Chelyabinsk, Russia (19 November 2012) - Active Database Software, a development company that provides programming support for professional database work, announced the release of a new version of Active Query Builder, a component for building SQL queries, which significantly improves the view and performance of metadata when building queries.
This new version of Active Query Builder makes working with metadata simpler and more understandable. Now the user 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 the programmer likes: by subject area, or by moving commonly used objects into a separate group.
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."
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.
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 web site: www.activequerybuilder.com.
Founded in 2005, Active Database Software is a privately owned software development company based in Chelyabinsk, Russia. Their areas of specialization include DB-aware components development, database management software development and software consulting. For more information, please visit www.activedbsoft.com.
Comments by Disqus:
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.