Database Modeling and Design

Database Modeling and Design

Volumn , Issue , 2006, Pages

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

^a UNIVERSITY OF MICHIGAN   (United States)

^b IBM TORONTO LAB   (Canada)

^c Ubiquiti Inc   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85013897105     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-0-12-685352-0.X5000-9     Document Type: Book

References (109)

1. Ambler S. Agile Database Techniques: Effective Strategies for the Agile Software Developer 2003, Wiley.
2. Bachman C.W. Data Structure Diagrams. Database 1969, 1(2):4-10.
3. Bachman C.W. The Evolution of Storage Structures. Comm. ACM July 1972, 15(7):628-634.
4. Bachman C.W. The Role Concept in Data Models. Proc. 3rd Intl. Conf. on Very Large Data Bases Oct. 6, 1977, 464-476. IEEE, New York.
5. Planning and Designing the Data Warehouse 1997, Prentice-Hall, Upper Saddle River, NJ. R. Barquin, H. Edelstein (Eds.).
6. Batini C., Lenzerini M., Navathe S.B. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys Dec. 1986, 18(204):323-364.
7. Batini C., Ceri S., Navathe S. Conceptual Database Design: An Entity-Relationship Approach 1992, Benjamin/Cummings.
8. Beeri C., Fagin R., Howard J.H. A Complete Axiomization Functional and Multivalued Dependencies in Database Relations. Proc. 1977 ACM SIGMOD Int'l. Conf. on Management of Data 1977, 47-61.
9. Beeri C., Bernstein P., Goodman N. A Sophisticated Introduction to Database Normalization Theory. Proc. 4th Intl. Conf. on Very Large Data Bases Sept. 13-15, 1978, 113-124. IEEE, New York.
10. Bernstein P. Synthesizing 3NF Tables from Functional Dependencies. ACM Trans. Database Systems 1976, 1(4):272-298.
11. Briand H., Habrias H., Hue J., Simon Y. Expert System for Translating E-R Diagram into Databases. Proc. 4th Intl. Conf. on Entity-Relationship Approach 1985, 199-206. IEEE Computer Society Press.
12. On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming languages 1984, Springer-Verlag, New York. M.L. Brodie, J. Mylopoulos, J. Schmidt (Eds.).
13. Bruce T.A. Designing Quality Databases with IDEF1X Information Models 1992, Dorset House, New York.
14. Bulger B., Greenspan J., Wall D. MySQL/PHP Database Applications 2004, Wiley. 2nd ed.
15. Burleson D.K. Physical Database Design Using Oracle 2004, CRC Press.
16. Cardenas A.F. Analysis and Performance of Inverted Database Structures. Communications of the ACM May 1975, vol. 18(no. 5):253-264.
17. Cataldo J. Care and Feeding of the Data Warehouse. Database Prog. & Design Dec. 1997, 10(12):36-42.
18. Chaudhuri S., Dayal U. An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26 March 1997, (1):65-74.
19. Chen P.P. The Entity-Relationship Model-Towards a Unified View of Data. ACM Trans. Database Systems March 1976, 1(1):9-36.
20. Chen and Associates, Inc. ER Designer 1987, (user manual).
21. Cobb R.E., Fry J.P., Teorey T.J. The Database Designer's Workbench. Information Sciences Feb. 1984, 32(1):33-45.
22. Codd E.F. A Relational Model for Large Shared Data Banks. Comm. ACM June 1970, 13(6):377-387.
23. Codd E.F. Recent Investigations into Relational Data Base Systems. Proc. IFIP Congress 1974, North-Holland, Amsterdam.
24. Codd E.F. Extending the Database Relational Model to Capture More Meaning. ACM TODS Dec. 1979, 4(3):397-434.
25. Codd E.F. The Relational Model for Database Management, Version 2 1990, Addison-Wesley.
26. AllFusion ERwin Data Modeler 1990, Computer Associates. http://www3.ca.com/Solutions/Product.asp?ID=260.
27. Database Answers, Modeling tools http://www.databaseanswers.com/modelling_tools.htm.
28. Date C.J. An Introduction to Database Systems 1999, Vol. 1. Addison-Wesley. 7th ed.
29. Directory of Data Modeling Resources, . http://www.infogoal.com/dmc/dmcdmd.htm.
30. Dittrich K.R., Gotthard W., Lockemann P.C. Complex Entities for Engineering Applications. Proc. 5th ER Conf. 1986, North-Holland, Amsterdam.
31. Dutka A.F., Hanson H.H. Fundamentals of Data Normalization 1989, Addison-Wesley, Reading, MA.
32. Elmasri R., Navathe S.B. Fundamentals of Database Systems 2003, Addison-Wesley. 4th ed.
33. Fagin R. Multivalued Dependencies and a New Normal Form for Relational Databases. ACM Trans. Database Systems 1977, 2(3):262-278.
34. Fagin R. "Normal Forms and Relational Database Operators." Proc. 1979 ACM SIGMOD Conf. on Mgmt. of Data, pp. 153-160.
35. Faloutsos C., Matias Y., Silberschatz A. Modeling Skewed Distributions Using Multifractal and the '80-20 Law'. Proceedings of the 22nd VLDB Conference 1996, 307-317.
36. Feldman P., Miller D. Entity Model Clustering: Structuring a Data Model by Abstraction. Computer Journal Aug. 1986, 29(204):348-360.
37. Fowler M. Patterns of Enterprise Application Architecture 2002, Addison-Wesley.
38. *Plus: The Definitive Guide 1999, O'Reilly.
39. Gennick J. SQL Pocket Guide 2004, O'Reilly.
40. Gray P., Watson H.J. Decision Support in the Data Warehouse 1998, Prentice-Hall, Upper Saddle River, NJ.
41. Halpin T. Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design 2001, Morgan Kaufmann.
42. Hammer M., McLeod D. Database Description with SDM: A Semantic Database Model. ACM Trans. Database Systems Sept. 1982, 6(3):351-386.
43. Han J., Kamber M. Data Mining: Concepts and Techniques 2001, Morgan Kaufmann Publishers, San Francisco.
44. Harinarayan V., Rajaraman A., Ullman J.D. Implementing Data Cubes Efficienty. Proceedings of the 1996 ACM-SIGMOD Conference 1996, 205-216.
45. Harriman A., Hodgetts P., Leo M. Emergent Database Design: Liberating Database Development with Agile Practices. Agile Development Conference June 22-26, 2004, http://www.agiledevelopmentconference.com/files/XR22.pdf.
46. Hawryszkiewycz I. Database Analysis and Design 1984, SRA, Chicago.
47. Hernandez M.J., Getz K. Database Design for Mere Mortals: A Hands-On Guide for Relational Databases 2003, Addison-Wesley. 2nd ed.
48. Hull R., King R. Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Computing Surveys Sept. 1987, 19(3):201-260.
49. IBM Rational Software http://www.306.ibm.com/software/rational/.
50. IDEF1X http://www.idef.com.
51. Jajodia S., Ng P. Translation of Entity-Relationship Diagrams into Relational Structures. J. Systems and Software 1984, 4(2):123-133.
52. Jensen C.S., Snodgrass R.T. Semantics of Time-Varying Information. Information Systems 1996, 21(4):311-352.
53. Kent W. A Simple Guide to Five Normal Forms in Relational Database Theory. Comm. ACM Feb. 1983, 26(2):120-125.
54. Kent W. Fact-Based Data Analysis and Design. J. Systems and Software 1984, 4:99-121.
55. Kimball R., Caserta J. The Data Warehouse ETL Toolkit 2004, Wiley. 2nd ed.
56. Kimball R., Ross M. The Data Warehouse Lifecycle Toolkit 1998, Wiley. 2nd ed.
57. Kimball R., Ross M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling 2002, Wiley. 2nd ed.
58. Kotidis Y., Roussopoulos N. DynaMat: A Dynamic View Management System for Data Warehouses. Proceedings SIGMOD '99 1999, 371-382.
59. Maier D. Theory of Relational Databases 1983, Computer Science Press, Rockville, MD.
60. Makridakis S., Wheelwright C., Hyndman R.J. Forecasting Methods and Applications 1998, John Wiley & Sons. 3rd ed.
61. Martin J. Strategic Data-Planning Methodologies 1982, Prentice-Hall.
62. Martin J. Managing the Data-Base Environment 1983, Prentice-Hall.
63. McGee W. A Contribution to the Study of Data Equivalence. Data Base Management 1974, 123-148. North-Holland, Amsterdam. J.W. Klimbie, K.L. Koffman (Eds.).
64. McLeod D., King R. Applying a Semantic Database Model. Proc. 1st Intl. Conf. on the Entity-Relationship Approach to Systems Analysis and Design 1979, 193-210. North-Holland, Amsterdam.
65. Melton J., Simon A.R. Understanding the New SQL: A Complete Guide 1993, Morgan Kaufmann Publ.
66. Mitchell T.M. Machine Learning 1997, WCB/McGraw-Hill, Boston.
67. Muller R. Database Design for Smarties: Using UML for Data Modeling 1999, Morgan Kaufmann Pub.
68. Mullins C.S. DB2 Developer's Guide 2004, Sams Publishing. 5th ed.
69. Nadeau T.P., Teorey T.J. Achieving Scalability in OLAP Materialized View Selection. Proceedings of DOLAP '02 2002, 28-34.
70. Nadeau T.P., Teorey T.J. A Pareto Model for OLAP View Size Estimation. Information Systems Frontiers 2003, vol. 5:137-147. no. 2, Kluwer Academic Publishers.
71. Naiburg E.J., Maksimchuk R.A. UML for Database Design 2001, Addison-Wesley.
72. Neilson P. Microsoft SOL Server Bible 2003, Wiley.
73. Nijssen G.M., Halpin T.A. Conceptual Schema and Relational Database Design: A Fact Oriented Approach 1989, Prentice-Hall.
74. Objects by Design: UML modeling tools http://www.objectsbydesign.com/tools/umltools_byCompany.html.
75. Peckham J., Maryanski F. Semantic Data Models. ACM Computing Surveys Sept. 1988, 20(3):153-190.
76. Quatrani T. Visual Modeling with Rational Rose 2002 and UML 2003, Addison-Wesley. 3rd ed.
77. Ramakrishnan R., Gehrke J. Database Management Systems 2004, Chapter 20, McGraw Hill. 3rd ed.
78. Reiner D., Brown G., Friedell M., Kramlich D., Lehman J., McKee R., Rheingans P., Rosenthal A. A Database Designer's Workbench. Proc. 5th ER Conference 1986, 347-360. North-Holland, Amsterdam.
79. Rumbaugh J., Jacobson I., Booch G. The Unified Modeling Language User Guide 2004, Addison-Wesley. 2nd ed.
80. Rumbaugh J., Jacobson I., Booch G. The Unified Modeling Language Reference Manual 2005, Addison-Wesley. 2nd ed.
81. 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.).
82. Scheuermann P., Scheffner G., Weber H. Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach. Entity-Relationship Approach to Systems Analysis and Design 1980, 121-140. Elsevier, North-Holland, Amsterdam. P. Chen (Ed.).
83. Senko M., et al. Data Structures and Accessing in Database Systems. IBM Syst. J. 1973, 12(1):30-93.
84. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2002, McGraw-Hill. 4th ed.
85. Simon A.R. Strategic Database Technology: Management for the Year 2000 1995, Morgan Kaufmann, San Francisco.
86. Simsion G.C., Witt G.C. Data Modeling Essentials: Analysis, Design, and Innovation 2001, Coriolis. 2nd ed.
87. Smith H. Database Design: Composing Fully Normalized Tables from a Rigorous Dependency Diagram. Comm. ACM 1985, 28(8):826-838.
88. Smith J., Smith D. Database Abstractions: Aggregation and Generalization. ACM Trans. Database Systems June 1977, 2(2):105-133.
89. Snodgrass R.T. Developing Time-Oriented Database Applications in SQL 2000, Morgan Kaufmann Publishers.
90. Stephens R., Plew R. Database Design 2000, Sams.
91. Sybase Power Designer http://www.sybase.com/products/developmentintegration/powerdesigner.
92. Teichroew D., Hershey E.A. PSL/PSA: A Computer Aided Technique for Structured Documentation and Analysis of Information Processing Systems. IEEE Trans. Software Engr. 1977, SE-3(1):41-48.
93. Teorey T., Fry J. Design of Database Structures 1982, Prentice-Hall.
94. Teorey T.J., Wei G., Bolton D.L., Koenig J.A. ER Model Clustering as an Aid for User Communication and Documentation in Database Design. Comm. ACM Aug. 1989, 32(8):975-987.
95. Teorey T.J., Yang D., Fry J.P. A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model. ACM Computing Surveys June 1986, 18(2):197-222.
96. Thomsen E. OLAP Solutions 1997, Wiley.
97. Tsichritzis D., Lochovsky F. Data Models 1982, Prentice-Hall.
98. Ubiquiti Inc. Web site. http://www.ubiquiti.com.
99. UML Overview, from Developer.com, . http://www.developer.com/design/article.php/1553851.
100. http://www.miswebdesign.com/resources/articles/wroxbeginning.
101. The University of Waikato Weka 3-Data Mining with Open Source Machine Learning Software in Java 2000, http://www.cs.waikato.ac.nz/ml/weka.
102. van der Lans R. Introduction to SQL: Mastering the Relational Database Language 2000, Addison-Wesley. 3rd ed.
103. Widom J. Data Management for XML. http://www.db.stanford.eduwidom/xml.
104. Wilmot R. Foreign Keys Decrease Adaptability of Database Designs. Comm. ACM Dec. 1984, 27(12):1237-1243.
105. Witten I., Frank E. Data Mining: Practical Machine Learning Tools and Techniques with Java Implementations 2000, Morgan Kaufmann Publishers, San Francisco.
106. Wong E., Katz R. Logical Design and Schema Conversion for Relational and DBTG Databases. Proc. Intl Conf. on the Entity-Relationship Approach 1979, 311-322.
107. Principles of Database Design 1985, Prentice-Hall. S.B. Yao (Ed.).
108. Zachmann J.A. A Framework for Information Systems Architecture. IBM Systems Journal 1987, 26(3). IBM Pub. G321-5298.
109. Zachmann Institute for Framework Advancement http://www.zifa.com.