44:
by other tables. Because POIDs, like surrogate keys, do not carry business information, they are immune to changes in the form or meaning of business data. It can therefore make it easier to maintain relations between objects and make queries simpler.
36:. Important characteristics of a POID are that it does not carry business information and are not generally exported or otherwise made visible to data users; as such a POID has many of the characteristics of a
40:. The only purpose of the POID is to act as the primary key on the table where it is defined and to be referenced as the
157:
147:
119:
172:
131:
177:
8:
94:
106:
74:
98:
166:
64:
37:
59:
54:
41:
33:
69:
29:
152:
17:
153:
What is a
Persistent Object Identifier and why should I care?
164:
165:
32:of a record on a table, used as the
13:
14:
189:
141:
86:
1:
80:
148:Persistent Object ID Service
22:persistent object identifier
7:
48:
10:
194:
158:Persistent Object
126:Missing or empty
114:Missing or empty
75:Object identifier
30:unique identifier
185:
136:
135:
129:
123:
117:
112:
110:
102:
90:
193:
192:
188:
187:
186:
184:
183:
182:
173:Database theory
163:
162:
144:
139:
127:
125:
115:
113:
104:
103:
92:
91:
87:
83:
51:
12:
11:
5:
191:
181:
180:
175:
161:
160:
155:
150:
143:
142:External links
140:
138:
137:
84:
82:
79:
78:
77:
72:
67:
62:
57:
50:
47:
9:
6:
4:
3:
2:
190:
179:
176:
174:
171:
170:
168:
159:
156:
154:
151:
149:
146:
145:
133:
121:
108:
100:
96:
89:
85:
76:
73:
71:
68:
66:
65:Surrogate key
63:
61:
58:
56:
53:
52:
46:
43:
39:
38:surrogate key
35:
31:
27:
23:
19:
116:|title=
88:
25:
21:
15:
178:Identifiers
60:Primary key
55:Natural key
42:foreign key
34:primary key
167:Categories
128:|url=
81:References
70:Unique key
20:design, a
107:cite web
99:64459959
49:See also
18:database
28:) is a
97:
95:S2CID
132:help
120:help
26:POID
16:In
169::
124:;
111::
109:}}
105:{{
93:.
134:)
130:(
122:)
118:(
101:.
24:(
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.