Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
admin:features:attach:home [2012/02/29 18:54]
doc
admin:features:attach:home [2012/02/29 18:58]
doc
Line 5: Line 5:
 ====== Administration:​ Omnidex Features ====== ====== Administration:​ Omnidex Features ======
  
-===== Attaching ​Tables ​=====+===== Attaching ​Data =====
  
 **[[admin:​features:​attach:​home|Overview]]** | **[[admin:​features:​attach:​home|Overview]]** |
Line 20: Line 20:
 There are many uses for attaching tables and database. ​ Omnidex queries can reference any of the tables in the connected environment,​ as well as those tables and databases that have been attached to the environment. ​ This greatly expands the scope of queries that are possible. ​ Attached databases can also have Omnidex indexing, allowing the query to be optimized using Omnidex indexes from all databases.  ​ There are many uses for attaching tables and database. ​ Omnidex queries can reference any of the tables in the connected environment,​ as well as those tables and databases that have been attached to the environment. ​ This greatly expands the scope of queries that are possible. ​ Attached databases can also have Omnidex indexing, allowing the query to be optimized using Omnidex indexes from all databases.  ​
  
-Some applications ​also receive data from their users which is to be applied as search criteria. ​ With Omnidex, this search criteria can be applied using two methods. ​ If the data is simple, such as a file of customer numbers or zipcodes, then these can be easily referenced using [[admin:​features:​segments:​home|Omnidex Segments]]. ​ If the data is more complex and contains multiple columns or multiple tables, then these can be referenced as attached tables or databases.+Some applications receive data from their users which is to be applied as search criteria. ​ With Omnidex, this search criteria can be applied using two methods. ​ If the data is simple, such as a file of customer numbers or zipcodes, then these can be easily referenced using [[admin:​features:​segments:​home|Omnidex Segments]]. ​ If the data is more complex and contains multiple columns or multiple tables, then these can be referenced as attached tables or databases.
  
-Some applications retain the result sets of searches performed against their databases. ​ These results sets can be as simple as a file of customer numbers, or they can be more complex with multiple columns. ​ If the result set is simple, it can most easily ​be stored ​in a permanent Omnidex Segment; however, if the result set is complex, applications ​may wish to export the result set as a small, indexed Omnidex database. ​ This database can be attached in later queries to provide services like order suppression or statistical analysis.+Some applications retain the result sets of searches performed against their databases. ​ These results sets can be as simple as a file of customer numbers, or they can be more complex with multiple columns. ​ If the result set is simple, it can be stored ​as a permanent Omnidex Segment; however, if the result set is complex, applications ​can export it to a small, indexed Omnidex database. ​ This database can be attached in later queries to provide services like order suppression or statistical analysis.
  
 ====  ==== ====  ====
 
Back to top
admin/features/attach/home.txt ยท Last modified: 2016/06/28 22:38 (external edit)