| Publisher | University of California | ||
|---|---|---|---|
| Format | 240.2KB PDF | Date added | 08 Sep 2006 |
| Topics | Database Management, Database Applications | ||
| Downloads | 2 | ||
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?
22 out of 41 users found this white paper useful
Related white papers
Maxmise IT Flexibility and Lower Costs With Grid Computing
This document discusses grid computing: Oracle's definition of it, the benefits of it, and the elements that comprise an Oracle Enterprise Grid Computing environment. It also highlights an Oracle customer's...
Ten Things to Know About Grid Computing on Windows
This Oracle whitepaper offers insights into Oracle Grid. A grid allows a business to add capacity, cheaply, whenever it is needed. What's more, an Oracle Grid can help you gain control...
The ROI of Data Governance - A Revenue Generation Perspective
"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). This white paper from Gwen Thomas of the Data Governance Institute provides a practical...
BPM Done Right: 15 Ways To Succeed Where Others Have Failed
Business Process Management (BPM) promises are real, but the path to success is littered with pitfalls and shortcuts to failure. Adopting best practices gained from our wealth of experience can...
Building a Data Quality Scorecard for Operational Data Governance
" Operational data governance is the manifestation of the processes and protocols necessary to ensure that an acceptable level of confidence in the data effectively satisfies the organization's business needs....
MDM Components and the Maturity Model
Any effective master data management program requires a mix of technologies to achieve success. This white paper by David Loshin provides a conceptual outline of technical MDM components and examines...
IBM Information Server Change Data Capture
In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily,...
