IBM Data Discovery and Query Builder software can simplify time-intensive, costly, and complex ad hoc database query creation

IBM United States Software Announcement 206-302
November 28, 2006

 

 ENUS206-302.PDF (36KB)

Table of contents   Document options  
TOC link At a glance TOC link Publications
TOC link Overview TOC link Technical information
TOC link Key prerequisites TOC link Software Services
TOC link Planned availability dates TOC link Ordering information
TOC link Description TOC link Terms and conditions
TOC link Offering Information TOC link Prices
 
Printable version Printable version

 
At a glance

Data Discovery and Query Builder V2.1 offers improved query generation, usability enhancements, support for Oracle databases, and these benefits:

  • Lets you build your own complex ad hoc queries
  • Quickly extracts knowledge from data warehouses or federated databases
  • Can be customized to meet your security and auditing requirements
  • Controls data access and presentation based on user and current user role
  • Includes a simple GUI to construct complex queries using nested Boolean logic, various comparison operators, and ranges
  • Allows collaboration via support for publicly saved queries and results, as well as the ability to restrict access via specific control lists
  • Easily builds queries that look at data retrospective to an event
  • Leverages investments in existing database infrastructure
  • Uses proven technologies such as IBM DB2®, Oracle, IBM WebSphere Application Server, and XML and Web Services technologies

 
Back topBack to top
 
Overview

Create complex ad hoc queries in your own terms with Data Discovery and Query Builder software V2.1. This easy-to-use software makes use of an innovative new data abstraction technology, and builds on WebSphere® and DB2 Universal Database® technologies. Data Discovery and Query Builder V2.1 features improved query generation support, usability enhancements, and support for Web Services and Oracle.

With this new version, you can track and manage change to the data abstraction model (DAM) and update saved objects such as queries and results.

Data Discovery and Query Builder offers a framework, run-time, and application development environment for the creation of Web browser-based query construction and management applications. Using the resulting browser-based applications, you can easily create complex ad hoc queries using business and research terms instead of obscure table and column names.

The query construction interface includes these powerful features that help free users from the complexities of Structured Query Language (SQL):

  • Easy navigation of data elements
  • Prompts for possible values
  • Easy incorporation of Boolean logic with nesting
  • Specification of various comparison operators
  • Implicit joining of tables
  • Sub Query support

The interface requires neither programming knowledge nor an understanding of relational concepts such as joins. The ability to construct complex queries without complex languages or user interfaces means that you can spend time understanding the data and refining queries without the assistance of a database administrator.

In addition, Data Discovery and Query Builder exposes APIs to enable programs to benefit from the easy query construction and management functions in Discovery and Query Builder.

For details about all the new features and enhancements, refer to the Description section.
 
Back topBack to top
 

Key prerequisites

For information on prerequisites, refer to the Hardware requirements and Software requirements sections.
 
Back topBack to top
 

Planned availability dates
  • December 1, 2006 (electronic software delivery)
  • December 15, 2006 (media and documentation)

 
Back topBack to top
 
Description

Data Discovery and Query Builder V2.1 is a development framework that allows easy creation of Web-based end-user dynamic query applications. Core components of Data Discovery and Query Builder applications are:

  • Data Query Builder: Web presence for the end user
  • Instance of a DAM: Virtualized data warehouse that users access
  • Data Discovery and Query Builder Studio: Graphical environment that the administrator uses to create the DAM and deploy the Data Query Builder

Data Query Builder

Data Query Builder is a run-time component of Data Discovery and Query Builder. It consists of a Web-based interface that allows creation of end-user dynamic queries using the terminology, categorization, hierarchies, and logical fields defined in a DAM. You can dynamically create complex searches without prior knowledge of physical data store tables, obscure column names, non-intuitive coded data values, filtering, or join logic.

In addition to simplifying construction of complex queries, Data Query Builder manages query and result set data that can either be shared among users or kept private. Query results can be returned in HTML, XML, comma separated values (CSV), XLS (Microsoft™ Excel), or tab delimited formats. Query results can be sorted and ordered.

You can extend Data Query Builder further extended with plug-ins for security, auditing, and end-user usability. Data Query Builder V2.1 supports native Oracle and streamlines the process of query building.

DAM

DAM is an XML-based document that maps physical to logical data representation. For example, a DAM may map an end user's concept of "age" to the calculation involving the current date and a column in a table containing a birth date. Users see and work with "age," while Data Discovery and Query Builder queries with the calculation for age.

