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.
Back to Top
|
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 |
|
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 Termswww.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.orgetutorials.org Database Glossarymap.ns.ec.gc.ca Deffinitions for common database terms. Database Glossary A | Data Terminology Awww.nwdatabase.com Database Glossary - A and Data Terminology - A including terms like address change service, aggregate and attribute. Database Termswww.comptechdoc.org Database Terms Database: Design: Relational Database Terminologywww.fredosaurus.com Databases Glossarydatabases.about.com Glossary of database related terms from your About.com Guide to Databases Databasics: A Database Dictionarywww.geekgirls.com A simplified dictionary of database terminology Glossary of Database Termsclem.mscd.edu Glossary of Database Termswww.raima.com Glossary of Database Terms for Classes by Orange Coast Database
Associates - Page 3www.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.pdfi.i.com.com Lesson 2: Understanding Database Terminologywww.personal.psu.edu MarketTorrent.com - [Dev] SQL - Relational Database - Glossary (Page 1)markettorrent.com MarketTorrent — a newsite with the latest happenings Relational Database Analysis - Glossarywww.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 glossaryzinser.no-ip.info Relational database Glossary SQL Database Glossarywww.sqlstrings.com Database dictionary of SQL database terminology
|