Handling Database Schema Variability in Software Product Lines

Managing variability in a software family is crucial to software product line engineering. The existing variability management techniques, however do not particularly address database design in the context of information systems poduct lines. This paper presents a practical approach to handle variab...

Full description

Saved in:
Bibliographic Details
Published in:Proceedings / Asia Pacific Software Engineering Conference Vol. 1; pp. 331 - 338
Main Authors: Khedri, Niloofar, Khosravi, Ramtin
Format: Conference Proceeding
Language:English
Published: IEEE 01.12.2013
Subjects:
Context
Data Model Variability
Data models
Delta-Oriented Programming
Educational institutions
Programming
Software
Software Product Line Engineering
Unified modeling language
ISSN:1530-1362
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Abstract Managing variability in a software family is crucial to software product line engineering. The existing variability management techniques, however do not particularly address database design in the context of information systems poduct lines. This paper presents a practical approach to handle variability in database design for families of software. We use the technique of Delta-Oriented Programming when a product is constructed by adding a number of delta modules to a core module incrementally, based on the features selected in the product configuration. We use SQL Data Definition Language to model core and delta modules. We present rules for consistency checking of the delta scripts based on the database consistency constraints to generate a valid consistent database schema for the product. Also we analyze the cases in which a conflict arises based on inconsistencies between delta modules. The fact that DDL is widely known to software developers, along with modularity and scalability of the proposed method makes it suitable to be used in industrial real world applications.
AbstractList Managing variability in a software family is crucial to software product line engineering. The existing variability management techniques, however do not particularly address database design in the context of information systems poduct lines. This paper presents a practical approach to handle variability in database design for families of software. We use the technique of Delta-Oriented Programming when a product is constructed by adding a number of delta modules to a core module incrementally, based on the features selected in the product configuration. We use SQL Data Definition Language to model core and delta modules. We present rules for consistency checking of the delta scripts based on the database consistency constraints to generate a valid consistent database schema for the product. Also we analyze the cases in which a conflict arises based on inconsistencies between delta modules. The fact that DDL is widely known to software developers, along with modularity and scalability of the proposed method makes it suitable to be used in industrial real world applications.
Author Khosravi, Ramtin
Khedri, Niloofar
Author_xml – sequence: 1
  givenname: Niloofar
  surname: Khedri
  fullname: Khedri, Niloofar
  email: nkhedri@ut.ac.ir
  organization: Sch. of Electr. & Comput. Eng., Univ. of Tehran, Tehran, Iran
– sequence: 2
  givenname: Ramtin
  surname: Khosravi
  fullname: Khosravi, Ramtin
  email: r.khosravi@ut.ac.ir
  organization: Sch. of Electr. & Comput. Eng., Univ. of Tehran, Tehran, Iran
BookMark eNotzE1LwzAYAOAIE1ynR09e8gda33y1zUUYdTqh4KDqdbxN3mhkS6WtyP69Bz09tydjizQkYuxaQCEE2Nv1rts0hQShCiPPWCZ0Za0UWsOCLYVRkAtVyguWTdMngAQNZsnutpj8IaZ3fo8z9jgR79wHHZG_4Rixj4c4n3hMvBvC_IMj8d04-G838zYmmi7ZecDDRFf_rtjrw-al2ebt8-NTs27zKCoz56EKXjtPXsoQjDGV6sEFKxW5IHRPiHUpe18KclQHZZ110tdOV1hXoAyoFbv5eyMR7b_GeMTxtC9rMFoq9QuPYEm6
CODEN IEEPAD
ContentType Conference Proceeding
DBID 6IE
6IL
CBEJK
RIE
RIL
DOI 10.1109/APSEC.2013.52
DatabaseName IEEE Electronic Library (IEL) Conference Proceedings
IEEE Proceedings Order Plan All Online (POP All Online) 1998-present by volume
IEEE Xplore All Conference Proceedings
IEEE Electronic Library (IEL)
IEEE Proceedings Order Plans (POP All) 1998-Present
DatabaseTitleList
Database_xml – sequence: 1
  dbid: RIE
  name: IEEE Electronic Library (IEL)
  url: https://ieeexplore.ieee.org/
  sourceTypes: Publisher
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISBN 1479921440
9781479921430
1479921432
9781479921447
EndPage 338
ExternalDocumentID 6805423
Genre orig-research
GroupedDBID 29O
6IE
6IF
6IK
6IL
6IN
AAJGR
AAWTH
ABLEC
ADZIZ
ALMA_UNASSIGNED_HOLDINGS
BEFXN
BFFAM
BGNUA
BKEBE
BPEOZ
CBEJK
CHZPO
IEGSK
IPLJI
M43
OCL
RIE
RIL
RNS
ID FETCH-LOGICAL-i175t-f7fd4cded22ff55573b0cf923ecf14beaa862bd61ece8f39c9c2d8c47a8703503
IEDL.DBID RIE
ISICitedReferencesCount 5
ISICitedReferencesURI http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000358736600041&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
ISSN 1530-1362
IngestDate Wed Aug 27 04:25:46 EDT 2025
IsPeerReviewed false
IsScholarly true
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-i175t-f7fd4cded22ff55573b0cf923ecf14beaa862bd61ece8f39c9c2d8c47a8703503
PageCount 8
ParticipantIDs ieee_primary_6805423
PublicationCentury 2000
PublicationDate 2013-Dec.
PublicationDateYYYYMMDD 2013-12-01
PublicationDate_xml – month: 12
  year: 2013
  text: 2013-Dec.
