Access Databases Tutorial

Access Databases Tutorial

Access Databases Tutorial

IMS is the granddaddy of all transaction management and database systems. It is made up of a hierarchical database and an online transaction processing system. To know more about online systems, you may want to read one of my previous articles (Types of Processing on the Mainframe: Batch and Online).

Hierarchical Database

The more popular databases today are relational databases. These are made up of tables related to other tables based on specific columns. Examples of relational databases are DB2, Oracle, MySQL and PostgreSQL. IMS is hierarchical in structure. An IMS database is made up of segments arranged in hierarchical order. An example of hierarchical arrangement of data is in XML.

In an IMS database, the topmost segment is called the root segment. Information relevant to the root segment are stored in child segments. For example, you want to store information about a client with many accounts. The top most segment will probably be information about your client, such as name, address, contact number, etc.