Oracle Spatial vs. ROLTA OnPoint vs. SQLite Data Access Components vs. ThinkSQL Comparison Chart

Rolta OnPoint™ is the engine that drives Rolta’s Geospatial Fusion solutions. It is a full-featured spatial integration application that supports business processes across a diverse range of business functions and industries. Using OnPoint™, clients can publish GIS data quickly and securely over the web, connecting to all data from inside and outside of the organization in real-time. This data, in turn, can be easily disseminated via Internet and/or Intranet platforms, transforming web-GIS into a true enterprise solution. OnPoint™ can also connect to industry standard databases such as Oracle, MS SQL Server, Teradata, Sybase, and any OBDC-compliant data source via configurable web services. In addition, OnPoint™ also has the capability to connect to legacy data structures (such as flat files and hierarchical files) through the use of Rolta’s SOA platform: iPerspective™. Easy to integrate with key business processes, OnPoint™ supports and enhances specialized workflows.

ThinkSQL is a powerful, cross-platform relational database management system designed for modern operating systems and hardware. It aims to comply fully with the ISO SQL standard to provide an open and flexible SQL server for your applications. Compliance with the SQL standard means it supports transactions, sub-selects, views, set operators (union, except, intersect), access privileges and comprehensive referential constraints to ensure the integrity of your data. ThinkSQL uses a multi-versioning engine to provide consistent views of data and concurrent access to rows without locking. The server also has stored procedures and functions (using the standard syntax), and has support for large multimedia objects. It's easy to install, runs on Windows ® and Linux ®, and has native ODBC, JDBC™, dbExpress™ and Python drivers so your applications can connect directly from any platform.