what is purpose of database scheme

Question

What is the purpose of database scheme? Where can I find more information about this? It's not table, it's not database, what is it?

Answer 1

Your best answer is probably all over the interwebs, such as:

http://en.wikipedia.org/wiki/Database_schema

However, put simply, the database schema is the definition that describes the entire configuration of the database, including all of its tables, relations, index, etc.

Answer 2

hello,

it's like a folder where you can have tables and other objects inside :-)

here is some more on wikipedia

I hope that was a fast simple answer :-)

Answer 3

The logical schema is the structure of the tables and relationships in the database.

The physical one is how this structure and the data it holds are stored.

Answer 4

i got your question and here is answer for this

A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.

You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.

You can also read full article on : http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm

Answer 5

A SQL scheme is container of objects. For example you may have a large enterprise application and then is a good practice to use different schemes for different purposes (e.g. put HR related tables into HR scheme, accounting related tables into Accounting scheme and so on). A schema can be owned by any user, and the ownership is transferable.

-Pavel

Answer 6

A database schema is a name space. It is like the C++ namespace, Java namespace, Delphi unit, etc. Depending on the DBMS, it may allow:

• to grant / revoke access to namespace;
• to use fully qualified / short object name (.);
• to admin the schema as a unit;
• etc.

You have to go to the your DBMS vendor site and check the documentation for the Schema term. In most cases, that will be a topic in Concepts.