References

Ambler, S. Agile Database Techniques: Effective Strategies for the Agile Software Developer, Wiley, 2003.

Bachman, C. W. “Data Structure Diagrams,” Database 1, 2 (1969), pp. 4–10.

Bachman, C. W. “The Evolution of Storage Structures,” Comm. ACM 15, 7 (July 1972), pp. 628–634.

Bachman, C. W. “The Role Concept in Data Models,” Proc. 3rd Intl. Conf. on Very Large Data Bases, Oct. 6, 1977, IEEE, New York, pp. 464–476.

Barquin, R., and Edelstein, H. (editors). Planning and Designing the Data Warehouse, Prentice-Hall, Upper Saddle River, NJ, 1997, Chapter 10 (OLAP).

Batini, C, Lenzerini, M., and Navathe, S. B. “A Comparative Analysis of Methodologies for Database Schema Integration,” ACM Computing Surveys 18, 204 (Dec. 1986), pp. 323–364

Batini, C, Ceri, S., and Navathe, S. Conceptual Database Design: An Entity-Relationship Approach, Benjamin/Cummings, 1992.

Beeri, C, Fagin, R., and Howard, J. H. “A Complete Axiomization Functional and Multivalued Dependencies in Database Relations,” Proc. 1977 ACM SIGMOD Int’l. Conf. on Management of Data, Toronto, 1977, pp. 47–61.

Beeri, C, Bernstein, R, and Goodman, N. “A Sophisticated Introduction to Database Normalization Theory,” Proc. 4th Intl. Conf. on Very Large Data Bases, Sept. 13–15, 1978, IEEE, New York, pp. 113–124.

Bernstein, P. “Synthesizing 3NF Tables from Functional Dependencies,” ACM Trans. Database Systems 1, 4(1976), pp. 272–298.

Briand, H., Habrias, H., Hue, J., and Simon, Y. “Expert System for Translating E-R Diagram into Databases,” Proc. 4th Intl. Conf. on Entity-Relationship Approach, IEEE Computer Society Press, 1985, pp. 199–206.

Brodie, M. L., Mylopoulos, J., and Schmidt, J. (editors). On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, Springer-Verlag, New York, 1984.

Bruce, T. A. Designing Quality Databases with IDEF1X Information Models, Dorset House, New York, 1992.

Bulger B., Greenspan, J., and Wall, D. MySQL/PHP Database Applications, 2nd ed., Wiley, 2004.

Burleson, D. K. Physical Database Design Using Oracle, CRC Press, 2004.

Cardenas, A. F. “Analysis and Performance of Inverted Database Structures,” Communications of the ACM, vol. 18, no. 5, pp. 253–264, May 1975.

Cataldo, J. “Care and Feeding of the Data Warehouse,” Database Prog. & Design 10, 12 (Dec. 1997), pp. 36–42.

Chaudhuri, S., and Dayal, U. “An Overview of Data Warehousing and OLAP Technology,” SIGMOD Record 26, 1 (March 1997), pp. 65–74.

Chen, P. P. “The Entity-Relationship Model—Toward a Unified View of Data,” ACM Trans. Database Systems 1, 1 (March 1976), pp. 9–36.

Chen and Associates, Inc. ER Designer (user manual), 1987.

Cobb, R. E., Fry, J. P., and Teorey, T. J. “The Database Designer’s Workbench,” Information Sciences 32, 1 (Feb. 1984), pp. 33–45.

Codd, E. F. “A Relational Model for Large Shared Data Banks,” Comm. ACM 13, 6 (June 1970), pp. 377–387.

Codd, E. F. “Recent Investigations into Relational Data Base Systems,” Proc. IFIP Congress, North-Holland, Amsterdam, 1974.

Codd, E. F. “Extending the Database Relational Model to Capture More Meaning,” ACM TODS 4, 4 (Dec. 1979), pp. 397–434.

Codd, E. F. The Relational Model for Database Management, Version 2, Addison-Wesley, 1990.

