Mobile database explained

Mobile computing devices (e.g., smartphones and PDAs) store and share data over a mobile network, or a database which is actually stored by the mobile device. This could be a list of contacts, price information, distance travelled, or any other information.[1]

Many applications require the ability to download information from an information repository and operate on this information even when out of range or disconnected. An example of this is your contacts and calendar on the phone. In this scenario, a user would require access to update information from files in the home directories on a server or customer records from a database. This type of access and work load generated by such users is different from the traditional workloads seen in client–server systems of today.

Mobile databases are not used solely for the revision of company contacts and calendars, but used in a number of industries.

Considerations

This is in database theory known as "replication", and good mobile database system should provide tools for automatic replication that takes into account that others may have modified the same data as you while you were away, and not just the last update is kept, but also supports "merge" of variants.

Products

Commercially available mobile databases include those shown on this comparison chart.

NameDeveloperTypeSync CentralSync P2PDescriptionLicense
Couchbase LiteCouchbaseJSON DocumentYesYesEmbedded/portable database, can synchronize with multiple stationary database and/or mobile devices.Apache 2.0 License
InterBaseEmbarcadero TechnologiesRelationalDependentDependentIoT embedded/portable database, can synchronize with multiple stationary database and/or mobile devicesProprietary
ObjectBoxObjectBox Inc.Object DatabaseDependent?Edge database for local data persistenceApache 2.0 / MIT
RealmMongoDB Inc.Object DatabaseDependentNoPortable local database, has a synchronized mode that synchronizes (real-time) with stationary databaseCore Apache 2.0 License, Sync Proprietary
SQL AnywhereSybase iAnywhereRelationalDependentNoEmbedded/portable database, can synchronize with stationary databaseProprietary
DB2 EveryplaceIBMRelationalDependentNoPortable, can synchronize with stationary databaseProprietary EULA
SQL Server CompactMicrosoftRelationalNoNoSmall-footprint embedded/portable database for Microsoft Windows mobile devices and desktops, supports synchronization with Microsoft SQL ServerProprietary
SQL Server ExpressMicrosoftRelationalNoNoEmbedded database, free downloadProprietary
Oracle Database LiteOracle CorporationRelationalNoNoPortable, can synchronize with stationary databaseProprietary
SQLiteD. Richard HippRelationalNoNoC programming libraryPublic domain
SQLBaseGupta Technologies LLC of Redwood Shores, CaliforniaNoNoProprietary
SparkseeSparsity TechnologiesGraph DatabaseNoNoGraph database written in C++.Proprietary

See also

External links

Notes and References

  1. Organize your business with a mobile database, Kevin Ebi, Microsoft.com, retrieved 14/12/08 http://www.microsoft.com/windowsmobile/en-us/business/solutions/small-business-database.mspx
  2. http://smallmobile.infogenium.com/2012/11/06/the-5-traits-of-great-cloud-syncing-apps/ The 5 Traits of Great Cloud-Syncing Apps