A hub of online professional and topical glossaries/dictionaries
?
Dicts
Items 1→50 of 769. Page 1 of 16. items/page.
100% RULE  look up translate image
a rule to help clarify a subclass-superclass relationship. 100% of the superclasses attributes and associations should be applicable to the subclass. See also "is-a rule"
1NF  look up translate image
See First Normal Form
2NF  look up translate image
See Second Normal Form
3NF  look up translate image
See Third Normal Form
4NF  look up translate image
See Fourth Normal Form
5NF  look up translate image
See Fifth Normal Form
ABSOLUTE  look up translate image
SQL keyword. Used in a "fetch" statement to move to a particular row of the query.
ABSTRACT CONCEPTUAL CLASS  look up translate image
a conceptual class is called abstract if every one of its instances must also be an instance of one of its subclasses. See also Concptual Class Partition.
ACCESS  look up translate image
Microsoft Access is an entry-level database management software from Microsoft, which allows you to organize, access, and share information easily. Access is very user-friendly and easy to use for inexperienced users, while sophisticated enough for database and software developers.
ACCESS MANAGER  look up translate image
part of the DBMS that takes a plan produced by the query optimiser and translates it into accesses to pages of memory containing data.
ACCESS METHOD  look up translate image
a software module providing data access and manipulation primitives for each access structure.
ACCESS PERMISSION  look up translate image
A rule associated with a shared resource that determines which users can access the resource, and at what permissions level.
ACCESSOR  look up translate image
a method used to retrieve data from an object.
ACID  look up translate image
ACID short for Atomicity – Consistency – Isolation – Durability and describes the four properties of an enterprise-level transaction:

+ ATOMICITY: a transaction should be done or undone completely. In the event of an error or failure, all data manipulations should be undone, and all data should rollback to its previous state.

+ CONSISTENCY: a transaction should transform a system from one consistent state to another consistent state.

