DBMS


Guidelines for Selecting Database Application Development Tools

FeatureWeightRatingScoreComments
Repositories
Metadata
Extended data attributes
Object storage
Team development (check in/check out)
Database support (choice of storage environment)
Visual repository information
Support for third-party repositories
Database Design Facility
Logical database design
Physical database design
Schema generation and reverse engineering
    Sybase SQL Server
    Oracle
    Microsoft SQL Server
    Informix
    IBM DB2
    Other native drivers
    ODBC data sources
Write, test, debug stored procedures and triggers
Database Connectivity
Sybase SQL Server
Oracle
Microsoft SQL Server
Informix
IBM DB2
Other native drivers
ODBC
JDBC
Local/test database engine
Support for extended relational features
-(User-defined types and methods/operators, and so on)
Client/Server Architectures Supported
File-oriented shared database
Web browser/thin client
Two-tier
Two-and-a-half-tier (3270 screen scraping)
Three-tier (such as TP monitors)
Four-tier (such as Web and TP monitor)
N-Tier (such as distributed objects)
Application Design Facilities
Process model
Object browser
Integration with CASE Tools
  • Rational Rose
  • Select OMT or Enterprise
  • Popkin System Architect
  • Logic Works ERwin
  • Others
User interface designer
Generate application forms and other objects
Object-Oriented Features
Inheritance
Multiple inheritance
Encapsulation
Polymorphism
Abstraction
Programming Language
4GL
3GL
Procedural
Event-driven
Database manipulation features
Application Deployment
Deployment
  • Interpreter
  • Compiler
Size of .dll
Size of .exe
IDE Features
Code editor
Debugger
  • Set break point
  • Variable watch
  • Single step through code
Object browser
  • Object
  • Method
  • Display hierarchy
Interface builder
Configuration mgmt./version control
Performance
Interface processing
Database access
Application object processing
Load balancing
Language processing
Third-Party Component Integration
ActiveX
VBX
OLE container
OLE automation server
Java Beans
Distributed objects
Java applets
Platform Support
Windows 3.1
Windows 95
Windows NT
OS/2
Macintosh
Unix
Web browser
Other
Scalability
10 users
50 users
100 users
200 users
500 users
1000 users
Internet (thousands of users)
Links to External Resources
MAPI
Message-oriented middleware
CORBA
COM/DCOM
TP Monitors
Internet
Cost
Per seat (developer)
Per seat (user)
Technical supports and upgrades /separate-cost items
Application Partitioning Features
Proprietary objects
CORBA distributed objects
Distributed Component Object Model (DCOM)
Performance monitoring console
Partitioning at the object level
Partitioning at the method level
Internet/Intranet Development Capabilities
HTML generation
CGI application generation
Java applet generation
ActiveX generation
CORBA (IIOP) object generation
Reporting Capabilities
Reporting included
Cross tabs
Banding
Formatting capabilities
Application integration
Support for user-defined functions
Number of functions
Accesses OLAP and multidimensional servers
Other Issues
Training availability
Configuration mgmt./version control
Available programmer talent
Frequency of upgrades
Vendor's financial viability

This worksheet is designed for developers conducting customized evaluations.
Not everyone assigns the same weight to each criterion or the same rating to each product.
This is the expanded version of the in-print chart.


David S. Linthicum is a widely published author, speaker, and senior manager with AT&T Solutions Systems Integration Practice in Chantilly, Virginia. You can email David at dlinthicum@attsolva.attmail.com.

Return to main article

Return to Home Page


Copyright © 1997 Miller Freeman, Inc. ALL RIGHTS RESERVED

Please send questions or comments about this Web site to dbms@mfi.com
Updated Tuesday, March 18, 1997