{"id":"https://openalex.org/W646930291","doi":null,"title":"Effect of Different Database Structure Representations, Query Languages, and Task Characteristics on Information Retrieval","display_name":"Effect of Different Database Structure Representations, Query Languages, and Task Characteristics on Information Retrieval","publication_year":2015,"publication_date":"2015-01-01","ids":{"openalex":"https://openalex.org/W646930291","mag":"646930291"},"language":"en","primary_location":{"id":"mag:646930291","doi":null,"is_oa":false,"landing_page_url":"http://ci.nii.ac.jp/ncid/BA67321208","pdf_url":null,"source":{"id":"https://openalex.org/S2764659262","display_name":"Academy of Information and Management Sciences journal","issn_l":"1524-7252","issn":["1524-7252"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["poland-20"],"host_organization":"https://openalex.org/P4310315810","host_organization_name":"Allied Academies","host_organization_lineage":["https://openalex.org/P4310315810","https://openalex.org/P4310320466"],"host_organization_lineage_names":["Allied Academies","OMICS Publishing Group"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Academy of Information and Management Sciences journal","raw_type":null},"volume":null,"type":"article","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/A5081466417","display_name":"Pascal A. Bizarro","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Pascal A. Bizarro","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5081466417"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.01317324,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":92},"biblio":{"volume":"18","issue":"1","first_page":"27","last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.2734000086784363,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.2734000086784363,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11734","display_name":"Decision Support System Applications","score":0.24549999833106995,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10286","display_name":"Information Retrieval and Search Behavior","score":0.19370000064373016,"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/query-languages","display_name":"query languages","score":0.8450000286102295},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.574999988079071},{"id":"https://openalex.org/keywords/entity-relationship-model","display_name":"entity-relationship model","score":0.9459999799728394},{"id":"https://openalex.org/keywords/query-by-example","display_name":"query-by-example","score":0.8320000171661377},{"id":"https://openalex.org/keywords/structured-query-language","display_name":"structured query language","score":0.9649999737739563},{"id":"https://openalex.org/keywords/accounting-information-systems","display_name":"accounting information systems","score":0.7680000066757202},{"id":"https://openalex.org/keywords/user-characteristics","display_name":"user characteristics","score":0.43700000643730164},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"information retrieval","score":0.4880000054836273},{"id":"https://openalex.org/keywords/task-characteristics","display_name":"task characteristics","score":0.41200000047683716}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8219172358512878},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.734270453453064},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.7259188890457153},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6774346232414246},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6180418133735657},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6065280437469482},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5008399486541748},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.48808109760284424},{"id":"https://openalex.org/C163867264","wikidata":"https://www.wikidata.org/wiki/Q4672792","display_name":"Accounting information system","level":2,"score":0.4507538974285126},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.44071394205093384},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4305417537689209},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.3402070999145508},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2848811447620392},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2823610007762909},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.17740535736083984},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10295909643173218},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:646930291","doi":null,"is_oa":false,"landing_page_url":"http://ci.nii.ac.jp/ncid/BA67321208","pdf_url":null,"source":{"id":"https://openalex.org/S2764659262","display_name":"Academy of Information and Management Sciences journal","issn_l":"1524-7252","issn":["1524-7252"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["poland-20"],"host_organization":"https://openalex.org/P4310315810","host_organization_name":"Allied Academies","host_organization_lineage":["https://openalex.org/P4310315810","https://openalex.org/P4310320466"],"host_organization_lineage_names":["Allied Academies","OMICS Publishing Group"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Academy of Information and Management Sciences journal","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":40,"referenced_works":["https://openalex.org/W99131893","https://openalex.org/W173833665","https://openalex.org/W301845292","https://openalex.org/W568984980","https://openalex.org/W1503787388","https://openalex.org/W1519179082","https://openalex.org/W1565714532","https://openalex.org/W1572700383","https://openalex.org/W1791587663","https://openalex.org/W1945121096","https://openalex.org/W1963857427","https://openalex.org/W1965187559","https://openalex.org/W1966606449","https://openalex.org/W1967390364","https://openalex.org/W1976777610","https://openalex.org/W1978966145","https://openalex.org/W1986864424","https://openalex.org/W2006148096","https://openalex.org/W2006783182","https://openalex.org/W2011126315","https://openalex.org/W2011582530","https://openalex.org/W2013012235","https://openalex.org/W2035489143","https://openalex.org/W2043892562","https://openalex.org/W2053154970","https://openalex.org/W2055008679","https://openalex.org/W2072031888","https://openalex.org/W2085832100","https://openalex.org/W2086647323","https://openalex.org/W2090253867","https://openalex.org/W2103219113","https://openalex.org/W2107045209","https://openalex.org/W2123334556","https://openalex.org/W2123605118","https://openalex.org/W2124670784","https://openalex.org/W2150147167","https://openalex.org/W2159306398","https://openalex.org/W2159593279","https://openalex.org/W3015264064","https://openalex.org/W7137042922"],"related_works":["https://openalex.org/W1554229619","https://openalex.org/W173833665","https://openalex.org/W7018824763","https://openalex.org/W203919745","https://openalex.org/W2077924815","https://openalex.org/W3146469788","https://openalex.org/W21710947","https://openalex.org/W7037511823","https://openalex.org/W2066293000","https://openalex.org/W1546627234"],"abstract_inverted_index":{"INTRODUCTION":[0],"The":[1,178,335,361],"accounting":[2,27,61,94,131,522],"and":[3,20,34,69,76,83,101,117,134,144,154,173,191,204,268,282,309,315,327,343,484,491,523,556,578,591],"business":[4,17,98],"communities":[5],"increasingly":[6],"rely":[7],"on":[8,245,252,387,416,500,559],"database":[9,81,124,166,185,296,324,431,502,551],"applications":[10],"to":[11,58,86,92,109,202,238,260,294,404,573,589],"convert":[12],"raw":[13],"data":[14,95,132,142,159,341,394,417,428,447],"into":[15,96],"useful":[16,97],"information":[18,28,40,99,114,253,564],"(Hayes":[19],"Hunton,":[21],"2000).":[22],"Today,":[23],"a":[24,165,219,225,399,475,494,594],"majority":[25],"of":[26,130,160,164,377,422,426,466,472,496,550],"systems":[29,41,62],"use":[30,63,87,471,493],"relational":[31,156],"databases":[32,67],"(Hooper":[33,68],"Page,":[35,70],"1996).":[36,71,103],"In":[37,505],"the":[38,80,88,112,128,140,150,155,264,295,323,328,340,344,355,358,369,375,378,393,423,427,446,470,534,542,548,563,581,587],"past,":[39],"(IS)":[42],"professionals,":[43],"not":[44,211,353],"end-users,":[45],"were":[46,439],"responsible":[47],"for":[48,408,430,441,528],"query":[49,90,167,175,188,198,246,288,329,345,383,388,454,487,497,554,593],"tasks":[50,433,456],"(Borthick,":[51,121],"1992).":[52,122],"Recently,":[53],"this":[54,223,365,479,519],"function":[55],"has":[56,210],"shifted":[57],"end-users":[59,105],"as":[60,222,372,374,474,486,516,526],"more":[64,240],"easily":[65],"accessible":[66],"End-users":[72],"(e.g.,":[73],"accountants,":[74],"auditors,":[75,490],"managers)":[77],"must":[78,106],"understand":[79],"structure":[82,125,325,552],"be":[84,107,235],"able":[85,108],"available":[89,116],"language":[91,176,265,289,330],"transform":[93],"(Leitheiser":[100],"March,":[102,283],"Accounting":[104],"discern":[110],"whether":[111],"potential":[113,529],"is":[115,181,224,402,533],"then":[118],"retrieve":[119],"it":[120],"A":[123],"representation":[126,138,186,258,297,326],"communicates":[127],"availability":[129],"(Dunn":[133],"Grabski,":[135],"2002).":[136],"This":[137,532,545],"details":[139],"stored":[141],"items":[143],"their":[145,216,242,501,575],"logical":[146],"organization.":[147],"Examples":[148,169],"include":[149,170],"entity-relationship":[151],"(ER)":[152],"model":[153,259,342,395,429,448],"model.":[157,544],"Accessing":[158],"interest":[161],"requires":[162],"knowledge":[163],"language.":[168,346],"query-by-example":[171],"(QBE)":[172],"structured":[174],"(SQL).":[177],"IS":[179,514],"literature":[180],"unclear":[182],"concerning":[183],"how":[184],"type,":[187,190],"tool":[189,401],"user":[192,451,539,560],"characteristic":[193],"affect":[194],"end-user":[195,382],"performance":[196,452,561],"in":[197,218,453,541,562],"construction":[199],"tasks.":[200],"According":[201],"Dunn":[203],"Grabski":[205],"(2002,":[206],"168),":[207],"prior":[508],"research":[209,228,251,386,415,543],"examined":[212],"these":[213,233,467],"factors":[214,234,380],"or":[215,285],"interactions":[217],"systematic":[220],"way,":[221],"relatively":[226],"new":[227,576],"field.":[229],"They":[230],"propose":[231],"that":[232,398,444,537],"studied":[236],"further":[237],"learn":[239],"about":[241],"combined":[243],"effects":[244,371],"writing":[247,455],"performance.":[248,384],"Past":[249],"empirical":[250],"retrieval":[254,476,565],"typically":[255,391],"compares":[256,286],"one":[257,287,319],"another,":[261],"while":[262,449],"keeping":[263],"constant":[266],"(Lochovsky":[267],"Tsichritzis,":[269],"1977;":[270,307],"Jih":[271],"et":[272,278,299,303,332,348,411,435,458,462],"al.,":[273,279,300,304,333,412,436,459,463],"1989;":[274,460],"Davis,":[275],"1990;":[276],"Chan":[277,347,461],"1993;":[280],"Leitheiser":[281],"1996),":[284],"against":[290],"another":[291],"without":[292],"regard":[293],"(Reisner":[298,410],"1975;":[301],"Chamberlin":[302],"1976;":[305],"Zloof,":[306],"Greenblatt":[308],"Waxman,":[310],"1978;":[311],"Reisner,":[312],"1981;":[313],"Yen":[314],"Scamell,":[316],"1993).":[317,334,464],"Only":[318],"study":[320,337,363,480,520,536,546],"manipulated":[321,445],"both":[322,339,482],"(Chan":[331],"current":[336,362],"manipulates":[338],"al.":[349],"(1993),":[350],"however,":[351],"did":[352],"investigate":[354],"interaction":[356,376],"between":[357],"two":[359],"factors.":[360],"solves":[364],"problem":[366],"by":[367],"analyzing":[368],"main":[370],"well":[373],"different":[379],"affecting":[381],"Prior":[385,414],"languages,":[389],"which":[390],"holds":[392],"constant,":[396],"suggests":[397],"graphical":[400,424],"easier":[403],"use,":[405],"but":[406],"only":[407],"nonprogrammers":[409],"1975).":[413],"models":[418],"indicates":[419],"overwhelming":[420],"superiority":[421],"version":[425],"designing":[432],"(Batra":[434],"1990).":[437],"Results":[438],"inconsistent":[440],"those":[442],"studies":[443,468],"investigating":[450],"(Jih":[457],"None":[465],"examines":[469],"QBE":[473,485],"technique.":[477],"Therefore,":[478,518],"includes":[481],"SQL":[483],"languages.":[488],"Accountants,":[489],"managers":[492],"variety":[495],"tools,":[498],"depending":[499],"management":[503],"system.":[504],"addition,":[506],"all":[507],"experiments":[509],"except":[510],"Amer":[511],"(1993)":[512],"used":[513],"students":[515,525],"participants.":[517],"uses":[521],"MIS":[524],"proxies":[527],"DBMS":[530],"end-users.":[531],"first":[535],"incorporates":[538],"characteristics":[540,558],"investigates":[547],"influence":[549],"representation,":[553],"language,":[555],"task":[557],"process.":[566],"Organizations":[567],"often":[568],"implement":[569],"formal":[570],"training":[571],"programs":[572],"teach":[574],"hires":[577],"experienced":[579],"employees":[580],"skills":[582],"they":[583],"will":[584],"need,":[585],"including":[586],"ability":[588],"efficiently":[590],"effectively":[592],"database.":[595],"\u2026":[596]},"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}