NoSQL
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.
Omnidex and Raw Data Files
Using Omnidex on raw data files has many advantages:
- Access the rest of your data – Most businesses miss out on the data that is stored outside their relational database. They simply don’t have a way to search it. Omnidex turns raw data files into instant databases.
- No need for data imports – Omnidex directly searches raw data files, flat files and delimited files without having to import them into a relational database. Ease the load on your servers and search the raw data files directly.
- Deploy your data while it is fresh – Pushing raw data files through a relational database means you have to wait to deploy it. Index it directly and make it available while it is still fresh.
- Better Performance – Omnidex usually performs better on raw data files than on relational databases. In general, Omnidex scans raw data files about three times faster than relational tables, given their simple structure and lower overhead.
- 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 to wherever you want.
- Save license fees – Save some money. 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 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.