Skip to content

Data Curation

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. 

Data Democratization

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 template questions, extended lexicons and 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 would prefer to give users self-service rather than constantly be 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 or commit transactions.

Flexible cloud-based administration

Log into the admin tool 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 file 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.