Database terms essays

Database terms essays Use short answers and examples to explain the following: Hierarchical Database Model An Operational database collects and stores data that is updated dynamically. This type of database is modified on regular intervals. A database containing account records for customers of a financial institution is an example of an operational database. This database is modified as customers change account information by performing various transactions at different intervals. An Analytical database is used to store data collected at a specific time. The data in this type of database remains constant and almost never changes. Companies conducting surveys or performing research often use this type of database. A marketing company conducting surveys on customers evaluation of a specific product would use an analytical database to store the results of the survey. The hierarchical database model defines hierarchical arranged data. The best way to visualize this type of database model is to visualize an upside down tree of data. In this tree a single table acts as the root of the database with other tables branching out from it. Relationships in a hierarchical database model are thought of in terms of parents and children. A child table has only one parent whereas a parent table can have many children. Links called pointers are use to tie parents to children. A parent will have a list of pointers to each of their children. The child/parent rule ensures that data is accessed systematically. To reach a lower-level table you must start at the root and work your way down through the tree structure to the desired target. The following diagram sho ...