| A database model is a structure of a database. It is a | | | | management capability of the relational model. |
| theory describing how a database is structured and | | | | ORDBMSs (Object/relational database management |
| used. A data model also defines a set of operations | | | | systems) are based on the object relational model. |
| performed on the data, thus ensuring a successful | | | | At the center of modern information systems, they |
| custom software development process. There are | | | | add new object storage capabilities to the relational |
| several models including relational model, object model | | | | systems. Software development companies employ |
| and object relational model. Let us learn more about | | | | these new capabilities to integrate management of |
| such models: | | | | complex objects such as geospatial data and |
| Relational Model: | | | | time-series and binary media such as images, applets, |
| Developed by E.F Codd, a relational model allows | | | | audio and video. |
| definition of retrieval operations, integrity constraints | | | | Object-Oriented Model: |
| data structures and storage. Based on the relational | | | | The object-oriented approach is based on the |
| model, RDBMS involves the relations between data | | | | integration of database development and application |
| organized in tables. The properties of the relational | | | | into a seamless language environment and data |
| tables are: | | | | model. In comparison to the relational approach, |
| - Each row is distinct or unique. | | | | object DBMSs have no performance management |
| - Column values are of the same type. | | | | overhead to store or retrieve a hierarchy of objects |
| - Insignificant sequence of columns and rows | | | | that are interrelated. With the help of this approach |
| - Unique name for each column | | | | software development service require less code to |
| Object Relational Model: | | | | build applications. Developers can easily maintain code |
| The object relational (OR) is an evolutionary | | | | bases and use more natural data modeling. Thus, |
| technology that has inherited the flexibility of the | | | | application developers can write complex database |
| object oriented model and the performance | | | | applications with a minimum effort. |