The Database Services Interface

The database services interface provides communication between the RDBMS and the other two tiers. It consists of the following components:

  • The Database Server (ladb)

  • The database APIs

  • The database drivers

The Database Server (ladb)

The Database Server (ladb) is the main server engine. It analyzes and manages user requests, determines which database to access, and spawns database drivers. The ladb also notifies other servers of terminated database users.

Database (4GL) APIs

Presentation and application programs use Application Program Interfaces (APIs) provided by the Lawson system to communicate with the database. These APIs perform a set of functions such as finding a single record, summing each of three columns in a table, or deleting a set of records.

The Database Driver

The Database Server (ladb) communicates with the relational database management system (RDBMS) through database drivers. The driver translates Lawson 4GL Database APIs into native RDBMS SQL commands. The database driver is specific to the RDBMS you use. The following database driver is associated with the Oracle server:

Database Server Database Driver
Oracle

oradb11

oradb12

The Database Utilities

Several utilities are connected with the database driver to provide additional data access and management services. They are:

  • verifyora11/verifyora12

    Compares Lawson dictionary descriptions to the expected translations in Oracle to ensure the Oracle database definitions match the Lawson dictionary.

  • bldora11ddl/bldora12ddl

    Generates SQL statements for creating or deleting selected tables, indexes, and stored procedures. The utility can operate on specific tables, all tables in a system code, or all tables in a data area.

  • bldora11sec/bldora12sec

    Duplicates Lawson table level security in the Oracle database.

  • dbatables11/dbatables12

    Populates the storage parameter tables (law_dba_table and law_dba_index).

  • ora11du/ora12du

    Calculates the space needed for an initial number of records in the database, using information found in the Lawson dictionary and both law_dba_table and law_dba_index.