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 51 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.

51 comments:

  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!

    ReplyDelete
  2. 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...

    habsq

    ReplyDelete
  3. 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 ;)

    ReplyDelete
  4. Anonymous4:36 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  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 :: http://casino-freespins.webs.com (http://singyourlife.com/blog/?p=112)

    ReplyDelete
  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

    ReplyDelete
  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.
    Cheers

    Here is my web page: weight loss herb garcinia

    ReplyDelete
  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.
    Thanks!

    Feel free to visit my homepage ... James

    ReplyDelete
  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

    ReplyDelete
  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
    http://www.gurgaonsex.com/
    Gurgaon Escorts Services

    ReplyDelete