{"id":"https://openalex.org/W7214273694","doi":"https://doi.org/10.5212/31xd4e05","title":"Automated Data Warehouse Architecture to Support Knowledge Management in Patent Databases","display_name":"Automated Data Warehouse Architecture to Support Knowledge Management in Patent Databases","publication_year":2026,"publication_date":"2026-09-25","ids":{"openalex":"https://openalex.org/W7214273694","doi":"https://doi.org/10.5212/31xd4e05"},"language":"en","primary_location":{"id":"doi:10.5212/31xd4e05","doi":"https://doi.org/10.5212/31xd4e05","is_oa":true,"landing_page_url":"https://doi.org/10.5212/31xd4e05","pdf_url":"https://revistas.uepg.br/index.php/ijac/article/download/26938/209209220977","source":{"id":"https://openalex.org/S7407064525","display_name":"Iberoamerican Journal of Applied Computing","issn_l":"2237-4523","issn":["2237-4523"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310312406","host_organization_name":"Ponta Grossa State University","host_organization_lineage":["https://openalex.org/P4310312406"],"host_organization_lineage_names":["Ponta Grossa State University"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Iberoamerican Journal of Applied Computing","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://revistas.uepg.br/index.php/ijac/article/download/26938/209209220977","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5152954660","display_name":"Rodrigo Ramos","orcid":"https://orcid.org/0000-0002-7969-0360","observed_orcids":["https://orcid.org/0000-0002-7969-0360"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rodrigo Ramos","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-7969-0360","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024947799","display_name":"Alexandre Leopoldo Gon\u00e7alves","orcid":"https://orcid.org/0000-0002-6583-2807","observed_orcids":["https://orcid.org/0000-0002-6583-2807"]},"institutions":[{"id":"https://openalex.org/I4104125","display_name":"Universidade Federal de Santa Catarina","ror":"https://ror.org/041akq887","country_code":"BR","type":"education","lineage":["https://openalex.org/I4104125"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Alexandre Leopoldo Gon\u00e7alves","raw_affiliation_strings":["Programa de P\u00f3s Gradua\u00e7\u00e3o em Engenharia , Gest\u00e3o e M\u00eddia do Conhecimento (PPGEGC) Departamento de Engenharia , Gest\u00e3o e M\u00eddia do Conhecimento Universidade Federal de Santa Catarina (UFSC)"],"raw_orcid":"https://orcid.org/0000-0002-6583-2807","affiliations":[{"raw_affiliation_string":"Programa de P\u00f3s Gradua\u00e7\u00e3o em Engenharia , Gest\u00e3o e M\u00eddia do Conhecimento (PPGEGC) Departamento de Engenharia , Gest\u00e3o e M\u00eddia do Conhecimento Universidade Federal de Santa Catarina (UFSC)","institution_ids":["https://openalex.org/I4104125"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5122660569","display_name":"Tobias Felipe Kiefer","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I164790352","display_name":"Universidade do Estado de Santa Catarina","ror":"https://ror.org/03ztsbk67","country_code":"BR","type":"education","lineage":["https://openalex.org/I164790352"]},{"id":"https://openalex.org/I4104125","display_name":"Universidade Federal de Santa Catarina","ror":"https://ror.org/041akq887","country_code":"BR","type":"education","lineage":["https://openalex.org/I4104125"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Tobias Felipe Kiefer","raw_affiliation_strings":["Santa Catarina State University","Universidade Federal de Santa Catarina"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Santa Catarina State University","institution_ids":["https://openalex.org/I164790352"]},{"raw_affiliation_string":"Universidade Federal de Santa Catarina","institution_ids":["https://openalex.org/I4104125"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.62482489,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"14","issue":"1","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.9063000082969666,"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.9063000082969666,"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/T10856","display_name":"Intellectual Property and Patents","score":0.017500000074505806,"subfield":{"id":"https://openalex.org/subfields/1405","display_name":"Management of Technology and Innovation"},"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.01720000058412552,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse-architecture","display_name":"data warehouse architecture","score":0.8989999890327454},{"id":"https://openalex.org/keywords/patent-databases","display_name":"patent databases","score":0.9900000095367432},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"knowledge management","score":0.9890000224113464},{"id":"https://openalex.org/keywords/etl-pipeline","display_name":"ETL pipeline","score":0.8809999823570251},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.9520000219345093},{"id":"https://openalex.org/keywords/semantic-enrichment","display_name":"semantic enrichment","score":0.7820000052452087},{"id":"https://openalex.org/keywords/uspto-patent-data","display_name":"USPTO patent data","score":0.6660000085830688},{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.5529999732971191},{"id":"https://openalex.org/keywords/technological-forecasting","display_name":"technology forecasting","score":0.7689999938011169},{"id":"https://openalex.org/keywords/topic-clustering","display_name":"topic clustering","score":0.7639999985694885},{"id":"https://openalex.org/keywords/word-co-occurrence","display_name":"word co-occurrence","score":0.5809999704360962},{"id":"https://openalex.org/keywords/innovation-decision-making","display_name":"innovation decision-making","score":0.5960000157356262},{"id":"https://openalex.org/keywords/docker-containers","display_name":"Docker containers","score":0.5}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7649000287055969},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7010999917984009},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6832000017166138},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5770000219345093},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.5745000243186951},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5051000118255615},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.48190000653266907},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.4041000008583069},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3582000136375427},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.35519999265670776},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34380000829696655},{"id":"https://openalex.org/C120567893","wikidata":"https://www.wikidata.org/wiki/Q1582085","display_name":"Knowledge extraction","level":2,"score":0.34290000796318054},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.3411000072956085},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.33959999680519104},{"id":"https://openalex.org/C2779027411","wikidata":"https://www.wikidata.org/wiki/Q167270","display_name":"Trademark","level":2,"score":0.33730000257492065},{"id":"https://openalex.org/C183068750","wikidata":"https://www.wikidata.org/wiki/Q357393","display_name":"XML database","level":3,"score":0.3271999955177307},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3140999972820282},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.3125},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.3118000030517578},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.31060001254081726},{"id":"https://openalex.org/C93692415","wikidata":"https://www.wikidata.org/wiki/Q1502030","display_name":"Thematic map","level":2,"score":0.3012999892234802},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.3003999888896942},{"id":"https://openalex.org/C58328972","wikidata":"https://www.wikidata.org/wiki/Q184609","display_name":"Expert system","level":2,"score":0.29840001463890076},{"id":"https://openalex.org/C80344994","wikidata":"https://www.wikidata.org/wiki/Q5227369","display_name":"Data virtualization","level":4,"score":0.29330000281333923},{"id":"https://openalex.org/C115925183","wikidata":"https://www.wikidata.org/wiki/Q1412694","display_name":"Knowledge-based systems","level":2,"score":0.2928999960422516},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2888999879360199},{"id":"https://openalex.org/C3019022308","wikidata":"https://www.wikidata.org/wiki/Q1418353","display_name":"Multidimensional data","level":2,"score":0.2761000096797943},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.2720000147819519},{"id":"https://openalex.org/C98025372","wikidata":"https://www.wikidata.org/wiki/Q477538","display_name":"Systems architecture","level":3,"score":0.2696000039577484},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.26429998874664307},{"id":"https://openalex.org/C21761406","wikidata":"https://www.wikidata.org/wiki/Q8042330","display_name":"XML framework","level":3,"score":0.2572000026702881},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.25529998540878296},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.2540000081062317},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.25220000743865967}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5212/31xd4e05","doi":"https://doi.org/10.5212/31xd4e05","is_oa":true,"landing_page_url":"https://doi.org/10.5212/31xd4e05","pdf_url":"https://revistas.uepg.br/index.php/ijac/article/download/26938/209209220977","source":{"id":"https://openalex.org/S7407064525","display_name":"Iberoamerican Journal of Applied Computing","issn_l":"2237-4523","issn":["2237-4523"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310312406","host_organization_name":"Ponta Grossa State University","host_organization_lineage":["https://openalex.org/P4310312406"],"host_organization_lineage_names":["Ponta Grossa State University"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Iberoamerican Journal of Applied Computing","raw_type":"journal-article"},{"id":"pmh:oai:uepg.br:article/26938","doi":null,"is_oa":true,"landing_page_url":"https://revistas.uepg.br/index.php/index/article/view/26938","pdf_url":null,"source":{"id":"https://openalex.org/S7407064525","display_name":"Iberoamerican Journal of Applied Computing","issn_l":"2237-4523","issn":["2237-4523"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310312406","host_organization_name":"Ponta Grossa State University","host_organization_lineage":["https://openalex.org/P4310312406"],"host_organization_lineage_names":["Ponta Grossa State University"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2237-4523","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.5212/31xd4e05","doi":"https://doi.org/10.5212/31xd4e05","is_oa":true,"landing_page_url":"https://doi.org/10.5212/31xd4e05","pdf_url":"https://revistas.uepg.br/index.php/ijac/article/download/26938/209209220977","source":{"id":"https://openalex.org/S7407064525","display_name":"Iberoamerican Journal of Applied Computing","issn_l":"2237-4523","issn":["2237-4523"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310312406","host_organization_name":"Ponta Grossa State University","host_organization_lineage":["https://openalex.org/P4310312406"],"host_organization_lineage_names":["Ponta Grossa State University"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Iberoamerican Journal of Applied Computing","raw_type":"journal-article"},"sustainable_development_goals":[{"score":1.0,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7214273694.pdf","grobid_xml":"https://content.openalex.org/works/W7214273694.grobid-xml"},"referenced_works_count":4,"referenced_works":["https://openalex.org/W1614298861","https://openalex.org/W1945317942","https://openalex.org/W2468328197","https://openalex.org/W4413148076"],"related_works":["https://openalex.org/W7134918417","https://openalex.org/W7120856451","https://openalex.org/W2889300262","https://openalex.org/W7019815207","https://openalex.org/W3211071034","https://openalex.org/W2184064365","https://openalex.org/W4409348745","https://openalex.org/W2076370288","https://openalex.org/W2901463299","https://openalex.org/W2061321794"],"abstract_inverted_index":{"This":[0],"work":[1],"presents":[2],"an":[3,154],"automated":[4],"Data":[5],"Warehouse":[6],"architecture":[7],"designed":[8],"to":[9,44,150],"support":[10],"the":[11,27,81,119,139,158],"structuring,":[12],"analysis,":[13],"and":[14,31,47,77,89,95,132,147,164,174,179],"management":[15],"of":[16,121],"knowledge":[17],"in":[18,176],"patent":[19],"databases.":[20],"Based":[21],"on":[22],"XML":[23],"files":[24],"provided":[25],"by":[26],"United":[28],"States":[29],"Patent":[30],"Trademark":[32],"Office":[33],"(USPTO),":[34],"a":[35,51,56,66,71,74,162],"Python-based":[36],"Extract,":[37],"Transform,":[38],"Load":[39],"(ETL)":[40],"pipeline":[41],"was":[42],"developed":[43],"preprocess,":[45],"standardize,":[46],"load":[48],"data":[49],"into":[50,91],"PostgreSQL":[52],"database":[53],"modeled":[54],"using":[55],"star":[57],"schema.":[58],"The":[59,116,135],"architecture,":[60],"executed":[61],"through":[62,105],"Docker":[63],"containers,":[64],"integrates":[65],"staging":[67],"layer,":[68],"analytical":[69,97,166],"dimensions,":[70],"fact":[72],"table,":[73],"REST":[75],"API,":[76],"OLAP":[78],"queries.":[79],"In":[80],"initial":[82],"load,":[83],"189,410":[84],"raw":[85],"records":[86],"were":[87],"processed":[88],"consolidated":[90],"16,311":[92],"unique":[93],"patents":[94],"651,117":[96],"associations.":[98],"Textual":[99],"processing":[100],"identified":[101],"25,658":[102],"distinct":[103],"terms":[104],"tokenization,":[106],"while":[107],"Artificial":[108],"Intelligence-based":[109],"semantic":[110,130],"enrichment":[111],"added":[112],"45,449":[113],"technical":[114],"terms.":[115],"analyses":[117],"supported":[118],"exploration":[120],"term":[122],"frequencies,":[123],"temporal":[124],"evolution,":[125],"technological":[126],"categories,":[127],"thematic":[128],"clusters,":[129],"co-occurrences,":[131],"trend":[133,172],"forecasts.":[134],"results":[136],"demonstrate":[137],"that":[138],"multidimensional":[140],"model":[141],"enables":[142],"temporal,":[143],"semantic,":[144],"technological,":[145],"geographical,":[146],"authorship":[148],"perspectives":[149],"be":[151],"combined":[152],"within":[153],"integrated":[155],"structure.":[156],"Therefore,":[157],"proposed":[159],"solution":[160],"provides":[161],"reproducible":[163],"extensible":[165],"foundation":[167],"for":[168],"supporting":[169],"technology":[170],"forecasting,":[171],"monitoring,":[173],"decision-making":[175],"research,":[177],"development,":[178],"innovation.":[180]},"counts_by_year":[],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2026-09-26T00:00:00"}