{"id":"https://openalex.org/W319014924","doi":null,"title":"A Two-stage Evaluation of User Query Performance for the Relational Model and SQL","display_name":"A Two-stage Evaluation of User Query Performance for the Relational Model and SQL","publication_year":2007,"publication_date":"2007-01-01","ids":{"openalex":"https://openalex.org/W319014924","mag":"319014924"},"language":"en","primary_location":{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/42827","doi":null,"is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/42827","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scopus","raw_type":"Conference Paper"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":[],"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/A5113636945","display_name":"Hock Chuan Chan","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Hock Chuan Chan","raw_affiliation_strings":["National University of Singapore"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5113636945"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"118","last_page":null},"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.9740999937057495,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9740999937057495,"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/T10286","display_name":"Information Retrieval and Search Behavior","score":0.007300000172108412,"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/T11106","display_name":"Data Management and Algorithms","score":0.0017000000225380063,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-model","display_name":"relational model","score":0.921999990940094},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.984000027179718},{"id":"https://openalex.org/keywords/query-performance-evaluation","display_name":"query performance evaluation","score":0.5899999737739563}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.86517333984375},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.8556414842605591},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.8330049514770508},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8024243116378784},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.7949327230453491},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.7679671049118042},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.7276604771614075},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.6745397448539734},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5400245189666748},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.5372199416160583},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5163775682449341},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.48122453689575195},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27514877915382385},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12161460518836975},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10745340585708618}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/42827","doi":null,"is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/42827","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scopus","raw_type":"Conference Paper"},{"id":"pmh:oai:aisel.aisnet.org:pacis2007-1111","doi":null,"is_oa":false,"landing_page_url":"http://aisel.aisnet.org/cgi/viewcontent.cgi?article=1111&context=pacis2007","pdf_url":null,"source":{"id":"https://openalex.org/S30879505","display_name":"Journal of the Association for Information Systems","issn_l":"1536-9323","issn":["1536-9323"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-a-star","anvur-scientific","cwts-core","dongbi-a","fnege-1","jufo-3","norway-2","poland-140","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310321080","host_organization_name":"Association for Information Systems","host_organization_lineage":["https://openalex.org/P4310321080"],"host_organization_lineage_names":["Association for Information Systems"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"PACIS 2007 Proceedings","raw_type":"text"},{"id":"mag:319014924","doi":null,"is_oa":false,"landing_page_url":"http://aisel.aisnet.org/cgi/viewcontent.cgi?article=1111&context=pacis2007","pdf_url":null,"source":{"id":"https://openalex.org/S4306420657","display_name":"Pacific Asia Conference on Information Systems","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Pacific Asia Conference on Information Systems","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W3951449","https://openalex.org/W118775435","https://openalex.org/W133567704","https://openalex.org/W197224857","https://openalex.org/W201431299","https://openalex.org/W404070196","https://openalex.org/W1487725643","https://openalex.org/W1491057425","https://openalex.org/W1499274542","https://openalex.org/W1519179082","https://openalex.org/W1543230276","https://openalex.org/W1575391024","https://openalex.org/W1585663410","https://openalex.org/W1589728983","https://openalex.org/W1596981116","https://openalex.org/W1964523235","https://openalex.org/W1965187559","https://openalex.org/W1965952789","https://openalex.org/W1966270718","https://openalex.org/W1987975131","https://openalex.org/W1992389722","https://openalex.org/W1994107079","https://openalex.org/W2023745308","https://openalex.org/W2036832324","https://openalex.org/W2042751396","https://openalex.org/W2050678942","https://openalex.org/W2071100465","https://openalex.org/W2082475955","https://openalex.org/W2087568125","https://openalex.org/W2090253867","https://openalex.org/W2094208344","https://openalex.org/W2096431252","https://openalex.org/W2115647291","https://openalex.org/W2117976212","https://openalex.org/W2119412658","https://openalex.org/W2139882688","https://openalex.org/W2143799661","https://openalex.org/W2145618437","https://openalex.org/W2150147167","https://openalex.org/W2151724878","https://openalex.org/W2158459778","https://openalex.org/W2171070728","https://openalex.org/W2403836124","https://openalex.org/W2753710282","https://openalex.org/W2798570750"],"related_works":["https://openalex.org/W6990638320","https://openalex.org/W1971638352","https://openalex.org/W2043020440","https://openalex.org/W2419053096","https://openalex.org/W1553228353","https://openalex.org/W7008716023","https://openalex.org/W7037574508","https://openalex.org/W7042838691","https://openalex.org/W7099608769","https://openalex.org/W184426432"],"abstract_inverted_index":{"PACIS":[0],"2007":[1],"-":[2],"11th":[3],"Pacific":[4],"Asia":[5],"Conference":[6],"on":[7],"Information":[8],"Systems:":[9],"Managing":[10],"Diversity":[11],"in":[12],"Digital":[13],"Enterprises":[14]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}