{"id":"https://openalex.org/W2002963734","doi":"https://doi.org/10.1007/s10844-006-0036-6","title":"Is it DSS or OLTP: automatically identifying DBMS workloads","display_name":"Is it DSS or OLTP: automatically identifying DBMS workloads","publication_year":2007,"publication_date":"2007-02-13","ids":{"openalex":"https://openalex.org/W2002963734","doi":"https://doi.org/10.1007/s10844-006-0036-6","mag":"2002963734"},"language":"en","primary_location":{"id":"doi:10.1007/s10844-006-0036-6","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10844-006-0036-6","pdf_url":null,"source":{"id":"https://openalex.org/S36033921","display_name":"Journal of Intelligent Information Systems","issn_l":"0925-9902","issn":["0925-9902","1573-7675"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5091248435","display_name":"Said Elnaffar","orcid":"https://orcid.org/0000-0002-6029-3429"},"institutions":[{"id":"https://openalex.org/I201726411","display_name":"United Arab Emirates University","ror":"https://ror.org/01km6p862","country_code":"AE","type":"education","lineage":["https://openalex.org/I201726411"]}],"countries":["AE"],"is_corresponding":true,"raw_author_name":"Said Elnaffar","raw_affiliation_strings":["College of IT, UAE University, Al-Ain, 17555, UAE","College of IT, UAE University, Al-Ain, UAE 17555"],"affiliations":[{"raw_affiliation_string":"College of IT, UAE University, Al-Ain, 17555, UAE","institution_ids":["https://openalex.org/I201726411"]},{"raw_affiliation_string":"College of IT, UAE University, Al-Ain, UAE 17555","institution_ids":["https://openalex.org/I201726411"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074608403","display_name":"Pat Martin","orcid":null},"institutions":[{"id":"https://openalex.org/I204722609","display_name":"Queen's University","ror":"https://ror.org/02y72wh86","country_code":"CA","type":"education","lineage":["https://openalex.org/I204722609"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Pat Martin","raw_affiliation_strings":["School of Computing, Queen\u2019s University, Kingston, ON, K7L 3N6, Canada","School of Computing, Queen's University,Kingston,Canada,K7L 3N6"],"affiliations":[{"raw_affiliation_string":"School of Computing, Queen\u2019s University, Kingston, ON, K7L 3N6, Canada","institution_ids":["https://openalex.org/I204722609"]},{"raw_affiliation_string":"School of Computing, Queen's University,Kingston,Canada,K7L 3N6","institution_ids":["https://openalex.org/I204722609"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110113360","display_name":"Berni Schiefer","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"Berni Schiefer","raw_affiliation_strings":["IBM Canada, IBM Software Lab, Markham, ON, L6G 1C7, Canada","IBM Canada, IBM Software Lab, Markham, Canada L6G 1C7#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Canada, IBM Software Lab, Markham, ON, L6G 1C7, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Canada, IBM Software Lab, Markham, Canada L6G 1C7#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5030480168","display_name":"Sam Lightstone","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"Sam Lightstone","raw_affiliation_strings":["IBM Canada, IBM Software Lab, Markham, ON, L6G 1C7, Canada","IBM Canada, IBM Software Lab, Markham, Canada L6G 1C7#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Canada, IBM Software Lab, Markham, ON, L6G 1C7, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Canada, IBM Software Lab, Markham, Canada L6G 1C7#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5091248435"],"corresponding_institution_ids":["https://openalex.org/I201726411"],"apc_list":{"value":2490,"currency":"EUR","value_usd":3090},"apc_paid":null,"fwci":0.3383,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.64977074,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"30","issue":"3","first_page":"249","last_page":"271"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9957000017166138,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.993399977684021,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.9629863500595093},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8799917697906494},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.8795821666717529},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7233695983886719},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6852099895477295},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5925514698028564},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.5043450593948364},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.473954439163208},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.3756802976131439},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.33478909730911255},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.29722827672958374},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.2763776183128357},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.2595430910587311},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.07291322946548462}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.9629863500595093},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8799917697906494},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.8795821666717529},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7233695983886719},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6852099895477295},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5925514698028564},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.5043450593948364},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.473954439163208},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.3756802976131439},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.33478909730911255},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.29722827672958374},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.2763776183128357},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.2595430910587311},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07291322946548462},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s10844-006-0036-6","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10844-006-0036-6","pdf_url":null,"source":{"id":"https://openalex.org/S36033921","display_name":"Journal of Intelligent Information Systems","issn_l":"0925-9902","issn":["0925-9902","1573-7675"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent Information Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320307762","display_name":"International Business Machines Corporation","ror":"https://ror.org/05hh8d621"},{"id":"https://openalex.org/F4320307764","display_name":"Microsoft","ror":"https://ror.org/00d0nc645"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W17444570","https://openalex.org/W32689398","https://openalex.org/W1483135265","https://openalex.org/W1780185704","https://openalex.org/W1983804562","https://openalex.org/W1985699615","https://openalex.org/W2079648353","https://openalex.org/W2094322553","https://openalex.org/W2102166438","https://openalex.org/W2122816893","https://openalex.org/W2125279093","https://openalex.org/W2127085526","https://openalex.org/W2142550009","https://openalex.org/W2145663758","https://openalex.org/W2155350341","https://openalex.org/W2155651153","https://openalex.org/W2168503413","https://openalex.org/W2540830414","https://openalex.org/W4243587504","https://openalex.org/W4285719527","https://openalex.org/W6646259609","https://openalex.org/W6675727724"],"related_works":["https://openalex.org/W2804682780","https://openalex.org/W2084383859","https://openalex.org/W3166336118","https://openalex.org/W2188262136","https://openalex.org/W834810655","https://openalex.org/W2084266952","https://openalex.org/W2188975716","https://openalex.org/W171602259","https://openalex.org/W2102729946","https://openalex.org/W2240092424"],"abstract_inverted_index":null,"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}