Microsoft SQL Server 7.0 Oracle 8i Standard Edition
Quote:$1, 399 $3, 925 Per CPU
Already included a client to count 5 Users (named Or Concurrent) 5 Concurrent Users
Every add and intercurrent client / accredit client $127 / $127 $785 / $392.50
Server operating system supports Windows NT, windows 9x Windows NT, multiple Unix FlAvors
The client carries an operating system to support Windows NT, windows 9x All Server Platforms Plus WiNdows 9x
Network agreement supports AppleTalk, IPX, named Pipes, TCP/IP, vines IP IPX, named
Pipes, TCP/IP
Management
Graphical tool: ? ?
Install database Yes Yes
Build administrative database / disk device Yes / Yes Yes / Yes
Build management to express / index Yes / Yes Yes / Yes
Build Yes Yes of administrative memory process
Build administrative user Yes Yes
Establish government duplicate join Yes Yes
Back up and restore Yes Yes
COLOR=”#ffffff “%26gt;Web releases Yes Yes
Database chart Yes Optional
Refer SQL inquiry and postmortem result Yes Yes
Look carefully at Yes Optional of code of all and current executive SQL
Examination resource sensitivity inquires / cleared inquiry Yes / Yes Yes / Yes
Figure of server engine state changes Yes Yes
Executive plan shows Yes Optional
Offer the index that is based on onefold SQL statement to suggest / be based on server whole to apply Yes / Yes Optional /
Optional
All tools offer the visit means Yes Yes that is based on command travel
COLOR=%26quot;#ffffff%26quot;%26gt;Reverse-engineer Database Objects/data To A SQL Script
Yes / No Yes / Optional
Offer the script that is based on command travel means to support JScript, OS Commands, SQL, transact-SQL,
VB ScriptJava, OS Commands, PL/SQL, SQL, TCL
The administrator reachs the safe log No Yes of user activity
The time task that finish / Yes / Yes Yes / Yes of task of the activation when should appointing incident happening
Online manual reachs search Yes Yes
Server engine
Levels Of Locking Granularity Available Database, table, page, row DatAbase, table, row
Default Locking Level For Queries Row Row
Readers Can Block Writers/writers Can Block Readers At Default IsolatiOn Level No / Yes No / No
Can use multiprocessing implement divide a load / the inquiry that finish / build index Yes / Yes / No Yes / OptioNal / Optional
Can use multiprocessing implement the backup that finish and restore / update / delete Yes / No / No Optional / OPtional / Optional
Nest binds circularly (Join)/ no use binds / amalgamative coupling Yes / Yes / Yes Yes / Yes / Yes

Semi-join For Star Queries Yes Yes
B-tree Index/Clustered Index/Bitmap Index Yes / Yes / Yes** Yes / Yes
/ Optional
Cost-based/rule-based Optimizer Yes / No Yes / Yes
Every inquiry can use multiple index Yes Yes
Can Use Just The Index To Answer The Query Yes Yes
Safeguard what what need automatically to optimize condition Yes Yes
Parameter of dynamic SQL statement changes gentle to put Yes Yes
Support is built be stationed in the watch Yes Yes that keeps memory
Dynamic memory resource shares Yes No
Every server supports CPU to count 4 4
Optional Yes of zero accident server
Inquire resource manages Yes Yes
Can allocate No Optional of different and first step for different user or group
Increment backs up / Yes / Yes Optional / Optional can restore in some time place
8K 2K Or 8K of acquiescent disk data dimension
The user can choose No Yes of disk data dimension
Collateral / asynchronous (much task) disk operates Yes / Yes Yes / Yes
The capacity of data and log equipment can increase Yes Yes when need
2000 attestation / euro supports Yes / Yes Yes / Yes
Multimedia data type
Binary big data (BLOB) Yes Yes
Frequency / video / graphical No / No / No Yes / Yes / Yes
Text documentation / geographical sex data / time Yes / No / Yes** Yes / Yes / Optional
Seesaw pattern
Coupling is other database ODBC, OLE DB Optional
To the Yes / No / No Yes / Opt of onefold entry support of Windows NT / LDAP / OSF DCEIonal / Optional
But process designing sex
Memory process / trigger Yes / Yes Yes / Yes
Inside buy programming language Transact-SQLJava, PL/SQL
Memory process is debugged implement Optional Optional
The client carries a database to support DB/LIB, ODBC, OLE DB CORBA, enterpriseJavaBeans, JDB
C, OCI, ODBC, oracle Objects For OLE
Inquire language and database are designed
Version of SQL language supports SQL-92 Entry Level With Extensions SQL-92 Entry LevelWith Extensions
ANSI separator supports Read Uncommitted, read Committed, repeatable Read, serIalizable, read Only Read Committed, serializable, read Only
Left / right / Yes / Yes / Yes Yes / Yes / Yes of completely exterior coupling
Yes Yes of referenced statement integrality
Cascade is deleted / cascade updates No / No Yes / No
Object-oriented design supports / the object is referenced (REFs) No / No Yes / Yes
Branch office supports
One-way / two-way and duplicate Yes / Yes Yes / Yes
Pass Beep-Pager / Yes / Yes Yes / Yes of mistake of electronic correspondence clew
Manager tool can manage server Yes Yes remotely
Offer the administrative interface No Yes that is based on WEB
The database is distributed processing general affairs / undertake handling clerical Yes / Yes Yes / Yes according to the library with other class number

Data storehouse
Data lades the program can call disk page Yes Yes directly
Data is changed and arrange tool Yes Yes
When great data bulk is called defer agreement checks Yes Yes
Undertake to collect information beforehand operation Yes** Optional
Include OLAP server Yes Optional
Inquiry rescripts automatically summary table No Optional
Summaries understands dimensional structure Yes** Optional
When data is changed No Optional of information of automatic refresh collect
Can undertake data sampling increases processing speed No Optional
Top N inquires / Top N Percent Of Total inquires Yes / Yes Yes / No
Can Handle Ties When Ranking Top Rows Yes No
Cube/rollup function Yes / Yes Yes / Yes
Oracle 8i Windows NT Version With JServer And InterMedia Options.
**In OLAP Services Only.