Geek Answers Handbook

Explanation for the term Schema

I need a simple explanation of the "schema" in English, as in the database schema and XML schema.

EDIT: When someone says create a database schema, does that mean creating constraints on the fields in the tables?

+5
source share
9 answers

Definition

A schema defines the structure of data stored in a database or XML file or elsewhere.


, , "", . Customer , , . , .

, . . - , . , .

"" , . , , "" . , , , .

XML

XML- XML-. W3C , XML, XSD. (. ). XML-, , . Relax-NG - .

, , , XML . XML - , . "", . , , , XML. -.

JSON. , XML. , JSON. , "" JSON-. , . . JSON, , , . , .

, . - " , ".

. . , . XML XSD . . , - .

,
, ( ), , ( ), Customer ( XML-), ( , ..).

. . : " ". : " ". : "" {S, M, L, XL}. , . : " S, M, L, XL" .

+11

- , .

, , .

XML-, XML-, - .

+8

.

- .

- ( , , ).

+4

. - . , .

+4

:

[ XML] - , , XML .

.

+3

A - , , . /, , ( , ).

, , , .

XML , .

OO .

C typedef.

+2

XML. - . , . .

XML, , . XML - , . XML- - XML- . XML- , , XML- , .

0

- , . . , . , .

SQL Server

0

" - ".

", ."

. - , , , . , , , . , .

- , , (, , ), ( , ), ( ) , - , .. ..

The physical scheme of the database tells the viewer which pieces of information are physically close to each other (and therefore it is interesting to request “at a time”), which indices exist on the registered information (and therefore the selection criteria are very interesting to apply if we want to get fast answers) etc. etc.

All this without a database that needs to be built or without it should be available for viewing the model.

0
source

More articles:


All Articles