File:RandGlossBlock.jpg: Difference between revisions
Darren Smith (talk | contribs) No edit summary |
ng su hwee (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
==CMM222 Database Organisations & Design (Minor)== | |||
==Database Terminologies== | |||
==Database== | |||
A collection of data stored in a standardized format, designed to be shared by multiple users. A collection of tables for a particular business situation. | |||
==Constraint== | |||
In SQL, a constraint is a rule that is enforced on the data. For example, there can be primary-key and foreign-key constraints that limit the data that can be entered into the declared columns. Other business rules can form constraints , such as Price > 0. | |||
==Data warehouse== | |||
A specialized database that is optimized for management queries. Data is extracted from online transaction processing systems, The data is cleaned and optimized for searching and analysis. Generally supported by parallel processing and RAID storage. | |||
==Durability== | |||
The transaction element that specifies that when a transaction is committed, all changes are permanently saved even if there is a hardware or system failure. | |||
==Edit== | |||
The Microsoft DAO command to alter data on the current row. |
Revision as of 12:20, 18 December 2007
CMM222 Database Organisations & Design (Minor)
Database Terminologies
Database
A collection of data stored in a standardized format, designed to be shared by multiple users. A collection of tables for a particular business situation.
Constraint
In SQL, a constraint is a rule that is enforced on the data. For example, there can be primary-key and foreign-key constraints that limit the data that can be entered into the declared columns. Other business rules can form constraints , such as Price > 0.
Data warehouse
A specialized database that is optimized for management queries. Data is extracted from online transaction processing systems, The data is cleaned and optimized for searching and analysis. Generally supported by parallel processing and RAID storage.
Durability
The transaction element that specifies that when a transaction is committed, all changes are permanently saved even if there is a hardware or system failure.
Edit
The Microsoft DAO command to alter data on the current row.
File history
Click on a date/time to view the file as it appeared at that time.
Date/Time | Thumbnail | Dimensions | User | Comment | |
---|---|---|---|---|---|
current | 18:24, 13 August 2005 | 218 × 423 (27 KB) | Darren Smith (talk | contribs) |
You cannot overwrite this file.
File usage
There are no pages that use this file.