From the course: Database Foundations: Application Development

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Communicate with the data layer

Communicate with the data layer

- [Instructor] When transitioning to a three-tier application architecture, we need to shift our thinking a little bit in how we interact with the relational database. In a multi-tier application, the database layer still functions as a server. It accepts connections and processes instructions that are sent to it from a client. This is similar to the way that we've been interacting with our database servers all along when we log in using a management GUI client or a command line interface. The big difference now is that the end user is no longer directly connecting to the database server. Instead, it's the logic tier of the application that becomes the database's client. Everything that we've learned about connecting to a database server still applies though. The logic tier will need to use a valid login account and password. It can have a user account with a specific set of permissions. For instance, maybe the logic…

Contents