Browse Prior Art Database

Method To Identify And Rank Essential Structural And Interdependent Elements For Robust Database Tool And Application Validation

IP.com Disclosure Number: IPCOM000201618D
Publication Date: 2010-Nov-16
Document File: 6 page(s) / 100K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method to prioritize testing on a given system by rank ordering the objects that have the most complex interdependencies. The invention provides a technique to identify and quantify essential database structural and interrelated elements in a given database schema. This ensures that no critical test scenarios are missed during database validation.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 30% of the total text.

Page 01 of 6

Method To Identify And Rank Essential Structural And Interdependent Elements For Robust Database Tool And Application Validation

Validating database tools and database applications is a complex task. These tools

and applications interact and modify database elements and data, and their validation requires that critical database scenarios be identified and exposed. The types of operations and transforms performed by these tools include database structural changes, data movement, basic object administration, database transactions, and multiple related database actions.

A typical enterprise database is large and contains a large number of relationships and

interdependencies. The number of possible test scenarios grows as the database grows, often exponentially. In order to validate a database tool, it must be subjected to these scenarios and combinations of scenarios. In fact, validation must capture the essential set of combinations on which the tool will operate and validate these scenarios using the tool.

Therefore, the value proposition provided by an effective validation framework is defined by the ability to identify both the test scenarios and the subset of those test scenarios that are essential and/or critical.

While there are many vendors that provide database tools and most modern applications require database interaction, there are not many available validation methods for these tools to evaluate their efficacy. Most tools and applications are tested manually or are subjected to simple automated tests and often miss critical database components. One reason is because the goal is often to exercise tool functionality. Test generators emphasize functional combinations, even on large databases. Without a rigorous and systematic method to identify high value objects on

which to apply those functional combinations, however, it is probable that many

scenarios, possibly critical scenarios, may be missed.

Database transforms, or operations in a database, are highly dependent on the database schema and the complexity of the schema; not only the object elements, but also the inter-relationships between them. Given this complexity, a number of diverse operations can be applied.

As the size of the schema increases, the number of

As a result, often a critical scenario is missed

applicable scenarios grows drastically.

and remains untested.

The disclosed invention:
• Presents a method to prioritize testing on a given system by rank ordering the objects that have the most complex interdependencies

• Provides a technique to identify and quantify essential database structural and interrelated elements in a given database schema.

The database dependency structure is traversed to generate a prioritized list of critical elements. These elements are then used to validate database tooling and database applications. The method of determining the essential list is the core of the invention,

1


Page 02 of 6

and can be used to generate any kind o...