Make Complex Database Structure Easy for Building SQL Queries

Online, December 21, 2012 (Newswire.com) - Needed database objects are always at hand

This new version of Active Query Builder makes working with metadata simpler and more understandable. Now the programmer can group database objects by different namespaces, including both the traditional ones (databases and schemas) and those specific to different database servers (packages and linked servers). It is now possible to group objects in a tree using arbitrary markers, which means it can reflect the logical structure of the database rather than its physical structure. That is, objects can now be organized in the tree however you like: by subject area, or by moving commonly used objects into a separate group.

The key to understanding SQL queries is all about how database structure is perceived

Reflecting metadata in a tree according to a logical, rather than a physical, structure completes the developers´ work in the first version of Active Query Builder on helping users understand databases when working with queries.

"Earlier we added full replacement of real object and field names with "alternative" names that are understandable and readable for the user," says Sergey Smagin, product manager of Active Database Software. "When working with queries, in both visual build mode and query text editing mode, the user has the ability to use such alternative object names in place of real names; it can significantly improve in the understanding of queries and database structures as a whole. The component substitutes the alternative names with the real ones unobtrusively, so the user barely notices."

What is Active Query Builder?

Active Query Builder provides the programmer with a full set of tools for working on SQL queries of any level of difficulty: parsing, visual building, program modification, and formatting. It also has an SQL text editor with code completion and syntax highlight. Working with Active Query Builder, the user has the ability to combine visual query building with text editing. The component supports SQL syntax for all widely distributed database servers and takes the specific traits of each one into account.

Pricing and Availability

Active Query Builder is available for different programming environments: .NET WinForms, ASP.NET, Java, Delphi and ActiveX. A license for one developer on WinForms, ASP.NET or Java, including subscriptions to free upgrades and unlimited technical support, costs $450 (USD). The license allows you to distribute commercial applications created with the component at no additional cost. Active Query Builder can be delivered with the full source code.

For more details and a free trial version, visit our product page: http://www.activequerybuilder.com

Contact
Sergey Smagin
[email protected]