|
|
 |
五大資料庫管理系統之比較總表
| 比較項目 |
廠牌名稱及功能 |
| Relational
Data Model |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Domains |
No |
No |
No |
No |
Yes |
Referential-integrity
violation options |
Restrict,
Cascade delete |
Restrict |
Restrict,
Cascade delete |
Restrict |
Restrict |
| Updateable
views |
Yes |
Yes |
Yes |
Yes |
Yes |
| Database
Objects |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
User-defined
data type |
Yes |
Yes |
Yes |
Yes |
Yes
(domain) |
| BLOBs |
Yes |
Yes |
Yes |
Yes |
Yes |
| Additional
types |
Image, video,
text, messaging,
spatial |
Image, money,
bit, text |
Byte, text |
|
File object |
| Table
Structure |
Heap,
clustered |
Heap,
clustered |
no
choice |
no
choice |
no
choice |
| Index
Structure |
B-tree, bitmap,
heap |
B-tree |
B-tree,
clustered |
Clustered |
B-tree |
| Tuning
facilities |
Table and
index
allocation |
Index pre-fetch,
I/O buffer cache,
block size,
table partition |
Extents,
table fragmentation
by expression or
roundrobin |
Fill factor,
allocation |
Fill factor,
frame size
|
| Trigger |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Level |
row-based,
set-based |
set-based |
row-based,
set-based |
set-based |
row-based,
set-based |
| Timing |
before, after |
after |
before,
for each, after |
after |
before,
for each, after |
| Nesting |
Yes |
Yes |
Yes |
Yes |
Yes |
| Stored
Procedures |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Language |
PS/SQL |
Transact-
SQL |
SPL |
Transact-
SQL |
ESQL/C |
| Nesting |
Yes |
Yes |
Yes |
Yes |
Yes |
| Events |
Yes |
Time-bases
events |
No |
No |
No |
| Queries |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Locking
level |
table,
row |
table,
page |
database, table,
page, row |
database, table,
page, row |
database, table,
page, row |
| Escalates
locks |
No |
Yes |
No |
Yes |
Yes |
| Cursors |
Forward |
Forward |
Forward,
backward |
Forward,
backward,
relative,
absolute |
Forward,
backward,
first, last
relative,
absolute |
| Outer
joins |
Yes |
Yes |
Yes |
Yes
(ANSI syntax) |
Yes |
ANSI
SQL
compliance |
Entry-Level
SQL 92 |
Entry-Level
SQL 92 |
Entry-Level
SQL 92 |
Entry-Level
SQL 92 |
Entry-Level
SQL 92 |
| Database
Administration |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| security |
C2 |
C2 |
C2, B1 |
NT integrated |
C2 |
Partial
backup &
recovery |
Yes
(tablespace) |
Yes |
No |
Yes
(table) |
No |
| Autoextend
tablespace |
Yes |
No |
No |
No |
Yes |
| Internet |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Internet
support |
Oracle
WebServer |
web.sql |
ESQL or
4GL CGI
interface kit |
IIS on NT |
CGI |
| Distribution |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Distributed
database |
Yes |
Yes |
Yes |
? |
Yes |
| 2PC
protocol |
Yes |
Yes |
Yes |
? |
Yes |
| Hetergeneous |
through
gateway |
through
gateway |
No |
? |
No |
| Optimization |
Yes |
Yes |
Yes |
? |
Yes (not
includes
network
cost) |
| Replication |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Hot
Standby |
Yes |
Yes |
Yes |
Yes |
Yes |
| Ownership |
Yes |
No |
Yes |
No |
No |
| Peer-to-peer |
Yes |
No |
Yes |
No |
No |
| Cascading |
Yes |
Yes |
No |
No |
No |
| Fragment |
Yes |
Yes |
Yes |
Yes |
No |
| Projection |
No |
Yes |
Yes |
Yes |
No |
| To
other DBMSs |
through
gateway |
through
gateway |
No |
through
ODBC |
No |
| Architecture |
2-tier |
3-tier |
2-tier |
3-tier |
2-tier |
| Platforms |
Oracle |
Sybase |
Informix |
Microsoft |
DBMaker |
| Platforms |
UNIX, 95, NT,
VAX, VMS,
OS/2, Macintosh |
UNIX, 95, NT,
VAX, VMS,
OS/2, Macintosh |
UNIX, 95,
NT |
NT |
UNIX, 95,
NT |
參考資料:
1. Robin Schumacher, "DBA Tools Today", DBMS,
Jan,1997
2. Martin Rennhackkamp, "Comparison Summary",
DBMS, Nov,1996
3. Cor Winckler, "Microsoft SQL Server 6.5", DBMS,
Nov, 1996
4. Willem Roos, "Informix-Online Dynamic Server 7.2",
DBMS, Nov,1996
5. Martin Rennhackkamp, "Sybase SQL Server 11",
DBMS, Nov,1996
6. Martin Rennhackkamp, "Oracle7 Release 7.3",
DBMS, Nov, 1996
7. Steve Roti, "Indexing and Access Mechanisms",
DBMS, May,1996
8. Oracle Webserver Release 1.0 Datasheet
9. Kevin Reichard, "Web Server for Database Applications",
Internet
Systems, Oct,1996
10. Robin Schumacher, "Universal DBMSs and the Web"Internet
Systems, Apr,1997
11. Charles J.Bontempo and C.M.Saracco, "Accelerating
Indexed
Searching", Database Programming & Design,1995
12. Sybase web.sql Programmer's Guide
13. Microsoft SQL Server 6.5 Books
14. Alex Berson and George Anderson, Sybase and Client/Server
Computing,1996
15. DBMaker Reference manua7ls
16. DBMaker Technical Report |
|
|
|
Copyright
2002 SYSCOM Computer Engineering Co. All rights reserved.
|
|
|
