External access to the DBMS
Architecture client-server: access modes to databases

Add to my library

H3865 V1 Article

External access to the DBMS
Architecture client-server: access modes to databases

Authors : Guillaume CABANAC, Olivier TESTE, Michel TUFFERY

Review date: April 28, 2016 | Lire en français

Add to my library Add to my library

Logo Techniques de l'Ingenieur You do not have access to this resource.
Request your free trial access! Free trial

Already subscribed?

3. External access to the DBMS

Using these different access modes, external actors interact with the DB. They access it either directly in SQL language (data definition, manipulation, interrogation and control), or through a host language (Java, C, C++, C#, Php, etc.). It should be noted that the declarative SQL language (standardized) has been extended by procedural languages, generally imperative and proprietary (PL/SQL for Oracle, Transact-SQL for MS SQL Server...).

3.1 Application architectures

The end-user has an application with which he interacts through presentation artifacts (presentation logic). The application manipulates data through processing (application logic). These three layers can be split between client and server in several ways, as illustrated in figure

You do not have access to this resource.
Logo Techniques de l'Ingenieur

Exclusive to subscribers. 97% yet to be discovered!

You do not have access to this resource. Click here to request your free trial access!

Already subscribed?

Ongoing reading
External access to the DBMS

Article included in this offer

"Software technologies and System architectures"

( 234 articles )

Complete knowledge base

Updated and enriched with articles validated by our scientific committees

Services

A set of exclusive tools to complement the resources

View offer details
Contact us
Contact our team FAQ