English to SQL via C-Phrase
C-Phrase Technologies Sweden AB
English to SQL via C-Phrase
C-Phrase Technologies Sweden AB
English to SQL via C-Phrase
C-Phrase Technologies Sweden AB
Let non-technical users quickly and easily access your SQL database
Benefits
C-Phrase promotes data democratization: Non-technical users can 'google' the database 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 for use in other tools. Administrators can easily set up example questions, extended lexicons and reports to empower even the most non-technical users.
C-Phrase raises data quality: 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. Companies might also wish to insert answers from ChatGPT into the given database. C-Phrase can give users the ability to input, update or delete data via natural language commands. This results in the rapid creation of SQL scripts that can be integrated into data deployment pipelines. C-Phrase's data modification capability can be enabled on a table by table basis and is naturally off by default.
C-Phrase reduces administration costs: Users would like to ask a series of unanticipated questions over various levels of granularity to tease out subtle trends in the data. Busy database administrators prefer to give users self-service capabilities rather than constantly being tasked to write special dashboards, data entry screens or custom SQL. C-Phrase provides exactly this capability.
Features
- Natural language to SQL select, insert, update and delete queries: C-Phrase can map natural language to OLTP and OLAP queries expressing regular conditions, set conditions, date and time conditions, superlatives, negations, universal and existential quantification, cardinality conditions, etc. C-Phrase also integrates well with transaction processing and database check-pointing via explicit SQL logging and the ability to start, abort or commit transactions.
- Flexible cloud-based administration: Log into the Admin Interface and connect to your remote SQL Server, PostgreSQL, MySQL, MariaDB, Aurora or Redshift 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, ellipsis, additional views and reports. Launch a natural language interface and invite your users to access it. Finally you can explore and manage XML-based logs of user sessions to pinpoint where to improve your interface.
- 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. This lets you embed natural language interfaces across many applications including those that use voice recognition. Finally C-Phrase can easily be secured with certificates to allow for HTTPS access.
Each new release of C-Phrase comes with additional example configurations and databases. Launching C-Phrase will give you immediate access to these examples which you are free to adapt to your own purposes. The number of users and natural language interfaces per virtual machine is limited only by the size of the virtual machine you launch. It is quite likely all your needs will be met with a single small virtual machine.