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

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.

PDF [267 KB]

Author

Rob Schoedel

This report is related to the following area(s) of work:

Process Improvement

Technical Note
CMU/SEI-2006-TN-017
May 2006

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://www.sei.cmu.edu/library/abstracts/reports/06tn017.cfm

IEEE:

R. Schoedel, "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://www.sei.cmu.edu/library/abstracts/reports/06tn017.cfm

APA:

Schoedel, R., (2006). PROxy Based Estimation (PROBE) for Structured Query Language (SQL) (CMU/SEI-2006-TN-017). Retrieved May 24, 2013, from the Software Engineering Institute, Carnegie Mellon University website: http://www.sei.cmu.edu/library/abstracts/reports/06tn017.cfm

CHI:

Schoedel, Robert, PROxy Based Estimation (PROBE) for Structured Query Language (SQL) (CMU/SEI-2006-TN-017). Pittsburgh, PA: Software Engineering Institute, Carnegie Mellon University, 2006. http://www.sei.cmu.edu/library/abstracts/reports/06tn017.cfm

MLA:

Schoedel, R., 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://www.sei.cmu.edu/library/abstracts/reports/06tn017.cfm

Find Us Here

Find us on Youtube  Find us on LinkedIn  Find us on twitter  Find us on Facebook

Share This Page

Share on Facebook  Send to your Twitter page  Save to del.ico.us  Save to LinkedIn  Digg this  Stumble this page.  Add to Technorati favorites  Save this page on your Google Home Page 

For more information

Contact Us

info@sei.cmu.edu

412-268-5800

Help us improve

Visitor feedback helps us continually improve our site.

Please tell us what you
think with this short
(< 5 minute) survey.