Schema object

Schema object

A schema object is a logical data storage structure. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the database. The data of each object is physically contained in one or more of the tablespace's datafiles. For some objects such as tables, indexes, and clusters, you can specify how much disk space Oracle allocates for the object within the tablespace's datafiles.

There is no relationship between schemas and tablespaces: a tablespace can contain objects from different schemas, and the objects for a schema can be contained in different tablespaces.

Associated with each database user is a schema. A schema is a collection of schema objects. Examples of schema objects include tables, views, sequences, synonyms, indexes, clusters, database links, snapshots, procedures, functions, and packages.

See also

* Data element
* Data modeling
* Data dictionary

External links

* http://www.csee.umbc.edu/help/oracle8/server.815/a67781/c08schem.htm


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Object-oriented modeling — (OOM), also called object oriented programming (OOP) is a modeling paradigm mainly used in computer programming. Prior to the rise of OOM, the dominant paradigm was procedural programming, which emphasized the use of discrete reusable code blocks …   Wikipedia

  • Object-Oriented Modeling — Object Oriented Modeling, or OOM, is a modeling paradigm mainly used in computer programming. Prior to the rise of OOM, the dominant paradigm was functional programming, which emphasized the use of discreet reusable code blocks that could stand… …   Wikipedia

  • SCHEMA ST4 — Basisdaten Entwickler SCHEMA GmbH Aktuelle Version 3.4.2 (Juli 201 …   Deutsch Wikipedia

  • Schema for Object-Oriented XML — Schema for Object Oriented XML, or SOX, is an XML schema language developed by Commerce One. In 1998 a SOX specification was submitted to the World Wide Web Consortium and published as a W3C Note. A revised version, SOX 2.0, was published as a… …   Wikipedia

  • Schema (Kant) — In Kantian philosophy, a schema (plural: schemata ) is the procedural rule by which a category or pure, non empirical concept is associated with a mental image of an object. It is supposedly produced by the imagination through the pure form of… …   Wikipedia

  • Object-relational impedance mismatch — The object relational impedance mismatch is a set of conceptual and technical difficulties that are often encountered when a relational database management system (RDBMS) is being used by a program written in an object oriented programming… …   Wikipedia

  • Object-Role Modeling — Not to be confused with Object relational mapping. Example of the application of Object Role Modeling in a Schema for Geologic Surface , Stephen M. Richard (1999).[1] Object Role Modeling (ORM) is a method for conceptual modeling, and can be used …   Wikipedia

  • Schéma d'URI — En informatique, un schéma d’URI est le premier niveau de la structure de nommage des identifiants uniformes de ressources (URI). Toutes les URIs sont construites à partir d’un nom de schéma, suivi de deux points (« : ») puis du reste… …   Wikipédia en Français

  • Object role modeling — Not to be confused with Object relational mapping. [ Stephen M. Richard (1999). [http://pubs.usgs.gov/of/1999/of99 386/richard.html Geologic Concept Modeling] . U.S. Geological Survey Open File Report 99 386.] ] Object Role Modeling (ORM) in the… …   Wikipedia

  • Object database — Example of an object oriented model.[1] An object database (also object oriented database management system) is a database management system in which information is represented in the form of objects as used in object oriented programming. Object …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”