Naslov
SDBMS Based Data Model for CAFM Systems

Autori
Matijević, Hrvoje ; Roić, Miodrag ; Mastelić Ivić, Siniša

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), znanstveni

Izvornik
Proceedings of INGEO 2004 and FIG Regional Central and Eastern European Conference on Engineering Surveying / Kopačik, A. - Bratislava : International Federation of Surveyors (FIG), 2004

Skup
3rd International Conference on Engineering Surveying and FIG Regional conference for Central and Eastern Europe

Mjesto i datum
Bratislava, Slovačka, 11.11.2004. - 13.11.2004

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
SDBMS; CAFM; topology; 3D spatial data
(prostorne baze podataka; podrška upravljanju prostorom; topologija; 3D podaci)

Sažetak
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.

Izvorni jezik
Engleski

Znanstvena područja
Geodezija

POVEZANOST RADA