Do you mean like SQL?  Oracle has SQL+ that uses their PL/SQL language.

Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839 



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Dawn M. Wolthuis
Sent: Thursday, April 15, 2004 8:04 AM
To: 'U2 Users Discussion List'
Subject: RE: Jbase handles multivalue on RDBMS


Do you know if there is a flavor of the type-it-in multivalue query language
(e.g. UniQuery) that can be executed against data stored in Oracle, DB2, SQL
Server, etc?  I know that DataBASIC can be with jBASE and ONGroup, for
example.

--dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of djordan
Sent: Thursday, April 15, 2004 12:27 AM
To: 'U2 Users Discussion List'
Subject: Jbase handles multivalue on RDBMS

Hi Steve

Just to correct you, jbase does not require you to move to 1NF files to run
on an RDBMS.  Jbase will port multi dimensional data across to an RDBMS and
automatically handle the conversion to multiple tables invisible to the
application.  The issue is in the quality of the dictionary, like lengths
and data types that RDBMS do not handle breaking the rules.  Jbase does
handle a lot of these issues and I would assume IBM will incorporate that in
U2.  Also in such an environment you would not move all your files over to
an RDBMS, it would make sense to leave work files and control files in
Universe which are usualy the worst offenders.  If you wish to make your
application portable in a future environment like this, look at SQLising
your files including multivalues and starting cleaning your data as this
will be your biggest issue, not multivalues.

Just another point, jbase does the same for Cache, which is another
multi-dimensional database, although not PICK.

Regards

David Jordan

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Steve Mayo
Sent: Thursday, 15 April 2004 4:01 AM
To: U2 Users Discussion List
Subject: RE: The future of U2


The way that jBase handles the problem is by requiring the database be
flattened out (i.e., no multivalues) and strict data typing. This is of
course the standard with 1NF databases. Unfortunately for most of us, it
means a complete redesign of the existing mv database structure. Over the
past several years, all new systems that I have developed have used 1NF.
Still most of the data still uses multivalues and would take years to
convert. :-)

Steve

-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately. 

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to