NDLI: Documenting database usages and schema constraints in database-centric applications

Please wait, while we are loading the content...

DEKANT: a static analysis tool that learns to detect web application vulnerabilities

Binary code is not easy

Generating focused random tests using directed swarm testing

CSNIPPEX: automated synthesis of compilable code snippets from Q&A sites

Practitioners' expectations on automated fault localization

Automatic generation of oracles for exceptional behaviors

DSI: an evidence-based approach to identify dynamic data structures in C programs

Semantic modelling of Android malware for effective malware comprehension, detection, and classification

Mutation-aware fault prediction

Efficient race detection in the presence of programmatic event loops

Zero-overhead profiling via EM emanations

COSTOTest: a tool for building and running test harness for service-based component models (demo)

Automated and effective testing of web services for XML injection attacks

Specification of concretization and symbolization policies in symbolic execution

Monkey see, monkey do: effective generation of GUI tests with inferred macro events

Automatic test case generation: what if test code quality matters?

A learning-to-rank based fault localization approach using likely invariants

Verdict machinery: on the need to automatically make sense of test results

Documenting database usages and schema constraints in database-centric applications

DroidRA: taming reflection to support whole-program analysis of Android apps

Predictive mutation testing

Automatically verifying and reproducing event-based races in Android apps

Efficient flow profiling for detecting performance bugs

ASTOR: a program repair library for Java (demo)

EagerMerge: an optimistic technique for efficient points-to analysis

Sapienz: multi-objective automated testing for Android applications

Analyzing test completeness for dynamic languages

Optimal sanitization synthesis for web application vulnerability repair

Testing stochastic software using pseudo-oracles

Exploring regular expression usage and context in Python

Threats to the validity of mutation-based test assessment

SyncProf: detecting, localizing, and optimizing synchronization bottlenecks

Energy-aware test-suite minimization for Android apps

Jolinar: analysing the energy footprint of software applications (demo)

IPA: improving predictive analysis with pointer analysis

FSX: fine-grained incremental unit test generation for C/C++ programs

Unveiling anomalies and their impact on software quality in model-based automotive software revisions with software metrics and domain experts

ARROW: automated repair of races on client-side web pages

Test oracle assessment and improvement

Toward understanding compiler bugs in GCC and LLVM

PIT: a practical mutation testing tool for Java (demo)

Documenting database usages and schema constraints in database-centric applications

Content Provider	ACM Digital Library
Author	Poshyvanyk, Denys Linares-Vásquez, Mario Li, Boyang Vendome, Christopher
Abstract	Database-centric applications (DCAs) usually rely on database operations over a large number of tables and attributes. Understanding how database tables and attributes are used to implement features in DCAs along with the constraints related to these usages is an important component of any DCA’s maintenance. However, manually documenting database related operations and their asynchronously evolving constraints in constantly changing source code is a hard and time-consuming problem. In this paper, we present a novel approach, namely DBScribe, aimed at automatically generating always up-to-date natural language descriptions of database operations and schema constraints in source code methods. DBScribe statically analyzes the code and database schema to detect database usages and then prop- agates these usages and schema constraints through the call-chains implementing database-related features. Finally, each method in these call-chains is automatically documented based on the underlying database usages and constraints. We evaluated DBScribe in a study with 52 participants analyzing generated documentation for database-related methods in five open-source DCAs. Additionally, we evaluated the descriptions generated by DBScribe on two commercial DCAs involving original developers. The results for the studies involving open-source and commercial DCAs demonstrate that generated descriptions are accurate and useful while understanding database usages and constraints, in particular during maintenance tasks. .
Starting Page	270
Ending Page	281
Page Count	12
File Format	PDF
ISBN	9781450343909
DOI	10.1145/2931037.2931072
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2016-07-18
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Schema constraints Documentation Sql-data statements Database-centric applications
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Sql dom: compile time checking of dynamic sql statements

Schema Conversion Model of SQL Database to NoSQL

A Generator of SQL Schema Specifications

A generator of sql schema specifications.

Abstract No-Schema SQL (NS-SQL): Querying Relational Databases Independent of Schema

Leveraging Data Analytics by Transforming Relational Database Schema in to Big Data

Sql fiddle reference.

Udc 004.43 a generator of sql schema specifications.

JSON data management: supporting schema-less development in RDBMS

Documenting database usages and schema constraints in database-centric applications

Similar Documents

Sql dom: compile time checking of dynamic sql statements

Schema Conversion Model of SQL Database to NoSQL

A Generator of SQL Schema Specifications

A generator of sql schema specifications.

Abstract No-Schema SQL (NS-SQL): Querying Relational Databases Independent of Schema

Leveraging Data Analytics by Transforming Relational Database Schema in to Big Data

Sql fiddle reference.

Udc 004.43 a generator of sql schema specifications.

JSON data management: supporting schema-less development in RDBMS

Documenting database usages and schema constraints in database-centric applications