CUBRID
is an open source SQL-based relational database management system (RDBMS) with
object extensions. It is highly optimized for Web Applications such as social
networking services that process large amount of data and that which receive huge
concurrent requests for complex set of web services. It implements SQL-92
standard and has extended SQL syntaxes. It is 90% compatible with MySQL and
supports many of the Oracle features including hierarchical queries. It is,
however, not been forked from MySQL or Oracle in spite of similarities.
CUBRID
is developed and managed by Naver Search Solutions. CUBRID was first released
in November, 2008; its most recent stable version, at the time of this writing,
CUBRID 10.0 was released in February, 2016. CUBRID’s server engine is licensed
under GNU General Public License for and its APIs and GUI tools are licensed
under BSD license.
CUBRID
is supported by in-depth online/offline manuals, release notes, API
documentations, tutorials, and technology reviews. It provides APIs for
programming language support to C, PHP/PDO, ADO.NET, Python, Perl, Ruby, and
Node.js. It also allows heterogeneous databases integration with APIs for with
JDBC, ODBC, OLEDB, etc. It provides native tools such as CUBRID Manager – a powerful
database administration tool; CUBRID Query Browser – a quick and lightweight tool
to query databases; CUBRID Migration Toolkit for seamless data migration
between MySQL, Oracle, and CUBRID databases; and CUBRID Web Manager – system
and resource monitoring features for web based applications.
CUBRID
is highly secured system with security implemented with IP, user id, and
database based access restriction. The smallest grant unit of authorization is
a table; security is not implemented at record or cell levels. Other features
of CUBRID include:
- Databases, tables, and indexes can be of unlimited number and size.
- Can run during system maintenance including OS, software upgrade, device replacement or expansion.
- Allows for connection and statement pooling.
- Has multi-threaded and multi-server architecture.
- High replication for high-availability, load balancing and scalability
- A native CUBRID Hearbeat technology that provides very accurate and predictable automatic fail-over and fail-back features.
- Allows partitioning of tables based on range, list and hash.
- It has multiple independent master database nodes and one or more slave database nodes.
- Transaction log replication can be done in three copy modes, viz., synchronous, semi-synchronous, and asynchronous.
- Allows unlimited database sharding to divide the data over multiple database instances.
- Includes multiple efficient caching techniques such as Query Plan Cache, Shared Query Plan Cache, Query Result Cache.
- Provides optimized indexing algorithms which can be multi-ranged, in-reverse, function based, filtered indexes and uses B+tree indexes to improve search performance.
- Object Identifiers (OIDs) for objects for faster access.
- Online compressed backups and restoring facilities
- Allows creation of columns with custom data type. One table can be a data type for a column in another table.
More on Free and Open Source software, their fundamentals, philosophy, development models and business models in ...
To Order this book click here