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.
This report is related to the following area(s) of work:
Process ImprovementTechnical Note
CMU/SEI-2006-TN-017
May 2006
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 25, 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
For more information