18.1.3.5 Oracle RDBMS
Oracle RDBMS provides the required operational, supervisory, and management software for mission-centric enterprise-wide applications. With the distributed database and network capabilities of Oracle RDBMS, users can transparently integrate the enterprise's old and new data, systems, and applications. Oracle is grouped into several packages that allow customers to choose the functionality they need for their own applications. These packages are:
Standard Oracle Packages
Process Options Package
Fractional-Object Packages
Parallel Server Option Package
Open Gateway Package
The standard Oracle software package provides the functionality and performance required to address a large number of mission-critical online data processing (OLDP) and decision support applications. This standard software, in addition to the full features of several other packages, has features that are proprietary to the following standard Oracle packages:
1. Oracle's Process options (procedual option)
Providing a variety of capabilities makes the database server an effective part of the application environment, and the process options are ideal for applications with advanced requirements and complex business implementation rules. It optionally includes the ability to use programming language pl/sql processes within an Oracle server. Features such as stored procedures and functions, process packages, database triggers, lock management program packages, and database alarms. It also allows the "anonymous" pl/sql process to be submitted either interactively or from 3GL (third-generation language) programs.
2. The Distributed option (distributed option) allows a physical distributed database to be treated as a logical database. Applications that need to update data at multiple sites can benefit from distributed options. Features of this option include:
Distributed updates
Transaction processing (TP)
Monitor (XA) interface
Transparent two-phase commit
Remote Procedure Call (RPC)
Table replication and Oracle Mail interface
For standard Oracle servers, also includes query capabilities and global database names.
3. Parallel server Option (Parallel | Server Option)
Provides support for multiple nodes of a loosely coupled system to enable parallel access to a database of OLTP and decision support. Parallel servers have great advantages in the fields of high performance, extensibility, usability and database connection. Parallel server options include cache management and all other features required for loose coupling and large-scale parallel platforms.
4. Oracle Open Gateway software package
Provides programmable and transparent access to data in non-Oracle data management programs, file systems, applications, and various other systems. Oracle uses open gateway technology to provide SQL connectivity gateways to a wide range of popular data systems and file systems for transparent SQL access. For Target data management programs that do not have SQL connectivity products, the Oracle Open Gateway Developer Toolkit simplifies the integration of systems, data, and applications based on open systems application manuals.
If some departments want to use data sensitivity or classification based access control, then trusted Oracle will contain all the features of Oracle T, and has multi-level security.
18.1.3.6 Sybase SQL Server series
The Sybase SQL Client/server architecture consists of three product family Sybase SQL Servers, Sybase lifecycle development tools, and Sybase open interoperability products.
The Sybase SQL Server is an RDBMS for online applications. It provides a second-level response time, low cost per user operation, and availability, and SQL Server smart data dictionaries collect a wide range of data definitions, business rules, reports, and configuration information.
The Sybase SQL Lifecycle tool provides a means to quickly prototype design, build, and maintain online applications, to model transactions, enforce business rules to protect data integrity, and combine existing applications with new data sources.
They allow developers to work on SQL cards at various stages of the lifecycle. With Sybase tools, developers can use SQL, 3GL, 4GL Multimedia, and object-oriented tools to build online systems in any combination.
Sybase's interoperability strategy provides two extension kits for developing client and server applications, and a toggle Gateway (turnkey gateways) for the most common RDBMS. This strategy makes it possible to collaborate on multiple machine hardware, operating systems, networks, databases and applications in complex computing environments.
Structure principle of 18.1.4 Idapi
The IDAPI (Integrated database application design interface) is a Borland company solution for client/server connectivity. Delphi is also a client/server development of an important part. To make it clear what IDAPI is, let's discuss the interface problem of the common database first.
Each database management system and database applications need a certain way to access the content of the data format, the connection between the two parts called interface, the simplest case is direct access to files, but also complex to be composed of several levels.
Today, user-oriented databases typically deal directly with their data, especially for products that have certain users and use a certain amount of time. Manufacturers always consider their products to be standards, without concern for access to other data formats. Similarly, many vertical database applications are developed in a language similar to C, mostly direct access to their databases. It will be easier for developers to do this, but the user's situation is often changeable. His choice of the underlying data format is not necessarily consistent with the product. In fact, in the first 20 years before the launch of ODBC and IDAPI, industry has come to realize that a DBMS is not just about accessing its own data format.
Broadly speaking, database interfaces can be grouped into the following two categories:
Native type (local)
Client/server type (client/server)