Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Help Understanding OODBMS'

 
Goto page Previous  1, 2, 3
   Database Help (Home) -> Object-Oriented RSS
Next:  converting data  
Author Message
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 31) Posted: Thu Feb 17, 2005 12:03 pm
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: comp>databases>object (more info?)

 > RM provides *one* simple, logical access path to all information.
 > You cannot beat that.

Please post a simpler RM solution than XDb2's for following scenario
recently posted in comp.databases:
"a" has label "red",
"b" has "red" and "green",
"c" has "red", "green", and "blue".
Retrieve every item that has both "red" and "green" labels.

// Create an item in directory to classify labels.
(CREATE *label.item ~in = dir)

// Create an item in directory to classify Items.
// Then create some Items and relate to labels
(CREATE *Item.item ~in = dir)
(CREATE *a.cls = Item & it.label = +red)
(CREATE *b.cls = Item & it.label = +red & it.label = +green)
(CREATE *c.cls = Item & it.label = +red & it.label = +green & it.label
= +blue)

// Find Items whose label is red and green.
// Finds Items b and c.
(SELECT *.cls = Item & *.label = red & *.label = green)

 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
Lee Fesperman

External


Since: Aug 10, 2003
Posts: 56



(Msg. 32) Posted: Sat Feb 19, 2005 1:41 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Neo wrote:
 >
 > .... One method of verifying this is by
 > using XDb2's GUI to display the ID of the string that names the
 > quarterback and the ID of the string that names the city and seeing
 > that they are in fact the same. The example "Things Named Brown" posted
 > at <a rel="nofollow" style='text-decoration: none;' href="http://www.xdb2.com/Example/Ex030.asp" target="_blank">www.xdb2.com/Example/Ex030.asp</a> shows exactly this where different
 > things are named by the just one string 'brown' which has the ID 2EFB.
 > ...

I've snipped your boring implementation details. What I did leave illustrates your poor
separation of logical/physical concerns, despite your claims to the contrary. That 'ID'
is a physical artifact.

  > > It's incorrect because it mixes meta data and user
  > > data, another logical blunder.
 >
 > It not a matter or mixing "meta data" and "user data".

You'll have to prove that managled sentence.

 > XDb2 can manipulate things via low-level functions AND high-level
 > declarative statements.

As I said, physical navigation and poor separation of logical/physical concerns. You
obviously don't know what declarative means.

  > > RM provides *one* simple, logical access path to all information.
  > > You cannot beat that.
 >
 > While still experimental, XDb2's declarative interface is simpler than
 > RM's SQL.

From our discussion so far, I've been able to discern the following distinct access
paths in your product:

+ meta data to user data
+ value to heterogenous references
+ value to value attributes
+ value to specific references

.... and more, I'm sure. RM has one.

What you have is not simpler; it is overwhelmingly more complex and redundant. In this
scheme, it would be difficult to determine the proper access path (to retrieve expected
results) and even to find information (it could be anywhere.)

  > > BTW, your code did not demonstrate how redundancy of values
  > > impacts integrity.
 >
 > Suppose we model the city/quarterback named 'Troy'. I use XDb2 which
 > automatically normalizes 'Troy'. You use RM and consider 'Troy' a value
 > and represent/model/store it redundantly and don't use generic
 > modelling.

Finally, you attempt to support your assertion....

 > First, because the string 'Troy' is redundant in RM, you will not be
 > able to perform some of the queries that XDb can as systematic/simple
 > manner. To prove me wrong, just post RM's script for the equivalent
 > schema/queries.

This has nothing to do with the impact on integrity.

 > Second, suppose Terrorist take over the US. As part of their spoils
 > they demand you and I reverse the spelling of every thing named 'Troy'.

That's all you have -- a ridiculous example? No one would arbitrarily change *all*
references to a specific value into a reference to another value (such as, the number 2
into the number 1492) in any but the simplest db and expect to retain usable data.

 > I can't believe I have to explain why having duplicate things in a db
 > increases the chances of corruption, as it is an extremely basic concept.

'Thing' is your word. Aspects of a database have specific names and concepts. Duplicate
facts cause corruption (Neo has 2 children; Neo has 1492 children.) Duplicate values are
needed (Sam has 2 children; Mary has 2 children.)

 > Third, suppose we want to add an attribute to the string 'Troy'. In
 > XDb2, it would be simply (CREATE 'Troy'.point value = 15). In RM, you
 > will need to change the schema to normalize all the redundant 'Troy's
 > so that the attrubute can be added non-redundantly.

Actually, assigning an attribute to heterogeneous references to a value is likely cause
integrity problems.

