Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us

what is the architechure of sybase ASE?

Add comment
Views: 771
Votes: 1
Comments: 33
The Sybase Server 
A Sybase server consists of: 
       a) Two processes, data

					 		 server and backup server.
       b) Devices which house the databases; one database

					 		 
(master) contains system and configuration data

					 		.
       c) A configuration file which contains the server 
attributes. 
Memory Model 
The Sybase memory model consists of: 
	a) The program area, which is where the dataserver 
executable is stored.
	b) The data

					 		 cache, stores recently fetched pages

					 		 
from the database

					 		 device. 
	c) The stored procedure

					 		 cache, which contains 
optimized sql

					 		 calls. 
A database

					 		 device stores the objects that make up 
databases. 
	The term device does not necessarily refer to a 
distinct physical device: it can refer to any piece of a 
disk (such as a disk partition) or a file in the file 
system that is used to store databases and their objects.

Each database

					 		 device or file must be prepared and made 
known to Adaptive Server before it can be used for database

					 		 
storage. This process is called initialization.
A segment is a label that points to one or more database

					 		 
devices. When you first create a database

					 		, Adaptive Server 
creates three segments in the database

					 		,

System: Stores the database

					 		?s system tables.
Logsegment: Stores the database

					 		?s transaction

					 		 log.
Default: Stores all other database

					 		 objects?unless you 
create additional segments and store tables or indexes on 
the new segments by using create table

					 		...on segment_name or 
create index

					 		...on segment_name
Showing: 1-20 of 33    »»
Comments

31 Dec, 1969   |   Guest
sql select statement


31 Dec, 1969   |   Guest
texas corporations database


31 Dec, 1969   |   Guest
data management systems


31 Dec, 1969   |   Guest
database management systems


31 Dec, 1969   |   Guest
database designers


31 Dec, 1969   |   Guest
dbms security


31 Dec, 1969   |   Guest
update sql statement


31 Dec, 1969   |   Guest
access database design


31 Dec, 1969   |   Guest
sql tutorial


31 Dec, 1969   |   Guest
sql server versions


31 Dec, 1969   |   Guest
what is sql server


31 Dec, 1969   |   Guest
ms sql server 2008


31 Dec, 1969   |   Guest
database management system


31 Dec, 1969   |   Guest
access dbms


31 Dec, 1969   |   Guest
dbms copy download


31 Dec, 1969   |   Guest
online database application


31 Dec, 1969   |   Guest
microsoft database


31 Dec, 1969   |   Guest
what is a database


31 Dec, 1969   |   Guest
gatherer database


31 Dec, 1969   |   Guest
database


Showing: 1-20 of 33    »»


Add comment

Others in this Category
document How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?
document What is Data Mapping



RSS