{"id":"https://openalex.org/W612907962","doi":null,"title":"A Data Warehouse Architectural Design Using Proposed Pseudo Mesh Schema","display_name":"A Data Warehouse Architectural Design Using Proposed Pseudo Mesh Schema","publication_year":2013,"publication_date":"2013-01-24","ids":{"openalex":"https://openalex.org/W612907962","mag":"612907962"},"language":"en","primary_location":{"id":"mag:612907962","doi":null,"is_oa":false,"landing_page_url":"https://www.researchgate.net/profile/Rajdeep_Chowdhury3/publication/277698380_A_DATA_WAREHOUSE_ARCHITECTURAL_DESIGN_USING_PROPOSED_PSEUDO_MESH_SCHEMA/links/557056a108aeab777228c19e.pdf","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},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Rajdeep Chowdhury","orcid":"https://orcid.org/0000-0002-6041-0613","observed_orcids":["https://orcid.org/0000-0002-6041-0613"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rajdeep Chowdhury","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-6041-0613","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101413313","display_name":"Amitava Ghosh","orcid":"https://orcid.org/0000-0003-4850-9570","observed_orcids":["https://orcid.org/0000-0003-4850-9570"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Amitava Ghosh","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0003-4850-9570","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5022774297","display_name":"Mallika De","orcid":"https://orcid.org/0000-0002-5402-3385","observed_orcids":["https://orcid.org/0000-0002-5402-3385"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mallika De","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-5402-3385","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.7287,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.91301006,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9609000086784363,"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.9609000086784363,"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.03799999877810478,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.0,"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/data-warehouse-architecture","display_name":"data warehouse architecture","score":0.972000002861023},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.7160000205039978},{"id":"https://openalex.org/keywords/snowflake-schema","display_name":"snowflake schema","score":1.0},{"id":"https://openalex.org/keywords/fact-tables","display_name":"fact tables","score":0.8349999785423279},{"id":"https://openalex.org/keywords/dimension-tables","display_name":"dimension tables","score":1.0},{"id":"https://openalex.org/keywords/redundancy-reduction","display_name":"redundancy reduction","score":0.6359999775886536},{"id":"https://openalex.org/keywords/time-complexity","display_name":"time complexity","score":0.5270000100135803},{"id":"https://openalex.org/keywords/schema-design","display_name":"schema design","score":0.3330000042915344}],"concepts":[{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.8015222549438477},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.696373462677002},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6931369304656982},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6779597401618958},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.5916663408279419},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.5007355213165283},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.43143773078918457},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4260751008987427},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.41857272386550903},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4049752354621887},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3294890522956848},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.24939867854118347},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.17495927214622498},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.13231328129768372},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09245878458023071},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:612907962","doi":null,"is_oa":false,"landing_page_url":"https://www.researchgate.net/profile/Rajdeep_Chowdhury3/publication/277698380_A_DATA_WAREHOUSE_ARCHITECTURAL_DESIGN_USING_PROPOSED_PSEUDO_MESH_SCHEMA/links/557056a108aeab777228c19e.pdf","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":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1544363742","https://openalex.org/W1554212881","https://openalex.org/W1951559138","https://openalex.org/W1982556167","https://openalex.org/W2008120802","https://openalex.org/W2052884373","https://openalex.org/W2056553115","https://openalex.org/W2072764742","https://openalex.org/W2164086463","https://openalex.org/W2460283281"],"related_works":["https://openalex.org/W2182568048","https://openalex.org/W7099993302","https://openalex.org/W3180669399","https://openalex.org/W2020958835","https://openalex.org/W2016144631","https://openalex.org/W4345979","https://openalex.org/W110700143","https://openalex.org/W2170235279","https://openalex.org/W147424557","https://openalex.org/W3023442443"],"abstract_inverted_index":{"A":[0],"set":[1],"of":[2,15,42,49,66,72,86,104,118,129],"dimension":[3,27,51,137],"tables":[4,25,28,52,55,87],"interlinked":[5],"with":[6,134],"one":[7,57,105],"another,":[8,58],"ensuring":[9],"improvement":[10],"in":[11,33,122],"the":[12,22,63,67,84,90,110,114,119,127,135],"time":[13],"complexity":[14],"a":[16,96],"data":[17,120],"warehouse":[18,121],"is":[19,94],"presented":[20],"through":[21],"formulation.":[23],"Fact":[24,140,154],"and":[26,53],"have":[29,59],"been":[30,60],"used":[31],"here,":[32],"their":[34],"normalized":[35],"form,":[36],"to":[37,56,132],"diminish":[38],"redundancy.":[39],"The":[40,70,92,124],"notion":[41],"pseudo":[43],"mesh":[44],"schema":[45,116],"architecture,":[46],"conforming":[47],"interlinking":[48],"all":[50],"fact":[54,130],"proposed":[61],"at":[62],"very":[64],"inception":[65],"devised":[68],"work.":[69],"number":[71,85],"links":[73],"can":[74],"be":[75],"precisely":[76],"calculated":[77],"using":[78],"n":[79,82],"(n-1)/2,":[80],"wherein":[81],"embodies":[83],"present":[88],"within":[89,109],"structure.":[91],"structure":[93,117,125],"obviously":[95],"flexible":[97],"one,":[98],"as":[99],"any":[100],"increase":[101],"or":[102,106],"decrease":[103],"more":[107],"databases":[108],"structure,":[111],"doesn\u2019t":[112],"affect":[113],"entire":[115],"concern.":[123],"uses":[126],"concept":[128],"views":[131],"connect":[133],"existing":[136],"tables.":[138],"Keywords\u2014":[139],"Table,":[141,143,145],"Dimension":[142],"View":[144],"Redundancy,":[146],"Star":[147],"Schema,":[148,150,153],"Snowflake":[149],"Pseudo":[151],"Mesh":[152],"view.":[155]},"counts_by_year":[{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":3}],"updated_date":"2026-09-29T14:09:16.559479","created_date":"2016-06-24T00:00:00"}