Skip to main content
SpringerLink
Log in

Using Oracle 11.2g Database Server in Social Network Analysis Based on Recursive SQL

  • Conference paper
Book cover Computer Networks (CN 2012)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 291))

Included in the following conference series:

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.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

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.

References

  1. Opsahl, T., Agneessens, F., Skvoretz, J.: Node centrality in weighted networks: Generalizing degree and shortest paths. Social Networks 32, 245–251 (2010)

    Article  Google Scholar 

  2. Freeman, L.C.: Centrality in social networks: Conceptual clarification. Social Networks 1, 215–239 (1978)

    Article  Google Scholar 

  3. Holland, P.W., Leinhardt, S.: Transitivity in structural models of small groups. Comparative Group Studies 2, 107–124 (1971)

    Google Scholar 

  4. Watts, D.J., Strogatz, S.H.: Collective dynamics of small-world networks. Nature 393, 440–442 (1998)

    Article  Google Scholar 

  5. Opsahl, T., Panzarasa, P.: Clustering in weighted networks. Social Networks 31, 155–163 (2009)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, 16 Akademicka St., 44-100, Gliwice, Poland

    Lukasz Wycislik & Lukasz Warchal

Authors
  1. Lukasz Wycislik
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Lukasz Warchal
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Computer Science, Silesian University of Technology, Akademicka 16, 44-100, Gliwice, Poland

    Andrzej Kwiecień

  2. Institute of Informatics, Silesian University of Technology, ul. Akademicka 16, 44-100, Gliwice, Poland

    Piotr Gaj

  3. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Piotr Stera

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Wycislik, L., Warchal, L. (2012). Using Oracle 11.2g Database Server in Social Network Analysis Based on Recursive SQL. In: Kwiecień, A., Gaj, P., Stera, P. (eds) Computer Networks. CN 2012. Communications in Computer and Information Science, vol 291. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-31217-5_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-31217-5_15

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-31216-8

  • Online ISBN: 978-3-642-31217-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation