Databse Approach Advantages and Disadvantages Essay Example for Free

Databse Approach Advantages and Disadvantages EssayEach individual record is represented as a row, and each refer as a column. Entity types are related to each other using1Nmappings, similarly known asone-to-manyrelationships. This model is recognized as the first database model created by IBM in the 1960s. Thenetwork structureconsists of more complex relationships. Unlike the hierarchical structure, it can relate to many records and accesses them by adjacent one of several paths. In other words, this structure allows for many-to-many relationships. Thenetwork modelis adatabase modelconceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice. Example of a Network Model. The network models original inventor wasCharles Bachman, and it was developed into a standard specification publish ed in 1969 by theCODASYLConsortium. Theobject-oriented structurehas the ability to handle graphics, pictures, office and text, types of data, without difficultly unlike the other database structures. This structure is popular formultimediaWeb-based applications.It was designed to work with object-oriented programming languages such asJava. The dominant model in use today is the ad hoc one embedded inSQL, despite the objections of purists who believe this model is a corruption of the relational model since it violates several fundamental principles for the sake of practicality and performance. Many DBMSs also support theOpen Database ConnectivityAPIthat supports a standard way for programmers to access the DBMS. Before the database management approach, organizations relied on commit process systems to organize, store, and process data files.End users criticized file processing because the data is stored in many different files and each organized in a different way. Each file was sp ecialized to be use with a specific application. File processing was bulky, costly and inflexible when it came to supplying needed data accurately and promptly. Data redundancy is an free with the file processing system because the independent data files produce duplicate data so when updates were needed each separate file would need to be updated. Another issue is the lack of data integration. The data is dependent on other data to organize and store it.