Français
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
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
External access to the DBMS
Conclusion
Bibliography
Software tools
Eclipse http://www.eclipse.org/
JDK http://www.oracle.com/technetwork/java/javase/
SQLDeveloper http://www.oracle.com/technetwork/developer-tools/sql-developer/
...Standards and norms
- SLQ1 – Information processing systems – Database language – SQL - ISO 9075 - 1987
- SQL2 – Information technology – Database languages – SQL - ISO/IEC 9075 - 1992
- SLQ3 – Information technology –Database languages – SQL – Part 1: Framework (SQL/Framework) - ISO/IEC 9075–1 - 1999
The Ultimate Scientific and Technical Reference
