|
|
||
[ Table 1 | Table 2 | Table 3 ]
Embedded Databases |
|
|
|
|
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Model | Berkeley DB | BirdStep DataBase Engine 3.0 | Cloudscape | Embedded Server | ||||||||
Manufacturer | Sleepycat Software, Inc. | Birdstep Technology | Cloudscape/ Informix | PointBase | ||||||||
Operating System | Linux; QNX; Windows 95/98/NT/2000; VxWorks |
EPOC; PalmOS; Linux; QNX; VxWorks; Elate; OSE; Windows 95, 98, NT, and 2000; WinCE; FreeBSD |
Windows CE; EPOC; Linux; Windows 98, NT; Solaris; HP-UX, AIX, OS/400; Mac OS |
EPOC; Windows CE; Windriver VxWorks; PalmOS |
||||||||
Memory | 315KB (Full Package) | 60K (min. size) | 2MB | 800KB | ||||||||
Network Connections | None | ODBC; JDBC |
JDBC; HTTP; HTTPS |
JDBC; HTTP |
||||||||
Synchronization | None | SyncML | bi-directiona Data; One way Schema and application |
One way, bi-directional, "hub & spoke" or P2P; Synchronizes with Oracle, IBM, DB2, MS SQL |
||||||||
Security | None | None | Signed JAR files; LDAP and NIS+; SSL support; DES 64-encryption |
SQL Security & authentication; 40/128-bit data encryption |
||||||||
API | C/C++; Java; Perl; Tcl; Python |
SQL; OLE-DB; ADO; JNI and JDBC; COM objects; C++; XML; Python Wrapper |
JDBC; SQL-92; SQL-J |
JDBC; SQL-92; SQL-99 |
||||||||
Development Tools | Portable to any development tools supporting the API languages | Birdwalk; Visual C++ |
Cloudview; IBM VisualAge; Visual Cafe |
Visual Cafe; Microsoft J++; IBM VisualAge; Inprise JBuilder |
||||||||
Other Features | B+tree, Hash, Fixed- and Variable-length record, and Persistent Queue access methods; transaction support; database recoverability |
XML DOM; XML parsing; Xpath; Unicode |
Triggers; Auto re-optimization; Multicolumn B-Tree indexes; Transaction rollback and isolation; Multithread connections; Referential Integrity |
Row-Level locking; Full Referential Integrity; |
||||||||
Availablility | Currently Available | Currently Available | Currently Available | Currently Available |
[ Table 1 | Table 2 | Table 3 ]
Embedded Databases |
|
|
|
|
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Model | Empress RDBMS | Mobile Edition | Oracle8i Lite | Polyhedra Real-Time Embedded Database | ||||||||
Manufacturer | Empress | PointBase | Oracle | Polyhedra | ||||||||
Operating System | Solaris; Sun O/S; HP-UX; AIX; Digital UNIX; IRIX; Win NT; Linux; SCO QNX; LYNX RTOS |
EPOC; Windows CE; Windriver VxWorks; PalmOS |
WinCE; PalmOS; EPOC32 |
Windows 98, NT, 2000; Linux; Solaris; OSE; VxWorks |
||||||||
Memory | 800KB (min. size) | 800KB | 750MB (With all Functionality) | N/A | ||||||||
Network Connections | ODBC; JDBC |
JDBC; HTTP |
ODBC; JDBC; iConnect through NET8, HTTP, wireless and FTP |
ODBC; JDBC; HTTP |
||||||||
Synchronization | Data Replication | One way bi-directional, "hub & spoke" or P2P; Synchronizes with Oracle, IBM, DB2, MS SQL |
Data Replication; Subquery Snapshots |
Master, Standby & Replicas modes of replication | ||||||||
Security | None | SQL Security; 40/128-bit data encryption |
None | SQL Security & authentication | ||||||||
API | SQL; C/C++; FORTRAN; JDBC |
JDBC; SQL-92; SQL-99 |
SQL-92; SQLJ; OKAPI; Java Access Classes; JDBC |
SQL; OLE/DB; JDBC; C/C++ Callback; Generic Device Interface (GDI) |
||||||||
Development Tools | EmpHTML; EmpPerl; EmpTcl/Tk; JumpStart |
Visual Cafe; Microsoft J++; IBM VisualAge; Inprise JBuilder |
Visual C++; Windows CE emulation mode; Oracle's JDeveloper, JBuilde; Visual Cafe; Visual Basic; Delphi; Oracle Lite Designer/Navigator; Web-to-go SDK |
Visual Basic; Visual C++ |
||||||||
Other Features | HTML Interface, Replication Server | Row-Level locking; Full Referential Integrity |
Java Stored Procedures and Triggers; Java Servlet; Row-level locking; Web-to-go Application Builder |
Active Queries; Control Language scripting; Journal Control Process; Web Database Server; Historian |
||||||||
Availablility | Currently Available | Currently Available | Currently Available | Currently Available |
[ Table 1 | Table 2 | Table 3 ]
Embedded Databases |
|
|
|
|
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Model | SOLID Embedded Engine | SQL Anywhere | SQL Server 2000 Windows CE Edition | SQLBase 7.5 | ||||||||
Manufacturer | Solid Information Technology | Sybase | Microsoft | Centura | ||||||||
Operating System | Windows 95/98/NT/2000; VxWorks; Solaris; Linux; HP-UX; FreeBSD; ChorusOS; EPOC; Enea OS |
Windows CE; PalmOS; VxWorks; DOS; EPOC |
Windows CE | Win 9X, NT | ||||||||
Memory | 450KB(min. size); 2MB (max. size) |
50K (min. size) | 1MB (With all Functionality) | N/A | ||||||||
Network Connections | ODBC; JDBC |
ODBC; JDBC; Sybase OpenClient |
Remote Data Access through HTTP | ODBC; JDBC |
||||||||
Synchronization | bi-directional | Mobilink synchronization through TCP/IP to any ODBC compliant database; Sybase SQL Remote through FTP or email; RiverBed ScoutSync; Palm HotSync |
Merge Replication; Remote Data Access |
None | ||||||||
Security | None | 128-bit data encryption | 128-bit data encryption during synchronization; RSA 128-bit data file encryption; Database password authentication |
Password Authentication; 40-bit data encryption using cryptogram and DES |
||||||||
API | SQL-92; JDBC |
Embedded SQL; Transact-SQL; SQL-92; C++; JDBC |
Transact-SQL; ADOCE; OLEDBCE |
SQL; C/C++ (DLL and linked); JDBC |
||||||||
Development Tools | N/A | Sybase PowerBuilder; Visual C++; Visual Basic; Delphi; Metrowerks CodeWarrior; WindRiver Tornado |
eMbedded Visual Tools 3.0; Platform Builder |
SQLBase Embedded Deployment Kit; Visual Basic |
||||||||
Other Features | Stored procedures and commands; Symmetric multi-processing; Unions; Triggers; Multithread processing |
SQL and Java Triggers and Stored Procedures; Referencial and entity Integrity; cascading deletes and updates; Full Transactional Processing; Row-Level locking; Event scheduling and handling; 2048 indexes per table; 32,767 tables per database; 2GB field size; unlimited rows and columns; |
Full referencial Integrity; Cascading deletes and updates; 32 indexes per table; Nested transactions; DDL/DML |
Synonyms; Views; Stored procedures and Triggers; Nested selects; Unions; Referential Integrity |
||||||||
Availablility | Currently Available | Currently Available | Currently Available | Currently Available |
[ Table 1 | Table 2 | Table 3 ]
Embedded Databases |
|
|
|
|
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Model | TimesTen 4.3 | |||||||||||
Manufacturer | TimesTen Performance Software | |||||||||||
Operating System | VxWorks | |||||||||||
Memory | 5MB | |||||||||||
Network Connections | ODBC | |||||||||||
Synchronization | N-way replication; P2P or cascading replication |
|||||||||||
Security | Client/Server Authentication | |||||||||||
API | SQL; C/C++ |
|||||||||||
Development Tools | N/A | |||||||||||
Other Features | SNNP events & alerts; In-Memory database; Checkpoints & Data Recovery |
|||||||||||
Availablility | Currently Available |