{"id":"https://openalex.org/W7154686303","doi":"https://doi.org/10.19053/uptc.01211129.v34.n74.2025.20737","title":"Integraci\u00f3n del algoritmo K-means en PostgreSQL mediante extensiones en PL/Python: una arquitectura medianamente acoplada","display_name":"Integraci\u00f3n del algoritmo K-means en PostgreSQL mediante extensiones en PL/Python: una arquitectura medianamente acoplada","publication_year":2025,"publication_date":"2025-01-01","ids":{"openalex":"https://openalex.org/W7154686303","doi":"https://doi.org/10.19053/uptc.01211129.v34.n74.2025.20737"},"language":"en","primary_location":{"id":"pmh:oai:dialnet.unirioja.es:ART0001846475","doi":null,"is_oa":true,"landing_page_url":"https://dialnet.unirioja.es/servlet/oaiart?codigo=10728876","pdf_url":"https://dialnet.unirioja.es/descarga/articulo/10728876.pdf","source":{"id":"https://openalex.org/S4306401293","display_name":"Dialnet (Universidad de la Rioja)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I168974976","host_organization_name":"Universidad de La Rioja","host_organization_lineage":["https://openalex.org/I168974976"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Revista Facultad de Ingenier\u00eda, ISSN 0121-1129, Vol. 34, N\u00ba. 74, 2025","raw_type":"text (article)"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://dialnet.unirioja.es/descarga/articulo/10728876.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5133895586","display_name":"Fernando-Mauricio Vallejo-Cabrera","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Vallejo-Cabrera, Fernando-Mauricio","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101625249","display_name":"Ricardo Timar\u00e1n Pereira","orcid":"https://orcid.org/0000-0002-0006-6654","observed_orcids":["https://orcid.org/0000-0002-0006-6654"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Timaran-Pereira, Ricardo","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5035258455","display_name":"An\u00edvar N\u00e9stor Chaves Torres","orcid":"https://orcid.org/0000-0001-6984-7398","observed_orcids":["https://orcid.org/0000-0001-6984-7398"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chaves-Torres, Anivar","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"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.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"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/T13373","display_name":"Data Mining and Machine Learning Applications","score":0.6294000148773193,"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"}},"topics":[{"id":"https://openalex.org/T13373","display_name":"Data Mining and Machine Learning Applications","score":0.6294000148773193,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.13379999995231628,"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/T11106","display_name":"Data Management and Algorithms","score":0.10100000351667404,"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/k-means-clustering","display_name":"K-means clustering","score":0.9679999947547913},{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":0.9509999752044678},{"id":"https://openalex.org/keywords/database-extension","display_name":"database extension","score":0.7990000247955322},{"id":"https://openalex.org/keywords/data-mining","display_name":"data mining","score":0.7400000095367432},{"id":"https://openalex.org/keywords/crisp-dm","display_name":"CRISP-DM","score":0.9660000205039978},{"id":"https://openalex.org/keywords/clustering-performance-comparison","display_name":"clustering performance comparison","score":0.5839999914169312}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5911999940872192},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5690000057220459},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.4083000123500824},{"id":"https://openalex.org/C98025372","wikidata":"https://www.wikidata.org/wiki/Q477538","display_name":"Systems architecture","level":3,"score":0.30469998717308044},{"id":"https://openalex.org/C459310","wikidata":"https://www.wikidata.org/wiki/Q117801","display_name":"Computational science","level":1,"score":0.2721000015735626},{"id":"https://openalex.org/C106516650","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm design","level":2,"score":0.2718000113964081},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.259799987077713},{"id":"https://openalex.org/C137800194","wikidata":"https://www.wikidata.org/wiki/Q11713455","display_name":"Interpolation (computer graphics)","level":3,"score":0.25609999895095825},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2549000084400177},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.2451999932527542}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:dialnet.unirioja.es:ART0001846475","doi":null,"is_oa":true,"landing_page_url":"https://dialnet.unirioja.es/servlet/oaiart?codigo=10728876","pdf_url":"https://dialnet.unirioja.es/descarga/articulo/10728876.pdf","source":{"id":"https://openalex.org/S4306401293","display_name":"Dialnet (Universidad de la Rioja)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I168974976","host_organization_name":"Universidad de La Rioja","host_organization_lineage":["https://openalex.org/I168974976"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Revista Facultad de Ingenier\u00eda, ISSN 0121-1129, Vol. 34, N\u00ba. 74, 2025","raw_type":"text (article)"},{"id":"pmh:oai:repositorio.uptc.edu.co:001/21620","doi":"https://doi.org/10.19053/uptc.01211129.v34.n74.2025.20737","is_oa":true,"landing_page_url":"https://repositorio.uptc.edu.co/handle/001/21620","pdf_url":null,"source":{"id":"https://openalex.org/S7407055399","display_name":"Repositorio Institucional UPTC","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://revistas.uptc.edu.co/index.php/ingenieria/article/view/20737","raw_type":"http://purl.org/coar/resource_type/c_6501"},{"id":"pmh:oai:revistas.uptc.edu.co:article/20737","doi":"https://doi.org/10.19053/uptc.01211129.v34.n74.2025.20737","is_oa":true,"landing_page_url":"https://revistas.uptc.edu.co/index.php/ingenieria/article/view/20737","pdf_url":null,"source":{"id":"https://openalex.org/S4306402167","display_name":"Portal De Revistas UPTC (Universidad Pedag\u00f3gica y Tecnol\u00f3gica de Colombia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I222202552","host_organization_name":"Universidad Pedag\u00f3gica y Tecnol\u00f3gica de Colombia","host_organization_lineage":["https://openalex.org/I222202552"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"0121-1129","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:dialnet.unirioja.es:ART0001846475","doi":null,"is_oa":true,"landing_page_url":"https://dialnet.unirioja.es/servlet/oaiart?codigo=10728876","pdf_url":"https://dialnet.unirioja.es/descarga/articulo/10728876.pdf","source":{"id":"https://openalex.org/S4306401293","display_name":"Dialnet (Universidad de la Rioja)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I168974976","host_organization_name":"Universidad de La Rioja","host_organization_lineage":["https://openalex.org/I168974976"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Revista Facultad de Ingenier\u00eda, ISSN 0121-1129, Vol. 34, N\u00ba. 74, 2025","raw_type":"text (article)"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5378999710083008}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7154686303.pdf","grobid_xml":"https://content.openalex.org/works/W7154686303.grobid-xml"},"referenced_works_count":10,"referenced_works":["https://openalex.org/W1782340540","https://openalex.org/W1865821943","https://openalex.org/W2114000432","https://openalex.org/W2902672843","https://openalex.org/W2921630034","https://openalex.org/W3038448533","https://openalex.org/W3130255873","https://openalex.org/W4307561380","https://openalex.org/W4387141942","https://openalex.org/W4400134761"],"related_works":["https://openalex.org/W4293105003","https://openalex.org/W2121737596","https://openalex.org/W3214681701","https://openalex.org/W109470809","https://openalex.org/W2032840619","https://openalex.org/W7099819933","https://openalex.org/W4408938010","https://openalex.org/W3080882866","https://openalex.org/W2144405306","https://openalex.org/W7121578415"],"abstract_inverted_index":{"This":[0,43,244],"paper":[1],"presents":[2],"the":[3,7,13,41,52,74,99,105,117,224,238],"process":[4],"of":[5,76,81,102,218,240],"integrating":[6],"K-means":[8,106],"partitioning":[9],"clustering":[10,46,169,216],"algorithm":[11],"into":[12,40,111],"PostgreSQL":[14,96],"data-base":[15],"management":[16],"system":[17],"by":[18,97],"developing":[19],"an":[20,152],"extension":[21,153,196,226],"in":[22,192],"PL/Python.":[23],"The":[24,90,172,195],"proposal":[25,245],"is":[26,92,129,209,230],"framed":[27],"within":[28],"a":[29,84,150,247],"moderately":[30],"coupled":[31],"architecture,":[32],"aiming":[33],"to":[34,48,54,62,73,86,108,159,167,202,232,256],"incorporate":[35],"machine":[36,241],"learning":[37,242],"capabilities":[38,236],"directly":[39],"DBMS.":[42],"integration":[44,239],"allows":[45],"processes":[47,170],"be":[49],"executed":[50],"without":[51,261],"need":[53,255],"rely":[55],"on":[56,94,263],"external":[57,264],"tools,":[58],"thus":[59],"facilitating":[60],"access":[61],"data":[63,132,141,143,193,213,259],"mining":[64,133],"techniques":[65],"for":[66,122,131,211,252],"small":[67],"and":[68,71,135,147,157,185,189,204,206,215,249],"medium-sized":[69],"organizations":[70,253],"contributing":[72],"generation":[75],"knowledge":[77],"from":[78],"large":[79],"volumes":[80,214],"data,":[82],"with":[83],"view":[85],"improving":[87],"their":[88],"competitiveness.":[89],"research":[91],"focused":[93],"extending":[95],"incorporating":[98],"descriptive":[100],"technique":[101],"clustering,":[103],"specifically":[104],"algorithm,":[107],"segment":[109],"datasets":[110],"homogeneous":[112],"groups.":[113],"To":[114],"achieve":[115],"this,":[116],"CRISP-DM":[118],"(Cross-Industry":[119],"Standard":[120],"Process":[121],"Data":[123],"Mining)":[124],"methodology":[125],"was":[126,154,174],"adopted,":[127],"which":[128],"suitable":[130],"projects":[134],"comprises":[136],"six":[137],"phases:":[138],"business":[139],"understanding,":[140,142],"preparation,":[144],"modeling,":[145],"evaluation,":[146],"deployment.":[148],"As":[149],"result,":[151],"designed,":[155],"developed,":[156],"implemented":[158],"expand":[160],"PostgreSQL's":[161,234],"functionalities":[162],"that":[163,228,254],"made":[164],"it":[165,229],"possible":[166,231],"execute":[168],"efficiently.":[171],"solution":[173],"validated":[175],"through":[176,237],"comparative":[177],"tests":[178],"against":[179],"specialized":[180],"tools":[181],"such":[182],"as":[183],"Weka":[184],"KNIME,":[186,205],"showing":[187],"consistent":[188],"high-quality":[190],"results":[191],"grouping.":[194],"maintains":[197],"lower":[198],"response":[199],"times":[200],"compared":[201],"WEKA":[203],"its":[207],"performance":[208],"optimal":[210],"high":[212],"exercises":[217],"greater":[219],"dimensional":[220],"complexity.":[221],"In":[222],"conclusion,":[223],"developed":[225],"demonstrates":[227],"enhance":[233],"analytical":[235],"algorithms.":[243],"represents":[246],"viable":[248],"accessible":[250],"alternative":[251],"perform":[257],"advanced":[258],"analysis":[260],"depending":[262],"platforms.":[265]},"counts_by_year":[],"updated_date":"2026-11-08T12:12:28.789561","created_date":"2026-04-18T00:00:00"}