Skip to main content

Modeling the Nonlinear Nature of Response Time in the Vertical Fragmentation Design of Distributed Databases

  • Conference paper
International Symposium on Distributed Computing and Artificial Intelligence 2008 (DCAI 2008)

Part of the book series: Advances in Soft Computing ((AINSC,volume 50))

  • 1357 Accesses

Abstract

The generalized use of the Internet has facilitated the implementation of distributed database (DDB) systems, which are becoming increasingly common-place. Unfortunately, though there exist many models for optimizing the design of DDBs (i.e., the distribution of data), they usually seek to optimize the transmission and processing costs of queries and overlook the delays incurred by their transmission and processing, which can be a major concern for Internet-based systems. In this paper a mathematical model is presented, which describes the behavior of a DDB with vertical fragmentation and permits to optimize its design taking into account the roundtrip response time (query transmission time, query processing time, and response transmission time).

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice Hall, USA (1999)

    Google Scholar 

  2. Chakravarthy, S., Muthuraj, J., Varadarajan, R., et al.: An Objective Function for Vertically Partitioning Relations in Distributed Databases and its Analysis. Distributed and Parallel Databases 2(2), 183–207 (1994)

    Article  Google Scholar 

  3. Tamhankar, A.M., Ram, S.: Database Fragmentation and Allocation: an Integrated Methodology and Case Study. IEEE Transactions Systems, Man and Cybernetics Part A 28, 288–305 (1998)

    Article  Google Scholar 

  4. Golfarelli, M., Maio, D., Rizzi, S.: Vertical Fragmentation of Views in Relational Data Warehouses. In: Proc. Settimo Convegno Nazionale Sistemi Evoluti per Basi di Dati (SEBD 1999), Villa Olmo, Italy, pp. 23–25 (1999)

    Google Scholar 

  5. Pérez, J., Pazos, R., Frausto, J., et al.: Vertical Fragmentation and Allocation in Distributed Databases with Site Capacity Restrictions Using the Threshold Accepting Algorithm. In: Cairó, O., Cantú, F.J. (eds.) MICAI 2000. LNCS, vol. 1793, pp. 75–81. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  6. Ulus, T., Uysal, M.: Heuristic Approach to Dynamic Data Allocation in Distributed Database Systems. Pakistan Journal of Information and Technology 2(3), 231–239 (2003)

    Google Scholar 

  7. Pérez, J., Pazos, R., Santaolaya, R., et al.: Data-Object Replication, Distribution, and Mobility in Network Environments. In: Broy, M., Zamulin, A.V. (eds.) PSI 2003. LNCS, vol. 2890, pp. 539–545. Springer, Heidelberg (2004)

    Google Scholar 

  8. Kleinrock, L.: Queueing Systems. Theory, vol. 1. Wiley-Interscience, USA (1975)

    MATH  Google Scholar 

  9. Kleinrock, L.: Communication Nets: Stochastic Message Flow and Delay. Dover Publications, USA (2007)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Juan M. Corchado Sara Rodríguez James Llinas José M. Molina

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pazos R., R.A., Vázquez A., G., Pérez O., J., Martínez F., J.A. (2009). Modeling the Nonlinear Nature of Response Time in the Vertical Fragmentation Design of Distributed Databases. In: Corchado, J.M., Rodríguez, S., Llinas, J., Molina, J.M. (eds) International Symposium on Distributed Computing and Artificial Intelligence 2008 (DCAI 2008). Advances in Soft Computing, vol 50. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85863-8_72

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-85863-8_72

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-85862-1

  • Online ISBN: 978-3-540-85863-8

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics