Here I will describe how to maintain and creating project through PDA at field label Data Collection.
PDA and Software Selection
PDA and Software Selection
PDA (Personal Digital Assistant) is handheld device. It's simply use as a mini PC which only covered into your thumb.
First need to select PDA & SD card which will be applicable for your software and database. SD card is applicable only for data transfer which incorporated with your software. Here I supposed to select PDA like HP iPaq 212 and SD card may be Transcend. After selecting PDA then you can concentrate your database design and front-end software.You can use SQL Server 2005 database(.sdf) and front end may be C# / VB.Net. .Net Framework support PDA application and windows Mobile 5.0 Pocket PC SDK need to install for running your software.
Field Selection and Prepare Questionnaire
First need to select PDA & SD card which will be applicable for your software and database. SD card is applicable only for data transfer which incorporated with your software. Here I supposed to select PDA like HP iPaq 212 and SD card may be Transcend. After selecting PDA then you can concentrate your database design and front-end software.You can use SQL Server 2005 database(.sdf) and front end may be C# / VB.Net. .Net Framework support PDA application and windows Mobile 5.0 Pocket PC SDK need to install for running your software.Field Selection and Prepare Questionnaire
It is very important role to selection your field for research. First you prepare questionnaire for related your topics or project. If you try to develop Demographic Surveillance then you have to follow Demographic rules.Here may be applicable Low Socio Economic Criteria. Due to this perspective may be scheduled Household,Socio Economic Status,Member Information and Event Information. So you have to prepare questionnaire depend upon above those criteria.
Approaching GIS (Geographical Information System)
It is newly applied for research methodology where Data management activities also involved. GIS is playing very effective role to data collection.Because if you want to maintain your project Map based where data collector can find easily their expected field through GIS approach.
Database Design and Development
After making a questionnaire think about your database and data tables. How many tables are covered your questionnaire. Database table design depend upon your data collection questionnaire. Need to concentrate fully about your tables which will be support your performance and quality. If you use SQL Server 2005 as Database I think it will compatible C# and VB.Net. One more important thing is that you have to confirmed that how many PDA's will be used this project. Because each and every PDA used same database but that should be distributed some other PDA's. You need to remember that your database should be gathered into a server database. So, you have to aware about your data field,Primary key and foreign key how you manage your database.
Software Design and Development
Next come to the software design and development. Software design would be depend upon your project output which will be support your requirements. Here need to specify that GIS information should be linked with software design. Several forms need to make which will be covered your questionnaire. You may used several Menus here like to Insert data,Updating Data,Deleting Data,Saving Data and Last of all Process Data. Process object should be there,because you have to Insert,Update and Save event should be one Temp table and process will retrieve from temp table and placed into main table. Otherwise it will be tough to Edit,Insert and Update. Because sometimes need to cancel working menu then what will be happen if you used main table. Bug will appear or database transaction may not work properly. So, need to concentrate carefully and develop a bug free software.
Data collection from field
Make ready to field worker how they will collect Data. Need to trained about software, Questionnaire field, Data inconsistent and some other applicable field. If you don't trained up or don't aware about questionnaire then performance become low. Create target to visit sample then distribute your concept how customized to reduced error free data collection. One or two days try to collect data as temporary.
Data Management Activities
Data QC ......................................................
Demerits
Each and every transaction should be copied to SD card itself. Otherwise data may be loss in any kind of PDA functional operation. Sometimes message may be displayed like I/O Exception. Then you have to replace SD card and again place it to SD card bucket through formatting. Otherwise need to format SD card then replace.Here need to inform that PDA selection is the vital role for your project where processor, memory and transfer rate should be consistent. Because if you use high volume data then PDA sometimes hanged for recall data browse. So you have to concentrate too much in your database properties, Software and PDA's. In present uses smartphone like Android applicable devices. So you have to think always to be updated one or more usable platform because which is update today, tomorrow is not.
Approaching GIS (Geographical Information System)
It is newly applied for research methodology where Data management activities also involved. GIS is playing very effective role to data collection.Because if you want to maintain your project Map based where data collector can find easily their expected field through GIS approach.
Database Design and Development
After making a questionnaire think about your database and data tables. How many tables are covered your questionnaire. Database table design depend upon your data collection questionnaire. Need to concentrate fully about your tables which will be support your performance and quality. If you use SQL Server 2005 as Database I think it will compatible C# and VB.Net. One more important thing is that you have to confirmed that how many PDA's will be used this project. Because each and every PDA used same database but that should be distributed some other PDA's. You need to remember that your database should be gathered into a server database. So, you have to aware about your data field,Primary key and foreign key how you manage your database.
Software Design and Development
Next come to the software design and development. Software design would be depend upon your project output which will be support your requirements. Here need to specify that GIS information should be linked with software design. Several forms need to make which will be covered your questionnaire. You may used several Menus here like to Insert data,Updating Data,Deleting Data,Saving Data and Last of all Process Data. Process object should be there,because you have to Insert,Update and Save event should be one Temp table and process will retrieve from temp table and placed into main table. Otherwise it will be tough to Edit,Insert and Update. Because sometimes need to cancel working menu then what will be happen if you used main table. Bug will appear or database transaction may not work properly. So, need to concentrate carefully and develop a bug free software.
Data collection from field
Make ready to field worker how they will collect Data. Need to trained about software, Questionnaire field, Data inconsistent and some other applicable field. If you don't trained up or don't aware about questionnaire then performance become low. Create target to visit sample then distribute your concept how customized to reduced error free data collection. One or two days try to collect data as temporary.
Data Management Activities
- Copy data Into Specific Folder : Collecting information through PDA you have to copy your hard drive first because you will use so many PDA's into different field site. There need to develop one module for copying database from different PDA's.
- Merge Data Into Server Database : After copying database you need to merge into the server.So due to this reason you need to develop module for merging data from stored folder.
- Check Errors,Data Consistency: Need to check range error,consistency check for your data you have to write so many queries to find out errors related to your project criteria.
- Prepare Error free Data: If you checked properly your database then you can declare that you data is error free.
- Convert several database platform: Error free data may be used in some other database format. So, you need to convert your database through SQL query where data field,data type should be declared. It is not necessary to do but your creation of demand through project. You can use ODBC connection also to convert directly from your database into different type of platform.
- Data transfer for making Report: Report always depend upon your completion of project. Here you can make report your project requirement. That may be generated into your software through Crystal Report or any other reporting software which is compatible for this environment. Other wise you may use SQL query for generating different types of report.
Data QC ......................................................
Demerits
Each and every transaction should be copied to SD card itself. Otherwise data may be loss in any kind of PDA functional operation. Sometimes message may be displayed like I/O Exception. Then you have to replace SD card and again place it to SD card bucket through formatting. Otherwise need to format SD card then replace.Here need to inform that PDA selection is the vital role for your project where processor, memory and transfer rate should be consistent. Because if you use high volume data then PDA sometimes hanged for recall data browse. So you have to concentrate too much in your database properties, Software and PDA's. In present uses smartphone like Android applicable devices. So you have to think always to be updated one or more usable platform because which is update today, tomorrow is not.
Update more......................................................
No comments:
Post a Comment