Lehr- und Forschungseinheit für Datenbanksysteme Datenbanksysteme Database Systems

Diplomarbeit

Compression of CAD Data

Inhalt

The management of complex spatial objects in many non-standard database applications, such as computer-aided design (CAD), imposes new requirements on spatial database systems, in particular on efficient query processing. In the past two decades various index structures have been proposed to support this process. Recently, there has been increasing interest for indispensable integration of these structures into fully-fledged database systems.

The HRI method is a multi step index for interval sequences which are generated out of spatial objects via space filling curves. Interval sequences representing high resolution spatially extended objects often consist of very short intervals connected by short gaps. The HRI method groups the detailed black intervals together to longer grey intervals and stores them in a BLOB. A disadvantage of this method is the fact that the storage requirements for the grey intervals table grows with the gap length. Because increasing the gap length, at least up to a certain limit, reduces the number of the grey intervals which positively affects the query response time, large gap lengths are used ignoring the sub-optimal storage requirements.

In this master thesis, several algorithms for BLOB compression are presented. First, two versions of a high performance data compressors are discussed which keep the overall size of a CAD test data set almost constant, although the gap length is increased by an order of magnitude. The second approach uses the fact that BLOBs often contain lots of repeating structures, also called patterns. A pattern decomposition method is introduced which stores frequent parts of an object in a separate BLOB to reduce space.

Ergebnis

The compressors and the pattern decomposition were implemented as external procedures for the Oracle Release 9.0.1 ORDBMS using the Visual C++ 6.0 compiler for all time intensive computations. The experimental evaluation was based on real world test data set, and leads to the conclusion that fast compressors make it possible to increase the gap length of the HRI method without having to suffer from high I/O-costs. Finally, the results show that the pattern decomposition can compete with the MAXGAP based decomposition regarding performance.

Personen

Bearbeiter Peter Kunath
Betreuer Martin Pfeifle

Homepages: DBS Institut LMU
21.01.2003 Peter Kunath