Conference ulysse::rdb_vms_competition

795.0. "Who wrote this list?" by SUBWAY::KABEL (doryphore) Wed Nov 14 1990 18:37

    My customer gave me the following checklist for completion (no
    advice on checklists, please), and I suspect that it was copied from
    another vendor's "Does your database vendor provide...?" sheet. If
    it looks like that to you, please let me know. 
    
    The most likely vendor, btw, is Ingres.
    
    Thanks,
    Rik Kabel, NYBD Sales Support
    
    
I. Data Base Server Functional Criteria

1. SQL Standards
	Supports full ANSI compliant SQL
	SQL Extensions (if Y, please list)

2. Query Optimization
	Dictionary-driven
	Compile-time optimization
	Statistics-based
	Assumption-based
	Syntax independent

3. Performance
	I/O Reduction techniques (deferred writes, group
	commits, etc.)
	Support for performance monitoring tools
	Support for performance management tools
	Data base administration tools (specify)

4. Concurrency
	Isolation Levels
		Cursor Stability
		Read Consistency
		Read Repeatability
	Multi-versioning
	Locking	-row level (shared / exclusive)
		-page level (shared / exclusive)

5. Transaction Integrity
	Data Base Logging
	Rollback
	Roll Forward

6. Recovery
	On-line back-ups
	Automated back-ups (by time of day, by txn volume)
	Conditional and incremental back-ups

7. Security
	Access privileges
	Support for user groups
	Support for hierarchies of user groups
	Resource allocation quotas
	User action logging
	Application level security

8. Distributed Data Management (homogeneous)
	Location transparency
	Site Autonomy
	Distributed Queries
		Transparent Communications
		Distributed Query Optimization
		Distributed Deadlock Detection
	Distributed Updates
		Distributed Deadlock Detection
		2 Phase Commit
			In server
			Under Application Control

9. Data Integrity
	Referential Integrity (if Y, specify technique)

10. Extended Functions
	Stored Procedures (if Y, specify type ie compiled)
	In server 2 Phase Commit
	Triggers
	Multi-file Storage (ie fire walls between tables)

11. Object Management
	Data base server (NOT application level) support for:
	User defined data types
	User defined functions
	User defined operators

12. Knowledge Management
	In server (NOT application level) support for:
	Supports creation and maintenance of business rules
	Fired based on value based and (user defined) events
	Supports centralized rule control
	Supports unlimited rules per table (if limited, specify no.)
	Supports unlimited forward chaining of rules (if limited,
		specify no.)
	Supports unlimited recursion (if limited, specify no.)


II. Access to DB2

1. Table joins to DB2	-Read (transparent joins of VAX db to with DB2)
			-Update

2. Architectural Features
	Supports a common data dictionary and ability to create
	a transparent singular logical view of the data
	Supports bi-directional data flow (Y/N)
		VAX initiated upload requests of DB2 (Y/N)
		MVS initiated uploads to VAX (Y/N)
	Support for interactive SQL
	Ad hoc SQL generated by end-user tools

3. Transparency to Application Pgm
	Gateway remapping of differences in data types,
	Common error handling (via gateway)
	Common catalog information
	Common error codes
	Automated standardized requests to either data base

4. Optimization
		Optimized routing to data

5. Performance thru the gateway

7. Supports a full complement of SQL

8. Integrity and Security:
		requests preserved
		rollback and recovery
		Gateway supports RACF
		Ability of gateway to restrict access to data (DB2) )ie
			DB2 permission structures honored by gateway

9. Referential Integrity Across the Gateway

10. Heterogeneous 2 Phase Commit

11. Requires familiarity with DB2

    I would say that this is clearly a feature by feature listing of Ingres
    V6.3 functionality.
    
    		Stuart P.

    Yes, it is clearly Ingres. The question is, was the list copied from
    vendor literature?

    A few people have told me that the list in .0 is a copy (or very
    close copy) of an Ingres marketing piece. I would very much like a
    copy of that piece, but none of the people who have remarked on the
    similarity can put their fingers on it.
    
    If you have it, please fax it to me at dtn.352.2500 (212.856.2500).
    
    Thanks again,
    Rik Kabel, New York Bank District SWS
    
    
    (cross posted in  ULTRIX SQL  and  Ingres tools for Rdb  notes files)