Access data anywhere with Everyplace
Mobile version of IBM’s DB2 database is a smooth operator
The MAB emits both native and Java applications. The Java apps are J2SE-compliant and will run on Windows CE, PocketPC, Symbian, and Windows. In my testing on the Palm, the DB2 Everyplace applications were typically native.
DB2 Everplace’s synchronization server is actually a servlet that runs in a compatible servlet container, which can be anything from Tomcat to the WebSphere application server. The server communicates with a synchronization client on the mobile device, either a provided stand-alone app or one that is integrated into a mobile database application.
In the current version of DB2 Everyplace, the synchronization server and client communicate via HTTP exchanges, ensuring coverage of a wide array of mobile clients with little or no device customization. However, the choice is mildly inconvenient on the Palm because it means that synchronization is not performed via HotSync and therefore requires two steps to synchronize data. IBM promises that an upcoming DB2 Everyplace release will support HotSync.
DB2 Everyplace gets high points for ease of installation: I had a handheld database ready and synchronized not more than an hour or so after I’d installed the product. All the tools and their controls were arranged so that it was easy to figure out what to do and in what order.
At first, I thought the MDAC’s interface was too sparse, but as I worked with it, I realized that it had no more and no less than exactly what was needed to work with the database apps. The same is true of the query tool that runs on the Palm; the SQL subset it supports was limited, but it provides just the tools you need to create, drop, and query tables.
Finally, there’s enough language support to keep just about anyone happy. DB2 Everyplace’s array of tools and libraries will suit a C/C++, Java, Visual Basic, or .Net developer comfortably.
DB2 Everyplace is easy to install and administer. Its use of membership abstractions (user, group, and subscription) easily accommodates just about every data-distribution contingency one can think of. Plus, it puts the venerable DB2 name at both ends of the synchronization cable -- and that counts for a lot.
Read more about data management in InfoWorld's Data Management Channel.