Computer Associates, AllFusion ERwin Data Modeler, http://www3.ca.com/Solutions/Product.asp?ID=260

Database Answers, Modeling tools, http://www.databaseanswers.com/modelling_tools.htm

Date, C. J. An Introduction to Database Systems, Vol. 1, 7th ed., Addison-Wesley, 1999.

Directory of Data Modeling Resources, http://www.infogoal.com/dmc/dmcdmd.htm

Dittrich, K. R., Gotthard, W., and Lockemann, R C. “Complex Entities for Engineering Applications,” Proc. 5th ER Conf, North-Holland, Amsterdam, 1986.

Dutka, A. F., and Hanson, H. H. Fundamentals of Data Normalization, Addison-Wesley, Reading, MA, 1989.

Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, 4th ed., Addison-Wesley, 2003.

Fagin, R. “Multivalued Dependencies and a New Normal Form for Relational Databases,” ACM Trans. Database Systems 2, 3 (1977), pp. 262–278.

Fagin, R. “Normal Forms and Relational Database Operators,” Proc. 1979 ACM SIGMOD Conf. on Mgmt. of Data, pp. 153–160.

Faloutsos, C., Matias, Y., and Silberschatz, A. “Modeling Skewed Distributions Using Multifractal and the ’80–20 Law’,” in Proceedings of the 22nd VLDB Conference, pp. 307–317, 1996.

Feldman, P., and Miller, D. “Entity Model Clustering: Structuring a Data Model by Abstraction,” Computer Journal 29, 204 (Aug. 1986), pp. 348–360.

Fowler, M. Patterns of Enterprise Application Architecture, Addison-Wesley, 2002.

Gennick, J. Oracle SQL*Plus: The Definitive Guide, O’Reilly, 1999.

Gennick, J. SQL Pocket Guide, O’Reilly, 2004.

Gray, P., and Watson, H. J. Decision Support in the Data Warehouse, Prentice-Hall, Upper Saddle River, NJ, 1998.

Halpin, T. Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design, Morgan Kaufmann, 2001.

Hammer, M., and McLeod, D. “Database Description with SDM: A Semantic Database Model,” ACM Trans. Database Systems 6, 3 (Sept. 1982), pp. 351–386.

Han, J., and Kamber, M., Data Mining: Concepts and Techniques, Morgan Kaufmann Publishers, San Francisco, 2001.

Harinarayan, V., Rajaraman, A., and Ullman, J. D., “Implementing Data Cubes Efficiently,” in Proceedings of the 1996 ACM-SIGMOD Conference, pp. 205–216, 1996.

Harriman, A., Hodgetts, P., and Leo, M. “Emergent Database Design: Liberating Database Development with Agile Practices,” Agile Development Conference, Salt Lake City, June 22–26, 2004. http://www.agiledevelopmentconference.com/files/XR2-2.pdf

Hawryszkiewycz, I. Database Analysis and Design, SRA, Chicago, 1984.

Hernandez, M. J. and Getz, K. Database Design for Mere Mortals: A Hands-On Guide for Relational Databases, 2nd ed., Addison-Wesley, 2003.

Hull, R., and King, R. “Semantic Database Modeling: Survey, Applications, and Research Issues,” ACM Computing Surveys 19, 3 (Sept. 1987), pp. 201–260.

IBM Rational Software, http://www-306.ibm.com/software/rational/IDEF1X, http://www.idef.com

Jajodia, S., and Ng, P. “Translation of Entity-Relationship Diagrams into Relational Structures,” J. Systems and Software 4, 2 (1984), pp. 123–133.

Jensen, C. S. and Snodgrass, R. T. “Semantics of Time-Varying Information,” Information Systems 21, 4 (1996), pp. 311–352.

Kent, W. “A Simple Guide to Five Normal Forms in Relational Database Theory,” Comm. ACM 26, 2 (Feb. 1983), pp. 120–125.

