Data domain

Data domain

In data management and database analysis, a data domain refers to all the unique values which a data element may contain. The rule for determining the domain boundary may be as simple as a data type with an enumerated list of values.[1]

For example, a database table that has information about people, with one record per person, might have a "gender" column. This gender column might be declared as a string data type, and allowed to have one of two known code values: "M" for male, "F" for female—and NULL for records where gender is unknown or not applicable (or arguably "U" for unknown as a sentinel value). The data domain for the gender column is: "M", "F".

In a normalized data model, the reference domain is typically specified in a reference table. Following the previous example, a Gender reference table would have exactly two records, one per allowed value—excluding NULL. Reference tables are formally related to other tables in a database by the use of foreign keys.

Less simple domain boundary rules, if database-enforced, may be implemented through a check constraint or, in more complex cases, in a database trigger. For example, a column requiring positive numeric values may have a check constraint declaring that the values must be greater than zero.

This definition combines the concepts of domain as an area over which control is exercised and the mathematical idea of a set of values of an independent variable for which a function is defined. See: domain (mathematics).

References

  1. ^ Loshin, David (2001). "Enterprise knowledge management: the data quality approach". books.google.co.uk. ISBN 978-0124558403. http://books.google.co.uk/books?id=3BXTfCtR8zsC&pg=PA302. Retrieved 19 August 2011. 

See also



Wikimedia Foundation. 2010.

Игры ⚽ Нужно сделать НИР?

Look at other dictionaries:

  • Data Domain (corporation) — Data Domain Corporation was an Information Technology company from 2001 2009 specializing in target based deduplication solutions for disk based backup.[1] In June 2009, EMC Corporation announced their intention to acquire Data Domain Corp,… …   Wikipedia

  • Data domain (disambiguation) — Data domain may refer to: Data domain, a concept in database design and management. Data Domain (corporation), a company making backup and recovery hardware and software. This disambiguation page lists articles associated with the same title. If… …   Wikipedia

  • Data, context and interaction — (DCI) is a paradigm used in computer software to program systems of communicating objects. Its goals are: To improve the readability of object oriented code by giving system behavior first class status; To cleanly separate code for rapidly… …   Wikipedia

  • Domain — may refer to: General Territory (administrative division), a non sovereign geographic area which has come under the authority of another government Public domain, a body of works and knowledge without proprietary interest Eminent domain, the… …   Wikipedia

  • Data — For data in a computer science context, see Data (computing). For other senses of the word, see Data (disambiguation). See also datum, a disambiguation page. The term data refers to qualitative or quantitative attributes of a variable or set of… …   Wikipedia

  • Domain-driven design — (DDD) is an approach to developing software for complex needs by deeply connecting the implementation to an evolving model of the core business concepts.[1] The premise of domain driven design is the following: Placing the project s primary focus …   Wikipedia

  • Data integrity — in its broadest meaning refers to the trustworthiness of system resources over their entire life cycle. In more analytic terms, it is the representational faithfulness of information to the true state of the object that the information represents …   Wikipedia

  • Domain-specific multimodeling — Domain specific multimodeling[1] is a software development paradigm where each view is made explicit as a separate domain specific language (DSL). Successful development of a modern enterprise system requires the convergence of multiple views.… …   Wikipedia

  • Domain inventory pattern — Domain Inventory is a design pattern, applied within the service orientation design paradigm, whose application enables creating pools of services, which correspond to different segments of the enterprise, instead of creating a single enterprise… …   Wikipedia

  • Data Context Interaction — (DCI) ist ein Architekturmuster für die Modellierung der Fachlichkeit komplexer objektorientierter Software. DCI trennt Fachobjekte ( Data ) von Anwendungsfällen ( Context ) und Rollen ( Interaction ). DCI wurde erstmals von Trygve Reenskaug, dem …   Deutsch Wikipedia

Share the article and excerpts

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