|
|
|
|
External Index and Query (EIQ) Products™
are unique in that they externally INDEX and query ALL data and information -
structured database queries and unstructured text searches -
WITHOUT submitting queries to the data source, WITHOUT copying and
storing data elsewhere and WITHOUT changing data schemas |
EIQ
Products are NOT conventional federated adapters, NOT data warehouses, NOT enterprise search
only,
and NOT Extract, Transform and Load (ETL) tools
EIQ
Products are NOT conventional technology
Background
WhamTech and its predecessors developed unique high
performance index and query processing technologies over the last
25 years as part of their own relational database management
system (RDBMS), called Thunderbolt. As the RDBMS is so fast,
WhamTech used it to develop unstructured text search technologies as part
of its search engine products for the Web, enterprise and
specialized search, which by definition, operate on external
files, documents, including Web pages, and e-mail.
With EIQ Products, WhamTech brings the power of its
advanced index and structured query processing technology and
unstructured text search to other databases and data
sources. For the range of EIQ Product offered by WhamTech,
please visit WhamTech
Products.
EIQ Products Enable Radically Improved/Changed Processes (Not
Just Better Technology)
WhamTech’s EIQ Products
are not conventional, as they take a very different approach
to major problems facing almost all large organizations:
How to integrate, share and interoperate data and information in near real-time
without (a) creating a huge additional super-infrastructure, e.g.,
massive data warehousing, (b) overloading existing systems, e.g.,
conventional adapters in federated systems, and (c) losing the ability to execute
structured database queries, e.g., enterprise search.
EIQ Product technology
offers the advantages of the above three approaches without the
disadvantages associated with each of them.
EIQ Products not only enable data and information
integration, sharing and interoperability within and between organizations, but
can also “turbo charge”
existing data source access and add significant features such as:
 |
Complex
query processing |
 |
Heuristic data mining
|
 |
Pre-aggregated and
pre-calculated indexes for
direct queries |
 |
Monitoring key performance indicators (KPIs) and
performance |
 |
Querying across and between
databases, files, documents and e-mail |
 |
Link mapping and analysis (connecting seemingly unconnected data and information)
|
EIQ Products consist of a highly flexible middleware/sub-middleware product,
called EIQ Federated Server™,
that resides between applications/middleware and other EIQ
Products. EIQ Federated Server
can also access other EIQ Federated Servers to allow indefinite
performance, scalability, load balancing, redundancy and
failover. Business rules can be applied within EIQ
Products to enable the best combination of
data and information to be queried and passed back to
applications, providing true organization-wide data and
information sharing, integration and interoperability.
EIQ Products are accessed by
applications, including middleware, through standard ODBC, JDBC,
OLE-DB, Web Services and a native driver. Standard Query
Language (SQL) or WhamTech's native language, TQL, can be used
to submit queries.
Figure 1 below illustrates where EIQ
Products reside
in the application/data source architecture.

Figure1:
EIQ Products reside between applications and data sources
-
Universal and uniform INDEX
and query engine for structured queries and unstructured search
on ALL data sources
 |
Allows up to 100% of data
to be found in a query due to
 |
Cleansed data used for
indexes |
 |
Multiple indexes
available, including name variation, fuzzy, pre-aggregated
and pre-calculated, join and Link Indexes™ |
 |
Complete control over
query processing |
|
 |
Combination database
queries and text search |
Data sources on multiple
platforms and locations
Leave source data in place
in original format
 |
Only INDEXES mapped to
common metadata |
Continue to use legacy
applications and data
 |
Modern application access
to legacy data |
 |
Legacy application access
to modern databases |
 |
Use as
transition/migration tool to modern systems |
Scale through multi-tiered,
independently maintained indexes, and locally controlled access
 |
Also offer
XML and Web Services |
High performance
queries
 |
Typically, 10 to 100
times faster than other data-based systems |
Near real-time updates
immediately available to queries
Embedded Value Indexes™ allow data
and information to be stored in indexes
Create VIRTUAL data
warehouses/data marts for multi-dimensional queries
Link mapping
and analysis
externally manages obvious/direct links and reveals
non-obvious/indirect links among disparate data and information
across multiple disparate data sources
Significant benefits
compared to conventional adapters in federated systems, data warehouse or enterprise
search
 |
Combines best of these
approaches |
Papers
EIQ Product-related papers are available for
download in Adobe *.pdf format under
Documents. |
|
|
|
|