The relational model is the basis for a relational database management system (RDBMS). An RDBMS moves data into a database, stores the data, and retrieves it so that applications can manipulate it.
dynamics 365 sales training courses malaysia
An RDBMS distinguishes between the following types of operations:
- Logical operationsIn this case, an application specifies what content is required. For example, an application requests an employee name or adds an employee record to a table.
dynamics 365 finance training courses malaysia - Physical operationsIn this case, the RDBMS determines how things should be done and carries out the operation. For example, after an application queries a table, the database may use an index to find the requested rows, read the data into memory, and perform many other steps before returning a result to the user. The RDBMS stores and retrieves data so that physical operations are transparent to database applications.
dynamics 365 field service training courses malaysia
Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
Leave a Reply