العربية
中国
Français
Deutsch
Ελληνική
हिन्दी
Italiano
日本語
Português
Русский
EspañolADAPTIVE SERVER ENTERPRISE
'Adaptive Server Enterprise (ASE)' is Sybase Corporation's flagship enterprise-class relational database management system product. ASE is predominantly used on the Unix platform but is also available for Windows.
ASE was called Sybase SQL Server up until version 11.5 released 1996 when it was renamed to differentiate itself with the increasingly successful Microsoft SQL Server product. 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. See the online documentation for more details.
The version number was bumped to 15 from 12 because 13 is considered unlucky in Europe, the United States and other "Western" countries, and 14 is considered unlucky in China.
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 procedures. 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.
★ Sybase
★ List of relational database management systems
★ Comparison of relational database management systems
★ Sybase ASE online documentation
★ Sybase
★ Various Documents about ASE
★ Rob Verschoor's well known Sybase site
★ The International Sybase User Group, an organization whose mission is to represent the interests of Sybase users worldwide.
| Contents |
| History |
| Structure |
| See also |
| External links |
History
ASE was called Sybase SQL Server up until version 11.5 released 1996 when it was renamed to differentiate itself with the increasingly successful Microsoft SQL Server product. 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. See the online documentation for more details.
The version number was bumped to 15 from 12 because 13 is considered unlucky in Europe, the United States and other "Western" countries, and 14 is considered unlucky in China.
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 procedures. 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.
See also
★ Sybase
★ List of relational database management systems
★ Comparison of relational database management systems
External links
★ Sybase ASE online documentation
★ Sybase
★ Various Documents about ASE
★ Rob Verschoor's well known Sybase site
★ The International Sybase User Group, an organization whose mission is to represent the interests of Sybase users worldwide.
This article provided by Wikipedia. To edit the contents of this article, click here for original source.
psst.. try this: add to faves
