PLATFORMS: INTEGRITY-based applications can be built and deployed on systems utilizing MVS and UNIX. INTEGRITY can process data from any source and to any target.

PRODUCT FUNCTIONALITY: Vality's INTEGRITY Data Re-engineering Environment re-engineers data, subsequently transforming it into high-quality input for new information systems such as data warehouses, customer information files and marketing databases. By turning highly fragmented data into an accurate, consolidated composite of customers, products, suppliers or other entities, businesses gain critical insight into their operations, thereby improving department results, operational programs and marketing efforts. INTEGRITY is customized to each company's business and data is reusable for other data projects through simple "tweaking" of parameter-driven modules. It consolidates data without the benefit of common identifiers through a powerful statistical matching engine and joins records that have only a "fuzzy" similarity by analyzing each and every available attribute within a matched set of records.

PROBLEM SOLVED: INTEGRITY re- engineered and matched provider data contained within Regence's claims system allowing them to construct consolidated provider profiles and accurately analyze episodes of care and associated trends and costs of service delivery.

STRENGTHS: INTEGRITY is a very powerful and versatile tool, and we used it in both an analysis and a corrective function. It has the reporting and the search grouping functionality to report on the actual condition of data and gave Regence the opportunity to discover patterns and undocumented business practices. There was a great deal of difference between what people thought should be in the data and what was actually in it. INTEGRITY also gave Regence the ability to go through several iterations of data "cleansing" and allowed us to fine-tune the data within specific parameters. From a corrective standpoint, once Regence set the rules, INTEGRITY provided us with an audit trail showing what we've changed. Our profiling effort is done on a periodic basis, and we "cleansed" input data as part of this process. This data then serves as the basis for profiles we establish and helps us to identify "best practices" among our providers and compare the results with those of our peers. Vality helped us by conducting training classes and worked with us on defining the business issue we planned to solve with the product. This ensured that Regence understood the technical and business issues and helped us accept the responsibility for the contents and condition of our data.

WEAKNESSES: A perceived weakness that was encountered was the run time of the cleansing job stream. Compared to internally developed programs, the INTEGRITY job stream did run longer. However, given the relative level of results, the INTEGRITY process was much more efficient and reduced overall elapsed time significantly.

PRODUCT CHARACTERISTICS: INTEGRITY is a multipurpose data tool that can be used on a number of projects from data audits to data conversions to acquisition-related activities.

DELIVERABLES: INTEGRITY produces clean, addressable, properly consolidated information ready for loading into target databases. INTEGRITY can output a flat file in any format desired by the user. There is no limit to the number of data sources or extracts that can be brought together by the tool for the purpose of finding redundancies or performing other data tasks.

VENDOR SUPPORT: Vality provides on-site training, maintenance and data re- engineering consulting services as well as telephone support. Vality's support and commitment to our project success was excellent.

DOCUMENTATION: Full hard copy documentation is available.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access