The Database Design Resource Center

Server Layer | SQL Database Layer | Presentation Layer | SQL Server Programming

Database application architecture - High performance software

Database application architecture: How does a computer operate?

Actually, much relies on the application architechture. In the real old days, computers worked with dumb terminals - that is, the screens were just screens; everything happened at the central site. IBM (tm) was big; you filled out a form of some sort, then you transmitted it to a central computer. If you did something wrong, you got a message back: Error in line 2 (out of 30).

Why couldn't you get that message when you were at line 2? Because you had NO computing power on your desk: all programs were running on the central computer.

Today it is another situation: Your application architecture delivers more computing power on your desk than these old mainframes could ever dream of.

And still your system is slow, making you wait forever?

Most likely, it's because of the database application architechture.

When PC's came into play, the IT professionals soon found out that much of the work could be done on the client. The client is your PC, hooked up to a server (a computer far away). So the application architecture changed radically: The software engineers placed a lot of logic on the PC's to avoid putting a too heavy workload on the server(s).

That sounds right, yes? The problem was: Now the network had so much to do, sending all the traffic to your PC, that the network became the bottleneck.

Imagine you want to see all information on a specific customer: the server sends you all customers and tells your PC: You figure out for yourself which customer. That is exactly what happened in client-server computing. The result was very slow performance because of the enormous traffic over the network.

Today, we have a new appproach to this: We split the application architecture logic in different layers, and we minimize traffic. This is called multi-layered software; many people call it three-tier: The database server does its job, which is to find data, the application server acts as a middle man; getting data after receiving requests, and the client (your PC) does only functional computing; that is, allowing you to act upon, and manipulate, the data you get from the application server.

(Bear in mind that this section of the website is relatively new; There will be other topics added here in the future).

Microsoft SQL Server Training keynotes

  • This keynote shows you the basic principle for designing real high-performance database applications, without having to think about the database itself.
  • This keynote addresses issues regarding good and bad practices when designing a SQL Server Database. In this issue, we address good and bad practices for the Application Layer/Tier. The benefits of stored procedures are illustrated with code samples.
  • In this keynote, special considerations are given to most flexible and best practices for reusing your code in a web application communicating with the SQL Server Database.
  • This keynote deals with good practices towards MS SQL Server: SQL Server Programming communicating with the SQL Server Database.

Return to Database Design home

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.