Open Access
Providing OLAP to User-Analysts: An IT Mandate
C.T. Salley,E. F. Codd +1 more
TLDR
This paper discusses the coexistence of so-called transaction databases with decision support systems and the argument that the physical design required for acceptable performance of each is incompatible and that therefore, data should be stored redundantly in multiple enterprise databases.Abstract:
Overview Recently, there has been a great deal of discussion in the trade press and elsewhere regarding the coexistence of so-called transaction databases with decision support systems. These discussions usually revolve around the argument that the physical design required for acceptable performance of each is incompatible and that therefore, data should be stored redundantly in multiple enterprise databases: one for transaction processing, and the other for decision support type activities. Also, these same arguments usually confuse physical schema with logical and conceptual schema.read more
Citations
More filters
Journal ArticleDOI
The 8 requirements of real-time stream processing
TL;DR: Eight requirements that a system software should meet to excel at a variety of real-time stream processing applications are outlined to provide high-level guidance to information technologists so that they will know what to look for when evaluation alternative stream processing solutions.
Journal ArticleDOI
Management Support with Structured and Unstructured Data-An Integrated Business Intelligence Framework
Henning Baars,Hans-George Kemper +1 more
TL;DR: Three types of approaches for tackling the respective challenges are distinguished and the approaches are mapped to a three layer BI framework and discussed regarding challenges and business potential.
Patent
Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
TL;DR: In this paper, an improved method of and apparatus for joining and aggregating data elements integrated within a relational database management system (RDBMS) using a non-relational multi-dimensional data structure (MDD) is presented.
Proceedings ArticleDOI
Multidimensional data modeling for complex data
TL;DR: The paper presents nine requirements to multidimensional data models, each of which is exemplified by a real world, clinical case study, and defines an extended multiddimensional data model, and an associated algebra, which address all nine requirements.
Patent
Method, system, and program for use of metadata to create multidimensional cubes in a relational database
TL;DR: In this article, a method, system, and program for query processing is described, and a data structure stored in the computer-readable medium includes data for use by the program.