About the problem of DBMS choice & what to do if you have gone the wrong way | Roman Bugaev

Transcript

1. Bugaev  Roman About  the  problem  of  DBMS  choice  &  what

    to  do   if  you  have  gone  the  wrong  way

2. .NET  web-­‐‑developer

3. SQL or NoSQL, that is the question!

4. Ñ Learning  management  system Ñ SCORM   Ñ 1  million  active  users CyberU

5. Ñ No  transactions Ñ No  relations Ñ No  datatypes  (some) SimpleDB

6. Key  →  ALribute  →  Value select  count(*)  from  cyberu_users  where

    RecordType  =  'user'  

7. Prons  &  Cons  

8. Ñ Everything  is  indexed Ñ Distributed Ñ Replicated Ñ Completely  hosted  on  Amazon  system

   BUT Ñ Latency  specially  if  you’re  not  on  ec2   (even  between  nodes) Ñ Only  strings,  lexicographical  string  only Ñ Huge  amount  of  code  

9. Ñ  If  you  love  writing  code-­‐‑-­‐‑  really,  truly  love  to

     write  code-­‐‑-­‐‑  you'ʹll  love  it  enough  to  write  as   liLle  of  it  as  possible.  And  SQL  can  help  you.

10. SQL  is  awesome! -­‐‑  Structured  Query  Language -­‐‑  ACID Atomicity,

     Consistency,  Isolation,  Durability -­‐‑  Predictable -­‐‑  Schema -­‐‑  Based  on  rational  algebra -­‐‑  Standardized  

11. No,  really,  it'ʹs  awesome! -­‐‑  Hardened -­‐‑  Free  and  commercial

     choices -­‐‑  MySQL,  PostgreSQL,  Oracle,  DB2,  MS   SQL... -­‐‑  Commercial  support -­‐‑  Tooling -­‐‑  Everyone  knows  it -­‐‑  It'ʹs  mature!
12. None

13. Sellerhit

14. So... -­‐‑  Some  preLy  big  and  important   problems -­‐‑

     And  brightest  engineers  in  the  world -­‐‑  Who  loooove  to  build  stuff

15. Yesterday'ʹs  problem  of   biggest  guys     Is  today'ʹs

     problem  of   startup  in  garage    

16. Ñ  What  schema  can  be  fine  for  a  lot  of

     product’s   types? E-­‐‑commerce

17. Books

18. Music

19. Jeans

20. Ñ Flexible  (and  sane) Ñ Searchable   Ñ Easy  to  use Ñ Fast MongoDB

21. Ñ Atomic  single  document  writes Ó If  you  need  atomic  writes  across

      multi-­‐‑document  –  don’t  use   MongoDB   And  what  about  $$?

22. Ñ Orders,  Inventory  (id,  count)   and  Payment  Transaction  you  

    can  store  in  SQL Ñ UI  –  MongoDB,  ecomerce  -­‐‑  SQL   Most  boring  SQL  Scheme  ever    

23. Ñ  Double  check  you  choice  of  DBMS  and  tools  

    Ñ  Do  it  fast Ñ  Check  your  logic   Ñ  Enterprise  design Ñ  Id<User>  !=  Id<Product> Ñ  Unit  tests Ñ  Delete  code   Ñ  Optimize  your  tools Ñ  Be  brave! Data  migrations

24. Use  case  –  first,  DB  –  last   ©  Anonymous

     

25. Neo4J  –  Graph  database

26. { Thx!  Q?   Bugaev  Roman,  @rbugaev