The LuciadLightspeed Database Connectors component provides support for seamlessly integrating Oracle Locator databases into LuciadLightspeed applications. It includes support for the more complex features that are offered by Oracle Spatial, with the exception of Oracle GeoRasters, for which the LuciadLightspeed Oracle Spatial functionality is also required. Within Oracle Locator, both the Relational Model and the Object-Relational Model are supported.
The Relational Model is based on sets of tables, called layers, containing columns with traditional primitive SQL types. When interpreted correctly, they represent various geometries. This representation is fairly difficult to maintain and to work with. The Relational Model is deprecated and no longer supported by Oracle.
This page focuses on the newer Object-Relational Model. It is based on additional SQL types for representing various geometries. These can be inserted as single entities into spatial columns, which can co-exist with traditional non-spatial columns.
The Oracle Spatial User’s Guide and Reference provides all the necessary information on setting up, maintaining, and using spatial databases. This page explains how spatial data can be imported from, and exported to, spatial databases.