The following dbd query finds persons who like either red fruits or
crunchy veggies:

(and (select person instance *)
(select * like (or (and (select fruit instance *)
(select * color red))
(and (select veggie instance *)
(select * texture crunchy))
)
)
)

What RMDB schema and SQL query will find the equivalent? Should I start
with T_Person, T_Fruit, T_Veggie, T_PLikeF, T_PLikeV ?

In your language, can you query:
How many fruit colors are there? Which fruit color(s) is/are the most
liked? How many veggies are there that nobody likes?


Neo wrote:

Currently dbd's NLI (SQL-type) interface implements very basic
functions such as create, select, update and delete (and a few others
listed at www.dbfordummies.com/NLI/function.asp).

Even modest functions such as MIN, MAX, etc would need to be
implemented by application interfacing to a db via API. See
www.dbfordummies.com/example/ex010b.asp which generates a nearest
common ancestor report for things in a hierarchy.

Below are the closest queries that dbd can perform via its NLI:

(; Count fruits)
(count (select fruit instance *))

(; Count colors for fruits)
(count (and (select color instance *)
(select (select fruit instance *) color *)))

(; Find veggies somebody likes)
(and (select veggie instance *)
(select (select person instance *) like *))

kvnkrkptrck (AT) gmail (DOT) com wrote:
How about relational division type of queries?

i) find all job applicants who have all the skills (or find pilots that
can fly all the airplans)

ii)
table sets (
set# integer,
element integer
)

e.g. {{1,2,3},{3,4}}
set# element
---- ---------
1 1
1 2
1 3
2 3
2 4

find the intersection of the sets (i.e. all the elements that belong to
all the sets).

Neo wrote:
I like tomatoes. Imagine a world without them. No ketchup. No pizza
base. Are they fruit or veges? They're not especially crunchy though
anyway. What about red capsicums? Are they crunchy veges or fruit?

Neo wrote:
definition of dbd schema?

Tonkuma wrote:
Please don't encourage Neo. He has an experimental system he created
himself. It is non-relational and "nonredundant" in the extreme. (e.g.,
he attempts to store the word red only once, whether it is used as the
color of fruit to someones nickname or a terrorist status).

Do a google search in this group is you feel like browsing nonsense.
Ed

Beware, there be trolls around here.

Dbd's "schema" is approximately as follows:
A sheet of paper with infinite lines (limited by memory),
where each lines can have a sentence of any length (usually 3 words).

This "schema" permits the following example:

(new 'red 'color)
(new 'yellow 'color)
(new 'green 'color)

(new 'soft 'texture)
(new 'crunchy 'texture)

(new 'apple 'fruit)
(create apple color red)
(create apple texture crunchy)

(new 'banana 'fruit)
(create banana color yellow)
(create banana texture soft)

(new 'celery 'veggie)
(create celery color green)
(create celery texture crunchy)

(new 'zuchinni 'veggie)
(create zuchinni color green)
(create zuchinni texture soft)

(new 'tomato 'fruit 'veggie)
(create tomato color red)
(create tomato color yellow)
(create tomato color green)
(create tomato texture soft)

(new 'like 'verb)

(new 'john 'person)
(create john like banana)
(create john like celery)

(new 'mary 'person)
(create mary like apple)
(create mary like zuchinni)

(new 'bob 'person)
(create bob like banana)
(create bob like zuchinni)
(create bob like tomato)

(new 'sue 'person)
(create sue like banana)
(create sue like zuchinni)


(; Who likes red fruits or crunchy veggies?)
(; Finds john, mary and bob)
(and (select person instance *)
(select * like (or (and (select fruit instance *)
(select * color red))
(and (select veggie instance *)
(select * texture crunchy)))))


See www.dbfordummies.com/NLI/new.asp for details on new function.

(new 'red 'color)
(new 'red 'person)
(new 'red 'terrorStatus)

(; Find the class of things named red)
(; Returns color, person and terrorStatus)
(select * instance (select * name 'red))

New function details at www.dbfordummies.com/nli/new.asp

How can I do this in SQL? Below script models the data in dbd, however
the query does not work (currently the function named ALL does not
exist).

(new 'fly 'verb)

(new 'jet1 'jet)
(new 'jet2 'jet)

(new 'pilot1 'pilot)
(create pilot1 fly jet1)

(new 'pilot2 'pilot)
(create pilot2 fly jet1)
(create pilot2 fly jet2)

(; Find pilots who fly all jets)
(; Does not work currently)
(and (select pilot instance *)
(select * fly (ALL (select jet instance *))))