Channels ▼
RSS

Database

McObject Releases Perst vs. SQLite Benchmark on Android


McObject has released TestIndex, a demo application showing Perst and Android's bundled SQLite database performing the same tasks side-by-side. Both are available as free downloads, with complete source code at www.mcobject.com/android. Perst is an all-Java object-oriented, open-source embedded database that has been verified as compatible with the Android mobile device platform backed by Google and the Open Handset Alliance.

Perst is a compact embedded database, with a core consisting of 5,000 lines of code that supports transactions with the ACID (Atomic, Consistent, Isolated and Durable) properties, and expands developers' coding efficiency by making Java objects as easy to use as possible. Perst stores data directly in Java objects, eliminating the need for data-packing or unpacking code to map between the application's data model and the database's data model, as is required by relational and object-relational databases.

For example, for access to objects, Perst implements specialized collection classes optimized for different data layouts and access patterns, including:

  • Classic B-Tree implementation
  • R-tree indexes for spatially-oriented applications such as GIS and navigation
  • Main-memory database containers, based on T-Tree indexes, optimized for real-time memory-only access
  • Patricia Trie index, which speeds searches in networking and telephony applications
  • TimeSeries class to efficiently deal with small fixed-size objects
  • Specialized versions of collections for thick indices (indices with many duplicates), and bit indices (keys with a restricted number of possible values).

In addition to its core functionality, Perst provides garbage collection, detection of hanging references, automatic schema evolution, XML import/export utilities, master-slave replication support (with the option to run read-only queries on slave nodes), an SQL subset to filter elements of any collection, and integration with the AspectJ and JAssist AOP tools.


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Comments:

Video