Engineering with Semantic

Formal semantics of SQL queries

The documentation of a database includes its conceptual schema, that formalizes the semantics of the data, and its logical schema that translates the former according to an operational database model. Important engineering processes such as database and program evolution rely on a complete and accurate database documentation. In many cases, however, these schemas are missing, or, at best, incomplete and outdated. Their reconstruction, a process called database reverse engineering, requires DDL code analysis but, more important, the elicitation of implicit constructs (data structures and constraints), that is, constructs that have been incompletely translated into the operational database schema. The most powerful discovery technique of these implicit constructs is the static analysis of application program source code, and, in particular of embedded SQL statements. Unfortunately, the increasing use of dynamic SQL in business applications development makes such techniques helpless, so that modern web software systems can no longer be correctly redocumented through current reverse engineering techniques. This paper introduces and evaluates dynamic SQL capturing and analysis techniques and shows that they can replace and even improve upon pure static analysis. A real world case study is presented and discussed.

You might also like
Microsoft Access: Table and query naming conventions
Microsoft Access: Table and query naming conventions ...
Discover HDP 2.2: Even Faster SQL Queries with Apache Hive
Discover HDP 2.2: Even Faster SQL Queries with Apache Hive ...
Discover HDP 2.1: Interactive SQL Query in Hadoop with
Discover HDP 2.1: Interactive SQL Query in Hadoop with ...
Amazon Kubuntu 10.04 Desktop Edition
Software (Amazon)
  • Kubuntu 10.04 LTS brings you a stable, innovative and attractive platform for all your desktop needs
  • Latest version of the popular Plasma Desktop provides improved system tray with widgets, improved semantic search, new features such as window grouping
  • Amarok 2.3 media player features many bugfixes, enhancements, and visual changes, such as the new main toolbar and better podcast support
  • New touchpad configuration section of System Settings allows you to fine-tune how your laptop s touchpad behaves
  • Improved Firefox integration, with native file dialogs and compliance to default application choices for opening files
Related Posts