database program

(redirected from Database system)
Also found in: Dictionary, Thesaurus, Medical, Acronyms, Wikipedia.
Related to Database system: database management system

database program

Software that is used to manage data and information structured as fields, records and files. A database program is the heart of a business information system and provides file creation, data entry, update, query and reporting functions. The traditional term for database software is "database management system" (see DBMS). For more about database structures, see DBMS, field, record, file, database and database schema.

User Interaction with a Database


Database programs let users create and edit single files interactively at the keyboard. However, as soon as they want data in one file to automatically update another, programming has to be done. That is where the faint of heart take their leave, and the techies take over. Following are the common interactive tasks.

Create a File (Table) and Set Index Order
Each field in a record is defined by name, type and length. In order to keep the file, also called a "table," in sequence, one or more fields are defined as key fields, upon which indexes are created and maintained. The index is updated whenever records are added or deleted or any data in a key field changes.

Create Data Entry Forms
Data entry is accomplished by designing a form to display each record. Data entry forms contain field validation, which determines what data can go in and what cannot.

Update/Edit
In a single-user, one-file-at-a-time application, there is nothing to predefine here. Changing data is a matter of opening the file and selecting the EDIT mode. However, in a multiuser system, security must be administered and audit trails must be programmed.

View/Query
Browse an entire file or select records. Selected records are usually created as a temporary file that can be sorted into a different sequence and, after viewing, can be deleted or saved for later use.

The ease with which a query can be composed determines how often users ask their own questions versus relying on IT staff. For example, retrieving data from two files, such as customers and orders, or vendors and purchases, requires knowledge of how to link the files for the query. Most database programs have a JOIN function, which creates a new file with data from two existing files. Once a query has been composed, it can be saved for use again.

Reporting
Reports provide details and summaries in a more elaborate fashion than queries. Reports have page and column headers and can be sorted into order by multiple fields; for example, city within county within state. Once a report description has been composed, it can be saved for use again.

Modify Structure
From time to time, it is necessary to add or delete fields, or change their lengths or possibly their names. This function is similar to creating the record structure in the first place, except that only modifications are made.



References in periodicals archive ?
Among the front-line agencies and government-run corporations prioritized for inclusion in the National Database System are: the Philippine Health Insurance Corporation (PHIC), Home Development Mutual Fund or PAG-IBIG Fund, Social Security System (SSS), Government Service Insurance System (GSIS), National Bureau of Investigation (NBI), Philippine National Police (PNP), Land Transportation Office (LTO) and the Office of Consular Affairs of the Department of Foreign Affairs (DFA).
A Materials Database Working Group was established under the ASME Committee on Materials and meets quarterly to oversee the design, development, and implementation of the database system.
The chapter on database systems and the Web has been updated
This company implemented a relational database system for storing documentation files.
It would have taken days to compile all of the statistics on the building before the network and database system was created.
In the field of computer science, the subfield of database systems is devoted to the study of the problems of managing large volumes of data, with "large" defined informally as a function of the computing power and storage capacity available at a given point in time.
EnterpriseComputing Database System currently includes 12 databases which feature news and editorial from various IDG publications, as well as market research and analysis from IDG market research companies.
Covering the traditional database system concepts from a systems perspective, this book addresses the functionality that database systems provide as well as what algorithms and design decisions will best implement their functionality
The database system stores all CV registrations and applications and allows them to be fully searchable using Boolean technology.
Both INGRES and System R were selected by the ACM Awards Committee in recognition of "their pervasive impact on database system research and the development of commercial database products.
The Vertica Database[TM] is the most important breakthrough in database system design in two decades, and that's why I chose to join Vertica from among the many database startups seeking my involvement," said Dr.
That means processing the transferred data through the file or database system that controls the placement of data on storage.