Adaptive Server Enterprise - Structure

Structure

A single stand alone installation of ASE typically comprises one "dataserver" and one corresponding "backup server". In multi server installation many dataservers can share one single backup server though. A dataserver consists of system databases and user's databases. Minimum system databases that are mandatory for normal working of dataserver are 'master', 'tempdb', 'model' and 'sybsystemprocs'. 'master' database holds critical system related information that includes, logins, passwords, and dataserver configuration parameters. 'tempdb' is used for storage of data that are required for intermediate processing of queries, and temporary data. 'model' is used a template for creating new databases. 'sybsystemprocs' consists of system supplied stored procedures that queries system tables and manipulates data in them.

ASE is a single process multithreaded dataserver application, it means when server is up and running there is one single OS process.

Read more about this topic:  Adaptive Server Enterprise

Famous quotes containing the word structure:

    “With sixty staring me in the face, I have developed inflammation of the sentence structure and definite hardening of the paragraphs.”
    —James Thurber (1894–1961)

    “Science is intimately integrated with the whole social structure and cultural tradition. They mutually support one other—only in certain types of society can science flourish, and conversely without a continuous and healthy development and application of science such a society cannot function properly.”
    —Talcott Parsons (1902–1979)

    “Vashtar: So it’s finished. A structure to house one man and the greatest treasure of all time.
    Senta: And a structure that will last for all time.
    Vashtar: Only history will tell that.
    Senta: Sire, will he not be remembered?
    Vashtar: Yes, he’ll be remembered. The pyramid’ll keep his memory alive. In that he built better than he knew.”
    —William Faulkner (1897–1962)