Issue No. 04 - July (1983 vol. 9)
S. Ceri , Departimento di Elettronica, Politecnico di Milano
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.
partitioning, Database, database design, distributed database
S. Ceri, S. Navathe, G. Wiederhold, "Distribution Design of Logical Database Schemas", IEEE Transactions on Software Engineering, vol. 9, no. , pp. 487-504, July 1983, doi:10.1109/TSE.1983.234957