Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons
Reexamination Certificate
2011-04-26
2011-04-26
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database and file access
Record, file, and data search and comparisons
C707S769000
Reexamination Certificate
active
07933913
ABSTRACT:
Pursuant to receipt of a data modification command or statement, such as an Update command, it is determined which fields in a data structure, such as a UDT, computed column, indexed view, or index, for example, will be changed as a result of the command. Only those fields that are affected by the command will be changed. Thus, changes are propagated to only to those dependent data structures whose content is being modified. Tree representations are used to facilitate the determination as to whether a subfield in a hierarchy is changed.
REFERENCES:
patent: 5396625 (1995-03-01), Parkes
patent: 6338056 (2002-01-01), Dessloch et al.
patent: 7769770 (2010-08-01), Denuit et al.
Bebel et al., “Hierarchical Materialisation of Methods in Object-Oriented Views: Design, Maintenance, and Experimental Evaluation”, Proceedings of the 4thACM international workshop on Data warehousing and OLAP, Nov. 2001, 77-84.
Goldstein et al., “Optimizing Queries Using Materialized Views: A Practical, Scalable Solution”, ACM SIGMOD Record, Proceedings of the 2001 ACM SIGMOD international conference on Management of data, May 2001, 30(2), 331-342.
Graefe, “Query Evaluation Techniques for Large Databases”, ACM Computing Surveys (CSUR), Jun. 1993, 25(2), 73-170.
Hanson, “A Performance Analysis of View Materialization Strategies”, ACM SIGMOD Record, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, Dec. 1987, 16(3), 440-453.
Jones et al., “View Materialization Techniques for Complex Hierarchical Objects”, Proceedings of the sixth international conference on Information and knowledge management, Jan. 1997, 222-229.
Kotidis et al., “A Case for Dynamic View Management”, ACM Transactions on Database Systems (TODS), Dec. 2001, 26(4), 388-423.
Kotidis et al., “DynaMat: A Dynamic View Management System for Data Warehouses”, ACM SIGMOD Record, Proceedings of the 1999 ACM SIGMOD international conference on Management of data, Jun. 1999, 28(2), 371-382.
Lee et al., “Incremental View Update for a Mobile Data Warehouse”, Proceedings of the 1998 ACM symposium on Applied Computing, Feb. 1998, 394-399.
Mistry et al., “Materialized View Selection and Maintenance Using Multi Query Optimization”, ACM SIGMOD Record, Proceedings of the 2001 ACM SIGMOD international conference on Management of data, May 2001, 30(2), 307-318.
Ross et al., “Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time”, ACM SIGMOD Record, Proceedings of the 1996 ACM SIGMOD international conference on Management of data, Jun. 1996, 25(2), 447-458.
Roussopoulos, “View Indexing in Relational Databases”, ACM Transactions on Database Systems (TODS), Jun. 1982, 7(2), 258-290.
Denuit Bruno H. M.
Stefani Stefano
Chojnacki Mellissa M
Microsoft Corporation
Rones Charles
Woodcock & Washburn LLP
LandOfFree
Secondary index and indexed view maintenance for updates to... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Secondary index and indexed view maintenance for updates to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Secondary index and indexed view maintenance for updates to... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2690097