Omnidex and raw data files are a well-tested and mature implementation of a NoSQL database. The NoSQL movement is a loose term describing databases that search data outside of the traditional relational database. NoSQL databases are designed to improve performance by not adhering to the ACID requirements for databases governing Atomicity, Consistency, Isolation and Durability. Raw data files are a classic implementation of this principle. Omnidex can index raw data files of enormous size and allow high-performance searches without the limitations of a relational database.
Using Omnidex on raw data files has many advantages:
Omnidex can index and search raw data files using SQL statements, available through standard interfaces like ODBC and JDBC. Applications usually do not know that they are even accessing raw data files, except for an increase in performance. For many applications, the possible advantages of a relational database are overwhelmed by the benefits of raw data files.
Where faster analytics or search performance is required for an existing relational database, Omnidex can take a snapshot of your SQL database which can then be fully indexed with Omnidex. This will provide fast, flexible searches and analytics with no impact on your production database.
For even more flexibility the ‘snapshot’ and indexes can be copies to multiple users and/or locations without additional database license costs.
Multi-national businesses use this capability to distribute high-performance analytics around their organisation.