Schema Evolution in Federated Information Systems

Author(s):  
Susanne Busse ◽  
Claudia Pons
Author(s):  
Zouhaier Brahmia ◽  
Fabio Grandi ◽  
Barbara Oliboni ◽  
Rafik Bouaziz

In information systems, changing the database schema is a common but often troublesome task in database administration that is needed for many reasons such as changes in user requirements, compliance to new regulations, addition of new functionalities, or correction of deficiencies in the current schema. For most database applications, changing the schema of the database without loss of existing data is a significant challenge: it is usually a time-consuming and error-prone task which must be done carefully. In the literature, schema evolution has been defined as the modality for the management of schema changes which relieves database programmers and administrators from this burden, by automatically recovering extant data and possibly adapting them to the new schema. The main goal of this chapter is to present the recent research proposals that deal with schema evolution in traditional and emerging databases and to discuss the recent advances on schema evolution support in mainstream DBMSs.


Author(s):  
Herman Balsters

Businesses can change their business structure by merging with other companies or, on the other end of the spectrum, by smoothly outsourcing some of their business processes to other more specialized parties. In this paper we will concentrate on conceptual modelling of merging and outsourcing information systems. Merging of a collection of information systems will be defined as the construction of a global information system that contains exactly the functionality of the original collection of systems. Such global information systems are called federated information systems, when we wish to address the situation where the component systems are so-called legacy systems; i.e. systems that are given beforehand and which are to interoperate in an integrated single framework in which the legacy systems are to maintain as much as possible their respective autonomy. Two major problems in constructing federated information systems concern achieving and maintaining consistency and a uniform representation of the data on the global level of the federation. The process of creation of uniform representations of data is known as data extraction, whereas data reconciliation is concerned with resolving data inconsistencies. Outsourcing of an information system, on the other hand, will be defined as the handing over of part of the functionality of the original system to an outside party (the supplier). Such functionality typically involves one or more operations, where each operation satisfies certain input- and output requirements. These requirements will be defined in terms of the ruling service level agreements (SLAs). We will provide a formal means to ensure that the outsourcing relationship between outsourcing party and supplier, determined by a SLA, satisfies specific correctness criteria. Formal specifications as offered in this paper can prove their value in the setup and evaluation of outsourcing contracts. We shall describe a uniform semantic framework for specification of both federated and outsourced information systems based on the UML/OCL data model. In particular, we will show that we can represent so-called exact views in UML/OCL, providing the means to capture the duality relation between federating and outsourcing.


1999 ◽  
Vol 28 (3) ◽  
pp. 9-11 ◽  
Author(s):  
S. Conrad ◽  
W. Hasselbring ◽  
U. Hohenstein ◽  
R.-D. Kutsche ◽  
M. Roantree ◽  
...  

2000 ◽  
Vol 29 (4) ◽  
pp. 16-18 ◽  
Author(s):  
W. Hasselbring ◽  
W.-J. van den Heuvel ◽  
G. J. Houben ◽  
R.-D. Kutsche ◽  
B. Rieger ◽  
...  

Sign in / Sign up

Export Citation Format

Share Document