Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2007.14-D.6.615

An Efficient Database Design Method for Mobile Multimedia Services on Home Network Systems  

Song, Hye-Ju (숙명여자대학교 멀티미디어과학과)
Park, Young-Ho (숙명여자대학교 멀티미디어과학과)
Kim, Jung-Tae (한국전자통신연구원 유비쿼터스 홈서비스 연구팀)
Paik, Eui-Hyun (한국전자통신연구원 유비쿼터스 홈서비스 연구팀)
Publication Information
The KIPS Transactions:PartD / v.14D, no.6, 2007 , pp. 615-622 More about this Journal
Abstract
Recently, users who want to be provided motile devices, such as PDP, PMP, and IPTV connected wireless internet, with multimedia contents are increasing due to an influence of multimedia contents. In the paper, we propose an efficient database design method for managing mobile multimedia services on home network systems. For this, we build relations using attributes required while providing multimedia services, and then design a database. Specially, we propose a database design method based on normalization theory to eliminate redundancies and update anomalies caused by a non trivial multi valued dependency in relations. In the experiments, we compare and analyze occurrence frequencies of data redundancies and update anomalies through query executions on the relation decomposed into normal forms. The results reveal that our database design is failrly effective.
Keywords
Home Network; Home Network Service; Database; MVD(Multi-Valued Dependency);
Citations & Related Records
연도 인용수 순위
  • Reference
1 J. Biskup, U. Dayal, and P. Bernstein. 'Synthesizing Independent DatabaseSchemes,' In Proc. 1979 ACM SIGMOD Int'l Conf. on Management of Data, pp.143-151, Boston, 1979
2 Catriel Beeri, Ronald Fagin, and John H. Howard, 'A Complete Axiomatization for Functional and Multivalued Dependencies in Database Relations,' In Proc. 1977 ACM SIGMOD Int'l Conf. on Management of Data, pp. 47-61, Toronto, Canada, Aug., 1977   DOI
3 McCarthy, Dennis R, and Umeshwqr Dayal, 'TheArchitecture of an Active Database Management System,' In Proc. 1989 ACM SIGMOD Int'l Conf. on Management of Data, pp.215-224, Portland, June, 1989
4 P. M. Ahmed Al-Theneyan and M. Zubair. 'Enancing Jini for use across non-multicastable networks,' In ICASE Report, No.2000-34, 2000
5 R. Fagin, 'Multivalued dependencies and a new normal form for relational databases,' ACM Tans on Database Systems 2:3, pp. 262-278, Vol.2, No.3, Sep., 1977   DOI   ScienceOn
6 Carlo. Zaniolo, 'A New Normal Form for the Design of Relational Database Schemata,' ACM Tans. on Database Systems(TODS), Sep., 1982   DOI
7 B. Rose, 'Home networks: a standards perspeotive,' Communications Magazine, IEEE Vol.39, pp.75-85, Dec., 2001
8 Ming -Syan Chen, Jiawei Han, and Philip Yu, 'Data Mining: An Overview from a Database Perspective,' IEEE Transactions on Knowledge and Data Engineering(TKDE), Vol.8, Num. 6, pp.866-883, 1996   DOI   ScienceOn
9 Dey, A. K, et al., 'A Conceptual Framework anda Toolkit for Supporting the Rapid Prototyping of Context-Aware Computing,' HCI Journal, Vol.16, pp.97 - 166, 2001   DOI   ScienceOn
10 Hong. J.I, et al., 'An Infrastructure Approach to Context-Aware Computing,' HCI Journal, Vol.16, pp.287-303, 2001   DOI
11 S. Hartmann, and S. Link, Multi-valued dependencies in the presence of lists,' In Proc. the 23rd SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, pp.330 - 341, 2004   DOI
12 S. Lee, H.J.Choi, C.H. Kim, and S.M. Back, 'ANew Control Protocol for Home Applicances - LnCP,' In Proc. ISIE 2001, Vol.1, pp. 286-291, 2001   DOI
13 E. F. Codd, 'A relational model of data for large shared data banks,' Communications of the ACM, Vol.13 No.6, pp. 377-387, June, 1970   DOI
14 E. F. Codd, 'Extending the database relational model to capture more meaning,' ACM Tans. on Database Systems (TODS), Vol.4, pp. 397-434,Dec., 1979   DOI   ScienceOn
15 P. C. Fisher, D.M. Tsou, 'Whether a Set of Multivalued Dependencies Impliesa Join Dependenc is NP Hard,' SIAM Journal, pp. 259-266, 1983
16 C. Ellison, 'Device Security:1 Service Template,' UPnP Forum, Nov., 2003
17 Al-Fayoumi, Nabeel, 'Tempral Trigger Processin g in the Trigger Man Active DBMS,' Univ. of Florida, Aug., 1998
18 Jeffrey D. Ullman, 'Principles of Database Systems, 2nd Edition.' Computer Science Press, ISBN 0-914894-36-6BibTeX, 1982