Kent, W. “Fact-Based Data Analysis and Design,” J. Systems and Software 4 (1984), pp. 99–121.

Kimball, R., and Caserta, J. The Data Warehouse ETL Toolkit, 2nd ed., Wiley, 2004.

Kimball, R., and Ross, M. The Data Warehouse Lifecycle Toolkit, 2nd ed., Wiley, 1998.

Kimball, R., and Ross, M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd ed., Wiley, 2002.

Kotidis, Y., and Roussopoulos, N. “DynaMat: A Dynamic View Management System for Data Warehouses,” in Proceedings SIGMOD ’99, pp. 371–382, 1999.

Maier, D. Theory of Relational Databases, Computer Science Press, Rockville, MD, 1983.

Makridakis, S., Wheelwright, C, and Hyndman, R. J. Forecasting Methods and Applications, 3rd ed., John Wiley & Sons, 1998.

Martin, J. Strategic Data-Planning Methodologies, Prentice-Hall, 1982.

Martin, J. Managing the Data-Base Environment, Prentice-Hall, 1983.

McGee, W. “A Contribution to the Study of Data Equivalence,” Data Base Management, J. W. Klimbie and K. L. Koffeman (eds.), North-Holland, Amsterdam, 1974, pp. 123–148.

McLeod, D., and King, R. “Applying a Semantic Database Model,” Proc. 1st Intl. Conf. on the Entity-Relationship Approach to Systems Analysis and Design, North-Holland, Amsterdam, 1979, pp. 193–210.

Melton, J., and Simon, A. R. Understanding The New SQL: A Complete Guide, Morgan Kaufmann Pub., 1993.

Mitchell, T. M. Machine Learning, WCB/McGraw-Hill, Boston, 1997.

Muller, R. Database Design for Smarties: Using UML for Data Modeling, Morgan Kaufmann Pub., 1999.

Mullins, C. S. DB2 Developer’s Guide, 5th ed., Sams Publishing, 2004.

Nadeau, T. P., and Teorey, T. J. “Achieving Scalability in OLAP Materialized View Selection,” In Proceedings of DOLAP ’02, pp 28–34, 2002.

Nadeau, T. P., and Teorey, T. J. “A Pareto Model for OLAP View Size Estimation,” Information Systems Frontiers, vol. 5, no. 2, pp. 137–147, Kluwer Academic Publishers, 2003.

Naiburg, E. J., and Maksimchuk, R. A. UML for Database Design, Addison-Wesley, 2001.

Neilson, P. Microsoft SQL Server Bible, Wiley, 2003.

Nijssen, G. M., and Halpin, T. A. Conceptual Schema and Relational Database Design: A Fact Oriented Approach, Prentice-Hall, 1989.

Objects by Design: UML modeling tools, http://www.objectsbydesign.com/tools/umltools_byCompany.html

Peckham, J., and Maryanski, R “Semantic Data Models,” ACM Computing Surveys 20, 3 (Sept. 1988), pp. 153–190.

Quatrani, T. Visual Modeling with Rational Rose 2002 and UML, 3rd ed., Addison-Wesley, 2003.

Ramakrishnan, R., and Gehrke, J. Database Management Systems, 3rd ed., McGraw Hill, 2004, Chapter 20.

Reiner, D., Brown, G., Friedell, M., Kramlich, D., Lehman, J., McKee, R., Rheingans, P., and Rosenthal, A. “A Database Designer’s Workbench,” Proc. 5th ER Conference, North-Holland, Amsterdam, 1986, pp. 347–360.

Rumbaugh, J., Jacobson, I., and Booch, G. The Unified Modeling Language User Guide, 2nd ed., Addison-Wesley, 2004.

Rumbaugh, J., Jacobson, I., and Booch, G. The Unified Modeling Language Reference Manual, 2nd ed., Addison-Wesley, 2005.

