{"id":"https://openalex.org/W2018741023","doi":"https://doi.org/10.1142/s0218843003000772","title":"Universal Data Warehousing Based on a Meta-Data Modeling Approach","display_name":"Universal Data Warehousing Based on a Meta-Data Modeling Approach","publication_year":2003,"publication_date":"2003-07-03","ids":{"openalex":"https://openalex.org/W2018741023","doi":"https://doi.org/10.1142/s0218843003000772","mag":"2018741023"},"language":"en","primary_location":{"id":"doi:10.1142/s0218843003000772","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218843003000772","pdf_url":null,"source":{"id":"https://openalex.org/S17147961","display_name":"International Journal of Cooperative Information Systems","issn_l":"0218-8430","issn":["0218-8430","1793-6365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Cooperative Information Systems","raw_type":"journal-article"},"type":"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/A5111423941","display_name":"Joseph Fong","orcid":null},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Joseph Fong","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Tat Chee Avenue, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Tat Chee Avenue, Hong Kong, China","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100404176","display_name":"Qing Li","orcid":"https://orcid.org/0000-0003-3370-471X"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Qing Li","raw_affiliation_strings":["Department of Computer Engineering and Information Technology, City University of Hong Kong, Tat Chee Avenue, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Engineering and Information Technology, City University of Hong Kong, Tat Chee Avenue, Hong Kong, China","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5012192744","display_name":"Shi\u2010Ming Huang","orcid":"https://orcid.org/0000-0001-6062-7153"},"institutions":[{"id":"https://openalex.org/I148099254","display_name":"National Chung Cheng University","ror":"https://ror.org/0028v3876","country_code":"TW","type":"education","lineage":["https://openalex.org/I148099254"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Shi-Ming Huang","raw_affiliation_strings":["Department of Information Management, National Chung Cheng University, Min-Hsiung, Chia-Yi 621, Taiwan, ROC"],"affiliations":[{"raw_affiliation_string":"Department of Information Management, National Chung Cheng University, Min-Hsiung, Chia-Yi 621, Taiwan, ROC","institution_ids":["https://openalex.org/I148099254"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5111423941"],"corresponding_institution_ids":["https://openalex.org/I168719708"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.15809,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"12","issue":"03","first_page":"325","last_page":"363"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T11106","display_name":"Data Management and Algorithms","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.998199999332428,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8802544474601746},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.822124719619751},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6793237328529358},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.6493571400642395},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.6013615131378174},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5822616219520569},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.5059193968772888},{"id":"https://openalex.org/keywords/data-element","display_name":"Data element","score":0.49857306480407715},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.4828679859638214},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.47490227222442627},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.4566880464553833},{"id":"https://openalex.org/keywords/metadata-management","display_name":"Metadata management","score":0.4529120922088623},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.44506147503852844},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.44435426592826843},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4440295696258545},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4416370391845703},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.43501344323158264},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4296450614929199},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3827502727508545},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.37168681621551514},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.20532327890396118}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8802544474601746},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.822124719619751},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6793237328529358},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.6493571400642395},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.6013615131378174},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5822616219520569},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.5059193968772888},{"id":"https://openalex.org/C30872290","wikidata":"https://www.wikidata.org/wiki/Q1172389","display_name":"Data element","level":3,"score":0.49857306480407715},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4828679859638214},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.47490227222442627},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4566880464553833},{"id":"https://openalex.org/C2779489174","wikidata":"https://www.wikidata.org/wiki/Q6822246","display_name":"Metadata management","level":3,"score":0.4529120922088623},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.44506147503852844},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44435426592826843},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4440295696258545},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4416370391845703},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.43501344323158264},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4296450614929199},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3827502727508545},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.37168681621551514},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.20532327890396118}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1142/s0218843003000772","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218843003000772","pdf_url":null,"source":{"id":"https://openalex.org/S17147961","display_name":"International Journal of Cooperative Information Systems","issn_l":"0218-8430","issn":["0218-8430","1793-6365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Cooperative Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.511.2328","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.511.2328","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Universal.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.47999998927116394}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W336975910","https://openalex.org/W1482520531","https://openalex.org/W1496609628","https://openalex.org/W1545406293","https://openalex.org/W1565208963","https://openalex.org/W1599398663","https://openalex.org/W1999593441","https://openalex.org/W2003218583","https://openalex.org/W2072764742","https://openalex.org/W2092246601","https://openalex.org/W2103848686","https://openalex.org/W2131165411","https://openalex.org/W2134218427","https://openalex.org/W2143455443","https://openalex.org/W2172549414"],"related_works":["https://openalex.org/W2365178252","https://openalex.org/W2783605540","https://openalex.org/W2748520928","https://openalex.org/W2535974884","https://openalex.org/W4205875026","https://openalex.org/W3084772717","https://openalex.org/W2374161210","https://openalex.org/W56165858","https://openalex.org/W4387960417","https://openalex.org/W2734649671"],"abstract_inverted_index":{"Data":[0,108],"warehouse":[1,147,178],"contains":[2],"vast":[3],"amount":[4],"of":[5,11,23,42,58,72,100,158,163,175],"data":[6,45,49,60,151,177,207],"to":[7,19,139,143],"support":[8],"complex":[9],"queries":[10],"various":[12],"Decision":[13],"Support":[14],"Systems":[15],"(DSSs).":[16],"It":[17],"needs":[18],"store":[20],"materialized":[21],"views":[22],"data,":[24],"which":[25,62,96,129],"must":[26],"be":[27,135],"available":[28],"consistently":[29],"and":[30,69,104,112,123,170],"instantaneously.":[31],"Using":[32],"a":[33,43,59,204],"frame":[34,52],"metadata":[35,53,57],"model,":[36],"this":[37,212],"paper":[38],"presents":[39],"an":[40,64,130,196],"architecture":[41],"universal":[44],"warehousing":[46,208],"with":[47],"different":[48,150],"models.":[50],"The":[51],"model":[54],"represents":[55],"the":[56,89,94,98,141,145,160,171,176,189],"warehouse,":[61],"structures":[63],"application":[65,197],"domain":[66,209],"into":[67,120,125],"classes,":[68],"integrates":[70],"schemas":[71],"heterogeneous":[73],"databases":[74],"by":[75,116,166,179],"capturing":[76],"their":[77],"semantics.":[78],"A":[79],"star":[80,164],"schema":[81,99,165],"is":[82,114],"derived":[83,187],"from":[84,188],"user":[85],"requirements":[86],"based":[87,210],"on":[88,211],"integrated":[90,190],"schema,":[91],"catalogued":[92],"in":[93,149,203],"metadata,":[95],"stores":[97],"relational":[101,132,161],"database":[102,106,119],"(RDB)":[103],"object-oriented":[105],"(OODB).":[107],"materialization":[109],"between":[110],"RDB":[111],"OODB":[113],"achieved":[115],"unloading":[117],"source":[118],"sequential":[121],"file":[122],"reloading":[124],"target":[126],"database,":[127],"through":[128,184],"object":[131,172],"view":[133,148,162,174],"can":[134],"defined":[136],"so":[137],"as":[138],"allow":[140],"users":[142],"obtain":[144],"same":[146],"models":[152],"simultaneously.":[153],"We":[154],"describe":[155],"our":[156,194],"procedures":[157],"building":[159],"multidimensional":[167],"SQL":[168],"query,":[169],"oriented":[173],"Online":[180],"Analytical":[181],"Processing":[182],"(OLAP)":[183],"method":[185],"call,":[186],"schema.":[191],"To":[192],"validate":[193],"work,":[195],"prototype":[198],"system":[199],"has":[200],"been":[201],"developed":[202],"product":[205],"sales":[206],"approach.":[213]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}