English 中文(简体)
• 如何建立一个等级数据库,配备一个Pache Cassandra
原标题:How do i build a hierarchical database with apache Cassandra

我想开发一个等级数据库,在档案系统中储存directory structure

Just like

 Root
   -dir
     -subdir
     -subdir
        -subdir
            -subdir
            -subdir
     -subdir
     -subdir

可为此使用阿帕奇卡桑。

ajava的例子将更好理解。

最佳回答

您可以在一栏家庭储存一条途径的数据、类型和母体,

paths { #colum family 
    "/some/path" { # key
         "type" : "file|directory" #column, either file or directory, if this is a file or a directory
         "data" : "??" # if this is a file, the data for the file.  you don t want to be storing very large files in cassandra in one column
    }
}

你们需要用 cas子来解冻,以回答你要回答的问题。 也许,你想问一位女长的孩子,就像一个结构一样。

children { #column family 
    "/some/path" { # key
         "child-path-1" : null #column, one for each child of /some/path
         "child-path-2" : null 
    }
}

增加一栏家庭,支持你希望做的其他询问。

问题回答

而现在的情况是,如果存在某种关系,则会做些什么。

product{
  id int,
  parent_id int,
  name varchar2(30)
}

Sample data:

product
--------------------
id   | parent_id   | name
0    | 0           | root
1    | 0           | laptop
2    | 0           | pc
3    | 1           | Dell Latitude E4310
4    | 1           | Dell Vostro E3300
5    | 2           | Compaq Desktop 3
6    | 2           | Compaq Presario 2




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签