Analysis of data management and query handling in social networks using NoSQL databases

Abstract

In the past few decades, traditional RDBMS(Relational Database Management Systems) was a predominant technology used for storing and retrieving structured data in web and business applications since 1980. However, relational databases have started squandering its importance due to strict schema reliance and costly infrastructure. This has collectively led to the problem in upgrade hardware-software challenges and relationships between objects. Another major issue of failure is the brobdingnagian hike of BigData. A new database model called NoSQL, plays a vital role in BigData analytics. The main focus of this paper is on four different types of NoSQL databases owned by social networking sites like Facebook, LinkedIn, Twitter, MySpace, Foursquare, Flickr and Friendfeed. Main features of these four types of NoSQL databases, like scalability of the data model, concurrency control, consistency in storage, availability during partitioning, durability, transactions, implementation language, query support possibilities and programming characteristics are compared and analyzed. These features are compared for the sub categories of the four NoSQL databases, for swift querying from social networking sites. In the detailed analysis presented, the features like data storage and fast retrieval phase of query processing are given primary importance. We also present a comparison of the time taken during insert and read operations of social network data of Facebook associating friends, intimate friends, family and groups like hometown and workplace. The results are compared and most suitable database from NoSQL Graph database subcategories for insert and read operations in Facebook are identified.