{"id":"https://openalex.org/W2741960012","doi":null,"title":"A DATA WAREHOUSE SOLUTION FOR E-GOVERNMENT","display_name":"A DATA WAREHOUSE SOLUTION FOR E-GOVERNMENT","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2741960012","mag":"2741960012"},"language":"en","primary_location":{"id":"mag:2741960012","doi":null,"is_oa":false,"landing_page_url":"http://orbit.dtu.dk/files/110626016/IJRRAS_4_1_12.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Research","raw_type":null},"volume":null,"type":"article","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/A5100735899","display_name":"Xiufeng Liu","orcid":"https://orcid.org/0000-0001-5133-6688","observed_orcids":["https://orcid.org/0000-0001-5133-6688"]},"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":"Xiufeng Liu","raw_affiliation_strings":["Aalborg university"],"raw_orcid":"https://orcid.org/0000-0001-5133-6688","affiliations":[{"raw_affiliation_string":"Aalborg university","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100547486","display_name":"Xiaofeng Luo","orcid":"https://orcid.org/0000-0002-4919-303X","observed_orcids":["https://orcid.org/0000-0002-4919-303X"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiaofeng Luo","raw_affiliation_strings":["Anhui Telecommunications Engineering Co.,Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Anhui Telecommunications Engineering Co.,Ltd","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2683,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.86957254,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"4","issue":"1","first_page":"101","last_page":"105"},"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.9330999851226807,"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.9330999851226807,"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/T10953","display_name":"E-Government and Public Services","score":0.06270000338554382,"subfield":{"id":"https://openalex.org/subfields/3320","display_name":"Political Science and International Relations"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.0005000000237487257,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.8939999938011169},{"id":"https://openalex.org/keywords/e-government","display_name":"e-government","score":0.9350000023841858},{"id":"https://openalex.org/keywords/etl","display_name":"ETL","score":0.7630000114440918},{"id":"https://openalex.org/keywords/data-warehouse-architecture","display_name":"data warehouse architecture","score":0.8209999799728394},{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":0.7570000290870667},{"id":"https://openalex.org/keywords/etl-tools","display_name":"ETL tools","score":0.460999995470047},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.5429999828338623},{"id":"https://openalex.org/keywords/decision-support","display_name":"decision support","score":0.5789999961853027}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8593687415122986},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.8038036823272705},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6249122619628906},{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.5395421981811523},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.45825472474098206},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.4168439507484436},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.41130346059799194},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3902536630630493},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3853321969509125},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.36694657802581787},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3570377826690674},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.2302015721797943},{"id":"https://openalex.org/C2780378061","wikidata":"https://www.wikidata.org/wiki/Q25351891","display_name":"Service (business)","level":2,"score":0.15837371349334717},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.12706288695335388},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.12331366539001465},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2741960012","doi":null,"is_oa":false,"landing_page_url":"http://orbit.dtu.dk/files/110626016/IJRRAS_4_1_12.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Research","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.4943999946117401,"id":"https://metadata.un.org/sdg/9"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1557907964","https://openalex.org/W1962086758","https://openalex.org/W2107760270","https://openalex.org/W2158275487","https://openalex.org/W2973379277","https://openalex.org/W3216315150"],"related_works":["https://openalex.org/W2186083098","https://openalex.org/W2382516379","https://openalex.org/W2021379762","https://openalex.org/W54385926","https://openalex.org/W2947219462","https://openalex.org/W20174836","https://openalex.org/W2380731451","https://openalex.org/W2368227388","https://openalex.org/W2753650998","https://openalex.org/W2027582417"],"abstract_inverted_index":{"ABSTRACT":[0],"The":[1,79,113,202,407,475,537],"eGovMon":[2,534],"Data":[3,72,160],"Warehouse":[4,161],"(eGovMon":[5],"DW)":[6],"is":[7,85,118,171,236,303,411,417,445,527,543],"built":[8],"as":[9,36,42,87,173,280,283,448],"a":[174],"data":[11,44,102,104,196,223,229,531,541],"repository":[178],"for":[13,29,66,185,221,529],"eGovernment":[14,39,548],"services":[15,214,549],"benchmarking":[16,547],"results.":[17],"We":[18,493],"propose":[19],"DW":[21,32,75],"architecture":[22,33,76],"with":[23,293],"open":[24,309,325,379,413,441,482,522],"source":[25,165,310,326,380,414,442,483,523],"business":[26,142,169,205,234,243,250,271,277,300,317,371,415,443,472,524],"intelligence":[27,143,206,235,244,251,272,278,301,318,372,416,444,473,525],"technologies":[28,203,254],"eGovernment.":[30],"This":[31,352],"uses":[34],"PostgreSQL":[35],"the":[37,43,53,60,88,121,126,129,134,147,163,195,222,233,239,247,294,297,357,361,365,370,399,405,420,438,456,470,481,489,498,530,546],"DBMS,":[38],"operational":[40],"system":[41,144],"source,":[45],"and":[46,64,91,97,106,123,155,166,192,215,225,253,312,373,396,402,454,506,512],"right-time":[48],"ETL":[49],"tool":[50],"to":[51,119,128,145,188,257,314,356,392,398,433,464,469,544],"populate":[52],"data.":[54,201],"Through":[55],"this":[56,502,515,519,540],"proposal,":[57],"we":[58],"give":[59,268],"potential":[61],"research":[62,510],"interests":[63,511],"issues":[65],"our":[67],"future":[68],"work.":[69],"Keywords:":[70],"eGovMon,":[71],"Warehouse,":[73],"ETL,":[74],"1.":[77],"INTRODUCTION":[78],"term":[80],"of":[81,101,115,125,168,198,204,210,242,299,324,335,404,423,440,533,539],"Business":[82,286],"Intelligence":[83],"(BI)":[84],"defined":[86,172],"technologies,":[89],"applications":[90],"practices":[92],"that":[93,218,412,427,496],"collect,":[94],"integrate,":[95],"analyze":[96],"present":[98],"large":[99],"amounts":[100],"from":[103,110,227],"warehouse":[105,532,542],"extract":[107],"useful":[108,220],"knowledge":[109],"it":[111,428,463],"[4].":[112],"objective":[114],"using":[116],"BI":[117,264,350],"improve":[120],"timeliness":[122],"quality":[124],"input":[127],"decision":[130,193],"process.":[131],"For":[132],"example,":[133],"world's":[135],"largest":[136],"retailer":[137],"-":[138],"Wal-Mart":[139],"use":[140,241,298,386],"their":[141,258,269,276],"attain":[146],"products":[148],"in":[149,291,308,331,340,342,347,477,486,497,514,551],"stock,":[150],"predict":[151],"retail":[152],"marketing":[153,157],"trends":[154],"make":[156,189,462],"decisions.":[158],"A":[159],"(DW),":[162],"information":[164,213],"basic":[167],"intelligence,":[170],"subject-oriented,":[175],"non-volatile,":[176],"time-variant":[177],"[2].":[179],"It":[180],"provides":[181],"single":[183],"platform":[184],"an":[186,321,521],"enterprise":[187],"plan":[191],"on":[194,458],"analysis":[197,226],"integrated":[199],"history":[200],"encompass":[207],"series":[209],"tools,":[211],"architectures,":[212],"communication":[216],"infrastructures":[217],"are":[219,337,485],"integration":[224],"heterogeneous":[228],"sources.":[230],"Much":[231],"often":[232],"characterized":[237],"by":[238,369],"widely":[240],"tools.":[245],"In":[246,518],"commercial":[248,295,362],"world,":[249,296],"tools":[252,273,302,327,363,381,484],"have":[255,328],"come":[256],"maturity":[259],"after":[260],"years'":[261],"development.":[262],"Many":[263],"vendors":[265],"not":[266,305,313],"only":[267],"own":[270],"but":[274],"provide":[275],"solutions":[279],"well,":[281],"such":[282,447],"IBM,":[284],"SAP,":[285],"Objects,":[287],"Cognos":[288],"etc.":[289],"However,":[290],"contrast":[292],"still":[304,338,418,429],"very":[306],"common":[307],"area,":[311],"mention":[315],"complete":[316],"solutions.":[319,474],"Although":[320],"increasing":[322],"number":[323],"been":[329],"developed":[330],"recent":[332],"years,":[333],"most":[334],"them":[336],"used":[339],"stand-alone":[341],"software":[343,459],"development,":[344],"other":[345],"than":[346],"full":[349,366],"solution.":[351],"might":[353,390],"be":[354,383,393,465],"due":[355],"reasons":[358],"that,":[359],"unlike":[360],"having":[364],"features":[367],"required":[368],"providing":[374],"good":[375],"technical":[376],"support,":[377],"many":[378],"cannot":[382],"put":[384],"into":[385,435],"immediately,":[387],"instead,":[388],"they":[389],"need":[391,430],"intimately":[394],"tailored":[395],"customized":[397],"distinctive":[400],"needs":[401],"requirements":[403],"business.":[406],"main":[408],"reason,":[409],"however,":[410],"at":[419],"beginning":[421],"phase":[422],"its":[424,449],"development":[425],"so":[426],"several":[431],"years":[432,501],"grow":[434],"maturity.":[436],"Nevertheless,":[437],"benefit":[439],"obvious,":[446],"low-cost,":[450],"manageable":[451],"size,":[452],"flexibility":[453],"reducing":[455],"dependence":[457],"vendors,":[460],"which":[461],"valuable":[467],"alternative":[468],"traditional":[471],"investigation":[476],"section":[478],"2.1":[479],"evidences":[480],"bloom":[487],"over":[488],"past":[490],"few":[491,500],"years.":[492],"can":[494],"expect":[495],"next":[499],"trend":[503],"will":[504,507],"continue":[505],"concentrate":[508],"more":[509],"efforts":[513],"area":[516],"[3].":[517],"paper,":[520],"solution":[526],"proposed":[528],"project":[535],"[1].":[536],"construction":[538],"store":[545],"results":[550],"four":[552],"observatories:":[553]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2017-08-08T00:00:00"}