What is Schema?

Discussion on SQL and MySQL
no avatar
Posts: 13
Joined: Tue Dec 18, 2012 9:30 pm

What is Schema?

by adams369 » Mon Jan 28, 2013 7:03 pm

Hi what is Schema in database?
Please give me answer.

Thanks & Regards

no avatar
Posts: 5
Joined: Sat Jan 05, 2013 11:04 pm

Re: What is Schema?

by manroger4 » Sat Feb 09, 2013 2:09 pm

A database schema (/ˈski.mə/SKEE-ma) of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a database will be constructed (divided into database tables). The formal definition of database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema. All constraints are expressible in the same language. A database can be considered a structure in realization of the database language.[1] The states of a created conceptual schema are transformed into an explicit mapping, the database schema. This describes how real world entities are modeled in the database.

"A database schema specifies, based on the database administrator's knowledge of possible applications, the facts that can enter the database, or those of interest to the possible end-users."[2] The notion of a database schema plays the same role as the notion of theory in predicate calculus. A model of this “theory” closely corresponds to a database, which can be seen at any instant of time as a mathematical object. Thus a schema can contain formulas representing integrity constraints specifically for an application and the constraints specifically for a type of database, all expressed in the same database language.[1] In a relational database, the schema defines the tables, fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, Java, XML schemas, and other elements.

Schemas are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure. In other words, schema is the structure of the database that defines the objects in the database.

no avatar
Posts: 1
Joined: Tue Mar 19, 2013 7:55 pm

Re: What is Schema?

by muthukarthik » Tue Mar 19, 2013 8:01 pm

A database schema is a way to logically group objects such as tables, views, stored procedures ect............

Return to SQL and MySQL