Self-tuning Database Technology and Information Services

Weikum, Gerhard; Moenkeberg, Axel; Hasse, Christof; Zabback, Peter

doi:10.1016/b978-155860869-6/50011-1

Cited by 119 publications

(81 citation statements)

References 7 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…While service discovery is shielded in Osiris by the clever replication of meta information, other systems like eFlow [2] or CrossFlow [10] have to explicitly provide support for service discovery. In terms of self-adaptability, Osiris reacts on changes of the overall configuration (e.g., new service providers) by implicit feedback loops [23]. In addition, following the idea of service grids [7], active changes of the overall configuration are also possible by the installation of new service instances.…”

Section: Related Workmentioning

confidence: 99%

Peer–to–Peer Process Execution with Osiris

Schuler

Weber

Schuldt³

et al. 2003

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. Standards like SOAP, WSDL, and UDDI facilitate the proliferation of services. Based on these technologies, processes are a means to combine services to applications and to provide new value-added services. For large information systems, a centralized process engine is no longer appropriate due to limited scalability. Instead, in this paper, we propose a distributed and decentralized process engine that routes process instances directly from one node to the next ones. Such a Peer-to-Peer Process Execution (P 3 E) promises good scalability characteristics since it is able to dynamically balance the load of processes and services among all available service providers. Therefore, navigation costs only accumulate on nodes that are directly involved in the execution. However, this requires sophisticated strategies for the replication of meta information for P 3 E. Especially, replication mechanisms should avoid frequent accesses to global information repositories. In our system called Osiris (Open Service Infrastructure for Reliable and Integrated Process Support), we deploy a clever publish/subscribe based replication scheme together with freshness predicates to significantly reduce replication costs. This way, OSIRIS can support process-based applications in a dynamically evolving system without limiting scalability and correctness. First experiments have shown very promising results with respect to scalability.

show abstract

Section: Related Workmentioning

confidence: 99%

Peer–to–Peer Process Execution with Osiris

Schuler

Weber

Schuldt³

et al. 2003

Lecture Notes in Computer Science

View full text Add to dashboard Cite

show abstract

“…Research at IBM is aimed to support auto configuration at database through physical database design [4,5] . Microsoft is working on a database selftuning project, aimed to reduce the cost of manual database tuning needed to support the required database performance for specific applications [6] . However, these approaches do not consider QoS guarantee issues in terms of both timeliness and freshness.…”

Section: Introductionmentioning

confidence: 99%

Adaptive Update Policy for Proactive Management of Deadline Miss Ratio and Data Freshness in Real-Time Database Models

Tanwani¹,

Ramani²

2005

J. of Computer Science

View full text Add to dashboard Cite

Important applications, like e-commerce, online stock trading, traffic control demand real-time data services. Conventional database perform poor at these applications. A database for real-time data services has to support timing constraints and temporal consistency in addition to supporting characteristics of a conventional database system. In other words, it is desirable to execute transactions within its deadline using updated data reflecting the current world status. In order to achieve these objectives, the Quality of Service (QoS) metrics like miss ratio, data freshness, perceived freshness and Quality of Data (QoD) management schemes along with architectures for effective QoS management are introduced in Literature. These architectures accommodate the unpredictable change in user transactions and maintain QoS metrics by changing the update pattern of data items, which are periodically updated to reflect the real world status. In this study, we present architecture with an improved update policy and propose an algorithm to change the update pattern in such a manner that the system is able to maintain QoS metrics even under busty traffic conditions. The simulation results show that the proposed model can keep QoS metrics, like miss ratio and perceived freshness within limits under busty traffic conditions [1] .

show abstract

“…For the examples described, the need for views to be materialised may be affected by the presence of indexes, and vice versa. However, as such decisions tend to be made on the basis of mathematical models of system behaviour, and the design of the associated utility functions is problematic when multiple criteria must be taken into account [21], it remains an unsolved problem how to combine multiple autonomous components in a way that yields the desired overall behaviour [35]. Similarly, in adaptive query processing there may be ordering dependencies between adaptations.…”

Section: Limitationsmentioning

confidence: 99%

“…Applications of control theory to software systems are increasingly widespread [16], in which a model is developed of the behaviour of a system in response to changes in specific parameters. The resulting feedback control loops have been widely deployed for database tuning [35], but the changes made to an executing query in adaptive query processing are typically more radical than can be represented by changes to parameter values (e.g. many adaptive query processing strategies reoptimize queries at runtime, and thus the relationship between the state of the system before and after an adaptation is complex).…”

Section: Limitationsmentioning

confidence: 99%

“…[17]), it cannot yet be said that there are well established methodologies for the development of autonomic systems. Relating this work to the state-of-the-art in databases, several basic techniques have been adopted in both areas, such as the use of control theory where it is applicable [35], but many proposals for autonomic behaviours seem to be developed largely in isolation, and to address specific problems rather than to make automation a central design goal in the development of complex infrastructures. This is somewhat in contrast with the software architectures that underpin high-profile internet applications, such as Google or Yahoo.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Automation Everywhere: Autonomics and Data Management

Paton

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. Traditionally, database management systems (DBMSs) have been associated with high-cost, high-quality functionalities. That is, powerful capabilities are provided, but only in response to careful design, procurement, deployment and administration. This has been very successful in many contexts, but in an environment in which data is available in increasing quantities under the management of a growing collection of applications, and where effective use of available data often provides a competitive edge, there is a requirement for various of the benefits of a comprehensive data management infrastructure to be made available with rather fewer of the costs. If this requirement is to be met, automation will need to be deployed much more widely and systematically in data management platforms. This paper reviews recent results on autonomic data management, makes a case that current practice presents significant opportunities for further development, and argues that comprehensive support for automation should be central to future data management infrastructures.

show abstract

Self-tuning Database Technology and Information Services

Cited by 119 publications

References 7 publications

Peer–to–Peer Process Execution with Osiris

Peer–to–Peer Process Execution with Osiris

Adaptive Update Policy for Proactive Management of Deadline Miss Ratio and Data Freshness in Real-Time Database Models

Automation Everywhere: Autonomics and Data Management

Contact Info

Product

Resources

About