2

Where do databases fit into object-oriented design? Lets say for example I had a articles database simple straight to the point, my use case diagram had scenarios for search articles, view article, and create article.

Should I have an article class with a connection to the database within the class or just a global database class so that other classes say user class can access the same connection?

Also should I use tables as objects such as article being it's own data object then having a class like ArticleApi for CRUD operations?

Another also if anyone has any start-to-finish object-oriented analysis and design tutorials that would be great.

Sorry for such a novice question I come from procedural programming practices and trying to move into the object-orientation part of software development.

Improve this question

2 Answers 2

Reset to default
4

You didn't specify any particular platform, so it's not gonna be a very accurate answer.

Where do databases fit into object-oriented design?

I guess we're talking about RDBMS, right? Well, they don't. This is why we need ORM software, like Hibernate for Java or Doctrine for PHP.

Should I have an article class with a connection to the database within the class or just a global database class so that other classes say user class can access the same connection?

Also should I use tables as objects such as article being it's own data object then having a class like ArticleApi for CRUD operations?

There are basically two common approaches for ORM architecture:

  • Data Mapper, where your domain objects are just plain-old objects, without any dependencies to ORM/database. You should model your model in OO-way and then map it into your database. You've got a separate set of objects (EntityManagers) for dealing with actual persistance.
  • Active Record, where your domain objects are tightly coupled with ORM and they provide a set of methods on their own for handling database-related operations.

In my personal opinion data mapper approach is superior to active record as it follows SOLID principles. But active record might be very usefull as well.

You should generally remember that your domain model (object oriented) and database model (rdbms) are two different things that have to be modeled with a different guidelines.

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

I could hug you right now, very informative and yes I was talking about RDBMS MySQL to be specific
@Crozin Can I confirm - are you advising that the data for the application should be designed and constructed separately as a RDBMS database using an ERD data model and the OO designed application mapped to the database using ORM? Is there no other way?
@AJF Yeah, if you're dealing with non-trivial system this is usually more beneficial approach than attempting to somehow merge those two distinct models.
@Crozin Thanks for response. Agreed on non-trivial as in if system simple enough to map class to table then fine otherwise another layer of manipulation is required. What about LINQ?
1

There is no single correct answer - all depends on application you are building. You can use Transaction Script approach (which is pretty procedural) for simplest applications.

Then you can evolve to Table Module - approach which uses class for each table in database, and that class is responsible for managing all data from table.

For more complex applications you will have Domain Model (usually even before you will have database). And you will need Data Mapper to map your Domain Model classes to tables in Database (you can map single class to many tables and vice versa). With power of modern Object Relational Mappers usage of Domain Model become much easier, because most part of this mapping is done automatically. Some tools like Entity Framework in .NET even allow you to generate Domain Model from Database tables.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.