29:
148:
As a general rule, first class items represent things rather than relationships. For example, the database representations of a human and of a company are each first class items. However, the fact that the person is an employee of that company is not a first class item. Likewise, data
183:: that is to say, unique for objects of this type; objects of different types, represented in different tables, can coincidentally have the same identifier, but the coincidence is meaningless.
168:
representing first class items of a given type (e.g. a table of people, a table of companies). It will also contain other tables representing relationships between these first class items.
145:
independent of any other item. The identity allows the item to persist when its attributes change, and allows other items to claim relationships with the item.
101:
50:
73:
142:
80:
87:
120:
58:
153:
that relationship, e.g. information about the salary the company pays to its employee, is not a first class item.
69:
54:
94:
39:
43:
210:
194:
have special identifiers for its rows. Instead these rows will be identified by an ordered
8:
161:
157:
198:
consisting of unique identifiers of the first class items involved in the relationship.
17:
190:
between two or more first class items (or data about that relationship) will usually
165:
134:
204:
180:
28:
176:
172:
195:
179:
assigned to each row (effectively, to each item) as a unique
186:In a relational database, a table representing a
202:
175:of the table will typically contain a different
171:In a table representing first class items, one
57:. Unsourced material may be challenged and
121:Learn how and when to remove this message
16:For general usage outside databases, see
203:
55:adding citations to reliable sources
22:
13:
14:
222:
27:
1:
70:"First class" computing
7:
10:
227:
15:
164:, each of which contains
141:item is one that has an
160:will include several
51:improve this article
158:relational database
18:First-class object
135:database modeling
131:
130:
123:
105:
218:
126:
119:
115:
112:
106:
104:
63:
31:
23:
226:
225:
221:
220:
219:
217:
216:
215:
201:
200:
127:
116:
110:
107:
64:
62:
48:
32:
21:
12:
11:
5:
224:
214:
213:
129:
128:
35:
33:
26:
9:
6:
4:
3:
2:
223:
212:
211:Data modeling
209:
208:
206:
199:
197:
193:
189:
184:
182:
178:
174:
169:
167:
163:
159:
156:Typically, a
154:
152:
146:
144:
140:
136:
125:
122:
114:
111:December 2009
103:
100:
96:
93:
89:
86:
82:
79:
75:
72: –
71:
67:
66:Find sources:
60:
56:
52:
46:
45:
41:
36:This article
34:
30:
25:
24:
19:
191:
188:relationship
187:
185:
170:
155:
150:
147:
138:
132:
117:
108:
98:
91:
84:
77:
65:
49:Please help
37:
139:first class
181:identifier
81:newspapers
38:does not
205:Category
143:identity
177:integer
95:scholar
59:removed
44:sources
173:column
162:tables
97:
90:
83:
76:
68:
196:tuple
151:about
102:JSTOR
88:books
166:rows
137:, a
74:news
42:any
40:cite
192:not
133:In
53:by
207::
124:)
118:(
113:)
109:(
99:·
92:·
85:·
78:·
61:.
47:.
20:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.