Research Issues in Data Warehousing

Wu, Ming-Chuan; Buchmann, Alejandro

doi:10.1007/978-3-642-60730-1_5

Cited by 52 publications

(24 citation statements)

References 35 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…They can create a star structure (star schema) (Chaudhuri and Dayal 1997;Wu and Buchmann 1997;Ballard et al 1998;McGuff 1998;Boehnlein and Ulbrich-vom Ende 1999), various forms of snowflakes (snowflake schema) (Chaudhuri and Dayal 1997;Ballard et al 1998;Boehnlein and Ulbrich-vom Ende 1999) and constellations (constellation schema) (Abdelhédi and Zurfluh 2013). The issue of choosing an appropriate structure is solved in the paper Levene and Louizou (2003).…”

Section: Doi: 1017221/108/2014-agriceconmentioning

confidence: 99%

Evaluation of the state of the Business Intelligence among small Czech farms

2015

View full text Add to dashboard Cite

Business Intelligence (BI) can assist in agricultural enterprises to strengthen their production potential and technical effi ciency due to its eff ective support to the managerial, analytical, planning, and decision-making activities of managers and specialists. However, the state of the BI in the Czech Republic is not still completely understood. In this context, this paper aims at the evaluation of the current state of the art of the BI among small Czech farms. Th e focus of the re search was put on the evaluation of both the state of the BI, and the relevant business information systems and software for agriculture. Th ere was a survey among 135 agricultural entrepreneurs from various regions in the Czech Republic. Th e survey results are presented by the descriptive statistics and frequency tables. Th ere is an examination of the relationship between the agricultural enterprise structure and the use of the BI. Dependencies among the examined characteristics were sought by the means of the analysis of qualitative variables. With 95% probability, it could be claimed that the type of production, the size of farmed land, the number of employees and the level of fi nancial subsidies have no signifi cant impact on using the BI, the expert and analytical systems in agricultural enterprises.

show abstract

Section: Doi: 1017221/108/2014-agriceconmentioning

confidence: 99%

Evaluation of the state of the Business Intelligence among small Czech farms

2015

View full text Add to dashboard Cite

show abstract

“…Data warehousing has become a well-established field but numerous definitions of it exist in the literature [8,10,23,42,47,48]. Possibly the most classical definition [17] is a ''subject-oriented, integrated, timevarying, non-volatile collection of data that is used primarily in organizational decision making.''…”

Section: Mining the Data Warehousementioning

confidence: 99%

“…Possibly the most classical definition [17] is a ''subject-oriented, integrated, timevarying, non-volatile collection of data that is used primarily in organizational decision making.'' From a user's perspective, a data warehouse should be a collection of cleaned, integrated, summarized data that is available for on-line analytical queries and decision making [48].…”

Section: Mining the Data Warehousementioning

confidence: 99%

An experimental investigation of the impact of aggregation on the performance of data mining with logistic regression

Fadlalla

2005

Information & Management

View full text Add to dashboard Cite

“…While transactional (OLTP, online transaction processing) DBMS like bank applications usually use simple query patterns to retrieve a very small part of a database (usually one record) by a primary key access, data processing in data warehousing (OLAP, online analytical processing) involves complex queries that usually access a large portion of the database [CD97,WB97,GBL+96].…”

Section: Data Warehousing Applicationsmentioning

confidence: 99%

MISTRAL: Processing Relational Queries using a Multidimensional Access Technique

Markl

2000

Ausgezeichnete Informatikdissertationen 1999

View full text Add to dashboard Cite

PrefaceClassical one dimensional B-trees have been the standard access method of all commercial database systems for many years. This dissertation is a very promising effort to introduce universal B-trees (UB-trees), the multidimensional variant of Btrees, as a basic access method into the core of fundamental DB-technology. The universal relevance of UB-trees is a consequence of the fact, that every relation can be considered as a set of points in multidimensional space. UB-trees organize this space for efficient processing of the data, resulting for many types of queries in orders of magnitude improvement over classical methods.The thesis lays the theoretical foundations of UB-tress, predicts their performance by analytical models and validates these models by experiments using large real world databases and real life applications and queries from the field of datawarehousing. The need to sort data and intermediate results frequently is an annoying drawback of today' s query processing methods. In combination with the Tetris algorithm UBtrees allow to avoid sorting in most cases, leading to dramatic improvements of response time, storage requirement and overall query processing time.Adding a new access method requires to consider all aspects of database systems:-architecture of subsystems -query optimization -query processing -multiuser operation and synchronization -bulk loading -storage requirement -parallelism, etc.Since UB-trees rely on classical B-trees for their implementation, all of these issues can be solved in a satisfactory way and can be dealt with elegantly.The performance experiments reported in this thesis were carried out with an implementation of UB-trees as a middleware layer on top of SQL. Additional performance improvements can be gained by integrating the UB-tree technology in the kernel of database systems.This thesis is a cornerstone of the MISTRAL project. MISTRAL has the goal to introduce UB-trees as a new access method into database systems with the fascinating vision, to extend fundamental database technology in an essential way. MISTRAL is financially supported by SAP, Teijin, NEC, Hitachi, the European Commission, Project MDA, TAS, Gfk and Microsoft. Abstract:A multidimensional access method offering significant performance increases by intelligently partitioning the query space is applied to relational database management systems (RDBMS). We introduce a formal model for multidimensional partitioned relations and discuss several typical query patterns. The model identifies the significance of multidimensional range queries and sort operations. The discussion of current access methods gives rise to the need for a multidimensional partitioning of relations. A detailed analysis of space partitioning focussing especially on Z-ordering illustrates the principle benefits of multidimensional indexes. After describing the UB-Tree and its standard algorithms for insertion, deletion, point queries, and range queries, we introduce the spiral algorithm for nearest neighbor queries with UB-Tree...

show abstract

Research Issues in Data Warehousing

Cited by 52 publications

References 35 publications

Evaluation of the state of the Business Intelligence among small Czech farms

Evaluation of the state of the Business Intelligence among small Czech farms

An experimental investigation of the impact of aggregation on the performance of data mining with logistic regression

MISTRAL: Processing Relational Queries using a Multidimensional Access Technique

Contact Info

Product

Resources

About