Data processing operations include addition of records from one table or file to another, importation or exportation of files such as spreadsheets and text files, and updating fields of all records or a subset of records in a table. Data processing also involves computations, such as working out the number of days between two dates. A user can also change data by searching a record and entering new values.Know More
Typical forms of data manipulation include changing capitalization of fields, summarizing data, cross-tabulation of records, and identification or removal of redundant or outdated entries. A user may retrieve records for purposes of data validation, which includes ascertaining that the data is useful and not corrupted. He may sort data to arrange it in a preferred order. On analysis, the user collects, organizes, interprets and presents data in a useful form. Selected entries from a database may be retrieved for reporting purposes during data processing.
Aggregation is also a data processing operation and entails the combining of several pieces of data. Aggregation operations also entail the classification of data into various categories. There are at least three methods of data processing: automatic, electronic and manual, with the computerized method being the most current as of 2014.Learn more about Computer Programming
Data compression is needed because it allows the data to be stored in an area without taking up an unnecessary amount of space. Data compression uses a series of algorithms to reduce the amount of real space that the data would normally take up.Full Answer >
Data validation is a checking procedure that a computer carries out automatically to help reduce input errors in data. A common type of data validation is the spell-checker function, which is used to check for spelling and grammar errors when typing in a word processing document.Full Answer >
Some advantages of using spreadsheets are that they make it easier to handle data effectively and allow for a more flexible presentation of that data. Some disadvantages of using spreadsheets are that the data can be easily manipulated, which can be a problem when making financial documents, it can be hard to troubleshoot problems in spreadsheets, collaboration may be difficult and human error can occur with data entry.Full Answer >
Real-time processing is the processing and output of data as soon as input is received. In contrast, batch processing occurs after all input has been received, with the processing and output completed at a specified time. Whether a company decides to use either real-time or batch processing, there are advantages and disadvantages to both methods.Full Answer >