A physical database model

214 leaves ; 30 cm. Includes bibliographical references. University of Otago department: Information Science. "December 2004".A good database design brings total attention to data. Data have been recognized as a valuable resource, resulting in an increased use of database systems. A wide variety of models and techniques are available to aid in system development at the analysis and logical stage. Once the system is defined at the logical stage, many other decisions have to be made to define the construction, operation and maintenance of the database system at the physical stage. Database design whether physical or logical is the process of determining the organization of a database. The concept of logical and conceptual modelling has been widely researched. However, few researchers seem to have considered physical modelling explicitly. Physical modelling is the conversion of a logical model to a physical model that will be suitable for a specific system with its own hardware configuration (Batini, Ceri et al. 1990). The objective of this thesis is to propose a physical database modelling technique that will demonstrate a join between logical and physical design to improve the performance of a database system using physical tuning techniques. It will annotate an entity model with physical detail that will provide a framework for building a physical model. To substantiate the relevance of the physical database model, the author looks at the physical storage structures in a database system and other physical database models that have been previously developed. This thesis will use a moderately realistic database system case study. The case study is used as an example for interpreting possible physical problem areas in a "real" database system. The aim will be to model and optimise the physical design of the discussed case study.UnpublishedAmbler, S. W. (2002). Agile Data, Agile Modelling. 2003. Batini, Ceri, et al. (1990). Entity Modelling, Publishing Company Inc. Batory, D. S. (1985). "Modelling the Storage Architectures of Commercial Database Systems." ACM Transactions on Database Systems 10(4): 463-528. Beynon-Davies, P. (1992). "Using an entity model to drive physical database design." Information and Software Technology 34(12/1992): 805-813. Beynon-Davies, P. (1996). Database Systems, Macmillan, USA Campbell, D. (1992). "Entity-Relationship Modelling: One Style Suits All?" DATABASE.23(3):12-18 Chan and Lochovsky (1980). Entity-Relationship Approach: The use of ER concept in knowledge representation. Edited by P. P. Chen. Chanchani, N. Understanding Clustering. Developer EIB,www.ejbsamples.com Last accessed date 14/08/2004. Connoly, T. and C. Begg (2002). Database Systems- A practical approach to design, implementation and Management, Addison-Wesley. Corey, M. J. and Abbey (1997). ORACLE data warehousing - A practical guide to successful data warehouse analysis, build, roll-out, Osborne McGraw-Hill. Coronel, R. Database Systems - Design, Implementation & Management, Thomson Learning. Date, C. J. (1995). An Introduction to Database Systems, 2nd Edition, Addison Wesley Publishing Company. D'Orazio, R. and G. Happel (1996). Practical Data Modelling for Database Design- The IT Series, John Wiley & Sons. Feldman, P. and D. Miller (1986). "Entity Model Clustering: Structuring A Data Model By Abstraction." The Computer Journal 29(4).Pages 348-360 Cane and Sarson (1978) Structured System Analysis: Tools and Techniques. Prentice Hall Gillenson, M. L. (1990). " Physical Design Equivalences in Database Conversion." Communications of the ACM 33(8).Pages 120-131 Kaminski, D. M. (1985). "Query Processing Optimisation Strategies: Possible vs. Optimal Solutions." ACM Transactions on Database Systems Volume 85 pg 449- 456. Knuth, D. E. (1973). The Art of Computer Programming - Sorting and Searching, Addison Wesley. McFadden, F. R. and J. A. Hoffer (1991). Modern Database Management, The Benjamin/Cummings Publishing Company Inc. Naiburg and Maksimchuk (2001) referenced from Agile Modeling. 2003. O'Neil, P. (1994). Database- Design, Principles And Programming, Morgan Kaufmann. O'Neil, P. and E. O'Neil (1994). Database Principles, Programming and Performance, Morgan Kaufmann Publishers. Powell, J. D. and D. P. Tiliman(1979) "Automating the development of a conceptual schema." ACM Transactions on Database Systems pg 98-105 Robinson, K. A. (1979). "An entity/event data modelling method." The Computer Journal 22(3) pg 270-271. Roti, S. (1996). Indexing and Access Mechanism. DBMS pg 65-68. Severance, D. G. and A. G. Merten (1986). "Performance Evaluation of File Organizations through Modeling." ACM Transactions on Database Systems pg 543-545 Silberschatz(1999). "Database Systems and Concepts" Fifth Edition Spiegler, I. and D. Widder (1993). "Physical Database Design: A Decision Support Model." DATABASE pg 5-11. Stanger, N. (2001). BDL Electronics.Case study for paper INFO 321 (Database Systems), Department of Information Science, University of Otago Teorey, T. J. and J. P. Fry (1982). Design of Database Structures, New Jersey, Prentice Hall. Tewari, R. (1990). "Expert Design Tools for Physical Database Design." ACM Transactions on Database Systems pg 538-549. Tufte, E. (1997). Visual Explanations, Images & Quantities, Evidence & Narrative, Graphics Press. Tufte, E. R. (1998). Envisioning Information, Graphics Press. Wiederhold (1993). "Physical Database Design (DDMS)." ACM Transactions on Database Systems pg 657-659. Willits, J. (1992). Database Design & Construction - an open learning course for students and information managers, Library Association Publishing, London