{"id":"https://openalex.org/W2065896400","doi":"https://doi.org/10.1145/2396761.2398605","title":"Fast PCA computation in a DBMS with aggregate UDFs and LAPACK","display_name":"Fast PCA computation in a DBMS with aggregate UDFs and LAPACK","publication_year":2012,"publication_date":"2012-10-29","ids":{"openalex":"https://openalex.org/W2065896400","doi":"https://doi.org/10.1145/2396761.2398605","mag":"2065896400"},"language":"en","primary_location":{"id":"doi:10.1145/2396761.2398605","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2396761.2398605","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st ACM international conference on Information and knowledge management","raw_type":"proceedings-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/A5031610238","display_name":"Carlos Ordo\u0144\u1ebdz","orcid":"https://orcid.org/0009-0005-1135-9726"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Carlos Ordonez","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030817740","display_name":"Naveen Mohanam","orcid":null},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Naveen Mohanam","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035134339","display_name":"Carlos Garcia-Alvarado","orcid":"https://orcid.org/0000-0002-9595-3861"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlos Garcia-Alvarado","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034907446","display_name":"Predrag T. To\u0161i\u0107","orcid":null},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Predrag T. Tosic","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042747851","display_name":"Edgar Oswaldo Pineda Mart\u00ednez","orcid":"https://orcid.org/0000-0001-6738-0237"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Edgar Martinez","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5031610238"],"corresponding_institution_ids":["https://openalex.org/I44461941"],"apc_list":null,"apc_paid":null,"fwci":1.4638,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.82054993,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"2219","last_page":"2223"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9962000250816345,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9962000250816345,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T11697","display_name":"Numerical Methods and Algorithms","score":0.9921000003814697,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T12303","display_name":"Tensor decomposition and applications","score":0.9876000285148621,"subfield":{"id":"https://openalex.org/subfields/2605","display_name":"Computational Mathematics"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.8572198152542114},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.7499730587005615},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6741434931755066},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6269103288650513},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5954976081848145},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5573750138282776},{"id":"https://openalex.org/keywords/singular-value-decomposition","display_name":"Singular value decomposition","score":0.5539681315422058},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5521878600120544},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3672986626625061},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3565613031387329},{"id":"https://openalex.org/keywords/computational-science","display_name":"Computational science","score":0.3252992630004883},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18078699707984924}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8572198152542114},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7499730587005615},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6741434931755066},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6269103288650513},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5954976081848145},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5573750138282776},{"id":"https://openalex.org/C22789450","wikidata":"https://www.wikidata.org/wiki/Q420904","display_name":"Singular value decomposition","level":2,"score":0.5539681315422058},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5521878600120544},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3672986626625061},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3565613031387329},{"id":"https://openalex.org/C459310","wikidata":"https://www.wikidata.org/wiki/Q117801","display_name":"Computational science","level":1,"score":0.3252992630004883},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18078699707984924},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2396761.2398605","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2396761.2398605","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st ACM international conference on Information and knowledge management","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.364.6833","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.364.6833","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.uh.edu//people/faculty/ordonez/w-2012-CIKM-udfsvd.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1760551737","https://openalex.org/W1966558147","https://openalex.org/W1966901553","https://openalex.org/W1985118052","https://openalex.org/W2095597068"],"related_works":["https://openalex.org/W2378211422","https://openalex.org/W4321353415","https://openalex.org/W2745001401","https://openalex.org/W2130974462","https://openalex.org/W2028665553","https://openalex.org/W2086519370","https://openalex.org/W972276598","https://openalex.org/W4246352526","https://openalex.org/W2121910908","https://openalex.org/W915438175"],"abstract_inverted_index":{"Efficient":[0],"and":[1,43,78,96,102,130,162],"scalable":[2],"execution":[3],"of":[4],"numerical":[5,20,45,60,84],"methods":[6,46,85],"inside":[7],"a":[8,149],"DBMS":[9],"is":[10,15,111],"difficult":[11],"as":[12],"its":[13],"architecture":[14],"not":[16],"suited":[17],"for":[18],"intense":[19],"computations.":[21],"We":[22,93,108,144],"study":[23,65],"computing":[24],"Principal":[25],"Component":[26],"Analysis":[27],"(PCA)":[28],"on":[29,47,148,158],"large":[30],"data":[31,71,121,160],"sets":[32],"via":[33,89,142],"Singular":[34],"Value":[35],"Decomposition":[36],"(SVD).":[37],"Given":[38],"the":[39,58,70,120,159],"difficulty":[40],"to":[41,68,80,99,103,113,138],"program":[42],"optimize":[44],"an":[48,53],"existing":[49],"DBMS,":[50],"we":[51,64],"explore":[52],"alternative":[54],"reusability":[55],"approach:":[56],"calling":[57,140],"well-known":[59],"library":[61],"LAPACK.":[62],"Thus":[63],"several":[66],"alternatives":[67],"summarize":[69],"set":[72,122,161],"with":[73,123,127],"aggregate":[74,128],"User-Defined":[75],"Functions":[76],"(UDFs)":[77],"how":[79],"efficiently":[81,114],"call":[82],"SVD":[83,137],"available":[86],"in":[87,136],"LAPACK":[88,141],"Stored":[90],"Procedures":[91],"(SPs).":[92],"propose":[94],"algorithmic":[95],"system":[97],"optimizations":[98],"enhance":[100],"scalability":[101],"push":[104],"processing":[105,135],"into":[106],"RAM.":[107],"show":[109],"it":[110,163],"feasible":[112],"solve":[115],"PCA":[116],"by":[117],"first":[118],"summarizing":[119],"arrays":[124],"incrementally":[125],"updated":[126],"UDFs":[129],"then":[131],"pushing":[132],"heavy":[133],"matrix":[134],"RAM":[139],"SPs.":[143],"benchmark":[145],"our":[146],"solution":[147,153],"modern":[150],"DBMS.":[151],"Our":[152],"requires":[154],"only":[155],"one":[156],"pass":[157],"exhibits":[164],"linear":[165],"scalability.":[166]},"counts_by_year":[{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}