Distribution Design of Logical Database Schemas
- 1 July 1983
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Software Engineering
- Vol. SE-9 (4) , 487-504
- https://doi.org/10.1109/tse.1983.234957
Abstract
The optimal distribution of a database schema over a number of sites in a distributed network is considered. The database is modeled in terms of objects (relations or record sets) and links (predefined joins or CODASYL sets). The design is driven by user-supplied information about data distribution. The inputs required by the optimization model are: 1) cardinality and size information about objects and links, 2) a set of candidate horizontal partitions of relations into fragments and the allocations of the fragments, and 3) the specification of all important transactions, their frequencies, and their sites of origin.Keywords
This publication has 20 references indexed in Scilit:
- Query processing in a system for distributed databases (SDD-1)ACM Transactions on Database Systems, 1981
- Transformation of data traversals and operations in application programs to account for semantic changes of databasesACM Transactions on Database Systems, 1981
- Database Location in Computer NetworksJournal of the ACM, 1980
- The Logical Record Access Approach to Database DesignACM Computing Surveys, 1980
- Schema analysis for database restructuringACM Transactions on Database Systems, 1980
- Optimal program and data locations in computer networksCommunications of the ACM, 1977
- An integer programming formulation of computer data base design problemsInformation Sciences, 1976
- The entity-relationship model—toward a unified view of dataACM Transactions on Database Systems, 1976
- Optimal allocation of resources in distributed information networksACM Transactions on Database Systems, 1976
- The use of cluster analysis in physical data base designPublished by Association for Computing Machinery (ACM) ,1975