On mapping natural language constructs into relational algebra through E-R representation☆
References (25)
English sentence structure and E-R diagrams
Inform. Sci.
(1983)TEAM: An experiment in the design of transportable natural-language interfaces
Artificial Intelligence
(1987)Using slots and modifiers in logic grammars for natural language
Artificial Intelligence
(1982)- et al.
Definite clause grammars for language analysis — A survey of the formalism and a comparison with augmented transition networks
Artificial Intelligence
(1980) - et al.
An intermediate database language and its rule-based transformation to different database languages
Data & Knowledge Engrg.
(1987) - et al.
Using semijoins to solve relational queries
J. Assoc. Comput. Mach.
(1981) - et al.
Relational database design using an object-oriented methodology
Comm. ACM
(1988) The Entity-Relationship model — Toward a unified view of data
ACM Trans. Database Syst.
(1976)Distributed query processing in a multiple database system
IEEE J. Selected Areas in Commun.
(1989)A localized approach to distributed query processing
Problems and some solutions in customization of natural language database front ends
ACM Trans. Office Inform. Syst.
A Guide to INGRES
Cited by (16)
NLQ into SQL translation using computational linguistics
2022, Journal of King Saud University - Computer and Information SciencesCitation Excerpt :In 1976, Chen (Chen, 1976) was the first to graphically model RDB schema entities using ERD to represent NLQ constructs. In (Tseng et al., 1992), ERD was used to represent NLQ constructs by analyzing the NLQ constructs’ inter-relationship with the ERD or even with the Class Diagram Conceptual Schema (Queralt and Teniente, 2006). However, NLQ constructs intra-relationships were not studied in previous works in terms of mapping constructs into an RDB query language (i.e., SQL) which will be implemented in the current research work.
Detection of naming convention violations in process models for different languages
2013, Decision Support SystemsCitation Excerpt :In some cases the extraction of the conceptual models is only an intermediate step: Tseng and Chen propose a methodology for mapping natural language constructs into SQL statements via the inference of UML class diagrams [82]. Similarly, Tseng et al. map natural language constructs into relational algebra via the extraction of entity–relationship models [81]. The important advantage that all these works have in common is that they apply standard NLP tools such as taggers, parsers, or speech recognition to infer the required information from written or verbal sources.
Enriching the class diagram concepts to capture natural language semantics for database access
2008, Data and Knowledge EngineeringExtending the UML concepts to transform natural language queries with fuzzy semantics into SQL
2006, Information and Software TechnologyThe impact of linguistics on conceptual models: Consistency and understandability
1997, Data and Knowledge EngineeringIntelligent user interface to SQL-based database system
1993, Engineering Applications of Artificial Intelligence
- ☆
This research was partially supported by the Republic of China National Science Council under Contract No. NSC 81-0408-E-007-12.
- ∗∗
Frank S.C. Tseng was born on June 30, 1964 in ChangHua, Taiwan, Republic of China. He received the B. S. and M. S. degrees both in Computer Engineering from National Chiao Tung University, Taiwan, in 1986 and 1988, respectively.
He is currently working towards the Ph.D degree in the Department of Computer Science and Information Engineering, National Chiao Tung University. His current research interests include integration and interoperability of federated databases, uncertain data manipulation, artificial intelligence, computer algorithms, and graph theory. Mr. Tseng is a member of IEEE Computer Society.
- †
Arbee L.P. Chen received the B. S. degree in Computer Science from National Chiao Tung University, Taiwan, Republic of China, in 1977, and the Ph. D. degree, in Computer Engineering from the Universtiy of Southern California, Los Angeles, in 1984.
He joined National Tsing Hua University, Taiwan, in August 1990, and is now a Professor in the Department of Computer Science. He was a Member of Technical Staff at Bell Communications Research, New Jersey, from 1987 to 1990, an Adjunct Associate Professor in the Department of Electrical Engineering and Computer Science, Polytechnic University, Brooklyn, New York, and a Research Scientist at Unisys, Santa Monica, California, from 1985 to 1986. He is currently also an Advisor to Industrial Technology Research Institute in Taiwan. His research interests include distributed databases, heterogeneous databases, active databases, spatial databases, and distributed computing systems.
Dr. Chen is a member of the Association for Computing Machinery and the IEEE Computer Society, and was a member of the ANSI/X3/SPARC/Database Systems Study Group.