Apache Phoenix vs. Oracle Big Data SQL Cloud Service vs. SQLite Data Access Components vs. ThinkSQL Comparison Chart

Oracle Big Data SQL Cloud Service enables organizations to immediately analyze data across Apache Hadoop, NoSQL and Oracle Database leveraging their existing SQL skills, security policies and applications with extreme performance. From simplifying data science efforts to unlocking data lakes, Big Data SQL makes the benefits of Big Data available to the largest group of end users possible. Big Data SQL gives users a single location to catalog and secure data in Hadoop and NoSQL systems, Oracle Database. Seamless metadata integration and queries which join data from Oracle Database with data from Hadoop and NoSQL databases. Utilities and conversion routines support automatic mappings from metadata stored in HCatalog (or the Hive Metastore) to Oracle Tables. Enhanced access parameters give administrators the flexibility to control column mapping and data access behavior. Multiple cluster support enables one Oracle Database to query multiple Hadoop clusters and/or NoSQL systems.

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.