Using Omnidex: Transaction Logs and Raw Data Files

Businesses own a lot of data which is outside of the relational database. Businesses have transaction logs showing the daily activity. Business obtain data from other vendors in raw data files, or “flat files”. Omnidex is frequently used to deliver standard SQL access to these files without having to use a relational database.

• Access the rest of your data - Most businesses miss out on the data that isn't stored in their relational database. They simply don't have a way to search it. Omnidex indexes and searches raw data files, turning them into instant databases.

• No need to import data - Omnidex searches raw data files, flat files and delimited files without having to import the data into a relational database or a proprietary format. Ease the load on your servers and get the answers today.

• Lighten the strain on your relational database - Businesses overload their relational databases by importing raw data files simply because they want to search using SQL. Omnidex provides a SQL engine that directly accesses your raw data files.

• Built-in portability - A “database” consisting of raw data files and Omnidex indexes can be easily copied to other servers. Simply copy a directory of files!

• Save license fees - The license fees for relational databases are not required on servers that simply host raw data files and Omnidex indexes.

Omnidex can index and search raw data files as though they were a database, providing a SQL engine that is available through standard interfaces like ODBC and JDBC. For many raw data files, there is no advantage to the complexities of a relational databases.