Key entries of the DAM are fields and categories. Fields are logical data entities that are available in searches on underlying physical data models. Categories are groups of related fields or other related categories. You can nest categories to any depth. Data Query Builder run-time component uses information from the DAM to determine what terminology and format to use when presenting a user with fields for query construction. The information from the DAM is also used to convert abstract representation of a user's query request into SQL during execution of queries.

Data Discovery and Query Builder V2.1 continues to improve the DAM to support user-controlled multiple table occurrences and specification of multiple event occurrences for a single table.

The new and enhanced Data Discovery and Query Builder Studio tools enable the administrator to build the DAM specifically for the client environment.

Data Discovery and Query Builder Studio

Data Discovery and Query Builder Studio is an integrated development environment for creating, customizing, running, and debugging Data Discovery and Query Builder applications. Studio is a set of plug-ins that can be installed into an existing installation, including:

  • IBM Rational® Web Developer for WebSphere Software V6.0
  • Rational Application Developer for WebSphere Software V6.0
  • Rational Software Modeler V6.0
  • Rational Software Architect V6.0
  • Eclipse

These platforms offer a wide array of development-related tools. The Rational products contain tools that are not available in the base Eclipse platform that Data Discovery and Query Builder application developers may find useful. Support for running and debugging Data Discovery and Query Builder applications is available only in those Rational products listed.

With Data Discovery and Query Builder Studio V2.1, you can track and manage changes to the DAM. In addition, you can update saved objects such as queries and results.

Data Discovery and Query Builder V2.1 Enhancements

Data Discovery and Query Builder V2.1 offers enhancements to query generation capability and usability as well as support for Web Services and Oracle databases. Enhancements and new features include:

  • Native Oracle support: Data Discovery and Query Builder can now run directly against an Oracle data warehouse.
  • Sub Query Support: Allows query conditions to be created using existing saved queries or results enabling better reuse of previous work and more complex requests to be created.
  • Enhanced data abstraction model search feature including searching hierarchical field values (e.g., ICD-9, DRG), searching against field selection values (male and female for a Gender field), and other metadata elements of the model.
  • Faster query building support via quick output only selection, improved metadata display within DAM, and the ability to build event profile conditions directly from the DAM tree.
  • Direct support for integration with query patroller, enabling administrators to retain control of the warehouse system resources including holding, cancelling, or delaying a user query until a less busy time based on query complexity or user class.
  • Enhancements to the support for working with saved objects including access control lists (fine grain control over who can use each saved object), name tagging (arbitrary groupings of saved objects based on their use), tabbed display allowing different types of saved objects to be viewed in isolation of each other, and a key word lookup for quickly finding specific objects.
  • Dynamic table function allowing custom components to build tables "just in time" for query execution. For example, allowing query conditions against WebSphere Information Integrator OmniFind™ Edition to be directly integrated into the query building process. Dynamic tables can come from anywhere ranging from simple properties files to Web Services.
  • Incident support: Enables queries to search for two or more unique occurrences of a particular condition or value.
  • Full featured integrated auditor: in addition to existing customizable audit support, a new a predefined auditor captures extensive information about the use of the Data Discovery and Query Builder system, right out of the box without additional customization.
  • Support for recovery of deleted queries and results, so that users can recover from accidental deletions.
  • Improved Administrator support for copying, renaming and deleting user queries.
  • Maintenance support for saved Data Discovery and Query Builder objects: Studio component that can monitor the effect of changes to abstraction models on existing saved objects and simplify the process of modifying those objects to be compatible with the changes.
  • Studio View Estimator: Administrators can validate the effect of their abstract data views, which encompasses their data security model.
  • New Studio component for graphically building plug-in definitions, enabling Data Discovery and Query Builder application customization to a specific environment.

Section 508 of the U.S. Rehabilitation Act

Data Discovery and Query Builder is capable, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. You can request a U.S. Section 508 Voluntary Product Accessibility Template (VPAT), containing details on accessibility compliance at

IPLA and subscription and support considerations

IPLA licenses can be transferred from one machine to another within, but not limited to an enterprise. You may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single proof of entitlement (PoE). It is your responsibility to manage the distribution of Value Units within the limits of the entitlement of the product license.

Subscription and Support must cover the same capacity as the product license entitlement. Subscription and Support will be available in the country in which the agreement is made.

Trademarks

 
OmniFind is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2 Universal Database, WebSphere, DB2, and Rational are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Offering Information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back topBack to top
 
Publications

No publications are shipped with this product.

