Static analysis of dynamic database usage in java systems

Loup Meurice; Csaba Nagy; Anthony Cleve

doi:10.1007/978-3-319-39696-530

Static analysis of dynamic database usage in java systems

Research Center on Information Systems Engineering

Résultats de recherche: Contribution dans un livre/un catalogue/un rapport/dans les actes d'une conférence › Article dans les actes d'une conférence/un colloque

Résumé

Understanding the links between application programs and their database is useful in various contexts such as migrating information systems towards a new database platform, evolving the database schema, or assessing the overall system quality. In the case of Java systems, identifying which portion of the source code accesses which portion of the database may prove challenging. Indeed, Java programs typically access their database in a dynamic way. The queries they send to the database server are built at runtime, through String concatenations, or Object- Relational Mapping frameworks like Hibernate and JPA. This paper presents a static analysis approach to program-database links recovery, specifically designed for Java systems. The approach allows developers to automatically identify the source code locations accessing given database tables and columns. It focuses on the combined analysis of JDBC, Hibernate and JPA invocations. We report on the use of our approach to analyse three real-life Java systems.

langue originale	Anglais
titre	Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings
Editeur	Springer Verlag
Pages	491-506
Nombre de pages	16
Volume	9694
ISBN (imprimé)	9783319396958
Les DOIs	https://doi.org/10.1007/978-3-319-39696-530
Etat de la publication	Publié - 2016
Evénement	28th International Conference on Advanced Information Systems Engineering, CAiSE 2016 - Ljubljana, Slovénie Durée: 13 juin 2016 → 17 juin 2016

Série de publications

Nom	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume	9694
ISSN (imprimé)	03029743
ISSN (Electronique)	16113349

Une conférence

Une conférence	28th International Conference on Advanced Information Systems Engineering, CAiSE 2016
Pays/Territoire	Slovénie
La ville	Ljubljana
période	13/06/16 → 17/06/16

Accès au document

10.1007/978-3-319-39696-530

Autres fichiers et liens

Link to publication in Scopus

Analyzing, Understanding and Supporting the Evolution of Dynamic and Heterogeneous Data-Intensive Software Systems
Auteur: Meurice, L., 22 juin 2017
Superviseur: Cleve, A. (Promoteur), Englebert, V. (Président), Lanza, M. (Personne externe) (Jury), Mens, T. (Personne externe) (Jury), Frenay, B. (Jury) & Vanhoof, W. (Jury)
Student thesis: Doc types › Docteur en Sciences

Fichier

Contient cette citation

Meurice, L., Nagy, C., & Cleve, A. (2016). Static analysis of dynamic database usage in java systems. Dans Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings (Vol 9694, p. 491-506). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol 9694). Springer Verlag. https://doi.org/10.1007/978-3-319-39696-530

Meurice, Loup ; Nagy, Csaba ; Cleve, Anthony. / Static analysis of dynamic database usage in java systems. Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings. Vol 9694 Springer Verlag, 2016. p. 491-506 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).

@inproceedings{c5f2e96a6a5b4a9d803a8271500091c7,

title = "Static analysis of dynamic database usage in java systems",

abstract = "Understanding the links between application programs and their database is useful in various contexts such as migrating information systems towards a new database platform, evolving the database schema, or assessing the overall system quality. In the case of Java systems, identifying which portion of the source code accesses which portion of the database may prove challenging. Indeed, Java programs typically access their database in a dynamic way. The queries they send to the database server are built at runtime, through String concatenations, or Object- Relational Mapping frameworks like Hibernate and JPA. This paper presents a static analysis approach to program-database links recovery, specifically designed for Java systems. The approach allows developers to automatically identify the source code locations accessing given database tables and columns. It focuses on the combined analysis of JDBC, Hibernate and JPA invocations. We report on the use of our approach to analyse three real-life Java systems.",

keywords = "Database access recovery, Java, ORM, Static analysis",

author = "Loup Meurice and Csaba Nagy and Anthony Cleve",

year = "2016",

doi = "10.1007/978-3-319-39696-530",

language = "English",

isbn = "9783319396958",

volume = "9694",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer Verlag",

pages = "491--506",

booktitle = "Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings",

address = "Germany",

note = "28th International Conference on Advanced Information Systems Engineering, CAiSE 2016 ; Conference date: 13-06-2016 Through 17-06-2016",

}

