Title
Optimising Conceptual Data Models Through Profiling In Object Databases
Abstract
Agile methods promote iterative development with short cycles, where user feedback from the previous iteration is used to refactor and improve the current version. For information systems development, we propose to extend this feedback loop by using database profiling information to propose adaptations to the conceptual model to improve performance. For every software release, our database profiler identifies and analyses navigational access patterns, and proposes model optimisations based on data characteristics, access patterns and a cost-benefit model. The proposed model optimisations are based on common database and data model refactoring patterns. The database profiler has been implemented as part of an open-source object database and integrated into an existing agile development environment, where the model optimisations are presented as part of the IDE. We evaluate our approach based on an example of agile development of a research publication system.
Year
DOI
Venue
2013
10.1007/978-3-642-41924-9_24
CONCEPTUAL MODELING, ER 2013
Keywords
Field
DocType
database profiling, object database, model optimisation
Data modeling,Data mining,Database model,Computer science,Database design,Database testing,Agile software development,Database schema,Database theory,Data model,Database
Conference
Volume
ISSN
Citations 
8217
0302-9743
2
PageRank 
References 
Authors
0.36
10
4
Name
Order
Citations
PageRank
Tilmann Zäschke1202.59
Stefania Leone28311.18
Tobias Gmünder320.70
Moira C. Norrie41317201.70