Traditional File Based System (TFBS) is the first and the oldest database system that attempt to computerize the manual filing system. For example, in an organization, a manual files is set up to record all internal and external information include, employee, product, project, and customer. File-based system consists of many file with name label and keep in different location. It causes a lot of problem such as data redundancy, lack of idea integration, data dependence and lack of data integrity or standardization.
There are several advantages of Traditional File Based System (TFBS) :
- No need of external storage
- No need of highly technical person to handle the database
- Processing speed is high as compare to (Data Base Management System) DBMS
There are several disadvantages of Traditional File Based System (TFBS) :
- Provide less security
- Redundancy is more
- Less integrity
- High complexity in updating of database
Data warehouse is focuses on data storage. However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve meta data.
There are 4 type of database system which is :
- Operational databases
- Distributed data
- External databases
- Hypermedia database
0 comments:
Post a Comment