{"id":"https://openalex.org/W2138195712","doi":"https://doi.org/10.1504/ijiids.2012.047003","title":"EMD: entity mapping diagram for automated extraction, transformation, and loading processes in data warehousing","display_name":"EMD: entity mapping diagram for automated extraction, transformation, and loading processes in data warehousing","publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W2138195712","doi":"https://doi.org/10.1504/ijiids.2012.047003","mag":"2138195712"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1504/ijiids.2012.047003","pdf_url":null,"source":{"id":"https://openalex.org/S27556001","display_name":"International Journal of Intelligent Information and Database Systems","issn_l":"1751-5858","issn":["1751-5858","1751-5866"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310317825","host_organization_name":"Inderscience Publishers","host_organization_lineage":["https://openalex.org/P4310317825"],"host_organization_lineage_names":["Inderscience Publishers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5058249834","display_name":"Abdeltawab Hendawi","orcid":"https://orcid.org/0000-0003-3385-3379"},"institutions":[{"id":"https://openalex.org/I89466785","display_name":"Minia University","ror":"https://ror.org/02hcv4z63","country_code":"EG","type":"education","lineage":["https://openalex.org/I89466785"]}],"countries":["EG"],"is_corresponding":false,"raw_author_name":"Abdeltawab M.A. Hendawi","raw_affiliation_strings":["Information Systems Department, Faculty of Computers and Information, Minia University, El-Minia, Egypt"],"affiliations":[{"raw_affiliation_string":"Information Systems Department, Faculty of Computers and Information, Minia University, El-Minia, Egypt","institution_ids":["https://openalex.org/I89466785"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5052265483","display_name":"Shaker El\u2013Sappagh","orcid":"https://orcid.org/0000-0001-9705-1477"},"institutions":[{"id":"https://openalex.org/I89466785","display_name":"Minia University","ror":"https://ror.org/02hcv4z63","country_code":"EG","type":"education","lineage":["https://openalex.org/I89466785"]}],"countries":["EG"],"is_corresponding":false,"raw_author_name":"Shaker H. Ali El Sappagh","raw_affiliation_strings":["Information Systems Department, Faculty of Computers and Information, Minia University, El-Minia, Egypt"],"affiliations":[{"raw_affiliation_string":"Information Systems Department, Faculty of Computers and Information, Minia University, El-Minia, Egypt","institution_ids":["https://openalex.org/I89466785"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.937,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":4,"citation_normalized_percentile":{"value":0.771018,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":78,"max":80},"biblio":{"volume":"6","issue":"3","first_page":"255","last_page":"255"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.998,"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.998,"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.9974,"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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9974,"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-transformation","display_name":"Data transformation","score":0.465373},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.42065257}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.83725345},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.74568987},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.54838675},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.54004014},{"id":"https://openalex.org/C186399060","wikidata":"https://www.wikidata.org/wiki/Q959962","display_name":"Diagram","level":2,"score":0.5235857},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.465373},{"id":"https://openalex.org/C202446494","wikidata":"https://www.wikidata.org/wiki/Q664166","display_name":"Class diagram","level":4,"score":0.45810816},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.43699014},{"id":"https://openalex.org/C4725764","wikidata":"https://www.wikidata.org/wiki/Q844704","display_name":"Extraction (chemistry)","level":2,"score":0.4354877},{"id":"https://openalex.org/C195807954","wikidata":"https://www.wikidata.org/wiki/Q1662562","display_name":"Information extraction","level":2,"score":0.4299835},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.42065257},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3788556},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33051467},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.24305612},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.090530425},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"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/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"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/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1504/ijiids.2012.047003","pdf_url":null,"source":{"id":"https://openalex.org/S27556001","display_name":"International Journal of Intelligent Information and Database Systems","issn_l":"1751-5858","issn":["1751-5858","1751-5866"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310317825","host_organization_name":"Inderscience Publishers","host_organization_lineage":["https://openalex.org/P4310317825"],"host_organization_lineage_names":["Inderscience Publishers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":21,"referenced_works":["https://openalex.org/W104870642","https://openalex.org/W125528362","https://openalex.org/W1893018","https://openalex.org/W1927396220","https://openalex.org/W1971518725","https://openalex.org/W1993257301","https://openalex.org/W1997529428","https://openalex.org/W2004583871","https://openalex.org/W2014763157","https://openalex.org/W2039780220","https://openalex.org/W2040890015","https://openalex.org/W2098856526","https://openalex.org/W2108971776","https://openalex.org/W2113450657","https://openalex.org/W2120865520","https://openalex.org/W2128731098","https://openalex.org/W2139135093","https://openalex.org/W2143180374","https://openalex.org/W2170950537","https://openalex.org/W4285719527","https://openalex.org/W84515857"],"related_works":["https://openalex.org/W3015205082","https://openalex.org/W2390710026","https://openalex.org/W2364425891","https://openalex.org/W2364409751","https://openalex.org/W2363759074","https://openalex.org/W2361930117","https://openalex.org/W2359411520","https://openalex.org/W2348093825","https://openalex.org/W2347601812","https://openalex.org/W1503556420"],"abstract_inverted_index":{"During":[0],"the":[1,29,34,41,72,75,78,90],"last":[2],"few":[3],"years,":[4],"researchers":[5],"and":[6,58,100],"developers":[7],"had":[8],"proposed":[9,67,91],"various":[10],"trials":[11,25],"to":[12,27,38,81],"put":[13],"a":[14,50,95],"standard":[15],"conceptual":[16,35,53,92],"design":[17,54],"of":[18,40,55,74],"ETL":[19,56],"processes":[20,57],"in":[21,44,77,94,103],"data":[22],"warehouse.":[23],"These":[24],"try":[26],"represent":[28],"main":[30],"mapping":[31,63,85],"activities":[32],"at":[33],"level.":[36],"Due":[37],"limitations":[39],"previous":[42,79],"trials,":[43],"this":[45],"paper":[46],"1":[47],"We":[48,88],"propose":[49],"model":[51,68,93],"for":[52],"we":[59],"call":[60],"it":[61,102],"entity":[62],"diagram":[64],"(EMD).":[65],"The":[66],"is":[69],"built":[70],"upon":[71],"enhancement":[73],"models":[76],"work":[80],"support":[82],"some":[83],"missing":[84],"features.":[86],"2":[87],"implemented":[89],"prototype":[96],"called":[97],"EMD":[98],"Builder":[99],"use":[101],"an":[104],"illustration":[105],"scenario.":[106]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2138195712","counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2025-01-19T14:30:50.787805","created_date":"2016-06-24"}