 |
|
 |
5000 newspaper articles |
Post Reply 
|
| Author |
 Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search  Topic Options
|
jellejacob 
Newbie 
Joined: 19 June 2002 Location: Netherlands Status: Offline Posts: 10 Points: 10 |
 Post Options
 Quote Reply
 Topic: 5000 newspaper articlesPosted: 11 July 2003 at 2:53am |
|
Hi all, I hope this is the right forum to post.
I dont know where to start so I'll start from the beginning. My client asked me to convert 5000 printed newspaper articles to usable text with OCR (Optical Character Recognition) for use on there intranet which runs on an windows server. The also would like an option to search by keyword through the content of the whole range of articles. I know how to convert these articles to usable text. But my question is, what is the most usable/fastest way of getting this articles in a database and which database MS Acces or SQL server? I've also have an option to export directly from my OCR program to HTML or XML. I hope someone can give me some advice. |
|
 |
|
|
the boss
Senior Member 
Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Posts: 1733 Points: 1735 |
Post Options
Quote Reply
Posted: 11 July 2003 at 5:31pm |
|
export them to HTMl.. then use the Web wiz search application.. the application has a capability to search in the text of a file for given keywords.. |
|
|
|
|
|
|
Gullanian
Senior Member
Joined: 04 January 2002 Location: England Status: Offline Posts: 4292 Points: 4292 |
Post Options
Quote Reply
Posted: 11 July 2003 at 7:33pm |
|
Ah yes, but it uses the description meta tag to get the keywords, for each of the 5000 articles you would need to put some HTML keywords in..... that could obviously take a while!
|
|
|
Tom
|
|
|
|
|
the boss
Senior Member
Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Posts: 1733 Points: 1735 |
Post Options
Quote Reply
Posted: 11 July 2003 at 7:40pm |
|
export them to XML then..use XSL for formatting.. and for searching too in combination with ASp i guess
|
|
|
|
|
|
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Posts: 23183 Points: 6383 |
Post Options
Quote Reply
Posted: 12 July 2003 at 1:24am |
|
I would put all the ariticles in an SQL Server database, databases are made for searching so that should be simple enough
|
|
|
|
|
jellejacob
Newbie
Joined: 19 June 2002 Location: Netherlands Status: Offline Posts: 10 Points: 10 |
Post Options
Quote Reply
Posted: 12 July 2003 at 4:01am |
|
Thanks people for your replies. I think I'll go for the SQL-server database option. XML is at this piont one bridge to far for me. Thanks again! |
|
|
|
|
Bunce
Senior Member
Joined: 10 April 2002 Location: Australia Status: Offline Posts: 847 Points: 847 |
Post Options
Quote Reply
Posted: 12 July 2003 at 7:29pm |
|
When you say search by keyword, what do you mean? Remember that if this was a subset of words from an article then you'd need to specify exactly what these keywords are... If however you just mean to search every word in an article then its a lot easier. Might pay to look into the 'Full-Text-Index' feature of SQL Server: Cheers, |
|
|
There have been many, many posts made throughout the world...
This was one of them. |
|
|
|
|
Post Reply
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
All prices are shown excluding VAT, which is charged where applicable. $, € prices shown as a guideline only.