DataBeat – week 48/2014
Reference to blogs, tweets, discussions, etc that caught my attention during the last week.Data ModelingPart 2 of the article about loading Data Vault 2.0 using SAS DI Studio. The referenced LinkedIn discussion also contains some feedback from D. Linstedt. A very...
Oracle Enterprise Manager Database Express 12c
EM 12c replaces Enterprise Manager Database Control from Oracle 12c onwards and serves basic Oracle database management and monitoring functionalities for a single database:ConfigurationStorageSecurityPerformanceIt's a lightweight tool and offers only a subset of the...
Commercial Hadoop distributions and their components
The following table shows commercial distributions and their Apache stack and some proprietary components. Hortonworks HDP 2.1 Cloudera CDH 5.0.1 MapR 4.0.0B Pivotal HD 2.0 IBM BigInsights 2.1.2 Hadoop/Yarn 2.4.0 2.3.0 2.3.0 2.2.0 2.2.0 Tez 0.4.0 Pig 0.12.1...
High-level overview of some Columnar Stores
Columnar Stores exist since a long time. There are well-known players like Vertica, Sybase IQ or Exasol. Recent trends like Cassandra and HBase or announcements from SAP, IBM, Microsoft and Oracle caused some hype for (in-memory) columnar stores. The term "columnar...
Beurer Half Marathon 2013
Beurer Half Marathon (+ Einstein-Marathon and some other distances) took place in Ulm on 29-Sep-2013. The weather was perfect. It was almost windless - just a bit cold during the waiting before start. Daimer TSS sponsored my participation and also organized food and...
Links to Oracle database white papers
Links to some Oracle database white papers: Best Practices For Implementing High Volume IoT workloads with Oracle Database 12c - April 2017 Manageability with Oracle Database 12c - June 2014 Upgrading to Oracle Database 12c - August 2013 Consolidation Best Practices:...
Google’s F1 database for AdWords
BigData - who does not think of Google who released white papers on Bigtable, Google File System (today: Colossus) and MapReduce. These papers contained lots of ideas that influenced the development of Apache Hadoop.On what kind of databases is...
OT: Beurer Half Marathon 2011
Beurer Half Marathon (+ Einstein-Marathon and other distances) took place in Ulm on 18-Sep-2011. The weather was nasty: rainy and windy - the only positive mention it was not hot. The event was again perfectly organized with one huge improvement compared to the last...
Real World Performance Day @Frankfurt
Real World Performance Day took place in Frankfurt on 25-AUG-2011. Real World Performance Day means three presenters - three roles - three screens. Tom Kyte acted as developer and showed the material available from his website ( http://asktom.oracle.com ). Andrew...
Oracle Fixed Object Statistics
Fixed objects are in-memory structures and variables inside the Oracle kernel. Fixed table names start with X$ and represent data via performance views like v$session. Performance views are used in applications (fixed tables should not be queried directly). Why to...
Oracle Dictionary Statistics
Statistics on Oracle-defined schemas like sys, ctxsys, dbsnmp, mdsys, etc are called dictionary statistics. Why to gather dictionary statistics Missing or wrong dictionary statistics can lead to performance issues from Oracle 10g onwards. For Oracle version 9i, Oracle...