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.3830999e-05
Overall Rank: 2,498 | 83.21%
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.00013942384
1,505	Generic Schema Matching, Ten Years Later	2011	VLDB	0.00010454635
2,778	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0299506e-05
2,972	Anatomy of the ADO.NET Entity Framework	2007	SIGMOD	7.7969328e-05
3,989	Beyond Relations: A Case for Elevating to the Entity-Relationship Abstraction	2025	CIDR	6.8703153e-05
4,704	Towards a Theory of Schema-Mapping Optimization	2008	PODS	6.4604802e-05
5,176	Scalable Data Exchange with Functional Dependencies	2010	VLDB	6.2415413e-05
7,391	Object/Relational Mapping 2008: Hibernate and the Entity Data Model (EDM)	2008	SIGMOD	5.5376795e-05
7,601	Query Containment in Entity SQL (Extended Abstract)	2013	SIGMOD	5.4868602e-05
8,491	Full-Fidelity Flexible Object-Oriented XML Access	2009	VLDB	5.3314923e-05
9,135	Equivalence of Nested Queries with Mixed Semantics	2009	PODS	5.2224867e-05
9,171	Analyzing and Revising Data Integration Schemas to Improve Their Matchability	2008	VLDB	5.2141009e-05
9,680	ADO.NET Entity Framework: Raising the Level of Abstraction in Data Programming	2007	SIGMOD	5.1429274e-05
11,015	Vodka: Rethink Benchmarking Philosophy in HTAP Systems	2026	VLDB	4.9793485e-05
11,985	Structural Generalizability: The Case of Similarity Search	2021	SIGMOD	4.9793485e-05
12,128	Programmable View Update Strategies on Relations	2020	VLDB	4.9793485e-05
12,179	Making an RDBMS Data Scientist Friendly: Advanced In-database Interactive Analytics with Visualization Support	2019	VLDB	4.9793485e-05
12,542	Incremental Mapping Compilation in an Object-to-Relational Mapping System	2013	SIGMOD	4.9793485e-05
12,728	Worry-Free Database Upgrades: Automated Model-Driven Evolution of Schemas and Complex Mappings	2010	SIGMOD	4.9793485e-05
12,760	Updatable and Evolvable Transforms for Virtual Databases	2010	VLDB	4.9793485e-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.00046602544
182	Schema Mapping as Query Discovery	2000	VLDB	0.00026277842
292	LINQ: Reconciling Objects, Relations and XML in the .NET Framework	2006	SIGMOD	0.00021947834
703	Composing Schema Mappings: Second-Order Dependencies to the Rescue	2004	PODS	0.00014660132
793	Model Management 2.0: Manipulating Richer Mappings	2007	SIGMOD	0.00013942384
1,522	Composition of Mappings Given by Embedded Dependencies	2005	PODS	0.00010367399
1,909	Of Objects and Databases: A Decade of Turmoil	1996	VLDB	9.3937135e-05
2,044	Views and Queries: Determinacy and Rewriting	2005	PODS	9.137464e-05
2,408	Implementing Mapping Composition	2006	VLDB	8.5146431e-05
2,698	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.1197711e-05
2,972	Anatomy of the ADO.NET Entity Framework	2007	SIGMOD	7.7969328e-05
3,428	Relational Lenses: A Language for Updatable Views	2006	PODS	7.3067857e-05
4,500	Bringing Object-Relational Technology to The Mainstream	1999	SIGMOD	6.5742799e-05
4,572	Persistence Software: Bridging Object-Oriented Programming and Relational Databases	1993	SIGMOD	6.5278616e-05
6,391	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.800896e-05
6,911	O-O, What Have They Done to DB2?	1999	VLDB	5.6486318e-05
7,266	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	5.5699944e-05
9,680	ADO.NET Entity Framework: Raising the Level of Abstraction in Data Programming	2007	SIGMOD	5.1429274e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,128	Programmable View Update Strategies on Relations	2020	VLDB
2	6,391	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,491	Full-Fidelity Flexible Object-Oriented XML Access	2009	VLDB
5	7,770	Unifying Data and Domain Knowledge Using Virtual Views	2007	VLDB
6	13,519	Conceptual-To-Internal Mappings in Commercial Database Systems	1984	PODS
7	2,698	Updating Relational Databases through Object-Based Views	1991	SIGMOD
8	12,542	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