DB2 Introduction

Db2 Tutorial Topics Index DB2 Table Storage Structure

Advertisements


File System:

File system is a traditional approach to store the data in the files.

The below will describe that what the file system is:

o Understanding of the data inside a file is very difficult since no column headings are not present until or unless it is mapped with the copybook layout.

o Access is slow.

o Concurrency is very low.

o Security is very low.

DB2:

  • DB2 is well known as Data base 2 which is introduced by IBM.
  • It is known as Relational database (Relational is nothing but the data stored will have a relation in between)
  • The relational data stored in format of TABLE which contains Tuples (ROWS) and the row consists of Attributes (COLUMNS).
  • It is almost similar to the SQL (Structured Query Language) but with some additional features.

Advantages with DB2:

  1. Understanding of the Data in the tables are very easy when compared to the other data management methods hence it has predefined Attribute names in it. So anyone can able to understand very easily by relating the data.
  2. Accessing is very faster than compared to the other data storage methods.
  3. Security is very high when compared to other data management methods.
  4. Independency is very high when compared to other data management methods. For example, adding the new attributes is only required to create the DCLGEN sufficient. No other changes required apart from that.
  5. Concurrency is very high. So that many applications/users can able to access the data concurrently.
  6. Redundancy is very less when compared to the other systems.

Differences between File system and Database:


If any questions on the above, post your queries on DB2 Discussion forum


Db2 Tutorial Topics Index DB2 Table Storage Structure

Advertisements