1 Affiliation : Department of Information Technology, Faculty of Computers and Information, Zagazig University, Zagazig 44519, Egypt
Email : email@example.com
2 Affiliation : Department of Information Technology, Faculty of Computers and Information, Zagazig University, Zagazig 44519, Egypt
Email : firstname.lastname@example.org
3 Affiliation : Department of Information Technology, Faculty of Computers and Information, Zagazig University, Zagazig 44519, Egypt
Email : email@example.com
Most people are more or less related to the web by participating in a kind of social networking site. Semantic Web technology plays a crucial role in these sites as they contain an enormous amount of data about persons, pages, events, places, corporations, etc. This research is a Semantic Web application designed to create a new semantic social community called Socialpedia. It links the already existing social public information to the newly public ones. This information is linked with different information on the web to construct a new immense data container. The resulting data container can be processed using a variety of Semantic Web techniques to produce machine-understandable content. This content shows the promise of using integrated data to improve Web search and Web-scale data analysis, unlike conventional search engines or social ones. This community involves obtaining data from traditional users known as contributors or participants, linking data from existing social networks, extracting structured data in triples using predefined ontologies, and finally querying and inferring such data to obtain meaningful pieces of information. Socailpedia supports all popular functionalities of social networking websites besides the enhanced features of the Semantic Web, providing advanced semantic search that acts as a semantic search engine.
Ontology , OWL , RDF , R2RML , SPARQL , Semantic Web (SW) , Semantic Search , Social Networking Sites (SNSs)
 Berners-Lee T., Hendler J., and Lassila O., "The Semantic Web," Scientific American, vol. 284, pp. 34-43, 2001.
 Mika P., "Social networks and the semantic web," in Proceedings of the 2004 ieee/wic/acm international conference on web intelligence, 2004, pp. 285-291.
 Shadbolt N., Berners-Lee T., and Hall W., "The semantic web revisited," IEEE intelligent systems, vol. 21, pp. 96-101, 2006.
 Manola F., Miller E., and McBride B., "RDF 1.1 primer, W3C working group note," 2014.
 Prud’hommeaux E. and Seaborne A., "SPARQL query language for RDF, W3C Candidate Recommendation (2006)," http://www.w3.org/TR/rdf-sparql-query/, 2007.
 Motik B., Patel-Schneider P. F., Parsia B., Bock C., Fokoue A., Haase P., et al., "OWL 2 web ontology language: Structural specification and functional-style syntax," W3C recommendation, vol. 27, p. 159, 2009.
 Baader F., Calvanese D., McGuinness D., Patel-Schneider P., and Nardi D., The description logic handbook: Theory, implementation and applications: Cambridge university press, 2003.
 Gjoka M., Kurant M., Butts C. T., and Markopoulou A., "Walking in facebook: A case study of unbiased sampling of osns," in 2010 Proceedings IEEE Infocom, 2010, pp. 1-9.
 Catanese S. A., De Meo P., Ferrara E., Fiumara G., and Provetti A., "Crawling facebook for social network analysis purposes," in Proceedings of the international conference on web intelligence, mining and semantics, 2011, pp. 1-8.
 Ferrara E., De Meo P., Fiumara G., and Baumgartner R., "Web data extraction, applications and techniques: A survey," Knowledge-based systems, vol. 70, pp. 301-323, 2014.
 Dong X. L. and Srivastava D., "Big data integration," in 2013 IEEE 29th international conference on data engineering (ICDE), 2013, pp. 1245-1248.
 Duggan J., Elmore A. J., Stonebraker M., Balazinska M., Howe B., Kepner J., et al., "The bigdawg polystore system," ACM Sigmod Record, vol. 44, pp. 11-16, 2015.
 Sahoo S. S., Halb W., Hellmann S., Idehen K., Thibodeau Jr T., Auer S., et al., "A survey of current approaches for mapping of relational databases to RDF," W3C RDB2RDF Incubator Group Report, vol. 1, pp. 113-130, 2009.
 Spanos D.-E., Stavrou P., and Mitrou N., "Bringing relational databases into the semantic web: A survey," Semantic Web, vol. 3, pp. 169-209, 2012.
 Hazber M., Yang J., and Jin Q., "Towards integration rules of mapping from relational databases to semantic web ontology," in 2010 International Conference on Web Information Systems and Mining, 2010, pp. 335-339.
 Vavliakis K. N., Grollios T. K., and Mitkas P. A., "RDOTE–Publishing Relational Databases into the Semantic Web," Journal of Systems and Software, vol. 86, pp. 89-99, 2013.
 Sequeda J. F., Arenas M., and Miranker D. P., "On directly mapping relational databases to RDF and OWL," in Proceedings of the 21st international conference on World Wide Web, 2012, pp. 649-658.
 Bumans G., "Mapping between Relational Databases and OWL Ontologies: an example," Scientific Papers, University of Latvia, vol. 756, pp. 99-117, 2010.
 Jain V. and Prasad S., "Mapping Between RDBMS And Ontology: A Review," International Journal of Scientific & Technology Research, vol. 3, pp. 307-313, 2014.
 Čerāns K. and Būmans G., "RDB2OWL: a language and tool for database to ontology mapping," in Proceedings of the CAiSE 2015 Forum at the 27th International Conference on Advanced Information Systems Engineering (CAiSE 2015), Kista, Sweden, 2015, pp. 81-88.
 Hazber M. A., Li R., Zhang Y., and Xu G., "An approach for mapping relational database into ontology," in 2015 12th Web Information System and Application Conference (WISA), 2015, pp. 120-125.
 Jain V. and Singh M., "A framework to convert relational database to ontology for knowledge database in semantic web," International Journal of Scientific & Technology Research, vol. 2, pp. 9-12, 2013.
 Arenas M., Bertails A., Prud’hommeaux E., and Sequeda J., "A direct mapping of relational data to RDF," W3C recommendation, vol. 27, pp. 1-11, 2012.
 Sequeda J. F., Tirmizi S. H., Corcho O., and Miranker D. P., "Survey of directly mapping SQL databases to the Semantic Web," Knowledge Engineering Review, vol. 26, pp. 445-486, 2011.
 Souripriya D., Seema S., and Richard C. (2012). R2RML: RDB to RDF mapping language. W3C Recommendation, World Wide Web Consortium, September 2012. Available: http://www.w3.org/TR/r2rml/.
 Beckett D., Berners-Lee T., Prud’hommeaux E., and Carothers G., "RDF 1.1 Turtle," World Wide Web Consortium, 2014.
 Auer S., Dietzold S., Lehmann J., Hellmann S., and Aumueller D., "Triplify: light-weight linked data publication from relational databases," in Proceedings of the 18th international conference on World wide web, 2009, pp. 621-630.
 Bizer C. and Cyganiak R., "D2r server-publishing relational databases on the semantic web," in Poster at the 5th international semantic web conference, 2006.
 Barrasa J., Corcho Ó., and Gómez-Pérez A., "R2O, an extensible and semantically based database-to-ontology mapping language," in Proceedings of the 2nd Workshop on Semantic Web and Databases, Toronto, Canada, 2004.
 OpenLink Virtuoso Universal Server. Available at: http://virtuoso.openlinksw.com.
 DB2Triples. Available: https://github.com/antidot/db2triples.
 Morph-RDB. Available: https://github.com/oeg-upm/morph-rdb.
 RDF Graph Features | Oracle Spatial and Graph. Available: https://www.oracle.com/database/technologies/spatialandgraph/rdf-graph-features.html.
 RDF-RDB2RDF. Available: https://metacpan.org/release/RDF-RDB2RDF.
 XSPARQL. Available: https://sourceforge.net/projects/xsparql/files/xsparql/.
 Sequeda J. F. and Miranker D. P., "Ultrawrap: SPARQL execution on relational data," Journal of Web Semantics, vol. 22, pp. 19-39, 2013.
 Ultrawrap. Available: http://capsenta.com/ultrawrap.
 Boris Villazón-Terrazas M. H. (2012). RDB2RDF Implementation Report. Available: https://www.w3.org/TR/rdb2rdf-implementations/.
 Boris Villazón-Terrazas M. H. (2012). R2RML and Direct Mapping Test Cases. Available: https://www.w3.org/TR/rdb2rdf-test-cases/.
 Daoud A. M., Hosny K. M., and Mohamed E. R., "Semantic Representation of Music Database Using New Ontology-Based System," Journal of Theoretical and Applied Information Technology, vol. 98, 2020.
 Kumar A. P., Kumar A., and Kumar V. N., "A comprehensive comparative study of SPARQL and SQL," International Journal of Computer Science and Information Technologies, vol. 2, pp. 1706-1710, 2011.
 Alaoui L., Abatal A., Alaoui K., Bahaj M., and Cherti I., "SQL to SPARQL mapping for RDF querying based on a new Efficient Schema Conversion Technique," International Journal of Engineering Research and Technology, vol. 4, 2015.
 Soussi N. and Bahaj M., "Semantics preserving SQL-to-SPARQL query translation for Nested Right and Left Outer Join," Journal of applied research and technology, vol. 15, pp. 504-512, 2017.
 Rodriguez-Muro M., Kontchakov R., and Zakharyaschev M., "Ontology-based data access: Ontop of databases," in International Semantic Web Conference. Springer, Berlin, Heidelberg, 2013, pp. 558-573.
 Calvanese D., Cogrel B., Komla-Ebri S., Kontchakov R., Lanti D., Rezk M., et al., "Ontop: Answering SPARQL queries over relational databases," Semantic Web, vol. 8, pp. 471-487, 2017.
 Rodrıguez-Muro M., Hardi J., and Calvanese D., "Quest: efficient SPARQL-to-SQL for RDF and OWL," in 11th International Semantic Web Conference ISWC, 2012, p. 53.
 Rodriguez-Muro M., Rezk M., Hardi J., Slusnys M., Bagosi T., and Calvanese D., "Evaluating SPARQL-to-SQL translation in ontop," in In Proc. of the 2nd Int. Workshop on OWL Reasoner Evaluation (ORE), volume 1015 of CEUR Electronic Workshop Proceedings, pages 94– 100, 2013.
 Kontchakov R., Rezk M., Rodriguez-Muro M., Xiao G., and Zakharyaschev M., "Answering SPARQL queries over databases under OWL 2 QL entailment regime," in International Semantic Web Conference, 2014, pp. 552-567.
 Rodriguez-Muro M. and Rezk M., "Efficient SPARQL-to-SQL with R2RML mappings," Journal of Web Semantics, vol. 33, pp. 141-169, 2015.
 Brickley D. and Miller L. (2007). FOAF vocabulary specification 0.91. Available at: http://xmlns.com/foaf/spec/.
 Golbeck J. and Rothstein M., "Linking Social Networks on the Web with FOAF: A Semantic Web Case Study," in AAAI, 2008, pp. 1138-1143.
 Mika P., "Flink: Semantic web technology for the extraction and analysis of social networks," Journal of web semantics, vol. 3, pp. 211-223, 2005.
 Tang J., Zhang D., and Yao L., "Social network extraction of academic researchers," in Seventh IEEE International Conference on Data Mining (ICDM 2007), 2007, pp. 292-301.
 Nasution M. K. and Noah S. A., "Extraction of academic social network from online database," in 2011 International Conference on Semantic Technology and Information Retrieval, 2011, pp. 64-69.
 Sander M., Waltinger U., Roshchin M., and Runkler T., "Ontology-based translation of natural language queries to SPARQL," in 2014 AAAI Fall Symposium Series, 2014.