Best design for a memory resident tool

Posted by Andrew S. on Programmers See other posts from Programmers or by Andrew S.
Published on 2011-07-20T02:17:53Z Indexed on 2011/11/11 18:25 UTC
Read the original article Hit count: 267

Filed under:
|
|

I apologize if this tends more toward design that programming, but here goes.

What design would you recommend for a database that is

  1. Memory resident
  2. Must run on windows, linux and (at a stretch) the mac
  3. Accept multiple queries simultaneously
  4. Have minimum overhead, since a search is expected to take <0.25s

This program implements a domain-specific search. Think of it as a database, but one that takes advantage of domain specific information to outperform a convential database search (for example, with custom oracle indexing). We have a custom data structure for our data. Our protoype is a simple exe that constructs the database in memory each time it is run. We were thinking that perhaps this program would suffice, but augmented with sockets so it can listen for queries.

This database will be static. Its contents will change infrequently.

We expect queries, and the solution, to be delivered via a web service.

© Programmers or respective owner

Related posts about database

Related posts about query