Object Relational Mapping

  • Created by: wreje035
  • Created on: 16-10-18 22:24
Object relational impedence mismatch
Typically we use an OO model in the applicaiton but a non-OO (relational) model in the database. IMPEDENCE MISMATCH says that the models are different enough to cause problems. eg have to deconstruct objects to store them, object relaships r complex
1 of 9
Why is ORM it not that bigger deal?
Most object relationships map quite well to foreign keys. Methods can be implemented as stored procedures.Database access APIs like JDBC simplifiy some of the differences.
2 of 9
Alternatives?
Serialisation - save to file (cant query, no transactions) or Object DBMS
3 of 9
Why are relational/SQL DBMS still best?q
Mature, well understood, well defined standards
4 of 9
Object Relational Mapping (ORM)
Category of libraries/frameworks for persistence of OO data in relational databases. On the fly conversion of domain objects to conform them to table struct of DB. Lets us query our data using the OO model. We still have a reltnal DB,bt treat it OO
5 of 9
Why ORM
can be very productive, do a lot of caching which can speed up processing.
6 of 9
Object Mapping
We need a way to map the applications OO domain classes to and from the databases relational tabes. Mapping lets us control how this happens.
7 of 9
Generating mappings:
Top Down (Start from the OO model - not so good for large systems). Bottom Up (Makes sense if database already exists). Hybrid - Start with both domain model and databse. Create each independently, use mapping to glue them together.
8 of 9
Ad and Dis of ORM frameworks
Can be very productive, improved maintentance, Caching, Widely used. Dis = over complex for small systems. Errors hard to deal with for non expereinced.
9 of 9

Other cards in this set

Card 2

Front

Why is ORM it not that bigger deal?

Back

Most object relationships map quite well to foreign keys. Methods can be implemented as stored procedures.Database access APIs like JDBC simplifiy some of the differences.

Card 3

Front

Alternatives?

Back

Preview of the front of card 3

Card 4

Front

Why are relational/SQL DBMS still best?q

Back

Preview of the front of card 4

Card 5

Front

Object Relational Mapping (ORM)

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Object Relational Mapping resources »