CUBRID

CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.wikipedia
69 Related Articles

Shard (database architecture)

shardingshardedshard
CUBRID provides built-in support for database sharding.
CUBRID: allows sharding from version 9.0

Hierarchical and recursive queries in SQL

common table expressionsrecursive queriescommon table expression
Hierarchical queries using the non-standard START WITH ... CONNECT BY Oracle syntax are supported in CUBRID.
Recursive CTEs are also supported by Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID and MySQL 8.0.1+,.

Stored procedure

stored proceduresproceduresdatabase procedures
The only stored procedure language supported in CUBRID is Java, requiring a Java virtual machine to be installed on the system.

SOFA Statistics

SOFA
SOFA Statistics
It has a graphical user interface and can connect directly to MySQL, PostgreSQL, SQLite, MS Access (mdb), Microsoft SQL Server, and CUBRID.

Open-source software

open sourceopen-sourceopen source software
CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.

Relational database management system

RDBMSrelational database management systemsrelational database
CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.

Object-relational database

object-relational database management systemobject-relationalORDBMS
CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.

Naver (corporation)

NaverNHNNaver Corporation
CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.

Web application

web-basedweb applicationsweb app
CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.

Application programming interface

APIAPIsapplication programming interfaces
CUBRID APIs and GUI tools have the Berkeley Software Distribution license in which there is no obligation of opening derivative works.

Berkeley Software Distribution

BSDBSD Unix*BSD
CUBRID APIs and GUI tools have the Berkeley Software Distribution license in which there is no obligation of opening derivative works.

Independent software vendor

ISVISVsindependent software vendors
The reason of adopting two separate license systems is to provide complete freedom to Independent software vendors (ISV) to develop and distribute CUBRID-based applications.

Operating system

operating systemsOScomputer operating system
In case of a hardware, network, operating system or software failure on one of the hosts, the underlying client API automatically fails over to the next host that a user has provided.

Hash function

hashhashinghashes
The data distribution logic among shards lies in CUBRID SHARD, which determines which shard to use for storage or retrieval of data based on a hash or user defined algorithm.

Query plan

access planexecutionexecution path
A query execution plan cache is implemented on the broker in order to skip most of the compilation steps on often used queries.

Cache (computing)

cachecachingcached
A query execution plan cache is implemented on the broker in order to skip most of the compilation steps on often used queries.

Parametrization (geometry)

parameterizationparametrizationparametrized
Because the queries are parametrized during parsing, two queries that differ only by the values of literal constants share the same cache entry.

Constant (computer programming)

constantconstantsconstant declarations
Because the queries are parametrized during parsing, two queries that differ only by the values of literal constants share the same cache entry.

B+ tree

B + -treeB+
CUBRID has support for B+-tree indexes, both single-column and multi-column.

Query optimization

query optimizeroptimizationQuery processing
The query optimizer can use indexes to produce faster execution plans using methods such as:

Database index

indexindexesindexing
Identifying covering indexes

Partition (database)

partitioninghorizontal partitioningpartitions
CUBRID supports horizontal partitioning by range, hash and value lists, with a maximum of 1024 partitions per table.