Publications are also available from the eServer® Info Center at

On that Web page (the eServer Info Center home page) expand "IBM Systems Software Information Center," then "Healthcare and Life Sciences" to find "IBM Data Discovery and Query Builder" with links to all the publications.

The IBM Publications Notification System (PNS)

PNS enables subscribers to set up profiles of interest by order number or product number. PNS subscribers automatically receive e-mail notifications of all new publications defined in their profiles. These may then be ordered or downloaded from the Publications Center.

The PNS site is available in English and Canadian French.
 
Back topBack to top
 

Technical information

Hardware requirements

Three different environments for Data Discovery and Query Builder and their hardware requirements:

  • For the application developer environment: Intel® Pentium® server running at 1.5 GHz with Windows™ or Linux™ operating system
  • For the production server environment:

    One of the following:

    • IBM eServer pSeries® server with AIX® operating system
    • IBM eServer iSeries™ server with i5/OS™ operating system
    • Intel Pentium server running at 1.5 GHz or more with Windows or Red Hat Linux operating system
  • Recommended specifications for the chosen server:
    • For the application developer server: 200 MB free disk space for DDQB installation files and sample database
    • For the production server: 2 GB free disk space for the prerequisite products of a full installation (including DB2®, HTTP server, and WebSphere® Application Server)
  • For the client environment (that access the Web application): System that will adequately run the chosen browser — Internet Explorer or Firefox

Refer to the Software requirements section for required level of operating systems for the servers and browser levels for the client.

For more information, visit

Software requirements

Data Discovery and Query Builder requires the following software:

For the application developer environment (Data Discovery and Query Builder Studio): WebSphere Application Server V6.0.2.9, or later

For the production server environment:

  • One of the following operating systems:
    • IBM AIX 5L™, V5.1, or later, with the current maintenance package
    • Red Hat Enterprise Linux V2.4.21, or later
    • Microsoft™
      • Windows 2000 Server with SP4
      • Windows 2000 Advanced Server with SP4
      • Windows 2000 Professional with SP4 (supported for application design, development, and testing only; not supported for production use)
      • Windows Server 2003 or 2003 SP1. Datacenter
      • Windows Server 2003 or 2003 SP1, Enterprise
      • Windows Server 2003 or 2003 SP1, Standard
      • Windows XP Professional with SP2 (supported for application design, development, and testing only; not supported for production use)
    • OS/400®: i5/OS V5R3, or later
  • When installing on Windows, Red Hat Linux, and AIX: IBM DB2 Universal Database®, V8.1, or later, or Oracle Database 10g

For the client environment, one of the following Web browsers:

  • Internet Explorer V6.0
  • Firefox V1.0.4, or later

Planning information

For installation information, refer to the IBM Data Discovery and Query Builder Installation and Configuration Guide provided with the program.

For more information, visit

Customer responsibilities: Software Maintenance is included with licenses purchased through Passport Advantage and Passport Advantage Express. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances your productivity, with voice and electronic access into IBM support organizations.

Packaging: The Data Discovery and Query Builder package includes a CD with the product code, and the License Information document.

Security, auditability, and control

Data Discovery and Query Builder uses the security and auditability features of both the DB2 database and the WebSphere Application Server. Data Discovery and Query Builder further provides extensive features for plugging in customized security, auditability, and control within the context of its abstraction layer. As an example, DB2 can be used to grant or revoke authority to a table containing test values, while Data Discovery and Query Builder can be used to grant or revoke authority to a logical specific test field containing hemoglobin test values.

Security and auditability features of the Data Discovery and Query Builder are:

  • Plug-in support allowing customized security based on the action taken (login, query execution), the user doing it, and the objects used (database values, analysis routines, and so on).
  • Default implementations of the security component for common cases that can be augmented and extended to specific environments.
  • Controllable data access to the row or column level.
  • Customizable audit logs that can be queried, in turn, through Data Discovery and Query Builder.
  • Data Discovery and Query Builder V2.1 includes a full featured integrated auditor provided in addition to the existing customizable audit support. This predefined auditor captures extensive information about the use of the Data Discovery and Query Builder system right out of the box without additional customization.

The security functions of Data Discovery and Query Builder can either replace or augment the security, auditability, and control features of DB2 and WebSphere.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
 
Back topBack to top
 

Software Services

IBM Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of the IBM lab-based, software services team and the business consulting, project management, and infrastructure expertise of the IBM Global Services team. Also, IBM extends its IBM Software Services reach through IBM Business Partners to provide an unmatched portfolio of capabilities. Together, they provide the global reach, intellectual capital, industry insight, and technology leadership to support any critical business need.

To learn more about Software Services or to contact a software services sales specialist, visit

To locate an IBM Business Partner, visit


 
Back topBack to top
 
Ordering information

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Product information

                                                    Product
Licensed function title             Product group   category
 
IBM Data Discovery and Query        IBM Other       Data Discovery
 Builder for Multiplatform                           and Query
 Concurrent User                                     Buildr Mltp
 
 
                                      PID        Charge unit
Program name                          number     description
 
IBM Data Discovery and Query Builder  5724-M26   Concurrent
 for Multiplatform Concurrent User                User(s)

Charge metrics definitions:

Concurrent user: A concurrent user is one and only one individual within or outside your enterprise. The number of Proof of Entitlements (PoEs) required is for the highest number of users simultaneously accessing the program or any program components either directly or indirectly (via a multiplexing program, device, or application server) through any means on behalf of the user.

Passport Advantage program licenses

Data Discovery and Query Builder

                                                         Part
Part description                                         number
 
IBM Data Discovery and Query
 Builder for Multiplatform
 Concurrent User
DDQB for Multiplatforms                                  D558NLL
 Concurrent User(s) License &
 SW Maintenance 12 Mon
DDQB for Multiplatforms                                  E01V5LL
 Concurrent User(s) SW
 Maintenance Annual Renewal
DDQB for Multiplatforms                                  D558PLL
 Concurrent User(s) SW
 Maintenance Reinstatement 12

Passport Advantage supply

                                                         Part
Program name/description                                 number
 
DDQB for Multiplatforms V2.1.0
DDQB for Multiplatforms AIX V3.x, Windows 2000,          BH030EN
 AIX V4.x, Red Hat Linux V2.1.

Passport Advantage customer: Media pack entitlement details

Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.

Data Discovery and Query Builder for Multiplatforms V2.1.0

Entitled maintenance                                  Part
offerings description     Media packs description     number
 
Data Discovery and Query  DDQB for Multiplatforms     BH030EN
 Builder Multiplatfrms     AIX V3.x,Windows 2000,AIX
 Concurrnt Usr             V4.x,Red Hat Linux V2.1.

 
Back topBack to top
 
Terms and conditions

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement and the IBM Agreement for Acquisition of Software Maintenance.

Agreement: IBM International Program License Agreement including the License Information (LI) document and PoE govern your use of the program. PoEs are required for all authorized use.

Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

This software license includes Software Maintenance, previously referred to as Software Subscription and Technical Support.

LI form number

                                   Program    Form
Program name                       number     number
 
Data Discovery and Query Builder   5724-M26   CT43JML

The program's LI will be available for review on the IBM Software License Agreement Web site

Limited warranty: Yes

Warranty: IBM warrants that when the program is used in the specified operating environment it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. Consult the IBM Software Support Guide for further information at

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Money-back guarantee: If for any reason you are dissatisfied with the program and you are the original licensee, return it within 30 days from the invoice date to the party (either IBM or its reseller) from whom you acquired it for a refund.

For programs acquired under the IBM International Passport Advantage Agreement, this term applies only to your first acquisition of the program.

Copy and use on home/portable computer: No

Passport Advantage applies: Yes, and through the Passport Advantage Web site at

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Agreement for acquisition of Software Maintenance: The following agreement applies for maintenance and does not require Customer signatures: IBM Agreement for Acquisition of Software Maintenance (Z125-6011).

Software Maintenance is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and Technical Support are provided by the Software Maintenance offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software and Technical Support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Maintenance with each program license acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option, if available.

While your Software Maintenance is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance via telephone and, if available, electronic access, to your IS technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, 7 days a week. For additional details, visit

Software Maintenance does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under the applicable agreements.

For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, visit the Passport Advantage Web site at

Volume orders (IVO): No

iSeries Software Maintenance applies: No

Educational allowance available: Not applicable
 
Back topBack to top
 

Prices

The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Passport Advantage: For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at

Business Partner information

If you are an IBM Business Partner — Distributor for Workstation Software acquiring products from IBM, you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBM ID and password are required. Copy the Web address below into the address field of your browser.

Trademarks

 
i5/OS, iSeries, and AIX 5L are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, eServer, AIX, pSeries, DB2, WebSphere, OS/400, DB2 Universal Database, and PartnerWorld are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel and Pentium are registered trademarks of Intel Corporation.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version