151. SDBMS Based Data Model for CAFM Systems
- Author
-
Matijević, Hrvoje, Roić, Miodrag, Mastelić Ivić, Siniša, and Kopačik, A.
- Subjects
SDBMS ,CAFM ,topology ,3D spatial data - Abstract
The need for maximum efficiency in (working) space usage resulted in 1980-s by emerging of first CAFM system. The technology in the field of spatial data management available in mentioned period (CAD+RDBMS) has significantly influenced further development of these systems and thus their current form. Current trends, like 3D modeled data in area of visualization being constantly requested by the user, or rapidly increasing need for 3D analysis of spatial data, mentioned technological basis simply can not satisfy. SDBMS technology, on the other hand, is more than capable to cope with such challenges. Although all currently available SDBMS do not natively support 3D spatial analysis, storage and querying of 3D spatial data is generally supported. Furthermore, by using available programming support (Java, PL/SQL, ...), at least some basic 3D analytical functionality is relatively simple to implement. Spatial component of the developed data model, which is also the main objective of the research, is based on spatial planar surfaces representing walls and other surfaces typically found within a building. These basic spatial objects are used to model logically important object, called body, which can be empty (a room) or filled (a wall). System’ s entire spatial data is therefore contained within a single object type (planar surface) which is topologically structured (face-node structure) to ensure safe, consistent and efficient operation. The model is implemented on top of Oracle9i SDBMS. Data access interface is being developed based on 3-tier program architecture with JSP servlet for data querying and preparation, HTTP as transport medium and VRML as presentation and basic user interface technology. Realization of a system based on the developed model directly enables performing of simple topological analysis (neighborhood), with thematic querying and resimbolization immediately available. Furthermore, by introducing temporal component of spatial data, reviewing of a system status in a specified moment is easily accomplished.
- Published
- 2004