80 likes | 109 Views
Explore how object-oriented concepts have influenced database design, the advantages and disadvantages of OODBMS, and the potential integration of features from next-generation DBMS. Understand the impact on relational models and the future direction of database technology.
E N D
Object-Oriented DBMS Figure 11.34
How OO Affects Database Design • OO database design approach provides both the data identification and the procedures or data manipulation to be performed. • OO database design forces us to think of data and procedures as a self-contained entity. • OO design is iterative and incremental in nature. • DBA’s role is likely to change with more programming responsibilities. • Lack of standards affects OO database design.
OODBMS: Advantages and Disadvantages • Advantages • More semantic information. • Support for complex objects. • Extensibility of data types. • Improved performance with efficient caching. • Versioning. • Faster development and easy maintenance through inheritance and reusability. • Technology-driven product for next generation DBMS. • Potential to integrate DBMSs into a single environment.
OODBMS: Advantages and Disadvantages • Disadvantages • Strong opposition from the established players. • Lack of theoretical foundation. • Retrogressive to the old pointer systems. • Lack of standard ad hoc query language. • Lack of business data design and management tools. • Steep learning curve. • Lack of resources.
How OO Concepts Have Influenced the Relational Model • New Features for Extended Relational (Object/Relational) Model • Extensibility of new user-defined (abstract) data types • Complex objects • Inheritance • Procedure calls (rules or triggers) • System-generated identifiers (OID surrogates)
How OO Concepts Have Influenced the Relational Model • Philosophy that guides the relational model’s enhancements: • Semantic and object-oriented concepts are necessary to support the new generation of applications. • These concepts can and must be added to the relational model. • The benefits of the relational model must be preserved to protect the investment in relational technology and to provide downward compatibility.
The Next Generation of DBMS • The next generation of DBMS is likely to incorporate features borrowed from: • Object-oriented database systems • Artificial intelligence systems • Expert systems • Distributed database • The Internet