DB2 IntroductionDB2 Tutorial Index DB2 Table Storage Structure
File system is a traditional approach to store the data in the files.
The below will describe that what the file system is:
- 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.
- Access is slow.
- Concurrency is very low.
- Security is very low.
- 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:
- 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.
- Accessing is very faster than compared to the other data storage methods.
- Security is very high when compared to other data management methods.
- 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.
- Concurrency is very high. So that many applications/users can able to access the data concurrently.
- Redundancy is very less when compared to the other systems.
Differences between File system and Database:
|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.||Understanding of the data inside a database is very easy since column names are present.|
|Access is slow.||Access is faster.|
|Concurrency is very low.||Concurrency is very high.|
|Security is very low.||Security high in database.|
DB2 Tutorial Index DB2 Table Storage Structure