Physical Database Design and Performance
ثبت نشده
چکیده
Describe the physical database design process, its objectives, and its deliverables. Choose storage formats for attributes from a logical data model. Select an appropriate file organization by balancing various important design factors. Describe three important types of file organization. Describe the purpose of indexes and the important considerations in selecting attributes to be indexed. Translate a relational data model into efficient database structures, including
منابع مشابه
PERFORMANCE BASED OPTIMAL SEISMIC DESIGN OF RC SHEAR WALLS INCORPORATING SOIL–STRUCTURE INTERACTION USING CSS ALGORITHM
In this article optimal design of shear walls is performed under seismic loading. For practical aims, a database of special shear walls is created. Special shear walls are used for seismic design optimization employing the charged system search algorithm as an optimizer. Constraints consist of design and performance limitations. Nonlinear behavior of the shear wall is taken into account and per...
متن کاملPhysical design in databases
We live in an age where data has become one of the most important assets of companies. Data in itself is valuable, yet it has to be turned into information to become useful. This is where database management systems come into the picture. They allow for efficient processing of even terabytes of data, and thus provide the basis of knowledge extraction and information retrieval. A high-performanc...
متن کاملPerformance Evaluation of Dynamic Modulus Predictive Models for Asphalt Mixtures
Dynamic modulus characterizes the viscoelastic behavior of asphalt materials and is the most important input parameter for design and rehabilitation of flexible pavements using Mechanistic–Empirical Pavement Design Guide (MEPDG). Laboratory determination of dynamic modulus is very expensive and time consuming. To overcome this challenge, several predictive models were developed to determine dyn...
متن کاملPhysical Database Design for an Object-Oriented Database System
Object oriented database systems typically o er a variety of structuring capabilities to model complex objects This exibility together with type or class hierarchies and computed attributes methods poses a high demand on the physical design of object oriented databases Similar to traditional databases it is hardly ever true that the conceptual structure of the database is also a good that is e ...
متن کاملCompression Aware Physical Database Design
Modern RDBMSs support the ability to compress data using methods such as null suppression and dictionary encoding. Data compression offers the promise of significantly reducing storage requirements and improving I/O performance for decision support queries. However, compression can also slow down update and query performance due to the CPU costs of compression and decompression. In this paper, ...
متن کاملEngineering Security and Performance with Cipherbase
Cipherbase is a full-fledged relational database system that leverages novel customized hardware to store and process encrypted data. This paper outlines the space of physical design options for Cipherbase and shows how application developers can implement their data confidentiality requirements by specifying the encryption method for static data storage and the acceptable information leakage f...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2014