Re: Implementing SQL on files

From: Anuradha Ratnaweera (anuradha_at_linux.lk)
Date: 02/16/04

  • Next message: Valdis.Kletnieks_at_vt.edu: "Re: Linux 2.6.3-rc3 - IDE DMA errors on Thinkpad A30"
    To: Hans Reiser <reiser@namesys.com>
    Date:	Mon, 16 Feb 2004 10:27:09 +0600
    
    

    On Sun, 2004-02-15 at 11:39, Hans Reiser wrote:
    >
    > I hate SQL but I will cooperate with persons seeking to use our storage
    > layer to support it.

    Thanks Hans. I am not an SQL fan either. But more than SQL this
    is about database like storage simantics in the filesystem. I had
    this idea in my mind for some time, but the real motivation came
    after seeing the Reiserfs 4 page, notably this section:

    http://www.namesys.com/v4/v4.html#design_flaws_details

    and hopefully the plugin design will make life much easier.

    By looking at the feedback I got off the list, I think there is a
    couple of points I need to clarify.

    o The plan is _not_ to implement a fully flegded database inside
      the kernel. Only the storage (well, "only" may not be the most
      appropriate word here, because this involves a _lot_ of work)
      and the relation operation primitives - or database operation
      primitives to be more general - are implemented in the kernel
      space.

    o Userspace tools are necessary to parse a query, optimize if
      necessary, and pass the result (which is a tree) to the kernel.
      And the nodes of the parsed tree will map to the primitives
      implemented in the kernel.

      And most likely, I would be using an exiting database to do the
      heavy userspace work (suggested by Peter Zaitsev of MySQL).

    Thanks for all the suggessions and comments (mostly offline).

            Anuradha

    -- 
    http://www.linux.lk/~anuradha/
    -
    To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
    the body of a message to majordomo@vger.kernel.org
    More majordomo info at  http://vger.kernel.org/majordomo-info.html
    Please read the FAQ at  http://www.tux.org/lkml/
    

  • Next message: Valdis.Kletnieks_at_vt.edu: "Re: Linux 2.6.3-rc3 - IDE DMA errors on Thinkpad A30"

    Relevant Pages

    • Re: Problems with querying date field
      ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
      (microsoft.public.sqlserver.programming)
    • Re: Capacity Issues with SQL
      ... So go for 3 Servers. ... > We're running a bespoke CRM tool running SQL as its backend. ... > create too much extra storage, ... > processor to cover the database. ...
      (microsoft.public.windows.terminal_services)
    • Re: separate doc storage server
      ... This is a SQL setup issue not a SharePoint issue. ... SharePoint is stored in a database and if you put that database on a sql ... storage solution and put your SQL sharepoint databases on the NAS. ...
      (microsoft.public.sharepoint.portalserver)
    • Re: rows
      ... supposed to have "first" and "last" rows in any physical sense. ... Order of storage on the disk is irrelevant and in a relational ... database system isn't supposed to be even available to the user. ... The SQL given above does what you want so far as I can see. ...
      (alt.php)
    • Re: dbdebunk Quote of Week comment
      ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
      (comp.databases.theory)