|
Home > Our Products > Digital Gridworks™ Studio > Documentation > Advanced Data Search
|
| |
Advanced Data SearchThe Advanced Data Search tool is a powerful tool that allows you to search through tables in a database in a very generic and flexible manner. It has two main operating methods: client-side and server-side. While both of these methods will provide good results when used appropriately, theyare very different in nature and performance. Server-side SearchesServer-side searches use the database to do the heavy lifting when searching through the tables. You can search for fields that equal a certain value or are LIKE a certain value. The same rules apply for matching with the LIKE options as do with the LIKE SQL operator. The tool will search the tables and columns that you have specified in the upper section of the form. The performance of these searches is usually very good since the database engine does most of the work.Client-side SearchesWhen dealing with multiple database systems that provide different searching operators and functions,sometimes it is easier and much more accurate to do complex searches on the client side using regularexpressions. Client-side searches are just that. They retrieve the data from the database, using the criteria that you specify in the upper part of the form, and then the data is matched against the provided matching text. You can search for equality, starts with, ends with, and complete regular expressions.The performance does suffer using this type of searching, at the ability to perform very exact and complex searches. You can maximize the performance by using this tool on a machine that is connected to the samenetwork as the target database. This method of searching is most useful when there is no other way to search for complex matches using the functions that the database engine provides. Java Regex PatternsWhen doing client-side searches, you can use Java Regular Expressions to match data. This tool follows the same specifications as the Java Regex specification that you can find at:http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Pattern.html Understanding and Saving ResultsOnce the search is started, a results window will appear and the results will be placed, one per row, in the table. As the tool starts searching each new table, a blue table header row will be inserted with the table column names.As matches are found, the row will be inserted and the field(s) that matched will contain a red background.You can export a search to HTML by selecting the Export To HTML checkbox on the search window before starting the search. When you start the search, you will be prompted to choose a filename to save the HTML file. The results windowwill then divert the results to the file, but will continue to show any log messages that may arise. |
|
|
|
