Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newsfeed3.dallas1.level3.net!newsfeed2.dallas1.level3.net!news.level3.com!postnews2.google.com!not-for-mail From: neo55592@hotmail.com (Neo) Newsgroups: comp.databases.theory Subject: Re: A Normalization Question Date: 23 Jul 2004 12:44:49 -0700 Organization: http://groups.google.com Lines: 47 Message-ID: <4b45d3ad.0407231144.d5c9244@posting.google.com> References: <20040626120209.29625.00000578@mb-m16.aol.com> <4b45d3ad.0407150938.c79cf6f@posting.google.com> <4b45d3ad.0407171411.5909f133@posting.google.com> <40fc03d9@post.usenet.com> <4b45d3ad.0407201356.39d4c09d@posting.google.com> <3638acfd.0407201850.3584c1fb@posting.google.com> <4b45d3ad.0407211939.47e9bebd@posting.google.com> <3638acfd.0407221716.387e1eb@posting.google.com> NNTP-Posting-Host: 67.98.160.207 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1090611889 32268 127.0.0.1 (23 Jul 2004 19:44:49 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 23 Jul 2004 19:44:49 +0000 (UTC) Xref: core-easynews comp.databases.theory:37305 X-Received-Date: Fri, 23 Jul 2004 12:43:52 MST (news.easynews.com) > event name subject verb object > ------------------------------------------ > thingA john takes final > thingB john receives 95 > thingC thingA causes thingB How would you implement this, taking into account normalization and need to handle multiple persons named john? Would it be similar to below and if so, how would one handle the "?"s T_Thing ID Name 1 john 2 take 3 final 4 recieve 5 95 T_SVO Subject Verb Object ->john ->take ->final ->john ->receive ->95 ? ->cause ? Unlike RM, where values of a column can only reference tuples of a single relation determined at design time, in XDb2/TM, any thing can reference anything in the entire db at run time. > > Where/how would one store the following: > > ((john take final) cause (john receive 95)) VerbX ObjectY. > > (I have no idea what VerbX and ObjectY mean here.) VerbX and ObjectY are variables for anything that act as verb and object in T_SVO, for example: ((john take final) cause (john receive 95)) cause (john win corvette) > Are you aware of the term "referential transparency"? No. > Do you really believe that 2 + 2 and let x = 2 in x + x > *denote* different things? My scope is limited to things represented within the context of a db. Please show how the above things are represented in a db and identify the things to be compared.