Sakai, H. “Entity-Relationship Approach to Logical Database Design,” Entity-Relationship Approach to Software Engineering, C. G. Davis, S. Jajodia, P.A. Ng, and R. T. Yeh (editors), Elsevier, North-Holland, Amsterdam, 1983, pp. 155–187.

Scheuermann, R, Scheffner, G., and Weber, H. “Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach,” Entity-Relationship Approach to Systems Analysis and Design, P. Chen (editor), Elsevier, North-Holland, Amsterdam, 1980, pp. 121–140.

Senko, M. et al. “Data Structures and Accessing in Database Systems,” IBM Syst. J. 12, 1 (1973), pp. 30–93.

Silberschatz, A., Korth, H. R, and Sudarshan, S. Database System Concepts 4th ed., McGraw-Hill, 2002.

Simon, A. R. Strategic Database Technology: Management for the Year 2000, Morgan Kaufmann, San Francisco, 1995.

Simsion, G. C, and Witt, G. C. Data Modeling Essentials: Analysis, Design, and Innovation, 2nd ed., Coriolis, 2001.

Smith, H. “Database Design: Composing Fully Normalized Tables from a Rigorous Dependency Diagram,” Comm. ACM 28, 8 (1985), pp. 826–838.

Smith, J., and Smith, D. “Database Abstractions: Aggregation and Generalization,” ACM Trans. Database Systems 2, 2 (June 1977), pp. 105–133.

Snodgrass, R. T. Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann Publishers, 2000.

Stephens, R., and Plew, R. Database Design, Sams, 2000.

Sybase PowerDesigner, http://www.sybase.com/products/developmentintegration/powerdesigner

Teichroew, D., and Hershey, E. A. “PSL/PSA: A Computer Aided Technique for Structured Documentation and Analysis of Information Processing Systems,” IEEE Trans. Software Engr. SE-3, 1 (1977), pp. 41–48.

Teorey, T., and Fry, J. Design of Database Structures, Prentice-Hall, 1982.

Teorey, T. J., Wei, G., Bolton, D. L., and Koenig, J. A. “ER Model Clustering as an Aid for User Communication and Documentation in Database Design,” Comm. ACM 32, 8 (Aug. 1989), pp. 975–987.

Teorey, T. J., Yang, D., and Fry, J. P. “A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model,” ACM Computing Surveys 18, 2 (June 1986), pp. 197–222.

Thomsen, E. OLAP Solutions, Wiley, 1997.

Tsichritzis, D., and Lochovsky, F. Data Models, Prentice-Hall, 1982.

Ubiquiti Inc. Web site: http://www.ubiquiti.com/

UML Overview, from Developer.com, http://www.developer.com/design/article.php/1553851

Understanding relational databases: referential integrity http://www.miswebdesign.com/resources/articles/wrox-beginning-php-4-chapter-3–5.html

The University of Waikato, Weka 3—Data Mining with Open Source Machine Learning Software in Java. http://www.cs.waikato.ac.nz/ml/weka.

van der Lans, R. Introduction to SQL: Mastering the Relational Database Language, 3rd ed., Addison-Wesley, 2000.

Widom, J. Data Management for XML. http://www-db.stanford.edu/~widom/xml-whitepaper.html

Wilmot, R. “Foreign Keys Decrease Adaptability of Database Designs,” Comm. ACM 27, 12 (Dec. 1984), pp. 1237–1243.

Witten, I., and Frank, E., Data Mining: Practical Machine Learning Tools and Techniques with Java Implementations, Morgan Kaufmann Publishers, San Francisco, 2000.

Wong, E., and Katz, R. “Logical Design and Schema Conversion for Relational and DBTG Databases,” Proc. Intl. Conf. on the Entity-Relationship Approach, 1979, pp. 311–322.

Yao, S. B. (editor). Principles of Database Design, Prentice-Hall, 1985.

Zachmann, J. A. “A Framework for Information Systems Architecture,” IBM Systems Journal 26, 3 (1987), IBM Pub. G321–5298.

Zachmann Institute for Framework Advancement, http://www.zifa.com.