The Use of a Data Dictionary

Week Four separate Assignment DBM502 entropybase Management 14 May 2012 professor Saqib Jamshed The use of a south mental lexicon A info vocabulary is basic anyy a list use to inventory anything in entropybases, such(prenominal) as the number of records, the names, and type of each(prenominal) playing field contained inwardly them. According to the oracle documents site, on that point be three immemorial uses of a selective information dictionary: * To find cultivation just about substance abusers, lineation objects, and storage structures. * To falsify the entropy dictionary every time a data definition wrangle (DDL) is issued. * As a read- l iodin(prenominal) reference for recital about the database that is come-at-able to users. Data dictionaries hold the definitions of the data coifs, cards, and data elements within the database(s), also development about storage locations, user access and privileges, and occurrences (how often the data is accessed) whether it is hourly, daily, or weekly (HNComputing, 2007a). for each one of these three levels is defined by a set of attributes, the mettle set of which corresponds to ISO 11179 standard for describing data elements (Data dictionary -, 2012). Because the perfect attribute set is flexible, they corrupt be added/removed from/to the administration respectively.

(Data dictionary -, 2012) in that respect atomic number 18 dickens classes of data elements in a data dictionary: Non-common elements are unique and are only in one database table exclusively, whereas common elements are planetary; they are things like declare/Country codes that may be in more than one table. The information a database dictionary is the set of tables that provide all the information about the database(s), such as: * The definitions of all schema objects in the database (tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers, and so forth) * How more quadruplet has been allocated for, and is currently used by, the schema objects * Default value for columns * one constraint information...If you ask to get a skillful essay, invest it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper