數(shù)據(jù)庫概論-表結(jié)構(gòu)

SOCIALNETWORKBENCHMARKCSVFILESCREATEDBYTHESNDATAGENERATORThisdocumentpresentstheCSVfilesgeneratedbythedatagenerator.ThereisaCSVfileforeachentityandrelationship.Themono-valuedattributesofanentity/relationareincludedinthefileofthecorrespondingentity/relation.Whenanattributeismulti-valuedthedataisstoredinaseparatedCSVfile.ThefollowingtablesummarizestheCSVfiles.NameFilenameEntitiesPersonperson.csvForumforum.csvPostpost.csvCommentcomment.csvOrganization(University|Company)organization.csvPlace(city|country|continent)place.csvTagtag.csvTagClasstagclass.csvRelationshipsandmultivaluedattributesPerson.emailperson_email_emailaddress.csvPerson.hasInterestperson_hasInterest_tag.csvPerson.isLocatedInperson_isLocatedIn_place.csvPerson.knowsperson_knows_person.csvPerson.likesperson_likes_post.csvPerson.speaksperson_speaks_language.csvPerson.studyAtperson_studyAt_organisation.csvPerson.workAtperson_workAt_organisation.csvForum.containerOfforum_containerOf_post.csvForum.hasMemberforum_hasMember_person.csvForum.hasModeratorforum_hasModerator_person.csvForum.hasTagforum_hasTag_tag.csvPost.hasCreatorpost_hasCreator_person.csvPost.hasTagpost_hasTag_tag.csvComment.hasCreatorcomment_hasCreator_person.csvComment.insLocatedIncomment_isLocatedIn_place.csvComment.replyOfcomment_replyOf_comment.csvComment.replyOfcomment_replyOf_post.csvOrganization.isLocatedInorganisation_isLocatedIn_place.csvPlace.isPartOfplace_isPartOf_place.csvTag.hasTypetag_hasType_tagclass.csvtagClass.isSubClassOftagclass_isSubclassOf_tagclass.csvPERSONperson.csvidfirstNamelastNamegenderbirthdaycreationDatelocationIPbrowserUsed6906HaoWangmale04-12-862010-02-23T06:47:31Z1Chromeperson_email_emailaddress.csvPerson.idemail6906Hao6906@person_hasInterest_tag.csvPerson.idTag.id69062080person_isLocatedIn_place.csvPerson.idPlace.id0622person_knows_person.csvPerson.idPerson.id69067279person_likes_post.csvPerson.IdPost.IdcreationDate49502011-01-23T01:11:55Zperson_speaks_language.csvPerson.idLanguage6906enperson_studyAt_organisation.csvPerson.idOrganization.idclassYear690602006person_workAt_organisation.csvPerson.idOrganization.idworkFrom6906102020FORUMforum.csvidtitlecreationDate13812WallofHaoWang2010-02-23T06:47:31Zforum_containerOf_post.csvForum.idPost.id138120forum_hasMember_person.csvForum.IdPerson.IdjoinDate1381272792011-01-10T00:43:11Zforum_hasModerator_person.csvForum.IdPerson.Id1381206906forum_hasTag_tag.csvForum.IdTag.Id69062080POSTpost.csvidimageFilecreationDatelocationIPbrowserUsedlanguagecontent3930Photo393.jpg

2011-01-16T09:27:52ZFirefoxruAbout...post_hasCreator_person.csvPost.IdPerson.Id106906post_hasTag_tag.csvPost.IdTag.Id102080post_isLocatedIn_place.csvPost.IdPlace.Id1073COMMENTcomment.csvidcreationDatelocationIPbrowserUsedcomment02010-08-21T02:14:51Z6ChromeAboutJeffBment_hasCreator_person.csvComment.IdPerson.Id10448comment_isLocatedIn_place.csvComment.IdPlace.Id1073comment_replyOf_comment.csvComment.IdComment.Id2010comment_replyOf_post.csvComment.IdPost.Id10100ORGANIZATIONorganisation.csvidtypenameurl10universityUniversidad_de_Oriente/resource/Universidad_de_OrienteNote.Thefield“type”willcontainavalueintheset{university,company).organisation_isLocatedIn_place.csvOrganization.idPlace.id1087PLACEplace.csvidnameurltype5170South_America/resource/South_AmericacontinentNote.Thefield“type”willcontainavalueintheset{city,country,continent}place_isPartOf_place.csvPlace.idPlace.id735168TAGtag.csvIdnameurl2080Jeff_Beck/resource/J