×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Large volume .trt file research help needed

Large volume .trt file research help needed

Large volume .trt file research help needed

(OP)
Hi, I am developing a text document retrieval application which needs to search for and retrieve a specific document with sub-second response from a data file. A traditional SQL-type database is not acceptable due to licensing/support issues based on number of users this will roll out to. This is for a US Customs Import Rulings database. The rulings will number in the 100s of thousands and must have that sub-second retrieval I have heard that such an engine exists and uses DATA.INX and DATA.TRT files as the data repository, however I can not find anything on this site or the web et.al. which gives info on what this application development system is.

Does anyone have any information on how to create .trt data files? Thanks

RE: Large volume .trt file research help needed

(OP)
John, I have looked at the link you sent, it is not the same, the file I am looking to create will be a text file, the link you sent was for a code base.

Thanks anyway for the response.

Licensed SQL will not work as all the users are not local and support for a formal SQL db would not be available at their locations.

RE: Large volume .trt file research help needed

Web interface?

John
 

RE: Large volume .trt file research help needed

I have to second John's idea, go on a per processor licence, and use oracle's built-in standard features for handling bulk text.

With that amount of data and the desired response time, a web interface seems ideal.  Let the users get what they need and then they leave you in peace.

Not using a RDBMS seems franlky daft.  They're designed and built for this sort of task, hence nifty things like partitioning to help deal with vast amounts of data.

Regards

T

RE: Large volume .trt file research help needed

I go with the others. Use SQL Server or Oracle or mySQL(or other large scale database) as backend with a processor liscense and a web interface for your users. If none of us know about the product you are talking about and it is isn't in common use, how hard is it going to be for you to get help when the inevitable issues of implementation arise? There are plenty of experts available for common databases and web programming languages. 100s of thousands of records is trivial for these databases (we have over 8 million records in our main table and ours would be considered a smallish to medium db) and you can't have more users than their current large users like Amazon.com or Microsoft.  

"NOTHING is more important in a database than integrity." ESquared
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close