Mobile database: Difference between revisions

Content deleted Content added

Inline

Latest revision as of 19:15, 8 June 2024

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.^{[citation needed]}

Mobile databases are not used solely for the revision of company contacts and calendars, but used 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 changing 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
InterBase	Embarcadero Technologies	Relational	Dependent	Dependent	IoT embedded/portable database, can synchronize with multiple stationary database and/or mobile devices	Proprietary
ObjectBox	ObjectBox Inc.	Object Database	Dependent	?	Edge database for local data persistence	Apache 2.0 / MIT
Realm	MongoDB Inc.	Object Database	Dependent	No	Portable local database, has a synchronized mode that synchronizes (real-time) with stationary database	Core Apache 2.0 License, Sync 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

References

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

External links

Mobile Database Review: Microsoft Databases for Windows CE, By Bryan Morgan, Apr 5, 2002, InformIT
Mobile Database Review: Sybase SQL Anywhere Studio 8.0, By Bryan Morgan, Feb 15, 2002, InformIT

[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

[1]

[2]

@@ Line 1: / Line 1: @@
-A '''mobile database''' is either a stationary [[database]] that can be connected to by a [[mobile computing]] device (e.g., [[Smartphone|smartphones]] and [[Personal digital assistant|PDAs]]) 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.<ref>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]</ref>
+[[Mobile computing]] devices (e.g., [[smartphone]]s and [[Personal digital assistant|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.<ref>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]</ref>
 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 directory|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 model|client–server]] systems of today.{{citation needed|date=March 2013}}
@@ Line 12: / Line 12: @@
 * 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.<ref>[http://smallmobile.infogenium.com/2012/11/06/the-5-traits-of-great-cloud-syncing-apps/ The 5 Traits of Great Cloud-Syncing Apps]</ref>
 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.
+* 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 ==
@@ Line 23: / Line 23: @@
 !Developer
 !Type
+!Sync Central
+!Sync P2P
 !Description
+!License
+|-
+|[[Couchbase Lite]]
+|[[Couchbase]]
+|[[NoSQL|JSON Document]]
+|Yes
+|Yes
+|Embedded/portable database, can synchronize with multiple stationary database and/or mobile devices.
+|Apache 2.0 License
+|-
+|[[InterBase]]
+|[[Embarcadero Technologies]]
+|[[Relational database|Relational]]
+|Dependent
+|Dependent
+|IoT embedded/portable database, can synchronize with multiple stationary database and/or mobile devices
+|Proprietary
+|-
+|[[ObjectBox (database)|ObjectBox]]
+|ObjectBox Inc.
+|Object Database
+|Dependent
+|?
+|Edge database for local data persistence
+|Apache 2.0 / MIT
+|-
+|[[Realm (database)|Realm]]
+|[[MongoDB Inc.]]
+|Object Database
+|Dependent
+|No
+|Portable local database, has a synchronized mode that synchronizes (real-time) with stationary database
+|Core Apache 2.0 License, Sync Proprietary
 |-
 |[[SQL Anywhere]]
 |[[Sybase iAnywhere]]
 |[[Relational database|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 (graph database)|Sparksee]]
-|[http://www.sparsity-technologies.com#sparksee Sparksee 5 mobile]
-|[http://www.sparsity-technologies.com Sparsity Technologies]
+|Sparsity Technologies
-|[[Graph database]]
+|[[Graph Database]]
+|No
-|Small-footprint embedded/portable database for Android, iOS and BB10. It allows traversals of nodes, minimum distance computations, community search, etc.
-|-
+|No
+|Graph database written in C++.
-|[http://www.couchbase.com/mobile Couchbase Lite]
+|Proprietary
-|[[Couchbase,_Inc.]]
-|[[Document-oriented_database]]
-|A lightweight full-featured embedded JSON document store. Supports iOS, Android, and REST SDKs. Is sync-ready using Couchbase Sync Gateway with Sync and conflict resolution built in.
-|-
-|[http://www.iboxdb.com/ iBoxDB]
-|[http://www.iboxdb.com/ iBoxDB]
-|[[Document-oriented_database]]
-|Embeddable transactional table style document database for Android Windows Phone. Supports Mono Xamarin and Unity3D mobile development platforms.
-|-
-|[http://realm.io/ Realm]
-|[http://realm.io Realm Inc]
-|[[Object Database]]
-|A lightweight full-featured embedded object store. Supports iOS and Android.
 |}
@@ Line 90: / Line 134: @@
 == External links ==
-* http://www.informit.com/articles/article.aspx?p=26223&seqNum=3
+* [http://www.informit.com/articles/article.aspx?p=26223&seqNum=3 Mobile Database Review: Microsoft Databases for Windows CE], By Bryan Morgan, Apr 5, 2002, InformIT
-* http://www.informit.com/articles/article.aspx?p=25328
+* [http://www.informit.com/articles/article.aspx?p=25328 Mobile Database Review: Sybase SQL Anywhere Studio 8.0], By Bryan Morgan, Feb 15, 2002, InformIT
 [[Category:Types of databases]]

Latest revision as of 19:15, 8 June 2024

Considerations

Products

See also

References

External links