On 12/19/05, Brutzman, Bill <[EMAIL PROTECTED]> wrote: > > Aside from U2 Personal Edition, are there any multi-value products like > say > IBM's CloudScape that do multi-value?
Are you asking only about IBM products or are you asking for all databases that permit multivalues? I don't know the answer related to CloudScape, but I know you can use jdbc to access it, and I think that SQL is the language of choice for access to the Cloudscape data. Some SQL-DBMS products have constructs for non-scalar values in a cell or for parent-child relationships between tables, both of which work for "multi-values." However, if they are using SQL for access, SQL-92 is what is used for ODBC and jdbc and is also the only easily ported version of SQL across databases. SQL-92 has no provisions for multivalues. So, even if products like PostgreSQL permit child tables (and they do), you could not take the same SQL statements and expect them to respond similarly in Oracle or DB2. As for non-IBM products, in addition to the many flavors of Pick, many databases that might be marketed as "embedded" permit multivalues, such as those from Sleepycat (Berkeley DB from Sleepycat is used extensively by Google, for example). Databases described as "object-oriented" or "XML databases" also permit multivalues. There are also flavors of Mumps, including Cache'. I'm interested in coming up with a name for all databases that 1) do not require first normal form and 2) use only a two-valued, not 3VL logic. MultiValue/Pick implementations are not the only products like that (even if they are the best ;-). I would guess that more data are stored in non-SQL-DBMS products than SQL-DBMS/RDBMS products, yet they don't have the market visibility. I don't like describing them as "non-SQL-DBMS," and "MultiValue" refers only to Pick. I'm starting a blog (everyone with half a mind to start one, does, eh?) and need to come up with a term for these, so if anyone has an idea ... Cheers! --dawn --Bill > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- Dawn M. Wolthuis Tincat Group, Inc. Take and give some delight today! ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
