Title :
Structuring databases for analysis
Author :
Stamen, Jeffrey P.
Author_Institution :
IRI Software, Waltham, MA, USA
Abstract :
Databases for online analytical processing (also called end-user computing) are discussed. The differences between end-user computing, which uses the multidimensional data model, and transaction processing, which uses the relational model, are examined. The differences between the two models are described. The data manipulation language and analytic functions used by end-user computer are also examined.<>
Keywords :
data handling; database management systems; online operation; personal computing; transaction processing; data manipulation language; databases; end-user computing; multidimensional data model; online analytical processing; relational model; transaction processing; Aggregates; Business; Costs; Data analysis; Data models; Database systems; Industrial relations; Marketing and sales; Multidimensional systems; Relational databases;
Journal_Title :
Spectrum, IEEE