PublicationDecade 2010
PublicationTitle Proceedings / Asia Pacific Software Engineering Conference
PublicationTitleAbbrev apsec
PublicationYear 2013
Publisher IEEE
Publisher_xml – name: IEEE
SSID ssj0020405
ssib030096719
ssib025038997
Score 1.9116365
Snippet Managing variability in a software family is crucial to software product line engineering. The existing variability management techniques, however do not...
SourceID ieee
SourceType Publisher
StartPage 331
SubjectTerms Context
Data Model Variability
Data models
Delta-Oriented Programming
Educational institutions
Programming
Software
Software Product Line Engineering
Unified modeling language
Title Handling Database Schema Variability in Software Product Lines
URI https://ieeexplore.ieee.org/document/6805423
Volume 1
WOSCitedRecordID wos000358736600041&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlZ1LT8JAEMc3QDx4QgXjO3vwaKHdR7e9mBiEcDCEBDXcyHZ3NuFSDBSN396dtoAHL96avtJMd_c_0878hpB7ZyFlodEBB_ABirRpkDEdB1zESZhJ5H-YstmEmkyS-TydNsjDvhYGAMrkM-jhZvkv367MFj-V9f3l0st_kzSViqtard3YYRUpbi-lHH1zhaiyOvjyg1VW7NQwiPyqfeBt9p-ms-EAs7x4D-uPfnVZKUVm1P7f452Q7qFaj073OnRKGpCfkfauXQOtZ2-HPI6RqOBPoc-60Chf_hgyW-m7D5grXvc3XeZ05pfmL70u74o4WPqCufFd8jYavg7GQd0-IVh6n6AInHJWGAuWMeeklIpnoXHeoQPjIpGB1j6ayWwcgYHE8dSkhtnECKX9HObenuekla9yuCCUaRcDV0Zh-MGEzDjXUWiEYxBrocQl6aA5Fh8VIWNRW-Lq793X5BiNXSWF3JBWsd7CLTkyn8Vys74rX-sPkKKfaQ
linkProvider IEEE
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlZ1LT8JAEMcniCZ6QgXj2z14tFD20W0vJgYhGJGQgIYb2W5nEy7FYNH47d1tC3jw4q3pK810d_8z7cxvAG5NghH1tfIYog1QRBJ5MVWBx3gQ-rFw_A-dN5uQw2E4nUajCtxtamEQMU8-w6bbzP_lJwu9cp_KWvZyYeV_B3YF59QvqrXWo4cWrLiNmDLnnUsHKyvDLztcRUFP9b22Xbe3xM3Ww2jc7bg8L9Z0FUi_-qzkMtOr_e8BD6Gxrdcjo40SHUEF02OorRs2kHL-1uG-75gK9hTyqDLlBMwec9RW8mZD5oLY_U3mKRnbxflLLfO7OiAsGbjs-Aa89rqTTt8rGyh4c-sVZJ6RJuE6wYRSY4QQksW-NtalQ23aPEalbDwTJ0EbNYaGRTrSNAk1l8rOYmbteQLVdJHiKRCqTIBMaukCEMpFzJhq-5obioHikp9B3Zlj9l4wMmalJc7_3n0D-_3Jy2A2eBo-X8CBM3yRInIJ1Wy5wivY05_Z_GN5nb_iHw-CorA
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=proceeding&rft.title=Proceedings+%2F+Asia+Pacific+Software+Engineering+Conference&rft.atitle=Handling+Database+Schema+Variability+in+Software+Product+Lines&rft.au=Khedri%2C+Niloofar&rft.au=Khosravi%2C+Ramtin&rft.date=2013-12-01&rft.pub=IEEE&rft.issn=1530-1362&rft.volume=1&rft.spage=331&rft.epage=338&rft_id=info:doi/10.1109%2FAPSEC.2013.52&rft.externalDocID=6805423
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1530-1362&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1530-1362&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1530-1362&client=summon