request
demo

Database Search Appliance

DBX

Perfect Search’s Database Search Appliance for databases (DBX) brings full search functionality to your database, including both structured and unstructured (full text) data, with blazing speed, low hassle, significant capacity to scale, and accelerating return on investment.

Perfect Search’s DBX employs fast indexing to quickly handle massive data sets, provides a configurable incremental indexing process to avoid significant latency lags, and provides blistering query speeds to access your database content. Content within databases, including full-text and unstructured data is now easily searchable .

Features

  • Search massive databases at blistering speeds (10x+)
  • Indexes and searches all of the data within the database
  • Allows for continuous, incremental indexing, avoiding the problem of fragmented indexes
  • Indexes at very high speeds
  • Searches all data within database
    • Unstructured (full text)
    • CLOB Text Fields
    • Structured
  • Offloads the computational search load from the database to the DBX
  • Search across various databases
    • Microsoft SQL Server
    • IBM DB2
    • Oracle
    • Oracle MySQL
    • Informix
  • Powerful federated search across Microsoft applications
    • Multiple Microsoft SQL Server databases
    • Microsoft Sharepoint Server
    • Microsoft Office files
    • Microsoft Exchange
  • Universal federated search across other enterprise applications
    • Documentum
    • HP Trim
    • LotusNotes
    • Many more!
  • Connectivity to Google Search Appliance to SQL databases

The Challenge

Companies need to find information within their databases quickly and with cost-efficient solutions. However, as databases grow exponentially in size and as SQL queries become more complex, current search solutions struggle to meet these needs. The challenges include the following:

- The ability to find data in any field within a database

Within any database, indexing carries a system cost, so to minimize that cost, DBAs will index only the most critical fields. If a search is done for data that is located within a field that is not indexed, the whole system suffers as the query does a full table scan for the information, leading to poor query recall rates.

- The ability to find data across multiple databases

If a user needs to find some data, but does not know in which database it is located, a query would need to be run in each database to attempt to located it.

- The ability to index new content at high rates of speed

New content added to a database requires frequent and costly indexing and optimizing to keep the searchable data current and of value to users.

- The ability to find data with CLOB fields or text fields

Documents stored within a CLOB field can become a significant burden to the system performance for indexing and querying the content. The overhead of indexing and searching text will need to be added to the system sizing to accommodate the extra load on the database. The database cost can grow dramatically in order to handle the Text functionality.

- The ability to find data within massive data sets

As the size of the database grows, system performance deteriorates for both indexing and query times. Solutions to maintain acceptable levels of performance become very costly and include things such as partitioning of data, significant expansion of hardware and extensive, labor-intensive optimization initiatives.

The Solution

The Perfect Search Database Search Appliance (DBX) allows you to search all the content in all the fields of your entire database. Data from all the fields of the database, including unstructured or full text content, is offloaded to the DBX to be indexed. Data from multiple databases can be offloaded as well, allowing the DBX to create a master index, giving the user a universal federated search across all indexed databases with one query. New incoming content is quickly indexed by the Perfect Search engine in incremental indexes, that can be merged into the master index at low cost and without the need to re-index the entire database. The DBX provides full search functionality, including such query expressions as wildcards, fuzzy search, stemming, proximity, and soundex without putting any query load on your production database and with no query slowdown. Not only will queries search structured data, but it will search unstructured or full text data, including data from BLOBs and CLOBs. And, because of the dramatic efficiency of the DBX engine, massive databases are handled with ease, providing sub-second query response times, blowing past previous search bottlenecks.

The Impact

Companies now have a cost-effective solution to index and search their databases. Firms that are struggling with ever-increasing database sizes now have a solution to cost-effectively search these content repositories. The DBX employs fast indexing to quickly handle massive data sets, provides a configurable incremental indexing process to avoid significant latency lags, and provides blistering query speeds to access your database content. Content within databases, including full-text and unstructured data is now easily searchable .

Copyright © 2009 - 2010 Perfect Search Corporation. All rights reserved.