English 中文(简体)
我如何把我的SQL表格作为卡桑德拉的“超级哥伦”表模型?
原标题:How do I model this MySQL table as a Super ColumnFamily in Cassandra?

Im目前正在设计一个个人项目数据库,Im正在运行。 实际上,我已经设计了这个概念,但现在我把它从关系(MySQL)改为非宗教(Cassandra)。

One of my tables (called "Friend request table") has a primary key that consists of 3 attributes: Receiver ID, Sender ID, and Request time (timestamp). There are 4 other attributes in the table as well:

Receiver ID  (Part of primary key)
Sender ID    (Part of primary key)
Request time (Part of primary key)
Request text
Request status
Time last viewed
Time accepted

我的思路是,根据将发件人身份识别器贴上接收器的计算结果,将各行子按申请时间排列。 这将努力储存这些请求,但我不知道我如何恢复这些请求。

是否有任何人建议以另一种方式在卡桑德拉模仿这种做法?

最佳回答

你们为什么认为答案涉及超级框架? 看像最直截了当的解决办法,就是仿照你在神话中(用UUID钥匙)的做法,并在你想要问的栏目上设定指数。

问题回答

暂无回答




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签