You have not supported your assertion.

 > Please post RM's equivalent script/queries that would support your
 > original assertions:
 > "Unlike relational/normalization, they have no solid foundation for
 > their structure. They use an ad-hoc organization that is not
 > appropriate for storing usable information. They can't guarantee that
 > the information is accessible and that the integrity of the information
 > is protected. Some do provide a primitive type of SQL interface, but it
 > is a mere shadow of the power of a relational query facility."

Get serious! There is a wealth of information available on those aspects of RM. I've
even pointed you to some.

You can try showing that your product doesn't have the above disadvantages. In this
short article I've already shown that you have an ad-hoc organization, information is
not guaranteed accessible, integrity and usability are not perserved and your query
facility is not declarative.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
Lee Fesperman

External


Since: Aug 10, 2003
Posts: 56



(Msg. 33) Posted: Sat Feb 19, 2005 8:47 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Neo wrote:
 >
  > > The last 2 queries use the title of an item ... This capability
  > > is a logical blunder and impractical (it fails should "first-name"
  > > for the quarteback and "city-name" for the city be used)
 >
 > Your comment leads me to believe someone like you would complain that a
 > bicycle doesn't fly, apparently not realizing that it wasn't designed
 > for that purpose. The XDb2 script below models a quarterback and a city
 > with the attributes "first-name" and "city-name" respectively and both
 > have the "value" 'Troy' (in RM speak). This design does allow a single
 > query to find them by the string 'Troy'.
 >
 > ... code snipped ...

Funny, even you can't design properly in your data model.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
Lee Fesperman

External


Since: Aug 10, 2003
Posts: 56



(Msg. 34) Posted: Sat Feb 19, 2005 8:57 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Neo wrote:
 >
  > > RM provides *one* simple, logical access path to all information.
  > > You cannot beat that.
 >
 > Please post a simpler RM solution than XDb2's for following scenario
 > recently posted in comp.databases:
 > "a" has label "red",
 > "b" has "red" and "green",
 > "c" has "red", "green", and "blue".
 > Retrieve every item that has both "red" and "green" labels.
 >
 > ... code snipped ...

The original question was about a *normalized* many-to-many design. Your solution uses a
completely different design that's not even 1NF. Why do you rattle on about
normalization when your product doesn't support it and you don't use it?

BTW, your design also mixes meta data and user data. Using user data values as names
(meta data) is incorrect.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 35) Posted: Sat Feb 19, 2005 9:11 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

  >> <a rel="nofollow" style='text-decoration: none;' href="http://www.xdb2.com/Example/Ex030.asp" target="_blank">www.xdb2.com/Example/Ex030.asp</a> shows ...
  >> different things are named by just
  >> one string 'brown' which has the ID 2EFB.
 >
 > illustrates your poor separation of logical/physical concerns,
 > despite your claims to the contrary.
 > That 'ID' is a physical artifact.

What it illustrates is your poor ability to evaluate information for a
particular purpose which was to determine if multiple things with the
same name refer to the same string in XDb2. Not that it would be a
typical method, but the sure-est method to verify if two things are the
same is by comparing their physical location. Exposing that different
things (a person, a color, a street) refer to ID 2EFB (string 'brown')
for its name is a surer means to verify non-redundancy than via
information provided by a higher level interface. For example, if a RM
view displays that a person is named brown and that a street is also
named brown, it is not as easy to determine if the two strings are
different or refer to just one. Just because I actually showed you the
physical blinkers of a car versus those displayed on the dashboard,
does not in anyway reduce/increase the separation to hardware provided
by the instrument panel (ie SQL/NLI). Please review XDb2's scripts for
any examples including that for 'Troy' and observe that no IDs are ever
exposed. Please post RM's equivalent script/queries WITHOUT IDs!

 > You obviously don't know what declarative means.

You might want to compare to XDb2's script to that of RM's for a person
named 'John' who is male. Please post RM's equivalent script/queries
for city and quarterback named 'Troy' (or almost any other XDb2
example) so one can verify which is more declarative. So far, you have
NOT posted ANY verifiable scripts to support your assertions.

 > I've been able to discern the following distinct
 > access paths in your product: + meta data to user data...

Could you pin-point this in one of the XDb2 scripts posted thus far and
also post RM's equivalent script which doesn't?

 > RM has one.

XDb2 has two, one high-level and one low-level. Each has it's
advantages and disadvantages. Can you demonstrate some advantages of
having only one?

  >> Second, suppose Terrorist take over the US. As part of
  >> their spoils they demand you and I reverse the spelling
  >> of every thing named 'Troy'.
 >
 > That's all you have ...

It only takes one.

 > ... a ridiculous example?

