You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 04-28-2015, 04:45 PM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
Sybase Adaptive Server Enterprise (ASE ) overview
11-07-2009, 01:32 PM
Post: #1
Quote this message in a reply
Sybase Adaptive Server Enterprise (ASE ) overview

Sybase ASE - Adaptive Server Enterprise overview

Adaptive Server runs as an application on top of an operating system and depends solely on the services exported by the operating system to function. Adaptive Server uses operating system services for process creation and manipulation, device and file processing, and inter-process communication. The hardware that the operating system runs on is completely transparent to Adaptive Server which sees only the operating system’s user interfaces.

Adaptive Server has a virtual server architecture and has one or more operating system processes (engines) that service client requests. You can configure multiple processes to enhance performance on multiprocessor systems. A process is divided into two components, a DBMS component and a kernel component. The kernel component manages multiple tasks, while the DBMS component performs the database functions on behalf of the current task. Each client is associated with a task, and there are several tasks that perform specific services; for example, writing buffers or audit data to disk, and communicating with the network. The DBMS component of Adaptive Server manages the processing of SQL statements, accesses data in a database, and manages different types of server resources.

All server processes share two distinct areas of shared memory: a kernel area and a DBMS area. The kernel area contains data structures that relate to task management and operating system services, while the DBMS component contains caches of database buffers, object descriptors, and other resources used by the DBMS component of the server process.

The kernel layer of the server abstracts the operating system-specific functions so that the rest of the server has a consistent view of those functions regardless of the underlying operating system. Essentially, the kernel provides low-level functions, such as task and engine management, network and disk I/O, and low-level memory management to the rest of the server. The part of the server that processes a TDS request (the TDS engine) is part of the kernel layer.

The heart of Adaptive Server is the SQL/DBMS engine. The SQL/DBMS engine processes data manipulation statements (DML), utility commands, which are generally data definition statements (DDL) and administrative functions, and performs stored procedure executions. The DBMS engine uses the services provided by the resource manager routines and the access methods routines.

A resource manager is a set of subroutines that manage a particular system resource, such as pages, buffers, or a particular data structure. The DBMS engine uses these subroutines to manipulate various system resources. There are also a number of tasks within the server that perform specialized tasks. The resource managers, as well as these specialized tasks, rely on the kernel layer for low-level functions.

Access methods has two primary functions: the management of data on disk and manipulation of database constructs, such as tables and rows. Actual disk I/O routines are provided to the access methods routines by the kernel disk I/O routines.

Find all posts by this user
Post Reply 

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  ASE Overview picture and explanation? rugby2 2 3,057 07-28-2012 09:36 AM
Last Post: amby_1986
  bcp copy failed:The column and default datatype sent from server are not same phadkedhawal21 2 3,701 06-19-2012 09:04 PM
Last Post: eldeleon
  Any Adaptive Server Login tarkan 0 2,438 03-07-2012 10:37 AM
Last Post: tarkan
  Overview of DBCC ? DerekAsirvadem 0 1,990 11-15-2011 10:02 PM
Last Post: DerekAsirvadem
  Sybase Adaptive Server Enterprise ASE 15 system tables diagram pdf download Kishor 1 5,134 04-24-2010 06:20 PM
Last Post: Joshi
  Sybase Adaptive Server Enterprise ASE 15.5 system tables diagram pdf download Kishor 0 3,306 04-23-2010 02:46 AM
Last Post: Kishor
  Sybase ASE 15 Architecture Overview ppt Kishor 1 14,112 01-20-2010 06:53 AM
Last Post: Joshi
  Sybase ASE – Lightweight Compression for Backup Server in Sybase ASE 15.5 version Kishor 0 2,847 01-08-2010 02:10 AM
Last Post: Kishor
  In-Memory Databases in Adaptive Server Enterprise 15.5 Kishor 0 2,157 01-08-2010 02:07 AM
Last Post: Kishor
  ASE Remains a Strong Enterprise DBMS Kishor 0 1,656 01-06-2010 08:02 PM
Last Post: Kishor

Forum Jump:

Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication