Data architecture for fetch-intensive database applications

Details Data architecture for fetch-intensive database applications Data architecture for fetch-intensive database applications

1997-07-29

1999-12-21

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707104, G06F 1730

Patent

active

060062169

ABSTRACT:
A logical data architecture for fetch-intensive database applications includes a first and a second logical database. The second database includes materialized views over the first database. Updates are propagated from the first database to the second database using so-called view maintenance techniques. In preferred embodiments, the first database may be optimized for update transactions and the second database may be optimized for read transactions. At least one of the materialized views included in the second database is based on a pre-defined application read transaction. The update processing overhead associated with view maintenance is substantially performed at the first database.

REFERENCES:
patent: 5276870 (1994-01-01), Shan et al.
patent: 5317731 (1994-05-01), Dias et al.
patent: 5535385 (1996-07-01), Griffin et al.
patent: 5758149 (1998-05-01), Bierma et al.
J.A. Blakeley, P.A. Larson, and F.W. Tompa. Efficiently updating materialized views. In Proc. ACM SIGMOD Symp. on the Management of Data, pp. 61-71, 1986.
S. Ceri and J. Widom. Deriving production rules for incremental view maintenance. In Proc. of Intl. Conf. on Very Large Data Bases, pp. 577-589, 1991.
T. Griffin and L. Libkin. Incremental maintenance of views with duplicates. In Proc. ACM SIGMOD Symp. on the Management of Data, pp. 328-339, 1995.
A. Gupta, I.S. Mumick, and V.S. Subrahamanian. Maintaining views incrementally. In Proc. ACM SIGMOD Symp. on the Management of Data, pp. 157-166, 1993.
W.H. Inmon and C. Kelley. Rdb/VMS: Developing the Data Warehouse. QED Publishing Group, Boston, Massachusetts, 1993.
Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. In Proc. ACM SIGMOD Symp. on the Management of Data, pp. 316-327. San Jose, California, May 1995.
G. Zhou, R. Hull, and R. King. Generating data integration mediators that use materialization. Journal of Intelligent Information Systems. 6(2/3): 199-221, May 1996.

Affiliated with

Also associated with

Rating

Data architecture for fetch-intensive database applications does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Data architecture for fetch-intensive database applications, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data architecture for fetch-intensive database applications will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-515923