Physical schema (version 2): Difference between revisions
Content deleted Content added
No edit summary |
←Blanked the page |
||
| Line 1: | Line 1: | ||
{{Citations missing|article|date=March 2007}} |
|||
{{Essay-like|date=December 2007}} |
|||
'''Physical Schema''' is a term used in relation to data management. |
|||
In the [[Windows-1252|ANSI]] four-schema architecture, the ''internal schema'' was the view of data that involved data management technology. This was as opposed to the ''external schema'' that reflected the view of each person in the organization, or the ''[[conceptual schema]]'' that was the integration of a set of external schemas. Subsequently the internal schema was recognized to have two parts: |
|||
The [[logical schema]] was the way data were represented to conform to the constraints of a particular approach to database management. At that time the choices were hierarchical and network. Describing dncbd.csd dsjbfadshf;dsfhkjdshafdsh;afhdshfakjdshf;jhdshfjdshafjdsjfhdsahfthe logical schema, however, still did not describe how physically data would be stored on disk drives. That is the domain of the ''physical schema''. Now logical schemas describe data in terms of relational ''tables and columns'', object-oriented ''classes'', and [[XML]] ''tags''. The underlying technology has since exploded. A single set of tables, for example can be implemented in dozens of different ways, up to and including the architecture where some rows are on a computer in [[Cleveland]] and others are on a computer in [[Warsaw]]. |
|||
This is the physical schema. |
|||
[[Category:Data management]] |
|||
{{comp-stub}} |
|||
[[ja:スキーマ (データベース)]] |
|||