While a person might judge an example to be "ridiculous", it shouldn't
prevent a data model from being able to model/manipulate the data as
such. See "A Normalization Question" for other less "ridiculous"
examples. Apparently your experiences in data management are limited in
scope if you haven't yet come across situations where the unimaginable
becomes reality.

 > No one would arbitrarily change *all* references to a specific
 > value into a reference to another value (such as, the number 2
 > into the number 1492) in any but the simplest db and expect
 > to retain usable data.

Again, while a person might judge that no one would perform a certain
operation, it shouldn't prevent a data model from being able to do so.
Such restrictions should be built in the app layer not the db layer.
Apparently your experiences in data management are limited in scope if
you haven't yet come across situations where the unimaginable becomes
reality.

 > Duplicate facts cause corruption...

Yes, and the string 'Troy' is a fact as much as a quarterback or a city
is a fact. See RM example posted earlier where Male is a "value" with
respect to John, is also a "fact" just as much as John. In the example
below, it is rather obvious to deduce that within the constructs of RM,
Male is just as much a "fact" as John is a "fact" even if Male is a
"value" with respect to John and Bob.

T_Gender
ID Name Abbr
1 Male M

T_Person
ID Name GenderID
2 John 1
3 Bob 1

 > Duplicate values are needed
 > (Sam has 2 children; Mary has 2 children.)

ARE YOU READING WHAT YOU ARE WRITING? One does NOT need duplicate
things in a db. It is redundant. It can lead to corruption. "Values"
are not duplicated in XDb2 and duplicate value can be eliminated in RM
by employing generic modelling (which is not always practical). See
example above, where both John and Bob have the same "value" Male
without redudancy. (No the ID 1 is not redundant data! See "A
Normalization Question")

  >> Third, suppose we want to add an attribute to the string 'Troy'.
  >> In XDb2, it would be simply (CREATE 'Troy'.point value = 15).
  >> In RM, you will need to change the schema to normalize all the
  >> redundant 'Troy's so that the attrubute can be added
non-redundantly.
 >
 > Actually, assigning an attribute to heterogeneous references
 > to a value is likely cause integrity problems.

In XDb2, the attributes are assigned to the one and only "value" not to
references to the value. The same can be accomplished in RM using
generic modelling (which is not always practical). See example above
where the attribute abbreviation is added to Male which is both a
"fact" and a "value" in RM speak.

 >From the example I gave earlier where "John isa Person" and "John is
Male" and "Male isa Gender", you still have not yet realized that while
Male is a value with respect to John, Male can have it own attributes
for example "Male is a Gender" or "Male is abbreviated as M" or "Male
point value is 8". Just as Male is a value with respect to John, there
are other things that are values with respect to Male. It is recursive.
Please read "Godel, Escher, Bach: An Eternal Golden Briad". Please post
RM's equivalent script/queries for that modelled by XDb2, irregardless
of your personal judgements about particular data or operations.

 > Get serious!
 > There is a wealth of information available on those aspects of RM.

Please post some verifiable scripts/queries to support that wealth of
information.

 > In this short article I've already shown that you have an ad-hoc
 > organization, information is not guaranteed accessible, integrity
 > and usability are not perserved and your query facility is not
 > declarative.

You have shown nothing verifable in this short article. Please post
equivalent RM's script/queries for city and quarterback named 'Troy' to
support your assertions.
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 36) Posted: Sat Feb 19, 2005 9:30 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 > Funny, even you can't design properly in your data model.

Even funnier, you can't post ANY verifiable RM scripts using a
methodology with a +30 yr history and the help of Pascal. Please
support your assertion by posting the "proper" RM design that
accomplishes the same as XDb2's.
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 37) Posted: Sat Feb 19, 2005 9:56 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 > The original question was about a *normalized* many-to-many design.
 > Your solution uses a completely different design that's not even 1NF.

Your conceptions of what is normalized or 1NF within the constructs of
RM are of little consequence as XDb2 models and queries the desired
things. Please post RM's equivalent script/queries.

 > Why do you rattle on about normalization
 > when your product doesn't support it and you don't use it?

I'd rather not rattle about normalization. I'd rather focus on actually
demonstrating things. I have already demonstrated XDb2's
scripts/queries for user's problem. Please demonstrate RM's equivalent
script/queries by posting them.
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 38) Posted: Sat Feb 19, 2005 10:05 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 > BTW, your design also mixes meta data and user data.
 > Using user data values as names (meta data) is incorrect.

BTW, I have already posted XDb2's solution to model/query the things
desired by user. Please support your assertions by posting RM's
equivalent using whatever you feel is the "correct" method and doesn't
mix "meta data" with "user data".
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 39) Posted: Sat Feb 19, 2005 1:27 pm
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 > * The Ultimate DBMS is here!

