SearchPublisher and Institutes
You are here: Home :: Area NEM :: Computer science
Stefan Dorendorf, Klaus Küspert
Reorganization of Relational Databases
One advantage of relational database management systems is a relatively high level of independence of application programs from the physical organization of data. Users do not have to know much about the physical storage of data. But the used physical data structures have influence on the performance of the system. Especially the administrator has to know the internal data organization. He has to develop and to implement a physical storage concept for data that provides high performance of the system. During daily operation the physical storage structures may degenerate. Typical disorganizations are scattered free space or the problem that thresholds built in the database management system (e.g. the max. number of extents per table) will be reached soon. Disorganizations waste space and decrease the performance of the database system. The administrator has to determine the degree of disorganization and has to reorganize data on demand.
This paper gives an overview on database reorganization and provides also a description of different reorganization methods. We discuss this problem in context with current results of research in this special field like problems in using databases like very large databases and high availability of databases.
it – Information Technology (vormals it+ti), Oldenbourg Wissenschaftsverlag
Print ISSN: 1611-2776
Volume: 42, 03/2000
Pages: 18