CI-P: Planning for a Community Infrastructure to Enable Pocket-Scale Data Management Research

全球20亿部智能手机和400万个应用程序已经成为大多数人通信和计算体验的重要组成部分。大多数应用程序都需要存储结构化数据，如联系人、地址簿条目，甚至是你在《糖果粉碎传奇》中的最高分数。大多数智能手机都有一个名为嵌入式数据库的软件，可以帮助应用程序保存和访问这些信息。例如，Android手机和iphone都包含一个流行的嵌入式数据库SQLite。SQLite被大量使用——项目团队测量了在实际使用中，平均一台Android手机每天有近18万个SQLite请求。该团队还发现，许多此类请求使用SQLite效率低下，导致电池寿命缩短，性能降低，并可能浪费计划数据。为了做得更好，需要研究来了解问题是什么。作为该项目的一部分，该团队正在收集真实世界的数据并构建基础设施，研究人员将需要这些基础设施来构建更好的嵌入式数据库，从而实现更长的电池寿命、更灵敏的手机和更持久的计划数据。这是一个总体项目的规划阶段，旨在使研究人员更容易探索“袖珍规模”数据的挑战。虽然服务器级数据库系统经常被测试和调优，以进行持续的高吞吐量查询处理，但嵌入式数据库经历了由交互式使用产生的小容量但突发的工作负载。这些工作负载更加动态，使得它们更难以重现，这反过来又使在现实环境中评估新技术和系统变得困难。这个社区基础设施（CI）项目的最终目标是建立一个由研究人员和行业合作伙伴组成的自我维持的社区，这些研究人员和行业合作伙伴可以创建和共享工作负载跟踪、基准测试、仪器和可视化工具，从而更容易评估嵌入式数据库技术中的创新。在CI规划阶段，项目团队通过接触来自多个领域（包括数据库、移动系统、编程语言和物联网）的潜在合作伙伴来构建社区。作为这个社区的中心，该团队正在开发一个工具链，用于对嵌入式数据库进行基准测试，以及在布法罗大学托管的社区网站（http://pocketdata.info）。该项目还涉及外联工作，包括教程、讲习班和系列研讨会。随着社区的兴趣和支持，嵌入式数据库基准CI有望引发对袖珍规模数据管理的新一波研究兴趣。

The world's 2 billion smartphones and 4 million apps have become a large part of most people's communication and computing experiences. Most apps need to store structured data like contacts, address book entries, or even your top scores in Candy Crush. Most smartphones include a piece of software called an embedded database that helps apps save and access this information. For example, both Android phones and iPhones include a popular embedded database called SQLite. SQLite is used a lot -- the project team measured nearly 180 thousand SQLite requests per day on an average Android phone in real-world use. The team also found that lots of these requests use SQLite inefficiently, resulting in shorter battery life, slower performance, and potentially wasted plan data. To do better, research is need to understand what is the problems are. As part of this project, the team is gathering the real-world data and building the infrastructure that researchers will need to make better embedded databases, leading to longer battery life, more responsive phones, and longer-lasting plan data.This is the planning stage of an overarching project that aims to make it easier for researchers to explore the challenges of "Pocket-Scale" data. While server-class database systems are frequently tested and tuned for continuous high-throughput query processing, embedded databases experience lower-volume but bursty workloads produced by interactive use. These workloads are far more dynamic, making them much harder to reproduce, which in turn make it hard to evaluate new techniques and systems in realistic settings. The ultimate goal for this community infrastructure (CI) project is to establish a self-sustaining community of researchers and industrial partners who create and share workload traces, benchmarks, instrumentation, and visualization tools, making it easier to evaluate innovations in embedded database technology. In this CI planning stage, the project team is building up the community by reaching out to potential partners from multiple areas including databases, mobile systems, programming languages, and internet-of-things. As a hub for this community, the team is developing a toolchain for benchmarking embedded database, as well as a community website hosted at the University at Buffalo (http://pocketdata.info). The project also involves outreach efforts including tutorials, workshops, and seminar series. With the interest and support from the community, the embedded database benchmark CI is expected to spark a new wave of research interest on pocket-scale data management.