Abstract
Modern content management systems allow end-user schema creation, which can result in schema heterogeneity within a system. Building functionality to create and modify data must keep pace with this heterogeneity, but the cost of constant development is high. In this paper, we present a novel approach that extends our previous integration system that uses domain structures—global schema fragments—and local type and integration operators by introducing new local record operators and global insert and update operators. We present two widgets that use the new operators: (i) a generic clone widget that allows users to selectively clone records shown in a global widget while creating new local records; (ii) a generic clone exploration widget that allows users to browse the CloneOf relationships and reason about how different cloned records and structures have evolved. We demonstrate our system with a running example of the clone and exploration widgets in a robotics educational repository.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Blaha, M.: Patterns of Data Modeling. CRC Press (June 2010)
Bohannon, A., Pierce, B.C., Vaughan, J.A.: Relational lenses: a language for updatable views. In: PODS 2006, p. 338. ACM Press, New York (2006)
Britell, S., Delcambre, L.M.L., Atzeni, P.: Flexible Information Integration with Local Dominance. In: International Conference on Information Modelling and Knowledge Bases. Kiel, Germany (2014)
Britell, S., Delcambre, L.M.L.: Mapping Semantic Widgets to Web-based, Domain-specific Collections. In: Atzeni, P., Cheung, D., Ram, S. (eds.) ER 2012. LNCS, vol. 7532, pp. 204–213. Springer, Heidelberg (2012)
Cattell, R.: Scalable SQL and NoSQL data stores. ACM SIGMOD Record 39(4), 12 (2011)
Dayal, U., Bernstein, P.A.: On the correct translation of update operations on relational views. ACM Transactions on Database Systems 7(3), 381–416 (1982)
Hernández, M.A., Papotti, P., Tan, W.C.: Data exchange with data-metadata translations. Proceedings of the VLDB Endowment 1(1), 260–273 (2008)
Keller, A.M., Jensen, R., Agarwal, S.: Persistence software: bridging object-oriented programming and relational databases. ACM SIGMOD Record 22(2), 523–528 (1993)
Lakshmanan, L.V.S., Sadri, F., Subramanian, S.N.: SchemaSQL: An extension to SQL for multidatabase interoperability. ACM Transactions on Database Systems 26(4), 476–519 (2001)
Lenzerini, M.: Data integration: a theoretical perspective. In: PODS 2002: Proceedings of the Twenty-First ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, pp. 233–246. ACM, New York (2002)
Ma, H., Noack, R., Schewe, K.D., Thalheim, B.: Using Meta-Structures in Database Design. Informatica 34, 387–403 (2010)
Meijer, E., Bierman, G.: A co-relational model of data for large shared data banks. Communications of the ACM 54(4), 49 (2011)
Melnik, S., Adya, A., Bernstein, P.A.: Compiling mappings to bridge applications and databases. ACM Transactions on Database Systems 33(4), 1–50 (2008)
Terwilliger, J.F., Delcambre, L.M.L., Maier, D., Steinhauer, J., Britell, S.: Updatable and evolvable transforms for virtual databases. Proceedings of the VLDB Endowment 3(1-2), 309–319 (2010)
Thalheim, B.: Entity-relationship modeling: foundations of database technology, 1st edn. Springer, New York (2000)
Thalheim, B., Schewe, K.D., Ma, H.: Conceptual Application Domain Modelling. In: Link, S., Kirchberg, M. (eds.) Sixth Asia-Pacific Conference on Conceptual Modelling (APCCM 2009). CRPIT, vol. 96, pp. 49–57. ACS, Wellington (2009)
Wyss, C.M., Robertson, E.L.: A formal characterization of PIVOT/UNPIVOT. In: Proceedings of the 14th ACM International Conference on Information and knowledge Management CIKM 2005, p. 602. ACM Press, New York (2005)
Wyss, C.M., Robertson, E.L.: Relational languages for metadata integration. ACM Transactions on Database Systems 30(2), 624–660 (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Britell, S., Delcambre, L.M.L., Atzeni, P. (2014). Generic Data Manipulation in a Mixed Global/Local Conceptual Model. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds) Conceptual Modeling. ER 2014. Lecture Notes in Computer Science, vol 8824. Springer, Cham. https://doi.org/10.1007/978-3-319-12206-9_20
Download citation
DOI: https://doi.org/10.1007/978-3-319-12206-9_20
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-12205-2
Online ISBN: 978-3-319-12206-9
eBook Packages: Computer ScienceComputer Science (R0)