A Data Warehouse Approach for Business Intelligence
Ieee account.
- Change Username/Password
- Update Address
Purchase Details
- Payment Options
- Order History
- View Purchased Documents
Profile Information
- Communications Preferences
- Profession and Education
- Technical Interests
- US & Canada: +1 800 678 4333
- Worldwide: +1 732 981 0060
- Contact & Support
- About IEEE Xplore
- Accessibility
- Terms of Use
- Nondiscrimination Policy
- Privacy & Opting Out of Cookies
A not-for-profit organization, IEEE is the world's largest technical professional organization dedicated to advancing technology for the benefit of humanity. © Copyright 2024 IEEE - All rights reserved. Use of this web site signifies your agreement to the terms and conditions.
International Conference on Conceptual Modeling
ER 1998: Advances in Database Technologies pp 81–92 Cite as
Recent Advances and Research Problems in Data Warehousing
- Sunil Samtani 7 ,
- Mukesh Mohania 8 ,
- Vijay Kumar 7 &
- Yahiko Kambayashi 9
- Conference paper
564 Accesses
11 Citations
Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1552))
In the recent years, the database community has witnessed the emergence of a new technology, namely data warehousing . A data warehouse is a global repository that stores pre-processed queries on data which resides in multiple, possibly heterogeneous, operational or legacy sources. The information stored in the data warehouse can be easily and efficiently accessed for making effective decisions. The On-Line Analytical Processing (OLAP) tools access data from the data warehouse for complex data analysis, such as multidimensional data analysis, and decision support activities. Current research has lead to new developments in all aspects of data warehousing, however, there are still a number of problems that need to be solved for making data warehousing effective. In this paper, we discuss recent developments in data warehouse modelling, view maintenance, and parallel query processing. A number of technical issues for exploratory research are presented and possible solutions are discussed.
- Data Warehouse
- Integrity Constraint
- View Update
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in via an institution .
Buying options
- Available as PDF
- Read on any device
- Instant download
- Own it forever
- Compact, lightweight edition
- Dispatched in 3 to 5 business days
- Free shipping worldwide - see info
Tax calculation will be finalised at checkout
Purchases are for personal use only
Unable to display preview. Download preview PDF.
S. Chaudhuri and U. Dayal. An overview of data warehousing and OLAP technology. In ACM SIGMOD Record , volume 26, pages 65–74. 1997.
Article Google Scholar
A. Datta, B. Moon, and H. Thomas. A case for parallelism in data warehousing and olap. Technical report, Dept. of MIS, University of Arizona, Tucson, AZ URL: http://loochi.bpa.arizona.edu , 1998.
Google Scholar
A. Gupta and I. S. Mumick. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Warehousing , 18(2), 1995.
A. Gupta, I.S. Mumick, and K.A. Ross. Adapting materialized views after redefinitions. In Proc. ACM SIGMOD International Conference on Management of Data, San Jose, USA , 1995.
A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In Proc. ACM SIGMOD Int. Conf. on Management of Data , pages 157–166, 1993.
N. Huyn. Multiple view self-maintenance in data warehousing environ-ments. In To Appear in Proc. Intl Conf. on Very Large Databases , 1997.
R. Hull and G. Zhou. A framework for supporting data integration using the materialized and virtual approaches. In Proc. ACM SIGMOD Conf. On Management of Data , pages 481–492, 1996.
V. Küchenhoff. On the efficient computation of the difference between consecutive database states. In C. Delobel, M. Kifer, and Y. Masunaga, editors, Proc. Second Int. Conf. on Deductive Object-Oriented Databases , volume 566 of Lecture Notes in Computer Science, Springer-Verlag , pages 478–502. Springer-Verlag, 1991.
M. Mohania and G. Dong. Algorithms for adapting materialized views in data warehouses. In Proc. of International Symposium on Cooperative Database Systems for Advanced Applications, Kyoto, Japan , pages 62–69, 1996.
M. Mohania, S. Konomi, and Y. Kambayashi. Incremental maintenance of materialized views. In Proc. of 8 th International Conference on Database and Expert Systems Applications (DEXA ‘87) . Springer-Verlag, 1997.
M. Mohania. Avoiding re-computation: View adaptation in data warehouses. In Proc. of 13 th International Database Workshop, Hong Kong , pages 151–165, 1997.
Dallan Quass, Ashish Gupta, Inderpal Singh Mumick, and Jennifer Widom. Making views self-maintainable for data warehousing. In Proc. of International Conference on Parallel and Database Information Systems , 1996.
D. Quass and J. Widom. On-line warehouse view maintenance for batch updates. In Proc. ACM SIGMOD Int. Conf. on Management of Data , 1997.
K.A. Ross, D. Srivastava, and Sudarshan S. Materialized view mainte-nance and integrity constraint checking: Trading space for time. In Proc. ACM SIGMOD International Conference on Management of Data, Montreal, Canada , 1996.
Jennifer Widom. Research problems in data warehousing. In Proc. Fourth Intl. Conference on Information and Knowledge Management , 1995.
Download references
Author information
Authors and affiliations.
Dept. of Computer Science Telecommunications, University of Missouri-Kansas City, Kansas City, MO, 64110, USA
Sunil Samtani & Vijay Kumar
Advanced Computing Research Centre, School of Computer and Information Science, University of South Australia, Mawson Lakes, 5095, Australia
Mukesh Mohania
Department of Social Informatics, Kyoto University, Kyoto, 606-8501, Japan
Yahiko Kambayashi
You can also search for this author in PubMed Google Scholar
Editor information
Editors and affiliations.
Graduate School of Informatics, Dept. of Social Informatics, Kyoto University, 606-8501, Yoshida Sakyo Kyoto, Japan
Dept. of Computer Science Clear Water Bay, Hong Kong University of Science and Technology, Hong Kong, China
Dik Lun Lee
School of Applied Science, Nanyang Technological University, N4-2A-12, Nanyang Avenue, 639798, Singapore
Ee-Peng Lim
School of Computer and Information Science The Levels Campus, University of South Australia, Mawson Lakes, 5095, S.A., Australia
Mukesh Kumar Mohania
Faculty of Science, Dept. of Information Sciences, Ochanomizu University, 2-1-1 Otsuka, Bunkyo-ku, 112-8610, Tokyo, Japan
Yoshifumi Masunaga
Rights and permissions
Reprints and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper.
Samtani, S., Mohania, M., Kumar, V., Kambayashi, Y. (1999). Recent Advances and Research Problems in Data Warehousing. In: Kambayashi, Y., Lee, D.L., Lim, EP., Mohania, M.K., Masunaga, Y. (eds) Advances in Database Technologies. ER 1998. Lecture Notes in Computer Science, vol 1552. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-49121-7_7
Download citation
DOI : https://doi.org/10.1007/978-3-540-49121-7_7
Publisher Name : Springer, Berlin, Heidelberg
Print ISBN : 978-3-540-65690-6
Online ISBN : 978-3-540-49121-7
eBook Packages : Springer Book Archive
Share this paper
Anyone you share the following link with will be able to read this content:
Sorry, a shareable link is not currently available for this article.
Provided by the Springer Nature SharedIt content-sharing initiative
- Publish with us
Policies and ethics
- Find a journal
- Track your research
IMAGES
VIDEO
COMMENTS
Abstract. A data warehouse is a r epository for all data which is collected by an organization in various operational systems; it can. be either physical or l ogical. It is a subject oriented ...
A data warehouse is attractive as the main repository of an organization’s historical data and is optimized for reporting and analysis. In this paper, we present a data warehouse the process of data warehouse architecture development and design. We highlight the different aspects to be considered in building a data warehouse. These range from data store characteristics to data modeling and ...
Data Systems Research (CIDR ’21), January 11–15, 2021, Online. data at low cost, but on the other hand, punted the problem of data quality and governance downstream. In this architecture, a small subset of data in the lake would later be ETLed to a downstream data warehouse (such as Teradata) for the most important decision
This paper discusses how a data lakehouse, a new architectural approach, achieves the same benefits of an RDBMS-OLAP and cloud data lake combined, while also providing additional advan-tages. We take today’s data warehousing and break it down into implementation-independent components, capabilities, and prac-tices.
Various issues and challenges in the field of data warehousing are presented in many studies during the recent years. In this paper, a comprehensive survey is presented to take a holistic view of the research trends in the fields of data warehousing. This paper presents a systematic division of work of researchers in the fields of data warehousing.
In a cloud based data warehouse (DW), business users can access and query data from multiple sources and geographically distributed places. Business analysts and decision makers are counting on DWs especially for data analysis and reporting. Temporal and spatial data are two factors that affect seriously decision-making and marketing strategies and many applications require modelling and ...
Mainly, data warehouse review works address architecture modeling and its comparisons [36,37], the evolution of the DW concept , real-time data warehousing and ETL , etc. Compared with the data warehouse literature reviews, data lake papers are relatively fewer in number.
Bill Inmon, recognized by many as the father of the data warehouse, defines the term “data warehouse” as a subject-oriented, nonvolatile, integrated, time-variant collection of data in support of management’s decisions. 1 The data warehouse forms the foundation for business intelligence.
Current research has lead to new developments in all aspects of data warehousing, however, there are still a number of problems that need to be solved for making data warehousing effective. In this paper, we discuss recent developments in data warehouse modelling, view maintenance, and parallel query processing.
This paper follows from a wide discus- sion that took place in Dagstuhl, during the Perspectives Workshop "Data Warehousing at the Crossroads", and is aimed at outlining some open issues in ...