Encyclopedia of Database Systems

2009 Edition

Active and Real-Time Data Warehousing

Reference work entry
DOI: https://doi.org/10.1007/978-0-387-39940-9_8



Active Data Warehousing is the technical ability to capture transactions when they change, and integrate them into the warehouse, along with maintaining batch or scheduled cycle refreshes. An active data warehouse offers the possibility of automating routine tasks and decisions. The active data warehouse exports decisions automatically to the On-Line Transaction Processing (OLTP) systems.

Real-time Data Warehousing describes a system that reflects the state of the warehouse in real time. If a query is run against the real-time data warehouse to understand a particular facet about the business or entity described by the warehouse, the answer reflects the state of that entity at the time the query was run. Most data warehouses have data that are highly latent – or reflects the business at a point in the past. A real-time data warehouse has low latency data and provides current (or real-time) data.

Simply put, a real-time data warehouse can...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Kimball R. and Strethlo K. Why decision support fails and how to fit it. ACM SIGMOD Rec., 24(3):91–97, 1995.CrossRefGoogle Scholar
  2. 2.
    Golfarelli M., Maio D., and Rizzi S. Conceptual design of data warehouses from E/R schemes. In Proc. 31st Annual Hawaii Int. Conf. on System Sciences, Vol. VII. 1998, pp. 334–343.Google Scholar
  3. 3.
    Lehner W. Modeling large scale OLAP scenarios. In Advances in Database Technology, Proc. 6th Int. Conf. on Extending Database Technology, 1998, pp. 153–167.Google Scholar
  4. 4.
    Li C. and Wang X.S. A data model for supporting on-line analytical processing. In Proc. Int. Conf. on Information and Knowledge Management, 1996, pp. 81–88.Google Scholar
  5. 5.
    Pedersen T.B. and Jensen C.S. Multidimensional data modeling for complex data. In Proc. 15th Int. Conf. on Data Engineering, 1999, pp. 336–345.Google Scholar
  6. 6.
    Vassiliadis P. Modeling multidimensional databases, cubes and cube operations. In Proc. 10th Int. Conf. on Scientific and Statistical Database Management, 1998, 53–62.Google Scholar
  7. 7.
    Chaudhuri S. and Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Rec., 26(1):65–74, 1997.CrossRefGoogle Scholar
  8. 8.
    Thalhammer T., Schrefl M., and Mohania M. Active data warehouses: complementing OLAP with analysis rules. Data Knowl. Eng., 39(3):241–269, 2001.zbMATHCrossRefGoogle Scholar
  9. 9.
    ACT-NET Consortium. The active database management system manifesto: a rulebase of ADBMS featueres. ACM SIGMOD Rec., 25(3), 1996.Google Scholar
  10. 10.
    Simon E. and Dittrich A. Promises and realities of active database systems. In Proc. 21th Int. Conf. on Very Large Data Bases, 1995, pp. 642–653.Google Scholar
  11. 11.
    Brobst S. Active data warehousing: a new breed of decision support. In Proc. 13th Int. Workshop on Data and Expert System Applications, 2002, pp. 769–772.Google Scholar
  12. 12.
    Borbst S. and Rarey J. The five stages of an active data warehouse evolution. Teradata Mag., 38–44, 2001.Google Scholar
  13. 13.
    IBM DB2 Data Warehouse Edition. http://www-306.ibm.com/software/data/db2/dwe/.
  14. 14.
    Rittman M. Implementing Real-Time Data Warehousing Using Oracle 10g. Dbazine.com. http://www.dbazine.com/datawarehouse/dw-articles/rittman5.
  15. 15.
    Kimball R. and Caserta J. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley, 2004.Google Scholar
  16. 16.
    Linthicum R.S. Enterprise Application Integration. Addison-Wesley, 1999.Google Scholar
  17. 17.
    Improving SOA with Goldengate TDM Technology. GoldenGate White Paper, October 2007.Google Scholar
  18. 18.
    Langseth J. Real-Time Data Warehousing: Challenges and Solutions. DSSResources.COM, 2004.Google Scholar
  19. 19.
    Paton N.W. and Diaz O. Active Database Systems. ACM Comput. Surv., 1(31),1999.Google Scholar

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  1. 1.IBM India Research LabNew DelhiIndia
  2. 2.University of LinzLinzAustria
  3. 3.University of South AustraliaAdelaideAustralia