Sybase Database Full Contact

Sybase basic Knowledge

Client/server architecture: Sybase is a database management system built on a client/server architecture.

From a hardware standpoint, a client/server architecture is the allocation of a task between two or more machines, where the client is used to run the application that provides the user interface and front-end processing, and the server computer provides the various resources and services used by the client.

From the software point of view, the client/server architecture is to divide an application or software system into the client software part and the server software part according to the logical function. The Client Software section is generally responsible for the presentation and application of the data, processing the user interface, receiving the user's data processing request and converting it into a request to the server, requiring the server to provide the storage and retrieval service for the data;

The client/server integrates the mainframe's power and central control as well as the low cost and better processing balance of the PC. Client/server provides a new approach to centralized/local distribution of tasks that enables users to centrally control data integrity, management, and security. The client/server system provides a good solution to ease network traffic and host load and meet user needs.

In short, the client/server mode of operation is: the customer and the Server network protocol (such as TCP/IP, ipx/spx) for the connection and communication, the client to the server to send a request, the server response to the request, and the corresponding services.

Basic procedures for accessing Sybase servers

1. Establish a connection between the client and the server, including network connectivity, connection between the client process and the server process;

2. The client sends SQL statements over the network to the server to query or manipulate data or database objects in the server;

3. After the server receives the SQL statement, it performs parsing, optimizing and compiling.

4. If the executed statement produces a result set, the server returns the result set to the customer over the network;

5. The client handles the received results accordingly.

Sybase Installation and Configuration

1. Server-side installation:

After you install SQL Server, you set up logical disk devices that place databases, logs, and indexes. The following principles should be noted in the configuration of databases, logs, and indexes;

A. Do not install any user objects in the master database.

B. The log should be saved on a disk that is separate from the database.

C. Can optimize I/O performance by allocating work across multiple devices.

2. The installation of the client;

3. Content that needs to be changed immediately;

(1) Changing the login password for the SA, (2) naming the server, (3) modifying the file name (to ensure that Sybase normal starts), (4) Changing the default device, and (5) increasing the space in tempdb.

4. To create a user database:

The following is a database-setting script that describes the process of establishing a database:

//创建数据库设备，设备大小以页（2KB）为单位
disk init
name=”test_dbdev”,
physname=”c:\test\test_dbdev.dat”,
vdevno=10,
size=10240
go
disk init
name=”test_logdev”,
phyname=”c:\test\test_logdev.dat”,
vdevno=11,
size=5120
go
//创建数据库TEST_DB，其大小为20M，日志大小为10M
create database TEST_DB
on test_dbdev=20
log on test_logdev=10
go
//打开数据库
use TEST_DB
go

5. Main contents of System management:

A. Management of physical resources

B. Users and their rights management

C. Database backup and Recovery

Sybase Product Overview

1. The composition of Sybase software

Sybase software can be divided into three parts: first, the data management and maintenance of the online relational database management system Sybase SQL Server; second, a set of front-end tool software to support the establishment and development of database application system Sybase SQL tools The third is the interface software Open Client/open Server, which can connect the application software of other vendors and any type of data in heterogeneous environment.

SQL Server is a programmable database management system (DBMS), which is the core software of the entire Sybase product, and plays the role of data management, buffer zone management and transaction management.

2. Basic features of SQL Server

SQL Server is a relational database management system that has the following basic characteristics:

The A.sql server can be placed on several disk devices, with at least 17MB of disk space required for initial installation.

The B.sql server supports a multiple-library structure, which means that there can be multiple databases in the Sybase system. Sybase can manage multiple databases.

C.sql server can compile and run T-SQL statements and return the results required by the client program. The T-SQL statement is an extension of standard SQL, which mainly adds process control statements in addition to data definition statements, data manipulation statements, and data control statements.

D.sql server can manage multiple users and has higher transaction throughput and lower transaction response times.

A customer's application can access data from one or several databases in the server.