|
DESSS incorporates MS SQL Server as the data base engine in its corporate office. All most all web applications data are stored in the MS SQL database. MS SQL server mainly consists of three categories as listed bellow.
SQLOS
Relational Engine
Protocol Layer
SQLOS includes base component in SQL Server architecture. It implements thread scheduling, memory management, I/O management, buffer pool management, resource management, synchronization primitives and locking, and deadlock detection. Relational Engine includes storage engine that contains way how to handle persistent storage of data in devices and how to retrieve data in a faster way. It implements the relational database components including support for databases, tables, queries and stored procedures. Protocol layer is the external interface for SQL server.
DESSS enables the use of MS SQL Server in web applications that reflects in faster retrieval of data from database. SQL server uses SQL queries to take or modify data in the database. DESSS is providing quality, flexible, cost effective solution in web application development by using MS SQL server. This is possible because of its concurrency that means SQL server allows multiple users to access the database. |