Mobile database

Mobile computing devices (e.g., smartphones and PDAs) store and share data over a mobile network, or access 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 accessing your contacts and calendar on a mobile 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.[citation needed]

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

Considerations

  • Mobile users must be able to work without a network connection due to poor or even non-existent connections. A cache could be maintained to hold recently accessed data and transactions so that they are not lost due to connection failure. Users might not require access to truly live data, only recently modified data, and uploading of changes might be deferred until reconnected.
  • Bandwidth must be conserved (a common requirement on wireless networks that charge per megabyte or data transferred).
  • Mobile computing devices tend to have slower CPUs and limited battery life.
  • Users with multiple devices (e.g. smartphone and tablet) need to synchronize their devices to a centralized data store. This may require application-specific automation features.[2]

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.

  • Users may change location geographically and on the network. Usually dealing with this is left to the operating system, which is responsible for maintaining the wireless network connection.

Products

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

Name Developer Type Sync Central Sync P2P Description License
Couchbase Lite Couchbase JSON Document Yes Yes Embedded/portable database, can synchronize with multiple stationary database and/or mobile devices. Apache 2.0 License
GUN (Graph Universe Node) ERA Inc Graph database Yes Yes Enables offline-first, real-time, and decentralized data synchronization between web browsers and JavaScript runtimes. MIT License, Apache 2.0, zlib License
InterBase Embarcadero Technologies Relational Dependent Dependent IoT embedded/portable database, can synchronize with multiple stationary database and/or mobile devices Proprietary
SQL Anywhere Sybase iAnywhere Relational Dependent No Embedded/portable database, can synchronize with stationary database Proprietary
DB2 Everyplace IBM Relational Dependent No Portable, can synchronize with stationary database Proprietary EULA
SQL Server Compact Microsoft Relational No No Small-footprint embedded/portable database for Microsoft Windows mobile devices and desktops, supports synchronization with Microsoft SQL Server Proprietary
SQL Server Express Microsoft Relational No No Embedded database, free download Proprietary
Oracle Database Lite Oracle Corporation Relational No No Portable, can synchronize with stationary database Proprietary
SQLite D. Richard Hipp Relational No No C programming library Public domain
SQLBase Gupta Technologies LLC of Redwood Shores, California No No Proprietary
Sparksee Sparsity Technologies Graph Database No No Graph database written in C++. Proprietary

See also

References

  1. ^ Organize your business with a mobile database, Kevin Ebi, Microsoft.com, retrieved 14/12/08 [1]
  2. ^ The 5 Traits of Great Cloud-Syncing Apps

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.