Select model ===>;
'Oracle Request Examples' lets you choose Request Example Queries to create a Request and run it, instead of creating an "ad hoc" request by typing into the textbox (or speaking the request on a smartphone).
The upper "Entity Type dropdown" of Oracle Request Examples lets you choose an Schema Entity Type shown below in the "Schema Diagram". Note: to learn about the Schema Diagram, in this "User Help" menu, choose "using Schemas to create a Request".
Once you have selected the Entity Type you want to explore, the "lower dropdown" lets you select an Example query to run.
The SayQL app shows the Oracle XE sample database entities in the 'Schema Diagram' (see below).
Please note that when SayQL is set up for your own corporate databases, it will show your corporate users the Schema Diagram for each selected corporate database.
Clicking on the link entitled "Show SQL" shows the actual database query that generated the current or last user-request answer (in the lower "Grid Panel").
Note that the SQL commands consist of database tables names and column names (corresponding to the Oracle XE sample database schemas shown in the Schema Diagram.
However, in SayQL you type or say terms in English (Natural Language), and let SayQL's patented IP transcribe that request into SQL.
To illustrate this 'central feature' of SayQL, pull down and select an Example Request and run it, and then press the Show SQL link see the generated SQL command.
With regard to your own Oracle database, you can test out accessing it by speaking or typing Natural Language requests, just like you're doing with this Sample Oracle database.
To discuss a pilot project for using SayQL with one of your databases, please call us at Cognal Labs by phone: 214-810-4854, leave a message with your name, company name, phone number or email address and we'll get back with you promptly.
SayQL runs successfully on any relational database whose RDBMS supports SQL 1999 and above, including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySql, PostGreSQL
SayQL is based on a patent ("NATURAL LANGUAGE QUERY": #9652452). SayQL's patent covers six unique features that greatly help Oracle users get actionable information: .
1) transcribing a user's typed or spoken 'Natural Language' request into Structured Database Language,.
2) executing the automatically generated SQL command against a 'target' relational database, .
3) a feature called "Dimension Values", which allows a user to type or say the VALUES of a given Entity/Attribute: an example would be a user request "accounting employees" as stated in the user's Natural Language, transcribed into a SQL query where the clause for "accounting" is department_name = 'accounting'",.
4) a feature called "Virtual Entity / Virtual Attribute", which allows a user to define a "filter" and a "condition" for a given Entity or Attribute: an example would be a user request "show me the foreign employees" as stated in the user's Natural Language, transcribed into a SQL query where clause for "foreign" is COUNTRIES country_name <> 'US'",.
5) a feature called "Calculated Field", which allows a user to define an Attribute using a calculation or function (an example is "Customer fullname" in the user request, transcribed into the Select query as a 'CONCAT' function coupling "CUSTOMERS firstName,' ',lastName" , and.
6) a feature called "Teach the System", which allows a user to define an "unstructured" request phrase: one that might not have to mention Entities and Attributes (examples would be like "'highest producers" or "'highest-priced' products" -- phrases that you "teach the system" to understand.
In the case of Oracle, the SQL command can accomplish table joins across the target database Schemas. To see this important point in action, select and run an Example Request that includes entities across Schemas, and then click on Show SQL.
(Note: the Oracle XE sample database schemas are shown in the Schema Diagram).
To discuss the SayQL setup process, pricing, patent licensing, or other product information as it relates to installing and using SayQL on your own corporate databases, please call us at 214-810-4854 or email us at "email@example.com"
Please visit our website: "https://www.cognal-labs.com" to learn about our products, technology, and other corporate information.
select this option to show the actual SQL code of the present or last query you ran
OracleXE - SayQL