2005 ( 17 )

Size: px

Start display at page:

Download "2005 ( 17 )"

ゆきふじつぐ
5 years ago
Views:

1 2005 ( 17 )

2 2005 ( 17 ) (SNS) 1., 2., 3., 4., 5.

3 Abstract of Master s Thesis Academic Year 2005 The Research on the Personal Information Control based on Multiple Social Network How to communicate about myself is very important problem. We have something to tell someone or secret something not to tell someone. Such personal information control we have been is also important in online communication. There is the theory called Social Network that archive the personal information control. In this theory, friendship of human is assumed a link of graph theory. A lot of applications to communication appears, but they can not reflect multiple social network we have. In result, our communication is inhibited. This research suggests the model that we can use multiple personality. There are not differents completely because there are derived from one person. The social networking model is re-defined to realize the control of myself. The Social Networking Site (SNS) is implemented and operated for confirming the significance of this model. The model is instantiated some case example supposed, then it can archives them. This model is significant. Keywords : 1. Social Networking, 2. Access Control, 3. Self Information Control, 4. Multiple Personality, 5. Trust Keio University Graduate School of Media and Governamce NAKAYAMA, Masahiro

4 SNS mixi imeem livedoor wyco iii

5 ( ) iv

6 6.5.1 SNS UNIX group A 66

7 mixi livedoor wyco wyco Perso ( ) Perso ( )

8 Catalyst Plugins

9 [1] 7 1 1

11 ( ) : 3

12 1.1.3 [2] SNS [3] SNS [4] [5] mixi SNS SNS OpenPNE[6] SNS SNS [7][8] 4

13 SNS 1 [9][10] SNS SNS

14 2hop

17 Weblog

18 1 2.3 SNS SNS( ) SNS mixi imeem Livedoor wyco mixi SNS mixi[11] mixi 2.1 mixi 10

19 2.1: mixi 11

20 : 12

21 2.3.2 imeem imeem[12] SNS imeem 2.3 imeem imeem imeem imeem The world (web publishable) SNS 13

22 2.3: 14

23 2.3.3 livedoor livedoor [13] mixi SNS livedoor 2.5 mixi livedoor mixi : 15

24 2.5: livedoor 16

25 2.3.4 wyco wyco[14] SNS

26 2.6: wyco 18

27 2.7: wyco 19

28 2.3.5 SNS : SNS 20

29 WWW 2.1: WWW mixi livedoor mixi, imeem imeem wyco wyco livedoor SNS 21

30 : A A 22

31 A A A 3.2 A A A A A A A A A A A # $!%'&(*)! " 3.2: 23

32 ! 3.3:

33 3.2.3 SNS

34 3.3 26

35 SNS

36 : : 1 17 (60.7%) 2 7 (25.0%) 3 4 (14.3%)

37 4.3:

38 4.2.3 SNS JOIN SNS 30

39 4.2.4 A SNS (Q ) SNS SNS SNS SNS (Q ) SNS [15] 5 4 [15] 43.22% SNS (Q201) Q201 ( ) (Q ) Q203 31

40 (Q204) 32

41 5 Perso 5.1 mixi GREE[16] : PC/AT CPU Intel Celeron CPU 566MHz OS CentOS release 4.2 Perl Catalyst 5.61 mod perl RC5 / Apache OR DBIx::Class / DBD::mysql Template-Toolkit 2.14 RDBMS MySQL

42 Catalyst[17] Catalyst Apache[18] mod perl[19] MVC Perl[20] Template-Toolkit[21] DBIx::Class[22] O/R DBIx::Class RDBMS MySQL[23] DBIx::Class O/R RDBMS RDBMS Catalyst SNS Perso::Model::DB Perso::Controller HTML MVC Apache Perl mod perl Catalyst Catalyst 34

