The functions and architectural features of the SESAM/SQL-Server database system meet all the demands placed on a powerful database server in today’s world. These characteristics are reflected in its name: SESAM/SQL-Server.
SESAM/SQL-Server is available in a standard edition for single-task operation and in an enterprise edition for multitask operation.
For the sake of simplicity, we shall use the name SESAM/SQL throughout this manual to refer to SESAM/SQL-Server.
Brief product description
SESAM/SQL is the relational database server for BS2000 systems.
SESAM/SQL combines the advantages of the relational data model with all the characteristics expected of a system which is subject to high loads in productive operation. On the one hand, this offers simple operation and data which is independent of the physical storage method used and, on the other, it means that the system is suitable for high transaction rates and large volumes of data and possesses outstanding security and availability characteristics.
The SQL interface implemented in SESAM/SQL has been based across the board on the current SQL standard. This standardized SQL interface means that SESAM/SQL allows you to create portable, future-proof database applications which can be transferred to different database systems and operating systems.
SESAM/SQL fulfils all the demands placed on a modern database system in today’s world:
SESAM/SQL uses SQL, a uniform language and a consistent set of terms for defining, structuring and maintaining a relational database and for creating application programs.
SESAM/SQL runs on all BS2000 systems and can be used as a powerful SQL server for clients of BS2000, UNIX systems, Solaris, Linux and Windows systems.
SESAM/SQL enables Unicode characters to be used in tables and takes into account coded character sets.
SESAM/SQL excels in terms of high availability, security and data integrity.
SESAM/SQL supports modern parallel processing techniques for multi-user operation and multi-database processing.
The Universal Transaction Monitor openUTM and the SESAM/SQL database system together form a powerful DB/DC system including fully coordinated transaction processing and restart facilities for online applications.
The product SESAM/SQL-DCN allows transparent, efficient and trusted access to distributed databases in BS2000 networks.
With the help of the SESAM-DBAccess release unit supplied with SESAM/SQL, also known as SESDBA for short, it is possible to access SESAM/SQL databases in the client/server environment over the following interfaces.
from Java programs or Java Server Pages, Java Servlets, and Java Applets on any platforms
via the ADO technology defined by Microsoft (ActiveX Data Objects) and the ADO.NET interface in client applications on Windows systems
Via the PDO driver of SESAM/SQL for the PHP interface (PHP: Hypertext Processor) on an Apache Webserver
A large range of add-on products increases the range of application of SESAM/SQL. These products range from database design tools, programming languages and third and fourth generation software development environments through to easy-to-use products for end users and the use of SESAM/SQL in World Wide Web applications.