Abstract
The users of social networking applications and websites are the prime producers of huge amounts of data that the world is witnessing today. With these growing databases, all the social networking websites and applications are looking for an easy, secure and efficient maintenance of the database. As the size of both the database and the network grow, the entire database cannot be kept in a single node/single location. So the need arises for distributing the database over a network by dividing the database into portions called partitions. The partitions may be replicated at multiple nodes depending on the needed degree of availability. At the same time a single partition may further be split across a collection of nodes depending on how much data is need at a node. In this article, we have highlighted what is database partitioning, what is its need. This article also highlights some of the popular social networking websites and applications that are using a numerous database depending on the features they are providing. During our study, we have studied upon some of the data bases used by the example websites considered and what type of partitioning scheme might have been used. This article discusses some key features of database partitioning schemes of Facebook, twitter, amazon, WhatsApp and Instagram.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Cassandra. (n.d.). https://academy.datastax.com/
Bouchard, J.-L.: Mark Zuckerberg’s full commencement address at Harvard, the school he left to start Facebook, 26 May 2017. https://qz.com/992048/mark-zuckerbergs-harvard-speech-a-full-transcript-of-the-facebook-ceos-commencement-address/
Navathe, S., Ceri, S., Wiederhold, G., Dou, J.: Vertical partitioning algorithms for database design. ACM Trans. Database Syst. (TODS) 9(4), 680–710 (1984)
Fowler, A.: Nosql data partitioning, January 2015. https://www.dummies.com/programming/big-data/handling-partitions-in-nosql/
Partitioning methods (n.d.). https://www.oracle.com/technetwork/database/options/partitioning/overview/index.html
Google’s NoSQL BIG DATA database service. Cloud Bigtable documentation. https://cloud.google.com/bigtable/docs/
Cesarini, F., Vinoski, S.: Designing for Scalability with Erlang/OTP: Implement Robust, Fault-Tolerant Systems, 1st edn., pp. 405–422. O’Reilly (2016). Chapter 15 Scaling out
Partitioning types (n.d.). https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/partitioning-types.html
Thomas, S.: (Guest Post): database design practices in various social media sites (n.d.). https://www.pixelproductionsinc.com/11-database-design-practices-for-social-media-sites/
Aarepu, L., Prasad, B.M.G., Sharma, Y.K.: A review on data mining and bigdata. Int. J. Comput. Eng. Technol. (IJCET) 10(1), 117–123 (2019)
Rivas, T.: Ranking the big four tech stocks: Google is No. 1, Apple comes in last, 22 August 2017. https://www.barrons.com/articles/ranking-the-big-four-internet-stocks-google-is-no-1-apple-comes-in-last-1503412102
Partitioning the database, 6 June 2019. www.wikipedia.com
Wakita, K., Tsurumi, T.: Finding community structure in mega-scale social networks. In: Proceedings of the 16th International Conference on World Wide Web, WWW 2007. ACM, New York (2007)
Sharma, Y.K., Sharif, G.M.: Framework for privacy preserving classification in data mining. J. Emerg. Technol. Innov. Res. 5(9), 178–183 (2018)
Lu, Z., Zhu, Y., Li, W., Wu, W., Cheng, X.: Influence-based community partition for social networks. Comput. Soc. Netw. (2014). https://computationalsocialnetworks.springeropen.com/articles/10.1186/s40649-014-0001-4
Markova, V., Shopov, V.: Graph partitioning methods in social network analysis (2016). https://www.researchgate.net/publication/321797991_GRAPH_PARTITIONING_METHODS_IN_SOCIAL_NETWORK_ANALYSIS
Rouse, M.: Definition of WhatsApp (n.d.). https://searchmobilecomputing.techtarget.com/definition/WhatsApp
Sharma, D.Y.K., Kumar, S.: Designing hybrid data mining technique for efficient industrial engineering domain. J. Comput. Inf. Syst. 15(3), 128–136 (2019)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Sridevi, S.V.G., Sharma, Y.K. (2020). An Approximative Study of Database Partitioning with Respect to Popular Social Networking Websites and Applications. In: Smys, S., Bestak, R., Rocha, Á. (eds) Inventive Computation Technologies. ICICIT 2019. Lecture Notes in Networks and Systems, vol 98. Springer, Cham. https://doi.org/10.1007/978-3-030-33846-6_94
Download citation
DOI: https://doi.org/10.1007/978-3-030-33846-6_94
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-33845-9
Online ISBN: 978-3-030-33846-6
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)