The DRS 2006 Database Utility (03/23/2002)
The DRS 2006 Database Utility is used to maintain the database used in DRS 2006 system. Here you can view and edit the records in the database. Additionally you can export or import records in three different formats. Database maintenance is accomplished using the Reindex and Repack functions in the tools section.

Database Terms
To understand how to use the Database Utility in a most sufficient way, an understanding of the database terms and their purpose in DRS 2006 is useful. Imagine that you have a room with a file cabinet in it. This file cabinet is our DRS 2006 database cabinet and contains all of our database files.

When you open the file cabinet you have access to each database and the records the database contains. Depending on the database structure it will usually contain an index, records and tables.

Index
An index determines the order of the records in a table. There are differences in the way indexes work and what information is required to define the index in different database systems.

Tables
Data in a database is organized in tables. A table name has meaning only within the database. Tables are accessible to DRS2006 in rows (records) and columns (fields). The rows are ordered by an index.

Records (Items)
A record (in DRS 2006 we use the expression item) is a single entry in the database that contains the fields. There may be just a single field in the record or it may contain several fields.

Fields
A field can contain various types of text or numerical data. The DRS 2006 Analyzer database (Analyzer.dbf) contains nine fields. The field names listed in the Analyzer.dbf database are Month, Day, Year, Ctime, Artist, title, Time, Type and comment.

The DRS 2006 Database Utility
Click the Database Utility module in the DRS 2006 Launcher to start using the Database Utility.

The Screen Layout
The screen is divided into four basic sections. They will be referred to as the Menu Tool Bar, Database ToolBar, Database Window and the Records Window.

Menu Tool Bar
The very top of the screen is the menu tool bar. It contains four main menus, Database, tools, Window and Help. There are sub menus in each main menu.

Database
The sub menus for the Database are: Open DRS 2006 Database (shortcut F2) , Close DRS 2006 Database, Save and Exit (shortcut Alt+X).

Tools
The sub menus for the Tools are: Reindex Table, Pack Table, Export Data, Import Data, Search and Replace.

Window
The sub menus for the Window Menu are: Cascade, Tile Horizontal, Tile Vertical, Minimize All.

Help
The help menu will open the DRS2006 information window. This Window contains information and web links that can be clicked on to connect to the DRS 2006 web site.

Navigating
When the DRS 2006 Database Utility first opens it will automatically connect to your database. On the left side of the screen under the Database Toolbar is the Database Window. It displays the different database files that are in DRS 2006.

To move between the files you have two options. You can select the database with your left mouse button, or you can use the Up/Down arrow keys of your keyboard. The scroll control on the right side of the window will move to the last database file or to the first database file when using the arrow bar on the right. As you move through each database you will see the records change in the Records window.

You can resize the window by moving your mouse to a narrow location located between the Database Window and Records Window. The mouse pointer will change the appearance of the arrow icon of the mouse into a small icon that has two vertical lines with two arrows pointing in each direction. Once the mouse appearance has changed, hold down the left mouse button and drag the window to the left or right. When you have it the size you want, release the mouse button.