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...
Book Overview “Constructing Generic Data Warehouses with Metadata-driven Generic Operators” by Bin Jiang
Data Warehouse automation is currently a hot topic. There exist a lot of repetitions during building a DWH in general. Defining patterns and automating that stuff is the main target by using code generators like BIGenius, AnalytiX DS, Quipu or a self-written...
Current trends in Data Management by BARC
Dr. Carsten Bange from Business Application Research Center (BARC) presented trends in the Big Data, Advanced Analytics, and Cloud market during Oracle Data Vision 2017 conference in Neuss. He focused on three areas:Data ManagementCloudExplorative...
Lambda Architecture, Master Dataset and Data Vault
The Lambda Architecture got known after Nathan Marz' and James Warren's book about Big Data. The authors describe a data processing architecture for batch and real-time data flows at the same time. Fault-tolerance and the balance of latency vs throughput are main...
SQL – Only the Strong Survive
There are tons of tech predictions at the end of every year. Eric Knorr lists "The incredible SQL comeback" in his 9 enterprise tech trends for 2017 and beyond. An old, mature programming language as the prevailing trend for 2017 and later?After years of NoSQL...
GOODS – How to post-hoc organize the Data Lake
Google describes in a recent paper „Goods: Organizing Google’s Datasets“ their approach for post-hoc metadata management. GOODS (GOOgle Dataset Search) is a system that crawls internal storage systems (e.g. GoogleFS, Bigtable, DBMSes) in order to collect, aggregate,...