Multi-Version Concurrency control (MVCC): MVCC is an advanced technique for improving database performance in a multi-user environment. MVCC ensures that a transaction never has to wait for a lock on a database object.
Unicode Support: The RDBMS supports Unicode characters and text. In contrast to ASCII, the Unicode format can express any character of any language.
External Java Procedures: Support for external Java procedures means that database developer can call Java class methods from stored procedures or functions.
Correlated Sub Query: A correlated subquery is a SELECT statement nested inside another SELECT statement where the inner query contains a reference to one or more columns in the outer query. Therefore, the correlated subquery can be said to be dependent on the outer query. This dependency is the difference between a correlated subquery and a plain subquery. A plain subquery is not dependent on the outer query, can be run independently of the outer query, and will return a result set. A correlated subquery, because it depends on the outer query, will return a syntax errors if run by itself.
PooledConnection: An object that provides hooks for connection pool management. A PooledConnection represents a physical connection to a data source. The connection can be recycled rather than being closed when an application is finished with it, thus reducing the number of active connections on the database.
Multi Column Predicate: This is the combination of multiple conditions in a single expression using an AND operator, for example: (ID, Name) = (265,'David')
SQL 99: This standard incorporates most of SQL-92 and SQL/PSM. The publication of this standard made all earlier standards obsolete. SQL-99 contains the following parts:
- Part 1: Framework (SQL / Framework)
- Part 2: Foundation (SQL / Foundation)
- Part 3: Call-Level Interface (SQL / CLI)
- Part 4: Persistent Stored Modules (SQL / PSM)
- Part 5: Host Language Bindings (SQL / Bindings).
| Author's Note: Source: ISO/IEC 9075:1999(E) Information technology - Database languages - SQL. The SQL-99 standard contains many different features; a subset of these features forms Core SQL-99. |
ODBC Driver: Open Database Connectivity (ODBC) is a standard API for connecting to database management systems (DBMS). ODBC is independent of any one programming language, database system or operating system. It's based on the Call Level Interface (CLI) specifications from SQL, X/Open (now part of The Open Group), and the ISO/IEC. ODBC was created by the SQL Access Group and first released in September, 1992.
JDBC 3.0: Java Database Connectivity, or JDBC, is an API for the Java programming language that defines how a client may access a database. It provides methods for interacting with the database server.
PHP Support: PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages. PHP-enabled web pages are treated just like regular HTML pages and you can create and edit them the same way you normally create regular HTML pages. PHP support means whether the database is support PHP or not.
Updatable Views: Views that you can use to insert, update, and delete base table rows.
Referential Integrity Options: Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table.
Match Types
- MATCH FULL: Specifies that for each row R1 of the referencing table, either the value of every referencing column in R1 shall be a null value, or the value of every referencing column in R1 shall not be null and there shall be some row R2 of the referenced table such that the value of each referencing column in R1 is equal to the value of the corresponding referenced column in R2.
- MATCH PARTIAL: Specifies that for each row R1 of the referencing table, there shall be some row R2 of the referenced table such that the value of each referencing column in R1 is either null or is equal to the value of the corresponding referenced column in R2. The referencing table may be the same table as the one referenced.
- MATCH SIMPLE: This is the default type, and specifies that for each row R1 of the referencing table, either at least one of the values of the referencing columns in R1 shall be a null value, or the value of each referencing column in R1 shall be equal to the value of the corresponding referenced column in some row of the referenced table.
JDBC-XA: The XA standard is an X/Open standard for distributed transaction processing. It describes the interface between the global transaction manager and the local resource manager. JDBC-XA support means whether database supports distributed transactions or not.
Domain: This is a defined data type based on the predefined data types of the underlying RDBMS with some constraints. We can say domains are user-defined data types with the specified size and associated constraints.
DataSource: An alternative to the DriverManager facility, a DataSource object is the preferred means of getting a connection. An object that implements the DataSource interface will typically be registered with a naming service based on the Java Naming and Directory (JNDI) API.
RowSets: A Javax.sql.RowSet object encapsulates a set of rows that have been retrieved from a tabular data source. The RowSet interface includes an event notification mechanism and supports getting and setting properties; every RowSet object is a JavaBeans component. This means, for example, that a RowSet can be used as a JavaBeans component in a visual JavaBeans development environment. As a result, a RowSet instance can be created and configured at design time, and its methods can be executed at run time.
SavePoints: SavePoints provide finer-grained control of transactions by marking intermediate points within a transaction.
ParameterMetaData: An object that can be used to get information about the types and properties of the parameters in a java.sql.PreparedStatement object.
DatabaseMetaData: JDBC driver vendors implement the DatabaseMetaData interface to let users know the capabilities of a Database Management System (DBMS).
ResultSetGetAutoGeneratedKeys: Many database systems have a mechanism that automatically generates a unique key field when a row is inserted. The method Statement.getGeneratedKeys, which can be called to retrieve the value of such a key, returns a ResultSet object with a column for each automatically generated key.
Role: A named list or group of privileges granted to users or other roles.
Full Text Search: A database either supports Full Text Search or not. Full Text Search is a technique based on 'natural language' search instead of searching for a specific or exact search.
|
