Optimal Synchronization Policies for Data Warehouses

Published Online:https://doi.org/10.1287/ijoc.1040.0094

References

  • Adelberg B., Garcia-Molina H., Kao B. Applying update streams in a soft real-time database system. ACM SIGMOD Record (1995) 24:245–256CrossrefGoogle Scholar
  • Adiba M. E., Lindsay B. G. Database snapshots. Proc. Internat. Conf. Very Large Data Bases (1980) Montreal, Canada:86–91Google Scholar
  • Agrawal D., Abbadi A., Singh A., Yurek T. Efficient view maintenance at data warehouses. ACM SIGMOD Record (1997) 26:417–427CrossrefGoogle Scholar
  • Anahory S., Murray D.Data Warehousing in the Real World (1997) (Addison-Wesley, Harlow, UK) Google Scholar
  • Babad Y. M., Saharia A. N. Use of stale answers in database applications. Proc. Internat. Conf. Inform. Systems (1992) Dallas, TX:233–239Google Scholar
  • Ballou D. P., Pazer H. L. Designing information systems to optimize the accuracy-timeliness tradeoff. Inform. Systems Res. (1995) 6:51–72LinkGoogle Scholar
  • Ballou D. P., Tayi G. K. Methodology for allocating resources for data quality enhancement. Comm. ACM (1989) 32:320–329CrossrefGoogle Scholar
  • Bischoff J., Alexander T.Data Warehouse: Practical Advice from the Experts (1997) (Prentice-Hall, Upper Saddle River, NJ) Google Scholar
  • Blakeley J. A., Coburn N., Larson P. Updating derived relations: Detecting irrelevant and autonomously computable updates. ACM Trans. Database Systems (1989) 14:369–400CrossrefGoogle Scholar
  • Chan C.-Y., Ioannidis Y. E. Bitmap index design and evaluation. ACM SIGMOD Record (1998) 27:355–366CrossrefGoogle Scholar
  • Chandy K. M., Browne J. C., Dissly C. W., Uhrig W. R. Analytical models for rollback and recovery strategies in database systems. IEEE Trans. Software Engrg. (1975) SE-1:100–110CrossrefGoogle Scholar
  • Chaudhuri S., Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Record (1997) 26:65–74CrossrefGoogle Scholar
  • Colby L. S., Griffin T., Libkin L., Mumick I. S., Trickey H. Algorithms for deferred view maintenance. ACM SIGMOD Record (1996) 25:469–480CrossrefGoogle Scholar
  • Crovella M. E., Bestavros A. Self-similarity in world wide web traffic: Evidence and possible causes. ACM Trans. Networking (1997) 5:835–846CrossrefGoogle Scholar
  • Dey D., Barron T. M., Saharia A. N. A decision model for choosing the optimal level of storage in temporal databases. IEEE Trans. Knowledge Data Engrg. (1998) 10:297–309CrossrefGoogle Scholar
  • Fowler H., Leland W. E. Local area network traffic characteristics, with implications for broadband network congestion management. IEEE J. Selected Areas Comm. (1991) 9:1139–1149CrossrefGoogle Scholar
  • Garcia-Molina H., Labio W. J., Yang J. Expiring data in a warehouse. Proc. 24th VLDB Conf. (1998) New York:500–511Google Scholar
  • Garcia-Molina H., Ullman J. D., Widom J.Database Systems: The Complete Book (2002) (Prentice Hall, Upper Saddle River, NJ) Google Scholar
  • Gelenbe E. On the optimum checkpoint interval. J. ACM (1979) 26:259–270CrossrefGoogle Scholar
  • Griffin T., Libkin L. Incremental maintenance of views with duplicates. ACM SIGMOD Record (1995) 24:328–339CrossrefGoogle Scholar
  • Gupta H., Mumick I. S. Selection of views to materialize under a maintenance cost constraint. Proc. 7th Internat. Conf. Database Theory (1999) Jerusalem, Israel:453–470CrossrefGoogle Scholar
  • Harinarayan V., Rajaraman A., Ullman J. Implementing data cubes efficiently. ACM SIGMOD Record (1996) 25:205–216CrossrefGoogle Scholar
  • Inmon W. H. Managing the data warehouse environment. Data Management Rev. (1996) 6:8Google Scholar
  • Jarke M., Lenzerini M., Vassiliou Y., Vassiliadis P.Fundamentals of Data Warehouses (2000) (Springer, New York) CrossrefGoogle Scholar
  • Krajewski L. J., Ritzman L. P.Operations Management: Strategy and Analysis (1990) (Addison-Wesley, Reading, MA) Google Scholar
  • Labio W. J., Yerneni R., Garcia-Molina H. Shrinking the warehouse update window. ACM SIGMOD Record (1999) 28:383–394CrossrefGoogle Scholar
  • Leland W. E., Taqqu M. S., Willinger W., Wilson D. V. On the self-similar nature of Ethernet traffic. IEEE/ACM Trans. Networking (1994) 2:1–15CrossrefGoogle Scholar
  • Liang W., Li H., Wang H., Orlowska M. E. Making multiple views self-maintainable in a data warehouse. Data Knowledge Engrg. (1999) 30:121–134CrossrefGoogle Scholar
  • McDysan D.QoS and Traffic Management in IP and ATM Networks (2000) (McGraw Hill, New York) Google Scholar
  • Mendelson H., Saharia A. N. Incomplete information costs and database design. ACM Trans. Database Systems (1986) 11:159–185CrossrefGoogle Scholar
  • Paradice D. B., Fuerst W. L. An MIS data quality methodology based on optimal error detection. J. Inform. Systems (1991) 5:48–66Google Scholar
  • Paxson V., Floyd S. Wide area traffic: The failure of Poisson modeling. IEEE/ACM Trans. Networking (1995) 3:226–244CrossrefGoogle Scholar
  • Quass D., Gupta A., Mumick I. S., Widom J. Making views self-maintainable for data warehousing. Proc. 4th Internat. Conf. Parallel Distributed Inform. Systems (1996) Miami, FL:158–169CrossrefGoogle Scholar
  • Quass D., Widom J. Online warehouse view maintenance. ACM SIGMOD Record (1997) 26:393–404CrossrefGoogle Scholar
  • Saharia A. N., Diehr G. A refresh scheme for remote snapshots. Inform. Systems Res. (1990) 1:277–308LinkGoogle Scholar
  • Segev A., Park J. Updating distributed materialized views. IEEE Trans. Knowledge Data Engrg. (1989) 1:173–184CrossrefGoogle Scholar
  • Srivastava J., Rotem D. Analytical modeling of materialized view maintenance. Proc. ACM SIGMOD Conf. Principles Database Systems (1988) Austin, TX:126–134CrossrefGoogle Scholar
  • Stockinger K., Wu K., Shoshani A. Strategies for processing ad hoc queries on large data warehouses. Proc. 5th ACM Internat. Workshop Data Warehousing OLAP (2002) McLean, VA:72–79CrossrefGoogle Scholar
  • Tantawi A. N., Ruschitzka M. Performance analysis of checkpointing strategies. ACM Trans. Comput. Systems (1984) 2:123–144CrossrefGoogle Scholar
  • Theodoratos D., Bouzeghoub M. A general framework for the view selection problem for data warehouse design and evolution. Proc. ACM Internat. Workshop Data Warehousing OLAP (2000) McLean, VA:1–8CrossrefGoogle Scholar
  • Vavouras A., Gatziu S., Dittrich K. R. Modeling and executing the data warehouse refreshment process. Proc. Internat. Sympos. Database Appl. Non-Traditional Environ. (DANTE 99) (1999) Kyoto, Japan:66–73Google Scholar
  • Winter R. Field experience with large scale data warehousing on Oracle. White Paper, Sponsored Research Program (2002) (Winter Corporation, Waltham, MA) Google Scholar
  • Yang J., Karlapalem K., Li Q. Algorithms for materialized view design in data warehousing environment. Proc. Internat. Conf. Very Large Data Bases (1997) Athens, Greece:136–145Google Scholar
INFORMS site uses cookies to store information on your computer. Some are essential to make our site work; Others help us improve the user experience. By using this site, you consent to the placement of these cookies. Please read our Privacy Statement to learn more.