Why not support your assertion by using the Ultimate DBMS to model a
city and quarterback both named by the string 'Troy'? Assign the string
an attribute "point value" of 15. Then show a query which finds all
things named by a string with the point value of 15. I have already
posted XDb2's solution. Use ANY method in your disposal to do the same.
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
Lee Fesperman

External


Since: Aug 10, 2003
Posts: 56



(Msg. 40) Posted: Mon Feb 21, 2005 3:40 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Neo wrote:
 >
 > Yes, and the string 'Troy' is a fact as much as a quarterback or a city
 > is a fact.

None of those are facts.

Anyway, I'm done here.

You continue to blur important distinctions. Your only purpose in claiming that values
and facts are the same is to confuse and to prevent meaningful discussion.

You are a snake oil salesman preying on the gulliable.

Note to readers: Like Neo, I'm associated with a vendor, so feel free to ignore my
advice. I recommend all readers educate themselves on database matters, to see through
the hype. You can start at Database Debunkings (http://www.dbdebunk.com) as they are not
vendor oriented.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 41) Posted: Mon Feb 21, 2005 1:10 pm
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 > Anyway, I'm done here.

I am sorry you are leaving without posting any RM solutions to support
your assertions.

 > You continue to blur important distinctions. Your only purpose
 > in claiming that values and facts are the same is to confuse
 > and to prevent meaningful discussion.

Feel free to call somethings "facts" and others "values" within the
context of RM. The important thing is a data model's suitability for a
given scope. While RM has a broad scope and is the appropriate tool in
many applications of today, its scope does not cover everything as RM
expert have been falsely propogating for at least the last few years in
these newsgroups.
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
Lee Fesperman

External


Since: Aug 10, 2003
Posts: 56



(Msg. 42) Posted: Mon Feb 21, 2005 10:40 pm
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Neo wrote:
 >
  > > You continue to blur important distinctions. Your only purpose
  > > in claiming that values and facts are the same is to confuse
  > > and to prevent meaningful discussion.
 >
 > Feel free to call somethings "facts" and others "values" within the
 > context of RM.

(Bite my tongue for responding to you! But...) You are indulging in gross distortions.
This is bigger than RM or even database. These concepts apply to logic, mathematics,
language, ... A fact is a logical proposition that is true or not. Try saying this out
loud: Sam has 2 children is true. This makes sense. 1492 is true or 'Troy' is true makes
no sense, without additional context to turn it into a proposition or fact.

I'm just tired of your crap. You refuse to educate yourself.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
neo55592

External


Since: Dec 06, 2004
Posts: 206



(Msg. 43) Posted: Tue Feb 22, 2005 11:47 am
Post subject: Re: Help Understanding OODBMS' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 > (Bite my tongue for responding to you! But...) You are indulging in
 > gross distortions. This is bigger than RM or even database. These
 > concepts apply to logic, mathematics, language, ... A fact is a
 > logical proposition that is true or not. Try saying this out loud:
 > Sam has 2 children is true. This makes sense. 1492 is true or 'Troy'
 > is true makes no sense, without additional context to turn it into
 > a proposition or fact. I'm just tired of your crap.
 > You refuse to educate yourself.

I hope you will come back when you are able to apply your definitions,
logic, mathematics, concepts and language to support your assertions by
posting verifiable solutions.
 >> Stay informed about: Help Understanding OODBMS' 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
oops help - Question 1:- Describe the following with the help of examples: 1)Generalization and its role in Inheritance. 2)abstract Classes 3)State Diagrams. 4)OMT and its impact in programming. 5)future of Object Oriented languages. Qusetion2: -Identify the..

Idempotent ODBMS iterators - I am building a client/server ODBMS in Java. It occurred to me that one way of helping to guarantee the consistency of the database was to ensure that all atomic requests were idempotent -- that is, that if a particular request is performed more than..

Modelling Books (with XDb2) -

CfP Reminder: The Second Scala Workshop - Scala Days 2011 - The Second Scala Workshop ========================= Call for Papers --------------- Scala is a general purpose programming language designed to express common programming patterns in a concise, elegant, and type-safe way. It smoothly integrates..

CGVCVIP 2011 (Rome, Italy) - 1st call extension: until 28 .. - Apologies for cross-postings. Please send to interested colleagues and students -- CALL FOR PAPERS - Deadline for submissions (1st call extension): 28 March 2011 -- IADIS INTERNATIONAL CONFERENCE ON COMPUTER GRAPHICS, VISUALIZATION, COMPUTER VISION..
   Database Help (Home) -> Object-Oriented All times are: Pacific Time (US & Canada)
Goto page Previous  1, 2, 3
Page 3 of 3

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]