scispace - formally typeset
Patent

Data extraction and testing method and system

Reads0
Chats0
TLDR
In this article, the authors present a testing framework that automates the querying, extraction and loading of test data into a test result database from plurality of data sources and application interfaces using source specific adaptors.
Abstract
The present method and apparatus provides for automated testing of data integration and business intelligence projects using Extract, Load and Validate (ELV) architecture. The method and computer program product provides a testing framework that automates the querying, extraction and loading of test data into a test result database from plurality of data sources and application interfaces using source specific adaptors. The test data available for extraction using the adaptors include metadata such as the database query generated by the OLAP Tools that are critical to validate the changes in business intelligence systems. A validation module helps define validation rules for verifying the test data loaded into the test result database. The validation module further provides a framework for comparing the test data with previously archived test data as well as benchmark test data.

read more

Citations
More filters
Patent

Integrated System and Method for Validating the Functionality and Performance of Software Applications

TL;DR: In this article, the authors present a multi-phase, end-to-end integrated process for testing application software using a standard software testing tool, which involves integrating the functional, automated regression and performance phases of software application testing by leveraging deliverables at each phase.
Patent

Post-migration validation of etl jobs and exception management

TL;DR: In this article, the authors propose exception handling for extract-transform-load (ETL) job mismatches as "exceptions" by determining a mismatch while running an ETL job with the mismatch being a mismatch of at least one of the following types: design time information mismatch, and/or operational metadata mismatch.
Patent

Validating code of an extract, transform and load (ETL) tool

TL;DR: In this paper, an approach for validating code for an extract, transform and load tool is provided, where the code is exported to a job definition file and parsed, and subsequently is determined to not include the violations of the standards.
Patent

Annotations-based generic load generator engine

TL;DR: In this paper, a generic transaction generator framework for testing a network-based production service may work in conjunction with a product-specific transaction creator module that executes transactions on the service.
Patent

Rule-based automated test data generation

TL;DR: In this article, a rule-based data population system including a rule dispatcher engine to automatically bind data generating rules to a database is described, and a data generator engine to generate testing data for the database based on the rules.
References
More filters
Patent

Full-service research bureau and test center method and apparatus

TL;DR: In this paper, a usability test for typical tasks faced by a visitor to the customer's site is presented, which measures not only the visitor's success in achieving objectives, but also prompts a tester for context-specific feedback ranging from aesthetics to behavior.
Patent

Validating multiple execution plans for database queries

TL;DR: In this paper, the authors propose an approach to validate large numbers of alternative execution plans for a database query, either an exhaustive enumeration of the complete space of alternatives, or an unbiased random sample, by efficiently constructing execution trees from a data structure having groups alternative operators that are ranked in a directory.
Patent

Method and system for testing data sources and database oriented software applications

TL;DR: In this article, the authors present a method and system for testing databases and database oriented applications through analyzing database contents and structure, which can also be used for database monitoring and database cleaning.
Patent

System and method for developing a rule-based named entity extraction

TL;DR: In this article, a system and method for developing a rule-based named entity extraction system is provided, which includes analyzing requirements of business users, and then designing the rule based NER system based on the requirement analysis.