This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
intro:overview:where:flatfiles [2010/08/01 03:43] els created |
intro:overview:where:flatfiles [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ~~NOTOC~~ | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
====== Introduction ====== | ====== Introduction ====== | ||
- | [[intro:overview:where|Back to Introduction]] | + | [[intro:overview:what|What is Omnidex?]] | **[[intro:overview:where|Where is Omnidex Used?]]** | [[intro:overview:how|How is Omnidex Implemented?]] | [[intro:overview:demos|Watch Omnidex in Action]] |
- | ===== Using Omnidex: Transaction Logs and Raw Data Files ===== | + | ---- |
+ | ===== Where is Omnidex used? ===== | ||
+ | |||
+ | Omnidex is used in a wide variety of applications. Essentially, Omnidex is used when you need high performance and increased flexibility. Some of the more common Omnidex applications include: | ||
+ | |||
+ | * [[intro:overview:where:lists|Database marketing and customer lists]] | ||
+ | * [[intro:overview:where:analytics|Business analytics and data warehouses]] | ||
+ | * [[intro:overview:where:onlinedb|Online, searchable databases]] | ||
+ | * [[intro:overview:where|Transaction logs and raw data files]] | ||
+ | == == | ||
+ | Businesses own a lot of data that resides outside of the relational database. Transaction logs contain valuable answers about the day's activity. Branch offices or vendors send raw data files, or "flat files", that deserve immediate attention. Currently, businesses overload their relational databases by importing these raw data files simply because they want to use SQL. Give your relational database a rest. Your raw data files are good enough as they are. Omnidex can provide standard SQL access to these files without having to involve a relational database. | ||
+ | |||
+ | This approach has become so common that it has a name: the NoSQL movement. Companies with lots of data want high-performance alternatives to standard relational databases. Omnidex provides the best of both worlds: fast queries against raw data files using both standard and extended SQL. | ||
- | Businesses own a lot of data which resides outside of the relational database. Transaction logs contain valuable answers about the day's activity. Branch offices or vendors send raw data files, or "flat files", that deserve immediate attention. Currently, businesses overload their relational databases by importing these raw data files simply because they want to use SQL. Give your relational database a rest. Your raw data files are good enough as they are. Omnidex can provide standard SQL access to these files without having to involve a relational database. | ||
* **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 indexes and then searches raw data files, turning them into instant databases. | * **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 indexes and then searches raw data files, turning them into instant databases. | ||
Line 19: | Line 31: | ||
* **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. | * **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 a standard SQL engine, available through standard interfaces like ODBC and JDBC. For many raw data files, there is no advantage to the complexities of a relational databases and there are plenty of advantages to making it available quickly. | ||
- | Omnidex can index and search raw data files, creating a database with a standard SQL engine, available through standard interfaces like ODBC and JDBC. For many raw data files, there is no advantage to the complexities of a relational databases and there are plenty of advantages to making it available quickly. | + | [[intro:overview:where| [close] ]] |
+ | ==== ===== | ||
+ | * [[intro:overview:where:largedb|Billion-record databases]] | ||
+ | * [[intro:overview:where:text|Knowledgebases and text databases]] | ||
+ | |||
+ | ===== ===== | ||
+ | **[[intro:overview:how|Next]]** | ||
- | **[[intro:overview:where|Prev]]** | ||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||
+ |