Using Oracle 11.2g database server in social network analysis based on recursive SQL

Abstract

The article describes the possibility of using Oracle 11.2g database server in social networks analysis. Nowadays, when data about human's relationships, thanks to Internet technologies, are often gathered, it is becoming more and more interesting to process that data. Authors show how to compute some metrics (degree centrality, local clustering) describing networks based on data stored in a relational database. The use of recursive SQL resulted in compact formulas that can be process at the database server side in an efficient way. © 2012 Springer-Verlag.