RE: [U2] Why Buy (or develop in) UniVerse?
David, Don't forget to invoice IBM when they use this! ;) Regards, Ray (presently in Japan,therefore missing U2 University) > - Original Message - > From: "David Jordan" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Why Buy (or develop in) UniVerse? > Date: Wed, 13 Aug 2008 10:18:21 +1000 > > > Hi Louie > > Intersystems have done some benchmarks of multidimensional databases versus > RDBMS and some of that logic follows through to UniVerse. > > It is difficult to compare UniVerse to RDBMS in benchmarks as they are > designed for RDBMS strengths. If a benchmark was designed for UniVerse > strengths instead, RDBMS would not look so rosy. > > RDBMS databases are designed to optimise cache and indexing because of the > performance issues in the database. UniVerse does not inherit those > performance issues, hence they do not need to optimise Cache and indexs to > the same extent and the optimisations needs to be different. > > There are hosts of differences. > RDBMS have fixed length and fixed structure records, where as UniVerse has > variable length records and fields can be added at any time. More UniVerse > records can fit on a disk sector than RDBMS rows increasing U2 performance. > RDBMS don't efficiently lock rows, they do group locks. Universe can lock > individual records without performance hits. > RDBMS work with optimistic locking as pessimistic locking is a nightmare > with group locking. UniVerse can handle both optimistic and pessimistic > locking. > RDBMS stores all tables within one file, UniVerse has a file for every > table. Totally different approaches for BU, Restore and handling file > corruptions. > RDBMS have to join multiple tables which creates overhead and referential > integrity issues. UniVerse stores all specific data in a multidimensional > record. > UniVerse is close to Zero-Administration, where RDBMS still require > expensive Database administrators. > RDBMS have large workloads in setting up security access to tables for > different users. UniVerse can use table security or OS file security. > RDBMS have limited functionality in business rules stored in the database. > UniVerse can handle complex business rules with ease. In complex > applications UniVerse is well ahead. > > However the argument should not be technical. The CEO and board does not > make decisions on Cache and indexes, they make it on a business case. ROI, > Cost of running, Staff numbers to administer and develop, competitive > advantage. The old joke was what hardware does Oracle run best on, a > projector. Oracle markets to CEOs and does little technology discussion, > that is why they are successful. > > Its horses for courses, but if a project is going to be complex, the success > rate of the project completing on time and on cost in UniVerse is near 100%, > on an RDBMS the numbers are scary. > > Regards > > > David Jordan > > Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] TCL literal select
Bruce Ordway wrote: Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. To include double-quote within field to be searched, use single quote as delimiter. SELECT PARTS WITH F1 = '["' -or- SELECT PARTS WITH F1 LIKE '..."...' -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why Buy (or develop in) UniVerse?
Hi Louie Intersystems have done some benchmarks of multidimensional databases versus RDBMS and some of that logic follows through to UniVerse. It is difficult to compare UniVerse to RDBMS in benchmarks as they are designed for RDBMS strengths. If a benchmark was designed for UniVerse strengths instead, RDBMS would not look so rosy. RDBMS databases are designed to optimise cache and indexing because of the performance issues in the database. UniVerse does not inherit those performance issues, hence they do not need to optimise Cache and indexs to the same extent and the optimisations needs to be different. There are hosts of differences. RDBMS have fixed length and fixed structure records, where as UniVerse has variable length records and fields can be added at any time. More UniVerse records can fit on a disk sector than RDBMS rows increasing U2 performance. RDBMS don't efficiently lock rows, they do group locks. Universe can lock individual records without performance hits. RDBMS work with optimistic locking as pessimistic locking is a nightmare with group locking. UniVerse can handle both optimistic and pessimistic locking. RDBMS stores all tables within one file, UniVerse has a file for every table. Totally different approaches for BU, Restore and handling file corruptions. RDBMS have to join multiple tables which creates overhead and referential integrity issues. UniVerse stores all specific data in a multidimensional record. UniVerse is close to Zero-Administration, where RDBMS still require expensive Database administrators. RDBMS have large workloads in setting up security access to tables for different users. UniVerse can use table security or OS file security. RDBMS have limited functionality in business rules stored in the database. UniVerse can handle complex business rules with ease. In complex applications UniVerse is well ahead. However the argument should not be technical. The CEO and board does not make decisions on Cache and indexes, they make it on a business case. ROI, Cost of running, Staff numbers to administer and develop, competitive advantage. The old joke was what hardware does Oracle run best on, a projector. Oracle markets to CEOs and does little technology discussion, that is why they are successful. Its horses for courses, but if a project is going to be complex, the success rate of the project completing on time and on cost in UniVerse is near 100%, on an RDBMS the numbers are scary. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Why Buy (or develop in) UniVerse?
These questions have come up so many times I'm almost sick of hearing it. I really wish that IBM would get off their duff and get some of these questions answered. I just wonder why they don't run the tests against the other databases. If their afraid to run them against DB2 for fear that their shinning star can be beat then don't do it against it, but at least they could run the tests against their competitors. And don't tell me that it's like testing apples and oranges because we all know that we can build either U2 product to act like an SQL database. If you do find that U2 is not up to other relational databases in their world then try using it natively. Jerry -- From: "Louie Bergsagel" <[EMAIL PROTECTED]> Sent: Tuesday, August 12, 2008 6:08 PM To: Subject: [U2] Why Buy (or develop in) UniVerse? Has anyone compiled any reasons for buying or developing in UniVerse vs. Oracle or some other relational database? I keep hearing things like: - UniVerse doesn't cache like a relational db - UniVerse doesn't use indexes properly - UniVerse selects aren't as fast as a relational db and I don't know what to reply. I've googled Multivalue vs. Oracle and found a bunch of complaints that UniVerse doesn't manage data or security like some people think it should. I have a friend who said that sometimes he just wished someone would tell him what to do. He would probably not like UniVerse. I found one white paper on IBM: ftp://ftp.software.ibm.com/software/data/u2/pubs/whitepapers/202452.pdf It would be nice to see hard data like: - Universe vs. Oracle speed benchmarks such as - time to select a 4 million record file. - time to update 4 million records. - time to LIST 4 million records. - UniVerse vs. Oracle tables per (Order Entry, for instance) app - number of UniVerse programmers to support a $100m sales company vs. Oracle - Cost of a UniVerse system vs. Oracle. Oracle here is generic for any relational data base management system, I suppose, including DB2. -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Why Buy (or develop in) UniVerse?
Has anyone compiled any reasons for buying or developing in UniVerse vs. Oracle or some other relational database? I keep hearing things like: - UniVerse doesn't cache like a relational db - UniVerse doesn't use indexes properly - UniVerse selects aren't as fast as a relational db and I don't know what to reply. I've googled Multivalue vs. Oracle and found a bunch of complaints that UniVerse doesn't manage data or security like some people think it should. I have a friend who said that sometimes he just wished someone would tell him what to do. He would probably not like UniVerse. I found one white paper on IBM: ftp://ftp.software.ibm.com/software/data/u2/pubs/whitepapers/202452.pdf It would be nice to see hard data like: - Universe vs. Oracle speed benchmarks such as - time to select a 4 million record file. - time to update 4 million records. - time to LIST 4 million records. - UniVerse vs. Oracle tables per (Order Entry, for instance) app - number of UniVerse programmers to support a $100m sales company vs. Oracle - Cost of a UniVerse system vs. Oracle. Oracle here is generic for any relational data base management system, I suppose, including DB2. -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] TCL literal select
or LIST PARTS WITH F1 LIKE \..."...\ I find dots easier to type then left and right brackets. -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
Consider trying... LIST PARTS WITH F1 LIKE '..."...' --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: TCL literal select
I tried using the lower case "SELECT/LIST" to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '"', '~') RETURN ED DICT PARTS F1.TILDA I SUBR("TILDA", F1) ... SELECT PARTS WITH F1.TILDA = "[~]" John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
LIST PARTS WITH F1 = /["]/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: 12 August 2008 21:00 To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Internal Virus Database is out of date. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.12/1599 - Release Date: 07/08/2008 20:49 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] TCL literal select
Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/