Click here to Skip to main content
       

Press Releases

Welcome to the new Press Releases forum! Our old press release system has been retired but we've moved everything and everyone to a new, shinier home. Enjoy!

A press release must be written for the purpose of announcing something newsworthy. Advertisements, promotions, or anything smelling even vaguely of spam will be deleted. All press releases must be relevant to the development community.

 
NewsMake Complex Database Structure Easy for Building SQL Queries PinmemberSoftPressRelease20-Dec-12 19:35 
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.
 
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/
 
About Active Database Software
 
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 http://www.activedbsoft.com/
 
Contact
Sergey Smagin
ssmagin@activedbsoft.com
SoftPressRelease

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 17 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid