Upgrade to Pro — share decks privately, control downloads, hide ads and more …

RDB anti-pattern that Java engineer wants to know

RDB anti-pattern that Java engineer wants to know

JJUG CCC 2017 spring での登壇資料です。

http://www.java-users.jp/ccc2017spring/

soudai sone

May 20, 2017
Tweet

More Decks by soudai sone

Other Decks in Technology

Transcript

  1. σʔλϕʔεͷ໎ٶ demo=# SELECT delete_falg AS delete_flag FROM users GROUP BY

    delete_flag delete_flag ------------- 1 2 0 9 99 NULL (6 ߦ)
  2. σʔλϕʔεͷ໎ٶ JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ 

     ીࠜɹᗅָ   ીࠜɹࡣָ  ݱঢ়
  3. σʔλϕʔεͷ໎ٶ ձһJE ໊લ ೥ྸ ݖݶJE ౎ಓ෎ݝJE  ીࠜɹ૖େ  

      ીࠜɹኽָ     ીࠜɹᗅָ     ીࠜɹࡣָ    ཧ૝
  4. σʔλϕʔεͷ໎ٶ JE ձһJE ໊લ ೥ྸ ݖݶJE ౎ಓ෎ݝJE  /6-- ીࠜɹ૖େ

     /6-- /6--  /6-- ીࠜɹኽָ  /6-- /6--  /6-- ીࠜɹᗅָ  /6-- /6--  /6-- ીࠜɹࡣָ  /6-- /6-- ର৅ͷΧϥϜΛ௥Ճ
  5. σʔλϕʔεͷ໎ٶ JE ձһJE ໊લ ೥ྸ ݖݶJE ౎ಓ෎ݝJE   ીࠜɹ૖େ

         ીࠜɹኽָ      ીࠜɹᗅָ      ીࠜɹࡣָ    ର৅ͷΧϥϜΛ௥Ճ
  6. σʔλϕʔεͷ໎ٶ ձһJE ໊લ ೥ྸ ݖݶJE ౎ಓ෎ݝJE  ીࠜɹ૖େ  

      ીࠜɹኽָ     ીࠜɹᗅָ     ીࠜɹࡣָ    ཧ૝ͷ7JFXΛ࡞Δ