Abstract
In this paper, we present a system called DONOW (Database on Network of Workstation), that is an example of an implementation and maintenance of a low cost distributed database without performances penalties. The system has a three tier architecture based on a client, a service and a data layer. The client layer allows local and remote users to interact with the system through a Java user friendly interface. The service layer is implemented in C++; it allows the service of user requests and, in particular, the management of queries involving more than one DONOW node. The data layer is based on a well-known free-ware relational database management system, that is, MySQL for each DONOW node. DONOW is under experimentation and will be used by Partena, an industry producing very advanced machinery for pharmaceutical products packaging, for the management of the information about their machines, that consists of close to 100000 drawings and related documentation.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
Ambler, S.W.: Tips for Mapping Objects to Relational Databases. AmbySoft Inc. (1998) Available from http://www.AmbySoft.com/onlineWritings.html
Anderson, T.E., Culler, D.E., Patterson, D.A.: A case for networks of workstations: NOW. IEEE Micro, 15(1) (1995) 56–64.
Arpaci-Dusseau, A.C., Arpaci-Dussuau, R.H., Culler, D.E., Hellerstein, J.M., Patterson D.A.: High-Performance Sorting on Networks of Workstations. In Proc. SIGMOD’97. Tucson, AZ (1997) 243–254
Arpaci-Dusseau, A.C., Arpaci-Dussuau, R.H., Culler, D.E., Hellerstein, J.M., Patterson D.A.: Searching for the Sorting Record: Experiences in Tuning NOW-Sort. In 2nd SIGMETRICS Symposium on Parallel and Distributed Tools. Welches, OR (1998)
Axmark, D.: MySQL 3.22 Reference Manual. (1998) Available from http://www.mysql.com
Baru, C., Fecteau, G., Goyal, A., Hsiao, H., Jhnigran, A., Padmanabhan, S., Wilson, W.: An Overview of DB2 Parallel Edition. In Proc. SIGMOD’95. San Jose, CA (1995) 460–462.
Basu, A., Buch, V., Vogels, W., von Eicken, T.: A User-Level Network Interface for Parallel and Distributed Computing. In Proc. 15th ACM Symp. on Operating System Principles Copper Mountain, CO (1995)
Blumrich, M.A., Li, K., Alpert, R., Dubnicki, C., Felten, E.W.: Virtual Memory Mapped Network Interface for the SHRIMP Multicomputer. In Proc. of the Int. Symp. on Computer Architectures Chicago, IL (1994) 142–153
Bobak, A.R.: Distributed and Multi-Database Systems. Artech House (1995)
Boral, H., Alexander, W., Clay, L., Copeland, G., et al: Prototyping Bubba, a Highly Parallel database system. IEEE Trans. on Knowledge Data Engineering. 2(1) (1990) 44–62.
Chiola, G., Ciaccio, G.: Implementing a low cost, low latency parallel platform. Parallel Computing. 22 (1997) 1703–1717
DeWitt, D., Ghandeharizadeh, S., Schneider, D., Bricker, A., et al.: The Gamma Database Machine Project. IEEE Trans. on Knowledge Data Engineering, 2(1) (1990) 4–24.
Gerber, R.: Informix Online XPS. In Proc. SIGMOD’95 San Jose, CA (1995) 463
Marenzoni, P., Rimassa, G., Vignali, M., Bertozzi, M., Conte, G., Rossi, P.: An operating system support to low-overhead communications in NOW clusters. In Proc. of Communication and Architectural Support for Network-Based Parallel Computing, San Antonio, TX (1995) 130–143
Microsoft: Clustering Support for Microsoft SQL Server High Availability for Tomorrow’s Mission Critical Applications. (1997) Available from http://research.microsoft.com/gray/.
Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice Hall, Englewood Cliff (1991)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1999 Springer-Verlag
About this paper
Cite this paper
Conte, G., Mazzeo, M., Poggi, A., Rossi, P., Vignali, M. (1999). Low cost databases for NOW. In: Rolim, J., et al. Parallel and Distributed Processing. IPPS 1999. Lecture Notes in Computer Science, vol 1586. Springer, Berlin, Heidelberg . https://doi.org/10.1007/BFb0098000
Download citation
DOI: https://doi.org/10.1007/BFb0098000
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-65831-3
Online ISBN: 978-3-540-48932-0
eBook Packages: Springer Book Archive