ER2MD:An Algorithm of the Transformation from ER Model to Multidimensional Model
DOI:
CSTR:
Author:
Affiliation:

Clc Number:

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    Multidimensional modeling is one of the chief techniques in conceptual design of data warehouse. If ER models of traditional databases can be directly transformed into multidimensional models, it would efficiently shorten the life circle of data warehouse design. Based on the traditional databases, an algorithm of the transformation from ER models to multidimensional models is presented. Those ER models under some conditions can be transformed, and the resulting multidimensional models conform to the standard of the generalized multidimensional normal form, ensuring the validity of analytical computations on multidimensional databases. Furthermore, the resulting multidimensional models favor an efficient physical database design.

    Reference
    Related
    Cited by
Get Citation

TANG Jiuyang, YANG Qiang, SHA Jichang, DENG Su, LU Changhui. ER2MD:An Algorithm of the Transformation from ER Model to Multidimensional Model[J]. Journal of National University of Defense Technology,2003,25(1):31-34.

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:July 02,2002
  • Revised:
  • Adopted:
  • Online: June 14,2013
  • Published:
Article QR Code