embedded sql inserts sql statements into the host programming language and executes them at program run time. sql injection is a known attack technique;however, detection techniques are not introduced in embedded sql....
详细信息
embedded sql inserts sql statements into the host programming language and executes them at program run time. sql injection is a known attack technique;however, detection techniques are not introduced in embedded sql. This paper introduces a technique based on candidate code generation that can detect sql injection vulnerability in the C/C++ host programming language.
We present sqlInspect, a tool intended to assist developers who deal with sql code embedded in Java applications. It is integrated into Eclipse as a plug-in that is able to extract sql queries from Java code through s...
详细信息
ISBN:
(纸本)9781450356633
We present sqlInspect, a tool intended to assist developers who deal with sql code embedded in Java applications. It is integrated into Eclipse as a plug-in that is able to extract sql queries from Java code through static string analysis. It parses the extracted queries and performs various analyses on them. As a result, one can readily explore the source code which accesses a given part of the database, or which is responsible for the construction of a given sql query. sql-related metrics and common coding mistakes are also used to spot inefficiently or defectively performing sql statements and to identify poorly designed classes, like those that construct many queries via complex control-flow paths. sqlInspect is a novel tool that relies on recent query extraction approaches. It currently supports Java applications working with JDBC and sql code written for Mysql or Apache Impala. Check out the live demo of sqlInspect at http://***/similar to cnagy/sqlinspect.
This paper describes proposed research into the development of various software engineering tools to aid engineers in the management of embedded sql statements. It addresses the problem of recovering embedded sql from...
详细信息
ISBN:
(纸本)9781450306867
This paper describes proposed research into the development of various software engineering tools to aid engineers in the management of embedded sql statements. It addresses the problem of recovering embedded sql from source-code files, and identifies existing tactics for doing so. It then provides mid-high level descriptions of basic tools that could be developed on top of such a parsing tool, to form an extensible tool-kit that will then be used as the basis for a GUI implementation, with focuses on ease-of-use for developers.
Multi-tenancy is a kind of technology full of business value in industry. It focuses on how to isolate and protect customer data in the same hardware and software platform. This paper makes research on multi-tenancy i...
详细信息
Testing is a critical activity for database application programs as faults if undetected could lead to unrecoverable data loss. Database application programs typically contain statements written in an imperative progr...
详细信息
ISBN:
(纸本)0769513727
Testing is a critical activity for database application programs as faults if undetected could lead to unrecoverable data loss. Database application programs typically contain statements written in an imperative programming language with embedded data manipulation commands, such as sql. However relatively little study has been made in the testing of database application programs. In particular, few testing techniques explicitly consider the inclusion of database instances in the selection of test cases and the generation of test data input. In this paper we study the generation of database instances that respect the semantics of sql statements embedded in a database application program. The paper also describes a supporting tool which generates a set of constraints. These constraints collectively represent a property against which the program is tested. Database instances for program testing can be derived by solving the set of constraints using existing constraint solvers.
We developed an assembly line to implement certain specific changes in a stockbroking system written in COBOL with embedded sql. The changes were proposed by the maintenance team of the system. Using our architecture,...
详细信息
ISBN:
(纸本)0769501796
We developed an assembly line to implement certain specific changes in a stockbroking system written in COBOL with embedded sql. The changes were proposed by the maintenance team of the system. Using our architecture, it took a few hours to implement the conditional transformations from the code examples we obtained from the maintenance team. Then we could carry out the tasks completely automated. We report on the transformations, their implementation and the architecture we used. It is the intention of the company that owns the COBOL/sql to use our architecture for similar tasks. This study was carried out in order to give the company that owns the code an indication of the effort it takes, the development process of the components that carry out such tasks, and the process to change software using our architecture.
暂无评论