Adding Vector and Matrix Support to SimSQL

Simple item page
dc.contributor.advisorJermaine, Chris
dc.creatorLuo, Shangyu
dc.date.accessioned2017-08-02T17:50:53Z
dc.date.available2017-08-02T17:50:53Z
dc.date.created2016-05
dc.date.issued2016-04-22
dc.date.submittedMay 2016
dc.date.updated2017-08-02T17:50:53Z
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.
dc.format.mimetypeapplication/pdf
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>.
dc.identifier.urihttps://hdl.handle.net/1911/96227
dc.language.isoeng
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.
dc.subjectVector/Matrix
dc.subjectLinear Algebra
dc.subjectRDBMS
dc.subjectSQL
dc.titleAdding Vector and Matrix Support to SimSQL
dc.typeThesis
dc.type.materialText
thesis.degree.departmentComputer Science
thesis.degree.disciplineEngineering
thesis.degree.grantorRice University
thesis.degree.levelMasters
thesis.degree.nameMaster of Science
Files
Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
LUO-DOCUMENT-2016.pdf
Size:
2.01 MB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 2 of 2
No Thumbnail Available
Name:
PROQUEST_LICENSE.txt
Size:
5.84 KB
Format:
Plain Text
Description:
Download
No Thumbnail Available
Name:
LICENSE.txt
Size:
2.6 KB
Format:
Plain Text
Description:
Download
Collections
Rice University Electronic Theses and Dissertations