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

IBM United States Software Announcement 205-330
December 13, 2005

 

 ENUS205-330.PDF (45KB)

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 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
 
Printable version Printable version

 
At a glance

Data Discovery and Query Builder offers 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
  • Enables different people to see different data or the same data differently
  • Provides a simple GUI to construct complex queries using nested Boolean logic, various comparison operators, and ranges
  • Allows you to save and classify queries as private or public for reuse
  • Easily builds queries that look at data retrospective to an event
  • Leverages investments in existing database infrastructure
  • Based on proven technologies — DB2 Universal Database (UDB), WebSphere Application Server, and XML

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. This easy-to-use software makes use of an innovative new data abstraction technology, and builds on WebSphere® and DB2 Universal Database® (UDB) technologies.

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 terms instead of obscure table and column names.

The query construction interface includes these powerful features:

  • 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

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.
 
Back topBack to top
 

Key prerequisites

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

Planned availability dates
  • December 14, 2005, electronic software delivery
  • December 16, 2005, media and documentation

 
Back topBack to top
 
Description

Data Discovery and Query Builder 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

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 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.

DAM

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.

For additional information about the Data Abstraction Model, refer to the IBM Data Discovery and Query Builder Data Abstraction Model  Reference Guide (DQADataModel.PDF) 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

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 IBM Rational® Web Developer for WebSphere Software 6.0, Rational Application Developer for WebSphere Software 6.0, Rational Software Modeler 6.0, Rational Software Architect 6.0, or Eclipse installation. These platforms offer a wide array of development-related tools for Data Discovery and Query Builder application developers.

Trademarks

 
WebSphere, DB2 Universal Database, 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

Publications in PDF form are included with this product.

Publications are also available from the eServer® Info Center at

The IBM Publications Notification System (PNS)

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

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

Technical information

Hardware requirements

Data Discovery and Query Builder requires following hardware:

220 MB free disk space for the base application server, 2 GB free disk space for a full installation (including DB2®, HTTP server, and WebSphere® Application Server)

One of the following:

  • IBM eServer pSeries® server
  • IBM eServer iSeries™ server

For more information, visit

  • Intel™ Pentium™ server running at 1.5 GHz, or more, with the following specifications:
    • 2 GB memory recommended
    • 180 MB free disk space for the base application server, 2 GB free disk space for a full installation (including DB2, HTTP server, and WebSphere Application Server)

Software requirements

Data Discovery and Query Builder requires the following software:

  • One of the following:
    • AIX 5L™, V5.1 with the 5100-05 recommended maintenance package, AIX 5L, V5.2 with the 5200-02 or 5200-03 recommended maintenance package, or AIX 5L V5.3 with the 5300-01 recommended maintenance package
    • Red Hat Enterprise Linux™ ES/AS V3.0 for Intel Update 2, 3 or 4, or Red Hat Enterprise Linux ES/AS V4.0
    • Microsoft™ Windows™ 2000 Server with SP4, Microsoft Windows 2000 Advanced Server with SP4, Microsoft Windows 2000 Professional with SP4 (supported for application design, development, and testing only); Microsoft Windows Server 2003 or 2003 SP1 Datacenter; Windows Server 2003 or 2003 SP1, Enterprise; or Windows Server 2003 or 2003 SP1, Standard; Microsoft Windows XP Professional with SP1a or SP2 (supported for application design, development, and testing only; no support for production use)
  • WebSphere Application Server 6.0, or later
  • When installing on Windows, Red Hat Linux, and AIX®, DB2 UDB Enterprise Server Edition, V8.2
  • When installing on OS/400®:
    • OS/400 V5.2, or later
    • QShell Interpreter, 5722SS1 option 30
  • One of the following Web browsers:
    • Internet Explorer V6.0, or later
    • Firefox V1.0.4, or later
  • Data Discovery and Query Builder Studio requires one of the following:
    • Application Server Toolkit V6.0 (included in WebSphere Application Server 6.0)
    • Web Developer for WebSphere Software V6.0
    • Application Developer for WebSphere Software V6.0
    • Software Modeler V6.0
    • Software Architect V6.0

Planning information

Installation information is found in the IBM Data Discovery and Query Builder Installation and Configuration Guide provided with the product.

Customer responsibilities: Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity, with voice and electronic access into IBM support organizations.

Packaging: The contents of the Data Discovery and Query Builder package is 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 which be augmented and extended to specific environments
  • Controllable data access to the row or column level
  • Customizable audit logs which can be queried, in turn, through Data Discovery and Query Builder

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
 

Ordering information

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

Product information

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

Charge metrics definitions

Concurrent user: A concurrent user (user) is one individual machine, program, access or device within or outside your enterprise. A Proof of Entitlement (PoE) is evidence of your authorization to use a program and is required for each user accessing the program or any program component, either directly or indirectly, (an example of "indirect" access would be through a multiplexing program or an application server), through any means on behalf of the user. You must acquire PoEs to support the "high water mark" of concurrent users — the highest number of users accessing the program at any given point of time.

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
 
DDQB for Multiplatforms V2.0.0
 
Media Pack English US Windows                     BH02LNA
 Server 2003, OS/400 V4.x, AIX 5L,
 V5, Red Hat Linux CD ROM Digital
 Disk -- ISO 9660 Standard V2.0.0

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.

DDQB for Multiplatforms V2.0.0

Entitled maintenance   Media packs                  Part
offerings description  description                  number
 
Data Discovery and     DDQB for Multiplatforms      BH02LNA
 Query Builder          English U.S. Windows
 Multiplatfrms          Windows Server 2003,
 Concurrnt Usr          OS/400 V4.x, AIX 5L, V5,
                        Red Hat Linux CD ROM
                        Digital Disk — ISO
                        9660 Standard

 
Back topBack to top
 
Terms and conditions

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

Licensing: IBM International Program License Agreement. PoE 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           Form
Program name            number            number
 
Data Discovery and      5724-M26          CT3R1ML
 Query Builder

On or near the planned availability date, the LI will be available for review on the IBM Software License Agreement Web site

Limited warranty applies: Yes

Warranty: This program includes a warranty for one year from acquisition from IBM or an authorized IBM Business Partner. For one year from acquisition of the program, this warranty provides the customer with access to databases containing program information and FAQs, including any known fixes to defects, which the customer can download or otherwise obtain and install.

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 offering, this term applies only to your first acquisition of the program.

Copy and use on home/portable computer: No

Volume orders (IVO): No

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

Software maintenance applies: Yes

Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the IBM International Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service provides voice and electronic access to IBM support organizations.

IBM includes one year of Software Maintenance with the initial license acquisition of each program 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, only 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, every day of the year. 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 this agreement.

For more information about the Passport Advantage Agreement, visit the Passport Advantage Web site at

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. 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


 
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 Americas Call Centers
            Dept. Teleweb Customer Support, 9th floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 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

 
iSeries and AIX 5L are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, eServer, the e-business logo, DB2, WebSphere, pSeries, AIX, DB2 Universal Database, and OS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel and Pentium are trademarks of Intel Corporation.
 
Microsoft and Windows 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