Evolution of File System Data Processing
Manual file systems are accomplished through a system of file folders and filing cabinets
With computerized file systems, a data processing (DP) specialist created a computer-based system to track data and produce required reports
File System Redux: Modern End-User Productivity Tools
Business users widely use spreadsheet programs such as Microsoft Excel to enter data in a series of rows and columns to manipulate data
A common misuse of spreadsheets is as a substitute for a database
Term | Definition - Basic File Terminology |
Data | Raw facts, such as a telephone number, a birth date, a customer name, and a year-to-date (YTD) sales value. Data has little meaning unless it has been organized in some logical manner. |
Field | A character or group of characters (alphabetic or numeric) that has a specific meaning. A field is used to define and store date. |
Record | A logically connected set of one or more fields that describes a person, place, or thing. For example, the fields that constitute a record for a customer might consist of the customer’s name, address, phone number, date of birth, credit limit, and the unpaid balance. |
File | A collection of related records. For example, a file might contain data about the students currently enrolled at Alamo College. |
Problems with file systems challenge the types of information that can be created from data as well as information accuracy:
Lengthy development times
The difficulty of getting quick answers
Complex system administration
Lack of security and limited data sharing
Extensive programming
Â