int survey #4...

**IDENTIFY AT LEAST 10 DBMS SOFTWARES WITH THEIR CORRESPONDING DEVELOPER. THEN CHOOSE 1 AND BRIEFLY TELL HOW DOES DBMS HANDLE OR ACCOMMODATE DATA INPUT.


Oracle Database
Developed by Oracle Corporation

IBM DB2
Developed by IBM

FileMaker
Developed by FileMaker Inc. Latest release

Firebird (database server)
Developed by Firebird Project

Ingres
Developed by Ingres Corporation

Microsoft Access
Developed by Microsoft

Microsoft SQL Server
Developed by Microsoft

MySQL
Developed by Sun Microsystems

PostgreSQL
Developed by PostgreSQL Global Development Group

OpenEdge Advanced Business Language
Developed by Progress Software Corporation

__________________________________________________


Microsoft SQL Server


The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with an .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension.

The main unit of data storage is a database, which is a collection of tables with typed columns. SQL Server supports different data types, including primary types such as Integer, Float, Decimal, Char (including character strings), Varchar (variable length character strings), binary (for unstructured blobs of data), Text (for textual data) among others.SQL Server also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). A database can also contain other objects including views, stored procedures, indexes and constraints, in addition to tables, along with a transaction log. An SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 220 TB.

Storage space allocated to a database is divided into sequentially numbered pages, each 8 KB in size. Page type defines the data contained in the page - data stored in the database, index, allocation map which holds information about how pages are allocated to tables and indexes.

The main mode of retrieving data from an SQL Server database is querying for it. The query is expressed using a variant of SQL called T-SQL, a dialect Microsoft SQL Server shares with Sybase SQL Server due to its legacy. The query declaratively specifies what is to be retrieved. It is processed by the query processor, which figures out the sequence of steps that will be necessary to retrieve the requested data. The sequence of actions necessary to execute a query is called a query plan.

END