A framework for enforcing application policies in database systems

Qiao, Lin; Soetarman, Basuki; Fuh, Gene; Pannu, Adarsh; Cui, Baoqiu; Beavin, Thomas; Kyu, William

doi:10.1145/1247480.1247597

Cited by 3 publications

(2 citation statements)

References 13 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Qiao et al [19] present a framework to define, manage, and enforce policies that are used to isolate a problem into a more specific context, upon which either general or customized solutions are derived. Another approach is to explore system-level provenance to improve the mental models, and troubleshooting process for system administrators [9].…”

Section: Related Workmentioning

confidence: 99%

Shared Context for Improving Collaboration in Database Administration

Tahir¹,

Brézillon²

2013

IJDMS

View full text Add to dashboard Cite

show abstract

Section: Related Workmentioning

confidence: 99%

Shared Context for Improving Collaboration in Database Administration

Tahir¹,

Brézillon²

2013

IJDMS

View full text Add to dashboard Cite

show abstract

“…Other recent research works uses Policy-based computing to implement autonomic administration capabilities into a database for enforcing policies to control and decide which changes are allowed and which ones are not. Qiao et al [17] present a framework to define, manage, and enforce policies that are used to isolate a problem into a more specific context, upon which either general or customized solutions are derived. Jabbour and Menasee [13] introduce the notion of embedding policies into the database itself and enabling these policies to block every attempt to compromise the state of the database, or to alter its configuration in a way that contradicts what has been established and fed into the policy by the system owner.…”

Section: Related Workmentioning

confidence: 99%

Procedure contextualization based on collaborative database administration

Tahir¹,

Brézillon²

2011

Proceedings of the 2011 15th International Conference on Computer Supported Cooperative Work in Design (CSCWD)

View full text Add to dashboard Cite

Database administration tasks often involve several actors within the organization. The main actor is the database administrator (DBA) who interacts with other DBAs and with other actors. Thus, sharing knowledge among them is crucial. This knowledge relies on each member's skills, experiences and background, and also on the common activities, conditions, facts, and situations faced during the administration of the database and the setting of the environment. Exchanging knowledge between the DBA and the other actors can only be effective if there is a common interpretive focus and a shared context where they can understand each other and exchange their experiences. The concept of context plays an important role in collaboration, especially in communication, interaction and knowledge sharing. In addition, and under temporal and financial pressures, this can help a DBA in avoiding misunderstandings and accidents such asdestroying each other's work or imposed system downtime. The paper presents how collaboration improves the contextualization of DBA procedures and the development of the DBA practices. Our work focuses on collaboration between actors with different roles according to an internal observation that is to say from the point of view of the main actor (i.e. DBA) to help him achieve his objective. This is a key element in the building of a support system for DBA acting as a real context-based intelligent assistant system based on a collaborative work. Contextual Graphs are used to illustrate the collaborative approach to database administration tasks.

show abstract

Optimizer plan change management

Ziauddin

Das

et al. 2008

Proc. VLDB Endow.

View full text Add to dashboard Cite

Execution plans for SQL statements have a significant impact on the overall performance of database systems. New optimizer statistics, configuration parameter changes, software upgrades and hardware resource utilization are among a multitude of factors that may cause the query optimizer to generate new plans. While most of these plan changes are beneficial or benign, a few rogue plans can potentially wreak havoc on system performance or availability, affecting critical and time-sensitive business application needs. The normally desirable ability of a query optimizer to adapt to system changes may sometimes cause it to pick a sub-optimal plan compromising the stability of the system. In this paper, we present the new SQL Plan Management feature in Oracle 11g. It provides a comprehensive solution for managing plan changes to provide stable and optimal performance for a set of SQL statements. Two of its most important goals are preventing sub-optimal plans from being executed while allowing new plans to be used if they are verifiably better than previous plans. This feature is tightly integrated with Oracle's query optimizer. SQL Plan Management is available to users via both command-line and graphical interfaces. We describe the feature and then, using an industrial-strength application suite, present experimental results that show that SQL Plan Management provides stable and optimal performance for SQL statements with no performance regressions.

show abstract

A framework for enforcing application policies in database systems

Cited by 3 publications

References 13 publications

Shared Context for Improving Collaboration in Database Administration

Shared Context for Improving Collaboration in Database Administration

Procedure contextualization based on collaborative database administration

Optimizer plan change management

Contact Info

Product

Resources

About