SQLfX® Overview SQLfX® (SQL for XML) is the first and only transparent total integration of native XML by ANSI SQL. It requires no use of XML centric syntax or functions, XML training, or knowledge of the hierarchical structures being processed in order to use. Its navigationless operation along with its dynamic hierarchical processing and optimization allows data value enhancing multi-path queries to be easily specified even by non technical users. About the Demo The demo has a sample database to test with and over 100 stored queries covering all of SQLfX® ‘s powerful hierarchical processing features and capabilities that can be accessed and executed in real-time. These standard SQL queries can be modified by the user or the user may enter their own ANSI SQL queries. SQL queries are composed using standard SELECT, FROM, WHERE, and LEFT Outer Join operations (for combining hierarchical views).
This Demo is actually operating as a powerful ANSI SQL Enterprise 2.0 interactive immediate response relational/XML hierarchical query product with hierarchical filtering and search capability. SQLfX® Demo Instructions The SQLfX® Demo is invoked easily through your browser. It is a Java Applet so Java must be installed and Java must be enabled in your browser. Any version of Java should work. Once the SQLfX® demo is invoked, the demo window is displayed. Connected should appear on the upper left of the window. If there is an initial connection failure, try restarting or changing your browser. If the problem persists, please contact us at: firstname.lastname@example.org. Click on the Query button top left on window buttons across the top of the window to enter the first or next SQL query. Load a pre stored query or enter your own query. To load a pre stored query shown in the SQLfX® User Guide click the Open button top left in window. Another window will open with a list of SQL statement numbers and their description used in the SQLfX® User Guide to identify each of the example SQL hierarchical queries. They are ordered chronologically, select the desired query number by clicking on it to highlight it and then click the Open button at the bottom of this active window. This will move the selected query into the SQLfX® demo window. The displayed stored query can be modified if you desire. To execute the displayed query, click the Exec bottom at the top right of the window. [At this point, the SQL query is hierarchically executed correctly in real time and the dynamically formatted XML result will be displayed hierarchically indented to emphasize its structure which is dynamically determined. Only the SELECTed data fields will be returned and automatically collected concisely eliminating node levels with no data selected. The WHERE clause operation performs hierarchical data filtering keeping the results meaningful. This is true next generation database XML hierarchical processing known as Focused Retrieval and Result Aggregation which is still being researched academically.] Repeat the above Query process for the next query. But note that the Query button will automatically display the previous query statement for easy repetitive modification. This query can be cleared with the New button upper left, manually blanked out, or just loaded over by a stored query. Optionally: The New button clears the current query displayed in query mode. The Result button will display the previous XML result, and the Help button can be used to display SQLfX®'s syntax and instruction set for the demo. The Cut, Copy and Past buttons at upper center can be used to help edit your query composing.
Click Demo to start the demo. You can position or shuffle between the Demo and SQLfX Guide windows if you bring up an SQLfX guide. To transfer SQL examples into the Demo window for processing see Demo instructions above. Any problems or comments, please contact us at: email@example.com