yet another blog about computer, technology, programming, and internet

Tuesday, April 25, 2006

Database/Data Access Layer (DAL)

Tuesday, April 25, 2006 Posted by Ismail Habib 64 comments
Related to my previous writing about MVC, there is other thing that I'd like to share. Previously, I wrote that MVC helped a lot in creating a big (enterprise?) application. While MVC defines layers that represent layer in same level, DAL (Data Access Layer) provides a depth in application abstraction. DAL logically inserted below business process layer to provide independent-to-database access. The DAL itself contains implementation to specific database access and also interfaces to business process layer.

The benefit of DAL is not far difference with MVC. By separating business process with data access, we may create several implementation of data access (to MySQL, MSSQL, Oracle, etc) without having problems changing the business process.


  1. Abstraction rocks!

    Good writing!
    (artinya "tulisan yang bagus" atau "selamat menulis" ya :)

    I'm curious to see how you can put the UI layer (consists of your MVC stuffs) along with the business logic and data abstraction layer. And how about drawing an arrow that show the dependencies between layers (for instance, some of business logic layer objects should know about some DAL objects, or vice versa).

    Keep writing!

  2. Anonymous11:43 AM

    Unlike a certain someone, I still have a long way to go Mr. monn ;) Thanks for the suggestions... let see what I can do about it...


  3. Anonymous11:59 AM

    for a more loose-coupling design, it's common to add another "thin" layer between BPL and DAL, which known as "Transfer Objects", and which usually persistable.
    These transfer objects represent any data entity you have, and they are independent to whatever the underlying data storage mechanism you use.
    ORM is the key ;)

  4. Anonymous4:36 AM

    This comment has been removed by a blog administrator.

  5. Anonymous12:14 AM

    Så din kommer att dra det freespins bakåt
    den här gången. Slutmålet för spelaren och dealern kommer att
    snurra roulette hjulet och samtidigt. Facket har ett
    chip inuti som är inställd på att betala ut med jämna mellanrum eller när de har samlat en viss summa pengar betalas ut
    när du vinner.

    Feel free to visit my webpage :: (

  6. Anonymous2:38 AM

    hello!,I love your writing so much! percentage we communicate extra approximately your post on AOL?
    I need a specialist in this area to resolve my problem.
    May be that is you! Having a look ahead to see you.

    Feel free to visit my blog - shock collar training guide

  7. Anonymous4:52 PM

    I know this if off topic but I'm looking into starting my own blog and was curious what all is required to
    get set up? I'm assuming having a blog like yours would cost a pretty penny?
    I'm not very internet savvy so I'm not 100% positive.
    Any suggestions or advice would be greatly appreciated.

    Here is my web page: weight loss herb garcinia

  8. Anonymous11:06 PM

    When someone writes an piece of writing he/she retains
    the image of a user in his/her brain that how a user
    can be aware of it. Therefore that's why this article is amazing.

    Feel free to visit my homepage ... James

  9. I love reading your articles and I shared it with my friends.People also like it and give good feedback. Thank you.
    Escort Services in Gurgaon
    Escort Services in Delhi
    Escort Services in Aerocity
    Escorts Services in Gurgaon

  10. Nice! thank you so much! Thank you for sharing. Your blog posts are more interesting and informative. I think there are many people like and visit it regularly, including me.
    Escorts Services in Gurgaon
    Roshani Beautiful Gurgaon Escorts
    Gurgaon Escorts Services


  11. شركة تنظيف منازل الكويت شركة تنظيف منازل الكويت
    شركة تنظيف منازل الاحمدي شركة تنظيف منازل الاحمدي
    شركة تنظيف حولي شركة تنظيف حولي
    شركة تنظيف الفروانية شركة تنظيف الفروانية
    شركة اصباغ الكويت شركة اصباغ الكويت
    شراء اثاث مستعمل الكويت شراء اثاث مستعمل الكويت
    فني كهربائي منازل الكويت فني كهربائي منازل الكويت
    شركة مكافحة البق الكويت شركة مكافحة البق الكويت

  12. We are one of the most successful and appreciated escorts company in Bangalore and have been providing escorts services in Bangalore for more than 5 years with satisfied results. So don't wait and book our Bangalore call girls now.

    Bangalore Escorts

    Air Hostess Escorts Bangalore

    Model Escorts Bangalore

    College Girls Escorts Bangalore

  13. When ordering your designer eyeglasses online, it is very important to make sure that you are choosing a reputable website.
    If you want to buy any Prescription Glasses and Round Sun Glasses. Please visit our Store to buy Best Glasses.
    Best EyeGlasses in US