Method for editing views created by joins

Details Method for editing views created by joins Method for editing views created by joins

1996-02-14

1998-11-03

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 1, 707200, 707201, 707100, G06F 1730

Patent

active

058324852

ABSTRACT:
A method and apparatus for selectively allowing data presented in a join view to be modified is disclosed. Data presented in a join view is allowed to be modified if provided to the join view by a key-preserved table. A table is a key-preserved table with respect to a join view if each of the keys of the table is a key of the join view. Key-preserved tables may be identified by inspecting the definition of a join view to identify the base tables of the join view and to generate a graph. In the graph, each node corresponds to one of the base tables. Directed edges between nodes of the graph correspond to relationships, specified in the definition of the join view, between the base tables. The graph is reduced to strong components, each of which corresponds to a set of the base tables in which each base table in the set is routed to each other base table in the set by one or more directed edges. If a strong component in the resulting graph constitutes a unique source vertex, then each of the tables corresponding to the unique source vertex are key-preserved tables.

REFERENCES:
patent: 5276870 (1994-01-01), Shan et al.
Segev et al., "Currency-Based Updates to Distributed Materialized Views", IEEE, pp. 512-520, Dec. 1990.

Affiliated with

Also associated with

Rating

Method for editing views created by joins does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for editing views created by joins, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for editing views created by joins will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-704035