This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
overview:flatfiles [2009/11/26 04:59] els |
overview:flatfiles [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | |||
| ====== Using Omnidex: Transaction Logs and Raw Data Files ====== | ====== Using Omnidex: Transaction Logs and Raw Data Files ====== | ||
| - | Businesses own a lot of data which resides outside of the relational database. Transaction logs contain valuable answers about the day's activity. Branches 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. | + | 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 12: | Line 11: | ||
| * **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. | * **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. | ||
| - | * **Built-in portability** - A database consisting of raw data files and Omnidex indexes can be easily copied to other servers. It is simply a directory of files that can be moved wherever you want. | + | * **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** - 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. |