SAMSTAR: A semi-automated lexical method for generating star schemas from an entity-relationship diagram

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2007, Pages 9-16

  Song, Il Yeol ^a   Khare, Ritu ^a   Dai, Bing ^a  

^a DREXEL UNIVERSITY   (United States)

Author keywords

connection topology value; data warehouse design; dimensional design patterns; ER diagram; star schema; WordNet

Indexed keywords

DATA MINING; DATA WAREHOUSES; ONTOLOGY; SEMANTICS; STARS;

CONNECTION TOPOLOGY VALUE; DATA WAREHOUSE DESIGN; DESIGN PATTERNS; DIMENSIONAL DESIGN; DIMENSIONAL DESIGN PATTERN; ENTITY RELATIONSHIP DIAGRAMS; ER DIAGRAMS; STAR SCHEMA; WAREHOUSE DESIGN; WORDNET;

TOPOLOGY;

EID: 79959670172     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1317331.1317334     Document Type: Conference Paper

References (25)

1. Adamson, C., Venerable, M. (1998). Data Warehouse Design Solutions. Danvers, MA: John Wiley & Sons.
2. Boehnlein, M., Lbrich, A. (1999). Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. Proc. Of ACM 2nd International Workshop on Data Warehousing and OLAP (DOLAP), pp. 15-21, Kansas City, Missouri, USA.
3. Cabibbo, L., Torlone, R. (1998). A Logical Approach to Multidimensional Databases. Proc. of 6th International Conference on Extending Database Technology (EDBT): Advances in Database Technology, pp. 183-197, Valencia, Spain.
4. Chen, Y. T., Hsu, P.Y. (2005). An Efficient and Grain Preservation Mapping Algorithm: From ER Diagram to Multidimensional Model. 5th International Symposium and School on Advance Distributed Systems (ISSADS), pp. 331-346, Guadalajara, Mexico.
5. Christie, R. D. (2003). Statistical Methods of Classifying Major Event Days in Distribution Systems. IEEE Transaction On Power delivery, V.18, N04, pp. 1336-1341.
6. Cognitive Science Laboratory. WordNet 3.0 Reference Manual. Princeton University. http://wordnet.princeton.edu/doc.
7. Dullea, J., Song, I.-Y., and Lamprou, I. (2003). An analysis of structural validity in entity-relationship modeling. Data & Knowledge Engineering, V. 47, N.2, pp. 167-205.
8. Giorgini, P., Rizzi, S. & Garzetti, M. (2005). Goal-Oriented Requirement Analysis for Data Warehouse Design. Proc. of 8th ACM International Workshop on Data warehousing and OLAP (DOLAP), pp. 47-56, Bremen, Germany.
9. Golfarelli, M., Maio, D., and Rizzi, S. (1998). Conceptual Design of Data Warehouses from E/R Schemes. Proc. of the 31st Hawaii International Conference on System Sciences (HICSS-31), Vol. VII, Kona, Hawaii, pp. 334-343, Kohala Coast, Hawaii, USA.
10. Golfarelli, M., Maio, D., & Rizzi, S. (1998). Dimensional Fact Model: A Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems (IJCIS), V. 7, N. 2 & 3, pp. 215-247.
11. Golfarelli, M., Rizzi, S., Vrdoljak, B. (2001). Data warehouse design from XML sources. Proc. of ACM 4th International Workshop on Data Warehousing and OLAP (DOLAP), pp. 40-47, Atlanta, Georgia, USA.
12. Gregersen, H., Jensen, C. S. (1999). Temporal Entity-Relationship Models - A Survey. IEEE Transactions on Knowledge and Data Engineering (TKDE), V. 11, N. 3, pp. 464-497.
13. Guo, Y., Tang, S., Tong, Y., Yang, D. (2006). Triple-Driven Data Modeling Methodology in Data Warehousing: A Case Study. Proc. of ACM 9th International Workshop on Data Warehousing and OLAP (DOLAP), pp 59-66, Arlington, Virginia, USA.
14. Husemann, B., Lechtenborger, J., Vossen G. (2000). Conceptual Data Warehouse Design. Proc. of 2nd International Workshop on Design and Management of Data Warehouses (DMDW), pp. 6, Stockholm, Sweden.
15. Imhoff, C., Galemmo, N., Geiger, J.G. (2003). Mastering Data Warehouse Design. Indianapolis, IN: Wiley Publishing, Inc.
16. Jensen, M., R., Holmgren, T., Pedersen, T., B. (2004). Discovering Multidimensional Structure in Relational Data. Proc. of 6th International Conference on Data Warehousing and Knowledge Discovery (DaWaK), pp. 138-148, Zaragoza, Spain.
17. Jones, M. E., Song, I.-Y. (2005). Dimensional Modeling: Identification, Classification, and Applying Patterns. Proc. of 8th ACM International Workshop on Data warehousing and OLAP (DOLAP), pp. 29-38, Bremen, Germany.
18. th Ed.). Hoboken, NJ: John Wiley & Sons, Inc.
19. Kimball, R., Merz, R. (2000). The Data Webhouse Toolkit: Building the Web-enabled Data Warehouse. Danvers, MA: John Wiley & Sons, Inc.
20. List, B., Bruckner, R. M., Machaczek, K., Schiefer, J. (2002). A Comparison of Data Warehouse Development Methodologies: Case Study of the Process Warehouse. Proc. of 13th International Conference on Database and Expert Systems Applications (DEXA), pp. 203-215, Aix-en-Provence, France.
21. Moody, D. L., Kortink, M. A. R. (2000). From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. Proc. of the 2nd International Workshop on Design and Management of Data Warehouses( DMDW), Stockholm, Sweden.
22. Phipps, D., Davis, K. C. (2002).Automating Data Warehouse Conceptual Schema Design and Evaluation. Proc. of the 4th International Workshop on Design and Management of Data Warehouses (DMDW), Toronto, Canada.
23. Prat, N., Akoka, J., Comyn-Watttiau, I. (2006). A UML-based data warehouse design method. Decision Support Systems.V.42, N.3, pp. 1449-1473.
24. Sapia, C., Blaschka, M., Hofling, G. and B. Dinter. (1998). Extending the E/R Model for the Multidimensional Paradigm. Workshops on Data Warehousing and Data Mining (DWDM), pp. 105-116, Singapore.
25. Zhou, X., Zhang, X., and Hu, X., (2006). The Dragon Toolkit Developer Guide, Data Mining & Bioinformatics Lab, iSchool at Drexel University, http://www.dragontoolkit.org/tutorial.