An overview of data warehousing and OLAP technology

@article{Chaudhuri1997AnOO,
  title={An overview of data warehousing and OLAP technology},
  author={Surajit Chaudhuri and Umeshwar Dayal},
  journal={SIGMOD Rec.},
  year={1997},
  volume={26},
  pages={65-74}
}
Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications. This paper provides an… 
An Overview of Data Warehousing and OLAP Technology
TLDR
An overview of data warehousing and OLAP technologies, with an emphasis on their new requirements, is provided, based on a tutorial presented at the VLDB Conference, 1996.
Data Warehousing and OLAP
TLDR
Several techniques used in data warehouse to accelerate the OLAP process speed are discussed and a dynamic view management system is used to discuss the techniques of dynamic view selection and view maintenance.
Using AutoMed for Data Warehousing
A data warehouse consists of a set of materialized views defined over a number of data source, collects copies of data from remote, distributed, autonomous and heterogeneous data sources into a
DATA WAREHOUSING, DATA MINING, OLAP AND OLTP TECHNOLOGIES ARE ESSENTIAL ELEMENTS TO SUPPORT DECISION-MAKING PROCESS IN INDUSTRIES
This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, applications and the architecture of Data Warehousing. The data warehouse supports
Curio: A Novel Solution for Efficient Storage and Indexing in Data Warehouses
Data warehousing and On-Line Analytical Processing (OLAP) are becoming critical components of decision support as advances in technology are improving the ability to manage and retrieve large volumes
Recent Advances and Research Problems in Data Warehousing
TLDR
This paper discusses recent developments in data warehouse modelling, view maintenance, and parallel query processing, and possible solutions for exploratory research are presented.
BUILDING OLAP TOOLS OVER LARGE DATABASES
During the last few years, On-Line Analytical Processing (OLAP) has emerged as a valuable tool for the analysis, navigation and reporting of hierarchically organized data from data warehouses. Still,
Innovative Approaches for efficiently Warehousing Complex Data from the Web
TLDR
This chapter presents three innovative researches recently introduced to extend the capabilities of decision support systems, namely the use of XML as a logical and physical model for complex data warehouses, associating data mining to OLAP to allow elaborated analysis tasks forcomplex data and schema evolution in complex data warehouse for personalized analyses.
A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases
TLDR
A model of a data cube and an algebra to support OLAP operations on this cube is proposed and the algebra provides a means to concisely express complex OLAP queries.
DATA WAREHOUSING APPLICATIONS: AN ANALYTICAL TOOL FOR DECISION SUPPORT SYSTEM
Data-driven decision support systems, such as data warehouses can serve the requirement of extraction of information from more than one subject area. Data warehouses standardize the data across the
...
1
2
3
4
5
...

References

SHOWING 1-10 OF 44 REFERENCES
Research problems in data warehousing
TLDR
This paper motivates the concept of a data warehouse, outlines a general data warehousing architecture, and proposes a number of technical issues arising from the architecture that are suitable topics for exploratory research.
Building the data warehouse
TLDR
This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking.
Research Issues in Data Warehousing
TLDR
The state of the art in data warehousing is summarized, architectural extensions are suggested and research problems in the areas of warehouse modeling and design, data cleansing and loading, data refreshing and purging, metadata management, extensions to relational operators, alternative implementations of traditional relational operators and special index structures are identified.
View maintenance in a warehousing environment
TLDR
This work introduces a new algorithm, ECA (for "Eager Compensating Algorithm"), that eliminates the anomalies of previous incremental view maintenance algorithms, but extra "compensating" queries are used to eliminate anomalies.
Why decision support fails and how to fix it
Because the truth is that relational database management systems aren’t very good at what they were supposed to do-help us get answers from our data-unless we ignore a good deal of relational dogma
Loading databases using dataflow parallelism
TLDR
This paper describes the optimizer's cost-based hierarchical optimization strategy in some detail and preliminary measurements indicate that this design will give excellent scaleups.
Improved query performance with variant indexes
TLDR
A new method whereby multi-dimensional group-by queries, reminiscent of OLAP/Datacube queries but with more flexibility, can be very efficiently performed is introduced.
Implementing data cubes efficiently
TLDR
This paper investigates the issue of which cells (views) to materialize when it is too expensive to materialized all views, and presents greedy algorithms that work off this lattice and determine a good set of views to materializing.
An Overview of Cost-based Optimization of Queries with Aggregates
TLDR
This paper overviews the line of research on histograms at the Univ. of Wisconsin and presents several results, which eventually point towards a class of histograms that are practical, close to optimal, and effective in estimating sizes of query results, frequency distributions of attribute values inquery results, and even costs of accesses using secondary indices.
On the Computation of Multidimensional Aggregates
TLDR
This paper presents fast algorithms for computing a collection of group bys using sort-based and hashbased grouping methods with several .optimizations, like combining common operations across multiple groupbys, caching, and using pre-computed group-by8 for computing other groupbys.
...
1
2
3
4
5
...