Adaptive Server Enterprise
Encyclopedia
Adaptive Server Enterprise (ASE) is Sybase Corporation's
(Now SAP AG
) flagship enterprise-class relational model
database server
product. ASE is predominantly used on the Unix platform but is also available for Windows
.
platforms in 1987, Sybase Corporation
's primary relational database management system
product was initially marketed under the name Sybase SQL Server. In 1988, SQL Server for OS/2
was co-developed for the PC by Sybase, Microsoft
, and Ashton-Tate
. Ashton-Tate divested its interest and Microsoft became the lead partner after porting SQL Server to Windows NT
.
Microsoft and Sybase sold and supported the product through version 4.21. In 1993 the co-development licensing agreement between Microsoft and Sybase ended and the companies parted ways while continuing to develop their respective versions of the software.
In 1995, Sybase released SQL Server 11.0. Starting with version 11.5, released in 1996, Sybase moved to differentiate its product from Microsoft SQL Server
by renaming it to Adaptive Server Enterprise.
Sybase provides native low-level programming interfaces to its database server which uses a protocol called Tabular Data Stream
. Prior to version 10, DBLIB (DataBase LIBrary) was used. Version 10 and onwards uses, CTLIB (Client LIBrary).
In 1998, ASE 11.9.2 was rolled out with support for row-level locking and distributed joins and improved SMP
performance. ASE 12.0 was released in 1999 providing support for Java
, high availability and distributed transaction management. In 2001, ASE 12.5 was released providing features such as dynamic memory allocation and support for XML
and SSL among others. Support of an EJB container within the database server along with efficient in-memory connections to the database engine, suggests an object oriented access to the relational data.
In September 2005, Sybase released ASE 15. It includes a rewritten query optimizer that is supposed to increase performance over the traditional optimizer, and support for partitioning table rows in a database across individual disk devices to reduce contention and increase the speed at which the data can be accessed, and "virtual columns" which are computed only when required. Other changes that didn't make it to the initial release but are expected soon are support for column-level encryption, and the ability to mount a database dump as a "virtual database" and extract only the information required.
Sybase ASE 15.0 also has many new configuration parameters included in its latest release. Many parameters that were static (which required server reboot for the changes to take place) have been made dynamic (Changes will take effect immediately) ensuring better performance of the adaptive server with comparably less down time. For example, In the earlier versions of Sybase ASE prior to 15, "tape retension in days" parameter was static which always caused a problem whenever there is a plan to change the number of days which the backup has to be kept in the tape media without overwriting the existing contents in the production environment has now been made dynamic in the latest release. See the online documentation for more details.
from 12 because 13
is considered unlucky in Europe
, the United States
and other "Western" countries, and 14
is considered unlucky in China
.
s. Users can access the data using a login and password. Once logged into a Sybase dataserver a user's access to databases and tables etc. is controlled by setting permissions.
http://www.sybase.com/ase_1500devel
It only allows 1 engine and 25 connections.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.asewqig/html/asewqig/asewqig3.htm
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
(Now SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
) flagship enterprise-class relational model
Relational model
The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by Edgar F...
database server
Database server
A database server is a computer program that provides database services to other computer programs or computers, as defined by the client–server model. The term may also refer to a computer dedicated to running such a program...
product. ASE is predominantly used on the Unix platform but is also available for Windows
Microsoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
.
History
Originally for UNIXUnix
Unix is a multitasking, multi-user computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs, including Ken Thompson, Dennis Ritchie, Brian Kernighan, Douglas McIlroy, and Joe Ossanna...
platforms in 1987, Sybase Corporation
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
's primary relational database management system
Relational database management system
A relational database management system is a database management system that is based on the relational model as introduced by E. F. Codd. Most popular databases currently in use are based on the relational database model....
product was initially marketed under the name Sybase SQL Server. In 1988, SQL Server for OS/2
OS/2
OS/2 is a computer operating system, initially created by Microsoft and IBM, then later developed by IBM exclusively. The name stands for "Operating System/2," because it was introduced as part of the same generation change release as IBM's "Personal System/2 " line of second-generation personal...
was co-developed for the PC by Sybase, Microsoft
Microsoft
Microsoft Corporation is an American public multinational corporation headquartered in Redmond, Washington, USA that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions...
, and Ashton-Tate
Ashton-Tate
Ashton-Tate was a US based software company best known for developing the popular dBASE database application. Ashton-Tate grew from a small garage-based company to become a multinational corporation...
. Ashton-Tate divested its interest and Microsoft became the lead partner after porting SQL Server to Windows NT
Windows NT
Windows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993. It was a powerful high-level-language-based, processor-independent, multiprocessing, multiuser operating system with features comparable to Unix. It was intended to complement...
.
Microsoft and Sybase sold and supported the product through version 4.21. In 1993 the co-development licensing agreement between Microsoft and Sybase ended and the companies parted ways while continuing to develop their respective versions of the software.
In 1995, Sybase released SQL Server 11.0. Starting with version 11.5, released in 1996, Sybase moved to differentiate its product from Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
by renaming it to Adaptive Server Enterprise.
Sybase provides native low-level programming interfaces to its database server which uses a protocol called Tabular Data Stream
Tabular Data Stream
Tabular Data Stream is an application layer protocol, used to transfer data between a database server and a client. It was initially designed and developed by Sybase Inc...
. Prior to version 10, DBLIB (DataBase LIBrary) was used. Version 10 and onwards uses, CTLIB (Client LIBrary).
In 1998, ASE 11.9.2 was rolled out with support for row-level locking and distributed joins and improved SMP
Symmetric multiprocessing
In computing, symmetric multiprocessing involves a multiprocessor computer hardware architecture where two or more identical processors are connected to a single shared main memory and are controlled by a single OS instance. Most common multiprocessor systems today use an SMP architecture...
performance. ASE 12.0 was released in 1999 providing support for Java
Java (programming language)
Java is a programming language originally developed by James Gosling at Sun Microsystems and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities...
, high availability and distributed transaction management. In 2001, ASE 12.5 was released providing features such as dynamic memory allocation and support for XML
XML
Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....
and SSL among others. Support of an EJB container within the database server along with efficient in-memory connections to the database engine, suggests an object oriented access to the relational data.
In September 2005, Sybase released ASE 15. It includes a rewritten query optimizer that is supposed to increase performance over the traditional optimizer, and support for partitioning table rows in a database across individual disk devices to reduce contention and increase the speed at which the data can be accessed, and "virtual columns" which are computed only when required. Other changes that didn't make it to the initial release but are expected soon are support for column-level encryption, and the ability to mount a database dump as a "virtual database" and extract only the information required.
Sybase ASE 15.0 also has many new configuration parameters included in its latest release. Many parameters that were static (which required server reboot for the changes to take place) have been made dynamic (Changes will take effect immediately) ensuring better performance of the adaptive server with comparably less down time. For example, In the earlier versions of Sybase ASE prior to 15, "tape retension in days" parameter was static which always caused a problem whenever there is a plan to change the number of days which the backup has to be kept in the tape media without overwriting the existing contents in the production environment has now been made dynamic in the latest release. See the online documentation for more details.
Version numbering
The version number was bumped to 1515 (number)
15 is the natural number following 14 and preceding 16. In English, it is the smallest natural number with seven letters in its spelled name....
from 12 because 13
13 (number)
13 is the natural number after 12 and before 14. It is the smallest number with eight letters in its name spelled out in English. It is also the first of the teens – the numbers 13 through 19 – the ages of teenagers....
is considered unlucky in Europe
Europe
Europe is, by convention, one of the world's seven continents. Comprising the westernmost peninsula of Eurasia, Europe is generally 'divided' from Asia to its east by the watershed divides of the Ural and Caucasus Mountains, the Ural River, the Caspian and Black Seas, and the waterways connecting...
, the United States
United States
The United States of America is a federal constitutional republic comprising fifty states and a federal district...
and other "Western" countries, and 14
14 (number)
14 is the natural number following 13 and preceding 15.In speech, the numbers 14 and 40 are often confused. When carefully enunciated, they differ in which syllable is stressed: 14 vs 40...
is considered unlucky in China
China
Chinese civilization may refer to:* China for more general discussion of the country.* Chinese culture* Greater China, the transnational community of ethnic Chinese.* History of China* Sinosphere, the area historically affected by Chinese culture...
.
Structure
An ASE installation typically comprises one "dataserver" which hosts several databases. Some of these are "system" databases which store only meta-data used to keep the system operational. The others are "user" databases which store application data in the form of tables and stored procedureStored procedure
A stored procedure is a subroutine available to applications that access a relational database system. A stored procedure is actually stored in the database data dictionary.Typical uses for stored procedures include data validation or access control mechanisms...
s. Users can access the data using a login and password. Once logged into a Sybase dataserver a user's access to databases and tables etc. is controlled by setting permissions.
Versions
Sybase also have a Developer edition that can be used for free to develop against (but not for production use).http://www.sybase.com/ase_1500devel
It only allows 1 engine and 25 connections.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.asewqig/html/asewqig/asewqig3.htm
See also
- SQL AnywhereSQL AnywhereSQL Anywhere is a relational database management system product from the company Sybase iAnywhere, a subsidiary of Sybase.- Features :...
- SybaseSybaseSybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
- List of relational database management systems
- Comparison of relational database management systemsComparison of relational database management systemsThe following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. This article is not all-inclusive or necessarily up to date...