Mobile database
Mobile computingdevices (e.g.,smartphonesandPDAs) store and share data over amobile 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 aninformation repositoryand 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 thehome directorieson 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 inclient–serversystems 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
[edit]- Mobile users must be able to work without a network connection due to poor or even non-existent connections. Acachecould 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.
- Bandwidthmust be conserved (a common requirement onwireless networksthat charge permegabyteor 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 thewireless networkconnection.
Products
[edit]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 forMicrosoft Windowsmobile devices and desktops, supports synchronization withMicrosoft SQL Server | Proprietary |
SQL Server Express | Microsoft | Relational | No | No | Embedded database, free download | Proprietary |
Oracle DatabaseLite | 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 TechnologiesLLC of Redwood Shores, California | No | No | Proprietary | ||
Sparksee | Sparsity Technologies | Graph Database | No | No | Graph database written in C++. | Proprietary |
See also
[edit]References
[edit]- ^Organize your business with a mobile database, Kevin Ebi, Microsoft, retrieved 14/12/08[1]
- ^The 5 Traits of Great Cloud-Syncing Apps
External links
[edit]- 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