jBASE Database Management

This user guide provides an overview of JBC APIs, file structures, Transaction Journaling, Internalization, distributed locks and other tools and utilities of jBASE. It also helps you to quickly understand the operations of jBASE with different configurations.

Dataguard

Dataguard provides high availability, data protection, and disaster recovery for enterprise data. Dataguard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production databases to survive disasters and data corruptions.

File Handling

This section describes the various commands used in jBASE file handling.

jBASE Indexes

In order to speed up retrieval of records by attributes rather than using key, jBASE provides the facility to build secondary indexes on these attributes. These indexes are stored as binary trees (see Appendices for details) which are compiled and stored in a file with the same name as the data file with “]I” appended onto the end.

jBASE Remote File Service

This section provides insight on configuring jBASE Remote File Service (jRFS) driver on application servers to achieve remote access to files present on Database Server to form Multiple Application Server (MAS) architecture.

jBASE Triggers

jBC subroutine defines the action that takes place when a database trigger event occurs. This section shows the subroutine that gets triggered for each of the nine database trigger events.

JDBC Driver

This section provides detailed instructions for the configuration and deployment of the jBASE JDBC 2.0 Driver.

jBASE Distributed Lock Service

This section provides a user guide for the deployment and configuration of the jBASE Distributed lock service for a Multiple Application Server environment.

jBASE Query Language

jBASE Query Language (jQL) is the data retrieval language for jBASE data. This query language uses english-like constructs to selectively retrieve, sort and display data held in jBASE files (or in other databases through the relevant Direct Connect driver). You can use jQL commands directly at the shell prompt or in jBC programs to process data programmatically. This section describes the various jQL command or statements that you can use.

SQL Engine

SQL Engine for jBASE allows you to use a database with external tools and APIs. This section is meant to be used with the jDBC Driver section, which gives a description of how the JAVA API for jDBC can be used with jBASE.  In addition, there is an API for jBASE BASIC that is covered in this section.

jBASE ODBC

Open Database Connectivity (ODBC) is an open standard Application Programming Interface (API) for accessing a database. By using ODBC statements in a program, you can access files in a number of different common databases.