|
Vol: 49(63) No: 3 / September 2004 A Physical Design Methodology for Databases Adi Cristina Mitea Department of Computer Science, Lucian Blaga University of Sibiu, Hermann Oberth Faculty, Zaharia Boiu street No. 2 – 4, 2400 Sibiu, Romania, phone: (040) – 269 &#, e-mail: adi_mitea@yahoo.com Ionel Jian Department of Computer Science, Politehnica University of Timisoara, Automatic Control and Computer Science Faculty, Vasile Parvan street No. 2, 1900 Timisoara, Romania, phone: (040) – 256 &#, e-mail: jian@cs.utt.ro Keywords: methodology, physical database design, relational databases, object-relational databases Abstract Database design is a part of a larger process called information system design. Database design is divided in three phases: conceptual design, logical design and physical design. Physical database design is the process of deciding physical storage structures for the data files and access methods used to make an efficient data access. If the physical structure of the database is not well suited, it will be very poor performance when the database will be in the operational phase. The methodology we present helps to elaborate this designing level with more accuracy and to obtain at the end a more suitable structure for the database. References REFERENCES [1] P. Rob, C. Coronel, Database Systems – design, implementation and management, Boyd & Fraser Publishing Company, 1995. [2] T. Connolly, C. Begg, A. Strachan, Database systems – A practical approach to design, implementation and management, Addison-Wesley Longman Limited, 1998. [3] *** - Oracle8i Concepts, Oracle Corporation, Release 8.1.5, 1999. [4] G. Wiederhold, Database Design, New York McGraw-Hill, 1983. [5] *** - Oracle9i Concepts, Oracle Corporation, Release 9.1.2., 2002. [6] *** - SQL Server 2000, Microsoft Corporation, 2000. [7] G. Lumpkin, H. Jakobsson, Ouery optimization in Oracle 9i, Oracle Corporation, 2002. [8] N. Thombre, C. Ozbutun, Key Data Warehousing Features in Oracle 9i, Oracle Corporation, 2001. [9] W.J. Labio, D. Quass, B. Adelberg, Physical Database Design for Data Warehouses, Proceedings of the International Conference on Data Engineering (ICDE), 1997. [10] L. Bellatreche, K. Karlapalem, M. Mohania, Some Issues in Design of Data Warehousing Systems, 2002. |