What is a 3 tier connection?
I found this answer from SearchSoftwareQuality.com and it seems to make a ton of sense.
A 3-tier application is an application program that is organized into three major parts, each of which is distributed to a different place or places in a network. The three parts are:
- The workstation or presentation interface
- The business logic
- The database and programming related to managing it
In a typical 3-tier application, the application user’s workstation contains the programming that provides the graphical user interface (GUI) and application-specific entry forms or interactive windows. (Some data that is local or unique for the workstation user is also kept on the local hard disk.)
Business logic is located on a local area network (LAN) server or other shared computer. The business logic acts as the server for client requests from workstations. In turn, it determines what data is needed (and where it is located) and acts as a client in relation to a third tier of programming that might be located on a mainframe computer.
The third tier includes the database and a program to manage read and write access to it. While the organization of an application can be more complicated than this, the 3-tier view is a convenient way to think about the parts in a large-scale program.
A 3-tier application uses the client/server computing model. With three tiers or parts, each part can be developed concurrently by different team of programmers coding in different languages from the other tier developers.
Because the programming for a tier can be changed or relocated without affecting the other tiers, the 3-tier model makes it easier for an enterprise or software packager to continually evolve an application as new needs and opportunities arise.
Existing applications or critical parts can be permanently or temporarily retained and encapsulated within the new tier of which it becomes a component.