Transcript Data Dictionaries

Data Dictionaries
Some Definitions
And
Examples
From Webopedia.com
• In database management systems, a file that defines the
basic organization of a database. A data dictionary contains
a list of all files in the database, the number of records in
each file, and the names and types of each field. Most
database management systems keep the data dictionary
hidden from users to prevent them from accidentally
destroying its contents. Data dictionaries do not contain
any actual data from the database, only bookkeeping
information for managing it. Without a data dictionary,
however, a database management system cannot access
data from the database.
• http://www.webopedia.com/TERM/D/data_dictionary.html
From Wikipedia, the free encyclopedia
• A data dictionary is a set of metadata that contains definitions and
representations of data elements.
• Within the context of a DBMS, a data dictionary is a read-only set of
tables and views. The data dictionary is a database in its own right.
Amongst other things, a data dictionary holds the following
information:
• Precise definition of data elements
• Usernames, roles and privileges
• Schema objects
• Integrity constraints
• Stored procedures and triggers
• General database structure
• Audit information
• Space allocations
From Wikipedia, the free encyclopedia
•
•
•
•
•
One benefit of a well-prepared data dictionary is a consistency between data items
across different tables. For example, several tables may hold telephone numbers; using a
data dictionary the format of this telephone number field will be consistent.
When an organization builds an enterprise-wide data dictionary, it may include both
semantics and representational definitions for data elements. The semantic components
focus on creating precise meaning of data elements. Representation definitions include
how data elements are stored in a computer structure such as an integer, string or date
format. Data dictionaries are one step along a pathway of creating precise semantic
definitions for an organization.
Initially, data dictionaries are sometimes simply a collection of database columns and
the definitions of what the meaning and types the columns contain. Data dictionaries are
more precise than glossaries (terms and definitions) because they frequently have one or
more representations of how data is structured. Data dictionaries are usually separate
from data models since data models usually include complex relationships between data
elements.
Data dictionaries can evolve into full ontologies when discrete logic has been added to
data element definitions.
http://en.wikipedia.org/wiki/Data_dictionary
ADOdb Data Dictionary Library for PHP
• http://phplens.com/lens/adodb/docsdatadict.htm
• http://www.amico.org/AMICOlibrary/dataD
ictionary.html
• http://www.flbog.org/irm/DataDict/
Institute of Transportation Engineers
• http://www.ite.org/tmdd/
• Traffic Management Data Dictionary
(TMDD) and
Message Sets for External Traffic
Management Center Communications
(MS/ETMCC)
• http://www.ite.org/tmdd/Sec1V1.4.mdb
Institute of Transportation Engineers
Institute of Transportation Engineers
•
•
•
•
1 - Traffic Data Partition, Entities: Link and Node
- Access Database
- Html
2 - Traffic Management Data Elements for Events, Incidents, and Notification Alarm
Access Database
- Name and ID
- Name and Definition
- Full Description
3 - Traffic Management Data Elements
- Access Database
- Traffic Network
- Traffic Signal Control
- Traffic Detectors
- Ramp Meter
- Traffic Modeling
- Vehicle Probe
4 - Traffic Management Data Elements for Closed Circuit Television (CCTV), Dynamic Message
Signs (DMS), Environmental Sensor Station (ESS), Gate, and Highway Advisory Radio (HAR)
- Access Database
- Name and ID
- Name and Definition
- Full Description
Preservation Metadata
Implementation Strategies
• Final Report of the PREMIS Working
Group
• Data Dictionary for Preservation Metadata
• www.oclc.org/research/projects/pmwg/prem
is-final.pdf
• OCLC - Online Computer Library Center
Mysql
• http://dev.mysql.com/techresources/articles/mysql-datadictionary.html
ORACLE Data Dictionary
• http://www.google.com/url?sa=U&start=13
&q=http://www.oreilly.com/catalog/oracled
dpr/chapter/ch01.pdf&e=9797
• From O’Reilly
Global Justice XML Data Dictionary
Version 3.0 Prerelease
•
•
•
•
•
http://it.ojp.gov/jxdd/
http://it.ojp.gov/jxdd/JusticeXMLOverview.pdf
http://it.ojp.gov/jxdd/JusticeXMLTechnical.pdf
http://it.ojp.gov/jxdd/prerelease/3.0.0.3/index.html
http://it.ojp.gov/jxdd/prerelease/3.0.0.1/index.html
Free Online Dictionary of
Computing
•
•
•
•
•
•
•
•
http://foldoc.org/index.html
<database> A data structure that stores meta-data, i.e. data about data. The
term "data dictionary" has several uses.
Most generally it is a set of data descriptions that can be shared by several
applications.
Usually it means a table in a database that stores the names, field types, length,
and other characteristics of the fields in the database tables.
An active data dictionary is automatically updated as changes occur in the
database. A passive data dictionary must be manually updated.
In a DBMS, this functionality is performed by the system catalog. The data
dictionary is a more general software utility used by designers, users, and
administrators for information resource management.
The data dictionary may maintain information on system hardware, software,
documentation, users, and other aspects.
Data dictionaries are also used to document the database design process itself
and can accumulate meta-data ready to feed into the system catalog.
Hutchinson Dictionary of Computers,
Multimedia, and the Internet
• http://www.tiscali.co.uk/reference/dictionari
es/computers/data/m0044443.html
• A file that holds data about data – for
example, lists of files, number of records in
each file, and types of fields.
• Data dictionaries are used by database
software to enable access to the data; they
are not normally accessible to the user.
From mywiseowl.com
•
•
•
•
•
•
•
•
•
•
•
http://www.mywiseowl.com/articles/Data_dictionary
A (generally) read-only set of tables and views that holds metadata - used in a
DBMS. The Data Dictionary may be considered a database in its own right.
Amongst other things, a Data Dictionary holds the following information:
Usernames, Roles and Privileges
Schema Objects
Integrity Constraints
Stored Procedures and Triggers
General Database Structure
Audit information
Space allocations
From Association for Geographic
Information
• http://www.geo.ed.ac.uk/agidexe/term?194
• Data Dictionary A repository of
information in a database in which
information is stored on all the objects
within the database and their relationships.
Archaeology Wordsmith
• http://www.reference-wordsmith.com/cgibin/lookup.cgi?category=&where=headword&ter
ms=data+dictionary
• data dictionary
– CATEGORY: database design
DEFINITION: Documentation of all the files, fields,
relations, and processes used in a database.
BC Forest Service
• http://www.for.gov.bc.ca/his/datadmin/ind_
dic_p.htm
• Integrated Data Dictionary :
http://www.for.gov.bc.ca/his/datadmin/id
d_p.htm
• Integrated Spatial Data Dictionary
• http://www.for.gov.bc.ca/his/datadmin/ind_
dic2.htm
New York State –
Division of Criminal Justice Services
• http://criminaljustice.state.ny.us/dict/dict.ht
m
University of Washington Libraries
• http://www.lib.washington.edu/msd/mig/dat
adicts/default.html
• American Indians of the Pacific Northwest
Text Data Dictionary
• http://www.lib.washington.edu/msd/mig/dat
adicts/amtech_txt.html
European Environment Agency
• http://dd.eionet.eu.int/doc1.jsp
• http://dd.eionet.eu.int/doc2.jsp
• http://dd.eionet.eu.int/doc3.jsp
M-NCPPC Planning Department
•
•
•
•
•
http://www.mncppc.org/gisdict/index.htm
GIS Section Data Dictionary
Census 2000
Churches
Other