SQL Server is a relational database management system(RDBMS) that is designed for applications with client / server architecture. The terms client, server, and client / server can be used to refer to the concept of a very general or specific terms of hardware or software. At a very general level, a client is any component of a system of requesting the services or resources (resource) from the other system components. While each component was largely a server system that provides services or resources to other system components.
System Client / Server (Mercus Teddy cs 2004)
Client / server system is a database service designed to separate from the client, by connecting using a data communication path. Service is implemented in a computer database that efficient, which enables centralized management, security, and other resources. Therefore, the server in a client / server is a database and its services. Client applications implemented on a variety of flat form, using a variety of programming.
Display Microsoft SQL Server 2000
SQL Server is a database server that is functionally the process or application that provides database services. Client interacts with the database service through a specific communication interface that aims to control and security. Client currently do not have direct access to data, but always communicate with the database server. (Marcus Teddy.2004).
SQL Server uses the type of database called a relational database. Relational database is a database used to manage or organize the data into tables. The tables are an invaluable tool for organizing or classifying data concerning the same subject and contains information and columns and rows. The tables are interconnected with the database engine when needed.
SQL Server supports several different data types, including character, antlers, the date (datetime) and money (money), SQL Server is used to describe the model and the implementation of the database.
The advantage of using SQL Server can be defined into two parts: one part to run on the server and the other for the client.
1.4.2.1. Client gains
1. Easy to use.
2. Supports various hardware.
3. Supports a variety of software applications.
4. Common to use
1.4.2.2. Advantages Server:
1. Reliable (Reliable).
2. Fault tolerance (Fault Tolerant).
3. Concurrency (Concurrent)
4. High performance in hardware (High-performance Hardware).
5. Centralized control (Centralized Control).
6. Sophisticated locking (Sophisticated locking).
(Marcus Teddy.2004).
(view with faesal_lbk)
Description : SQL SERVER 2000
URL : http://indra-combination.blogspot.com/2012/06/definition-of-sql-server-2000.html
Permalink : SQL SERVER 2000
URL : http://indra-combination.blogspot.com/2012/06/definition-of-sql-server-2000.html
Permalink : SQL SERVER 2000
