Databases Reference
In-Depth Information
• MySQL Enterprise Monitor for proactive best practices tips and security alerting
through the Enterprise Dashboard, Advisors, Replication Monitor, and Query An‐
alyzer (that identifies SQL code slowing query performance)
The MySQL Cluster Carrier Grade Edition automatically partitions database tables
across nodes of a multinode commodity hardware platform providing horizontal scal‐
ability using the NDB engine. This Edition also enables highly available configurations
and supports active-active replication for clustering across distributed geographies, in‐
cluding for purposes of disaster recovery. Nodes can be added and database schema can
be updated while the database is online. The MySQL Cluster Manager automates com‐
mon cluster management tasks and provides extended cluster monitoring support.
Berkeley DB & Oracle NoSQL Database
Oracle Berkeley DB is an extremely small-footprint embedded database engine. The
engine supports transactional workloads and features multiversion concurrency con‐
trol, indexing, encryption, and replication. It comes in variations that Oracle labels as
Berkeley DB, Berkeley DB Java Edition, and Berkeley DB XML. Data interfaces sup‐
ported include the SQLite API, Java Objects, key value, and XQuery/XPath for XML.
For example, the Java Edition provides a direct persistence layer (DPL) API for EJB-
style persistence and a Java collection API and the database is a single JAR file.
Berkeley DB is designed to be deployed with and run in the same process as your ap‐
plications. Footprints for the database have static library sizes of less than 1 MB and
runtime dynamic memory requirements of a few kilobytes.
When mobile applications deployed using Berkeley DB are to be attached to an Oracle
Database, the Oracle Database Mobile Server provides a sync engine and a mobile
manager. This server can be deployed on WebLogic or GlassFish. Mobile clients can
include Java, Android, Blackberry, Windows, and Linux.
In 2011, Oracle introduced the Oracle NoSQL Database that leverages the Berkeley DB
Java Edition engine. It is designed to support large volume and low latency applications
and is implemented on a distributed key value engine with transparent load balancing
across the nodes it is deployed to. The applications are written specifying data consis‐
tency policies depending on the amount of overhead that is acceptable. These policies
can range from absolute consistency to time-based consistency to weak consistency
(and lowest latency). The NoSQL Database can be deployed as highly available through
configurable multiple replicas and for disaster recovery by locating the replicas in sec‐
ondary locations.
Two editions are available. The Oracle NoSQL Database Community Edition is Oracle's
open source offering (AGPL version 3 license). It is included with the Oracle Big Data
Appliance. Oracle also offers the Oracle NoSQL Database Enterprise Edition, which is
Oracle-supported.
