Embedded database Research

Embedded Database concepts:

An embedded database system is a database management system that supports mobile computing or a specific computing model that is typically integrated with the operating system and specific applications, running on intelligent embedded devices or mobile devices. Because embedded databases are always combined with mobile computing, embedded databases are often referred to as embedded mobile databases.

Types of embedded databases:

1.progress:

2.SQLite: http://www.sqlite.org/

1. Support events, no configuration required, no installation required , no administrator required

2. Support for most SQL92

3. A complete database is saved on the disk above a file, the same database file can be used on different machines, up to 2T, character and blob support only limited to the available memory

4. The entire system less than 30,000 lines of code, less than 250KB of memory consumption (GCC), most applications than the current common client/server database faster, no other dependencies

5. Source code Open, Code 95% has a good comment, easy-to-use API. Official with Tcl's compiled version.

SQLite executes faster,http://www.ituring.com.cn/article/44112

3.Empress (Commercial database):

4.berkeley DB are as follows:

1, embedded, no installation configuration required.
2, for a variety of programming languages to provide API interface, including C, C + +, Java, Perl, Tcl, Python and PHP and so on.
3. Light and flexible. It can run on almost all UNIX and Linux systems and their variant systems, Windows operating systems, and a variety of embedded real-time operating systems.
4. can be scaled. Its database library is only hundreds of KB in size, but it can manage databases up to 256TB in size. It supports high concurrency, and thousands of users can manipulate the same database at the same time.

5.Firebird's embedded version has the following features:

1, the database file and Firebird Network version is fully compatible, the difference is only the connection mode, you can achieve zero-cost migration.
2, the database files are only limited by the operating system, and support the partition of a database into different files, breaking through the operating system maximum file limit, improve IO throughput.
3, fully support SQL92 standard, support most SQL-99 standard function.
4, rich development tools support, most of the components based on InterBase, can be directly used in Firebird.
5. Support all the characteristics of relational database such as transaction, stored procedure, trigger, etc.
6. You can write your own extension function (UDF).

Comparison of embedded database features
Product name SQLite Berkeley DB Firebird
Current version: 3.3.8, 4.5.20, 2.0
Speed: fastest , fastest , fastest
Stability: Good, good , good
Database capacity: 2TB, 256TB, 64TB
SQL support: most SQL-92, unsupported, fully SQL-92 and most SQL-99
Minimum volume under Win32 platform: 374KB, 840KB, 3.68MB
Data manipulation: sql, application-only interface, SQL

Development Interface: C, C + +, PHP, Java, Delphi, Python. NET (some are developed by third-party vendors)

from the above comparison, we can see, the most concise is SQLite, its performance is also the highest, Berkeley db is more special, because it is not in SQL language to manipulate the data, Firebird embedded version of the volume contrast appears slightly larger, But its support for relational database features is best, and if you want to take into account that you might want to upgrade your database to a network version in the future, you should choose Firebird.

RELATED links:

http://www.360doc.com/content/11/0321/10/59141_103107315.shtml

Embedded database Research