Database Reference
In-Depth Information
Fig. 9.20 Adding the node
thesis on the
Student
hypernode
Student_1
St_id
St_name
St_lastname
03
Mohsen
Ali
Director_thesis_2
Thesis_1
Dir-id
Thesis
Director_thesis_WeberJean
38
Dir-id
Lab_id
Laboratory_1
Thesis
Thesis_1
Thesis_3
Director_thesis_LochanNorman
Dir-id
27
Student_MohsenAli
Lab_id
Laboratory_1
Thesis
Thesis_2
St_id
03
IS-A
Foreign_Student
Egypt
Country
Student_YenYang
Student_JackPierre
St_id
Dir-id
Director_thesis_2
St_id
IS-A
Country
12
05
Thesis_1
Thesis
Dir-id
Director_thesis_1
Foreign_Student
China
Thesis
Thesis_2
Dir-id
Director_thesis_2
Thesis_3
Thesis
Fig. 9.21 Corresponding social network
-P
4
:
, by this pattern
we search all the students who share the same thesis (not found in our data).
- From the relation R
h4
:
¼<
Same_Thesis, Student
i
, Student
j
,
Thesis_hasStudent
>
¼<
””, Thesis, Director_thesis
>
, there is no identified
pattern because
Thesis
is not related to other entities.
After identifying relations and entities, the final social network is obtained by
applying all the previous detection (people and their relations) and giving as a tag
for each hypernode its type and the name of the corresponding person (see
Fig.
9.21
)
9.5
Implementation and Evaluation
In order to demonstrate the effectiveness and the validity of the proposed approach,
a prototype has been developed. The prototype was implemented using Java and
PostgreSQL. We have visualized the output database and the social network using
SNA
12
(Fig.
9.22
).
The hypernode database will be stored in an adapted database management
system that also allows the storage of voluminous complex graphs.
12
http://www.sapweb20.com/blog/2009/03/sap-enterprise-social-networking-prototype/
Search WWH ::
Custom Search