Re: Data Layer architecture



Please don't feed the trolls.

Thanks for that? Laimis put the spirit of the post right when he said "consider tradeoffs of your decisions".

One of the projects I worked on failed because it had too many layers. The design was all by the books (Microsoft's "Designing Component-Based Applications" by Mary Kirtland.) It was hard work to develop.

When we finally had the first working version, the bugfixes and requirement changes started to come in. For each requirement, we had to change the database, data access, business logic, and presentation layers. Then we had to write a converter for the database and all of the messages in the queues. Then we had to write an installer to update the application. We had made a wrong tradeoff for this particular project; the time required for the extra layers wasn't worth it. The project was cancelled.

On a next project, I used only two layers and dropped the message queues. Development speed was amazing. We were responsive to the customer's requests, and able to deliver on time.

A good learning experience though.

Greetings,
Wessel
.



Relevant Pages

  • Re: [Info-Ingres] String Manipulations
    ... The database contain the business logic pertaining to the data (when ... I've even seen the same logic covered in both layers. ... should be using Jasmine. ...
    (comp.databases.ingres)
  • Re: Multiple databases or not
    ... suppliers can have different codes, and one where they are, for example, ... The 'layers', can ideally be, views. ... > into our existing database. ... > uses a view to access the external databases dependant on the client. ...
    (microsoft.public.sqlserver.programming)
  • Re: LDBC driver
    ... They say that with JDBC, ... Also, most products are designed to work with a single database engine; not as many are meant to plug into virtually any RDBMS, and those tend to be written with a generic SQL dialect in the first place. ... Where RDBMSes differ the most is in DDL, which is generally outside the scope of the Java program and not such an issue there. ... With modern data layers like Hibernate and other JPA solutions, the differences the program does care about are moved off into deployment descriptors. ...
    (comp.lang.java.databases)
  • Re: BLL and DAL.
    ... And yes it can be confusing to begin with, ... I understand the core concepts of Business Logic Layers ... end and the database back end. ... just looks like something that would slow down the whole web experience ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Network Stack Locking
    ... >:I was asking was about the depth of the message queues between protocol ... >:coallescing between layers as a result of the queues at this point? ... > actually maxing out the cpu before maxing out the PCI bus, ...
    (freebsd-arch)