43 >>?? BB >>> :::: ; < =; > >@??A 0 0B B6 ; *C ; *C D> $7 89& EF;GHJI/KLNMOQP (2 *+&,3# ### #### $ 4'5*6 * () *+&,-# ### ####./ 0 #### #### 1 "!# ### #### $% &'& 5.1: 35

44 Catalyst : Catalyst Plugins Dumper StackTrace DateTime Config::YAML DefaultEnds FormValidator::Simple RequestToken FillInForm :Japanese Session Session::Store::File Session::State::Cookie Authentication Authentication::Credential::Password Authentication::Store::DBIC Authorization::Roles Static::Simple Redirect : : CSRF Catalyst HTML Template-Toolkit DBIx::Class SNS 36

45 SQL Perso MySQL MySQL 37

46 5.3: users Users user roles UserRoles roles Roles people People link requests LinkRequests links Links sameperson Sameperson faces Faces ( ) fof Fof Friend of Friend invitations Invitations Perso person attribute types PersonAttributeTypes person attributes PersonAttributes diary articles DiaryArticles diary comments DiaryComments diary permission DiaryPermission diary trackbacks DiaryTrackbacks communities Communities person has communities PersonHasCommunities community comments CommunityComments community invitations CommunityInvitations community topics CommunityTopics incoming comments IncomingComments incoming diaries IncomingDiaries incoming events IncomingEvents system message SystemMessage 38

47 5.2: 39

48 #! " 5.3: Perso ( ) 40

49 !#" #$#%'&)(+*,-!#. /10 2! 3! :1+;+< = >#? 5.4: Perso ( ) 41

50 5.4.1 ( ) 5.5: 42

52 5.6: 44

53 : 45

54 : 46

55 : 47

56 : 48

57 : users Perso::Model::DB::Users ID 49

58 distance distance is myself is friend is fof JOIN people Perso::Model::DB::People ID person attributes readable attributes link friend unlink friend links fof fof 2 50

59 6 6.1 Q SNS 51

61 : 53

62 SNS SNS ID ID RDBMS 54

63 Q103 Q104 Q UNIX group UNIX SNS

64 SNS 56

65 6.8.3 SNS HTTP cookie SQL SELECT me.passwd, me. , me.registered_time, me.id FROM users me WHERE ( =? ) SQL ID SNS SQL SELECT me.name, me.user_id, me.id FROM people me WHERE ( user_id =? ) SELECT me.name, me.user_id, me.id FROM people me LEFT JOIN links link_from_me ON ( link_from_me.link_from = me.id ) WHERE ( link_from_me.link_to =? ) SELECT me.name, me.user_id, me.id FROM people me LEFT JOIN links link_from_me ON ( link_from_me.link_from = me.id ) WHERE ( link_from_me.link_to =? ) ID(user id) O n O(n) 57

66 2 SNS ID ID ID SQL SELECT me.name, me.user_id, me.id FROM people me WHERE ( ( ( user_id =? ) AND ( id =? ) ) ) people ID people links SNS SQL SELECT COUNT(*) FROM links me JOIN people link_to ON ( link_to.id = me.link_to ) LEFT JOIN sameperson rel_sameperson ON ( rel_sameperson.same_to = me.link_from ) WHERE ( ( link_from =? AND link_to.user_id =? ) OR ( link_to.user_id =? AND rel_sameperson.same_from =? ) ) people links sameperson JOIN EXPLAIN 58

67 mysql> EXPLAIN SELECT COUNT(*) FROM links me -> JOIN people link_to ON ( link_to.id = me.link_to ) -> LEFT JOIN sameperson rel_sameperson -> ON ( rel_sameperson.same_to = me.link_from ) -> WHERE ( ( link_from = 8 AND link_to.user_id = 1 ) -> OR ( link_to.user_id = 1 AND rel_sameperson.same_from = 8 ) ) \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: link_to type: ref possible_keys: PRIMARY,people_FKIndex1 key: people_fkindex1 key_len: 4 ref: const rows: 1 Extra: Using index *************************** 2. row *************************** id: 1 select_type: SIMPLE table: me type: ref possible_keys: PRIMARY,links_pairunique,links_FKIndex1,links_FKIndex2 key: links_fkindex2 key_len: 4 ref: persotest.link_to.id rows: 1 Extra: Using index *************************** 3. row *************************** id: 1 select_type: SIMPLE table: rel_sameperson type: ref possible_keys: sameperson_fkindex2 key: sameperson_fkindex2 key_len: 4 ref: persotest.me.link_from rows: 1 Extra: Using where; Using index 3 rows in set (0.00 sec) 59

68 MySQL ID people people user id people JOIN links sameperson LEFT JOIN WHERE SNS MySQL BTree O(logN) fof sameperson JOIN 6.9 SNS SNS SNS 6.10 SNS SNS 60

69 7 7.1 (SNS) Affelio[24] 61

70 SNS SNS SNS 62

71 neco pub NetMeeting A4 IRCnet 7 63

72 [1]. [2] : scrap book. [3]. [4] 2005 web. [5] Itmedia mixi. [6] openpne. news/archives/ html. [7] sns. [8] sns filn. [9] sns otaba. [10] : [11] [mixi( )]. [12] imeem! [13] livedoor. [14] wyco 20 sns. [15]. [16] (gree) :. 64

73 [17] Catalyst - web framework. [18] The apache http server project. [19] mod perl: Welcome to the mod perl world. [20] Perl.com. [21] Template toolkit home page. [22] Dbix-class - search.cpan.org. [23] Mysql ab :: The world s most popular open source database. [24] Affelio - -the open social network-.

74 A Q101 (SNS) Q102 SNS SNS Q103 SNS SNS

75 Q104 SNS Perso Q Q202 Perso

76 Q Q204 Perso ( ) Q205 Perso SNS

Web Web Web Web i

28 Research of password manager using pattern lock and user certificate 1170369 2017 2 28 Web Web Web Web i Abstract Research of password manager using pattern lock and user certificate Takuya Mimoto In