History[02]

Sybase’s main DBMS product was marketed as Sybase SQL Server and was co-developed for PC by Sybase, Microsoft, and Ashton-Tate. In, 1993, the co-development licensing agreement terminated, and Sybase and Microsoft continued developing their respective products. In 1996, Sybase changed the name of its product to Adaptive Server Enterprise (ASE) as a means to differentiate its SQL Server product from Microsoft SQL Server.

Compression

Concurrency Control[03]

Sybase ASE uses multi-version concurrency control where all transactions are performed in the in-memory row storage or on disk MVCC, which enables the server to lock rows for writing in one session while granting access to unaltered rows in another session.

Data Model

Indexes[04]

Indexes can have a root level, leaf level, and/or intermediate level. An index on a 15-byte field has around 100 rows per index page.

Query Interface

Storage Architecture[05]

The database runs entirely in the Adaptive Server memory space (cache), so neither log nor data is ever written to disk, and I/O is not required. Its performance can be better than a disk-oriented database, at the cost of durability; in the event of memory failure, the database cannot be recovered.

Storage Model

Stored Procedures