Software Engineering Institute | Carnegie Mellon University
Software Engineering Institute | Carnegie Mellon University

Digital Library

Javascript is currently disabled for your browser. For an optimal search experience, please enable javascript.

Advanced Search

Basic Search

Content Type

Topics

Publication Date

Technical Note

PROxy Based Estimation (PROBE) for Structured Query Language (SQL)

  • May 2006
  • By Rob Schoedel
  • This 2006 report outlines a method for applying the PROxy Based Estimation (PROBE) technique to Structured Query Language (SQL).
  • Process Improvement
  • Publisher: Software Engineering Institute
    CMU/SEI Report Number: CMU/SEI-2006-TN-017
  • Abstract

    This paper presents a method for applying the PROxy Based Estimation (PROBE) technique to Structured Query Language (SQL). Estimating program size is a critical component of successful software project effort estimation and cost estimation. The PROBE technique is a simple estimation method that can be used for estimating program size and effort. To date, PROBE has been used more often to estimate programs written in third-generation programming languages (3GL) such as C, C++, and Java. Its application to IT development has been inhibited by the lack of demonstrated applicability to database work. For data storage, most IT departments have transitioned from file-oriented storage (accessed by traditional 3GL languages) to relational database server software, which uses an implementation of 4GL languages such as SQL to manipulate data. SQL's logic encapsulation properties differ dramatically from those of traditional 3GL languages, so it is not clear to most developers how to effectively apply the PROBE techniques to SQL. The method presented here enables a level of estimation detail similar to the application of PROBE to traditional 3GL languages.

  • Download

Cite This Report

SEI

Schoedel, Robert. PROxy Based Estimation (PROBE) for Structured Query Language (SQL). CMU/SEI-2006-TN-017. Software Engineering Institute, Carnegie Mellon University. 2006. http://resources.sei.cmu.edu/library/asset-view.cfm?AssetID=7911

IEEE

Schoedel. Robert, "PROxy Based Estimation (PROBE) for Structured Query Language (SQL)," Software Engineering Institute, Carnegie Mellon University, Pittsburgh, Pennsylvania, Technical Note CMU/SEI-2006-TN-017, 2006. http://resources.sei.cmu.edu/library/asset-view.cfm?AssetID=7911

APA

Schoedel, Robert. (2006). PROxy Based Estimation (PROBE) for Structured Query Language (SQL) (CMU/SEI-2006-TN-017). Retrieved October 16, 2017, from the Software Engineering Institute, Carnegie Mellon University website: http://resources.sei.cmu.edu/library/asset-view.cfm?AssetID=7911

CHI

Robert Schoedel. PROxy Based Estimation (PROBE) for Structured Query Language (SQL) (CMU/SEI-2006-TN-017). Pittsburgh, PA: Software Engineering Institute, Carnegie Mellon University, 2006. http://resources.sei.cmu.edu/library/asset-view.cfm?AssetID=7911

MLA

Schoedel, Robert. 2006. PROxy Based Estimation (PROBE) for Structured Query Language (SQL) (Technical Report CMU/SEI-2006-TN-017). Pittsburgh: Software Engineering Institute, Carnegie Mellon University. http://resources.sei.cmu.edu/library/asset-view.cfm?AssetID=7911

BibTex

@techreport{SchoedelPROxyBased2006,
title={PROxy Based Estimation (PROBE) for Structured Query Language (SQL)},
author={Robert Schoedel},
year={2006},
number={CMU/SEI-2006-TN-017},
institution={Software Engineering Institute, Carnegie Mellon University},
address={Pittsburgh, PA},
url={http://resources.sei.cmu.edu/library/asset-view.cfm?AssetID=7911} }