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:
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!