Following the introductory blog post on the topic – ' Stream
your transactions into Big Data Systems', and blog posts on "Streaming Relational Transactions to HDFS and Hive", in this blog post I focus on the
architecture for streaming transactions into HBase.
As shown in the diagram below, integrating database with HBase is accomplished by
developing a custom handler using Oracle GoldenGate's Java API and HBase
A new article, now up on otn/java titled “JavaOne 2013 Review: Java Takes on the Internet of Things,” takes a look back at the lively happenings at JavaOne 2013, which reprised the 2012 JavaOne "Make the Future Java" theme. The articles quotes JavaOne keynoter Peter Utzschneider, Vice President, Java Product Management at Oracle, who said, "There is a lot going on in the industry, with massive shifts and innovation happening which pose huge challenges and opportunities for Java."
Occasionally questions will come up about the STAR schema and how it maps to fields in P6. The STAR schema is comprised of data pulled from the P6 EPPM Extended view schema, the rest of the data is calculated as part of the Transformation process. Calculated data includes - historical captures, hierarchies, burndown and work planning calculations, and many others.