{"id":"https://openalex.org/W206449581","doi":null,"title":"A Goal and Ontology Based Approach for Generating ETL Process Specifications","display_name":"A Goal and Ontology Based Approach for Generating ETL Process Specifications","alternate_titles":[],"publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W206449581","mag":"206449581"},"language":"en","primary_location":{"id":"pmh:oai:etd.uum.edu.my:3351","doi":null,"is_oa":true,"landing_page_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","pdf_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","source":{"id":"https://openalex.org/S4377196727","display_name":"UUM Electronic Theses and Dissertation [eTheses] (Northern University of Malaysia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I94625822","host_organization_name":"Universiti Utara Malaysia","host_organization_lineage":["https://openalex.org/I94625822"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"parent_works":[],"lineage":["https://openalex.org/W206449581"],"child_works_count":0,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5085569274","display_name":"Azman Ta\u2019a","orcid":"https://orcid.org/0000-0003-4443-3302","observed_orcids":["https://orcid.org/0000-0003-4443-3302"]},"institutions":[{"id":"https://openalex.org/I94625822","display_name":"Universiti Utara Malaysia","ror":"https://ror.org/01ss10648","country_code":"MY","type":"education","lineage":["https://openalex.org/I94625822"]}],"countries":["MY"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Azman Ta\u2019a","raw_affiliation_strings":["Universiti Utara Malaysia"],"raw_orcid":"https://orcid.org/0000-0003-4443-3302","affiliations":[{"raw_affiliation_string":"Universiti Utara Malaysia","institution_ids":["https://openalex.org/I94625822"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5085569274"],"corresponding_institution_ids":["https://openalex.org/I94625822"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9829000234603882,"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.9829000234603882,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.006500000134110451,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T14222","display_name":"Knowledge Management and Technology","score":0.003100000089034438,"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/data-warehouse-design","display_name":"data warehouse design","score":0.9309999942779541},{"id":"https://openalex.org/keywords/goal-oriented-requirements-analysis","display_name":"goal-oriented requirements analysis","score":0.5130000114440918},{"id":"https://openalex.org/keywords/user-requirements-analysis","display_name":"user needs analysis","score":0.5740000009536743},{"id":"https://openalex.org/keywords/data-heterogeneity","display_name":"data heterogeneity","score":0.8040000200271606}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6760088205337524},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.5671588182449341},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5654538869857788},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.4854453206062317},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.48160263895988464},{"id":"https://openalex.org/C2780522230","wikidata":"https://www.wikidata.org/wiki/Q1140419","display_name":"Ambiguity","level":2,"score":0.4604718089103699},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4581862986087799},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.45626094937324524},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.34555569291114807},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21465924382209778},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:etd.uum.edu.my:3351","doi":null,"is_oa":true,"landing_page_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","pdf_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","source":{"id":"https://openalex.org/S4377196727","display_name":"UUM Electronic Theses and Dissertation [eTheses] (Northern University of Malaysia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I94625822","host_organization_name":"Universiti Utara Malaysia","host_organization_lineage":["https://openalex.org/I94625822"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},{"id":"mag:206449581","doi":null,"is_oa":false,"landing_page_url":"https://etd.uum.edu.my/3351/","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"pmh:oai:etd.uum.edu.my:3351","doi":null,"is_oa":true,"landing_page_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","pdf_url":"https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf","source":{"id":"https://openalex.org/S4377196727","display_name":"UUM Electronic Theses and Dissertation [eTheses] (Northern University of Malaysia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I94625822","host_organization_name":"Universiti Utara Malaysia","host_organization_lineage":["https://openalex.org/I94625822"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":155,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W65269168","https://openalex.org/W70492302","https://openalex.org/W77011064","https://openalex.org/W84082018","https://openalex.org/W87275792","https://openalex.org/W120802049","https://openalex.org/W135962628","https://openalex.org/W141953425","https://openalex.org/W167013338","https://openalex.org/W181305784","https://openalex.org/W186994102","https://openalex.org/W190840948","https://openalex.org/W203030367","https://openalex.org/W609472041","https://openalex.org/W653669459","https://openalex.org/W657079967","https://openalex.org/W1214084238","https://openalex.org/W1482379509","https://openalex.org/W1482880007","https://openalex.org/W1485166144","https://openalex.org/W1488758641","https://openalex.org/W1489574993","https://openalex.org/W1493831684","https://openalex.org/W1495859460","https://openalex.org/W1502624642","https://openalex.org/W1504376353","https://openalex.org/W1504452355","https://openalex.org/W1506240119","https://openalex.org/W1508412218","https://openalex.org/W1515884279","https://openalex.org/W1516374810","https://openalex.org/W1520191953","https://openalex.org/W1524500851","https://openalex.org/W1534626598","https://openalex.org/W1536603646","https://openalex.org/W1538627168","https://openalex.org/W1540516229","https://openalex.org/W1541543414","https://openalex.org/W1541795485","https://openalex.org/W1543472629","https://openalex.org/W1543681337","https://openalex.org/W1546854838","https://openalex.org/W1549145368","https://openalex.org/W1551438051","https://openalex.org/W1553277444","https://openalex.org/W1555447184","https://openalex.org/W1558140929","https://openalex.org/W1558491139","https://openalex.org/W1560914538","https://openalex.org/W1574774197","https://openalex.org/W1578269782","https://openalex.org/W1580022002","https://openalex.org/W1582407391","https://openalex.org/W1587074509","https://openalex.org/W1590548082","https://openalex.org/W1591959487","https://openalex.org/W1600475986","https://openalex.org/W1602357152","https://openalex.org/W1603422431","https://openalex.org/W1605533097","https://openalex.org/W1608936120","https://openalex.org/W1610496399","https://openalex.org/W1620530708","https://openalex.org/W1681447125","https://openalex.org/W1750243098","https://openalex.org/W1771420424","https://openalex.org/W1793807384","https://openalex.org/W1851338714","https://openalex.org/W1860825398","https://openalex.org/W1881101619","https://openalex.org/W1912089697","https://openalex.org/W1940888119","https://openalex.org/W1969722313","https://openalex.org/W1975334201","https://openalex.org/W1980624726","https://openalex.org/W1982600306","https://openalex.org/W1989532930","https://openalex.org/W1992673035","https://openalex.org/W1997144646","https://openalex.org/W1998400029","https://openalex.org/W2002977049","https://openalex.org/W2008120802","https://openalex.org/W2008896880","https://openalex.org/W2021539942","https://openalex.org/W2027043094","https://openalex.org/W2032047314","https://openalex.org/W2032999854","https://openalex.org/W2034334856","https://openalex.org/W2037460328","https://openalex.org/W2040847901","https://openalex.org/W2047806017","https://openalex.org/W2063753658","https://openalex.org/W2065512886","https://openalex.org/W2066151696","https://openalex.org/W2071463681","https://openalex.org/W2071816903","https://openalex.org/W2072764742","https://openalex.org/W2088378932","https://openalex.org/W2091579301","https://openalex.org/W2098856526","https://openalex.org/W2099885468","https://openalex.org/W2101569704","https://openalex.org/W2102069129","https://openalex.org/W2102111427","https://openalex.org/W2102994123","https://openalex.org/W2104394545","https://openalex.org/W2106895292","https://openalex.org/W2107658650","https://openalex.org/W2107843752","https://openalex.org/W2108914561","https://openalex.org/W2109105084","https://openalex.org/W2114887408","https://openalex.org/W2116437219","https://openalex.org/W2122789628","https://openalex.org/W2124405605","https://openalex.org/W2126004201","https://openalex.org/W2129289644","https://openalex.org/W2130028914","https://openalex.org/W2130891285","https://openalex.org/W2133109597","https://openalex.org/W2134232070","https://openalex.org/W2136646851","https://openalex.org/W2137079713","https://openalex.org/W2138105615","https://openalex.org/W2139088695","https://openalex.org/W2139301219","https://openalex.org/W2144192824","https://openalex.org/W2144819523","https://openalex.org/W2146531709","https://openalex.org/W2149223538","https://openalex.org/W2150413312","https://openalex.org/W2153753087","https://openalex.org/W2154829072","https://openalex.org/W2159765281","https://openalex.org/W2160826253","https://openalex.org/W2163009032","https://openalex.org/W2164947858","https://openalex.org/W2165242406","https://openalex.org/W2166709107","https://openalex.org/W2170165620","https://openalex.org/W2188953292","https://openalex.org/W2189184186","https://openalex.org/W2304057943","https://openalex.org/W2431933493","https://openalex.org/W2496917169","https://openalex.org/W2504550867","https://openalex.org/W2624907881","https://openalex.org/W2661743557","https://openalex.org/W3045699281","https://openalex.org/W3124954823","https://openalex.org/W3127729154","https://openalex.org/W4243742440","https://openalex.org/W4244274343","https://openalex.org/W4250680218"],"related_works":["https://openalex.org/W2081050398","https://openalex.org/W2139611831","https://openalex.org/W1681447125","https://openalex.org/W7042898700","https://openalex.org/W1254164846","https://openalex.org/W2013823950","https://openalex.org/W7047535505","https://openalex.org/W2497184331","https://openalex.org/W1482268585"],"abstract_inverted_index":{"Data":[0],"warehouse":[1],"(DW)":[2],"systems":[3,25,121,255],"development":[4,256],"involves":[5],"several":[6],"tasks":[7],"such":[8,51],"as":[9,52],"defining":[10,53],"requirements,":[11,78],"designing":[12,98,135,205],"DW":[13,24,94,120,220,254],"schemas,":[14],"and":[15,38,56,79,147,152,165,186,206,226,231],"specifying":[16],"data":[17,57,70,73,83],"transformation":[18,58,84],"operations.":[19],"Indeed,":[20],"the":[21,31,35,43,48,80,91,99,108,111,130,136,141,198,208,213,219,224,232,242,250,259],"success":[22],"of":[23,34,76,82,93,110,119,144,157,228,253],"is":[26,126,235],"very":[27],"much":[28],"dependent":[29],"on":[30,90],"proper":[32],"design":[33],"extracting,":[36],"transforming,":[37],"loading":[39],"(ETL)":[40],"processes.":[41,101],"However,":[42],"common":[44],"design-related":[45],"problems":[46,66],"in":[47,72,174],"ETL":[49,100,112,137,209,243],"processes":[50,113,138,210,244],"user":[54,77],"requirements":[55],"specifications":[59,114,245],"are":[60,67],"far":[61],"from":[62,123,140,249],"being":[63],"resolved.":[64],"These":[65,190],"due":[68],"to":[69,128,195],"heterogeneity":[71],"sources,":[74],"ambiguity":[75],"complexity":[81],"activities.":[85],"Current":[86],"approaches":[87],"have":[88],"limitations":[89],"reconciliation":[92],"requirement":[95,131],"semantics":[96],"towards":[97],"As":[102],"a":[103],"result,":[104],"this":[105,124,229],"has":[106],"prolonged":[107],"process":[109],"generation.":[115],"The":[116,155,170,237],"semantic":[117],"framework":[118],"established":[122],"study":[125],"used":[127,194],"develop":[129],"analysis":[132],"method":[133,239],"for":[134,204,222],"(RAMEPs)":[139],"different":[142],"perspectives":[143],"organization,":[145],"decision-maker,":[146],"developer":[148],"by":[149,162,218,257],"using":[150,163,258],"goal":[151],"ontology":[153],"approaches.":[154],"correctness":[156],"RAMEPs":[158,171,199,214,238],"approach":[159,200,215,234],"was":[160,172,216],"validated":[161],"modified":[164],"newly":[166],"developed":[167],"compliant":[168],"tools.":[169],"evaluated":[173],"three":[175],"real":[176],"case":[177,191],"studies,":[178],"i.e.,":[179],"Student":[180],"Affairs":[181],"System,":[182,185],"Gas":[183],"Utility":[184],"Graduate":[187],"Entrepreneur":[188],"System.":[189],"studies":[192],"were":[193],"illustrate":[196],"how":[197],"can":[201,246],"be":[202,247],"implemented":[203],"generating":[207],"specifications.":[211],"Moreover,":[212],"reviewed":[217],"experts":[221],"assessing":[223],"strengths":[225],"weaknesses":[227],"method,":[230],"new":[233],"accepted.":[236],"proves":[240],"that":[241],"derived":[248],"early":[251],"phases":[252],"goal-ontology":[260],"approach.":[261]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W206449581","counts_by_year":[],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2016-06-24T00:00:00"}
