안드로이드 플랫폼 상에서 동기화가 고려된 통합 커서의 설계 및 구현 = Design and Implementation of an Unified Cursor Considering Synchronization on the Android Mobile Platform

다국어 초록 (Multilingual 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.

참고문헌 (Reference)

1 김상형, "안드로이드 프로그래밍 정복" 한빛미디어(주) 2010

2 진희규, "멀티미디어 CE 기기를 위한 빠른 질의 복구 기법" 한국정보과학회 35 (35): 286-295, 2008

3 "http://en.wikipedia.org/wiki/Sqlite"

4 "http://en.wikipedia.org/wiki/CRUD"

5 "http://download.oracle.com/javase/7/docs/api/"

6 "http://d.android.com/guide/"

7 A. Eisenberg, "SQL Standardization:The Next Steps" 29 (29): 63-67, 2000

8 R. Rashid, "Machine-Independent virtual memory management for paged uniprocessor and Multiprocessor Architectures" 37 (37): 896-908, 1988

9 Erich Gamma, "Design Patterns:Elements of Reusable Object-Oriented Software" Addison-Wesley 1994

10 Silberschatz A, "Database System Concepts, 4th edition" McGrawHill 2001

11 Mark L, "Beginning android, first edition" Apress 2009