Normal view MARC view ISBD view

Materialized views : techniques, implementations, and applications / edited by Ashish Gupta, Inderpal Singh Mumick ; foreword by Jeffrey D. Ullman.

Contributor(s): Mumick, Inderpal Singh | Gupta, Ashish, 1968- | IEEE Xplore (Online Service) [distributor.] | MIT Press [publisher.].
Material type: materialTypeLabelBookPublisher: Cambridge, Massachusetts : MIT Press, 1999Distributor: [Piscataqay, New Jersey] : IEEE Xplore, [1999]Description: 1 PDF (xix, 589 pages) : illustrations.Content type: text Media type: electronic Carrier type: online resourceISBN: 9780262287500.Subject(s): Database management | Data warehousing | Materialized views (Computer science)Genre/Form: Electronic books.Additional physical formats: Print version: No titleDDC classification: 005.74/068 Online resources: Abstract with links to resource Also available in print.Summary: When an application is built, an underlying data model is chosen to make that application effective. Frequently, other applications need the same data, only modeled differently. The naive solution of copying the underlying data and modeling is costly in terms of storage and makes data maintenance and evolution impossible. View mechanisms are a technique to model data differently for various applications without affecting the underlying format and structure of the data. The technique enables applications to customize shared data objects without affecting other applications that use the same objects. The growing data-manipulation needs of companies cannot be met by existing legacy systems that contain valuable data. Thus view mechanisms are becoming increasingly important as a way to model and use legacy data in new applications.Materialized views are views that have been computed and stored in databases. Because they reduce the need to recompute the view and/or data being queried, they speed up the querying of large amounts of data. Further, because they provide a systematic way to describe how to recompute the data, maintenance and evolution can be automated. Materialized views are especially useful in data warehousing, query optimization, integrity constraint maintenance, online analytical processing, and applications such as billing, banking, and retailing. This comprehensive volume, with a foreword by Jeff Ullman of Stanford University, will serve as a reference for students and commercial users, and encourage further use and development of materialized views.
    average rating: 0.0 (0 votes)
No physical items for this record

Includes bibliographical references (p. [551]-579) and index.

Restricted to subscribers or individual electronic text purchasers.

When an application is built, an underlying data model is chosen to make that application effective. Frequently, other applications need the same data, only modeled differently. The naive solution of copying the underlying data and modeling is costly in terms of storage and makes data maintenance and evolution impossible. View mechanisms are a technique to model data differently for various applications without affecting the underlying format and structure of the data. The technique enables applications to customize shared data objects without affecting other applications that use the same objects. The growing data-manipulation needs of companies cannot be met by existing legacy systems that contain valuable data. Thus view mechanisms are becoming increasingly important as a way to model and use legacy data in new applications.Materialized views are views that have been computed and stored in databases. Because they reduce the need to recompute the view and/or data being queried, they speed up the querying of large amounts of data. Further, because they provide a systematic way to describe how to recompute the data, maintenance and evolution can be automated. Materialized views are especially useful in data warehousing, query optimization, integrity constraint maintenance, online analytical processing, and applications such as billing, banking, and retailing. This comprehensive volume, with a foreword by Jeff Ullman of Stanford University, will serve as a reference for students and commercial users, and encourage further use and development of materialized views.

Also available in print.

Mode of access: World Wide Web

Description based on PDF viewed 12/23/2015.

There are no comments for this item.

Log in to your account to post a comment.