Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2013
    Posts
    2

    Unanswered: Catalog based database engine

    I am looking for catalog based database engine. What I mean? Have you ever been to library? I mean not nowadays, but ealier when libraries not have been used computers. There was a paper based catalog. It was similar like directories. You don't need to fetch a lots of data, because you know excatly what are you looking for. You can jump straight to where you need instead of searching milliions of records. The sql parser goes through all rows till it finds a record. But if I know where the record is, I can jump straight to it. I mean is it exist the engine that implements this logic?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by zerrow View Post
    The sql parser goes through all rows till it finds a record.
    The "parser" doesn't go through anything. The parser only analyses the statement.
    The actual execution (which is what you mean) is done by the database engine itself (often called the "executor").

    See e.g. the Postgres manual that describes the different steps of query execution: http://www.postgresql.org/docs/curre...uery-path.html

    But if I know where the record is, I can jump straight to it. I mean is it exist the engine that implements this logic?
    Every modern relational DBMS does that. The concept is called an index.

    http://www.postgresql.org/docs/curre...xes-intro.html
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Dec 2013
    Posts
    2
    Thank you for the answer. I went through graph based databases engines and decide that neo4j should fits my needs the best. Is am right or you or somebody knows other one?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •