{"id":"https://openalex.org/W3204565838","doi":"https://doi.org/10.31004/edukatif.v3i6.1477","title":"Analisis dan Perancangan Database Menggunakan Model Konseptual Data Warehouse Sistem Manajemen Transaksi Toko Online Haransaf","display_name":"Analisis dan Perancangan Database Menggunakan Model Konseptual Data Warehouse Sistem Manajemen Transaksi Toko Online Haransaf","publication_year":2021,"publication_date":"2021-09-29","ids":{"openalex":"https://openalex.org/W3204565838","doi":"https://doi.org/10.31004/edukatif.v3i6.1477","mag":"3204565838"},"language":"id","primary_location":{"id":"doi:10.31004/edukatif.v3i6.1477","doi":"https://doi.org/10.31004/edukatif.v3i6.1477","is_oa":true,"landing_page_url":"https://doi.org/10.31004/edukatif.v3i6.1477","pdf_url":"https://edukatif.org/index.php/edukatif/article/download/1477/pdf","source":{"id":"https://openalex.org/S4210191986","display_name":"EDUKATIF JURNAL ILMU PENDIDIKAN","issn_l":"2656-8063","issn":["2656-8063","2656-8071"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310315283","host_organization_name":"Universitas Pahlawan Tuanku Tambusai","host_organization_lineage":["https://openalex.org/P4310315283"],"host_organization_lineage_names":["Universitas Pahlawan Tuanku Tambusai"],"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":"EDUKATIF : JURNAL ILMU PENDIDIKAN","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://edukatif.org/index.php/edukatif/article/download/1477/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5052245066","display_name":"Yose Indarta","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I245308123","display_name":"Universitas Negeri Padang","ror":"https://ror.org/04jrfgq66","country_code":"ID","type":"education","lineage":["https://openalex.org/I245308123"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Yose Indarta","raw_affiliation_strings":["Universitas Negeri Padang, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Negeri Padang, Indonesia","institution_ids":["https://openalex.org/I245308123"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019676608","display_name":"Dedy Irfan","orcid":"https://orcid.org/0000-0002-8441-1178","observed_orcids":["https://orcid.org/0000-0002-8441-1178"]},"institutions":[{"id":"https://openalex.org/I245308123","display_name":"Universitas Negeri Padang","ror":"https://ror.org/04jrfgq66","country_code":"ID","type":"education","lineage":["https://openalex.org/I245308123"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Dedy Irfan","raw_affiliation_strings":["Universitas Negeri Padang, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Negeri Padang, Indonesia","institution_ids":["https://openalex.org/I245308123"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041813273","display_name":"Mukhlidi Muksir","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I245308123","display_name":"Universitas Negeri Padang","ror":"https://ror.org/04jrfgq66","country_code":"ID","type":"education","lineage":["https://openalex.org/I245308123"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Mukhlidi Muksir","raw_affiliation_strings":["Universitas Negeri Padang, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Negeri Padang, Indonesia","institution_ids":["https://openalex.org/I245308123"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083480190","display_name":"Wakhinuddin Simatupang","orcid":"https://orcid.org/0009-0005-3617-9596","observed_orcids":["https://orcid.org/0009-0005-3617-9596"]},"institutions":[{"id":"https://openalex.org/I245308123","display_name":"Universitas Negeri Padang","ror":"https://ror.org/04jrfgq66","country_code":"ID","type":"education","lineage":["https://openalex.org/I245308123"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Wakhinuddin Simatupang","raw_affiliation_strings":["Universitas Negeri Padang, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Negeri Padang, Indonesia","institution_ids":["https://openalex.org/I245308123"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5055381854","display_name":"Fadhli Ranuharja","orcid":"https://orcid.org/0000-0001-7160-124X","observed_orcids":["https://orcid.org/0000-0001-7160-124X"]},"institutions":[{"id":"https://openalex.org/I245308123","display_name":"Universitas Negeri Padang","ror":"https://ror.org/04jrfgq66","country_code":"ID","type":"education","lineage":["https://openalex.org/I245308123"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Fadhli Ranuharja","raw_affiliation_strings":["Universitas Negeri Padang, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Negeri Padang, Indonesia","institution_ids":["https://openalex.org/I245308123"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I245308123"],"apc_list":null,"apc_paid":null,"fwci":5.0726,"has_fulltext":true,"cited_by_count":32,"citation_normalized_percentile":{"value":0.95452199,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":99},"biblio":{"volume":"3","issue":"6","first_page":"4448","last_page":"4455"},"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.9092000126838684,"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.9092000126838684,"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/T11734","display_name":"Decision Support System Applications","score":0.062300000339746475,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.01269999984651804,"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/data-warehouse","display_name":"data warehouse","score":0.7179999947547913},{"id":"https://openalex.org/keywords/conceptual-data-model","display_name":"conceptual data model","score":0.7929999828338623},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.9879999756813049},{"id":"https://openalex.org/keywords/online-store","display_name":"online store","score":0.640999972820282},{"id":"https://openalex.org/keywords/transaction-management","display_name":"transaction management","score":0.7419999837875366},{"id":"https://openalex.org/keywords/inventory-management","display_name":"inventory management","score":0.7540000081062317},{"id":"https://openalex.org/keywords/women-s-clothing-retail","display_name":"women's clothing retail","score":0.7549999952316284},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.5989999771118164},{"id":"https://openalex.org/keywords/decision-support","display_name":"decision support","score":0.6290000081062317}],"concepts":[{"id":"https://openalex.org/C15708023","wikidata":"https://www.wikidata.org/wiki/Q80083","display_name":"Humanities","level":1,"score":0.44513189792633057},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4202682375907898},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38841116428375244},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.15334349870681763}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.31004/edukatif.v3i6.1477","doi":"https://doi.org/10.31004/edukatif.v3i6.1477","is_oa":true,"landing_page_url":"https://doi.org/10.31004/edukatif.v3i6.1477","pdf_url":"https://edukatif.org/index.php/edukatif/article/download/1477/pdf","source":{"id":"https://openalex.org/S4210191986","display_name":"EDUKATIF JURNAL ILMU PENDIDIKAN","issn_l":"2656-8063","issn":["2656-8063","2656-8071"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310315283","host_organization_name":"Universitas Pahlawan Tuanku Tambusai","host_organization_lineage":["https://openalex.org/P4310315283"],"host_organization_lineage_names":["Universitas Pahlawan Tuanku Tambusai"],"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":"EDUKATIF : JURNAL ILMU PENDIDIKAN","raw_type":"journal-article"},{"id":"pmh:oai:edukatif.org:article/1477","doi":null,"is_oa":true,"landing_page_url":"https://edukatif.org/edukatif/article/view/1477","pdf_url":"https://edukatif.org/edukatif/article/download/1477/pdf","source":{"id":"https://openalex.org/S4210191986","display_name":"EDUKATIF JURNAL ILMU PENDIDIKAN","issn_l":"2656-8063","issn":["2656-8063","2656-8071"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310315283","host_organization_name":"Universitas Pahlawan Tuanku Tambusai","host_organization_lineage":["https://openalex.org/P4310315283"],"host_organization_lineage_names":["Universitas Pahlawan Tuanku Tambusai"],"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":"10.31004/edukatif.v3i6","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.31004/edukatif.v3i6.1477","doi":"https://doi.org/10.31004/edukatif.v3i6.1477","is_oa":true,"landing_page_url":"https://doi.org/10.31004/edukatif.v3i6.1477","pdf_url":"https://edukatif.org/index.php/edukatif/article/download/1477/pdf","source":{"id":"https://openalex.org/S4210191986","display_name":"EDUKATIF JURNAL ILMU PENDIDIKAN","issn_l":"2656-8063","issn":["2656-8063","2656-8071"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310315283","host_organization_name":"Universitas Pahlawan Tuanku Tambusai","host_organization_lineage":["https://openalex.org/P4310315283"],"host_organization_lineage_names":["Universitas Pahlawan Tuanku Tambusai"],"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":"EDUKATIF : JURNAL ILMU PENDIDIKAN","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3204565838.pdf","grobid_xml":"https://content.openalex.org/works/W3204565838.grobid-xml"},"referenced_works_count":14,"referenced_works":["https://openalex.org/W1485562399","https://openalex.org/W1637139609","https://openalex.org/W2257479000","https://openalex.org/W2727265985","https://openalex.org/W2909334415","https://openalex.org/W2937922288","https://openalex.org/W2978502740","https://openalex.org/W3020110144","https://openalex.org/W3081516365","https://openalex.org/W3128960745","https://openalex.org/W3135754036","https://openalex.org/W3164512394","https://openalex.org/W3187108446","https://openalex.org/W3193867046"],"related_works":["https://openalex.org/W314860621","https://openalex.org/W90026896","https://openalex.org/W4220847787","https://openalex.org/W348004126","https://openalex.org/W87326089","https://openalex.org/W95495617","https://openalex.org/W7215428428","https://openalex.org/W235226457","https://openalex.org/W336227066","https://openalex.org/W1735094045"],"abstract_inverted_index":{"Penelitian":[0],"ini":[1,21,96,124],"bertujuan":[2],"untuk":[3,141],"merancang":[4],"dan":[5,46,52,88,118,150,160,174],"menganalisis":[6],"kebutuhan":[7,18],"basis":[8,19,100,166],"data":[9,15,20,65,101,128,167,171],"toko":[10,25,37,84,95,109,182],"online":[11],"Haransaf":[12,85],"menggunakan":[13,125],"konseptual":[14,127],"warehouse.":[16],"Analisis":[17],"mengambil":[22],"subjek":[23],"penelitian":[24],"haransaf":[26],"yang":[27,56,67,77,81,130,136,172],"bergerak":[28],"di":[29,83],"penjualan":[30,48,89,161],"barang":[31,43],"berupa":[32],"baju":[33],"khusus":[34,140],"wanita.":[35],"Owner":[36],"dalam":[38,41,113,162,183],"wawancara":[39],"kesulitan":[40],"pembukuan":[42,47,55],"pembelian":[44,87,159],"stock":[45],"barang.":[49,90],"Buku":[50],"catatan":[51],"file":[53,60],"excel":[54],"sering":[57],"tercampur":[58],"dengan":[59],"lain":[61],"sehingga":[62,176],"sulit":[63],"mencari":[64,114],"transaksi":[66,80],"telah":[68],"berlalu,":[69],"oleh":[70],"karna":[71],"itu":[72],"dibutuhkanlah":[73],"sebuah":[74],"sistem":[75,93],"pengelolaan":[76],"dapat":[78,110,169],"medata":[79],"ada":[82],"mengenai":[86],"Langkah":[91],"perancangan":[92,99,122],"manajemen":[94,103],"melalui":[97],"analisis":[98],"Melalui":[102],"sitem":[104],"tersebut":[105],"pengguna":[106],"khususnya":[107],"owner":[108],"memperoleh":[111],"kemudahan":[112],"informasi,":[115],"menyimpan":[116],"informasi":[117],"membuang":[119],"informasi.":[120],"Dalam":[121],"database":[123],"model":[126],"warehouse":[129,168],"menghasilkan":[131],"star":[132,158],"schema.":[133],"atribut":[134],"tabel":[135],"didapat":[137],"diperlukan":[138],"pengkodean":[139],"id":[142,144,146,148,151],"owner,":[143],"karyawan,":[145],"produk,":[147],"costumer":[149],"supplier":[152],"serta":[153],"terdapat":[154],"perbedaan":[155],"antara":[156],"skema":[157],"hasil":[163],"analisis.":[164],"Perancangan":[165],"dihasilkan":[170],"terstruktur":[173],"terintegrasi":[175],"bisa":[177],"menjadi":[178],"masukan":[179],"bagi":[180],"pemilik":[181],"proses":[184],"pengambilan":[185],"keputusan":[186]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":13},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":6}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2021-10-11T00:00:00"}