Create a database

已完成 已发布的 Mar 10, 2008 货到付款
已完成 货到付款

Introduction Our primary interest is improving the searchability of the 721 pdf documents saved on our site. On a different site that archives the same documents, [url removed, login to view]~ota, users can only search pdf versions of the reports alphabetically by title, alphabetically by predetermined keyword, and by year of publication. We want to expand this capability so that users can search using these tools, but also can search the text of the reports, report number, etc. We are definitely interested in hearing about the type of system you suggest and the price of such a system. Below please find a request for the next phase of our project. Let us know what suggestions you have on how to improve our project. Sincerely, otaarchive Request We are looking for someone to create and populate a database using php and mysql protocols. The database will provide index information for a series of 721 reports (saved in .PDF format). Once the database is built, a second request will be posted to build a search engine function to search the database, retrieve report matches, and display the matching pdf files. The data will be built on the following website [url removed, login to view]

## Deliverables

We are looking for someone to create and populate a database using php and mysql protocols. The database will provide index information for a series of 721 reports (saved in .PDF format). Once the database is built, a second request will be posted to build a search engine function to search the database, retrieve report matches, and display the matching pdf files. The data will be built on the following website [url removed, login to view] The tables should be MyISAM and use MySQL’s native Full-Text search functions for the Title, Summary and Table of Contents. The developer should include pagination-ready sample search queries that include the matching text from the query if the Title, Summary or Table of Contents is searched. For full-text searches that do not return any results, a second search using query expansion should be automatically and transparently performed.

To summarize, the coder will:

1) design the database

2) create a php form for adding data to the database

3) add all the requested data to the database

To populate the mysql database-

A) Identify all the files named [url removed, login to view] through [url removed, login to view]

B) For each PDF file, add the following information to the database.

1) Report title (in italics at top of the first page),

2) OTA catalog number (on the first page, only used between 1990 and 1995),

3) GPO stock # (on the first page, only used between 1992-1995),

4) NTIS order # (on the first page, used between 1974-1994), 5) Year of release (first two digits of the file name- for instance [url removed, login to view] refers to a report published in 1974; [url removed, login to view] refers to 1975; etc)

6) PDF file name

7) Summary

8) Table of contents

C) For each report [url removed, login to view], [url removed, login to view], etc, the summary and table of contents information to be added to the database can be found in the following links:

1) Document summary at [url removed, login to view]

2) Table of contents at [url removed, login to view]

## Platform

any

工程 MySQL PHP 软件构架 软件测试

项目ID: #3787502

关于项目

4个方案 远程项目 活跃的Mar 13, 2008

授予:

hits

See private message.

$85 USD 在14天内
(898条评论)
8.9

有4名威客正在参与此工作的竞标,均价$213/小时

spx2vw

See private message.

$255 USD 在14天内
(38条评论)
4.7
expappdeveloper

See private message.

$85 USD 在14天内
(0条评论)
0.0
simdolvw

See private message.

$425 USD 在14天内
(0条评论)
0.0