Žiga Vaupot's Blog

Oracle Analytics, March 2022 Update is available! … and as usual is bringing some new exiting features. I will focus on some really nice one, three to be exact, which I was waiting for quite a some time and which will definitely improve developer and end user experience: new content management tool conditional formatting in Performance Tile visualisations Dashboard Filter Bar Content Management Personally, I am missing some more content management tools in Oracle Analytics. In this, March 2022 Update, this is certainly improving. Under the Console  users have now an option to use  Content  management tools.  Content management allows user quickly search through all objects (not just catalog) in the system. It allows searching by owner as well. Of course, more details are always available to inspect: If use is Administrator, she can transfer ownership of an object from one user to another. Example being, an employee leaves company.  This functionality in general is not new. It was avail

  Oracle Data Lakehouse Series highlights some of the examples of using elements of Oracle Data Lakehouse and presents the tools that are available as part of Oracle Cloud Infrastructure. The first blog, Using OCI Object Storage based Raw Data in Oracle Analytics , of the Series talks about how to use Object Storage for “a file cabinet” for the retail transactions CSV files. These files are then “registered” with Oracle autonomous database and used in Oracle Analytics analyses. Any new files added to that “file cabinet” are immediately included in any analysis. Of course, there are several ways to perform the following exercise, but in this 2nd example I’m discussing similar approach to load and use the data, however there are two add-ins in the process. Firstly, we will use Oracle Analytics Data Flows to prepare data for machine learning exercise and secondly we will use Oracle Machine Learning AutoML feature to build a prediction model which will be registered with and used in Oracl

What is Object Storage? Let’s start this blog with a definition of Object Storage. Object Storage is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability. Object Storage can store an unlimited amount of unstructured data of any content type, including analytic data Object Storage can also be used as a cold storage layer for the data warehouse by storing data that is used infrequently and then joining it seamlessly with the most recent data by using hybrid tables in Oracle Autonomous Data Warehouse. More on object storage can be found here . It seems that Object Storage can be considered as a key elements of Oracle Data Lakehouse architecture. In this blog post we are looking at setting up an Object Storage bucket with several data files and using those data for analysis in Oracle Analytics. One might argue some better and more reasonable approaches, but we are focusing on particular elements in the first place and we are not looki