![]() Hierarchical database Organises data in a series of level Network Database Organises data in a series of nodes linked by branches Data warehouse Database that collects information from different data sources. Transaction files also serve asĪudit trails and history for the organisation. Transaction file is used to update the master file. transaction file a collection of transaction records. Relational Database Organises data in a series of related tables report file contains data that has been formatted for presentation to a user. It is createdįrom a high-level programming language, such as Cobol, Fortran,Visual Basic ![]() program file contains instructions for the processing of data. So it set up to be viewed only Consolidated data warehousing Data is organised using consistent naming conventions, measurements, attributes and semantics Subject-oriented data warehousing When a large amount of data is stored across an organisation work file Temporary file in the system used during the processing. It is not active and is not being altered or added to. It is historical and reflects what has happened. The data is being stored in the warehouse and act as a storage device for old data. Read-only data This is data that has been permanently stored and cannot be altered. It is structured this way so you can search effectively about what happened in the past. It is not live and is a snapshot of the transactions that have been completed. Instantaneous occurring or done instantly Historical Data The data needs to be a reflection of the TPS in the past. ![]() Advantages of Real-Time Processing Real-time processing has fewer errors than batch processing, as transaction data is validated and entered immediately. real-time transaction processing This is the immediate process of the data, it provides instant confirmation of a transaction but does require access to an online database. Atomicity This ensures that all of the steps involved in a transaction are completed successfully as a group. Think reserving the same seat in a plane at a check in counter at the airport. ![]() Duplex Allows two devices to transmit and receive data across the same physical link Concurrency This ensures that multiple users access the same data at the same time. Batch transaction processing collects the transaction data as a group, or batch, and ![]()
0 Comments
Leave a Reply. |