Skip to main content
SpringerLink
Log in
Book cover

Community-Built Databases pp 159–182Cite as

Social Interaction in Databases

  • Chapter
  • First Online:

Abstract

The advent of the social web has made user-generated content a focus of research. Such content is already available in the form of tags, blogs, comments, etc., in many Web sites. Experience with social Web sites has shown that users tend to have a say about the data: they may interpret the same data in somewhat different ways, or may be able to add detail to it, enriching the existing contents. When users are able to enter information in a format-free manner, they tend to do so and may provide additional semantics to the data. The success of tagging clearly indicates that users are willing to provide content when this can be done in a manner that is natural to the users. Past research shows that the tags that users add to items in many Web sites are, as a whole, excellent descriptors of the contents of the items themselves and can be fruitfully used for several tasks, like improving search or clustering of the item set [1–3]. Overall, the amount of user-created content is growing at a fast rate.

This is a preview of subscription content, 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   84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   109.99
Price excludes VAT (USA)
  • Durable hardcover 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

Learn about institutional subscriptions

Notes

  1. 1.

    Once again, a dynamic analysis will add a time component, as ext(D) changes over time.

  2. 2.

    www.getty.edu/research/conducting_research/vocabularies/tgn/index.html

  3. 3.

    Note that it may be impossible to decide when a query returns as answer a single row. In practice, we expect that a (human) user would pick a particular row (and/or a particular attribute within a row) by clicking on it in a GUI, and then attaching some information to the selected value. Thus, the implementation of this functionality may depend on the user interface, an issue that is not within the scope of this chapter. We assume, though, that such functionality exists, and hence we provide operations for it.

  4. 4.

    This is already the case in several commercial systems.

  5. 5.

    Note that the SQL standard allows for some attributes to appear in the GROUP BY clause and not in the SELECT clause, so this check is necessary.

  6. 6.

    While an update statement may involve more than one table, the typical usage of SQL is to make changes in one table at a time.

