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...
Read MoreAuthor: abuData
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,...
Read MoreIs my Oracle database healthy?
It’s a common question if a database is in a healthy state. DBA_REGISTRY shows the status of components loaded into the database. Mike Dietrich mentions in his blog two additional checks that should be performed regularly...
Read More
Data Vault 2.0, Hashing and DB2 LUW
Hashing is part of Data Vault 2.0. Hash Keys are used to provide a surrogate for business keys...
Read MoreAmazon Redshift (hosted DWH) – SQL for simplicity
NoSQL databases like Amazon Dynamo got quite popular in the OLTP market. Their marketing credo is supposed to be simplicity compared to RDBMS. The absence of a declarative programming language like SQL means that a lot of work...
Read More