| Publisher | University of California | ||
|---|---|---|---|
| Format | 240.2KB PDF | Date added | 08 Sep 2006 |
| Topics | Database Management, Database Applications | ||
| Downloads | 12 | ||
Many data-intensive applications dynamically construct queries in response to client requests and execute them. Java servlets, e.g., can create string representations of SQL queries and then send the queries, using JDBC, to a database server for execution. The servlet programmer enjoys static checking via Java's strong type system. However, the Java type system does little to check for possible errors in the dynamically generated SQL query strings. Thus, a type error in a generated selection query can result in an SQL runtime exception. Currently, such defects must be rooted out through careful testing, or (worse) might be found by customers at runtime. This paper presents a sound, static, program analysis technique to verify the correctness of dynamically generated query strings.
Did you find this white paper useful?
25 out of 50 users found this white paper useful
Related white papers
Realising the benefits of going green
Cross over to greener communications with improved data accuracy. Many organisations have processes in place to improve the quality of their contact data to address business drivers, such as cost reduction...
Creating a Dynamic Infrastructure through Virtualization
In almost every case,the transformation to a dynamic infrastructure will involve virtualization.Many IT professionals think of virtualization specifically in terms of servers.IBM,however,has a broader perspective,in which virtualization is seen as...
Dynamic Infrastructure Helping Build a Smarter PlanetDelivering Superior Business and IT Services with Agility and Speed
In this smarter world, we need our infrastructure to propel us forward, not hold us back. This infrastructure becomes instrumented, interconnected and intelligent to bring together the business and IT...
IBM Virtualization Services
Virtualization is a powerful technology and can have profound effects on the datacenter; however, it should be viewed as a component of an overall IT strategy that will be able...
MSC Industrial Direct- customer case study
"Following a company merger, MSC Industrial Direct Co. found that duplicate customer records were disrupting the business workflow and causing sales compensation issues. MSC Industrial Direct Co. implemented the Pitney Bowes Business...
Customer Data Quality Platform from Pitney Bowes Business Insight - a Butler Group Technology Audit report
Pitney Bowes Customer Data Quality Platform (CDQP) is a domain-specific customer data quality management system that enables tasks such as integration, cleansing, matching, profiling, monitoring, and enriching the data with...
Data Quality Considerations for a Master Data Management Structure
Companies acquiring companies. Human Resources sharing information with Finance. Businesses spanning multiple countries. What do all of these scenarios have in common? The sharing of data. What is the critical...
