Evaluating different approaches of spatial database management for moving objects




7.5. Spatial Extender
In 1997, the Open GIS Consortium published the OpenGIS Simple Features Specifications for SQL, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial data.

DB2 Spatial Extender is use to generate and analyze spatial information about geographic features and to store and manage the data on which this information is based. The DB2 Spatial Extender allows the user to include spatial attributes (distances, times, and geographical information) into business analysis. It confirms to ISO and OpenGIS Consortium (OGC) standards. Additionally the latest version of the spatial extenders includes an Index Advisor for tuning spatial indexes, includes additional spatial functions, and the ability to export SDE transfer data and spatial data to geobrowsers.

MySQL implements spatial extensions following the specification of the Open GIS Consortium (OGC).

A major feature of Oracle 9i is Oracle Spatial. This is a spatial extender that provides storage, indexing and proximity queries for location-based information, which may include road networks, wireless service boundaries and geo-coded customer addresses, for example. Oracle Spatial makes it possible to combine the relational power of a database with spatial data. The ability to use indexes, various queries, and functions means complex spatial calculations may be pushed back onto large database servers. As mobile applications and technologies increase, so will the demands to store and analyze spatial data in a transactional setting. [4]

7.6. Security
Database security is a very important aspect of any relational database management system to protect access to the database operations and the data.

At first glance, Oracle and IBM appear to offer similar security solutions, but with closer inspection, it is plain to see that the two companies approach security differently and ship solutions at vastly different levels of maturity. Independent evaluations and feature-for-feature comparisons prove that the Oracle9i Database is more secure than IBM’s DB2 Universal Database. Overwhelming evidence supporting this assertion, as established in this paper, proves that Oracle security is far superior to DB2 security.

It is difficult to make up for a lack of security built into the core DB2 product set, but IBM offers a variety of packaged service plans to do so. Oracle’s security solutions are much less expensive than IBM’s because customers do not have to pay for additional software and services. IBM’s security solutions are less secure than Oracle’s because they rely on external solution and services to implement security they’ve neglected to build into DB2, which does not provide equivalently robust, mature security features that Oracle has been shipping for years.

8. Summery
In summery, different DBMS package has different features and capabilities. The following tabale provide a brief review on the comparison different DBMS based on their featurs and capabilities. (Table 3)

Table 3. Comparison of DBMS’s at a glance


9. Conclusion
From the above presented comparison, the following conclusions can be made:
  • SQL Server 2000 holds the top TPC-C performance and price/performance results.
  • SQL Server 2000 is generally accepted as easier to install, use and manage.
  • MySQL version 4.1 requires little hardware resources.
  • You can use MySQL version 4.1 without any payment under the terms of the GNU General Public License.
  • Oracle 9i Database, DB2 Universal Database v8.1 and MySQL version 4.1 supports all known platforms, not only the Windows-based platforms.
  • PL/SQL is the most powerful language
  • Oracle9i Database offers a rich set of development and administration tools
  • Oracle and DB2 can scale to terabytes of data storage fairly easily
  • When it comes to backups, open-source databases like MySQL and PostgreSQL may not completely fulfill your needs.
  • Oracle Spatial makes it possible to combine the relational power of a database with spatial data
With concider to specifications of different commercial database management systems, that mentioned before and based on the capabilities that are needed by moving objects database applications, we recommend Oracle as the first choice for managing spatio-temporal data. DB2 universal database and SQL server are the next alternatives.

10. Future Activities
Our objective is to develop a framework for managing and querying moving object database. We will use Oracle software package to design and develop the capabilities required for moving object’s querries.

11. References
  1. G.Christakos, P.Bogaert, M.Serre, , Temporal GIS: Advanced functions for field-based applications, Springer.2002.
  2. Time-integrative Geographic information system: Management and analysis of spatio-temporal data. Thomas Ott. Frank Swisaczny.2001.Springer
  3. Roshannezhad, Aliasghar,”,(1996) The Management Of Spatio-Temporal Data in a National Geographic Information System”.
  4. Matt Bauer, Mapping Geometric Data with Oracle Spatial, 11/10/2003
  5. Xavier R. Lopez, Oracle Database 10g:A SPATIIAL VLDB CASE STUDY, Oracle Corporation
  6. Alexander Chigrik. A Comparison of Oracle 9i with DB2 v8.1, September 10, 2003
  7. www.databasejournal.com
  8. Michael Otey . SQL Server 2000's Coolest Features, InstantDoc #9797, November 2000
  9. Alexander Chigrik. The comparison of SQL Server 2000 with MySQL v4.1, October 8, 2003
  10. Suita Gupta, Allan Tham, Raul Chong. Leveraging your Oracle 9i skills to learn DB2 UDB for Linux, UNIX and Windows V8, 09 Jan 2004
  11. Gregg Petri .A Comparison of Oracle and MySQL, 1st Qtr 2005
  12. Tim Conrad .PostgreSQL vs. MySQL vs. Commercial Databases: It's All About What You Need,2005
  13. Konrad Bohuszewicz, Maciej Czy¿owicz, Micha Janik, Dawid Jarosz, Piotr Mazan, Marcin Mierzejewski, Miko aj Olszewski, Wiktor S. Peryt, Sylwester Radomski, Piotr Szarwas, Tomasz Traczyk, Dominik Tukendorf, Jacek Wojcieszuk .Comparison of Oracle, MySQL and Postgres DBMS.
  14. Technical Comparison of Oracle9i Database vs. IBM DB2 UDB: Focus on High Availability, An Oracle White Paper, February 2002
  15. Bloor Research .Databases An evaluation & comparison.
Page 3 of 3
| Previous |