+ ISOLATION: each transaction should happen independently...(more)
ADD  look up translate image
SQL keyword: command to add items to a composite object.
ADDITIVE RULE  look up translate image
an inference rule for functional dependencies. Also called the Union Rule. If X Y and X Z then X YZ. Contrast with the projective rule.
ADO  look up translate image
Short for Microsoft ActiveX Data Objects. ADO enables your client applications to access and manage data from a range of sources through an OLE DB provider. ADO is built on top of OLE DB and its main benefits are ease of use, high speed, and low memory overhead. ADO makes the task of building complex database enabled client/server and web applications a breeze.
AGGREGATE QUERY  look up translate image
an SQL query that returns some function of a collection of rows, rather than the rows themselves. See count,avg,min,max,sum.
AGGREGATION  look up translate image
Objects that are composed of other objects.
ALL  look up translate image
SQL keyword. Used in an aggregate query to summarise all non-null values of an attribute, with repetition. Used after union, intersect or except to include/exclude all rows, irrespective of repetition. Used with nested queries to compare an attribute/attributes with the rows returned by the nested query, returning true if all rows satisfy the comparison.
ALL KEY RELATION  look up translate image
a relation whose key consists of all its attributes.
ALL-KEY RELATION  look up translate image
A relation in which every field is a member of the relation's primary key.
ALTER  look up translate image
SQL keyword: command to change an object specification.
ALTERNATE (CANDIDATE) KEY  look up translate image
A column or combination of columns, other than the primary key column(s), which may be used to uniquely identify a row in a table. The primary key is chosen from one of the candidate keys. As you can read from the article behind this term; if you have many candidate keys, you have a problem of selecting the best fit.
ANALYSIS OBJECT MODEL  look up translate image
see Domain Model.
ANALYSIS PATTERNS  look up translate image
a tool for identifying classes in a conceptual model.
AND  look up translate image
SQL keyword: Used as a Boolean operator to construct the where clause of a query.
ANOMALY  look up translate image
an inconsistency in a database. See Update Anomaly, Insertion Anomaly, Deletion Anomaly, Modification Anomaly.
ANY  look up translate image
SQL keyword. Used with nested queries to compare an attribute/attributes with the rows returned by the nested query, returning true if at least one row satisfies the comparison.
APPLICATION DESIGNERS  look up translate image
define and create programs for the database.
ARE SYSTEM GENERATED  look up translate image
SQL-3 keyword. Used with "values for" to denote that the DBMS should generate OIDs in the given attribute.
ARMSTRONG"S INFERENCE RULES  look up translate image
The additive, augmentation and transitive rules taken together. These three are logically complete, in that any other valid inference rule may be derived from them.
ARRAY-SEQUENCED ORGANISATION  look up translate image
a way data may be arranged in memory (primary or secondary). The sequence of tuples is dictated by an index.
AS  look up translate image
SQL keyword. An optional keyword used to specify aliases for attributes or tables in a query. SQL keyword: Part of the syntax of "create view" SQL-3 keyword: Part of the syntax of "external"
ASC  look up translate image
SQL keyword. Used with order by to denote how the rows returned by a query are to be sorted (ascending).
ASSERTION  look up translate image
SQL keyword. Used to specify a condition (not dependent on any particular table) that must always be true of the data in the database.
ASSOCIATION  look up translate image
a relationship between (instances of) types that indicates some meaningful and interesting connection.
ASSOCIATION CLASS  look up translate image
a class encapsulating (capturing) information about an association between other classes.
ATOMIC DATA TYPES  look up translate image
the most simple forms of data, Boolean, string, integer, and so forth.
ATTRIBUTE  look up translate image
the name of a column of a table, indicating the meaning of the data in that column. A logical data value of an object. See simple attribute.
ATTRIBUTE PRESERVATION PROPERTY  look up translate image
the property of a decomposition D = {R1, R2, , Rk} of R that the union of the Ri is in fact R.
AUGMENTATION RULE  look up translate image
an inference rule for functional dependencies. If X Y then XZ YZ. Sometimes stated as: If X Y then XZ Y. for MVD"s: If X Y and Z is a subset of W, then WX YZ.
AUTHORIZATION  look up translate image
SQL keyword used to specify the owner of a schema.
AVG  look up translate image
SQL keyword. Used to perform an aggregate query that returns the average value of an attribute.
B-TREE  look up translate image
a tree-based structure used for storing data in a database.
B+ TREE  look up translate image
a tree-based structure used for storing data in a database, with extra links to facilitate sequential access to data.
BAG  look up translate image
an unordered collection that allows duplicates.
BAG-OF  look up translate image
O2 keyword allowing the construction of bags.
BASE RELATION  look up translate image
a relation stored in a database, with data that is not calculated from data in other relations. See also derived relation.
BASE TABLE  look up translate image
A table stored in a database.
first prev Page of 16 next last
Back to Top
Glossary of Database terms
Visibility Public
Created by admin
Created on 2012-08-19 02:32:23
Number of terms 769
Last added Yourdon/DeMarco by admin
2012-08-19 08:01:47
Members
Sources
  • Database Glossary. Important database design terms in database design defined.
    www.databasedesign-resource.com
    Database Glossary. Important database design terms in database design defined.
  • A Comprehensive Dictionary of Database Terms
    www.dr-mikes-maths.com
    A very detailed and comprehensive dictionary of database terms.
  • Basic Database Terminology :: Chapter 1. Introduction to PostgreSQL and SQL :: Part I: General PostgreSQL Use :: Postgresql :: SQL :: eTutorials.org
    etutorials.org
  • Database Glossary
    map.ns.ec.gc.ca
    Deffinitions for common database terms.
  • Database Glossary A | Data Terminology A
    www.nwdatabase.com
    Database Glossary - A and Data Terminology - A including terms like address change service, aggregate and attribute.
  • Database Terms
    www.comptechdoc.org
    Database Terms
  • Database: Design: Relational Database Terminology
    www.fredosaurus.com
  • Databases Glossary
    databases.about.com
    Glossary of database related terms from your About.com Guide to Databases
  • Databasics: A Database Dictionary
    www.geekgirls.com
    A simplified dictionary of database terminology
  • Glossary of Database Terms
    clem.mscd.edu
  • Glossary of Database Terms
    www.raima.com
  • Glossary of Database Terms for Classes by Orange Coast Database Associates - Page 3
    www.dhdursoassociates.com
    Glossary of Database Terms. A reference for MS Access, SQL, and Database classes taught by Orange Coast Database Associates. Includes common concepts such as database design, normalization, query design, relationships, keys, etc.
  • http://i.i.com.com/cnwk.1d/i/tr/downloads/home/mg_database.pdf
    i.i.com.com
  • Lesson 2: Understanding Database Terminology
    www.personal.psu.edu
  • MarketTorrent.com - [Dev] SQL - Relational Database - Glossary (Page 1)
    markettorrent.com
    MarketTorrent — a newsite with the latest happenings
  • Relational Database Analysis - Glossary
    www.relationaldbdesign.com
    Glossary that contains terms with respect to Relational Database Analysis
  • Relational Database Design Glossary | Database Solutions for Microsoft Access | databasedev.co.uk
    www.databasedev.co.uk
    Database Solutions for Microsoft Access. Database design and implementation articles, tips, tricks, code samples, Access FAQ's and Free downloadable database examples.
  • Relational database glossary
    zinser.no-ip.info
    Relational database Glossary
  • SQL Database Glossary
    www.sqlstrings.com
    Database dictionary of SQL database terminology