C-Phrase's update capability makes it particularly suited to tasks in data curation. Many companies must manually fix data in complex SQL databases to deliver high quality products and services. Often this is a painstaking process involving standardization of data values, removal of outliers and one-off corrections. C-Phrase gives users the ability to explore and correct data via natural language questions and commands. This results in the rapid creation of scripts of SQL statements that can integrate into data deployment pipelines.
On the search side, C-Phrase promotes data democratization. Users 'google' the databases using precise, often complex conditions. Results are specific values, lists, tables or charts. Users can export these results to CSV files in a single click to easily import results into other tools. The ability to define example questions, extend lexicons and provide reports lets administrators quickly set up interfaces that empower even the most non-technical users.
Whether being used for data curation or data democratization, C-Phrase reduces or eliminates the cost of building complex dashboards and data entry screens. Sure one could build many custom dashboards and search screens, but finding the right one is tedious and frustrating. With C-Phrase users can ask a series of unanticipated questions over various levels of granularity to tease out subtle trends in the data. Busy DBAs give users self-service rather than constantly being bothered to write special dashboards, data entry screens or custom SQL.
The ultimate benefit of C-Phrase is that it enables organizations to define and manage much more sophisticated data models. Traditional methods to implement conceptually complex databases require high levels of expertise and effort to build front ends. C-Phrase enables organizations to radically cut the costs associated with such efforts. The end result is more time to build accurate and nuanced models of what's important.
Natural language to SQL select, insert, update and delete queries
Given your question or command, C-Phrase computes all the possible meaningful mappings to SQL. In cases of ambiguity, you pick the SQL (paraphrased in English) that you intended. Likewise you confirm update and delete queries before execution. C-Phrase also integrates well with transaction processing and database check pointing via explicit SQL logging and ability to start, abort and commit transactions.
Flexible cloud-based administration
Log into the admin GUI and connect to your remote PostgreSQL, MariaDB or MySQL database and automatically build an initial natural language interface in under five minutes. You can also fully define and populate a stand-alone SQLite database within C-Phrase. Use editing tools to customize and refine an interface with synonyms, regular expressions, additional views and reports. Launch a natural language interface and invite your users to access it.
Open formats and APIs for interoperability
All configuration for C-Phrase natural language interfaces is represented in a single XML format in a completely documented and open format. In addition, live natural language interfaces can be accessed via REST calls. These properties let you embed natural language interfaces across many applications including those that use voice recognition.