İptal Edildi

Optimizing DBF database file

DBF files are flat, simple database files that use defined record sizes, and field sizes. We need a utility program to optimize the size of the database by scanning though each field of the dbf and re-outputting the data in the smallest sized field possible to conserve space.

The utility should be able to handle strings, float, double, integer, and long values. floating, strings and integers have different optimizations. For strings you want to look for the longest string and then output a field size of the longest string. for integers you want to look for largest integer, and smallest if negatives are used. if for example, 100 is the max number and 0 is the minimum, you do not want to store it in a field size of 8 bytes, 1 byte would be sufficient!

also, if a double or a float is used and no decimal numbers are used at all in the data, then it should be converted into an integer of smallest size needed.

you would need to keep the following info on each field:

max number (ie 540), min number (ie -600), number with largest decimal (ie. 0.1234), or if it is a string max trimmed length of string.

then output the same dbf file only with adjusted field sizes to use least needed space.

if the max value for a particular field is 94.36 then you'd use field length 2 with decimal precision of 2...you get the picture...

and one more thing... watch out for minuses and nulls...

i have sample dbf files that can be used to test the optimization.

you should also output stats for each field in a text file of same name as the dbf file with txt extension, or something similar.

there is also a document describing dbf file format in detail...

i have it and it's also on the internet.

one more thing... we use dbf files with more than 1024 fields so don't rely on that limit as max!

we will need source code to this utility.

Beceriler: .NET, C Programlama, Java

Daha fazlasını gör: string source code java, simple file database, largest number, integers and, get length of string in c, though, strings, scanning, out source a database, look max, java optimization, java file, java database, floating, float, file, document scanning, document database, dbf, database optimization

İşveren Hakkında:
( 1 değerlendirme ) rego park, United States

Proje NO: #68002

Bu iş için 12 freelancer ortalamada $453 teklif veriyor


Dear Sir/Madam, I have all required knowledge and experience to achieve success of this project with best quality and professionalism. Please see my profile. Before accepting my bid offer please contact me via proj Daha Fazla

in %bids___i_period_sub_35% gün içinde590%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(36 Değerlendirme)

Bid placed on RAC :)

in %bids___i_period_sub_35% gün içinde550%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)

Hello Please see PMB for details of my bid. Thank you

in %bids___i_period_sub_35% gün içinde550%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)

Dear Respected sir/Madam, I have 8+ years of experieence in Software industry. I have worked on DBase, Fox, Access, SQL, Oracle, C, C++, VB .net, VC++, Java etc. I have worked hugly with DBF, converting from D Daha Fazla

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)

Sir I have the 8 years of experience in developement and design field. More about our information visit our profile. Im master in VFP and .net. We will give the quality works and supports. Waiting for your replay. Daha Fazla

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

Plz check your PM.

in %bids___i_period_sub_35% gün içinde700%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

I think i can help, please check pm.

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

i can do it!

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I just registered on this website. I am quite a DBF specialist, I wrote a DBF component for Delphi in 2000 ([login to view URL]). Should I assume that your DBF are DBF complient and readable using the OLEDB drivers? Daha Fazla

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Oh, man, that's simple. Indeed there's a nice logic behind the scenes, but it is simple. Specially for a CA/Clipper programmer like me (my everyday job since 2001). I have it all in mind. Best regards.

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi! I have a lot of experience in C/C++, DBF rebuilding and can do it in the time. I have done similar applications several times. Regards.

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am experienced in dbf optimization from old dos systems to porting them into windows based systems. you wont get disappointed

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)