The week's pick
Random Articles
Reseach Article
From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 81 - Number 2 |
| Year of Publication: 2013 |
| Authors: Revathy. S, Saravana Balaji. B, N. K. Karthikeyan |
10.5120/13984-1990
|
Revathy. S, Saravana Balaji. B, N. K. Karthikeyan . From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions. International Journal of Computer Applications. 81, 2 ( November 2013), 15-18. DOI=10.5120/13984-1990
Abstract
Data Warehouses usually work on history data. In most cases, the Data Warehouse is loaded with data from operational or transactional systems on a weekly or nightly basis. As today's decisions in the business world are becoming real-time, it is only natural that Data Warehouse, Business Intelligence, Decision Support and OLAP systems must quickly begin incorporating real-time data. When shifting from a traditional offline and time-consuming data warehousing system to a real-time system, two important considerations are speeding up the ETL and the OLAP process. This survey looks into the various challenges involved in building a real-time Data Warehouse and some of the solutions available to overcome them.
References
- Oracle Data Warehousing Guide – Oracle Documentation,docs. oracle. com/cd/B28359_01/server. 111/b28313. pdf by P Lane.
- The Data Warehouse Lifecycle Toolkit ,Ralph Kimball, Margy Ross ,Warren Thornthwaite ,Joy Mundy , Bob Becker , John Wiley & Sons; 2nd Edition.
- Dr. Kamal Kakish Dr. Theresa A. kraft , ETL Evolution for Real-Time Data Warehousing,2012, Proceedings of the Conference on Information Systems Applied Research ,New Orleans Louisiana, USA , ISSN:2167-1508 , v5 n2214.
- Mohamed A. Sharaf, Alexandros Labrinidis, Panos K. Chrysanthis , ETL Scheduling Continuous Queries in Data Stream Management Systems, ACM 978-1-60558-306-8/08/08.
- Langseth, J. , "Real-Time Data Warehousing: Challenges and Solutions", http://dssresources. com/papers/features/ langseth/langseth02082004. html
- Lucas Golab, Theodere Johnson , Vladislav Shkapenyuk Scalable, Scheduling of Updates in Streaming Data Warehouse, IEEE Transactions on knowledge and data engineering ,Vol. 24, N0. 6, JUNE 2012.
- Agrawal , D. , The Reality of Real-Time Business Intelligence, Proceedings of the 2nd International Workshop on Business Intelligence For the Real Time Enterprise (BIRTE 2008), Springer , LNBIP 27 , 75-88.
- Lukasz Golab and Theodore Johnson, Consistency in a Stream Warehouse, 5th Biennial Conference on Innovative Data Systems Research (CIDR '11) January 9-12, 2011, Asilomar, California, USA.
- Chaudhuri, S. , Dayal, U. , Narasayya, V. , (2011) An overview of Business Intelligence Technology, Communications of the ACM, 54(8), 88-98.
Index Terms
Keywords