| W. Lehner, H. Albrecht, and H. Wedekind. Multidimensional normal forms. In Proceedings of the 10th Statistical and Scientific Database Management Conference, Capri, Italy., 1998. |
....required every pair of elements of a given category to have ancestors in the same set of categories, a restriction referred to as homogeneity. For example, in a homogeneous dimension we cannot have some cities that rollup to provinces and some to states. A number of researchers and practitioners [11, 8, 13, 6] have dropped this restriction over the past few years, yielding heterogeneous dimensions, which are needed to represent more naturally and cleanly many practical situations. Moreover, heterogeneous dimensions permit more e#cient storage of data by having fewer categories. A smaller number of ....
....must rewrite a cube view as another query that refers to pre computed cube views. The process of finding such rewritings is known in the OLAP world as aggregate navigation [9] The notion of summarizability was introduced to study aggregate navigation in statistical objects and OLAP dimensions [12, 11, 13, 6]. As originally stated, summarizability refers to whether a simple aggregate query (usually called summarization or consolidation) correctly computes a single category cube view from another precomputed singlecategory cube view, in a particular database instance. In previous work [6] we extended ....
[Article contains additional citation context not shown here]
W. Lehner, H. Albrecht, and H. Wedekind. Multidimensional normal forms. In Proceedings of the 10th Statistical and Scientific Database Management Conference, Capri, Italy., 1998.
....the schema of the MD database determines what types of queries the user can ask. Thus, the design of the schema in such an environment is a very important task. This has been recognized by the research community as several publications in the field of multidimensional schema design show (e.g. 7] [12]) Nevertheless, a complete methodology for designing and maintaining an MDIS must also take schema evolution into account which has so far received almost no attention. This paper provides a framework to formally approach the evolution issue for MDIS and shows how this formal frame 1 An ....
W. Lehner, Multidimensional Normal Forms, Proceedings of SSDBM'98, Capri, Italy
....aspect of multidimensional data is the separation of factual and dimensional data. While dimensions represent descriptive and relatively static data, facts depict eventbased data, represented as points in spaces defined by dimensions. A number of multidimensional models for OLAP [CT97] HMV99a] LAW98] JLS99] have recently incorporated dimensions as first class entities in query and update languages. In the logical layer, a dimension is composed of a schema and an instance. The dimension schema includes a directed acyclic graph (DAG) of levels, called hierarchy schema, where levels may have ....
....then Gamma l b l a = d Gamma l b l a . Definition 4 (Partitioned Instances) A dimension instance is partitioned when all its rollup relations are single valued (partial functions) The partitioning property appears as an inherent constraint in the the dimension models of [CT97] HMV99a] LAW98] and [JLS99] It requires that each member in the base level reach, through Gamma l l base , not more that one member in each level l. In this sense, each levels represent partitioned classifications of the base members. In the sequel we assume that all dimension instances are partitioned. ....
[Article contains additional citation context not shown here]
W. Lehner, H. Albrecht, and H. Wedekind. Multidimensional normal forms. In Proceedings of the 10th SSDBM Conference, Capri, Italy., 1998.
....While this work certainly is a step in the right direction, a lot of work has still to be done in this area. Until now, no formal definition of the semantics has been given for the different graphical notations. Another important area of work are guidelines for proper multidimensional modeling. [25] takes a first step in this direction by defining multidimensional normal forms which can be used to provide the modeler with guidelines for a good schema design. Furthermore, the main interest of conceptual models so far has been the static aspect of an OLAP system (schema design) Until now ....
W. Lehner, J. Albrecht, H. Wedekind, "Multidimensional Normal Forms",Proc. 10 th Int. Conference on Scientific and Statistical Data Management (SSDBM), Capri, Italy, 1998
No context found.
W. Lehner, H. Albrecht, and H. Wedekind. Multidimensional normal forms. In Proceedings of the 10th Statistical and Scientific Database Management Conference, Capri, Italy., 1998.
No context found.
W. Lehner, H. Albrecht, and H. Wedekind. Multidimensional normal forms. In Proceedings of the 10th Statistical and Scientific Database Management Conference, Capri, Italy., 1998.
No context found.
W. Lehner, H. Albrecht, and H. Wedekind. Multidimensional normal forms. In Proceedings of the 10th Statistical and Scientific Database Management Conference, Capri, Italy., 1998.
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC