{"id":"https://openalex.org/W4400617850","doi":"https://doi.org/10.62527/joiv.7.4.1722","title":"Implementation of Big Data Information System Using Open-Source Metabase for Civil Registration and Vital Statistics Data Visualization in Surabaya","display_name":"Implementation of Big Data Information System Using Open-Source Metabase for Civil Registration and Vital Statistics Data Visualization in Surabaya","publication_year":2023,"publication_date":"2023-12-31","ids":{"openalex":"https://openalex.org/W4400617850","doi":"https://doi.org/10.62527/joiv.7.4.1722"},"language":"en","primary_location":{"id":"doi:10.62527/joiv.7.4.1722","doi":"https://doi.org/10.62527/joiv.7.4.1722","is_oa":true,"landing_page_url":"https://doi.org/10.62527/joiv.7.4.1722","pdf_url":null,"source":{"id":"https://openalex.org/S4210222436","display_name":"JOIV International Journal on Informatics Visualization","issn_l":"2549-9610","issn":["2549-9610","2549-9904"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj","norway-1","poland-20","russia-white-list-2"],"host_organization":"https://openalex.org/P4310315170","host_organization_name":"State Polytechnics of Andalas","host_organization_lineage":["https://openalex.org/P4310315170"],"host_organization_lineage_names":["State Polytechnics of Andalas"],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"JOIV : International Journal on Informatics Visualization","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://doi.org/10.62527/joiv.7.4.1722","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5050024175","display_name":"Rizqi Putri Nourma Budiarti","orcid":"https://orcid.org/0000-0003-1007-6888","observed_orcids":["https://orcid.org/0000-0003-1007-6888"]},"institutions":[{"id":"https://openalex.org/I4387155854","display_name":"Universitas Nahdlatul Ulama Surabaya","ror":"https://ror.org/00wbwde85","country_code":"ID","type":"education","lineage":["https://openalex.org/I4387155854"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Rizqi Putri Nourma Budiarti","raw_affiliation_strings":["Universitas Nahdlatul Ulama Surabaya, Surabaya, 60237, Indonesia"],"raw_orcid":"https://orcid.org/0000-0003-1007-6888","affiliations":[{"raw_affiliation_string":"Universitas Nahdlatul Ulama Surabaya, Surabaya, 60237, Indonesia","institution_ids":["https://openalex.org/I4387155854"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031078978","display_name":"Sritrusta Sukaridhoto","orcid":"https://orcid.org/0000-0002-8157-5863","observed_orcids":["https://orcid.org/0000-0002-8157-5863"]},"institutions":[{"id":"https://openalex.org/I4387153613","display_name":"Politeknik Elektronika Negeri Surabaya","ror":"https://ror.org/00cf3sf89","country_code":"ID","type":"education","lineage":["https://openalex.org/I4387153613"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Sritrusta Sukaridhoto","raw_affiliation_strings":["Politeknik Elektronika Negeri Surabaya, Surabaya, 60111, Indonesia"],"raw_orcid":"https://orcid.org/0000-0002-8157-5863","affiliations":[{"raw_affiliation_string":"Politeknik Elektronika Negeri Surabaya, Surabaya, 60111, Indonesia","institution_ids":["https://openalex.org/I4387153613"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044280525","display_name":"Ubaidillah Zuhdi","orcid":"https://orcid.org/0000-0002-0414-5720","observed_orcids":["https://orcid.org/0000-0002-0414-5720"]},"institutions":[{"id":"https://openalex.org/I4387155854","display_name":"Universitas Nahdlatul Ulama Surabaya","ror":"https://ror.org/00wbwde85","country_code":"ID","type":"education","lineage":["https://openalex.org/I4387155854"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Ubaidillah Zuhdi","raw_affiliation_strings":["Universitas Nahdlatul Ulama Surabaya, Surabaya, 60237, Indonesia"],"raw_orcid":"https://orcid.org/0000-0002-0414-5720","affiliations":[{"raw_affiliation_string":"Universitas Nahdlatul Ulama Surabaya, Surabaya, 60237, Indonesia","institution_ids":["https://openalex.org/I4387155854"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065132877","display_name":"Alfandino Rasyid","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4387153613","display_name":"Politeknik Elektronika Negeri Surabaya","ror":"https://ror.org/00cf3sf89","country_code":"ID","type":"education","lineage":["https://openalex.org/I4387153613"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Alfandino Rasyid","raw_affiliation_strings":["Politeknik Elektronika Negeri Surabaya, Surabaya, 60111, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politeknik Elektronika Negeri Surabaya, Surabaya, 60111, Indonesia","institution_ids":["https://openalex.org/I4387153613"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5029321215","display_name":"Agus Imam Sonhaji","orcid":"https://orcid.org/0009-0007-1599-1299","observed_orcids":["https://orcid.org/0009-0007-1599-1299"]},"institutions":[{"id":"https://openalex.org/I166843116","display_name":"Institut Teknologi Sepuluh Nopember","ror":"https://ror.org/05kbmmt89","country_code":"ID","type":"education","lineage":["https://openalex.org/I166843116"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Agus Imam Sonhaji","raw_affiliation_strings":["Institut Teknologi Sepuluh Nopember, Surabaya, 60111, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institut Teknologi Sepuluh Nopember, Surabaya, 60111, Indonesia","institution_ids":["https://openalex.org/I166843116"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.383,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.61681529,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"7","issue":"4","first_page":"2358","last_page":"2358"},"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.34200000762939453,"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.34200000762939453,"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/T10799","display_name":"Data Visualization and Analytics","score":0.2257000058889389,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/T14280","display_name":"Big Data Technologies and Applications","score":0.17499999701976776,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/civil-registration-and-vital-statistics","display_name":"civil registration and vital statistics","score":0.8870000243186951},{"id":"https://openalex.org/keywords/metabase","display_name":"Metabase","score":0.828000009059906},{"id":"https://openalex.org/keywords/data-visualization","display_name":"data visualization","score":0.75},{"id":"https://openalex.org/keywords/open-source-software","display_name":"open source software","score":0.8379999995231628},{"id":"https://openalex.org/keywords/pieces-framework","display_name":"PIECES framework","score":0.8659999966621399},{"id":"https://openalex.org/keywords/legal-identity","display_name":"legal identity","score":0.6539999842643738},{"id":"https://openalex.org/keywords/surabaya","display_name":"Surabaya","score":0.6499999761581421},{"id":"https://openalex.org/keywords/decision-support","display_name":"decision support","score":0.46000000834465027}],"concepts":[{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.6603965759277344},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.6263219118118286},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.57682204246521},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.5537524819374084},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4610971212387085},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4424172341823578},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.36918315291404724},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3606460690498352},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3245595693588257},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08484947681427002},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0652616024017334},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.62527/joiv.7.4.1722","doi":"https://doi.org/10.62527/joiv.7.4.1722","is_oa":true,"landing_page_url":"https://doi.org/10.62527/joiv.7.4.1722","pdf_url":null,"source":{"id":"https://openalex.org/S4210222436","display_name":"JOIV International Journal on Informatics Visualization","issn_l":"2549-9610","issn":["2549-9610","2549-9904"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj","norway-1","poland-20","russia-white-list-2"],"host_organization":"https://openalex.org/P4310315170","host_organization_name":"State Polytechnics of Andalas","host_organization_lineage":["https://openalex.org/P4310315170"],"host_organization_lineage_names":["State Polytechnics of Andalas"],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"JOIV : International Journal on Informatics Visualization","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:3ee01df20f8341d1b68ea22db57ccb49","doi":null,"is_oa":true,"landing_page_url":"https://doaj.org/article/3ee01df20f8341d1b68ea22db57ccb49","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","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":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"JOIV: International Journal on Informatics Visualization, Vol 7, Iss 4, Pp 2358-2365 (2023)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.62527/joiv.7.4.1722","doi":"https://doi.org/10.62527/joiv.7.4.1722","is_oa":true,"landing_page_url":"https://doi.org/10.62527/joiv.7.4.1722","pdf_url":null,"source":{"id":"https://openalex.org/S4210222436","display_name":"JOIV International Journal on Informatics Visualization","issn_l":"2549-9610","issn":["2549-9610","2549-9904"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj","norway-1","poland-20","russia-white-list-2"],"host_organization":"https://openalex.org/P4310315170","host_organization_name":"State Polytechnics of Andalas","host_organization_lineage":["https://openalex.org/P4310315170"],"host_organization_lineage_names":["State Polytechnics of Andalas"],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"JOIV : International Journal on Informatics Visualization","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/11","score":0.7250000238418579,"display_name":"Sustainable cities and communities"},{"id":"https://metadata.un.org/sdg/16","score":0.46149998903274536,"display_name":"Peace, justice, and strong institutions"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W988728913","https://openalex.org/W2764114022","https://openalex.org/W2929784530","https://openalex.org/W2943223003","https://openalex.org/W2945802133","https://openalex.org/W2946288943","https://openalex.org/W2965347228","https://openalex.org/W2965801387","https://openalex.org/W2969075722","https://openalex.org/W2975040524","https://openalex.org/W2980849143","https://openalex.org/W2986833599","https://openalex.org/W3033545933","https://openalex.org/W3094831681","https://openalex.org/W3110263021","https://openalex.org/W3119652897","https://openalex.org/W3137003701","https://openalex.org/W3165775786","https://openalex.org/W3185295579","https://openalex.org/W3194679995","https://openalex.org/W3196363777","https://openalex.org/W3201274265","https://openalex.org/W3206522480","https://openalex.org/W3212655254","https://openalex.org/W4200400033","https://openalex.org/W4205704075","https://openalex.org/W4205936169","https://openalex.org/W4213210220","https://openalex.org/W4289521812","https://openalex.org/W4291824880"],"related_works":["https://openalex.org/W4388554576","https://openalex.org/W3132774015","https://openalex.org/W7204618673","https://openalex.org/W4404497253","https://openalex.org/W7120349273","https://openalex.org/W6968550103","https://openalex.org/W2376824115","https://openalex.org/W2936561863","https://openalex.org/W4319350634","https://openalex.org/W2809976622"],"abstract_inverted_index":{"Civil":[0,50,95],"registration":[1,220],"involves":[2],"the":[3,108,117,129,134,142,147,173,199,215],"mandatory":[4],"and":[5,41,52,74,77,97,110,133,159,181,193,211],"continuous":[6],"documentation":[7],"of":[8,12,155,168,201],"important":[9],"life":[10],"events":[11,82],"a":[13,48,57,67,87,93,152,185,203,218],"country's":[14],"population":[15],"under":[16],"local":[17],"legal":[18,68],"requirements.":[19],"In":[20],"many":[21,104],"countries,":[22],"these":[23],"documents":[24],"are":[25],"required":[26],"to":[27,62,165],"access":[28,71],"government":[29,72],"services":[30],"such":[31],"as":[32,217],"education,":[33],"healthcare,":[34],"social":[35],"services,":[36,73],"formal":[37],"employment,":[38],"insurance":[39],"benefits,":[40],"inheritance":[42],"rights.":[43],"Indonesia":[44],"should":[45],"prioritize":[46],"building":[47],"comprehensive":[49,94],"Registration":[51,96],"Vital":[53,98],"Statistics":[54,99],"(CRVS)":[55,100],"using":[56],"big":[58],"data":[59,209],"information":[60],"system":[61],"ensure":[63],"every":[64],"individual":[65],"has":[66],"identity,":[69],"can":[70,162,178],"collect":[75],"accurate":[76],"reliable":[78],"statistics":[79],"on":[80,116],"vital":[81],"through":[83],"geospatial":[84],"maps.":[85],"Surabaya,":[86],"city":[88],"in":[89,113],"Indonesia,":[90],"still":[91],"needs":[92],"system.":[101],"We":[102],"produce":[103],"informative":[105],"visualizations":[106,167,177],"from":[107],"query":[109],"modeling":[111],"processes":[112],"Metabase.":[114],"Based":[115],"PIECES":[118],"framework,":[119],"this":[120],"application's":[121],"importance":[122,200],"level":[123,136],"is":[124,131,137,144],"4.56":[125],"or":[126,139],"91.25%,":[127],"meaning":[128,141],"application":[130,143],"important,":[132],"satisfaction":[135],"4.29":[138],"85.76%,":[140],"satisfied":[145],"for":[146,208,214],"respondents.":[148],"This":[149],"research":[150],"provides":[151],"brief":[153],"overview":[154],"how":[156,160],"Metabase":[157,207],"works":[158],"it":[161],"be":[163,179],"used":[164],"generate":[166],"job-type":[169],"data.":[170],"It":[171,183,196],"demonstrates":[172],"ease":[174],"with":[175],"which":[176],"changed":[180],"customized.":[182],"had":[184],"good":[186],"affordability":[187],"point,":[188],"making":[189],"its":[190],"implementation":[191],"easier":[192],"more":[194],"beneficial.":[195],"also":[197],"emphasizes":[198],"having":[202],"powerful":[204],"tool":[205],"like":[206],"analysis":[210],"decision-making,":[212],"especially":[213],"dispendukcapil":[216],"civil":[219],"agency.":[221]},"counts_by_year":[{"year":2026,"cited_by_count":2}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2024-07-15T00:00:00"}