Creating a Database

A database is the foundation of an mvBase application. It provides a way to organize and use business data in a logical and efficient manner. Once a database exists, you can use INFO/ACCESS to generate reports that extract information for end users. Application developers can write custom programs in the mvBASIC language that provide the end-user with an integrated, task-oriented environment. Using menus, users can perform a variety of database management tasks, such as selecting reports, adding new items to the database, or updating existing items.

An application might be based on one or more files, each one containing a logical grouping of data. These files may be available in any or all accounts on the system. The term database refers both to an individual file and to all of these files collectively that are associated with an application.

This section examines the procedures involved in designing and creating a simple database consisting of a single file. The following topics are presented in this section:

Designing a Database

Creating a File

Extracting Information

NOTE

For the system privilege level required to perform the above steps, see mvBase Database Architecture.

See Also

Guide to mvBase Files and Accounts Overview

Syntax Notations

Using the Terminal Control Language

mvBase Database Architecture

Managing Files

Creating and Deleting Accounts

Managing Accounts

Backing Up Files

Restoring Files and Accounts

Using the BTREE File Structure System

Using the SYSPROG Account and Commands

Using User Accounts and Commands