Meurice, L , Nagy, C & Cleve, A 2016, Static analysis of dynamic database usage in java systems. Dans Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings. VOL. 9694, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), VOL. 9694, Springer Verlag, p. 491-506, 28th International Conference on Advanced Information Systems Engineering, CAiSE 2016, Ljubljana, Slovénie, 13/06/16. https://doi.org/10.1007/978-3-319-39696-530

Static analysis of dynamic database usage in java systems. / Meurice, Loup ; Nagy, Csaba ; Cleve, Anthony.
Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings. Vol 9694 Springer Verlag, 2016. p. 491-506 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol 9694).

Résultats de recherche: Contribution dans un livre/un catalogue/un rapport/dans les actes d'une conférence › Article dans les actes d'une conférence/un colloque

TY - GEN

T1 - Static analysis of dynamic database usage in java systems

AU - Meurice, Loup

AU - Nagy, Csaba

AU - Cleve, Anthony

PY - 2016

Y1 - 2016

N2 - Understanding the links between application programs and their database is useful in various contexts such as migrating information systems towards a new database platform, evolving the database schema, or assessing the overall system quality. In the case of Java systems, identifying which portion of the source code accesses which portion of the database may prove challenging. Indeed, Java programs typically access their database in a dynamic way. The queries they send to the database server are built at runtime, through String concatenations, or Object- Relational Mapping frameworks like Hibernate and JPA. This paper presents a static analysis approach to program-database links recovery, specifically designed for Java systems. The approach allows developers to automatically identify the source code locations accessing given database tables and columns. It focuses on the combined analysis of JDBC, Hibernate and JPA invocations. We report on the use of our approach to analyse three real-life Java systems.

AB - Understanding the links between application programs and their database is useful in various contexts such as migrating information systems towards a new database platform, evolving the database schema, or assessing the overall system quality. In the case of Java systems, identifying which portion of the source code accesses which portion of the database may prove challenging. Indeed, Java programs typically access their database in a dynamic way. The queries they send to the database server are built at runtime, through String concatenations, or Object- Relational Mapping frameworks like Hibernate and JPA. This paper presents a static analysis approach to program-database links recovery, specifically designed for Java systems. The approach allows developers to automatically identify the source code locations accessing given database tables and columns. It focuses on the combined analysis of JDBC, Hibernate and JPA invocations. We report on the use of our approach to analyse three real-life Java systems.

KW - Database access recovery

KW - Java

KW - ORM

KW - Static analysis

UR - http://www.scopus.com/inward/record.url?scp=84976641951&partnerID=8YFLogxK

U2 - 10.1007/978-3-319-39696-530

DO - 10.1007/978-3-319-39696-530

M3 - Conference contribution

AN - SCOPUS:84976641951

SN - 9783319396958

VL - 9694

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 491

EP - 506

BT - Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings

PB - Springer Verlag

T2 - 28th International Conference on Advanced Information Systems Engineering, CAiSE 2016

Y2 - 13 June 2016 through 17 June 2016

ER -

Meurice L , Nagy C , Cleve A. Static analysis of dynamic database usage in java systems. Dans Advanced Information Systems Engineering - 28th International Conference, CAiSE 2016, Proceedings. Vol 9694. Springer Verlag. 2016. p. 491-506. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). doi: 10.1007/978-3-319-39696-530

Static analysis of dynamic database usage in java systems

Résumé

Série de publications

Une conférence

Accès au document

Autres fichiers et liens

Empreinte digitale

Thèses de l'étudiant

Analyzing, Understanding and Supporting the Evolution of Dynamic and Heterogeneous Data-Intensive Software Systems

Contient cette citation