Getting started with Oracle Autonomous Data Warehouse (ADW)
The blog post shows screenshots of how to set up an Oracle Autonomous Data Warehouse (ADW) service in the Oracle Cloud. The blog post contains three parts: Create the ADW service Client Credentials Client configuration (SQL Developer, sqlplus) Parameter list ...
TDWI Munich 2018 – AI, Data Catalog and Automation&Agility
TDWI 2018 took place in Munich from 25-JUN-2018 to 28-JUN-2018. This blog post summarizes some of my impressions on the topics AI, Data Catalog and Automation&Agility. Artificial Intelligence AI was the main topic in many sessions. I joined Barry Devlin's...
Metadata Management reloaded
Metadata is data about data. It used to be so simple with RDBMS and defined schemas. Variety creates the biggest challenge to derive metadata on-the-fly. What about schema-on-read? Schema-on-read applies the schema when data is retrieved.
Does Big Data stand in the way to derive value from data?
„Big Data is nothing but a marketing campaign that was designed to put money in the pockets of technology vendors and their collaborators.“ (Stephen Few: Big Data, Big Dupe – Analytics Press 2018, page 31)
Cloud computing: on-premise vs on-premises (grammar issues)
I'm not a native speaker and this post itself may contain grammar errors. So this post about grammar issues seems to be at the wrong place. But with all the hype around cloud, it looks like to me that many have adopted a wrong usage of a technical term: premise vs...
DOAG 2017 & Oracle 18c: DBIM (Oracle Database In-Memory) new features
The annual DOAG 2017 conference took place from 21-NOV-2017 to 24-NOV 2017 in Nuremberg. As usual, the conference was great with 450 sessions and a comprehensive community schedule. Core database topics are still covered by the majority of sessions but also with a...
Oracle Release Model, Release Updates (RU), Monthly Recommended Patches (MRPs) and discontinued Release Update Revisions (RUR)
Update Oct/2022 Monthly recommended patches will replace Release Update Revisions (RURs) from Nov/2022 onwards. Release Updates (RUs) will remain the same (see article below) MRP include recommended patches and all prior MRPs for the Release Update. Update Jan/2021...
Data Modeling Zone, Düsseldorf 2017
The European Data Modeling Zone (DMZ) took place in Düsseldorf from 23-OCT-2017 to 25-OCT-2017. The location was well-chosen as reachability by train or plane was good. Overall the conference was worthwhile for me as topics like Data Vault or Data Integration...
DBCA causes ORA-27104
DBCA fails with error message ORA-27104 on Linux [ 2017-09-03 20:49:06.137 CEST ] Creating and starting Oracle instance DBCA_PROGRESS : 1% DBCA_PROGRESS : 2% [ 2017-09-03 20:49:07.366 CEST ] ORA-27104: system-defined limits for shared memory was misconfigured...
DB2 is now Db2
Some IBM name changes for DB2: Old name New name DB2 for LUW Db2 DB2 for z/OS Db2 for z/OS DB2 for z/OS Db2 for i DB2 on Cloud Db2 Hosted dashDB for Transactions Db2 on Cloud dashDB for Analytics Db2 Warehouse on Cloud...
SQL Tuning – filtered rows percentage method
Kevin Meade is the author and publisher of his own book "Oracle SQL Performance Tuning and Optimization" - It's all about the cardinalities". His book is rather unknown as there is not much marketing about it. Unfortunately. Because it is a great book for the SQL...
Schemaless revolution and data migration burden
The need to model all data up front caused developers to tag relational databases with attributes like inflexible, dated, annoying, painful, etc. It is often not possible anymore to define a schema that remains stable for some revisions in case of continuous...