Adaptive Server Enterprise

About the Product

Adaptive Server Enteprise (in abbreviated form ASE or Sybase ASE earlier known as Sybase SQL Server) is the relational database management system of SAP company, one of DBMS using the Transact-SQL language as the main procedural SQL expansion. It is initially created by Sybase company in 1987 and long time developed together with the Microsoft SQL Server.

History

• 1987 - development of Adaptive Server Enterprise, under the name Sybase SQL Server, historically the first and most known product of Sybase company.

• 1988 - product SQL Server 1.0 was released created together with Microsoft and Ashton-Tate for OS/2 platform, on the basis of codes of the first Sybase DBMS for Unix and VAX/VMS. At the same time it was noted that the version of DBMS for Unix was significantly more productive, than the version for OS/2.

• 1991 - Ashton-Tate after absorption by Borland company stopped cooperation, and Sybase and Microsoft jointly released new versions of a product, implementing them, respectively, under the names Sybase SQL Server and Microsoft SQL Server.

• 1994 - Microsoft and Sybase companies released SQL Server for the Windows platform of NT. At the same time, the alliance developed also versions for Unix.

• 1996 - Sybase and Microsoft companies made the decision to stop joint development of a product, and to independently develop everyone the branch. Thus, two different DBMS with the general heritage in the form of a procedural language of Transact-SQL and architecture of data processing appeared: Sybase Adaptive Server Enterprise and Microsoft SQL Server. Sybase SQL Server 11.0 was the last, developed together with Microsoft version, version 11.5 is already released independently.

• 1998 - Adaptive Server Enterprise of version 11.9.2 is released, in DBMS blocking at the level of records is supported.

• 1999 - Adaptive Server Enterprise of version 11.9.2 is released, and in version 12.0 (released in 1999) — support of distributed transactions is implemented.
• 2001 - Adaptive Server Enterprise of version 12.5 in which the built-in EJB container in a database server is implemented is released.

• 2005 - there was version 15 in which, in particular, such opportunities as sectioning are implemented, virtual columns, many initsializatsionny parameters of copies of databases became dynamic (i.e., there was an opportunity to change their values during operation without restart of a copy).

• 2011 - version 15.5 for the operating systems Windows, AIX, by HP-UX, Solaris, Linux is released.