Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Introduction to Manual

Manual Contents

The contents of the CUBRID Database Management System (CUBRID DBMS) product manual are as follows:

  • Getting Started with CUBRID : The "Getting Started with CUBRID" provides users with a brief explanation on what to do when first starting CUBRID. The chapter contains information on new features added to CUBRID, on how to install and execute the system, and provides a simple guide on how to use the CSQL Interpreter and CUBRID Manager. The chapter also includes examples of how to write application programs using JDBC, PHP, ODBC, CCI, etc.
  • Introduction to CUBRID : This chapter provides a description of the structure and characteristics of the CUBRID DBMS.
  • CSQL Interpreter : CSQL is an application that allows you to use SQL statements through a command-driven interface. This chapter explains how to use the CSQL Interpreter and associated commands.
  • Administrator's Guide : This chapter provides instructions on how to create, drop, back up, restore, migrate, and replicate a database. Also it includes instructions on how to use CUBRID utilities, which starts and stops the Server, Broker and CUBRID Manager servers, etc.
  • Performance Tuning : The "Performance Tuning" chapter provides instructions on setting system parameters that may influence the performance. This chapter provides information on how to use the configuration file for the Server, Broker and CUBRID Manager and describes the meaning of each parameter.
  • CUBRID SQL Guide : This chapter describes SQL syntaxes such as data types, functions and operators, data retrieval or table manipulation. The chapter also provides SQL syntaxes used for indexes, triggers, partitioning, serial and user information changes, etc.
  • CUBRID Manager : The chapter provides instructions on how to use the CUBRID Manager, which is a GUI (Graphic User Interface) mode database management and query tool. The CUBRID Manager makes the easy handling of numerous management tasks possible and also provides a "query editor" function, which can execute the SQL syntax in the connected database.
  • API Reference : This chapter provides information on JDBC API, ODBC API, OLE DB API, PHP API, and CCI API.
Manual Conventions

The following table provides conventions on definitions used in the CUBRID Database Management System product manual to identify "statements," "commands" and "reference within texts."

Convention

Description

Example

Italics

Italics type is used to show the variable names.

persistent:
stringVariableName

Boldface

Boldface type is used for names such as the member function name, class name, constants, CUBRID keyword or names such as other required characters.

fetch ( ) member function
class odb_User

Constant Width

Constant Width type is used to show segments of code example or describes a command's execution and results.

csql database_name

UPPER-CASE

UPPER-CASE is used to show the CUBRID keyword (see Boldface).

SELECT

Single Quotes (' ')

Single quotes (' ') are used with braces and brackets, and shows the necessary sections of a syntax. Single quotes are also used to enclose strings.

{'{'const_list'}'}

Brackets ([ ])

Brackets ([ ]) indicate optional parameters or keywords.

[ONLY]

Underline( _ )

Underline (_) indicates a default keyword if no keyword is specified.

[DISTINCT|UNIQUE|ALL]

Vertical bar( | )

Vertical bar (|) indicates that one or another option can be specified.

[COLUMN|ATTRIBUTE]

Braces around parameters({  })

Braces around parameters indicate that one of those parameters must be specified in a statement syntax.

CREATE {TABLE|CLASS}

Braces around values({ })

Braces around values indicate that every value is a member of the same set.

{2. 4, 6}

Braces with ellipsis({ }...)

Braces before an ellipsis indicate that a parameter can be repeated.

{, class_name}...

Angle brackets(< >)

Angle brackets indicate a single key or a series of key strokes.

<Ctrl+n>