NDLI: On the IO characteristics of the SQLite transactions

Please wait, while we are loading the content...

Indoor localization: challenges and opportunities

User interaction monitoring and analysis framework

Toward designing mobile software to predict hypoglycemia for patients with diabetes

Comparing performance parameters of mobile app development strategies

CATLES: a crowdsensing-supported interactive world-scale environment simulator for context-aware systems

Blending mobile programming and liberal education in a social-economic high school

A distributed open social platform for mobile devices

Migrating user interfaces in native mobile applications: android to iOS

Web-based hybrid mobile apps: state of the practice and research opportunities

Mobile app and app store analysis, testing and optimisation

Cognitive mobile security: invited conference keynote

Modeling free-form handwriting gesture user authentication for Android smartphones

Towards having a cloud of mobile devices specialized for software testing

A novel approach to mobile indoor navigation systems

Profiling the responsiveness of Android applications via automated resource amplification

Reproducing context-sensitive crashes of mobile apps using crowdsourced monitoring

Debugging energy-efficiency related field failures in mobile apps

AD-APT: blurring the boundary between mobile advertising and user satisfaction

On the IO characteristics of the SQLite transactions

Virtualization toolset for emulating mobile devices and networks

A pro-active and dynamic prediction assistance using BaranC framework

Mobile user identification through authentication using keystroke dynamics and accelerometer biometrics

Helping mobile software code reviewers: a study of bug repair and refactoring patterns

An empirical study of the performance impacts of Android code smells

MASON: an open development contextual sensing framework enabling reactive applications

Automated re-factoring of Android apps to enhance energy-efficiency

Coordinating proactive social devices in a mobile cloud: lessons learned and a way forward

Understanding code smells in Android applications

Identifying Android inter app communication vulnerabilities using static and dynamic analysis

XD (exchange-deliver): #a middleware for developing device-to-device mobile applications

Estimate method calls in Android apps

Integrating mobile and cloud for PPG signal selection to monitor heart rate during intensive physical exercise

Accelerating a computer vision algorithm on a mobile SoC using CPU-GPU co-processing: a case study on face detection

A generic architecture supporting context-aware data and transaction management for mobile applications

Generative patterns for designing multiple user interfaces

Towards cooperative content downloading for resource-constrained mobile devices

Extending app installable memory in Android smartphones

Pinpointing mobile malware using code analysis

Discovery and selection mechanism of cloudlets in a decentralized MCC environment

Scenario-based programming for mobile applications

Evaluating BSS algorithms in a mobile context realized by a client-server architecture

Improving design validation of mobile application user interface implementation

Inter-app communication between Android apps developed in app-inventor and Android studio

Model under design and over design on mobile applications

BehaviorDroid: monitoring Android applications

idb: a tool for blackbox iOS security assessments

Middleware for writing distributed applications on physical computing devices

Faux disk encryption: realities of secure storage on mobile devices

Preserving energy resources using an Android kernel extension: a case study

VALERA: an effective and efficient record-and-replay tool for android

Mobile exergaming: exergames on the go

Cloud-native, event-based programming for mobile applications

Regression test selection for Android applications

App security with JSFlow

Eavesdropping and obfuscation techniques for smartphones

DroidMate: a robust and extensible test generator for Android

Cross-platform access-rights analysis of mobile applications

A framework for automatic anomaly detection in mobile applications

PVDetector: a detector of privacy-policy violations for Android apps

Mining usage data from large-scale Android users: challenges and opportunities

On the IO characteristics of the SQLite transactions

Content Provider	ACM Digital Library
Author	Cheon, Seungyong Tuan, Dam Quang Won, Youjip
Abstract	This work is dedicated to study the IO characteristics of SQLite transaction in Android platform. We collect the block level IO trace from for six months. We develop an elaborate pattern matching algorithm. It allows us to identify the individual SQLite transactions from the raw IO trace, which is essentially an interleaved mixture of IO requests from concurrently running smartphone applications. Among the various observations obtained from the study, we can summarize the key findings as follows. We carefully believe that these deserve special attention. First, SQLite transaction is under extreme inefficiency. In an SQLite transaction, the IO's for SQLite journaling and EXT4 filesystem journaling account for over 75% of the entire IO volume in a transaction. Second, the suspend and the wakeup feature of the smartphone can leave the SQLite transaction to an extreme delay, a few minutes. Third, in fair number of occasions, the SQLite transactions are being used in inconsiderate manner. We find that a single SQLite transaction inserts 17.5 MByte of data to the database. It turns out to be the operation of initializing the map database. We hope that the findings obtained in this study are bifurcated to various efforts to makes the SQLite related IO more efficient and effective.
Starting Page	214
Ending Page	224
Page Count	11
File Format	PDF
ISBN	9781450341783
DOI	10.1145/2897073.2897093
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2016-05-14
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Measurement Io stack Sqlite Ext4 Real-time io characteristics Android
Content Type	Text
Resource Type	Article

Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302

See location in the Map
03222 282435
Mail: support@ndl.gov.in

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in