SQL database design static analysis

Simple item page
dc.contributor.advisorKrasner, Herb
dc.contributor.advisorPerry, Dewayne E.
dc.creatorDooms, Joshua Harolden
dc.date.accessioned2014-10-14T21:56:32Zen
dc.date.accessioned2018-01-22T22:26:58Z
dc.date.available2018-01-22T22:26:58Z
dc.date.issued2010-12en
dc.date.submittedDecember 2010en
dc.date.updated2014-10-14T21:56:32Zen
dc.descriptiontexten
dc.description.abstractStatic analysis of database design and implementation is not a new idea. Many researchers have covered the topic in detail and defined a number of metrics that are well known within the research community. Unfortunately, unlike the use of metrics in code development, the use of these metrics has not been widely adopted within the development community. It seems that a disjunction exists between the research into database design metrics and the actual use of databases in industry. This paper describes new metrics that can be used in industry to ensure that a database's current implementation supports long term scalability, to support easily developed and maintainable code, or to guide developers towards functions or design elements that can be modified to improve scalability of their data systems. In addition, this paper describes the production of a tool designed to extract these metrics from SQL Server and includes feedback from professionals regarding the usefulness of the tool and the measures contained within its output.en
dc.description.departmentElectrical and Computer Engineeringen
dc.format.mimetypeapplication/pdfen
dc.identifier.urihttp://hdl.handle.net/2152/26594en
dc.subjectSQLen
dc.subjectMetricen
dc.subjectSoftwareen
dc.subjectRDBMSen
dc.subjectORDBMSen
dc.titleSQL database design static analysisen
dc.typeThesisen

Files

Collections

University of Texas at Austin