Method of presenting lineage diagrams representing query plans
View Patent ↗A diagram manager has a diagram handler and a lineage handler. The diagram handler presents to a user a diagram representing relations between query subjects in a metadata model. The lineage handler changes presentation of a selected query subject to show one or more corresponding query subjects that are represented by the selected query subject.
1. A method of presenting to a user a lineage diagram representing a query plan, the method comprising:
receiving by a computer a query plan from a query engine during a query planning mode when a logical query is processed by the query engine to generate the query plan, the query plan containing transformations used to convert the logical query into one or more native queries that are applicable to databases storing data relevant to the native queries;
generating, during the query planning mode, a lineage diagram representing the query plan using one or more query subjects and one or more symbolic links representing the transformations and conceptual data streams between the query subjects connected by the symbolic links, wherein at least a first query subject in the lineage diagram references a second query subject defined by a metadata model describing a plurality of layers of abstraction of the database storing data relevant to the native queries, and wherein at least one query subject in the lineage diagram references a database table present in one of the databases storing data relevant to the native queries;
receiving user selection of a query subject presented in the lineage diagram;
changing, in the lineage diagram, presentation of the selected query subject to show one or more corresponding query subjects that are represented by the selected query subject such that lineage of the selected query subject is interactively shown in the diagram using the corresponding query subjects in a same or different layer of the metadata model;
allowing the user to select one of the symbolic links visual in a current view; and
expanding or collapsing the selected symbolic link to show or hide one or more query subjects that are represented by the selected symbolic link based on the user's selection.
2. The method as claimed in claim 1 , wherein generating the lineage diagram allows the user to modify the query plan by moving one or query subjects and/or modifying one or more symbolic links.
3. The method as claimed in claim 1 , wherein generating the lineage diagram uses one or more process nodes having symbols to indicate the transformations.
4. The method as claimed in claim 3 , wherein the one or more process nodes use symbols representing a joining, inner join, union, or filter.
5. The method as claimed in claim 1 , further comprising:
receiving a user change in the lineage diagram; and
changing the metadata model in response to the user change made to the lineage diagram.
6. The method as claimed in claim 5 , wherein the user change is adding, removing or altering one or more transformations in the lineage diagram.