Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!dciem!nrcaer!cognos!garyp From: garyp@cognos.UUCP (Gary Puckering) Newsgroups: comp.databases Subject: Re: Sybase Message-ID: <452@cognos.UUCP> Date: Fri, 20-Mar-87 14:29:51 EST Article-I.D.: cognos.452 Posted: Fri Mar 20 14:29:51 1987 Date-Received: Sun, 22-Mar-87 05:36:36 EST References: <1094@ur-tut.UUCP> Reply-To: garyp@smokey.UUCP (Gary Puckering) Organization: Cognos Incorporated, Ottawa, Canada Lines: 51 In article <1094@ur-tut.UUCP> jdia@ur-tut.UUCP (Wowbagger) writes: >Does anyone out there in netland know anything about a database system >called "Sybase" ?? It is supposed to run using networked suns, ibm-pcs, >microvaxen, real-vaxen, pyramids, etc. It does this using either tcp-ip or >decnet. > >The user interface uses menus (pop-down) and windows. It likes mice, >but they are not required. > >They claim that to create an automated application one need write no code, >just use their application generation system. > >Rules, triggers, etc. are implemented as part of the database, and therefore >need not be part of the application. Sybase claims performance in the 35 transaction per second range on SUN-3 hardware in a multi-user environment (based on the time required to select a single row from a million-row table). They estimate this to be equivalent to 80 transactions per second on a VAX 8650 and 25 transactions per second on a MicroVax. Sybase supports the usual set of datatypes and some unusual ones: INT 4 byte integer SMALLINT 2 byte integer TINYINT 1 byte positive integer FLOAT 8 byte floating point (per hardware) CHAR(n) Fixed size character string up to 255 bytes VARCHAR(n) Variable-length string up to 255 bytes TEXT Text string up to 2,147,438,648 bytes (release 3.0) BINARY(n) Fixed length binary data up to 255 bytes VARBINARY(n) IMAGE Binary equivalent of TEXT BIT For boolean values (cannot be null) MONEY 8 byte, 15 digits, accurate to 1E-6 cents DATETIME 2 four-byte integers Using these base types, you can define your own. More information on Sybase can be obtained from: Sybase Inc. 2910 Seventh St. Suite 110 Berkely, CA 94710 (NB. This information was accurate as of June 1986) -- Gary Puckering 3755 Riverside Dr. Cognos Incorporated Ottawa, Ontario decvax!utzoo!dciem! (613) 738-1440 CANADA K1G 3N3 nrcaer!cognos!garyp