Adding Vector and Matrix Support to SimSQL

dc.contributor.advisorJermaine, Chrisen_US
dc.creatorLuo, Shangyuen_US
dc.date.accessioned2017-08-02T17:50:53Zen_US
dc.date.available2017-08-02T17:50:53Zen_US
dc.date.created2016-05en_US
dc.date.issued2016-04-22en_US
dc.date.submittedMay 2016en_US
dc.date.updated2017-08-02T17:50:53Zen_US
dc.description.abstractIn this thesis, I consider the problem of making linear algebra simple to use and efficient to run in a relational database management system. Relational database systems are widely used, and much of the data in the world is stored within them. Having linear algebra integrated into a relational database would provide great support for tasks such as in-database analytics and in-database machine learning. Currently, when it is necessary to perform such analyses, one must either extract the data from a database, and use an external tool such as MATLAB, or else use awkward, existing within-the-database linear algebra facilities. In this thesis, I will focus on my four main contributions: (1) I add vector and matrix types to SQL, the most commonly-used database programming language; (2) I design a few simple SQL language extensions to accommodate vectors and matrices; (3) I consider the problem of making vector and matrix operations efficient via integration with the database query optimizer; and (4) I conduct some experiments to show the efficacy of my language extensions.en_US
dc.format.mimetypeapplication/pdfen_US
dc.identifier.citationLuo, Shangyu. "Adding Vector and Matrix Support to SimSQL." (2016) Master’s Thesis, Rice University. <a href="https://hdl.handle.net/1911/96227">https://hdl.handle.net/1911/96227</a>.en_US
dc.identifier.urihttps://hdl.handle.net/1911/96227en_US
dc.language.isoengen_US
dc.rightsCopyright is held by the author, unless otherwise indicated. Permission to reuse, publish, or reproduce the work beyond the bounds of fair use or other exemptions to copyright law must be obtained from the copyright holder.en_US
dc.subjectVector/Matrixen_US
dc.subjectLinear Algebraen_US
dc.subjectRDBMSen_US
dc.subjectSQLen_US
dc.titleAdding Vector and Matrix Support to SimSQLen_US
dc.typeThesisen_US
dc.type.materialTexten_US
thesis.degree.departmentComputer Scienceen_US
thesis.degree.disciplineEngineeringen_US
thesis.degree.grantorRice Universityen_US
thesis.degree.levelMastersen_US
thesis.degree.nameMaster of Scienceen_US
Files
Original bundle
Now showing 1 - 1 of 1
Loading...
Thumbnail Image
Name:
LUO-DOCUMENT-2016.pdf
Size:
2.01 MB
Format:
Adobe Portable Document Format
License bundle
Now showing 1 - 2 of 2
No Thumbnail Available
Name:
PROQUEST_LICENSE.txt
Size:
5.84 KB
Format:
Plain Text
Description:
No Thumbnail Available
Name:
LICENSE.txt
Size:
2.6 KB
Format:
Plain Text
Description: