Welcome!

Java IoT Authors: Yeshim Deniz, Liz McMillan, Zakia Bouachraoui, Pat Romanski, Elizabeth White

Related Topics: Java IoT, Mobile IoT

Java IoT: Article

Off-the-shelf Mobile Phone Hosts Java Embedded Database Benchmark

SQLite and McObject's Perst square off on Android smartphone

In what is likely the first-ever database benchmark conducted on an off-the-shelf mobile phone, McObject® has successfully deployed its TestIndex application on T-Mobile’s Android-based G1smartphone, to measure performance of the SQLite embedded database alongside McObject’s open source Perst™ embedded database on typical data management functions.

The comparison showed that gaps in database performance can be measured as easily in this pocket-sized test bed as in more traditional benchmark environments with rack-mounted hardware. On three of the four TestIndex metrics, Perst performed database tasks significantly faster—more than 16 times faster, in the case of database inserts.

McObject has gathered benchmark results and analysis into a report, available for free download from McObject’s Web site. McObject also offers the TestIndex application, with complete source code, to run in the Android emulator as well as on the T-Mobile G1 and any future phones based on Google’s Android platform.

Mobile Devices’ Database Challenge
To support sophisticated features, applications running on mobile devices manage increasing volumes of complex data. Examples include location-based services (LBS) that rely on GIS data, MP3 players that index songs and playlists, and field sales and service applications that store enterprise data.

Incorporating an off-the-shelf embedded database for these tasks reduces coding and QA, and improves reliability and performance. Given mobile phones’ typically limited processing resources, though, the chosen database must be highly efficient.

Two quite different embedded database systems that have emerged for use on Google’s Android are SQLite, a relational embedded database that supports the SQL application programming interface (API), and Perst, an object-oriented embedded database that works directly with Java objects.

To compare Android databases in an “applets to applets” test, McObject developed the TestIndex benchmark application, which measures performance along the following parameters:

  • Insert – loading 10,000 simple records into the database (with string and integer keys, using two B-tree indexes)
  • Search – seeking these records via the indexes (there are 10,000 searches for random values in each index, so searching is performed 20,000 times)
  • Scan – performing two traverses (sequential scans) through all records using both indexes, so that records are sorted by integer key and string key
  • Delete – locate and remove all 10,000 records

SQLite vs. Perst: Benchmark Results

For the first TestIndex benchmark test in a real Android phone, McObject obtained T-Mobile’s G1 phone, equipped with all standard features.

The TestIndex application with both embedded databases was downloaded via USB from a PC to the G1 phone, where it received its own “Benchmark” icon. Clicking this launched TestIndex, which returned the following results (in milliseconds):

Operation

SQLite

Perst

Performance Disparity

Insert

299,166

18,214

Perst is 16.43 times faster

Search

104,796

15,743

Perst is 6.65 times faster

Scan

6,457

9,747

SQLite is 1.51 times faster

Delete

203,253

37,811

Perst is 5.38 times faster

Examining the Results
According to McObject CEO Steve Graves, the performance disparity in insert and delete operations likely results, at least partially, from the lack of explicit transaction support in the SQLite Android API. Each update must be performed as a separate transaction, in autocommit mode, resulting in significant transaction processing overhead.

Perst’s edge in searching for records probably stems from latency in SQLite caused by using Android’s Java interface to access the native C language database, and SQLite’s overhead of parsing, optimizing and executing the interpreted SQL, Graves said. In contrast, Perst is all Java, and its interface works directly with database objects – no interpretation of an intermediate language is needed.

SQLite’s advantage in scan operations probably stems from the test’s simple tabular data layout, Graves said. As a relational database, SQLite organizes data in rows, and these rows are physically close to one another in storage, like rows of a spreadsheet. This proximity lends an edge in sequentially fetching the rows. In contrast, in Perst, everything is an object, including index pages, and objects are interleaved in the storage.

More details, including database definitions used in the test and an expanded performance analysis, are included in McObject’s freely downloadable benchmark report.

Perst is part of McObject’s family of powerful small footprint, high performance embedded database software products. The eXtremeDB™ in-memory embedded database from McObject is used widely in devices including MP3 players, WiMAX base stations, digital TVs, telecom/network communications equipment and military/aerospace technology. Perst is available for Java and .NET, including Java ME and .NET Compact Framework. CA’s Wily Technology credits Perst with delivering a shortened development cycle and a ten-fold performance improvement within its real-time Java application.

About McObject
Founded by embedded database and real-time systems experts, McObject offers proven data management technology that makes applications and devices smarter, more reliable and more cost-effective to develop and maintain. McObject counts among its customers industry leaders such as Chrysler, Maximizer Software, Siemens, Phillips, EADS, JVC, Tyco Thermal Controls, F5 Networks, DIRECTV, CA, Motorola and Boeing. McObject, based in Issaquah, WA, is committed to providing innovative technology and first-rate services to customers and partners. The company can be reached at +1-425-888-8505, or visit www.mcobject.com.

McObject and eXtremeDB are trademarks or registered trademarks of McObject LLC. All other company or product names mentioned herein are trademarks or registered trademarks of their respective owners.

More Stories By Ted Kenney

Ted Kenney writes for McObject, developer of proven embedded database software that makes applications and devices smarter, more reliable and more cost-effective to develop and maintain.

McObject's Products include the Perst open source, object-oriented embedded database for Java and .NET, and eXtremeDB, a in-memory and on-disk embedded database system used widely in telecommunications, industrial control, aerospace and other application categories that require real-time responsiveness.

IoT & Smart Cities Stories
After years of investments and acquisitions, CloudBlue was created with the goal of building the world's only hyperscale digital platform with an increasingly infinite ecosystem and proven go-to-market services. The result? An unmatched platform that helps customers streamline cloud operations, save time and money, and revolutionize their businesses overnight. Today, the platform operates in more than 45 countries and powers more than 200 of the world's largest cloud marketplaces, managing mo...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
The platform combines the strengths of Singtel's extensive, intelligent network capabilities with Microsoft's cloud expertise to create a unique solution that sets new standards for IoT applications," said Mr Diomedes Kastanis, Head of IoT at Singtel. "Our solution provides speed, transparency and flexibility, paving the way for a more pervasive use of IoT to accelerate enterprises' digitalisation efforts. AI-powered intelligent connectivity over Microsoft Azure will be the fastest connected pat...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
CloudEXPO has been the M&A capital for Cloud companies for more than a decade with memorable acquisition news stories which came out of CloudEXPO expo floor. DevOpsSUMMIT New York faculty member Greg Bledsoe shared his views on IBM's Red Hat acquisition live from NASDAQ floor. Acquisition news was announced during CloudEXPO New York which took place November 12-13, 2019 in New York City.
In an age of borderless networks, security for the cloud and security for the corporate network can no longer be separated. Security teams are now presented with the challenge of monitoring and controlling access to these cloud environments, at the same time that developers quickly spin up new cloud instances and executives push forwards new initiatives. The vulnerabilities created by migration to the cloud, such as misconfigurations and compromised credentials, require that security teams t...
The graph represents a network of 1,329 Twitter users whose recent tweets contained "#DevOps", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Thursday, 10 January 2019 at 23:50 UTC. The tweets in the network were tweeted over the 7-hour, 6-minute period from Thursday, 10 January 2019 at 16:29 UTC to Thursday, 10 January 2019 at 23:36 UTC. Additional tweets that were mentioned in this...
The term "digital transformation" (DX) is being used by everyone for just about any company initiative that involves technology, the web, ecommerce, software, or even customer experience. While the term has certainly turned into a buzzword with a lot of hype, the transition to a more connected, digital world is real and comes with real challenges. In his opening keynote, Four Essentials To Become DX Hero Status Now, Jonathan Hoppe, Co-Founder and CTO of Total Uptime Technologies, shared that ...
When Enterprises started adopting Hadoop-based Big Data environments over the last ten years, they were mainly on-premise deployments. Organizations would spin up and manage large Hadoop clusters, where they would funnel exabytes or petabytes of unstructured data.However, over the last few years the economics of maintaining this enormous infrastructure compared with the elastic scalability of viable cloud options has changed this equation. The growth of cloud storage, cloud-managed big data e...
Your applications have evolved, your computing needs are changing, and your servers have become more and more dense. But your data center hasn't changed so you can't get the benefits of cheaper, better, smaller, faster... until now. Colovore is Silicon Valley's premier provider of high-density colocation solutions that are a perfect fit for companies operating modern, high-performance hardware. No other Bay Area colo provider can match our density, operating efficiency, and ease of scalability.