Data Blog by Andreas Buckenhofer

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...

read more
Data Modeling Zone, Düsseldorf 2017

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...

read more

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...

read more

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...

read more
SQL Tuning – filtered rows percentage method

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...

read more

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...

read more

Archives

Categories