DB

dwh/bi

DB

http://www.bbreak.co.jp/maeyes/column/column7.html dwh http://stackoverflow.com/questions/3419353/what-is-the-difference-between-a-database-and-a-data-warehouse bi http://dba.stackexchange.com/questions/6619/can-you-give-me-one-example-of-…

列持ち行持ち(縦持ち横持ち)

DB

http://www.skyarch.net/blog/?p=1670

natural key

DB

http://en.m.wikipedia.org/wiki/Natural_key

OLTP and OLAP

DB

http://stackoverflow.com/questions/21900185/what-are-oltp-and-olap-what-is-the-difference-between-them (以前も書いた気が)

normal form (NF)

DB

1NF requiring existence of "the key" 2NF requiring the non-key attributes be dependent on "the whole key" 3NF requiring the non-key attributes be dependent on "nothing but the key" header tag body hello some hello world... ... ... ... ... …

foreign key or foreign keydata

DB

field in one table that uniquely identifies a row of another table. defined in a second table, but it refers to the first table Foreign key - Wikipedia, the free encyclopedia 外部キーとは 【 FK 】 【 foreign key 】 - 意味/解説/説明/定義 :…

primary key, unique key

DB

primary key key for identification of set unique key key for uniqueness assurance of set 整合性制約 - オラクル・Oracleをマスターするための基本と仕組みwww.shift-the-oracle.com

Table name - singular or plural

DB

singular side(?) -- T-SQL plural side -- Joe Celko sql - Table Naming Dilemma: Singular vs. Plural Names - Stack Overflow

DOA

DB

POA: program -> data DOA: data -> program http://stackoverflow.com/questions/1641580/what-is-data-oriented-design