Declarative Management in Microsoft SQL Server

Summary: Declarative Management for SQL Server: users specify the desired state; the system derives and enforces the steps to achieve it. Enables self‑managing database administration, reducing errors and costs; includes an initial SQL Server 2008 implementation and design details. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10086
Venue: VLDB
Year: 2009
Pagerank: 5.093636e-05
Overall Rank: 12,531 | 14.03%
DOI: 10.14778/1687553.1687555

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Hongfei Guo (Microsoft)
2. Dan Jones (Microsoft)
3. Jennifer Beckmann (Microsoft)
4. Praveen Seshadri (Microsoft)

BibTeX Citation

@article{guo_vldb09,
        title = {{Declarative Management in Microsoft SQL Server}},
        author = {Guo, Hongfei and Jones, Dan and Beckmann, Jennifer and Seshadri, Praveen},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687553.1687555},
        url = {https://doi.org/10.14778/1687553.1687555},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
246	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023457421
600	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.00015871387
781	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00014085674
2,466	Goal-Oriented Buffer Management Revisited*	1996	SIGMOD	8.5428771e-05
3,063	Oracle Database Replay	2008	SIGMOD	7.802088e-05
8,150	A Dependability Benchmark for OLTP Application Environments	2003	VLDB	5.4784885e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,475	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB
2	13,229	Conceptual-To-Internal Mappings in Commercial Database Systems	1984	PODS
3	12,261	Microsoft SQL Server's Integrated Database Approach for Modern Applications and Hardware	2013	VLDB
4	11,499	Towards Auto-Generated Data Systems	2023	VLDB
5	12,792	Production Database Systems: Making Them Easy is Hard Work	2004	VLDB
6	6,247	A Data Base Management System Design Philosophy	1975	SIGMOD
7	6,131	Foundations of Automated Database Tuning	2006	VLDB
8	12,644	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD
9	250	Answering Queries using Humans, Algorithms and Databases	2011	CIDR
10	6,700	Self-Managing Technology in Database Management Systems	2004	VLDB