Slide 1
Slide 1 text
SchemaPolicyCheck
()
2018/12/02
Slide 2
Slide 2 text
• %1: "/ -2 ( )
• : ATK → !,4
• )+203
• .( (SRE)
'*
•
DBFlute
&$#
Slide 3
Slide 3 text
LT
1
Before/After
2
SchemaPolicy
Tips
3
Slide 4
Slide 4 text
Slide 5
Slide 5 text
• DBA
( )
•
DB
Slide 6
Slide 6 text
9
MTG
Slide 7
Slide 7 text
< DB' # &"
'
( $
%…) >
DBA, !
Slide 8
Slide 8 text
< DB/# +" &.*
/
(%, -…) >
< DB/#
'!(
$DBA, )
Slide 9
Slide 9 text
< DB1% -$ (0,
1
('." /
…) >
<
DB1% )#*
>
&DBA, !+
Slide 10
Slide 10 text
• DB0&
• !/*',
Alter-check.
DDL%
• 2+32$3.
• #-()(8"1)
Slide 11
Slide 11 text
SchemaPolicyCheck
Slide 12
Slide 12 text
Before/After
Slide 13
Slide 13 text
• : 500
• DB: 2~3
•
Slide 14
Slide 14 text
• "#
$5DB
3*%:
• SchemaPolicyMap
&
• -/7 140+.
• 2:8%4
• 98%4
• '6 )
• !(2
• …
0,
Slide 15
Slide 15 text
schemaPolicyMap
Slide 16
Slide 16 text
Before → After
•
• " DDL alter-check
• DBA$→%
•
• " DDL alter-check → SchemaPolicyCheck
• DBA # !
&
Slide 17
Slide 17 text
After
Good(From DBA)
• DB% !→30
• DB"
• ($'#&)
SchemaPolicyCheck
Slide 18
Slide 18 text
After
Good
• “/ *1%”$0
.2-)
• +
!4& ,(
• '3
#(
1% "
Slide 19
Slide 19 text
DB
Slide 20
Slide 20 text
After
Bad
• $ SchemaPolicyMap %
#'
• &
!
"
#'
Slide 21
Slide 21 text
SchemaPolicyTips
Slide 22
Slide 22 text
SchemaPolicyTips
•
Slide 23
Slide 23 text
SchemaPolicyTips
•
•
1.
2. firstDate
3.
1 > 2 > 3
2 : 3
Slide 24
Slide 24 text
SchemaPolicyTips
•
!
•
"
Slide 25
Slide 25 text
SchemaPolicyTips
• : XXX_TM
DATETIME
•
XXX_TM
•
DATETIME
Slide 26
Slide 26 text
SchemaPolicy()
•
• uniqueTableAlias
•
• sameColumnNameIfSameColumnAlias
Slide 27
Slide 27 text
SchemaPolicy()
• PK #
• +*' #
• '
!&
• $ ( )
• %" (')
Slide 28
Slide 28 text
SchemaPolicy()
• ,+-AUTO_INCREMENT
*
• (% )
• #/ !& DATETIME
• '$" . BIGINT
Slide 29
Slide 29 text
SchemaPolicy()
•