Transaction Processing Systems

Transaction Processing SystemsThe chief(prenominal) information dodgings utilize for operational support in a business argon exertion process systems. This type of system processes info just about transactions, which argon events that fix occurred that affect the business, such as the sales event or purchase of goods.A transaction treat system has 3 main purposes keep records about the state of an organization, process transactions that affect these records, and make grow getups that report on transactions that have occurred. For example, an roll control system tracks records about fund, processes sales and purchases of enrolment, and produces reports about the amount and value of items on hand, on order, etceteraTransaction impact systems exist in all aras of an organization, and in all types of organizations. TPSs can be utilise by employees (order entry) or customers (bank ATMs). They can riding habit various types of hardware, software, and networks. TPSs use stored info in both files and databases, and nigh types of programs.TPS structureThe structure of a TPS generally consists of a user or other TPS that interacts with TPS software, and stored data used by the TPS. Users of the system are typically personnel who work with business transactions, such as salespeople. insert data comes from users and other TPS. Output includes data back to other TPSs, screens, and reports.TPS kick the bucketsLike other information systems, TPSs discharge four main functions commentary, processing, payoff, and data storage. The input function accepts data for processing from distant the system. The processing output transforms the data in some way. The output function makes the processing results available outside the system. The storage function stores the data for use.Before transaction data can be brought into a TPS, it must be acquired from its source. This cadence is called data capture. The receiving report is an example of a source docume nt that is used to perform data entry. information entry means using a screen similar to the one(a) in this figure to inclose data. Once the data is entered, a program checks it for errors, a process called data validation. For example, inventory receiving data big businessman be checked to ensure that all number entries are numeric that the item is known to the system, and that quantities are in acceptable ranges.Much output from a TPS is in the form of reports. Several types of reports are ordinarily produced by TPSs. A detailed report dips details about transactions, such as inventory movement. A summary report summarizes data at various levels. Exception reports indicate data that are exceptions to some condition or standard.Data in a TPS is stored to data files and databases. Two types of stored data are comm moreover found in TPSs transaction and master data. Master data is the main data used by the TPS. Master data is usually permanent data that remains in the system a s spacious as the system is in use. For example, an inventory system would have an inventory master file with one record for each item in inventory. Transaction data is data about transactions that have occurred. Transaction data usually remains with the system only until the transactions are processed. The transaction data is whence replaced with other transaction data for new transactions. For example, in the inventory control system, a transaction file would contain data about inventory transactions. That data would be used to modify the inventory master file. Once the update was complete, the transaction file would be cleared and a new list of transactions would be started.After the data is created, the TPS can retrieve data from the file or database, a process called irritateing the data. The data is accessed to produce reports, update master files, and other purposes. Some durations, before a TPS can access data, it must be arranged in an order that is useful to the system , a process called sorting. For example, the inventory system may produce a report of the 5 most expensive items. The item list should then be sorted in descending order of cost.The data put into a file or database when it is created will become obsolete over time. The TPS must update the data periodically to keep it current. update can involve adding new data, changing current data, and deleting old data. Transaction data is used to update master data.Processing involves manipulating data within the system. virtuoso function that just involves data processing and non any of the other functions is computation, such as calculating details and counts. Another processing function is conclusiveness making, or checking for conditions and acting on them.TPS ControlsTPSs must have procedures to ensure the completeness of the data processing, and to minimize the chance of errors. In general, these procedures are called controls. Many types of controls are used, including control totals, audit trails, and comforter and convalescence procedures.All data in a TPS may not be processed for various reasons, including hardware and software losers, and human error. One way that a TPS checks that all data is processed is through control totals. A control total is a number that is computed when data enters a system, and again after the system has processed the data. For example, in the inventory control system, a number reflecting an initial count of receiving reports to be entered would be entered into the system. After the receiving reports are entered, a count of the documents entered would be produced. There are also other types of control totals. Document counts are only one type.An audit trail is a way of tracing the effect of data through a system. A good audit trail is one in which someone can start with the output and go back through the system to the source document and vice versa. For example, the inventory receiving system could produce a report of all item co unts. This could be used to trace each item have back to its receiving report source document.Computer systems sometimes fail, causing a loss of corruption of data. The failure may be caused by a malfunction in the hardware or software, or because of something outside the system, such as a lightning strike. The main way of ensuring against loss of data is to use a backup procedure. This means copying important data and programs to a portable media and moving it somewhere away from the main computing site. Important files and databases are usually backed up daily or weekly.The backup of the stored data can be copied back to the system, a process known are restoring the data. If a system fails, recovery procedures tell the computer professionals how to use the backups to recover from a crash.Modes of Data ProcessingData in a TPS can be processed using two basic approaches batch and online processing. A TPS may use both online and batch processing. In batch processing, data for all t ransactions to be processed are prepared in form understandable to the computer before actual processing begins. Then the batch of data is processed by the computer, and the resulting output is received in a batch. An example of batch processing is overnight payroll check processing and printing.With online processing, or OLTP, a person uses a screen and keyboard or I/O device connected to the computer at the time the processing is done. Each particularise of data for a transaction is entered directly into the computer. The data is processed, and the output is received before the next input data is entered. Online processing may also be called interactive processing. An example of online processing is an airline taciturnity system.The term real-time may also be used to indicate online processing. Real-time means the processing is performed immediately after the data is entered. This description is not quite accurate for online processing. If there are legion(predicate) users of a n online system, processing may not begin for some time after the input is received. The amount of time depends on the hardware, software, and number of users. One example of a real-time system is a manufacturing monitoring system. If cars are being manufactured and theres a problem with the computerized assembly line, the system alerts operators immediately.