IBM Licensed Programs: Database Products 545
IBM Licensed Programs: Database Products
SQL dialects, protocols, operating systems, data types, error codes, and functional
differences are all transparent to the application. Similarly, client workstations attached to
DB2 DataJoiner only need one client interface to DataJoiner and all other supported data
sources are then available. This eliminates the need for each workstation to have client code
for each data source and is very efficient and cost effective.
One way DataJoiner provides data transparency is with compensation. DataJoiner can
provide functions not available at a data source, enriching the native SQL of the data source.
For example, a client can submit a query using DataJoiner to a data source. If that function is
not supported (such as Recursive SQL) at the data source, but is supported by DataJoiner,
the query can complete successfully. DataJoiner compensates by simulating the function,
thus preserving transparent access.
Version 2.1.1 includes a new DataJoiner SQL statement for creating tables in different types
of data sources. If the native SQL for creating tables in these data sources includes a unique
option, for example, the option in DB2 for OS/390 for specifying the database in which you
want a table to reside, it is possible to code this option in the new DataJoiner statement.
When a data source table is created with this new statement, it can also be altered or deleted
with DataJoiner SQL.
DataJoiner supports Geographic Information System (GIS) data (also known as spatial or
geographic data). New data types, spatially-enabled columns, and spatial join capability allow
the user to take advantage of geographic data in applications. Powerful two-dimensional
functions are included that allow the creation of specific relationships among the defined
geographic objects. The following components are included with the DB2 Spatial Extender:
• A set of spatial data types
• A set of spatial operations and predicates
• A set of spatial index data types
DB2 DataJoiner Version 2.1.1 and DB2 Spatial Extender allow the integration of “location or
geographic” information with traditional business data and enable the creation of a new breed
of business applications, Geographic-Business. Geographic-Business applications employ
queries based on proximity, distance, and driving times and provide the option to present the
resultsasmaps.
The DB2 DataJoiner base offering includes free of charge a 60-day trial license for the DB2
Spatial Extender. The DB2 Spatial Extender may be installed and used on a trail basis for 60
days from the date of first use of the feature. The DB2 Spatial Extender feature includes a
time disabling service, which prevents its use upon expiration of the 60-day trail period. To
permanently install and use this feature, purchase the DB2 Spatial Extender License Pack
(31L1137).
This DB2 Spatial Extender was jointly developed by IBM and Environmental Systems
Research Institute, Inc. (ESRI), a leading GIS company.
To Next Page
Loading...
Need help?
General