-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathobject_integration.htm
353 lines (291 loc) · 11.3 KB
/
object_integration.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
<HTML><HEAD><TITLE>Object Integration</TITLE></HEAD>
<BODY TEXT="#202020">
<TABLE WIDTH=90%>
<TR>
<TD ALIGN=left VALIGN=top>
<IMG ALT="Database Answers Header" HEIGHT=58 WIDTH=400 SRC="images/dba_400_home.jpg">
</TD>
<TD ALIGN=right ROWSPAN=2 VALIGN=top>
<IMG ALT="Maldive Islands is a great break from job-Hunting" HEIGHT=94 WIDTH=251 SRC="images/maldives_sml.jpg">
</TD>
</TR>
<TR>
<TD ALIGN=left VALIGN=top>
<FONT COLOR=red FACE="Comic Sans MS" SIZE=4>
<B>Integrating Objects and Relations</B></FONT>
</TD>
</TR>
</TABLE>
<TABLE BGCOLOR=blue WIDTH=90%>
<TR>
<TD ALIGN=left COLSPAN=1 VALIGN=TOP WIDTH=40>
<A HREF="index.htm"><IMG ALT="Home" BORDER=0 SRC="images/buttons/home_alt.gif"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=100>
<A HREF="ask_a_question.htm"><IMG ALT="Ask a Question" BORDER=0 SRC="images/buttons/ask_a_question_alt.gif"></A>
</TD>
<TD ALIGN=middle VALIGN=middle WIDTH=60>
<A HREF="careers.htm"><IMG ALT="Careers" BORDER=0 SRC="images/buttons/careers_alt.jpg"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=85>
<A HREF="data_models/index.htm"><IMG ALT="Data Models" BORDER=0 SRC="images/buttons/data_models_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=50>
<A HREF="faqs.htm"><IMG ALT="FAQs" BORDER=0 SRC="images/buttons/faqs_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=75>
<A HREF="sql_scripts/index.htm"><IMG ALT="SQL Scripts" BORDER=0 SRC="images/buttons/sql_scripts_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=50>
<A HREF="site_map.htm"><IMG ALT="Search" BORDER=0 SRC="images/buttons/search_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=62>
<A HREF="site_map.htm"><IMG ALT="Site Map" BORDER=0 SRC="images/buttons/site_map_alt.gif"></A></TD>
<TD ALIGN=right VALIGN=top><FONT COLOR=white face="Verdana" size="1"> </TD>
</TR>
</TABLE>
<!-- end Standard Header - Version 3-->
<!-- begin body Text -->
<FONT COLOR=blue FACE="Verdana" SIZE=2>
<TABLE BGCOLOR="98CEDF" BORDER=0 CELLPADDING=5 CELLSPACING=5 WIDTH=90%>
<TR>
<!---
<TD ROWSPAN=3 VALIGN=top WIDTH=80>
<A HREF="images/boschendal_pool.jpg">
<IMG ALIGN=left ALT="Boschendal Estate, South Africa" BORDER=0 HEIGHT=128 WIDTH=85 SRC="images/boschendal_vertical_sml.jpg"></A>
</TD>
--->
<TD>
<CENTER>
<TABLE BGCOLOR="003088" CELLPADDING=5 CELLSPACING=5 WIDTH=90%>
<TR><TD ALIGN=middle BGCOLOR="#6699FF" BGCOLOR="#004098" COLSPAN=2><FONT COLOR=white SIZE=2>
<B>Background</B>
</TD>
</TR>
<TR>
<TD BGCOLOR="#004098"><FONT COLOR=white SIZE=2>
<P>There are a number of alternatives for mapping Objects onto Tables :-
<BR>
<OL>
<LI>Store everything in one table
<LI>Create one table per class and one SQL view per superclass/subclass relationship
<LI> Create one table per subclass (in the case of inheritance that includes superclass attributes as well)
</OL>
<BR>Each alternative has different <B>Performance implications</B> which need to be evaluated for any specific situation.
<!--- <BR>The aspect of <A HREF="mapping_and_toplink.htm">Mapping</A> is discussed in more detail elsewhere. --->
</TD></TR>
<TR><TD ALIGN=middle BGCOLOR="#6699FF" BGCOLOR="#004098" COLSPAN=2><FONT COLOR=white SIZE=2>
<B>Here are some Useful Links ...</B>
</TD>
</TR>
<TR><TD>
<TABLE BGCOLOR="98CEDF" BORDER=3><FONT COLOR=blue SIZE=2>
<TR>
<TD><FONT COLOR=blue SIZE=2><B>CATEGORY</TD>
<TD><FONT COLOR=blue SIZE=2><B>LINK</TD>
<TD><FONT COLOR=blue SIZE=2><B>ORIGIN</TD>
<TD><FONT COLOR=blue SIZE=2><B>DESCRIPTION</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=1>Michael Stonebreaker</TD>
<TD><FONT COLOR=blue SIZE=1>Object-Relational DBMSs,(ISBN 1-55860-397-2)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=1>
<A HREF="http://www.amazon.com/exec/obidos/ASIN/0201615770/qid%3D971542296/104-9495826-7144747">
Building Web Applications with UML</A>(4.5 Stars)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=1>
<A HREF="http://www.amazon.com/exec/obidos/ASIN/0471295515/ref=sim_books/104-9495826-7144747">
Business Modelling with UML</A> (4 Stars)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=1><A HREF="http://www.amazon.com">
Design using UML Object Modelling</A> (ISBN 0-07-882474-5)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Paul Reed</TD>
<TD><FONT COLOR=blue SIZE=1><A HREF="http://www.amazon.com">
Developing Applications with Visual Basic and UML</A></TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=1>
<A HREF="http://www.amazon.com/exec/obidos/ASIN/0201433133/ref=sim_books/104-9495826-7144747">
Enterprise Modelling with UML</A> (4 Stars)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=1>
<A HREF="http://www.amazon.com/exec/obidos/ASIN/020165783X/o/qid=971543220/sr=2-1/104-9495826-7144747">
UML Distilled - a Brief Guide to the Standard Object Modelling Language</A> (4 Stars)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Books</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.amazon.com">Amazon.com</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=1>
<A HREF="http://www.amazon.com/exec/obidos/ASIN/0201699613/ref=sim_books/104-9495826-7144747">
Visual Modelling with Rational Rose 2000 and UML</A> (4 Stars)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Consultants</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://www.objectarchitects.de/">
Object Architects</A></TD>
<TD><FONT COLOR=blue SIZE=2>Germany</TD>
<TD><FONT COLOR=blue SIZE=1>Worth checking out</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Consultants</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.objectarchitects.de/ObjectArchitects/orpatterns/">
Object Architects</A></TD>
<TD><FONT COLOR=blue SIZE=2>Germany</TD>
<TD><FONT COLOR=blue SIZE=1>Patterns for Object/Relational Layers</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Developers</TD>
<TD VALIGN=TOP>
<FONT COLOR=blue SIZE=2><A HREF="http://www.objectarchitects.de/Wolfgang/">Wolfgang Keller</A></TD>
<TD><FONT COLOR=blue SIZE=2>Germany</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://www.objectarchitects.de/ObjectArchitects/orpatterns/Architecture/architecture.htm">Paper on Architecture</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Objects in Use</TD>
<TD VALIGN=TOP>
<FONT COLOR=blue SIZE=2><A HREF="objects_in_use.htm">including Jim O'Connell's Answer</A></TD>
<TD><FONT COLOR=blue SIZE=2> </TD>
<TD BGCOLOuuR="lightyellow"><FONT COLOR=blue SIZE=2> </TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Publication</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.ambysoft.com/mappingObjects.html" TARGET=_NEW>
Scott Ambler</A></TD>
<TD><FONT COLOR=blue SIZE=2>USA</TD>
<TD><FONT COLOR=blue SIZE=1>
<A HREF="http://www.AmbySoft.com/mappingObjects.pdf" TARGET=_NEW>
Paper on Mapping Objects Relational Databases(pdf file)</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Publication</TD>
<TD><FONT COLOR=blue SIZE=2>
Scott Ambler</A></TD>
<TD><FONT COLOR=blue SIZE=2>USA</TD>
<TD><A HREF="http://www.ambysoft.com/onlineWritings.html" TARGET=_NEW>
<FONT COLOR=blue SIZE=1>List of Scott Ambler's Online Writings</FONT></A></TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.enhydra.org/software/documentation/enhydra/DODS.html" TARGET=_NEW>
Data Objects Design Studio</A></TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.enhydra.org/index.html">Enhydra</TD>
<TD><FONT COLOR=blue SIZE=1>Open Source Java/XML Application Server</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor <IMG ALT="New"SRC="images/new.gif"></TD>
<TD><FONT COLOR=blue SIZE=2>
<A HREF="http://www.hibernate.org/" TARGET=_NEW>Hibernate</A></TD>
<TD><FONT COLOR=blue SIZE=2>Open Source</TD>
<TD><FONT COLOR=blue SIZE=1>Tool for Object-Relational Mapping - controversial to use.
<BR>Offers its own portable SQL extension (HQL), and native SQL, or an object-oriented API.
</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://www-sop.inria.fr/cermics/dbteam/ObjectDriver/" TARGET=_NEW>
Object Driver</A></TD>
<TD><FONT COLOR=blue SIZE=2>France</TD>
<TD><FONT COLOR=blue SIZE=1>An Open Object Wrapper for Relational Databases</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://www.persistence.com" TARGET=_NEW>Persistence</A></TD>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=1> </TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://www.polyhedra.com" TARGET=_NEW>Polyhedra</A></TD>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=1> </TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://www.roguewave.com" TARGET=_NEW>RogueWave</A></TD>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=1>Very popular</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://otn.oracle.com/products/ias/toplink/quicktour/ovr01_05.htm" TARGET=_NEW>TopLink</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=2>Tool that Maps Java Classes onto Relational Tables.</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://otn.oracle.com/products/ias/toplink/quicktour/ovr01_05.htm" TARGET=_NEW>TopLink</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="toplink_discussion_1.htm">Discussion 1</A>.</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://otn.oracle.com/products/ias/toplink/quicktour/ovr01_05.htm" TARGET=_NEW>TopLink</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="toplink_discussion_2.htm">Discussion 2</A>.</TD>
</TR>
<TR>
<TD><FONT COLOR=blue SIZE=2>Vendor</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="http://otn.oracle.com/products/ias/toplink/quicktour/ovr01_05.htm" TARGET=_NEW>TopLink</A></TD>
<TD><FONT COLOR=blue SIZE=2>Oracle</TD>
<TD><FONT COLOR=blue SIZE=2><A HREF="toplink_discussion_3.htm">Discussion 3</A>.</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD VALIGN=top WIiDTH=50%> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</BODY>
<!-- Start of Standard Footer -->
<HR SIZE=3>
<CENTER><FONT FACE="Verdana" SIZE=1>
[ <A HREF="index.htm">Home Page</A>
| <A HREF="ask_a_question.htm">Ask a Question</A>
| <A HREF="contact_us.htm">Contact Us</A>
| <A HREF="mailto:info@databaseanswers.org">Email Us</A>
| <A HREF="search.htm">Search</A>
| <A HREF="site_map.htm">Site Map</A> ]
</CENTER>
<!-- End of Standard Footer -->
<P>
<CENTER><FONT SIZE=1><I> © DatabaseAnswers.com 2006</I></A></FONT></CENTER>
</HTML>