A software application that allows for the management of data and information structured as fields, records and files. Database programs provide a way of creating and manipulating the electronic equivalent of a name and address card that can hold large amounts of information.
Because all data are structured into a one- record-per-subject or one-record-per-transaction format, it allows for powerful query capabilities, in which you can select records based on any of their content. A database program is the heart of a business information system and provides mainly file creation, data entry, update, query and reporting functions.
The traditional term for a database program is a database management system (DBMS). It is also called a "data management system." For more details on the features of a DBMS, see DBMS. Also see application software for a breakdown of all major software applications.
User Interaction with a Database Program
The database programs available for Windows and Mac let you perform all the following tasks interactively on one file at a time. However, as soon as you 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 hackers take over. Following are the common tasks you need to perform to create and work with a database file.
Create a File and Set Index Order
Each field in a record is defined by name, type and length. In order to keep the file in sequence, one or more fields are defined as key fields, upon which indexes are created and maintained. The index is updated whenever new records are added or existing records are 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. You decide what data can go in and what must stay out of these fields.
Update/Edit
In a single-user, one-file-at-a-time application, there is nothing to predefine here. Changing data is just 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
You can browse an entire file or just selected records. Selected records are usually created as a temporary file that can be saved or abandoned. The temporary file may be sorted into a new sequence if desired.
The ease with which a query can be composed determines how much users will ask their own questions or rely on their IT staff to create them. Getting data from two files; for example, 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 description has been composed, it can be saved for use again.
Reporting
Reports provide details and summaries in a more elaborate fashion than queries. They have page and column headers and can be sorted into order by multiple fields; for example, county within city 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 you are editing the structure rather than defining it from scratch.
Because all data are structured into a one- record-per-subject or one-record-per-transaction format, it allows for powerful query capabilities, in which you can select records based on any of their content. A database program is the heart of a business information system and provides mainly file creation, data entry, update, query and reporting functions.
The traditional term for a database program is a database management system (DBMS). It is also called a "data management system." For more details on the features of a DBMS, see DBMS. Also see application software for a breakdown of all major software applications.
User Interaction with a Database Program
The database programs available for Windows and Mac let you perform all the following tasks interactively on one file at a time. However, as soon as you 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 hackers take over. Following are the common tasks you need to perform to create and work with a database file.
Create a File and Set Index Order
Each field in a record is defined by name, type and length. In order to keep the file in sequence, one or more fields are defined as key fields, upon which indexes are created and maintained. The index is updated whenever new records are added or existing records are 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. You decide what data can go in and what must stay out of these fields.
Update/Edit
In a single-user, one-file-at-a-time application, there is nothing to predefine here. Changing data is just 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
You can browse an entire file or just selected records. Selected records are usually created as a temporary file that can be saved or abandoned. The temporary file may be sorted into a new sequence if desired.
The ease with which a query can be composed determines how much users will ask their own questions or rely on their IT staff to create them. Getting data from two files; for example, 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 description has been composed, it can be saved for use again.
Reporting
Reports provide details and summaries in a more elaborate fashion than queries. They have page and column headers and can be sorted into order by multiple fields; for example, county within city 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 you are editing the structure rather than defining it from scratch.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- JavaScript 2.0: Why Give Programmers Crutches?
- [Guest Comment from Shane Steinert-Threlkeld] A new spec on which JavaScript 2.0 will be based , should be finalized by the end of the fall. Yet most of the proposed changes do close to nothing to actually improve the language. A lot of...
- Blog posts 2008-08-29
- Cool Tools - What is your Twitter grade?
- HubSpot has launched what it is calling the Twitter Grader, which seems to be the now-defunct Tweeterboard reincarnate -- yet with a proposed business purpose. The grader allows Twitter users to enter in their screen names and the names of others into its secret algorithmic stuff generator and find out...
- Blog posts 2008-08-29
- Green Plug snags heavy hitter for board
- Who says green tech isn't rocket science? Starting Sept. 1, green tech start-up Green Plug, which is pushing for the concept of a universal power converter, has appointed former White House advisor George Keyworth as the chairman of its board of directors. Keyworth was Science Advisor to...
- Blog posts 2008-08-29
- The biggest health tech story of our time
- It's the sort of work politicians have been doing for decades, only with much greater depth, because the database is deeper, and with a purely scientific motivation. by Dana Blankenhorn
- Blog posts 2008-08-29
- Weekend Gadget Guidance: Speed up Vista installation via thumb drive
- It's Labor Day weekend. Have you given your computer a fresh Windows install for the holiday? (If you're the kind of guy or gal who's into periodically wiping your hard drive, this tip's for you.) The How-To Geek over at Lifehacker recently posted a...
- Blog posts 2008-08-29
- MSD Organizer Freeware (zip)
- MSD Organizer Portable Freeware is a personal and professional information manager to be installed in Pen Drives, with the following modules: Calendar, Contacts, Alarms, Tasks and Cards. It also provides the following tools: backup and restore, word processor, spreadsheet, image viewer, calculator, and financial calculator. The program will allow you...
- Software downloads 2008-08-29
- Family E-Mail Spoofer Free Version (zip)
- Wind your family and friends up with our great new program Family E-Mail Spoofer. With our program you can send spoofed emails To anyone and FROM anyone with the click of a button. You could send an email from the Queen or even President Bush,its up to you. Family E-Mail...
- Software downloads 2008-08-29
- Why does Safari stink?
- Why does Safari stink?Safari on iPhone is even worseSafari on a Mac should work at least as well as Firefox. but on the iPhone it crashes regularly or locks up the iPhone. And it appears Apple's licensing is designed to preclude any competition:"Apple's software requirements for the device are too...
- Discussion threads 2008-08-28
- PC Bug Cleaner (exe)
- PC Bug Cleaner is suggested by experts that over time, your system, through additions and deletions and amendments, will cause your Windows registry to become fragmented, corrupted or full of errors causing all sorts of problems and issues. Are you getting annoying error messages repeatedly or feeling your computer is...
- Software downloads 2008-08-28
- Free KPMSS Persistent Process Stopper (exe)
- Target several processes to be send the exit signal repeatedly. It is simple to use and will surely be a useful tool to remove viruses that have multiple processes that automatically restart each other. Program features: sends an end signal to chosen the processes 20 times a second, easily see...
- Software downloads 2008-08-28
- FTP Password Recovery (exe)
- FTP Password Recovery is a program that will show your forgotten FTP passwords. This FTP password finder is very easy to use and can recover passwords from FTP instantly. This tool can recover passwords from CuteFTP, Core FTP, FFFTP, FlashFXP, FileZilla, Total Commander, WS_FTP, WinSCP. This version is the first...
- Software downloads 2008-08-28
- Redirect Page Creator (zip)
- Redirect Page Creator creates stand alone Web pages that gives Webmasters the ability to redirect visitors to other Web sites. This program uses meta refresh technology to accomplish redirecting the visitor. A Webmaster simply enters the destination URL then saves the code generated by this program. Finally the page is...
- Software downloads 2008-08-28
- WWD Backup Widget (exe)
- The World Wide Data Backup Widget is a Windows based application. It allows you to upload and download files, create folders, drag and drop files and schedule backups. Users will need a subscription to the World Wide Data Storage network to use the widget. This program provides basic backup functions....
- Software downloads 2008-08-28
- iPod Deleted Data Recovery Tool (exe)
- Recover iPod Apple, Shuffle, Mini, Nano and portable media player songs, music files. Data Doctor iPod recovery software is the best solution to restore your iPod deleted files. This advanced files retrieval tool support restoration of hard drive-based iPod Classic data. Undelete utility retrieves the touch screen iPod Touch, the...
- Software downloads 2008-08-28
- Oncilla Excel2Text (exe)
- Oncilla Excel2Text is a tool to convert Excel files to Text files. The Text files can be in any of the following formats UTF8, ANSI or Unicode little endian. The tool lets you perform this conversion with out using MS Excel, it does not require that MS Excel be installed...
- Software downloads 2008-08-28
- X-Lizard PM (exe)
- X-Lizard is a simple, compact and reliable management application, specifically designed to store your confidential data, such as usernames, passwords, and pin codes. X-Lizard will allow to get easy and simple access to records, quickly to edit records containing names and the passwords, one click of the mouse will reproduce...
- Software downloads 2008-08-28
- FFFTP Password Recovery (exe)
- FFFTP Password Recovery is a program that will show your forgotten FTP passwords. This FTP password finder is very easy to use and can recover passwords from FFFTP instantly. FTP sites can be exported to a URL list file. This version is the first release on CNET Download.com.
- Software downloads 2008-08-28
- MegaCrammer (msi)
- MegaCrammer is essential for the student who wants to get ahead. MegaCrammer allows users to create personalized tests to suit their specific needs. After easily entering the material into MegaCrammer, the program creates a unique test that automatically changes each time it is taken. MegaCrammer will grade the tests and...
- Software downloads 2008-08-28
- Easy Tracker 2008 Enterprise (exe)
- Easy Tracker 2008 Enterprise edition is a full-featured time and expense tracking suite designed specifically for project & expense management, schedule notification and work measurement. Basing on SQL server database, it suits teams and companies specially. It provides convenient task assignment and timesheet entries for team members; simple approving process...
- Software downloads 2008-08-28
- CrazyContrast (zip)
- Crazy Contrast is another crazy prank program from MAXIMA Productions. It will change your monitor contrast level every 1 second, so your monitor will be flashy. Great program to prank your friends. To stop the prank: move your mouse to the left-corner of the screen until a window appears. This...
- Software downloads 2008-08-28
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Sports and Technology
-
Major League Baseball pitches new app to iPhone users
At Apple's Worldwide Developers Conference in San Francisco, Jeremy Schoenherr of MLB.com demos At-Bat, a new iPhone app from Major League Baseball.
View the ZDNet video to learn more -
The SF Giants' new hi-tech ballpark
SF Giants CIO Bill Schlough discusses new technology upgrades at AT&T Park and outlines his dual role- managing technology operations at the backend while using hi-tech to improve player performance on the field.
View the ZDNet CIO Vision Series video - From our Sponsors
- Fantasy Football
-
-
3 Great Ways To Play Fantasy Football
Play for free, play to win cash prizes- up to $3500, or customize your own league.
Learn More » -
