190 likes | 593 Views
Outline. Issues with RDBMSOODBMSBenefits, drawbacksMDDBMSBenefits, drawbacksOLAP, MOLAPSummaryQuestions. Relational Databases. Have problems with redundancyCould normalize the data to create a star schema, but this breaks the
E N D
1. OODBMS, MDDBMS Two emerging (emerged?) database technologies, and how they relate to Knowledge Management
Sean Sullivan
100046263
2. Outline Issues with RDBMS
OODBMS
Benefits, drawbacks
MDDBMS
Benefits, drawbacks
OLAP, MOLAP
Summary
Questions
3. Relational Databases Have problems with redundancy
Could normalize the data to create a star schema, but this breaks the “object” across multiple tables, and can introduce artificial keys
Complex queries are difficult or sometimes impossible to write because SQL breaks the relational model
Traditionally, could not represent files such as pictures, audio and video natively (only BLOB)
4. OODBMS: A Solution? Started in the 1980s
Integrates database capabilities with OO programming language capabilities
Makes database objects appear as programming language objects in an existing language (such as JAVA, C++ or Smalltalk)
Relational Model is no longer valid: objects are related through inheritance and polymorphism
More of a persistent programming language than a DBMS
5. Why Object Oriented?