Data architecture for fetch-intensive database applications

Data processing: database and file management or data structures – Database design – Data structure types

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

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.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

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

     

Profile ID: LFUS-PAI-O-515923

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.