Differences between revisions 3 and 4
Revision 3 as of 2014-11-11 17:46:29
Size: 3244
Comment: Added link to QueryExecutionStrategies
Revision 4 as of 2014-12-23 13:07:50
Size: 3285
Comment: Added Cassandra and ElasticSearch to NoSQL database list
Deletions are marked like this. Additions are marked like this.
Line 6: Line 6:
 * Extensive but fault-tolerant use of the Java DataBase Connectivity (JDBC) specification.  * Extensive but fault-tolerant use of the Java !DataBase Connectivity (JDBC) specification.
Line 27: Line 27:
 * MongoDB  * Apache Cassandra
Line 30: Line 30:
 * !ElasticSearch
 * MongoDB

Database compliancy

It is one of the important goals of MetaModel to be compliant with as many databases and datastores as possible! We ensure a broad compliance by several initiatives:

  • A broad integration test suite.
  • Extensive but fault-tolerant use of the Java DataBase Connectivity (JDBC) specification.

  • Use of uniform SQL-99 compliant queries.

For information on the performance characteristics and approach to query execution, see QueryExecutionStrategies.

Relational databases known to be working with MetaModel

Database

Version

JDBC driver

MySQL

5+

Connector/J

PostgreSQL

8+

PostgreSQL JDBC driver

Oracle

10g

SQLJ/JDBC

Apache Derby

10+

Derby driver

Firebird SQL

2.0+

Jaybird driver

Hsqldb/HyperSQL

1.8+

Hsqldb driver

H2

1.2+

H2 driver

SQLite

3.6.0+

Xerial driver

Microsoft SQL Server

2005+

JTDS driver

Ingres

Ingres JDBC driver

Non-relational / NoSQL databases supported by MetaModel

  • Apache Cassandra
  • Apache CouchDB
  • Apache HBase
  • ElasticSearch

  • MongoDB

Business application supported (through system services) by MetaModel

  • Salesforce.com
  • SugarCRM

File data formats supported by MetaModel

File format

File extension

Version

Comma separated file

.csv

Microsoft Excel spreadsheet

.xls

Excel '97-2003

.

.xlsx

Excel 2007+

JSON file

.json

OpenOffice.org database

.odb

OpenOffice 2.0+

XML file (SAX based)

.xml

XML file (DOM based)

.xml

Microsoft Access database

.mdb

Access '97-2003

.

.accdb

Access 2007+

dBase database

.dbf

Java object datastores (aka POJO datastores)

MetaModel also supports creating datastores built on top of plain Java objects. Either by using a collection of Java bean objects (with getters and setters) or by using collections of Maps or arrays. In the case of using collections of arrays, you will need to manually appoint column names to each index in the arrays.

Composite datastores

MetaModel supports an advanced feature called composite datastores. In short it means that it's possible to access and query several datastores as if they where one. This involves transparent client-side joining, filtering, grouping etc. Composite datastores are typically not as performant in terms of querying but provides for a convenient way to combine data that is otherwise inherently separated from each other.

Third party connectors

See MetaModelExtras

DatabaseCompliancy (last edited 2014-12-23 13:07:50 by KasperSorensen)