Databse Approach Advantages and Disadvantages Essay Example for Free

Databse Approach Advantages and Disadvantages Essay Each individual record is represented as a row, and each attribute as a column. Entity types are related to each other using  1:N  mappings, also known as  one-to-many  relationships. This model is recognized as the first database model created by IBM in the 1960s. The  network structure  consists of more complex relationships. Unlike the hierarchical structure, it can relate to many records and accesses them by following one of several paths. In other words, this structure allows for many-to-many relationships. The  network model  is a  database model  conceived 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 was  Charles Bachman, and it was developed into a standard specification published in 1969 by the  CODASYL  Consortium. The  object-oriented structure  has the ability to handle graphics, pictures, voice and text, types of data, without difficultly unlike the other database structures. This structure is popular formultimedia  Web-based applications. It was designed to work with object-oriented programming languages such as  Java. The dominant model in use today is the ad hoc one embedded in  SQL, 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 the  Open Database Connectivity  API  that supports a standard way for programmers to access the DBMS. Before the database management approach, organizations relied on file processing 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 specialized to be used 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 issue 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.