DOI QR코드

DOI QR Code

Design and Implementation of an Unified Cursor Considering Synchronization on the Android Mobile Platform

안드로이드 플랫폼 상에서 동기화가 고려된 통합 커서의 설계 및 구현

  • 김경환 (LG전자 미래IT융합연구소) ;
  • 하주호 (LG전자 미래IT융합연구소) ;
  • 원종필 (LG전자 미래IT융합연구소) ;
  • 이의성 (LG전자 미래IT융합연구소) ;
  • 김주민 (LG전자 미래IT융합연구소) ;
  • 손진호 (LG전자 미래IT융합연구소)
  • Received : 2011.02.28
  • Accepted : 2011.03.28
  • Published : 2011.06.30

Abstract

Android platform provides a content provider and a cursor mechanism to access the internal SQLite engine. Content providers not only store and retrieve data but also make it accessible to applications. Applications can only share data through content provider, since there's no common storage area that Android packages can access. Cursor is an interface that provides random read-write access to the result set returned by a database query. However, this cursor possesses two major limitations. First, a cursor does not support a join clause among cursors, since the cursor can only access a single table in the content provider. Second, the cursor is not capable of creating user-customized field in the predefined content providers. In this paper, we propose the unified cursor architecture that merges several cursors into a single virtual cursor. Cursor translation look-aside buffer (TLB), column windowing mechanism and virtual data management are the three major techniques we have adopted to implement our structure. And we also propose a delayed synchronization method between an application and a proposed unified cursor. An application can create a user-customized field and sort multiple tables using a unified cursor on Android platform.

Keywords

References

  1. http://d.android.com/guide/
  2. http://en.wikipedia.org/wiki/Sqlite
  3. 김상형, 안드로이드 프로그래밍 정복, 한빛미디어(주), 2010.
  4. Erich Gamma, Richard Helm, Ralph Johnson, "Design Patterns: Elements of Reusable Object-Oriented Software", Addison-Wesley, Professional, first edition, 1994.
  5. A. Eisenberg, J. Melton, "SQL Standardization: The Next Steps", ACM SIGMOD Record, 29(1), pp. 63-67, 2000. https://doi.org/10.1145/344788.344819
  6. R. Rashid, A. Tevanian, M. Young, D. Golub, R. Baron, D. Black, W. Bolosky, J. Chew. "Machine-Independent virtual memory management for paged uniprocessor and Multiprocessor Architectures", IEEE tansactions on Computers, Vol.37(8), pp. 896-908, Aug. 1988. https://doi.org/10.1109/12.2242
  7. Mark L., "Beginning android", first edition, Apress, 2009.
  8. http://download.oracle.com/iavase/7/docs/api/
  9. 진희규, 이기용, 우경구, "멀티미디어 CE 기기를 위한 빠른 질의 복구 기법", 정보과학회논문지, Vol.35, No.3, pp. 286-205, 2008.
  10. Silberschatz A., Korth H., Sudarshan, S. "Database System Concepts", 4th edition, McGrawHill, 2001.
  11. http://en.wikipedia.org/wiki/CRUD