{"id":"https://openalex.org/W1983345534","doi":"https://doi.org/10.5539/cis.v2n4p116","title":"Analysis and Design of ETL in Hospital Performance Appraisal System","display_name":"Analysis and Design of ETL in Hospital Performance Appraisal System","publication_year":2009,"publication_date":"2009-10-19","ids":{"openalex":"https://openalex.org/W1983345534","doi":"https://doi.org/10.5539/cis.v2n4p116","mag":"1983345534"},"language":"en","primary_location":{"id":"doi:10.5539/cis.v2n4p116","is_oa":true,"landing_page_url":"https://doi.org/10.5539/cis.v2n4p116","pdf_url":"https://ccsenet.org/journal/index.php/cis/article/download/4276/3723","source":{"id":"https://openalex.org/S2764452479","display_name":"Computer and Information Science","issn_l":"1913-8989","issn":["1913-8989","1913-8997"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322531","host_organization_name":"Canadian Center of Science and Education","host_organization_lineage":["https://openalex.org/P4310322531"],"host_organization_lineage_names":["Canadian Center of Science and Education"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer and Information Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ccsenet.org/journal/index.php/cis/article/download/4276/3723","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5057406899","display_name":"Fengjuan Yang","orcid":"https://orcid.org/0000-0002-5478-6139"},"institutions":[{"id":"https://openalex.org/I83791580","display_name":"Fujian University of Technology","ror":"https://ror.org/03c8fdb16","country_code":"CN","type":"education","lineage":["https://openalex.org/I83791580"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Fengjuan Yang","raw_affiliation_strings":["Department of Computer and Information Science, Fujian University of Technology Fuzhou 350100, China","Department of Computer and Information Science, Fujian University of Technology"],"affiliations":[{"raw_affiliation_string":"Department of Computer and Information Science, Fujian University of Technology Fuzhou 350100, China","institution_ids":["https://openalex.org/I83791580"]},{"raw_affiliation_string":"Department of Computer and Information Science, Fujian University of Technology","institution_ids":["https://openalex.org/I83791580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5057406899"],"corresponding_institution_ids":["https://openalex.org/I83791580"],"apc_list":null,"apc_paid":null,"fwci":2.6615,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.89964158,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"2","issue":"4","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13690","display_name":"Quality and Safety in Healthcare","score":0.5353000164031982,"subfield":{"id":"https://openalex.org/subfields/3607","display_name":"Medical Laboratory Technology"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},"topics":[{"id":"https://openalex.org/T13690","display_name":"Quality and Safety in Healthcare","score":0.5353000164031982,"subfield":{"id":"https://openalex.org/subfields/3607","display_name":"Medical Laboratory Technology"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8734818696975708},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.6402111053466797},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.554374098777771},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5119057893753052},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.5009593963623047},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.480214923620224},{"id":"https://openalex.org/keywords/performance-appraisal","display_name":"Performance appraisal","score":0.4519398808479309},{"id":"https://openalex.org/keywords/mechanism","display_name":"Mechanism (biology)","score":0.4490080177783966},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.4368381202220917},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36675673723220825},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09511071443557739},{"id":"https://openalex.org/keywords/medline","display_name":"MEDLINE","score":0.07896491885185242},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.060042887926101685}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8734818696975708},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6402111053466797},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.554374098777771},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5119057893753052},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.5009593963623047},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.480214923620224},{"id":"https://openalex.org/C2777873905","wikidata":"https://www.wikidata.org/wiki/Q1430184","display_name":"Performance appraisal","level":2,"score":0.4519398808479309},{"id":"https://openalex.org/C89611455","wikidata":"https://www.wikidata.org/wiki/Q6804646","display_name":"Mechanism (biology)","level":2,"score":0.4490080177783966},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.4368381202220917},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36675673723220825},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09511071443557739},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.07896491885185242},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.060042887926101685},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5539/cis.v2n4p116","is_oa":true,"landing_page_url":"https://doi.org/10.5539/cis.v2n4p116","pdf_url":"https://ccsenet.org/journal/index.php/cis/article/download/4276/3723","source":{"id":"https://openalex.org/S2764452479","display_name":"Computer and Information Science","issn_l":"1913-8989","issn":["1913-8989","1913-8997"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322531","host_organization_name":"Canadian Center of Science and Education","host_organization_lineage":["https://openalex.org/P4310322531"],"host_organization_lineage_names":["Canadian Center of Science and Education"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer and Information Science","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.668.6990","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.668.6990","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.ccsenet.org/journal/index.php/cis/article/download/4276/3723?origin%3Dpublication_detail","raw_type":"text"}],"best_oa_location":{"id":"doi:10.5539/cis.v2n4p116","is_oa":true,"landing_page_url":"https://doi.org/10.5539/cis.v2n4p116","pdf_url":"https://ccsenet.org/journal/index.php/cis/article/download/4276/3723","source":{"id":"https://openalex.org/S2764452479","display_name":"Computer and Information Science","issn_l":"1913-8989","issn":["1913-8989","1913-8997"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322531","host_organization_name":"Canadian Center of Science and Education","host_organization_lineage":["https://openalex.org/P4310322531"],"host_organization_lineage_names":["Canadian Center of Science and Education"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer and Information Science","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.4699999988079071}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1983345534.pdf","grobid_xml":"https://content.openalex.org/works/W1983345534.grobid-xml"},"referenced_works_count":1,"referenced_works":["https://openalex.org/W2353604048"],"related_works":["https://openalex.org/W2382997850","https://openalex.org/W2390968135","https://openalex.org/W2382213751","https://openalex.org/W2351750670","https://openalex.org/W1597848696","https://openalex.org/W2354715126","https://openalex.org/W2388563748","https://openalex.org/W2375179084","https://openalex.org/W2366646518","https://openalex.org/W2370906336"],"abstract_inverted_index":{"Taking":[0],"the":[1,7,9,31,40,44,47,56,62],"hospital":[2],"performance":[3],"appraisal":[4],"items":[5],"as":[6],"background,":[8],"method":[10],"and":[11,22,28,46,49],"mechanism":[12,51],"of":[13,43,64],"ETL":[14,41,65],"process,":[15],"data":[16,18,20,34],"extraction,":[17],"cleaning,":[19],"transformation":[21],"increment":[23],"updating":[24],"are":[25],"concretely":[26],"analyzed":[27],"designed":[29],"in":[30,39,55],"article.":[32],"The":[33],"preparation":[35],"area":[36],"is":[37,52],"added":[38],"process":[42],"system,":[45,57],"monitoring":[48],"restarting":[50],"set":[53],"up":[54],"which":[58],"can":[59],"effectively":[60],"enhance":[61],"efficiency":[63],"process.":[66]},"counts_by_year":[{"year":2013,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}