Compiling Mappings to Bridge Applications and Databases

Summary: Declarative mappings between apps and databases compile into bidirectional views powering transformation engine. Queries answered and updates translated via view maintenance; handles constraint rewriting and nonrelational constructs; deployed commercially. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hcb772a12d427624b
Venue: SIGMOD
Year: 2007
Pagerank: 8.3791317e-05
Overall Rank: 2,500 | 83.20%
DOI: 10.1145/1247480.1247532

Incoming Non-self Citations Over Time

Authors

1. Sergey Melnik (Microsoft)
2. Atul Adya (Microsoft)
3. Philip A. Bernstein (Microsoft)

BibTeX Citation

@inproceedings{melnik_sigmod07,
        title = {{Compiling Mappings to Bridge Applications and Databases}},
        author = {Melnik, Sergey and Adya, Atul and Bernstein, Philip A.},
        series = {{SIGMOD} '07},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1247480.1247532},
        url = {https://dl.acm.org/doi/10.1145/1247480.1247532},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
793	Model Management 2.0: Manipulating Richer Mappings	2007	SIGMOD	0.00013935809
1,505	Generic Schema Matching, Ten Years Later	2011	VLDB	0.00010449986
2,778	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0261532e-05
2,973	Anatomy of the ADO.NET Entity Framework	2007	SIGMOD	7.7932422e-05
3,990	Beyond Relations: A Case for Elevating to the Entity-Relationship Abstraction	2025	CIDR	6.867063e-05
4,706	Towards a Theory of Schema-Mapping Optimization	2008	PODS	6.4574226e-05
5,177	Scalable Data Exchange with Functional Dependencies	2010	VLDB	6.2385872e-05
7,393	Object/Relational Mapping 2008: Hibernate and the Entity Data Model (EDM)	2008	SIGMOD	5.535058e-05
7,607	Query Containment in Entity SQL (Extended Abstract)	2013	SIGMOD	5.4842774e-05
8,499	Full-Fidelity Flexible Object-Oriented XML Access	2009	VLDB	5.3289687e-05
9,145	Equivalence of Nested Queries with Mixed Semantics	2009	PODS	5.2200167e-05
9,180	Analyzing and Revising Data Integration Schemas to Improve Their Matchability	2008	VLDB	5.2116341e-05
9,687	ADO.NET Entity Framework: Raising the Level of Abstraction in Data Programming	2007	SIGMOD	5.1404928e-05
11,024	Vodka: Rethink Benchmarking Philosophy in HTAP Systems	2026	VLDB	4.9769913e-05
11,991	Structural Generalizability: The Case of Similarity Search	2021	SIGMOD	4.9769913e-05
12,134	Programmable View Update Strategies on Relations	2020	VLDB	4.9769913e-05
12,185	Making an RDBMS Data Scientist Friendly: Advanced In-database Interactive Analytics with Visualization Support	2019	VLDB	4.9769913e-05
12,548	Incremental Mapping Compilation in an Object-to-Relational Mapping System	2013	SIGMOD	4.9769913e-05
12,734	Worry-Free Database Upgrades: Automated Model-Driven Evolution of Schemas and Complex Mappings	2010	SIGMOD	4.9769913e-05
12,766	Updatable and Evolvable Transforms for Virtual Databases	2010	VLDB	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046583225
182	Schema Mapping as Query Discovery	2000	VLDB	0.00026265768
292	LINQ: Reconciling Objects, Relations and XML in the .NET Framework	2006	SIGMOD	0.00021937893
703	Composing Schema Mappings: Second-Order Dependencies to the Rescue	2004	PODS	0.00014653248
793	Model Management 2.0: Manipulating Richer Mappings	2007	SIGMOD	0.00013935809
1,522	Composition of Mappings Given by Embedded Dependencies	2005	PODS	0.00010362522
1,909	Of Objects and Databases: A Decade of Turmoil	1996	VLDB	9.3898701e-05
2,046	Views and Queries: Determinacy and Rewriting	2005	PODS	9.1331561e-05
2,410	Implementing Mapping Composition	2006	VLDB	8.5106165e-05
2,700	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.1159657e-05
2,973	Anatomy of the ADO.NET Entity Framework	2007	SIGMOD	7.7932422e-05
3,428	Relational Lenses: A Language for Updatable Views	2006	PODS	7.3033487e-05
4,502	Bringing Object-Relational Technology to The Mainstream	1999	SIGMOD	6.5711677e-05
4,574	Persistence Software: Bridging Object-Oriented Programming and Relational Databases	1993	SIGMOD	6.5247715e-05
6,394	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.79815e-05
6,913	O-O, What Have They Done to DB2?	1999	VLDB	5.6459578e-05
7,269	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	5.5673576e-05
9,687	ADO.NET Entity Framework: Raising the Level of Abstraction in Data Programming	2007	SIGMOD	5.1404928e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,134	Programmable View Update Strategies on Relations	2020	VLDB
2	6,394	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB
3	4,268	Mapping Adaptation under Evolving Schemas	2003	VLDB
4	8,499	Full-Fidelity Flexible Object-Oriented XML Access	2009	VLDB
5	7,779	Unifying Data and Domain Knowledge Using Virtual Views	2007	VLDB
6	13,525	Conceptual-To-Internal Mappings in Commercial Database Systems	1984	PODS
7	2,700	Updating Relational Databases through Object-Based Views	1991	SIGMOD
8	12,548	Incremental Mapping Compilation in an Object-to-Relational Mapping System	2013	SIGMOD
9	1,811	Supporting Executable Mappings in Model Management	2005	SIGMOD
10	1,050	Data-Driven Understanding and Refinement of Schema Mappings	2001	SIGMOD