{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,17]],"date-time":"2025-10-17T13:29:32Z","timestamp":1760707772242},"reference-count":32,"publisher":"Springer Science and Business Media LLC","issue":"3","license":[{"start":{"date-parts":[[2007,2,14]],"date-time":"2007-02-14T00:00:00Z","timestamp":1171411200000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["J Intell Inf Syst"],"published-print":{"date-parts":[[2008,6]]},"DOI":"10.1007\/s10844-006-0036-6","type":"journal-article","created":{"date-parts":[[2007,2,13]],"date-time":"2007-02-13T18:06:14Z","timestamp":1171389974000},"page":"249-271","source":"Crossref","is-referenced-by-count":6,"title":["Is it DSS or OLTP: automatically identifying DBMS workloads"],"prefix":"10.1007","volume":"30","author":[{"given":"Said","family":"Elnaffar","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Pat","family":"Martin","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Berni","family":"Schiefer","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sam","family":"Lightstone","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2007,2,14]]},"reference":[{"key":"36_CR1","unstructured":"Agrawal, S., Chaudhuri, S., & Narasayya, V. (2001). Automated selection of materialized views and indexes for SQL databases. In Proceedings of 27th VLDB conference (pp. 20\u201331), Rome, Italy."},{"key":"36_CR2","unstructured":"Ailamaki, A., DeWitt, D., Hill, M., & Wood, D. (1999). DBMSs on a modern processor: Where does time go? In Proceedings of international conference on very large data bases (pp. 266\u2013277)."},{"key":"36_CR3","doi-asserted-by":"crossref","unstructured":"Barroso, L., Gharachorloo, K., & Bugnion, E. (1998). Memory system characterization of commercial workloads. In Proceedings of the 25th international symposium on computer architecture (pp. 3\u201314).","DOI":"10.1109\/ISCA.1998.694758"},{"key":"36_CR4","unstructured":"Brown Associates, D. (2000). DB2 UDB vs. Oracle8i: Total cost of ownership. Port Chester, NY: D.H. Brown Associates, Inc. Retrieved from http:\/\/www.breakthroughdb2.com\/ ."},{"key":"36_CR5","doi-asserted-by":"crossref","unstructured":"Chaudhuri, S., & Narasayya, V. (2000). Automating statistics management for query optimizers. In Proceedings of 16th international conference on data engineering. San Diego, USA.","DOI":"10.1109\/ICDE.2000.839433"},{"issue":"1","key":"36_CR6","doi-asserted-by":"crossref","first-page":"127","DOI":"10.1007\/BF01232474","volume":"4","author":"A. Dan","year":"1995","unstructured":"Dan, A., Yu, P., & Chung, J. (1995). Characterization of database access pattern for analytic prediction of buffer hit probability. Very Large Data Bases (VLDB) Journal, 4(1), 127\u2013154.","journal-title":"Very Large Data Bases (VLDB) Journal"},{"key":"36_CR7","unstructured":"Elnaffar, S. (2004). Towards workload-aware DBMSs: Identifying workload type and predicting its change. PhD thesis, Queens University at Kingston, Canada (November)."},{"key":"36_CR8","unstructured":"Elnaffar, S., & Martin, P. (2002). Characterizing computer systems\u2019 workloads. Technical Report 2002-461, Queen\u2019s University."},{"key":"36_CR9","unstructured":"Elnaffar, S., & Martin, P. (2006). The psychic-skeptic prediction framework for effective monitoring of DBMS workloads (submitted)."},{"key":"36_CR10","unstructured":"Fox, A., & Patterson, D. (2003). Self-repairing computers. In Scientific American. Retrieved from http:\/\/www.sciam.com ."},{"issue":"1","key":"36_CR11","doi-asserted-by":"crossref","first-page":"5","DOI":"10.1147\/sj.421.0005","volume":"42","author":"A. Ganek","year":"2003","unstructured":"Ganek, A., & Corbi, T. (2003). The dawning of the autonomic computing era. IBM Systems Journal, 42(1), 5\u201318.","journal-title":"IBM Systems Journal"},{"issue":"3","key":"36_CR12","doi-asserted-by":"crossref","first-page":"781","DOI":"10.1147\/sj.403.0781","volume":"40","author":"W Hsu","year":"2001","unstructured":"Hsu, W., Smith, A., & Young, H. (2001). Characteristics of production database workloads and the TPC benchmarks. IBM Systems Journal, 40(3), 781\u2013802.","journal-title":"IBM Systems Journal"},{"key":"36_CR13","unstructured":"IBM Corp. (1999). DB2 Intelligent Miner for Data. Retrieved from http:\/\/www-4.ibm.com\/software\/data\/iminer\/fordata\/about.html ."},{"key":"36_CR14","unstructured":"IBM Corp. (2000). DB2 Universal Database Version 7 Administration Guide: Performance."},{"key":"36_CR15","unstructured":"IBM Corp. (2003). DB2 Universal Database Version 8.1 Administration Guide: Performance."},{"key":"36_CR16","doi-asserted-by":"crossref","unstructured":"Lightstone, S., Schiefer, B., Zillio, D., & Kleewein, J. (2003). Autonomic computing for relational databases: The ten-year vision. In Proceedings of workshop on autonomic computing principles and architectures. Banff, Alberta.","DOI":"10.1109\/INDIN.2003.1300373"},{"key":"36_CR17","unstructured":"Lohman, G., Valentin, G., Zilio, D., Zuliani, M., & Skelly, A. (2000). DB2 advisor: An optimizer smart enough to recommend its own indexes. In Proceedings of 16th IEEE conference on data engineering. San Diego, CA."},{"key":"36_CR18","unstructured":"Microsoft Corp. (2002). Microsoft SQL Server 2000 Documentation."},{"key":"36_CR19","doi-asserted-by":"crossref","first-page":"345","DOI":"10.1023\/A:1009744630224","volume":"2","author":"S. Murthy","year":"1998","unstructured":"Murthy, S. (1998). Automatic construction of decision trees from data: A multi-disciplinary survey. Data Mining and Knowledge Discovery, 2, 345\u2013389.","journal-title":"Data Mining and Knowledge Discovery"},{"key":"36_CR20","unstructured":"Nikolaou, C., Labrinidis, A., Bohn, V., Ferguson, D., Artavanis, M., Kloukinas, C., et al. (1998). The impact of workload clustering on transaction routing. Technical Report FORTH-ICS TR-238."},{"key":"36_CR21","unstructured":"Oracle Corp. (2001a). Oracle 9i Manageability Features. An Oracle White Paper. Retrieved from http:\/\/www.oracle.com\/ip\/deploy\/database\/oracle9i\/collateral\/ma_bwp10.pdf ."},{"key":"36_CR22","unstructured":"Oracle Corp. (2001b). Oracle9iDatabase Performance Guide and Reference, Release 1(9.0.1), Part# A87503-02."},{"key":"36_CR23","unstructured":"Oracle Corp. (2001c). Oracle 9i Materialized Views. An Oracle White Paper. Retrieved from http:\/\/technet.oracle.com\/products\/oracle9i\/pdf\/o9i_mv.pdf ."},{"key":"36_CR24","unstructured":"Oracle Corp. (2002). Query Optimization in Oracle 9i. An Oracle White Paper. Retrieved from http:\/\/technet.oracle.com\/products\/bi\/pdf\/o9i_optimization_twp.pdf ."},{"key":"36_CR25","doi-asserted-by":"crossref","unstructured":"Sapia, C. (2000). PROMISE: Predicting query behavior to enable predictive caching strategies for OLAP systems. In Proceedings of the second international conference on data warehousing and knowledge discovery (pp. 224\u2013233).","DOI":"10.1007\/3-540-44466-1_22"},{"key":"36_CR26","unstructured":"Shafer, J., Agrawal, R., & Mehta, M. (1996). SPRINT: A scalable parallel classifier for data mining. In Proceedings of the 22th international conference on very large databases. Mumbai (Bombay), India."},{"key":"36_CR27","unstructured":"Stillger, M., Lohman, G., Markl, V., & Kandil, M. (2001). LEO\u2014DB2\u2019s LEarning optimizer. In Proceedings of 27th VLDB conference (pp. 19\u201328). Rome, Italy."},{"key":"36_CR28","unstructured":"TPC (1999a). Benchmark D Standard Specification Revision 2.1, Transaction Processing Performance Council."},{"key":"36_CR29","unstructured":"TPC (1999b). Benchmark H Standard Specification Revision 1.3.0, Transaction Processing Performance Council."},{"key":"36_CR30","unstructured":"TPC (2001a). Benchmark C Standard Specification Revision 5.0, Transaction Processing Performance Council."},{"key":"36_CR31","unstructured":"TPC (2001b). Benchmark W (Web Commerce) Standard Specification Revision 1.7, Transaction Processing Performance Council."},{"issue":"5","key":"36_CR32","doi-asserted-by":"crossref","first-page":"764","DOI":"10.1109\/69.317706","volume":"6","author":"P. Yu","year":"1994","unstructured":"Yu, P., & Dan, A. (1994). Performance analysis of affinity clustering on transaction processing coupling architecture. IEEE Transactions on Knowledge and Data Engineering, 6(5), 764\u2013786.","journal-title":"IEEE Transactions on Knowledge and Data Engineering"}],"container-title":["Journal of Intelligent Information Systems"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-006-0036-6.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10844-006-0036-6\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-006-0036-6","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,31]],"date-time":"2019-05-31T02:10:46Z","timestamp":1559268646000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10844-006-0036-6"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2007,2,14]]},"references-count":32,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2008,6]]}},"alternative-id":["36"],"URL":"https:\/\/doi.org\/10.1007\/s10844-006-0036-6","relation":{},"ISSN":["0925-9902","1573-7675"],"issn-type":[{"value":"0925-9902","type":"print"},{"value":"1573-7675","type":"electronic"}],"subject":[],"published":{"date-parts":[[2007,2,14]]}}}