Browse > Article

A Lifelog Management System Based on the Relational Data Model and its Applications  

Song, In-Chul (KAIST 전산학과)
Lee, Yu-Won (KAIST 전산학과)
Kim, Hyeon-Gyu (KAIST 전산학과)
Kim, Hang-Kyu (KAIST 전산학과)
Haam, Deok-Min (KAIST 전산학과)
Kim, Myoung-Ho (KAIST 전산학과)
Abstract
As the cost of disks decreases, PCs are soon expected to be equipped with a disk of 1TB or more. Assuming that a single person generates 1GB of data per month, 1TB is enough to store data for the entire lifetime of a person. This has lead to the growth of researches on lifelog management, which manages what people see and listen to in everyday life. Although many different lifelog management systems have been proposed, including those based on the relational data model, based on ontology, and based on file systems, they have all advantages and disadvantages: Those based on the relational data model provide good query processing performance but they do not support complex queries properly; Those based on ontology handle more complex queries but their performances are not satisfactory: Those based on file systems support only keyword queries. Moreover, these systems are lack of support for lifelog group management and do not provide a convenient user interface for modifying and adding tags (metadata) to lifelogs for effective lifelog search. To address these problems, we propose a lifelog management system based on the relational data model. The proposed system models lifelogs by using the relational data model and transforms queries on lifelogs into SQL statements, which results in good query processing performance. It also supports a simplified relationship query that finds a lifelog based on other lifelogs directly related to it, to overcome the disadvantage of not supporting complex queries properly. In addition, the proposed system supports for the management of lifelog groups by providing ways to create, edit, search, play, and share them. Finally, it is equipped with a tagging tool that helps the user to modify and add tags conveniently through the ion of various tags. This paper describes the design and implementation of the proposed system and its various applications.
Keywords
Lifelog Management System; Relational Data Model; Relationship Query; Lifelog Group; Tagging;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Gemmel, J., Bell, G., and Lueder, R., “MyLifeBits: A Personal Database for Everything,” Comm. ACM, vol.49, no.1. pp.88-95, 2006   DOI   ScienceOn
2 Freeman, E. and Gelernter, D., “Lifestreams: A Storage Model for Personal Data,” SIGMOD Record, vol.25, no.1. pp.80-86, 1996   DOI
3 NMEA 0183 Standard. http://www.nmea.org/content/nmea_standards/nmea_083_v_400.asp
4 MetaWeblog API. http://www,xmlrpc.com/metaWeblogAPi
5 The Open Computer Vision Library. http://sourceforge.net/projects/opencvlibrary/
6 Turk, M. and Pentland, A., "Eigenfaces for recog-nition," Journal of Cognitive Neuroscience, vol.3, no.1, pp.71-86, 1991   DOI   ScienceOn
7 JSON Script. http://json.org
8 Social Bookmarking. http://del.icio.us
9 Oracle Text. http://www.oracle.com/technology/products/text/index.html
10 Dittrich, J. and Salles, M. A., “iDM: A Unified and Versatile Data Model for Personal Dataspaee Management,” In Proc. of VLDB, 2006
11 Yates, R. B. and Neto, B. R., "Modern Information Retrieval," Addison Wesley, 1999
12 Dumais, S., Cutrell, E., Cadiz, JJ, Jancke, G., Sarin, R., Robbins, D. C., “Stuff I've Seen: A System for Personal Information Retrieval and Re-Use,” In Proc. of SIGIR, 2003   DOI
13 Franklin, M., Halevy, A., and Maier, D., "From Databases to Dataspaces: A New Abstraction for Information Management," SIGMOD Record, vol.34, no.4, pp.27-33, 2005   DOI   ScienceOn
14 Dong, X. and Halevy, A., “A Platform for Per-sonal Information Management and Integration,” In Proc. of CIDR, 2005
15 Sony GPS-CS1. http://www.sonystyle.com/webapp/wcs/stores/servlet/ProductDisplay?catalogId=10551&storeId=10151&langId=-1&partNumber=GPSCS1
16 Google Desktop. http://desktop.google.com
17 Naver Map API. http://dev.naver.com/openapi/apis/map/javascript/example
18 Karger, D. R., Bakshi, K., Huynh, D., Quan, D., and Sinha, V., “Haystack: A Customizable General-Purpose information Management Tool for End Users of Semistructured Data,” in Proc. of CIDR, 2005