Research 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 - Issue 2 |
| Published: November 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
@article{ 10.5120/13984-1990,
author = { Revathy. S,Saravana Balaji. B,N. K. Karthikeyan },
title = { From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions },
journal = { International Journal of Computer Applications },
year = { 2013 },
volume = { 81 },
number = { 2 },
pages = { 15-18 },
doi = { 10.5120/13984-1990 },
publisher = { Foundation of Computer Science (FCS), NY, USA }
}
%0 Journal Article
%D 2013
%A Revathy. S
%A Saravana Balaji. B
%A N. K. Karthikeyan
%T From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions%T
%J International Journal of Computer Applications
%V 81
%N 2
%P 15-18
%R 10.5120/13984-1990
%I Foundation of Computer Science (FCS), NY, USA
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