Hi,
I need to perform a "scalability" comparison between the following databases:
1a) Sybase FMS V.11.0.3 on SUN UNIX 2.6
1b) Sybase Cluster V.11.5.1 on SUN UNIX 2.6
2) Oracle MLT V.2.2 on HP UNIX 7.3
3) MS Access MAP on Win NT 4.0 Server
4) INFORMIX BillDats V.7.30.UC2 on SUN UNIX 2.6
There are many parameters that could be considered. I've done some research
on the WEB and on the various newsgroups and I've found the ones written
below (but I'm totally open to suggestions).
Could you help me finding some of the answers for the four alternatives? Any
partial answers and/or advice would also be much appreciated. The questions
with a "+" are the most important to for my study...
Thanks very much.
Andrej
- Characteristics
- Intrinsic limitations:
case sensitivity
max number of foreign keys
(+)SQL syntax: compliance with which version of SQL, proprietary SQL,
stored procedure, dynamic SQL
(+)Unit of work (e.g. database or user?)
length of table and variable names
max number of tables in queries
Y2K compliance
- (+) Partitioning :
distribution
load sharing
- (+) Security (what about an eventual WEB access?)
- Complexity: learning curve (for DBAs, developers, "technical" users) and
education services available
- Performance
- (+)Max number of users
- (+)Max number of processors
- (+)Max hard disk space
- (+)Performance monitoring tools
- Compatibility/Interoperability with other applications - Import/export
from/to other database systems - (+)Interface with programming languages and
APIs - (+)does it allow you to pick the best components (both hardware and
software) and know that they will work well together?
- Adaptability - (+)guaranty that the system will accommodate advances in
technology - (+)financial situation of the DBMS vendor (for future
development and support) - years of presence on the market (maturity) -
(+)quality of technical support
- Affordability
- Takes advantage of the plummering prices in the personal computer and LAN
markets.
- cost scalability (increase of cost vs increase of the size of the database)
Thanks again.
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Mar 29 1999 - 11:55:20 CST
