Graphical query formulation for an entity-relationship model

Authors: Bogdan CZEJDO, David W. Embley, Douglas M. CAMPBELL

Tags: 1987, conceptual modeling

A query language is defined in which users graphically manipulate entity-relationship (ER) diagrams to formulate queries. The theoretical foundation for the graphical language is algebraic. Each algebraic operator maps an ER diagram to an ER diagram, and every ER diagram represents a possible user query. A set of operators is formally defined and a suggested interactive implementation is given. The set of algebraic operators is both entity-set conservative, which guarantees that a user can interpret any transformed diagram in terms of known entity sets, and relationally complete, which guarantees an acceptable level of retrieval power.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X01450/1-s2.0-0169023X87900176/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEE0aCXVzLWVhc3QtMSJIMEYCIQDfFAI3hCknUfpFrJivpiPmyG3R2DBEyD4RNtIMxaAkTgIhAPcE3iBpCTMXCPLubb%2FHwJkLiRgdPb1rxbglDEE79%2FxbKrQDCGUQAxoMMDU5MDAzNTQ2ODY1IgxFl4MB%2B63rGxKGZFcqkQO%2Fp6Q2J5HDqMLeqwJ2IC3PkqAl4Dd8yPE%2FNAtFK7RB87Rk6Rfpfoh20VTLl23OAgbUqeGTh%2BOAYAzoDZYO67dEDVsYsBXf5Iy%2B%2FQSXswTjW0rhxFwvSD%2BheAAmC3Qqj2mWtVGmqcBYsHG4%2BfustdSN0WplOKYBTr1WfUwCsOiXEE8C5hurjeO%2BT0gv36MllD5Ls3KwHzA%2F6S7W2w5Gqk9NvRgLd9gKNQeVe0H0H34nDIk%2F2KV4f2lGTqHynrnsE755zAbIvfxvW4I%2F%2B0kJ4zqkUKpIk3MkGnUqO0uM9VnVDJ5DwlmJhHvrrfZDqqmNg6TgeiMnTqupH3c1se3Vx87XRY1M9gvrvTa0OSFtVyH2ASr1zS3kcboZUv1ATnP7wGY2GBiXYSpxYNTxuGNXnfBlslE6aevUxA2fm1xFJ7pkVoBdn93QZFCmN9UxG82zs4n%2BDkTk%2FhKIUHxUBGByJ961bHOhvGwAd3DE2JmH71tBn%2F24BbQb9wKAMl2K07otyAPkiX0GsmHLU5wT1lIIkXUt%2FDCM8J77BTrqAbaptFJ6U4sOdqNOYopiQnALPxLW0RuYW8q%2FnwkRjt7bHOOVXgf2XYFAAL7qlxFEM3rHU3tkQHACP5UQUnla9e4jf%2BrUBTqnmFJQsNszHh4yphSM%2Fb56kp44qw1%2BjBnUajEexnhYVLBb0SXVRsVfb%2F5teEGc8y%2BlOTO956X0RVbfKVRtZk7gwhncomQyae9KzHjr5fRhyVdhMXGHGswAdg9Vor0eBzlHlm1x6SUhmaHHhIAOzR1AXMjPMJjcgWESTUeo5OmwNG%2FjAenKS7Um64Fd6tJ9l44Fv6UjvqPKNsueQCKF8qgLjKnpbQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200920T214516Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTY2QN6BRGE%2F20200920%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=a55279570ae85480ff7732c20e484c17049cf3ac798bb7ca83e4f0da70ff3905&hash=c3ab1c8f1cf4172e75ba4fccca48e1bf591c935ca1191705221f82c65124c379&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X87900176&tid=spdf-b3073969-cbe0-41fd-8a9e-6e2b2cd6247f&sid=27939d14918fb14e6d7bc0d-c8b7bcc143a4gxrqa&type=client