A Hybrid Row-Column OLTP Database Architecture for Operational Reporting

Operational reporting differs from informational reporting in that its scope is on day-to-day operations and thus requires data on the detail of individual transactions. It is often not desirable to maintain data on such detailed level in the data warehouse, due to both exploding size of the warehouse and the update frequency required for operational reports. Using an ODS as the source for operational reporting exhibits a similar information latency.

[1]  Setrag Khoshafian,et al.  A decomposition storage model , 1985, SIGMOD Conference.

[2]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[3]  F. E..  A Relational Model of Data Large Shared Data Banks , 2000 .

[4]  Daniel J. Abadi,et al.  Integrating compression and execution in column-oriented database systems , 2006, SIGMOD Conference.

[5]  Peter C. Lockemann,et al.  Advances in Database Technology — EDBT 2000 , 2000, Lecture Notes in Computer Science.

[6]  Wolfgang Lehner,et al.  Data mining with the SAP NetWeaver BI accelerator , 2006, VLDB.

[7]  Daniel J. Abadi,et al.  Query execution in column-oriented database systems , 2008 .

[8]  Wilson C. Hsieh,et al.  Bigtable: A Distributed Storage System for Structured Data , 2006, TOCS.

[9]  Ralph Kimball,et al.  The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data , 2004 .

[10]  Peter Boncz,et al.  UvA-DARE ( Digital Academic Repository ) Monet ; a next-Generation DBMS Kernel For Query-Intensive Applications , 2007 .

[11]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[12]  Shamkant B. Navathe,et al.  Proceedings of the 1985 ACM SIGMOD International Conference on Management of Data, Austin, Texas, USA, May 28-31, 1985 , 1985 .

[13]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[14]  Nihar R. Mahapatra,et al.  The processor-memory bottleneck: problems and solutions , 1999, CROS.

[15]  Willem Jonker,et al.  Databases in Telecommunications , 1999, Lecture Notes in Computer Science.

[16]  Timos K. Sellis,et al.  State-space optimization of ETL workflows , 2005, IEEE Transactions on Knowledge and Data Engineering.

[17]  Jovanka Adzic,et al.  Data Warehouse Population Platform , 2001, DMDW.

[18]  R MahapatraNihar,et al.  The processor-memory bottleneck , 1999 .

[19]  Ken Barker,et al.  A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse , 1999, CIKM '99.

[20]  Jeffrey F. Naughton,et al.  Materialized View Selection for Multi-Cube Data Models , 2000, EDBT.

[21]  Stephen A. Brobst.  Enterprise Application Integration and Active Data Warehousing , 2002 .

[22]  Michael Stonebraker,et al.  C-Store: A Column-oriented DBMS , 2005, VLDB.