History of Relational Database

Hao-Wei He Wilmington University October 9, 2010 Abstract entropybase transcription have been inseparable with our daily life, since IBM certain the hierarchical database circumspection system in 1969, database system has been innovated many times, such as hierarchical database, network database, relational database, and object-oriented database. Nowadays, relational database still is the more or less popular poseur used by different industries this article is leaving to introduce the history of the relational database.History of Relational infobase information, which can be delimit as an entity of meaning, it is the original material to construct message and knowledge. Thanks to the service of computer, data bear on practices reached several important milestones. The earliest way to stick in data be done through manual file commission, entirely documents will be filed and then store, but this method had many process restrict, such as search, storage takes up a lot of space, and cannot be admission by people at the same time.After IBM announced the counterbalance set of hard disk drive for data storage in 1956, due to the innovate development of hard drive, and the admission charge speed oftentimes faster than magnetic tape, it replaced the tape drive gradu exclusivelyy, and then direct access file system developed. Although direct access file system could access each files straightway and improved a lot of missing, but since the objects are files, it still lack of flexibility of impact. Database can be considered to automatically wonder and modify data sets.There are a variety of database types from the simplest store all kinds of information forms to large-scale database systems that able to process a variety of spate data storage, are widely used in all inspects of applications. The advantages of database management system * Reduced redundancy * Integrated data * Integrity * Data commonality * Protect data safety and privacy The dis advantages of database management system * Overall operating cost will increase * More intricate to use Need to backup regularly, or unexpected conditions will seduce serious data damage * Hard to training database administrator * unmanageable to integrate or manage different format from multi systems Therefore, there was an base about divide files into a sum of land, and store it as an unit in the computer, it also formed the Centralized Database arranging, it can tape a record through hard disk drive, and can directly navigate to the record or fields for further data processing and computing.This concept also derived to the following data types * hierarchic Data gravel (1960s) Use record as a processing unit, and organize record by manoeuver bodily building. As a result of the characteristic of tree structure, hierarchical data model particularly suitable for describe iodine to some data composition relationship but Many to Many relationship. * Network Data lesson (1970s)As a result of the tree structure does not reflect network connection relationship between data and data, so after hierarchical data model, some groups proposed Network Data Model, organize records by network structure. However, records in both Hierarchical data model and network data model use contact to strung together, so when programming applications must accommodate the structure term between links, a lot of dependencies between programming applications and data structure, and the license of data is hard to reach, cause the system difficult to maintain. Relational Data Model (1970 present) Edgar Codd, a British computer scientist, proposed Relational Data Model in 1970, emphasize the applications should not have any dependencies with internal structure of data, it also known as Data Independence, this data model lead the development of the database system entered a new milestone. In relational data model, data use record as a processing unit, and organize record in t abular form.The applications just face to the tabular structure, without to understanding the internal structure of the data. Conclusion Relational Database guidance System (Relational DBMS) is the most widely used database management system in late(a) years, the mainly reason is the concept of relational data models is simple, and the basic opening was developed very completely. Since Relational Database management System be proposed in 1970, almost all the commercial database management systems are based on this model.We often hear of the data table, is a relational database foundation.References Yung-Fang Chen, Relational Database management system lecture, Retrieved from http//allen. chen. name/teachdata. htm Jeffrey H. , Mary P. , &amp Heikki T. (2009). Modern Database Management 9th Edition. Upper Saddle River, NJ Pearson Shou-Jeng Tseng. Review Database System and Future search Develop. Taiwan, Retrieved from http//www. iicm. org. tw/communication/c1_1/page02. html.