Does PDA requires DB2E or can work with File System

[Former Member]

Hello Everyone,

Is it necessary that MI Client on PDA requires DB2E to be used for persistance purpose or it can work with File System also?

[Former Member · Accepted solution]

Hi Abhijit,

It is not compulsory to use D2Be for PDAs, even File I/O is fine. On the contrary it is sometimes better to use File I/O b'coz D2Be itself will consume some installation and runtime memory which will eat into the already limited memory on your PDA.

Following are the additional factores you should consider before reaching to any conclusion:

Pros for DB usage

1. MI’s File I/O is not fail-safe. If physical disk write action is interrupted, the data store is corrupted and requires device re-installation

2. Query performance is a lot better for larger data volumes

3. Query API easier to use

4. Error analysis easier due to existence of admin tools for DB

Cons against DB-independence

1. DB2E costs ~ $ 30 USD extra per mobile user

2. DB installation and configuration is more complex than using File I/O.

Regards,

Rahul

If this helps, kindly assign me some points.

[Former Member]

Hello Rahul,

Thank you very much.

You solved my problem.

[Former Member]

hello abhijit,

just an additional info.

though it might not be necessary to use DB2E, some of

the existing MI applications or other hybrid applications

might have dependencies to the underlying persistence

layer.

e.g. in case of an hybrid application where you can

have your own imlementation of the persistence APIs for

a very specific DB. so don't be surprised when you find

some MI applications that require you a specific DB

layer.

regards

jo

[Former Member]

hi Abhijit,

Check this link below.

http://help.sap.com/saphelp_nw04s/helpdata/en/43/122f4ef2dc2be8e10000000a1553f7/frameset.htm

In this you will find a statement on database/storage system pertaining to your OS.

+The following databases are possible:

¡ For setup packages for Win32 systems:

MaxDB (> 7.5.26) or file-based backup

¡ For setup packages for Windows Mobile System:

DB2E or file-based backup

.+

From this we can say file-based backup is possible. i'm not sure about the advantages/constraints of this type.

Your PDA can run on Win32 & Windows Mobile systems besides PalmOS/Linux(Mobile)/Symbian.

Regards,

ak