Select model ===>;
1) SayQL is a "Natural Language" app; If you use the app with a smartphone, you will likely use the device Speech Recognizer to convert Speech to Text in the Request textbox; When you look at the Schema Diagram, you will see that there is an underscore in many of the entity and attribute name; So SayQL's designers assigned synonyms using Natural Language terms; For instance, element names with underscores have one or more synonyms without the underscores; The actual Oracle Query must use the table/column names, many of which have the underscore; To see how the user's use of Natural Language is automatically converted to SQL, select and run any Request Example request in the textbox, and then click on the "Show SQL" link; This illustrates the "secret sauce" of SayQL's patent: automatically converting the user's English request into SQL.
2) Even though SayQL is a "Natural Language" app, there are rules for you to follow in your user request: use "nouns" that refer to the Entities and Attributes you want to see, and avoid words and phrases that humans use and understand, but that the app has not been "taught", such as "which employees made the most revenue?"; SayQL doesn't understand the word "made"; actually Cognal Labs does offer a BI product, called Cognal Studio, that allows its users to "teach the computer" non-nouns, but that is beyond the scope of SayQL for now.
3) The quickest way to learn how to formulate "ad hoc requests" is to select and run Request Examples: Only Request Examples that work are available to choose from; other requests that were run but resulted in some type of error code are not included for future examples.
4) Depending on your browser, sometimes a user request that includes several attribute names will appear to only show the first two columns; If this happens, click on the answer grid and it will expand to show all the attributes you asked to see; An example is "employee hiredate, salary"; The word "employee" brings up the default columns of FirstName and LastName; Since the request includes two more columns, they are included in the answer.
'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 email us at admin@cognal-Labs.com and leave a message with your name, company name, and phone number 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). The patent covers three unique features: 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, and 3) 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.
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).
The SayQLTechnology Diagram is located at https://cognal-labs.com/?page_id=29 .
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