History of Relational Database

Hao-Wei He Wilmington University October 9, 2010 Abstract infobase agreement have been inseparable with our daily life, since IBM demonstrable the hierarchical randomnessbase concern trunk in 1969, entropybase system has been innovated many times, such as hierarchical infobase, meshing infobase, comparative database, and object-oriented database. Nowadays, relative database still is the more or less popular example wontd by diametrical industries this word is going to introduce the history of the relative database.History of comparative informationbase information, which washstand be outlined as an entity of meaning, it is the original material to make message and knowledge. Thanks to the assistance of computer, data touch practices reached several important milestones. The earliest way to break in data ar done by means of manual tear management, altogether documents depart be pointd and then(prenominal) store, merely this method had many processin g restrict, such as search, transshipment center takes up a lot of space, and can non be assenting by people at the corresponding time.After IBM announced the first set of knockout disk depend on for data storage in 1956, due to the innovate exploitation of hard drive, and the access speed more than faster than magnetic tape, it replaced the tape drive gradually, and then direct access buck system developed. Although direct access file system could access each files now and improved a lot of missing, still since the objects be files, it still lack of tractableness of processing. entropybase can be considered to automatically doubtfulness 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 mass data storage, are widely used in all inspects of applications. The advantages of database management system * Reduced periphrasis * Integrated data * I ntegrity * Data commonality * Protect data gumshoe and privacy The disadvantages of database management system * general operating cost will extend * More complex to use expect to backup regularly, or unexpected conditions will cause serious data hurt * Hard to training database administrator * delicate to integrate or manage different format from multi systems Therefore, there was an idea round divide files into a sum of exhibit, and store it as an unit in the computer, it as well as formed the Centralized Database System, it can record a record through hard disk drive, and can immediately navigate to the record or field for further data processing and computing.This notion also derived to the following data types * gradable Data place (1960s) Use record as a processing unit, and arise record by point expression. As a result of the characteristic of shoetree structure, hierarchical data exemplification especially suitable for describe One to legion(predicate) dat a composition relationship but Many to Many relationship. * Network Data Model (1970s)As a result of the tree structure does not reflect network connection relationship amongst 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 link to strung together, so when programme applications must accommodate the structure term between links, a lot of dependencies between programming applications and data structure, and the independence of data is hard to reach, cause the system rocky 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 leading the development of the database system entered a refreshing milestone. In relational data model, data use record as a processing unit, and organize record in tabular form.The applications just face to the tabular structure, without to understanding the internal structure of the data. closing Relational Database focussing System (Relational DBMS) is the most widely used database management system in recent years, the mainly fence is the concept of relational data models is simple, and the staple fiber theory 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 lots hear of the data table, is a relational database foundation.References Yung-Fang Chen, Relational Database management system lecture, Retrieved from http//allen. chen. make water/teachdata. htm Jeffrey H. , Mary P. , & Heikki T. (2009). Modern Database Management 9th Edition. Upper Saddle River, NJ Pearson Shou-Jeng Tseng. inspection Database System and Future Research Develop. Taiwan, Retrieved from http//www. iicm. org. tw/ conversation/c1_1/page02. html.