1 / 24

Data Dictionaries

Data Dictionaries. Some Definitions And Examples. From Webopedia.com.

rachelberrios
Download Presentation

Data Dictionaries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Dictionaries Some Definitions And Examples

  2. 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

  3. 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

  4. 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

  5. ADOdb Data Dictionary Library for PHP • http://phplens.com/lens/adodb/docs-datadict.htm

  6. http://www.amico.org/AMICOlibrary/dataDictionary.html

  7. http://www.flbog.org/irm/DataDict/

  8. 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

  9. Institute of Transportation Engineers

  10. 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

  11. Preservation Metadata Implementation Strategies • Final Report of the PREMIS Working Group • Data Dictionary for Preservation Metadata • www.oclc.org/research/projects/pmwg/premis-final.pdf • OCLC - Online Computer Library Center

  12. Mysql • http://dev.mysql.com/tech-resources/articles/mysql-datadictionary.html

  13. ORACLE Data Dictionary • http://www.google.com/url?sa=U&start=13&q=http://www.oreilly.com/catalog/oracleddpr/chapter/ch01.pdf&e=9797 • From O’Reilly

  14. Global Justice XML Data DictionaryVersion 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

  15. 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, fieldtypes, 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.

  16. Hutchinson Dictionary of Computers, Multimedia, and the Internet • http://www.tiscali.co.uk/reference/dictionaries/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.

  17. 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

  18. 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.

  19. Archaeology Wordsmith • http://www.reference-wordsmith.com/cgi-bin/lookup.cgi?category=&where=headword&terms=data+dictionary • data dictionary • CATEGORY: database design DEFINITION: Documentation of all the files, fields, relations, and processes used in a database.

  20. 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/idd_p.htm • Integrated Spatial Data Dictionary • http://www.for.gov.bc.ca/his/datadmin/ind_dic2.htm

  21. New York State –Division of Criminal Justice Services • http://criminaljustice.state.ny.us/dict/dict.htm

  22. University of Washington Libraries • http://www.lib.washington.edu/msd/mig/datadicts/default.html • American Indians of the Pacific Northwest Text Data Dictionary • http://www.lib.washington.edu/msd/mig/datadicts/amtech_txt.html

  23. European Environment Agency • http://dd.eionet.eu.int/doc1.jsp • http://dd.eionet.eu.int/doc2.jsp • http://dd.eionet.eu.int/doc3.jsp

  24. M-NCPPC Planning Department • http://www.mncppc.org/gisdict/index.htm • GIS Section Data Dictionary • Census 2000 • Churches • Other

More Related