Mobile Database Design Consideration
Design considerations and goals.
Some aspects need to be considered to achieve the design objectives of the Mobile Database System or MDS. Performance should stabilize due to the use of mobility. The design of the MDS should be a discrete interface. The MDS is reliable to meet the high expectations of mobile users. Lastly, the scalability of the MDS, this includes, everyone will sync at the same time. Merge replication, allow database engines to synchronize the local database residing on the mobile device with a central database running on a server. Determine how the data will be imported or exported to the driving database on the server as part of the database strategy. Plan the synchronization strategy as part of the database design phase
mobile database design
Mobile database design is based on eight steps. The particular steps will help the MDS design goal to be successful. Figure 1 below will show the flow of the eight mobile database design steps.
1. Mobile platform
Factors that can be considered when choosing a platform include ease of use, ease of development, ease of communication, ease of implementation, product price, system reliability, product maintainability, width of communication band, the technical support and the popularity of the product. It is also necessary to consider what kind of wireless communication techniques and network facilities are available for use with mobile applications. For example, which mobile operating system is best for proper implementation of MDS? Currently available mobile and laptop operating systems include Windows 2003/XP/Vista/7, Windows Mobile and PocketPC, Symbian OS 7.x/8.x/9.x, Linux and Embedded Linux.
2. Mobile database
Once the platform is chosen, it will be necessary to select a suitable mobile database management system. At this point, if it is determined that the mobile databases supported on the mobile platform selected above do not meet the requirements, then it may be necessary to select another mobile database or switch to another mobile platform. For example IBM DB2 Everyplace and Oracle9i Lite. Oracle Database Lite provides a small SQL-enabled client database for local access to enterprise data through applications on the mobile device. In addition, it introduces the Mobile Server middleware component that supports scalable data synchronization and centralized management of mobile resources.
3. Central database
The core database selection parallels the mobile database selection, because the database must coexist on a single system while data is shared. For example, if SQL Server for Windows Mobile is used as the mobile database, SQL Server can be used as the central database to ensure interoperability since both database management systems are from the same vendor.
4. Transaction model
An appropriate transaction model should be chosen based on model characteristics and user preferences. The names between the transaction models are available in the Kangaroo, PRO-MOTION, Moflex, Cluster and Multi-Database mobile environment.
5.Optimization Techniques
The compression technique provides the ability to move large amounts of data between the mobile device and the central database server. The compression technique will make the best use of the available bandwidth, the data transferred between the mobile devices and the central database. This will not only improve performance, but also make the bandwidth available to other users. Mobile devices have limited storage problems, the most frequently used data must be stored to make the most of the available space.
6. Database entities
Identifying the database entities and data is crucial. Once infrastructure decisions have been made, data storage decisions must be made.
7. Entity attributes
While identifying the entities in the database, it will be necessary to consider the attributes contained in each of those entities. For each of those attributes, it is also necessary to determine the data type and data size.
8. Entity relationship diagram
When the detailed database entities and their attributes are finalized, an entity relationship diagram should be developed. This diagram will provide the relationships between the different entities.
The database design process is the most critical part. This step involves making a number of important decisions and the steps mentioned above play a vital role in the successful development of MDS.