Main Page
From BaraWiki
Contents |
Database Design
CASE: Computer-aided software engineering [1]
Data Model Cardinality: Cardinality defines the numeric relationships between occurrences of the entities on either end of the relationship line. [2]
Identifying relationship: one of the child entities is also a dependent entity.
Non-identifying relationship: both entities are independent.
BTREE: balanced multiway tree.[3][4]
Clustered vs Non-Clustered: [5]
UUID as primary key?: There are also situations where you need database values to be universally unique. One good example is in a system where there are two separate physical databases containing human resource data from two different physical locations of a company. To ensure that records are uniquely identified regardless of which database they are in, you can use a datatype called a GUID (or UUID or just UID) which stands for Globally Unique Identifier.
These are 128-bit values that are generated from some sort of magical combination of starting values that are different for each computer in the world. The values are then represented as a 30-some character string of hexadecimal values and dashes. (Those of you who are Windows or ASP programmers will recognize them as CLSID values.) The downside of using GUIDs is that they require more storage space and take more time to analyze when used in a WHERE clause compared to integer values. But the upside is that your primary key will be unique both within and between any database anywhere, ever.
Data Modeling: [6]
Links:
Ten Common Database Design Mistakes: [7]
Primary Keys: IDs versus GUIDs: [8]
To UUID or not to UUID: [9]
TRUNCATE TABLE vs DELETE truncate bypasses the transaction log [10]
Quikis
- Windows Logo+D: Minimizes all open windows and displays the desktop
Learning Wiki
This section is for experimenting with wikis.
Barawiki Ideas
I think we should use this space to recount stories and folklore of Ray - some true, some not, but all very baranoski-esque. Either that or write carefully thought-out, film-major-grade reviews of all of Mel Gibson's films. --Danp 07:15, 12 December 2006 (PST)
Apocalypterrific! --Rayb 19:15, 28 January 2007 (PST)
Consult the User's Guide for information on using the wiki software.
