如何搞定NoSQL事务机制

在SequoiaDB巨杉数据库联合创始人兼CTO王涛看来，目前只有少量的NoSQL数据库支持事务机制，如VoltDB、RavenDB、SequoiaDB、MarkLogic。并且，“NoSQL支持事务（ACID）是未来的趋势，不支持事务的NoSQL会大大缩小其应用场景。”对于ACID来说，是指数据库事务机制正确执行的四大基本要素，包含了：原子性（Atomicity）、一致性（Consistency）、隔离性（Isolation）、持久性（Durability）。

中央广播电视总台。

经查询名人数据库资料显示，王涛是央视频道的主持人，因此在中央广播电视总台工作。

解说员，是指专门对体育项目/赛事进行讲解、介绍、分析的人员。

1: select name , age from student

2: select major_num from student where major = '计算机专业'

3: select * from student where age >19

4: select name , ID from stduent where major = '...'

5: select name , age from student where sex = '男' or age >19

6: select name , ID , sex from student where name like '王%'

7: select name , ID , sex from student where name NOT like '王%'

8: select name , ID , sex from student where name NOT like '_佳%'

9: select name , age ,major where age like [18-25]

10: select name , age ,major where age NOT like [18-25]

11: select * from student where name = (select major from student

where name = '王涛')

12: select ID,name from student where major_id = 001

13: select ID,name from student where major_id <>001

14: select * from student where zhuanyechengji >80

15: select ID,score from student where major_id = 001

Order by score DESC

16: select * from student order by age DESC ,major

17:

18: select count(*) from student

19: select count(*) from student where EXISTS (select scroe from

student)

20:

21:

22:

其他几道没有把握....就不放出来了

---