{'fraction_non_alphanumeric': 0.021491782553729456, 'fraction_numerical': 0.0, 'mean_word_length': 5.2362204724409445, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Data Extraction from Structured Databases using Keyword-based Queries

Relational databases are used to store a large quantity of data scattered around the world. However, users face difficulties in accessing such data for lack of a more natural way of specifying queries. Techniques that use natural language words to search different information sources on the Web are now very common, but they cannot be employed to search relational databases. This work proposes a method that allows user to submit keyword-based queries, which are then semantically analysed and enriched before being mapped for the database language. By analysing keyword-based queries, the method considers different factors, e.g. the proximity between keywords, query segmentation, and the use of aggregate functions.