Oracle Technology Network for Java Developers Oracle Technology Network.Features Feature List Comparison to Other Database Engines H2 in Use Connection Modes Database URL Overview Connecting to an Embedded Local Database In Memory Databases Database Files Encryption Database File Locking Opening a Database Only if it Already Exists Closing a Database Ignore Unknown Settings Changing Other Settings when Opening a Connection Custom File Access Mode Multiple Connections Database File Layout Logging and Recovery Compatibility Auto Reconnect Automatic Mixed Mode Page Size Using the Trace Options Using Other Logging APIs Read Only Databases Read Only Databases in Zip or Jar File Computed Columns Function Based Index Multi Dimensional Indexes User Defined Functions and Stored Procedures Pluggable or User Defined Tables Triggers Compacting a Database Cache Settings.Feature List.Main Features.Very fast database engine Open source Written in Java Supports standard SQL, JDBC API Embedded and Server mode, Clustering support Strong security features The Postgre.SQL ODBC driver can be used Multi version concurrency Additional Features.Disk based or in memory databases and tables, read only database support, temporary tables Transaction support read committed, 2 phase commit Multiple connections, table level locking Cost based optimizer, using a genetic algorithm for complex queries, zero administration Scrollable and updatable result set support, large result set, external result sorting, functions can return a result set Encrypted database AES, SHA 2.SSL SQL Support.Support for multiple schemas, information schema Referential integrity foreign key constraints with cascade, check constraints Inner and outer joins, subqueries, read only views and inline views Triggers and Java functions stored procedures Many built in functions, including XML and lossless data compression Wide range of data types including large objects BLOBCLOB and arrays Sequence and autoincrement columns, computed columns can be used for function based indexes ORDER BY, GROUP BY, HAVING, UNION, LIMIT, TOPCollation support, including support for the ICU4.J library Support for users and roles Compatibility modes for IBM DB2, Apache Derby, HSQLDB, MS SQL Server, My.SQL, Oracle, and Postgre.SQL.Security Features.Includes a solution for the SQL injection problem User password authentication uses SHA 2.For server mode connections, user passwords are never transmitted in plain text over the network even when using insecure connections this only applies to the TCP server and not to the H2 Console however it also doesnt apply if you set the password in the database URL All database files including script files that can be used to backup data can be encrypted using the AES 1.The remote JDBC driver supports TCPIP connections over TLS The built in web server supports connections over TLS Passwords can be sent to the database using char arrays instead of Strings Other Features and Tools.Small footprint smaller than 1.Here is a Simple demonstration of Debugging Jdbc NW Connectivity issues.Some very basic and common tools and simple Jdbc programs helps us a lot in debugging the.DN_2D00_5d.jpg' alt='Db2 Jdbc Driver Jar File Name Change' title='Db2 Jdbc Driver Jar File Name Change' />MB, low memory requirements Multiple index types b tree, tree, hash Support for multi dimensional indexes CSV comma separated values file support Support for linked tables, and a built in virtual range table Supports the EXPLAIN PLAN statement sophisticated trace options Database closing can be delayed or disabled to improve the performance Web based Console application translated to many languages with autocomplete The database can generate SQL script files Contains a recovery tool that can dump the contents of the database Support for variables for example to calculate running totals Automatic re compilation of prepared statements Uses a small number of database files Uses a checksum for each record and log entry for data integrity Well tested high code coverage, randomized stress tests Comparison to Other Database Engines This comparison is based on H2 1.Apache Derby version 1.HSQLDB 2.My. SQL 5.Postgre.SQL 9. 0.Feature.H2. Derby.HSQLDBMy.SQLPostgre.SQLPure Java.Yes.Yes. Yes. No.No.Embedded Mode JavaYes.Yes.Yes. No. No.In Memory Mode.Yes.Yes. Yes. No.No.Explain Plan. Yes.Yes 1.Yes. Yes.Yes. Built in Clustering Replication.Yes.Yes. No. Yes.Yes.Encrypted Database.Yes.Yes. 0Yes. No.No.Linked Tables.Yes.No. Partially.Partially.Yes. ODBC Driver.Yes.No. No. Yes.Yes. Fulltext Search.Yes.Yes. No. Yes.Yes.Domains User Defined TypesYes.No.Yes. Yes. Yes.Files per Database.Few.Many. Few. Many.Many.Row Level Locking.Yes.Yes. Yes. Yes.Yes.Multi Version Concurrency.Yes.No. Yes. Yes.Yes.Multi Threaded Processing.No.Yes. Yes. Yes.Yes.Role Based Security.Yes.Yes. Yes. Yes. Corel Draw Graphics Suite X4 Serial Number .Yes. Updatable Result Sets.Yes.Yes. Yes. Yes.Yes.Sequences. Yes.Yes.Yes. No. Yes.Limit and Offset.Yes.Yes. 3Yes. Yes.Yes. Install Windows Me On Dosbox Emulator . Window Functions.No.No. 5No. No.Yes. Temporary Tables.Yes.Yes. Yes. Yes.Yes.Information Schema.Yes.No. Yes. Yes.Yes.Computed Columns.Yes.Yes. Yes. Yes.Yes.Case Insensitive Columns.Yes.Yes. 4Yes. Yes.Yes.Custom Aggregate Functions.Yes.No. Yes. No.Yes. CLOBBLOB Compression.Yes.No. No. No. Yes.Footprint jardll size1.MB 3 MB1.MB4 MB6 MB HSQLDB supports text tables.My.SQL supports linked My.SQL tables under the name federated tables.Derby support for roles based security and password checking as an option.Derby only supports global temporary tables.The default H2 jar file contains debug information, jar files for other databases do not.Postgre.SQL supports functional indexes.Derby only supports updatable result sets if the query is not sorted.Derby doesnt support standard compliant information schema tables.When using MVCC multi version concurrency.Derby and HSQLDB dont hide data patterns well.The MULTITHREADED option is not enabled by default, and with version 1.MVCC.Derby doesnt support the EXPLAIN statement, but it supports runtime statistics and retrieving statement execution plans.Derby doesnt support the syntax LIMIT.OFFSET., however it supports FETCH FIRST.ROWS ONLY.Using collations.Derby and H2 support ROWNUMBER OVER.Daffodil.Db and OneDb It looks like the development of this database has stopped.The last release was February 2.Mc.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |