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

IBM United States Software Announcement 207-278
November 6, 2007

 

 ENUS207278.PDF (42KB)

 

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

 
At a glance

Data Discovery and Query Builder V2.2 offers new advanced query capabilities including support for CLOBs and time stamps, additional API support, and full internationalization including double-byte database support and translation to Italian, German, Spanish, Dutch, Brazilian Portuguese, Chinese, Japanese, and Korean. Data Discovery and Query Builder V2.2 offers these benefits:

  • Lets you build your own complex ad hoc queries
  • Quickly extracts knowledge from data warehouses or federated databases
  • Allows customization 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 DB2®, Oracle, WebSphere Application Server, and XML and Web Services technologies

For ordering, contact:

Your IBM representative or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
 
Back topBack to top
 

Overview

Create complex ad hoc queries in your own terms with Data Discovery and Query Builder software V2.2 software that makes use of an innovative new data abstraction technology, and builds on WebSphere® and DB2 Universal Database® technologies. Earlier updates to Data Discovery and Query Builder featured improved query generation support, usability enhancements, and support for Web services and Oracle.

This new Data Discovery and Query Builder V2.2 delivers:

  • New advanced query capabilities, including support for CLOBs and time stamps
  • Additional API support for creating advanced queries
  • Full internationalization support, including translation of Web interface and User's Guide and double-byte database support

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
  • Subquery 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, the API support for Data Discovery and Query Builder now offers essentially the full functionality of the Data Discovery Query Builder Web application. These APIs enable application programmers 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
  • November 7, 2007 (electronic software delivery)
  • November 14, 2007 (media and documentation)

 
Back topBack to top
 
Description

Data Discovery and Query Builder V2.2 is an application development framework that allows creation of Web-based end-user dynamic query applications. Core components of an application created with Data Discovery and Query Builder are:

  • Data Query Builder
  • Instance of a Data Abstract Model
  • Data Discovery and Query Builder Studio

New features and enhancements for Data Discovery and Query Builder V2.2 are listed in detail below.

Data Query Builder

Data Query Builder is a run-time component of Data Discovery and Query Builder. It consists of a Web-based interface, allowing creation of end-user dynamic queries using the terminology, categorization, hierarchies, and logical fields defined in a Data Abstraction Model (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. Data Query Builder can be further extended with plug-ins for security, auditing, and end-user usability. Data Query Builder V2.2 streamlines the process of query building, as well as supporting native Oracle databases.

DAM

The DAM is an XML-based document that maps how end users logically think of the data-to-physical-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.

Key entries of the DAM are fields and categories. Fields represent logical data entities available in searches against underlying physical data model, and categories group related fields or other related categories. Categories can be nested to an arbitrary 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.2 continues to improve the DAM to support additional capabilities, such as user controlled multiple table occurrences and specification of multiple event occurrences for a single table.

For additional information DAM, refer to the document entitled "IBM Data Discovery and Query Tutorial: Creating a DDQB Application" on the CD that is shipped with the software. This information is also available from the Data Discovery and Query Builder Information Center at

Data Discovery and Query Builder Studio development environment

Data Discovery and Query Builder Studio is an integrated development environment for creating, customizing, running, and debugging Data Discovery and Query Builder applications. The development environment provides the needed tools to create and edit your Data Discovery and Query Builder applications. Studio is a set of plug-ins that can be installed into an existing development environment, including:

  • WebSphere Application Server Toolkit ("AST") V6.1
  • IBM Rational® Application Developer for WebSphere Software V7.0
  • IBM Rational Software Modeler V7.0
  • IBM Rational Software Architect V7.0

These platforms offer a wide array of development-related tools. The IBM Rational products contain additional tools beyond what is available in the AST 6.1 development environment provided for free by WebSphere. These additional IBM Rational tools are helpful in debugging Data Discovery and Query Builder applications.

Data Discovery and Query Builder Studio V2.2 allows tracking and managing of changes to the DAM. Another new feature of Studio in V2.2 is the ability to update saved objects such as queries and results.

Data Discovery and Query Builder V2.2 enhancements

Data Discovery and Query Builder V2.2 offers new advanced query capabilities, additional API support as well as product translation. The following are just some of these enhancements and new features for V2.2:

  • New advanced query capabilities — including support for:
    • Querying CLOB fields
    • Querying time stamp fields
    • Setting default values for parameter queries
    • Wizard for modifying parameter queries
    • Multiple occurrence support for text field conditions
    • Multiple-field conditions
  • Additional API support, providing essentially the full functionality of the Data Discovery and Query Builder Web application. This includes API support for creating queries with the following advanced settings:
    • Limit result rows
    • Random output
    • Duplicate rows on/off (distinct)
    • entity mode
  • New API support for creating queries that include the following support:
    • Constraint conditions (always/never)
    • Advanced text search utilizing DB2 Net Search Extender, including fuzzy and stemmed searches
    • Subquery conditions
    • Incident conditions
    • Parameter conditions
    • Aggregate queries
    • Classification on output fields
  • New API support for saving queries and results, with ability to assign:
    • Restricted access lists (RALs)
    • Tags
  • Additional advanced query capabilities include:
    • Support for querying time stamp field
    • Setting default values for parameter queries
    • Wizard for modifying parameter queries
    • Support for querying CLOB fields
    • Multiple occurrence support for text field conditions
    • Multiple-field conditions support
  • Full global support, including:
    • Full locale support
    • Support for double-byte character set (DBCS) databases
    • Translation of Web interface to Italian, German, Spanish, Dutch, Brazilian Portuguese, Japanese, Korean, Simplified Chinese, and Traditional Chinese
    • Translation of User's Guide to Italian, German, Spanish, Dutch, Brazilian Portuguese, Japanese, and Korean

Accessibility by people with disabilities

A U.S. Section 508 Voluntary Product Accessibility Template (VPAT) can be requested via the IBM Web site

Section 508 of the U.S. Rehabilitation Act

Data Discovery and Query Builder is capable as of November 14, 2007, when used in accordance with associated IBM 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. A U.S. Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested 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.

Availability of national languages

Product description            Language        GA date
 
DDQB(1) for Multiplatforms     English         November 14, 2007
 V2.2.0
 
(1) Data Discovery Query Builder

Trademarks

 
WebSphere, DB2 Universal Database, DB2, and Rational are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a registered 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.

Hardcopy publications are not shipped with the product CD, but we do ship the following on-line publications with the product CD:

  • IBM Data Discovery and Query Builder User's Guide: An Introduction to the Data Discovery and Query Builder Web Application V2.2
  • IBM Data Discovery and Query Builder Installation and Configuration Guide V2.2
  • IBM Data Discovery and Query Builder Tutorial: Creating a DDQB Application V2.2
  • IBM Data Discovery and Query Builder API Guide V2.2

Additional documentation included in the installed product:

  • Javadoc for plug-ins
  • API Javadoc

Publications are also available from the eServer® Info Center at

The IBM Publications Center

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries.
 
Back topBack to top
 

Technical information

Hardware requirements

There are three different environments for Data Discovery and Query Builder and their hardware requirements are as follows:

  • For the application developer environment
    • Intel® Dual Core running at 2 GHz or higher with at least 2 GB of RAM with Windows® or Linux™ operating system
    • 200 MB free disk space for DDQB installation files and sample database
  • For the production server environment, one of the following:
    • IBM eServer pSeries® or IBM System p5™ server running at 1.5 GHz or higher and at least 4 GB of RAM with AIX® operating system
    • IBM eServer pSeries or IBM System i™ server with i5/OS™ operating system
    • Intel Dual Core server running at 2 GHz or higher and at least 4 GB of RAM with Windows or Red Hat Linux operating system

    On the chosen server: 6 GB free disk space for the pre-req products of a full installation (including DB2®, HTTP server, and WebSphere® Application Server)

  • For the client environment (that accesses 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

For the application developer environment (Data Discovery and Query Builder Studio), one of the following:

  • WebSphere Application Server Toolkit V6.1.1 (provided with WebSphere Application Server V6.1)
  • IBM Rational® Application Developer V7 with current fix pack (minimally V7.0.0.2) or equivalent IBM Rational development environment such as IBM Rational Software Architect V7 or IBM Rational Web Developer V7 with current fix pack

For the production server environment, one of the following operating systems:

  • AIX 5L™, V5.3 or higher with the current maintenance package
  • Red Hat Enterprise Linux V2.4.21 or later
  • i5/OS V5R3 or later
  • Microsoft®
    • Windows Server 2003 at current service pack level
    • Windows XP Professional with current service pack level (supported for application design, development, and testing only; not supported for production use)
  • When installing on Windows, Red Hat Linux, and AIX, the database must be DB2 Universal Database®, V9.1 or later, or Oracle Database 10g

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

  • Internet Explorer V6.0 or V7.0 with current fix pack
  • Firefox V1.5 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

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.

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

To learn more about IBM 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
 
Data Discovery and Query            BM Other       Data Discovery
 Builder for Multiplatform                           and Query
 Concurrent User                                     Builder for
                                                     Multiplatforms
 
 
 
                                       PID         Charge unit
Program name                           number      description
 
IBM Data Discovery and Query Builder   5724-M26    Concurrent
 for Multiplatform concurrent user                  user

Charge metrics definitions

Concurrent user

A concurrent user is one and only one individual within or outside your enterprise. The number of 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 description                                         Part number
 
IBM Data Discovery and Query
 Builder for Multiplatform
 Concurrent user
DDQB for Multiplatforms                                  D558NLL
 Concurrent user License & SW
 Maintenance 12 Mon
DDQB for Multiplatforms                                  E01V5LL
 Concurrent user SW
 Maintenance Annual Renewal
DDQB for Multiplatforms                                  D558PLL
 Concurrent user SW
 Maintenance Reinstatement 12

Passport Advantage supply

                                                         Part
Program name/description                                 number
 
DDQB for Multiplatforms V2.2.0
IBM Data Discover and Query Builder V2.2 for AIX V5.x,   BH03AML
 i5/OS V5.x, Red Hat Enterprise Linux, Windows Server
 2003, Windows XP Multilingual

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.

IBM Data Discovery and Query Builder V2.2

Entitled maintenance                                     Part
offerings description       Media packs description      number
 
Data Discovery and Query    IBM Data Discover and        BH03AML
 Builder Multiplatfrms       Query Builder V2.2 for AIX
 Concurrent user             V5.x, i5/OS V5.x, Red Hat
                             Enterprise Linux, Windows
                             Server 2003, Windows XP,
                             Korean, Chinese
                             Simplified, Spanish,
                             Portuguese Brazilian,
                             German, Japanese, Chinese
                             Traditional, English US,
                             Dutch MNCS, Italian Media
                             Pack

 
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.

Licensing: IBM International Program License Agreement including the License Information document and Proof of Entitlement (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.

License Information form number

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

The program's license information 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, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

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

Authorization for use on home/portable computer: The program may be stored on the primary machine and another machine, provided that the program is not in active use on both machines at the same time. You may not copy and use this program on another computer without paying additional license fees.

Product name
 
Data Discovery and Query Builder                 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 IBM Agreement for Acquisition of Software Maintenance (Z125-6011) applies for maintenance and does not require customer signatures.

Software maintenance applies: Yes. 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 information systems (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, consult your IBM Software Support Guide at

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

Other terms

Volume orders (IVO): No

System i Software Maintenance applies: No

Educational allowance available: Not applicable
 
Back topBack to top
 

Prices

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.


 
Back topBack to top
 
Order now

To order, contact the Americas Call Centers or your local IBM representative.

To identify your local IBM representative, call 800-IBM-4YOU (426-4968).

 Phone:      800-IBM-CALL (426-2255)
 Fax:        800-2IBM-FAX (242-6329)
 Internet:   callserv@ca.ibm.com
 Mail:       IBM Teleweb Customer Support
             ibm.com Sales Execution Center, Americas North
             3500 Steeles Ave. East, Tower 3/4
             Markham, Ontario
             Canada
             L3R 2Z1
 
 Reference:  YE001

The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

Note: Shipments will begin after the planned availability date.

Trademarks

 
System p5, i5/OS, System i, iSeries, and AIX 5L are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, eServer, pSeries, AIX, DB2, WebSphere, Rational, DB2 Universal Database, and PartnerWorld are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a registered trademark of Intel Corporation.
 
Windows and Microsoft are registered 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