Overview
NQL SQL-BUILDER is a platform independent database interface that can be easily integrated into any database-driven business systems, enabling any user to conduct real-time ad-hoc data retrieval, modification, reporting, and sharing without any programming. NQL SQL-Builder increases the value of your existing system while easing the heavy workload on your IT department.
Unparallel Querying and Searching Capabilities
NQL SQL-Builder offers unparallel database searching and querying capabilities through its proprietary technology:
Natural Language Query (NQL)
With NQL, any user, and not just programmers, can retrieve data from the database through its simple and English-like language. Through the dictionary interface, users can fully customize the language to suit their and/or industry preference. NQL SQL-Builder accurately interprets the user's phrase and returns the requested information easily and efficiently [read white paper].
Click Query
With just a few clicks of the mouse, users can submit any type of query, whether simple or complex. Unlike TOAD™ and other database tools, NQL SQL-Builder does not limit users to filter on specific search tables.
Example with existing Customer Relationship Management (CRM) System
Suppose we want to search all the employees who have the title "sales managers". With NQL SQL-Builder, we simply choose the "Click Query" option and click on the "employee" table and add a filter on the "'job title" table, all done with a few simple click of the mouse. Intelligently, NQL links all the necessary tables to successfully return our results.
Technical brief
At the database level, the employee information is held in the "employee" table and the job title is held in "job title" table since each employee can have multiple titles, therefore a join between the two tables is necessary to give us our complete result. Too complex to understand? We think so too - let NQL SQL-Builder do all the grunt work so that you can focus on getting the information you want easily and efficiently.
Keyword Query
NQL SQL-Builder comes with a powerful keyword searching capability. Like Google™ is for the web, NQL is for the databases. Unlike other database tools, NQL SQL-Builder does not restrict keywords to be located in specific tables. NQL SQL-Builder offers intelligent, fast, and real-time keyword searching capabilities that dynamically searches across all tables.
Example with existing Customer Relationship Management (CRM) System
Suppose we want to search all the sales managers located in our USA office. With NQL SQL-Builder, we simply choose the "Keyword Search" and type in "sales manager USA" and let NQL intelligently link all the necessary tables and successfully return records with the closest match - similar to Google™ search.
Technical brief
At the database level, the employee name is held in the "employee" table, job title is held in "job title" table, and location is held in the "location" table. To successfully return the request information, sales manager who are located in USA, we must join (link) all three tables together. Too complex to understand? We think so too - let NQL SQL-Builder do all the grunt work so that you can focus on getting the information you want easily and efficiently.
Pre-Defined Query
NQL SQL-Builder allows administrators to create pre-defined query with dynamic parameters. For example, a query could be made to show all sales in a specific region, where region is a parameter passed in by the user.
Saved Query
NQL SQL-Builder maximizes productivity by allowing users to save and share their existing query requests. Access existing queries is done by simply clicking and running the saved query.
Export and Reports
NQL SQL-Builder exporting feature enable users to easily and quickly export their query results into Microsoft Excel or HTML format, and generate professional looking reports within minutes.
Secure and Real-Time Record Insertion and Modification
NQL SQL-Builder offers secure and real-time record insertion and modification. Should the underlying database schema change, NQL SQL-Builder automatically detects and handles all the GUI changes, eliminating the need for additional development work.
Administration Features
NQL SQL-Builder offers and array of administrative features, which include:
- Granular Security feature provides a powerful and easy-to-use security interface that enables Database Administrators to restrict user access from the table level straight down to the field level. Administrators can define read, write, and edit permissions. Group security can also be defined to allow quick and easy security access.
- Configure Table Name and Fields feature enables renaming of table and field names, providing a more meaningful data representation for end-users.
- Search Configuration feature allows the Database Administrators to configure what is searchable and non-searchable data.
- Preferred Link feature offer users to define the relationship of tables in database platforms that do not support primary and foreign key linkage.
Other Features
NQL SQL-Builder is loaded with additional features, which include:
- Simple and user-friendly interface with a Microsoft look and feel.
- NQL SQL-Builder can be used as a stand alone product, straight out of the box, or can be quickly and easily integrate into existing systems.
- NQL SQL-Builder automatically picks up any changes to the database. No expensive and complicated maintenance is required when the underlying database schema is changed.
- Fully documented Application Program Interface (API) for power users and programmers.
|
