0
Oracle Spatial is an option of the Oracle Database Enterprise Edition. Its core component is a new datatype called SDO_GEOMETRY that is used to store geometric figures (points, lines and polygons) defined by one or more coordinates.
This allows you to create "spatial" tables, i.e. tables that contain any number of regular columns and one column of type SDO_GEOMETRY (or even multiple such columns).
You can then query those tables using spatial predicates (like CONTAINS, TOUCHES, INSIDE, WITHIN_DISTANCE etc). Things like "get me the land parcels of a certain type that are on the path of this pipeline", or "get the list of customers that live within 10km of a store".
Databases that use Oracle Spatial are commonly used by commercial or open source GIS tools to store and manage their spatial data.
Advanced capabilities include the storage of raster data (imagery), network searches, geocoding, routing, topology etc.
Add your answer:
Earn +20 pts
When was Spatial Query Server created?
Spatial Query Server was created in 2001-12.
What server can use PHP and Oracle?
Oracle is a database server and is independent from the web server. This means that any server capable of running natively or through CGI/FastCGI php can also use Oracle.
Which Oracle software uses SQL server tools?
SQL Server Tools are tools for the Microsoft SQL Server (MSSQL). Oracle is another company that develops database systems and offer Oracle tools to manage Oracle databases.
Which services are offered on the website PostGIS?
The website for PostGIS offers services such as Oracle Locator/Spatial and SQL Server. It has a features list showing all of their offerings as well - mainly in the spatial and geographic objects. They also offer Open Source Desktop Editing/Viewing Tools.
What is deffirence between sql server 2005 and oracle?
oracle runs on any platform whereas sql server runs only on windows.
What is the main purpose of an Oracle application server 10g?
The main purpose of an Oracle Application Server 10g, is to basically replace an older version of the servers that the Oracle corporation was using. The "g" stands for grid, and this new enhanced version is the center or the corporation. This application, is now the standard for server platforms.
Where can one find instructions on how to use a Weblogic server?
One can find instructions on how to use a Weblogic server online on websites, such as Slide Share, Oracle and Free Oracle Help. There are many online tutorials for Weblogic server.
Difference between weblogic server and application server?
WebLogic Server is a specific brand of Java EE application server provided by Oracle, while an application server is a generalized term for a server dedicated to running applications. WebLogic Server is a type of application server that specifically supports Java EE applications and includes additional features like clustering, security, and transaction handling.
Is an implicit cursor is managed internally by oracle server?
yes. Implicit is managed by Oracle n Explicit cursors we have to manage.
What is oracle software structures?
when we install d oracle software, on oracle directory structure is created to store the executables , shared libraries , configuration files , trace files , and so on both server and client software is stored in the same directory. Oracle is installed on the server using on operating system account created specially for the task oracle has a directory structure.
Any examples for rdbms?
Oracle, Db2, SQL Server etc
How do you migrate from sql server to oracle?
Hire contractors who know both?
