Database Modeling and Design

Database Modeling and Design

Volumn , Issue , 2011, Pages

  Teorey, Toby J ^a   Lightstone, Sam S ^b   Nadeau, Tom ^c   Jagadish, H V ^a  

^a UNIVERSITY OF MICHIGAN   (United States)

^b IBM CANADA LTD   (Canada)

^c Ubiquiti Inc   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85013761687     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/C2009-0-62960-3     Document Type: Book

References (120)

1. Ambler S., Sadalage P. Refactoring Databases: Evolutionary Database Design 2006, Addison-Wesley, Boston.
2. Armstrong W. Dependency Structures of Data Base Relationships. IFIP Congress 1974, 580-583.
3. Atkinson M., Bancilhon F., DeWitt D., Dittrich K., Maier D., Zdonik S. The Object-Oriented Database System Manifesto 1989, 223-240.
4. 2 1992, 223-240. Kyoto, Japan. Also appears in, Morgan Kaufmann, San Francisco. F. Bancilhon, C. Delobel, P. Kanellakis (Eds.).
5. Bachman C. Data Structure Diagrams. Database 1969, 1:4-10.
6. Bachman C. The Evolution of Storage Structures. Communications of the ACM 1972, 15:628-634.
7. Bachman C. The Role Concept in Data Models 1977, October 6, 464-476. IEEE.
8. Bagui S. Database Design Using Entity-Relationship Diagrams 2003, Tayler and Francis (Auerbach), London.
9. Planning and Designing the Data Warehouse 1997, Prentice-Hall, Upper Saddle River, NJ. R. Barquin, H. Edelstein (Eds.).
10. Batini C., Lenzerini M., Navathe S. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys 1986, December, 18:323-364.
11. Batini C., Ceri S., Navathe S. Conceptual Database Design: An Entity-Relationship Approach 1992, Benjamin/Cummings, Menlo Park, CA.
12. Beeri C., Bernstein P., Goodman N. A Sophisticated Introduction to Database Normalization Theory 1978, 113-124. IEEE.
13. Bernstein P. Synthesizing 3NF Tables from Functional Dependencies. ACM Transactions on Database Systems 1976, 1:272-298.
14. Briand H., Habrias H., Hue J., Simon Y. Expert System for Translating E-R Diagram into Databases 1985, 199-206. IEEE Computer Society Press.
15. On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages 1984, Springer-Verlag, New York. M. Brodie, J. Mylopoulos, J. Schmidt (Eds.).
16. Bruce T. Designing Quality Databases with IDEF1X Information Models 1992, Dorset House, New York.
17. Bulger B., Greenspan J., Wall D. MySQL/PHP Database Applications 2004, Wiley, Somerset, NJ. 2nd ed.
18. Cardenas A. Analysis and Performance of Inverted Database Structures. Communications of the ACM 1975, May, 18:253-264.
19. Cataldo J. Care and Feeding of the Data Warehouse. Database Programming and Design 1997, December, 10:36-42.
20. The Object Data Management Standard: ODMG 3.0 2000, Morgan Kaufmann, San Francisco. R.G.G. Cattell, D.K. Barry, M. Berler, J. Eastman, D. Jordan, C. Russell (Eds.).
21. Chaudhuri S., Dayal U. An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 1997, March, 26:65-74.
22. Chen P. The Entity-Relationship Model-Toward a Unified View of Data. ACM Transactions on Database Systems 1976, March, 1:9-36.
23. Churcher C. Beginning Database Design: From Novice to Professional 2009, Springer-Verlag, New York.
24. Cobb R., Fry J., Teorey T. The database designer's workbench. Information Sciences 1984, February, 32:33-45.
25. Codd E. A Relational Model for Large Shared Data Banks. Communications of the ACM 1970, June, 13:377-387.
26. Codd E. Recent Investigations into Relational Data Base Systems 1974, North-Holland, Amsterdam.
27. Codd E. Extending the Database Relational Model to Capture More Meaning. ACM Transactions on Database Systems 1979, December, 397-434.
28. Codd E. The Relational Model for Database Management, Version 2 1990, Addison-Wesley, Boston.
29. Computer Associates AllFusion ERwin Data Modeler Retrieved from. http://www3.ca.com/Solutions/Product.asp?ID=260.
30. Database Answers Modeling tools Retrieved from. http://www.databaseanswers.com/modelling_tools.htm.
31. Date C. An Introduction to Database Systems 2003, Vol. 1. Addison-Wesley, Boston. 8th ed.
32. Directory of Data Modeling Resources Retrieved from. http://www.infogoal.com/dmc/dmcdmd.htm.
33. Dittrich K., Gotthard W., Lockemann P. Complex Entities for Engineering Applications 1986, North-Holland, Amsterdam.
34. Dutka A., Hanson H. Fundamentals of Data Normalization 1989, Addison-Wesley, Boston.
35. Elmasri R., Navathe S. Fundamentals of Database Systems 2010, Addison-Wesley, Boston. 6th ed.
36. Fagin R. Multivalued Dependencies and a New Normal Form for Relational Databases. ACM Transactions on Database Systems 1977, 2:262-278.
37. Faloutsos C., Matias Y., Silberschatz A. Modeling skewed distributions using multifractal and the "80-20 law." 1996, 307-317.
38. Feldman P., Miller D. Entity Model Clustering: Structuring a Data Model by Abstraction. Computer Journal 1986, August, 29:348-360.
39. Gennick J. Oracle SQL*Plus: The Definitive Guide 1999, O'Reilly, Cambridge, MA.
40. Gennick J. SQL Pocket Guide 2004, O'Reilly, Cambridge, MA.
41. Goldberg A., Robson D. Smalltalk-80: The Language and Its Implementation 1983, Addison-Wesley, Boston.
42. Gray P., Watson H. Decision Support in the Data Warehouse 1998, Prentice-Hall, Upper Saddle River, NJ.
43. Halpin T., Morgan T. Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design 2008, Morgan Kaufmann, San Francisco. 2nd ed.
44. Han J., Kamber M. Data Mining: Concepts and Techniques 2001, Morgan Kaufmann, San Francisco.
45. Harinarayan V., Rajaraman A., Ullman J. Implementing Data Cubes Efficiently. Proceedings of the 1996 ACM-SIGMOD Conference 1996, 205-216.
46. Harriman A., Hodgetts P., Leo M. Emergent Database Design: Liberating Database Development with Agile Practices 2004, Salt Lake City, 2004. Retrieved from. http://www.agiledevelopmentconference.com/files/XR2-2.pdf.
47. Harrington J. Relational Database Design Clearly Explained 2002, Morgan Kaufmann, San Francisco. 2nd ed.
48. Hawryszkiewycz I. Database Analysis and Design 1984, SRA, Chicago.
49. Hernandez M., Getz K. Database Design for Mere Mortals: A Hands-On Guide for Relational Databases 2003, Addison-Wesley, Boston. 2nd ed.
50. Hoberman S. Data Modeling Made Simple: A Practical Guide for Business and IT Professionals 2009, Technics-Publications, Bradley Beach, NJ. 2nd ed.
51. Hull R., King R. Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Computing Surveys 1987, September, 19:201-260.
52. IBM Rational Software Retrieved from, Retrieved from. http://www.idef.com.
53. Jajodia S., Ng P. Translation of Entity-Relationship Diagrams into Relational Structures. Journal of Systems and Software 1984, 4:123-133.
54. Jensen C., Snodgrass R. Semantics of Time-Varying Information. Information Systems 1996, 21:311-352.
55. Kent W. A Simple Guide to Five Normal Forms in Relational Database Theory. Communications of the ACM 1983, February, 26:120-125.
56. Kimball R., Caserta J. The Data Warehouse ETL Toolkit 2004, Wiley, Somerset, NJ. 2nd ed.
57. Kimball R., Ross M. The Data Warehouse Lifecycle Toolkit 2002, Wiley, Somerset, NJ. 2nd ed.
58. Kimball R., Ross M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling 2002, Wiley, Somerset, NJ. 2nd ed.
59. Kirkerud B. Object-Oriented Programming with Simula 1989, Addison-Wesley (International Computer Science Series), Boston.
60. Kotidis Y., Roussopoulos N. DynaMat: A Dynamic View Management System for Data Warehouses 1999, 371-382.
61. Lightstone S., Teorey T., Nadeau T. Physical Database Design 2007, Morgan Kaufmann Publishers, San Francisco, CA.
62. Maier D. Theory of Relational Databases 1983, Computer Science Press, Rockville, MD.
63. Makridakis S., Wheelwright C., Hyndman R. Forecasting Methods and Applications 1998, Wiley, Somerset, NJ. 3rd ed.
64. Mannino M. Database Design, Application Development, and Administration 2008, ediyu, New York. 4th ed.
65. Martin J. Strategic Data-Planning Methodologies 1982, Prentice-Hall, Upper Saddle River, NJ.
66. Martin J. Managing the Data-Base Environment 1983, Prentice-Hall, Upper Saddle River, NJ.
67. McGee W. A Contribution to the Study of Data Equivalence. Data Base Management 1974, 123-148. North-Holland, Amsterdam. J.W. Klimbie, K.L. Koffeman (Eds.).
68. McLeod D., King R. Applying a Semantic Database Model 1979, 193-210. North-Holland, Amsterdam.
69. Melton J., Simon A. Understanding the New SQL: A Complete Guide 1993, Morgan Kaufmann, San Francisco.
70. Mitchell T. Machine Learning 1997, WCB/McGraw-Hill, Boston.
71. Muller R. Database Design for Smarties: Using UML for Data Modeling 1999, Morgan Kaufmann Pub, San Francisco.
72. Mullins C. DB2 Developer's Guide 2004, Sams Publishing, Upper Saddle River, NJ. 5th ed.
73. Naiburg E., Maksimchuk R. UML for Database Design 2001, Addison-Wesley, Boston.
74. Nadeau T., Teorey T. Achieving Scalability in OLAP Materialized View Selection 2002, 28-34.
75. Nadeau T., Teorey T. A Pareto Model for OLAP View Size Estimation. Information Systems Frontiers 2003, 5:137-147. New York: Kluwer Academic Publishers.
76. Neilson P. Microsoft SQL Server Bible 2003, Wiley, Somerset, NJ.
77. Nijssen G., Halpin T. Conceptual Schema and Relational Database Design: A Fact Oriented Approach 1989, Prentice-Hall, Upper Saddle River, NJ.
78. Objects by Design: UML modeling tools Retrieved from. http://www.objectsbydesign.com/tools/umltools_byCompany.html.
79. Peckham J., Maryanski F. Semantic Data Models. ACM Computing Surveys 1988, September, 20:153-190.
80. Powell G. Beginning Database Design 2005, Wiley, Somerset, NJ.
81. Quatrani T. Visual Modeling with Rational Rose 2002 and UML 2003, Addison-Wesley, Boston. 3rd ed.
82. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, Boston. 3rd ed.
83. Rumbaugh J., Jacobson I., Booch G. The Unified Modeling Language User Guide 2004, Addison-Wesley, Boston. 2nd ed.
84. Rumbaugh J., Jacobson I., Booch G. The Unified Modeling Language Reference Manual 2005, Addison-Wesley, Boston. 2nd ed.
85. Sakai H. Entity-Relationship Approach to Logical Database Design. Entity-Relationship Approach to Software Engineering 1983, 155-187. Elsevier, North-Holland, Amsterdam. C.G. Davis, S. Jajodia, P.A. Ng, R.T. Yeh (Eds.).
86. Scamell R., Umanath N. Data Modeling and Database Design 2007, Cengage Learning, Florence, KY.
87. Scheuermann P., Scheffner G., Weber H. Abstraction Capabilities and Invariant Properties Modeling within the Entity-Relationship Approach. Entity-Relationship Approach to Systems Analysis and Design 1980, 121-140. Elsevier, North-Holland, Amsterdam. P. Chen (Ed.).
88. Senko M., et al. Data Structures and Accessing in Data-base Systems. IBM Systems Journal 1973, 12:30-93.
89. Silberschatz A., Korth H., Sudarshan S. Database System Concepts 2010, McGraw-Hill, Boston. 6th ed.
90. Silverston L. The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises 2001, Wiley, Somerset, NJ.
91. Simon A. Strategic Database Technology: Management for the Year 2000 1995, Morgan Kaufmann, San Francisco.
92. Simsion G. Data Modeling Theory and Practice 2007, Technics Publicatons, Bradley Beach, NJ.
93. Simsion G., Witt G. Data Modeling Essentials: Analysis, Design, and Innovation 2004, Coriolis, Scottsdale, AZ. 3rd ed.
94. Smith H. Database Design: Composing Fully Normalized Tables from a Rigorous Dependency Diagram. Communications of the ACM 1985, August, 28:826-838.
95. Smith J., Smith D. Database Abstractions: Aggregation and Generalization. ACM Transactions on Database Systems 1977, June, 2:105-133.
96. Snodgrass R. Developing Time-Oriented Database Applications in SQL 2000, Morgan Kaufmann, San Francisco.
97. Stephens R., Plew R. Database Design 2000, Sams, Upper Saddle River, NJ.
98. Stephens R. Beginning Database Design Solutions 2008, Wrox, Somerset, NJ.
99. Sybase PowerDesigner Retrieved from. http://www.sybase.com/products/developmentintegration/powerdesigner.
100. Teichroew D., Hershey E. PSL/PSA: A Computer Aided Technique for Structured Documentation and Analysis of Information Processing Systems. IEEE Transactions on Software Engineering 1977, SE-3:41-48.
101. Teorey T., Fry J. Design of Database Structures 1982, Prentice-Hall, Upper Saddle River, NJ.
102. Teorey T., Yang D., Fry J. A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model. ACM Computing Surveys 1986, June, 18:197-222.
103. Teorey T., Wei G., Bolton D., Koenig J. ER Model Clustering as an Aid for User Communication and Documentation in Database Design. Communications of the ACM 1989, August, 32:975-987.
104. Thomsen E. OLAP Solutions 2002, Wiley, Somerset, NJ. 2nd ed.
105. Tsichritzis D., Lochovsky F. Data Models 1982, Prentice-Hall, San Francisco.
106. Ubiquiti Inc Retrieved from. http://www.ubiquiti.com/.
107. UML Overview Developer.com Retrieved from. http://www.developer.com/design/article.php/1553851.
108. University of Waikato Weka 3-Data Mining with Open Source Machine Learning Software in Java Retrieved from. http://www.cs.waikato.ac.nz/ml/weka.
109. Understanding Relational Database: Referential Integrity Retrieved from. http://www.miswebdesign.com/resources/articles/wrox-beginning-php-4-chapter-3-5.html.
110. van der Lans R. Introduction to SQL: Mastering the Relational Database Language 2000, Addison-Wesley, Boston. 3rd ed.
111. Widom J. Data Management for XML Retreived from. http://www-db.stanford.edu/~widom/xml-whitepaper.html.
112. Witten I., Frank E. Data Mining: Practical Machine Learning Tools and Techniques with Java Implementations 2000, Morgan Kaufmann, San Francisco.
113. Wong E., Katz R. Logical Design and Schema Conversion for Relational and DBTG Databases 1979, 311-322.
114. XML Database Products (Ronald Bourret, 2010) Retrieved from. http://www.rpbourret.com/xml/XMLDatabaseProds.htm.
115. XML Design Patterns Index Retrieved from. http://www.xmlpatterns.com/patterns.shtml.
116. XML Technology Retrieved from. http://www.w3.org/standards/xml/.
117. XML Tutorials Retrieved from. http://www.w3schools.com/xml/default.asp.
118. Principles of Database Design 1985, Prentice-Hall, Upper Saddle River, NJ. S. Yao (Ed.).
119. Zachmann J. A Framework for Information Systems Architecture. IBM Systems Journal 1987, 26:3. IBM Pub. G321-5298.
120. Zachman Institute for Framework Advancement Retrieved from. http://www.zifa.com.