References

  1. Bao, S., Wu, X., Fei, B., Xue, G., Su, Z., Yu, Y.: Optimizing web search using social annotations. In: Proceedings of the WWW 2007 Conference, pp. 501–510. ACM, New York, NY (2007)

    Google Scholar 

  2. Escobar-Molano, M., Badia, A.: Exploiting Tags for Concept Extraction and Information Integration. In: Proceedings of the 5th International Conference on Collaborative Computing: Networking, Applications and Worksharing. IEEE Press (2009)

    Google Scholar 

  3. Golder, S., Huberman, B.A.: The structure of collaborative tagging systems. J. Inf. Sci. 32(2), 198–208 (2006)

    Article  Google Scholar 

  4. Melnik, S., Adya, A., Bernstein, P.A.: Compiling mappings to bridge applications and databases. J. ACM Trans. Database Syst. 33(4), 1–50 (2008)

    Article  Google Scholar 

  5. Wyss, C., Robertson, E.: Relational languages for metadata integration. ACM Trans. Database Syst. TODS 30(2), 624–660 (2005)

    Article  Google Scholar 

  6. Yu, B., Li, G., Ooi, B.C., Zhou, L.-Z.: One table stores all: enabling painless free-and-easy data publishing and sharing. In Proceedings of the 3rd Biennial Conference on Innovative Data Systems Research (CIDR), pp. 142–153, (2007)

    Google Scholar 

  7. Nørbåg, K.: Design issues in transaction-time temporal object database systems. In: Stuller, J., Pokorny, J., Thalheim, B., Masunaga, Y. (eds.) Current Issues in Databases and Information Systems. Lecture Notes in Computer Science, vol. 1884, pp. 371–378. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  8. Jensen, C.S., Snodgrass, R.T.: Temporal data management. IEEE Trans. Knowl. Data Eng. TKDE 11, 36–44 (1999)

    Article  Google Scholar 

  9. Gupta, A., Mumick, I.S. (eds.): Materialized Views: Techniques, Implementations, and Applications. MIT, Cambridge, MA (1999)

    Google Scholar 

  10. Wilkinson, D.M., Huberman, B.A.: Cooperation and quality in Wikipedia. In: Proceedings of the 2007 International Symposium on Wikis, Montreal, Quebec, Canada, pp. 157–164 (2007).

    Google Scholar 

  11. Doan, A., Halevy, A.: Semantic integration research in the database community: A brief survey. AI Magazine, Special Issue on Semantic Integration, Spring (2005)

    Google Scholar 

  12. Kang, J., Naughton, J.: Schema matching using interattribute dependencies. IEEE Trans. Knowl. Data Eng. TKDE 20(10), 1393–1407 (2008)

    Article  Google Scholar 

  13. Sciore, E., Siegel, M., Rosenthal, A.: Using semantics values to facilitate interoperability among heterogeneous information systems. ACM Trans. Database Syst. 19, 254–290 (1994)

    Article  Google Scholar 

  14. Wasserman, S., Faust, K.: Social Network Analysis. Cambridge University Press, Cambridge (1994)

    Google Scholar 

  15. Vassiliadis, P., Papastefanatos, G., Vassiliou, Y., Sellis, T., Hellas, I.: Management of the evolution of database-centric information systems. Download from CiteSeerX at http://citeseerx.ist.psu.edu/viewdoc/summary?doi=?doi=10.1.1.104.5372 (2008)

  16. Plangprasopchok, A., Lerman, K.: Exploiting social annotation for automatic resource discovery. In: Proceedings of AAAI workshop on Information Integration (2007)

    Google Scholar 

  17. Wu, X., Zhang, L.,Yu, Y.: Exploring social annotations for the semantic web. In: Proceedings of the WWW 2006 Conference (2006)

    Google Scholar 

  18. Li, R., Bao, S., Fei, B., Su, Z., Yu, Y.: Towards effective browsing of large scale social annotations. In Proceedings of the WWW 2007 Conference, pp. 943–952. ACM Press, New York, NY (2007)

    Google Scholar 

  19. Liu, H., Tang, T., Agarwal, N.: Tutorial on community detection and behavior. Study for social computing. Presented in the 1st IEEE International Conference on Social Computing (2009)

    Google Scholar 

  20. Agarwal, P.K., Xie, J., Yang, J., Yu, H.: Input-sensitive scalable continuous join query processing. ACM Trans. Database Syst. (TODS) 34(3) article 13 (2009)

    Google Scholar 

  21. Jayapandian, M., Jagadish, H.V.: Automating the design and construction of query forms. IEEE Trans. Knowl. Data Eng. TKDE 21(10), 1389–1402 (2009)

    Article  Google Scholar 

  22. Howe, B., Tanna, K., Turner, P., Maier, D.: Emergent semantics: towards self-organizing scientific metadata. In: Proceedings of the International Conference on Semantics of a Networked World (ICSNW), pp. 177–198 (2004)

    Google Scholar 

  23. Abiteboul, S., Polyzotis, N.: The data ring: community content sharing. In Proceedings of the 3rd Biennial Conference on Innovative Data Systems Research (CIDR), pp. 154–163 (2007)

    Google Scholar 

  24. Geerts, F., Kementsietsidis, A., Milano, D.: MONDRIAN: Annotating and querying databases through colors and blocks. In: Proceedings of the ICDE 2006 Conference (2006)

    Google Scholar 

  25. Bhagwat, D., Chiticariu, L., Tan, W., Vijayvargiya, G.: An annotation management system for relational database systems. In: Proceedings of the VLDB 2004 Conference, pp. 942–944 (2004)

    Google Scholar 

  26. Philippe, K.A. Ouksel, A. M., Catarci, T., Hacid, S., Illarramendi, A., Mecella, M., Mena, E., Neuhold, E.J., De, O., Risse, T., Scannapieco, M., Saltor, F., Santis, L.D., Spaccapietra, S., Staab, S., Studer, R.: Emergent semantics: principles and issues. In: Proceedings of the 9th International Conference on Database Systems for Advanced Applications (DASFAA 2004), pp. 25–38, Springer, Heidelberg

    Google Scholar 

  27. Santini, S., Gupta, A., Jain, R.: Emergent semantics through interaction in image databases. IEEE Trans. Knowl. Data Eng. 13(3), 337–351 (2001)

    Article  Google Scholar 

  28. Benjelloun, O., Sarma, A. D., Halevy, A., Widom, J.: Uldbs: Databases with uncertainty and lineage. In: Proceedings of the 32nd international conference on Very large data bases, VLDB Endowment, pp. 953–964 (2006)

    Google Scholar 

  29. Libkin, L.: Data exchange and incomplete information. In: Proceedings of the 25th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, Chicago, IL, USA, pp. 60–69 (2006)

    Google Scholar 

Download references

Acknowledgments

This research was sponsored by NSF under grant CAREER IIS-0347555. The author is very grateful to his Program Manager, Maria Zemankova, for her support and patience.

Author information

Authors and Affiliations

  1. Computer Engineering and Computer Science Department, University of Louisville, Louisville, KY, USA

    Antonio Badia

Authors
  1. Antonio Badia
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Antonio Badia .

Editor information

Editors and Affiliations

  1. Dept. Computer Science &, Computer Engineering, La Trobe University, Bundoora, 3083, Victoria, Australia

    Eric Pardede

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Badia, A. (2011). Social Interaction in Databases. In: Pardede, E. (eds) Community-Built Databases. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-19047-6_7

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-19047-6_7

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-19046-9

  • Online ISBN: 978-3-642-19047-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation