Introduction to Lightweight databases

Data storage is an important part of engineering. The big family of database is a flourishing, the schools of contention, such as memory data storage, non-relational database, relational database, graph database and so on.

ACCESS

Microsoft Office Access is a relational database management system that is released by Microsoft. It combines two features of the Microsoftjet Database Engine and the graphical user interface and is one of the system programs for Microsoft Office.
Microsoft Office Access is a database management system that combines the graphical user interface of the database engine with the software development tools. It is a member of Microsoft Office and is sold separately in both professional and later versions of Office. December 4, 2012, the latest Microsoft Office Access 2016 was released in Microsoft Office 2016, and Microsoft Office Access 2013 was the previous version.
MS Access stores data in its own format in the Access jet-based database engine. It can also import or link data directly (this data is stored in other applications and databases).

Berkeley DB

Berkeley db is a pure Java open-source file database, between a relational database and an in-memory database, and is used in a similar way to a memory database, providing a series of functions that directly access the database, rather than requiring network communication, SQL parsing, and so on, like a relational database.

The reptile frame webcollector is used to berkeleydb.

PostgreSQL

PostgreSQL is more like MySQL, because it is a medium-sized relational database.
PostgreSQL is a POSTGRES, developed by the University of California, Berkeley Computer Department, and has now been renamed PostgreSQL, version 4.2-based Object Relational database management system (ORDBMS). PostgreSQL supports most SQL standards and offers many other modern features: complex queries, foreign keys, triggers, views, transactional integrity, MVCC. Similarly, PostgreSQL can be extended in many ways, such as by adding new data types, functions, operators, aggregation functions, and indexes. Free use, modification, and distribution of PostgreSQL, whether for private, commercial or academic use.

Berkeley database is a bit strong.

Hsqldb

The equivalent of Java version of Sqlite,sqlite is implemented in the C + + language.
Because JAVA,HSQLDB is based on natural cross-platform.

Db4o

An object-oriented database that supports both Java and. NET two platforms.
The innate disadvantage of the relational database: ORM Mapping wordy trouble.
Db4o is a kind of nosql.

Neo4j

NEO4J is a high-performance, NoSQL graphics database that stores structured data on a network rather than a table. It is an embedded, disk-based, Java persistence engine with full transactional characteristics, but it stores structured data on a network (mathematically called a graph) rather than a table. Neo4j can also be seen as a high-performance graph engine with all the features of a mature database. Programmers work in an object-oriented, flexible network structure rather than a strict, static table-but they can enjoy all the benefits of having full transactional features and an enterprise-class database.

Derby

Apache-Published pure Java memory database, relational database, fully supports JDBC.
Derby's life course is more tortuous.
The goal of the Apache Derby project is to build an open-source database that is easy to use and suitable for most applications, written entirely in the Java programming language. As you can imagine, developing a database is not easy, and Apache Derby database is no exception (because it is an open source software, so you can view it yourself). But the Derby project doesn't start with zero. Back in 1996, a new company called Cloudscape, Inc. was founded, and the company's goal was to build a database server written in the Java language. The first release of the company was launched a year later, and the name of the product became Cloudscape. In 1999, Cloudscape, Inc. was acquired by a large database vendor, Informix Software, Inc.
Informix software was acquired by IBM in 2001 and then IBM Cloudscape? The database system is used as an embedded database engine in many IBM products. In April 2004, IBM presented the Cloudscape database software to the Apache Software Foundation, which was born from the Apache Derby project.
At this point, the Cloudscape database has almost 500,000 lines of Java code, so it took some time to properly convert it to Apache Derby. After the incubation period, Derby was officially released in July 2005. So while it looks like something new, Derby has been developed for almost 10 years.

Firebird

A long history, relational database, C + + writing.

Sybase ASA

A relational database system developed by Sybase, a typical UNIX or WindowsNT platform, is a large database system in a client/server environment. Sybase provides a suite of application programming interfaces and libraries that can be integrated with non-Sybase data sources and servers, allowing data to be replicated across multiple databases, and for creating multi-tiered applications. The system has a complete definition of triggers, stored procedures, rules and integrity, and it supports optimized queries and has better data security.

H2

Features of the H2 include:

• Super fast speed, open source, JDBC syntax
• Embedded service mode, available as a memory database
• Browser-based Console interface
• Very small, jar package only 1.5M

is a comparison of H2 and other databases

Resources

H2 official website

Dawn winds up-cnblog:access, SQLite, HSQLDB, Sybase, MySQL, db4o
Http://www.ruanyifeng.com/blog/2013/12/getting_started_with_postgresql.html

Introduction to Lightweight databases