Data access layer design pattern

Question

I need to build a data access layer and I am looking for the right design pattern.

what I need is:

object mapping: it shouldn't be too complicated and not generic.
I have a lot of look up tables and I need to a good way to load them. I don't care about starting time (when the program starts up), what I care is to minimizing the number of connections to the db and on the other hand not killing the virtual memory.
relationships: I have a lot of connected objects which relate to each other and I need a generic way to load as much as relationships as I want.

Number 2(above) is most critical for me. Any suggestions?

Thanks

I'd recommend trying to rewrite this - it's hard to work out what you're trying to say. Foxes? Chunky bacon? I'm confused. — Skilldrick
– Skilldrick, Commented Aug 21, 2010 at 11:00
probably means "focus on number 2 as its the most critical" — Marjan Venema
– Marjan Venema, Commented Aug 21, 2010 at 16:30
shuky, are you interested in writing everything on your own, or would a framework that does most of what you want (like Hibernate) be acceptable? — atk
– atk, Commented Aug 22, 2010 at 15:10

Attilah · Accepted Answer · 2010-08-22 22:06:04Z

1

It looks like the Facade pattern could be used here.

and maybe the Singleton pattern too.

answered Aug 22, 2010 at 22:06

Attilah

18k42 gold badges143 silver badges204 bronze badges

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

1 Answer 1