On mapping natural language constructs into relational algebra through E-R representation

0
137

Authors: Arbee L. P. Chen, Frank S.C. Tseng, Wei-Pang Yang

Tags: 1992, conceptual modeling

Research on accessing databases in natural language usually employs an intermediate form for the mapping process from natural language to database languages. However, much effort is needed to bridge the gap between the existing intermediate forms and the database languages. In this paper, we present a methodology to map natural language constructs into relational algebra through E-R representation. This methodology employs a logical form to represent the natural language queries. The logical form has the merits that it can be mapped from natural language constructs by referring to the Entity-Relationship conceptual schema and can be efficiently transformed into relational algebra for query execution. The whole process provides a clear and natural framework for processing natural language queries to retrieve data from database systems,

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X00924/1-s2.0-0169023X92900198/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCIBFUPTKVwH9YKmFPMJYhCuzTU5Cr5ORTC5%2Fm6mqsM6T6AiEAoWnmKKkuxV2V0UOMDkW81kNHP8AWYOOcOmuSLxK02fIqvQMI9P%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARADGgwwNTkwMDM1NDY4NjUiDJQJf4WyhLJ%2FoB4aayqRA9adZibto7Z0bflM6NJCOp9zI3%2F%2FWmGDSA3qWzk3SKENMQWn66wGZAAezD1b2xxl%2BKr3zELYXBcsmUd%2Fvsgmh7CFfhmb8FZC%2FTiXBj4qQOq%2FZrGi8cTiZ%2BeeE%2BHHXVZAgfdBoK9%2BfauVh16fSuxyFjzh2HR%2F7rn0CCu34x%2BkFhbo3vP44qlKujlajUmKAmYrSWfWGJAAmb4%2BT8DfdL0A40UJmZaXQ896JD8mO0q4meD8egPWe3x58ktzoyqY8%2BBMKP3qSYN2q5GYH9zVR0vD%2BuiSvadKKdmFEt01G2urJtkzn1ykCRAazy2nuCT5ueXBBYR%2FKXNooL6LMtVlYlVRlbSXd86SZEqxKiIIreNPNzxSVd0MTj4MkLfpWkjA6BoYQwNMkB7suRKOn0BdybgFpRboZ0t2DExKZZTfYs12%2BTiUzECp9ASCvzPUDGEMIDxC57qBi6%2BI8KkMsY4jGqev%2BaNik2nGJbN4Nk1aSSp%2FA4%2BEtOMd2%2B2KCF4zsubdRlXNZ581Vb2%2FzoaGQnA25gGlRheYMJnu8vsFOusBhM0VmXS8hjBT1CjUrnD5WoIRiEyr9tYoZ4A0gyebFOnVc%2ByTahLrOrzgehS1k0eXd1zVFhmBKcrwCrOzt94uPrZ5MPzrdxCXQbzJumpeRQ9rAvbdgzmLxac%2B5%2FK3ksBtDMEhPgArMUYuL2NCgLle5GONi4HFD%2FOnm74OaobJvixBpovgDyzD%2F44ANJ21mFI%2B1bpSZ9gH01BUNiNS7t21tZxW1XqIpWQ3PY5S5zksojFDjXPcCjRYAUOW3lYJJ0b4LJRGZ%2BjFz1wKOpXG9nZ9Dmbqh1cs%2FCO%2FsMhOtHHMv2ASFXQ8JCKSV4Op5A%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20201006T192244Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYU4CGQZ7M%2F20201006%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=52d62f908d445c5323a349b30762bdbeb9fc8bbc867e9e1a92a4fcfa010490cb&hash=45adf7a1e7d71e4e24c58929e309b9cd27f77b75162c25c658179baadc3658f9&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X92900198&tid=spdf-44dfe90c-577b-4591-bd76-e4ec9a39611f&sid=486d779f37b05542706a4e676167ccab2c3agxrqa&type=client