Path: utzoo!attcan!uunet!cs.utexas.edu!sun-barr!ames!pasteur!zooey.Berkeley.EDU!c162-aj From: c162-aj@zooey.Berkeley.EDU (Mark Christiansen) Newsgroups: comp.databases Subject: Re: Ingres vs Sybase Message-ID: <13680@pasteur.Berkeley.EDU> Date: 12 May 89 17:52:51 GMT References: <4306@elecvax.eecs.unsw.oz> <2350@canisius.UUCP> Sender: news@pasteur.Berkeley.EDU Reply-To: c162-aj@zooey.Berkeley.EDU.UUCP (Mark Christiansen) Organization: University of California, Berkeley Lines: 27 A magazine/newspaper called Computerworld has many very good articles comparing and describibg various databases. As for some recent light research that I have done on Sybase, they are (as of the articles read from 1988) the only database with government security clearance, data integrity (ie. non null primary keys, and matching foreign keys, etc), and they have an excellent data backup. The DB may be proted from one VAX on a network to another if the original 'goes down' and the DB also uses a mirror disk access system where it saves to different places on the disk, or different drives simultaneously to protect lose of data to disk crashes (or limits the lose at least). DataServer (the DBMS for Sybase) also using a multi-threaded access to relations so that many users may be using the exact same info without integrity conflict (ie. one writer, but many readers) and DataServer also can shovel many users into a small area. Somewhere on the order of 50 users to 1 Meg (don't have the articles in front of me) which leaves massive room for caching resulting in less I/O. This is all in addition to the fact that Sybase is an amazing start-up company, only 5 1/2 years old with product for only 3 1/2, and also their remarkable DataTools that use bitmapped or character terminals automatically from the same server. Any other info or corrections to this enthusiastic but not too researched posting is welcome. Mark