{"id":"https://openalex.org/W2973379277","doi":"https://doi.org/10.4018/jdwm.2009070103","title":"A Survey of Open Source Tools for Business Intelligence","display_name":"A Survey of Open Source Tools for Business Intelligence","publication_year":2009,"publication_date":"2009-07-01","ids":{"openalex":"https://openalex.org/W2973379277","doi":"https://doi.org/10.4018/jdwm.2009070103","mag":"2973379277"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2009070103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2009070103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","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/A5010748912","display_name":"Christian Thomsen","orcid":"https://orcid.org/0000-0002-0862-0509"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Christian Thomsen","raw_affiliation_strings":["Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":null,"display_name":"Torben Bach Pedersen","orcid":null},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Torben Bach Pedersen","raw_affiliation_strings":["Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I891191580"],"apc_list":null,"apc_paid":null,"fwci":10.0628,"has_fulltext":false,"cited_by_count":53,"citation_normalized_percentile":{"value":0.98062539,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"5","issue":"3","first_page":"56","last_page":"75"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9975000023841858,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9975000023841858,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9435999989509583,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9391999840736389,"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-analytical-processing","display_name":"Online analytical processing","score":0.9056581258773804},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8706663250923157},{"id":"https://openalex.org/keywords/open-source","display_name":"Open source","score":0.7163081169128418},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.695775032043457},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.5311409831047058},{"id":"https://openalex.org/keywords/open-source-software","display_name":"Open source software","score":0.5207697749137878},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.5148700475692749},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48921751976013184},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.396518349647522},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.3900160789489746},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3526037931442261},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3495190739631653},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1244255006313324}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9056581258773804},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8706663250923157},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.7163081169128418},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.695775032043457},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5311409831047058},{"id":"https://openalex.org/C2988343187","wikidata":"https://www.wikidata.org/wiki/Q1130645","display_name":"Open source software","level":3,"score":0.5207697749137878},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.5148700475692749},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48921751976013184},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.396518349647522},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.3900160789489746},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3526037931442261},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3495190739631653},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1244255006313324}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.4018/jdwm.2009070103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2009070103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:5:y:2009:i:3:p:56-75","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2009070103","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:pure.atira.dk:publications/793788e0-774e-11dd-8b88-000ea68e967b","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/793788e0-774e-11dd-8b88-000ea68e967b","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Thomsen, C & Pedersen, T B 2009, 'A Survey of Open Source Tools for Business Intelligence', International Journal of Data Warehousing and Mining, vol. 5, no. 3, pp. 56-75. https://doi.org/10.4018/jdwm.2009070103","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6000000238418579,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W208715492","https://openalex.org/W23190051"],"abstract_inverted_index":{"The":[0],"industrial":[1],"use":[2],"of":[3,24,29,53,56,69,113],"open":[4,38,57],"source":[5,39,58],"Business":[6],"Intelligence":[7],"(BI)":[8],"tools":[9,59,101],"is":[10,15,27],"becoming":[11],"more":[12],"common,":[13],"but":[14],"still":[16,109],"not":[17],"as":[18,20],"widespread":[19],"for":[21,37,60],"other":[22],"types":[23],"software.":[25],"It":[26],"therefore":[28],"interest":[30],"to":[31],"explore":[32],"which":[33],"possibilities":[34],"are":[35],"available":[36],"BI":[40],"and":[41,82,99],"compare":[42],"the":[43,51,63,89,107],"tools.":[44,118],"In":[45,62],"this":[46],"survey":[47],"article,":[48,64],"we":[49,65],"consider":[50,66],"capabilities":[52],"a":[54,67,91],"number":[55,68],"BI.":[61],"Extract-Transform-Load":[70],"(ETL)":[71],"tools,":[72],"database":[73],"management":[74],"systems":[75],"(DBMSs),":[76],"On-Line":[77],"Analytical":[78],"Processing":[79],"(OLAP)":[80],"servers,":[81],"OLAP":[83],"clients.":[84],"We":[85],"find":[86],"that,":[87],"unlike":[88],"situation":[90],"few":[92],"years":[93],"ago,":[94],"there":[95],"now":[96],"exist":[97],"mature":[98],"powerful":[100],"in":[102,116],"all":[103],"these":[104],"categories.":[105],"However,":[106],"functionality":[108],"falls":[110],"somewhat":[111],"short":[112],"that":[114],"found":[115],"commercial":[117]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":7},{"year":2012,"cited_by_count":11}],"updated_date":"2026-06-11T06:19:23.411458","created_date":"2025-10-10T00:00:00"}