{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,2,8]],"date-time":"2024-02-08T10:52:08Z","timestamp":1707389528738},"reference-count":34,"publisher":"Wiley","issue":"5","license":[{"start":{"date-parts":[[2006,10,30]],"date-time":"2006-10-30T00:00:00Z","timestamp":1162166400000},"content-version":"vor","delay-in-days":4200,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#vor"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Softw Pract Exp"],"published-print":{"date-parts":[[1995,5]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>A key problem in providing \u2018enterprise\u2010wide\u2019 information is the integration of databases that have been independently developed. An important requirement is to accommodate heterogeneity and maintain the autonomy of component databases. Myriad is a federated database prototype developed at the University of Minnesota, to provide a testbed for investigating alternatives in architecture and algorithms for database integration, query processing and optimization, and concurrency control and recovery. The system incorporates our group's research results in these areas. This paper describes our experiences in the design and implementation of Myriad, and in the project management. Special emphasis is given to discussing design alternatives and their impact on Myriad. This paper also presents the software engineering principles and the project management techniques we used in developing Myriad and the lessons we learned. We believe these lessons would be useful for practitioners who wish to develop a similar system.<\/jats:p><jats:p>Handling heterogeneity and autonomy were prime objectives throughout the prototyping effort. We are convinced that a prototype federated database is an important infrastructural requirement for the overall goal of \u2018enterprise\u2010integration\u2019, and believe Myriad to be a significant contribution towards this.<\/jats:p>","DOI":"10.1002\/spe.4380250505","type":"journal-article","created":{"date-parts":[[2006,11,17]],"date-time":"2006-11-17T18:01:43Z","timestamp":1163786503000},"page":"533-562","source":"Crossref","is-referenced-by-count":13,"title":["Myriad: Design and implementation of a federated database prototype"],"prefix":"10.1002","volume":"25","author":[{"given":"Ee\u2010Peng","family":"Lim","sequence":"first","affiliation":[]},{"given":"San\u2010Yih","family":"Hwang","sequence":"additional","affiliation":[]},{"given":"Jaideep","family":"Srivastava","sequence":"additional","affiliation":[]},{"given":"Dave","family":"Clements","sequence":"additional","affiliation":[]},{"given":"M.","family":"Ganesh","sequence":"additional","affiliation":[]}],"member":"311","published-online":{"date-parts":[[2006,10,30]]},"reference":[{"key":"e_1_2_1_2_2","doi-asserted-by":"publisher","DOI":"10.1145\/96602.96607"},{"key":"e_1_2_1_3_2","doi-asserted-by":"publisher","DOI":"10.1145\/27633.27634"},{"key":"e_1_2_1_4_2","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-82375-6_5"},{"key":"e_1_2_1_5_2","doi-asserted-by":"publisher","DOI":"10.1109\/MC.1986.1663123"},{"key":"e_1_2_1_6_2","doi-asserted-by":"publisher","DOI":"10.1109\/2.116885"},{"key":"e_1_2_1_7_2","doi-asserted-by":"publisher","DOI":"10.1109\/2.223544"},{"key":"e_1_2_1_8_2","unstructured":"E.\u2010P.Lim J.Srivastava S.PrabhakarandJ.Richardson \u2018Entity identification problem in database integration\u2019 Proc. 9th IEEE Data Eng. Conf. 1993."},{"key":"e_1_2_1_9_2","unstructured":"E.\u2010P.Lim J.SrivastavaandS.Shekhar \u2018Resolving attribute incompatibility in database integration: An evidential reasoning approach\u2019 Proc. 10th IEEE Data Eng Conf. 1994."},{"key":"e_1_2_1_10_2","doi-asserted-by":"publisher","DOI":"10.1007\/BF01418060"},{"key":"e_1_2_1_11_2","doi-asserted-by":"publisher","DOI":"10.1145\/96602.96604"},{"key":"e_1_2_1_12_2","doi-asserted-by":"crossref","unstructured":"P. G.Selinger M. M.Astrahan D. D.Chamberlin R. A.LorieandT. G.Price \u2018Access path selection in a relational database management system\u2019 inProc. ACM SIGMOD Conference 1979 pp.23\u201324.","DOI":"10.1145\/582095.582099"},{"key":"e_1_2_1_13_2","doi-asserted-by":"crossref","unstructured":"E.\u2010P.LimandJ.Srivastava \u2018Query optimization\/processing in federated database systems\u2019 inConference of Information and Knowledge Management 1993.","DOI":"10.1145\/170088.170469"},{"key":"e_1_2_1_14_2","volume-title":"IDMS\/R: Concepts, Design, and Programming","author":"Martin J.","year":"1990"},{"issue":"2","key":"e_1_2_1_15_2","article-title":"Ingres gateways: Transparent heterogeneous sql access","volume":"13","author":"Simonson D.","year":"1990","journal-title":"Data Engineering Bulletin"},{"issue":"3","key":"e_1_2_1_16_2","article-title":"Update mechanism for multidatabase systems","volume":"10","author":"Breitbart Y.","year":"1987","journal-title":"IEEE Data Engineering"},{"key":"e_1_2_1_17_2","doi-asserted-by":"crossref","unstructured":"Y.BreitbartandA.Silberschatz \u2018Multidatabase update issues\u2019 inProc. ACM SIGMOD Int. Conf. on Management of Data 1988.","DOI":"10.1145\/50202.50217"},{"issue":"3","key":"e_1_2_1_18_2","article-title":"Superdatabases: Transactions across database boundaries","volume":"10","author":"Pu C.","year":"1987","journal-title":"IEEE Data Engineering"},{"key":"e_1_2_1_19_2","unstructured":"C.Pu \u2018Superdatabases for composition of heterogeneous databases\u2019 inProc. 4th Int. Conf. on Data Engineering 1988."},{"key":"e_1_2_1_20_2","unstructured":"A. K.ElmagarmidandW.Du \u2018A paradigm for concurrency control in heterogeneous distributed database system\u2019 InProc. 6th Int. Conf. on Data Engineering 1990."},{"key":"e_1_2_1_21_2","doi-asserted-by":"crossref","unstructured":"Y.LeuandA. K.Elmagarmid \u2018A hierarchical approach to concurrency control for multidatabases\u2019 inProc. 2nd Int. Symposium on Databases in Parallel and Distributed Systems 1990.","DOI":"10.1145\/319057.319100"},{"key":"e_1_2_1_22_2","unstructured":"D.Georgakopoulos M.RusinkiewiczandA.Sheth \u2018Serializability of multidatabase transactions through forced local conflicts\u2019 inProc. 7th Int. Conf. on Data Engineering 1991."},{"key":"e_1_2_1_23_2","doi-asserted-by":"crossref","unstructured":"S.Mehrotra R.Rastogi H. F.KorthandA.Silberschatz \u2018The concurrency control problem in multidatabases: Characteristics and solutions\u2019 inProc. ACM SIGMOD Int. Conf. on Management of Data 1992.","DOI":"10.1145\/130283.130327"},{"key":"e_1_2_1_24_2","unstructured":"R. K.Batra M.RusinkiewiczandD.Georgakopoulos \u2018Decentralized deadlock\u2010free concurrency control method for multidatabase transactions\u2019 inProc. 12th Int. Conf. on Distributed Computing Systems 1992."},{"key":"e_1_2_1_25_2","doi-asserted-by":"crossref","unstructured":"S.\u2010Y.Hwang J.HuangandJ.Srivastava \u2018Concurrency control in federated databases: A dynamic approach\u2019 inProc. 2nd Int. Conf. on Information and Knowledge Management 1993.","DOI":"10.1145\/170088.170458"},{"key":"e_1_2_1_26_2","volume-title":"Proc. 7th Int. Conf. on Parallel and Distributed Computing Systems","author":"Huang J.","year":"1994"},{"key":"e_1_2_1_27_2","unstructured":"J.Huang S.\u2010Y.HwangandJ.Srivastava \u2018Distributed forward optimistic concurrency control for federated database systems\u2019.Technical Report Honeywell Technology Center 3660 Technology Drive Minneapolis Minnesota 1992."},{"key":"e_1_2_1_28_2","unstructured":"W.DuandA.Elmagarmid \u2018Quasi serializability: A correctness criterion for global concurrency control in interbase\u2019 inProc. 15th Int. Conf. on Very Large Data Bases 1989."},{"key":"e_1_2_1_29_2","doi-asserted-by":"publisher","DOI":"10.1007\/BF01267325"},{"key":"e_1_2_1_30_2","unstructured":"Y.Breibart W.LitwinandA.Silberschatz \u2018Deadlock problems in a multidatabase environment\u2019 inProc. COMPCON 1991."},{"key":"e_1_2_1_31_2","unstructured":"P.ScheuermannandH.Tung \u2018A deadlock checkpointing scheme for multidatabase systems\u2019 inProc. 2nd Int. Workshop on Research Issues on Data Engineering: Transaction and Query Processing 1992."},{"key":"e_1_2_1_32_2","doi-asserted-by":"crossref","unstructured":"S.\u2010Y.Hwang J.SrivastavaandJ.Huang \u2018Incorporating admission control into concurrency control in federated databases\u2019 Technical Report93\u201356 Dept. Computer Sci. University of Minnesota MN 1993.","DOI":"10.1145\/170088.170458"},{"key":"e_1_2_1_33_2","volume-title":"Unix Network Programming","author":"Richard Stevens W.","year":"1990"},{"key":"e_1_2_1_34_2","unstructured":"B.Beizer Software Testing Techniques Van Nostrand Reinhold New York 1983."},{"key":"e_1_2_1_35_2","doi-asserted-by":"publisher","DOI":"10.1109\/VL.1993.269578"}],"container-title":["Software: Practice and Experience"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.wiley.com\/onlinelibrary\/tdm\/v1\/articles\/10.1002%2Fspe.4380250505","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1002\/spe.4380250505","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,2,8]],"date-time":"2024-02-08T10:07:39Z","timestamp":1707386859000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1002\/spe.4380250505"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1995,5]]},"references-count":34,"journal-issue":{"issue":"5","published-print":{"date-parts":[[1995,5]]}},"alternative-id":["10.1002\/spe.4380250505"],"URL":"https:\/\/doi.org\/10.1002\/spe.4380250505","archive":["Portico"],"relation":{},"ISSN":["0038-0644","1097-024X"],"issn-type":[{"value":"0038-0644","type":"print"},{"value":"1097-024X","type":"electronic"}],"subject":[],"published":{"date-parts":[[1995,5]]}}}