DB architecture — Which database is best for single key search

  • Blue Mancunian

    SSC Eights!

    Points: 809

    I have a very simple database, which consists of two tables:

    TabA , idA binary(32) Primarykey NOT NULL

    TabB,  idB binary(32) Primarykey NOT NULL

    Only two simple activities are performing on these tables and they are independent.

    Inserting new id to idA in TabA.

    Searching TabB idB column for a given value, if not exists insert the given value.

    The two tables could grow into billions of records. The data can’t be housekept. Currently the database is in a relational database MS SQL.

    Based on the very simple query and flat schema, which type of databases could provide best performance? Search engine? In memory KV? Mapreduce? Thanks in advance!

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

    this sounds very much like a scenario for A KV NoSQL database - maybe mongoDB would serve you well.

    MVDBA

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply