Understanding of Schema in db---database

See the term schema today, for its understanding of the Internet is also a lot of, there is a degree of recognition is relatively large, for the moment first use:

"First I'll do a metaphor, what is database, what is a schema, what is a table, what is column, what is row, what is User?" We can think of database as a large warehouse, the warehouse has a lot of rooms, the schema is one of the rooms, a schema represents a room, table can be considered as a bed in each schema, table (bed) is placed in each room, Cannot be placed outside the room, it is not night to sleep homeless. Then the bed can be placed a lot of items, just like the table can be placed a lot of columns and rows, the database is stored in the basic unit of data is a table, in reality, each warehouse place the basic unit of the item is the bed, user is the owner of each schema, " So the schema contains the object, not the user ", in fact, the user is corresponding to the database (that is, the user is the owner of each corresponding database), since there is the right to operate the database (warehouse), there must be operational database of each schema (room) right, That is, each database mapping user has a key to each Schema (room), in other words, if he is the owner of a warehouse, then the use of the warehouse and everything in the warehouse is his (including the room), he has the full operation right, can throw away the unused things from each room, You can also put some useful things into a room, and of course you can remove a room (remove Schema). Oh, and the reality is too similar to it. I (the Administrator of the warehouse) can also assign specific permissions to the user, that is, what he can do in a room, can only see (read-only), or can be like the owner has all the control (r/w), this depends on the role of the user corresponding roles, As to the question of assigning permissions, I will leave it in detail in a separate blog later. The analogy here, I believe everyone is clear. "

Above paragraph Source: http://blog.csdn.net/yanjiangbo/article/details/1782576

Many online are copied above this paragraph, this paragraph is probably the schema compared to the database in a small compartment, today I read "MySQL must know will" this book, the book is said:

"Tables have features that define how data is stored in a table, such as what data can be stored, how data is decomposed, how parts of information are named, and so on. This set of information describing a table is called a pattern, which can be used to describe a particular table in a database and the entire database (and its relationships with tables).

Schema (schema) information about the layout and characteristics of databases and tables. ”

This is to think of schema as an abstraction, a layout, an architecture. How to understand, the above said the room can also reluctantly say that each room can be understood as a different layout, different room bed put the same way. As the study progresses, it is estimated that there will be new explanations and ideas, and there are ideas to continue to update the concept.

DB---Understanding of schema in database