4D v11 SQL in Depth (2010)

Transcript

1. 4D v11 SQL in Depth #1
2. 4D v11 SQL in Depth #1 • ΞʔΩςΫνϟʔ / εέʔϥϏϦςΟ
3. Tokyo/2010-03-03/04 ༻ޠͷఆٛ
4. Tokyo/2010-03-03/04 ༻ޠͷఆٛ • ίΦϖϥςΟϒ: ଞͷϓϩηεʢλεΫ, εϨο υ, ...ʣʹৡΔCPU࣌ؒΛࣗ෼ͰܾΊΔϓϩηε
5. Tokyo/2010-03-03/04 ༻ޠͷఆٛ • ίΦϖϥςΟϒ: ଞͷϓϩηεʢλεΫ, εϨο υ, ...ʣʹৡΔCPU࣌ؒΛࣗ෼ͰܾΊΔϓϩηε ‣ ಠ઎Ͱ͖Δ = ϒϩοΫͰ͖Δʢྫ : Mac OS 9ʣ
6. Tokyo/2010-03-03/04 ༻ޠͷఆٛ • ίΦϖϥςΟϒ: ଞͷϓϩηεʢλεΫ, εϨο υ, ...ʣʹৡΔCPU࣌ؒΛࣗ෼ͰܾΊΔϓϩηε ‣ ಠ઎Ͱ͖Δ = ϒϩοΫͰ͖Δʢྫ : Mac OS 9ʣ ‣ ͻͱͭͷΞϓϦέʔγϣϯͷίΦϖϥςΟϒεϨ ου͸ඞͣಉ͡ίΞͰ࣮ߦ͞ΕΔ
7. Tokyo/2010-03-03/04 ༻ޠͷఆٛ • ίΦϖϥςΟϒ: ଞͷϓϩηεʢλεΫ, εϨο υ, ...ʣʹৡΔCPU࣌ؒΛࣗ෼ͰܾΊΔϓϩηε ‣ ಠ઎Ͱ͖Δ = ϒϩοΫͰ͖Δʢྫ : Mac OS 9ʣ ‣ ͻͱͭͷΞϓϦέʔγϣϯͷίΦϖϥςΟϒεϨ ου͸ඞͣಉ͡ίΞͰ࣮ߦ͞ΕΔ • ϓϦΤϯϓςΟϒ: ͦΕͧΕͷϓϩηεʹ༩͑ΒΕ ΔCPU࣌ؒ͸OS͕൑அ͢Δ
8. Tokyo/2010-03-03/04 ༻ޠͷఆٛ • ίΦϖϥςΟϒ: ଞͷϓϩηεʢλεΫ, εϨο υ, ...ʣʹৡΔCPU࣌ؒΛࣗ෼ͰܾΊΔϓϩηε ‣ ಠ઎Ͱ͖Δ = ϒϩοΫͰ͖Δʢྫ : Mac OS 9ʣ ‣ ͻͱͭͷΞϓϦέʔγϣϯͷίΦϖϥςΟϒεϨ ου͸ඞͣಉ͡ίΞͰ࣮ߦ͞ΕΔ • ϓϦΤϯϓςΟϒ: ͦΕͧΕͷϓϩηεʹ༩͑ΒΕ ΔCPU࣌ؒ͸OS͕൑அ͢Δ • ϓϦΤϯϓςΟϒͳ౓߹͍͕ߴ͍΄Ͳ଎͍
9. Tokyo/2010-03-03/04 ࡾରͷπΠϯ 4
10. Tokyo/2010-03-03/04 ࡾରͷπΠϯ • 4D Clientͷάϩʔόϧϓϩηε͸ඞͣαʔόʔʹ͋Δ;ͨͭͷπΠ ϯϓϩηεͱର࿩͍ͯ͠Δ: ‣ ϓϦΤϯϓςΟϒ εϨου: «७ਮͳ» DB4DϦΫΤετΛॲཧ (query, order by, create, ...) ‣ ίΦϖϥςΟϒ εϨου: ΞϓϦέʔγϣϯϦΫΤετΛॲཧ (Current date(*), GET PROCESS VARIABLE(-1;...), τϦΨ, ...) 4
11. Tokyo/2010-03-03/04 ࡾରͷπΠϯ • 4D Clientͷάϩʔόϧϓϩηε͸ඞͣαʔόʔʹ͋Δ;ͨͭͷπΠ ϯϓϩηεͱର࿩͍ͯ͠Δ: ‣ ϓϦΤϯϓςΟϒ εϨου: «७ਮͳ» DB4DϦΫΤετΛॲཧ (query, order by, create, ...) ‣ ίΦϖϥςΟϒ εϨου: ΞϓϦέʔγϣϯϦΫΤετΛॲཧ (Current date(*), GET PROCESS VARIABLE(-1;...), τϦΨ, ...) • ϓϦΤϯϓςΟϒͳୈࡾͷεϨουͱର࿩͢Δ͜ͱ΋͋Δ 4
12. Tokyo/2010-03-03/04 ࡾରͷπΠϯ • 4D Clientͷάϩʔόϧϓϩηε͸ඞͣαʔόʔʹ͋Δ;ͨͭͷπΠ ϯϓϩηεͱର࿩͍ͯ͠Δ: ‣ ϓϦΤϯϓςΟϒ εϨου: «७ਮͳ» DB4DϦΫΤετΛॲཧ (query, order by, create, ...) ‣ ίΦϖϥςΟϒ εϨου: ΞϓϦέʔγϣϯϦΫΤετΛॲཧ (Current date(*), GET PROCESS VARIABLE(-1;...), τϦΨ, ...) • ϓϦΤϯϓςΟϒͳୈࡾͷεϨουͱର࿩͢Δ͜ͱ΋͋Δ ‣ ͜Ε͸Begin SQL͕࣮ߦ͞ΕΔͱ࡞੒͞ΕΔ 4
13. Tokyo/2010-03-03/04 ࡾରͷπΠϯ • 4D Clientͷάϩʔόϧϓϩηε͸ඞͣαʔόʔʹ͋Δ;ͨͭͷπΠ ϯϓϩηεͱର࿩͍ͯ͠Δ: ‣ ϓϦΤϯϓςΟϒ εϨου: «७ਮͳ» DB4DϦΫΤετΛॲཧ (query, order by, create, ...) ‣ ίΦϖϥςΟϒ εϨου: ΞϓϦέʔγϣϯϦΫΤετΛॲཧ (Current date(*), GET PROCESS VARIABLE(-1;...), τϦΨ, ...) • ϓϦΤϯϓςΟϒͳୈࡾͷεϨουͱର࿩͢Δ͜ͱ΋͋Δ ‣ ͜Ε͸Begin SQL͕࣮ߦ͞ΕΔͱ࡞੒͞ΕΔ • ͦΕͧΕͷର࿩͸ҟͳΔωοτϫʔΫϙʔτΛ࢖༻͢Δ: 4 . . . $date:=Current date(*) . . . QUERY([City];[City]Name=”Paris”) . . . Begin SQL . . .
14. Tokyo/2010-03-03/04 ࡾରͷπΠϯ • 4D Clientͷάϩʔόϧϓϩηε͸ඞͣαʔόʔʹ͋Δ;ͨͭͷπΠ ϯϓϩηεͱର࿩͍ͯ͠Δ: ‣ ϓϦΤϯϓςΟϒ εϨου: «७ਮͳ» DB4DϦΫΤετΛॲཧ (query, order by, create, ...) ‣ ίΦϖϥςΟϒ εϨου: ΞϓϦέʔγϣϯϦΫΤετΛॲཧ (Current date(*), GET PROCESS VARIABLE(-1;...), τϦΨ, ...) • ϓϦΤϯϓςΟϒͳୈࡾͷεϨουͱର࿩͢Δ͜ͱ΋͋Δ ‣ ͜Ε͸Begin SQL͕࣮ߦ͞ΕΔͱ࡞੒͞ΕΔ • ͦΕͧΕͷର࿩͸ҟͳΔωοτϫʔΫϙʔτΛ࢖༻͢Δ: 4 . . . $date:=Current date(*) . . . QUERY([City];[City]Name=”Paris”) . . . Begin SQL . . . ΞϓϦέʔγϣϯαʔόʔϙʔτ: 19813
15. Tokyo/2010-03-03/04 ࡾରͷπΠϯ • 4D Clientͷάϩʔόϧϓϩηε͸ඞͣαʔόʔʹ͋Δ;ͨͭͷπΠ ϯϓϩηεͱର࿩͍ͯ͠Δ: ‣ ϓϦΤϯϓςΟϒ εϨου: «७ਮͳ» DB4DϦΫΤετΛॲཧ (query, order by, create, ...) ‣ ίΦϖϥςΟϒ εϨου: ΞϓϦέʔγϣϯϦΫΤετΛॲཧ (Current date(*), GET PROCESS VARIABLE(-1;...), τϦΨ, ...) • ϓϦΤϯϓςΟϒͳୈࡾͷεϨουͱର࿩͢Δ͜ͱ΋͋Δ ‣ ͜Ε͸Begin SQL͕࣮ߦ͞ΕΔͱ࡞੒͞ΕΔ • ͦΕͧΕͷର࿩͸ҟͳΔωοτϫʔΫϙʔτΛ࢖༻͢Δ: 4 . . . $date:=Current date(*) . . . QUERY([City];[City]Name=”Paris”) . . . Begin SQL . . . DB4D ϙʔτ: 19814 ΞϓϦέʔγϣϯαʔόʔϙʔτ: 19813 SQLαʔόʔϙʔτ: 19812
16. Tokyo/2010-03-03/04
17. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3…⋯ Ϣʔβʔ 1
18. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3…⋯ Ϣʔβʔ 1 ϓϩηε U1-1 ϓϩηε U1-1 19813 19814
19. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3…⋯ Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1…⋯ R2 Ϣʔβʔ 3 ϓϩηε U1-1 ϓϩηε U1-1 ϓϩηε U2-2 R1.. R3 19813 19814
20. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3…⋯ Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1…⋯ R2 Ϣʔβʔ 3 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U2-2 R1.. R3 19813 19814
21. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3…⋯ Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1…⋯ R2 Ϣʔβʔ 3 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U2-2 R1.. R3 19813 19814
22. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3…⋯ Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1…⋯ R2 Ϣʔβʔ 3 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U2-2 R1.. R3 19813 19814
23. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U2-2 R1.. R2 19813 19814
24. Tokyo/2010-03-03/04 4D Server αʔόʔ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U1-1 ϓϩηε U2-1 ϓϩηε U2-2 ϓϩηε U3-1 ϓϩηε U3-2 ϓϩηε U2-2 R1.. R2 19813 19814
25. Tokyo/2010-03-03/04 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1…⋯ R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R3 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
26. Tokyo/2010-03-03/04 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
27. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
28. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ 19812
29. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ 19812
30. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ 19812
31. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 Process U2-2 R1.. R2 19812 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
32. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 Process U2-2 R1.. R2 19812 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
33. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ 19812
34. Tokyo/2010-03-03/04 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
35. Tokyo/2010-03-03/04 ৳ுੑͱ଎౓ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ DBϦΫΤετ͸ಉ࣌ʹෳ਺ͷ ΫϥΠΞϯτ͕࣮ߦͰ͖Δ
36. Tokyo/2010-03-03/04 ৳ுੑͱ଎౓ ϘτϧωοΫ ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ DBϦΫΤετ͸ಉ࣌ʹෳ਺ͷ ΫϥΠΞϯτ͕࣮ߦͰ͖Δ ϥϯήʔδ τϦΨ ϝιου «αʔόʔͰ࣮ߦ» ετΞυϓϩγʔδϟʔ Web αʔόʔ/SOAP 4Dࣗମ: αʔόʔͷϢʔβʔΠϯλϑΣʔ ε ίωΫγϣϯϋϯυϥʔ ͋Δछͷ֎෦SQLϦΫΤετ
37. Tokyo/2010-03-03/04 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ ϘτϧωοΫ
38. Tokyo/2010-03-03/04 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ 2004Ҏલ: ίΦϖϥςΟϒ
39. Tokyo/2010-03-03/04 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ
40. Tokyo/2010-03-03/04 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ
41. Tokyo/2010-03-03/04 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ
42. Tokyo/2010-03-03/04 2004Ҏલ: ίΦϖϥςΟϒ 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ
43. Tokyo/2010-03-03/04 2004Ҏલ: ίΦϖϥςΟϒ v11: ϓϦΤϯϓςΟϒ... ...ͦͯ͠εέʔϥϒϧ 10 ΫϥΠΞϯτ, QUERY ·ͨ͸ ORDER BY ಉ࣌ʹ࣮ߦ
44. Tokyo/2010-03-03/04 ͍Ζ͍Ζͳαʔόʔ
45. Tokyo/2010-03-03/04 ͍Ζ͍Ζͳαʔόʔ ΞϓϦέʔγϣϯαʔόʔ Web /SOAP SQL αʔόʔ DB4D αʔόʔ ίΦϖϥςΟϒ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ϓϦΤϯϓςΟϒ
46. Tokyo/2010-03-03/04 v11-v12 σεΫτοϓ σεΫτοϓ ΫϥΠΞϯτ ΫϥΠΞϯτ-αʔόʔ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ΠϯλϑΣʔ ε全般 ϥϯήʔδ ετΞυϓϩγʔδϟʔ HTTP αʔόʔ ΞϓϦέʔγϣϯαʔόʔ ΠϯσοΫεϏϧμ ʔ ϑϥογϡϚωʔδϟʔ SQL αʔόʔ DB4D（σʔλΞΫηε）
47. Tokyo/2010-03-03/04 v11-v12 σεΫτοϓ σεΫτοϓ ΫϥΠΞϯτ ΫϥΠΞϯτ-αʔόʔ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ΠϯλϑΣʔ ε全般 ϥϯήʔδ ετΞυϓϩγʔδϟʔ HTTP αʔόʔ ΞϓϦέʔγϣϯαʔόʔ ΠϯσοΫεϏϧμ ʔ ϑϥογϡϚωʔδϟʔ SQL αʔόʔ DB4D（σʔλΞΫηε）
48. Tokyo/2010-03-03/04 Begin SQL... Begin SQL... Begin SQL... Begin SQL... Begin SQL... 4D Server αʔόʔ 19813 19814 ϓϩηε U1-1 Req1... QUERY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U2-1 R1... Current date(*) R2.. Ϣʔβʔ 2 ϓϩηε U3-1 R1…⋯ R2 ϓϩηε U3-2 R1.. R2 Ϣʔβʔ 3 ϓϩηε U2-2 R1.. R2 ΦϖϨʔςΟϯάγεςϜ ίΦϖϥςΟϒ ϓϦΤϯϓςΟϒ ίΞ 1 ίΞ 2 ίΞ 3 ίΞ 4 εέδϡʔϥʔ
49. Tokyo/2010-03-03/04
50. Tokyo/2010-03-03/04 ϘτϧωοΫ ϥϯήʔδ τϦΨ ϝιου «αʔόʔͰ࣮ߦ» ετΞυϓϩγʔδϟʔ Web αʔόʔ/SOAP 4Dࣗମ: αʔόʔͷϢʔβʔΠϯλϑΣʔ ε ίωΫγϣϯϋϯυϥʔ ͋Δछͷ֎෦SQLϦΫΤετ
51. Tokyo/2010-03-03/04 ϘτϧωοΫ ϥϯήʔδ τϦΨ ϝιου «αʔόʔͰ࣮ߦ» ετΞυϓϩγʔδϟʔ Web αʔόʔ/SOAP
52. Tokyo/2010-03-03/04 ϘτϧωοΫ ϥϯήʔδ τϦΨ ϝιου «αʔόʔͰ࣮ߦ» ετΞυϓϩγʔδϟʔ Web αʔόʔ/SOAP • αʔόʔ͕ૉૣ͘ऴ͑ΒΕΔΑ͏ʹ • τϦΨ: ‣ ઈରʹඞཁͳ৔߹͚ͩ ‣ ൚༻తͳίʔυ͸ආ͚Δ • ΫϥΠΞϯτ͔ΒϓϦΤϯϓςΟϒʹ (STA/ ATS, ...) • EXECUTE ON CLIENT͕׆༻Ͱ͖Δ͔΋ • ίϯύΠϧϞʔυͰॏ౓ͷϧʔ ϓ: IDLE • ίʔυϦϑΝΫλϦϯά: ͦΜͳʹͨ͘͞Μͷε τΞυϓϩγʔδϟʔ͕΄Μͱ͏ʹඞཁ ? • . . .
53. Tokyo/2010-03-03/04 ϘτϧωοΫ ϥϯήʔδ τϦΨ ϝιου «αʔόʔͰ࣮ߦ» ετΞυϓϩγʔδϟʔ Web αʔόʔ/SOAP • αʔόʔ͕ૉૣ͘ऴ͑ΒΕΔΑ͏ʹ • τϦΨ: ‣ ઈରʹඞཁͳ৔߹͚ͩ ‣ ൚༻తͳίʔυ͸ආ͚Δ • ΫϥΠΞϯτ͔ΒϓϦΤϯϓςΟϒʹ (STA/ ATS, ...) • EXECUTE ON CLIENT͕׆༻Ͱ͖Δ͔΋ • ίϯύΠϧϞʔυͰॏ౓ͷϧʔ ϓ: IDLE • ίʔυϦϑΝΫλϦϯά: ͦΜͳʹͨ͘͞Μͷε τΞυϓϩγʔδϟʔ͕΄Μͱ͏ʹඞཁ ? • . . . ߟྔͤΑ «ෛՙͱ଎౓»
54. 4D v11 SQL in Depth #1 • ΞʔΩςΫνϟʔ / εέʔϥϏϦςΟ
55. 4D v11 SQL in Depth #1 • ΞʔΩςΫνϟʔ / εέʔϥϏϦςΟ • SQL vs 4D
56. Clichy/2010-02-03 SQL vs 4D - ύϑΥʔϚϯε
57. Clichy/2010-02-03 4D, ௨ৗ QUERY( . . .) SQL SELECT . . . FROM . . . WHERE . . . SQL vs 4D - ύϑΥʔϚϯε
58. Clichy/2010-02-03 4D, ௨ৗ QUERY( . . .) SQL SELECT . . . FROM . . . WHERE . . . ΠϯλϓϦλʔ SQL vs 4D - ύϑΥʔϚϯε
59. Clichy/2010-02-03 4D, ௨ৗ QUERY( . . .) SQL SELECT . . . FROM . . . WHERE . . . ΠϯλϓϦλʔ DB4D Τϯδϯ σʔλϑΝΠϧ/ΠϯσοΫεϑΝΠϧ SQL vs 4D - ύϑΥʔϚϯε
60. Clichy/2010-02-03 • 4D͸ෆՄ෼, ϫϯΞΫγϣϯʹରͯ͠ߴ౓ʹ࠷దԽ SQL vs 4D - ύϑΥʔϚϯε
61. Clichy/2010-02-03 • 4D͸ෆՄ෼, ϫϯΞΫγϣϯʹରͯ͠ߴ౓ʹ࠷దԽ ‣ QUERY - ݕࡧ, ηϨΫγϣϯͷ࡞੒, ઌ಄Ϩίʔυͷϩʔυ - ͜͜·ͰΛ͢΂ͯͻͱͭͷίϚϯυͰ SQL vs 4D - ύϑΥʔϚϯε
62. Clichy/2010-02-03 • 4D͸ෆՄ෼, ϫϯΞΫγϣϯʹରͯ͠ߴ౓ʹ࠷దԽ ‣ QUERY - ݕࡧ, ηϨΫγϣϯͷ࡞੒, ઌ಄Ϩίʔυͷϩʔυ - ͜͜·ͰΛ͢΂ͯͻͱͭͷίϚϯυͰ • SQL͸൚༻త ‣ ͻͱͭͷ໋ྩ (SELECT) Ͱ͋ΒΏΔཁٻʹରॲ SQL vs 4D - ύϑΥʔϚϯε
63. Clichy/2010-02-03 • 4D͸ෆՄ෼, ϫϯΞΫγϣϯʹରͯ͠ߴ౓ʹ࠷దԽ ‣ QUERY - ݕࡧ, ηϨΫγϣϯͷ࡞੒, ઌ಄Ϩίʔυͷϩʔυ - ͜͜·ͰΛ͢΂ͯͻͱͭͷίϚϯυͰ • SQL͸൚༻త ‣ ͻͱͭͷ໋ྩ (SELECT) Ͱ͋ΒΏΔཁٻʹରॲ ‣ Ճ͑ͯଘࡏ͢ΔΦʔόʔϔου: - ղੳ - ݕূ - SQL ύεεϧʔ SQL vs 4D - ύϑΥʔϚϯε
64. Clichy/2010-02-03 • 4D͸ෆՄ෼, ϫϯΞΫγϣϯʹରͯ͠ߴ౓ʹ࠷దԽ ‣ QUERY - ݕࡧ, ηϨΫγϣϯͷ࡞੒, ઌ಄Ϩίʔυͷϩʔυ - ͜͜·ͰΛ͢΂ͯͻͱͭͷίϚϯυͰ • SQL͸൚༻త ‣ ͻͱͭͷ໋ྩ (SELECT) Ͱ͋ΒΏΔཁٻʹରॲ ‣ Ճ͑ͯଘࡏ͢ΔΦʔόʔϔου: - ղੳ - ݕূ - SQL ύεεϧʔ - ϥϯήʔδόΠϯσΟϯά SQL vs 4D - ύϑΥʔϚϯε
65. Clichy/2010-02-03 • 4D͸ෆՄ෼, ϫϯΞΫγϣϯʹରͯ͠ߴ౓ʹ࠷దԽ ‣ QUERY - ݕࡧ, ηϨΫγϣϯͷ࡞੒, ઌ಄Ϩίʔυͷϩʔυ - ͜͜·ͰΛ͢΂ͯͻͱͭͷίϚϯυͰ • SQL͸൚༻త ‣ ͻͱͭͷ໋ྩ (SELECT) Ͱ͋ΒΏΔཁٻʹରॲ ‣ Ճ͑ͯଘࡏ͢ΔΦʔόʔϔου: - ղੳ - ݕূ - SQL ύεεϧʔ - ϥϯήʔδόΠϯσΟϯά - Τϯδϯোน SQL vs 4D - ύϑΥʔϚϯε
66. Clichy/2010-02-03 4D, ௨ৗ QUERY( . . .) SQL SELECT . . . FROM . . . WHERE . . . ΠϯλϓϦλʔ DB4D Τϯδϯ σʔλϑΝΠϧ/ΠϯσοΫεϑΝΠϧ
67. Clichy/2010-02-03 4D, ௨ৗ QUERY( . . .) SQL SELECT . . . FROM . . . WHERE . . . ΠϯλϓϦλʔ DB4D Τϯδϯ σʔλϑΝΠϧ/ΠϯσοΫεϑΝΠϧ
68. Clichy/2010-02-03 • v11: SQL ͸ 5-10 ഒ஗͍৔߹͕͋Δ SQL vs 4D - ύϑΥʔϚϯε
69. Clichy/2010-02-03 • v11: SQL ͸ 5-10 ഒ஗͍৔߹͕͋Δ ‣ ͔͜͠͠Ε͸๞͘·Ͱฏۉ, ͋·ΓัΘΕͳ͍Α͏ʹ ‣ ৔߹ʹΑͬͯ͸, SQLͷ΄͏͕଎͍͜ͱ΋ SQL vs 4D - ύϑΥʔϚϯε
70. Clichy/2010-02-03 • v11: SQL ͸ 5-10 ഒ஗͍৔߹͕͋Δ ‣ ͔͜͠͠Ε͸๞͘·Ͱฏۉ, ͋·ΓัΘΕͳ͍Α͏ʹ ‣ ৔߹ʹΑͬͯ͸, SQLͷ΄͏͕଎͍͜ͱ΋ - యܕྫ͸ܭࢉΛཁ͢Δεςʔτϝϯτ: SELECT (Debits - Credits) FROM Clients into :rBalance - ϓϦΤϯϓςΟϒ - গͳ͍ωοτϫʔΫϦΫΤετ SQL vs 4D - ύϑΥʔϚϯε
71. Clichy/2010-02-03 • v11: SQL ͸ 5-10 ഒ஗͍৔߹͕͋Δ ‣ ͔͜͠͠Ε͸๞͘·Ͱฏۉ, ͋·ΓัΘΕͳ͍Α͏ʹ ‣ ৔߹ʹΑͬͯ͸, SQLͷ΄͏͕଎͍͜ͱ΋ - యܕྫ͸ܭࢉΛཁ͢Δεςʔτϝϯτ: SELECT (Debits - Credits) FROM Clients into :rBalance - ϓϦΤϯϓςΟϒ - গͳ͍ωοτϫʔΫϦΫΤετ • SQL 12 vs SQL v11 ‣ ϩʔΧϧσʔλϑΣονϯά => 2-3 ഒߴ଎ ‣ ϦϞʔτσʔλϑΣονϯά => 5-20 ഒߴ଎ SQL vs 4D - ύϑΥʔϚϯε
72. Clichy/2010-02-03 • ͲͷΑ͏ͳ৔߹ʹSQLΛ࢖༻͢Δ΂͖ ? SQL vs 4D - ύϑΥʔϚϯε
73. Clichy/2010-02-03 • ͲͷΑ͏ͳ৔߹ʹSQLΛ࢖༻͢Δ΂͖ ? ‣ ͦͷ΄͏͕଎͍ͱࢥ͑Δࠜڌ͕͋Δͱ͖ SQL vs 4D - ύϑΥʔϚϯε
74. Clichy/2010-02-03 • ͲͷΑ͏ͳ৔߹ʹSQLΛ࢖༻͢Δ΂͖ ? ‣ ͦͷ΄͏͕଎͍ͱࢥ͑Δࠜڌ͕͋Δͱ͖ ‣ SQLͰهड़ͨ͠΄͏ָ͕ͳͱ͖: SQL vs 4D - ύϑΥʔϚϯε
75. Clichy/2010-02-03 • ͲͷΑ͏ͳ৔߹ʹSQLΛ࢖༻͢Δ΂͖ ? ‣ ͦͷ΄͏͕଎͍ͱࢥ͑Δࠜڌ͕͋Δͱ͖ ‣ SQLͰهड़ͨ͠΄͏ָ͕ͳͱ͖: SQL vs 4D - ύϑΥʔϚϯε
76. Clichy/2010-02-03 • ͲͷΑ͏ͳ৔߹ʹSQLΛ࢖༻͢Δ΂͖ ? ‣ ͦͷ΄͏͕଎͍ͱࢥ͑Δࠜڌ͕͋Δͱ͖ ‣ SQLͰهड़ͨ͠΄͏ָ͕ʢඒ͍͠ ?ʣͳͱ͖ ‣ ଞͷDBʢ4D͋Δ͍͸ͦΕҎ֎ʣʹ઀ଓ͢Δͱ͖ SQL vs 4D - ύϑΥʔϚϯε
77. Clichy/2010-02-03 • ͲͷΑ͏ͳ৔߹ʹSQLΛ࢖༻͢Δ΂͖ ? ‣ ͦͷ΄͏͕଎͍ͱࢥ͑Δࠜڌ͕͋Δͱ͖ ‣ SQLͰهड़ͨ͠΄͏ָ͕ʢඒ͍͠ ?ʣͳͱ͖ ‣ ଞͷDBʢ4D͋Δ͍͸ͦΕҎ֎ʣʹ઀ଓ͢Δͱ͖ ‣ SQLಛ༗ͷػೳ͕ඞཁͳͱ͖ SQL vs 4D - ύϑΥʔϚϯε
78. Clichy/2010-02-03 • DBϝʔΧʔͷ਺͚ͩ࢓༷͕ଘࡏ͢Δͱ͍͏ͷ͕࣮৘: ‣ Oracleͷίʔυ͕͢΂ͯMySQLͰಈ͘Θ͚Ͱ͸ͳ͍ ‣ MySQLͷίʔυ͕͢΂ͯPostgreSQLͰಈ͘Θ͚Ͱ͸ͳ͍ SQL-92
79. Clichy/2010-02-03 • DBϝʔΧʔͷ਺͚ͩ࢓༷͕ଘࡏ͢Δͱ͍͏ͷ͕࣮৘: ‣ Oracleͷίʔυ͕͢΂ͯMySQLͰಈ͘Θ͚Ͱ͸ͳ͍ ‣ MySQLͷίʔυ͕͢΂ͯPostgreSQLͰಈ͘Θ͚Ͱ͸ͳ͍ ➡ Oracle, MySQL, PostgreSQL...Ͱಈ͍ͨίʔυ͕ͦͷ··Ͱ͸4DͰಈ͔ͳ͍͔΋͠Ε ͳ͍ʢͦͯ͜͠ΕΛόάͱݺͿ͜ͱ͸Ͱ͖ͳ͍ʣ SQL-92
80. 4D v11 SQL in Depth #1 • ΞʔΩςΫνϟʔ / εέʔϥϏϦςΟ • SQL vs 4D
81. 4D v11 SQL in Depth #1 • ΞʔΩςΫνϟʔ / εέʔϥϏϦςΟ • SQL vs 4D • Ωϟογϡ
82. Tokyo/2010-03-03/04 Ωϟογϡ • ओཁͳ໨త͸଎౓Ξοϓʢ4D: σʔλΞΫηεʣ
83. Tokyo/2010-03-03/04 Ωϟογϡ • ओཁͳ໨త͸଎౓Ξοϓʢ4D: σʔλΞΫηεʣ ‣ ྫ: ϨίʔυΛϩʔυ͢Δ - ॳճ͸σΟεΫ͔ΒಡΈࠐΈ: ΞΫηε͸ϛϦඵͷੈք
84. Tokyo/2010-03-03/04 Ωϟογϡ • ओཁͳ໨త͸଎౓Ξοϓʢ4D: σʔλΞΫηεʣ ‣ ྫ: ϨίʔυΛϩʔυ͢Δ - ॳճ͸σΟεΫ͔ΒಡΈࠐΈ: ΞΫηε͸ϛϦඵͷੈք - Ҏ߱͸Ωϟογϡ͔Β: ΞΫηε͸φϊඵͷੈք
85. Tokyo/2010-03-03/04 Ωϟογϡ • ओཁͳ໨త͸଎౓Ξοϓʢ4D: σʔλΞΫηεʣ ‣ ྫ: ϨίʔυΛϩʔυ͢Δ - ॳճ͸σΟεΫ͔ΒಡΈࠐΈ: ΞΫηε͸ϛϦඵͷੈք - Ҏ߱͸Ωϟογϡ͔Β: ΞΫηε͸φϊඵͷੈք 1,000,000 ഒߴ଎ ΋͠ 1 ns = 1 ඵͩͱ͢Ε͹, 1 ms = 11,5 ೔
86. Tokyo/2010-03-03/04 Ωϟογϡ • ओཁͳ໨త͸଎౓Ξοϓʢ4D: σʔλΞΫηεʣ ‣ ྫ: ϨίʔυΛϩʔυ͢Δ - ॳճ͸σΟεΫ͔ΒಡΈࠐΈ: ΞΫηε͸ϛϦඵͷੈք - Ҏ߱͸Ωϟογϡ͔Β: ΞΫηε͸φϊඵͷੈք
87. Tokyo/2010-03-03/04 Ωϟογϡ • ओཁͳ໨త͸଎౓Ξοϓʢ4D: σʔλΞΫηεʣ ‣ ྫ: ϨίʔυΛϩʔυ͢Δ - ॳճ͸σΟεΫ͔ΒಡΈࠐΈ: ΞΫηε͸ϛϦඵͷੈք - Ҏ߱͸Ωϟογϡ͔Β: ΞΫηε͸φϊඵͷੈք • Ωϟογϡʹऩೲ͞ΕΔ΋ͷ͸ ? - ςʔϒϧ, ϑΟʔϧυ, ϦϨʔγϣϯ, ΠϯσοΫεͳͲετϥΫνϟఆٛ৘ใ - ݱࡏͷσʔλϕʔεʹؔ͢Δશൠతͳ৘ใʢϑΝΠϧύε, ϓϩύςΟͳͲʣ - σʔλϑΝΠϧΞϩέʔγϣϯϏοτςʔϒϧ - Ϩίʔυ, ΠϯσοΫε, BLOBͷ௥Ճ৘ใ, ௥ՃϓϩύςΟͳͲ - ΠϯσοΫεϖʔδ - Ϩίʔυ - BLOBʢΩϟογϡʹॆ෼ͷεϖʔε͕ͳ͚Ε͹ϝΠϯϝϞϦʹߦ͘͜ͱ΋ʣ - ͦͷଞͷϓϩύςΟ - γʔέϯγϟϧφϯόʔ - τϥϯβΫγϣϯ - ηϨΫγϣϯ - ηοτ - ฒͼସ͑༻ͷҰ࣌తόοϑΝ, ઌಡΈ, σΟεΫॻ͖ࠐΈ༻όοϑΝͳͲ
88. Tokyo/2010-03-03/04 Ωϟογϡ
89. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB)
90. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ
91. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ
92. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ - ྫ #2: ηοτ͸খ͞ͳΦϒδΣΫτʹѹॖɾ෼ࢄ͞Ε͍ͯΔ
93. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ - ྫ #2: ηοτ͸খ͞ͳΦϒδΣΫτʹѹॖɾ෼ࢄ͞Ε͍ͯΔ • ͓͓͖͍ΦϒδΣΫτ͸ϢʔβʔΦϒδΣΫτ:
94. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ - ྫ #2: ηοτ͸খ͞ͳΦϒδΣΫτʹѹॖɾ෼ࢄ͞Ε͍ͯΔ • ͓͓͖͍ΦϒδΣΫτ͸ϢʔβʔΦϒδΣΫτ: ‣ BLOBɹ
95. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ - ྫ #2: ηοτ͸খ͞ͳΦϒδΣΫτʹѹॖɾ෼ࢄ͞Ε͍ͯΔ • ͓͓͖͍ΦϒδΣΫτ͸ϢʔβʔΦϒδΣΫτ: ‣ BLOBɹ ‣ ϐΫνϟ
96. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ - ྫ #2: ηοτ͸খ͞ͳΦϒδΣΫτʹѹॖɾ෼ࢄ͞Ε͍ͯΔ • ͓͓͖͍ΦϒδΣΫτ͸ϢʔβʔΦϒδΣΫτ: ‣ BLOBɹ ‣ ϐΫνϟ ‣ ςΩετ
97. Tokyo/2010-03-03/04 Ωϟογϡ • ΄ͱΜͲ͸খ͞ͳΦϒδΣΫτ: (<= 64 KB) ‣ ϑΝϛϦʔ͝ͱʹϦϯΫ͍ͯ͠ΔͨΊ - ྫ #1: ͋ΔςʔϒϧͷϨίʔυ100,000,000 ݅෼ͷΞυϨεͷϦετ͸ ෳ਺ͷΞυϨεςʔϒϧʹಡΈࠐ·ΕΔʢͦΕͧΕ͸ <= 64 KBʣ - ྫ #2: ηοτ͸খ͞ͳΦϒδΣΫτʹѹॖɾ෼ࢄ͞Ε͍ͯΔ • ͓͓͖͍ΦϒδΣΫτ͸ϢʔβʔΦϒδΣΫτ: ‣ BLOBɹ ‣ ϐΫνϟ ‣ ςΩετ ‣ ʢϨίʔυʣ «BLOBs»ͱ૯শ͢Δ
98. Tokyo/2010-03-03/04 Ωϟογϡ
99. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ
100. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ
101. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ
102. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ
103. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ • FLUSH BUFFERS
104. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ • FLUSH BUFFERS • «ԚΕͨ»ΦϒδΣΫτΛσΟεΫͷอଘ͢Δ͜ͱ
105. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ • FLUSH BUFFERS • «ԚΕͨ»ΦϒδΣΫτΛσΟεΫͷอଘ͢Δ͜ͱ • ͦͷޙ «ԚΕ͍ͯͳ͍»ͱ͍͏ҹ͕෇͚ΒΕΔ
106. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ • FLUSH BUFFERS • «ԚΕͨ»ΦϒδΣΫτΛσΟεΫͷอଘ͢Δ͜ͱ • ͦͷޙ «ԚΕ͍ͯͳ͍»ͱ͍͏ҹ͕෇͚ΒΕΔ • ͦΕʹΑΓ, ύʔδͯ͠΋ྑ͍ঢ়ଶʹͳΔ
107. Tokyo/2010-03-03/04 Ωϟογϡ • ελʔτΞοϓͰ֬อ͞ΕΔ • ΞϓϦέʔγϣϯ࣮ߦத, ॻ͖ࠐΈ, ύʔδ, ϑϥογϡ, ࠶഑ ஔ͕܁Γฦ͞ΕΔ • FLUSH BUFFERS • «ԚΕͨ»ΦϒδΣΫτΛσΟεΫͷอଘ͢Δ͜ͱ • ͦͷޙ «ԚΕ͍ͯͳ͍»ͱ͍͏ҹ͕෇͚ΒΕΔ • ͦΕʹΑΓ, ύʔδͯ͠΋ྑ͍ঢ়ଶʹͳΔ σΟεΫΞΫηε͸ϛϦඵͷੈք ෆඞཁʹFLUSH BUFFERSͯ͠͸͍͚ͳ͍
108. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ?
109. Tokyo/2010-03-03/04 Ωϟογϡ • ঢ়گ: - ϩʔυ͠ͳ͚Ε͹ͳΒͳ͍ΦϒδΣΫτ͕͋Δ: Ϩίʔυ,ΞυϨεςʔϒϧ, ... - ॆ෼ͳεϖʔ ε͕ͳ͍ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ?
110. Tokyo/2010-03-03/04 Ωϟογϡ • ঢ়گ: - ϩʔυ͠ͳ͚Ε͹ͳΒͳ͍ΦϒδΣΫτ͕͋Δ: Ϩίʔυ,ΞυϨεςʔϒϧ, ... - ॆ෼ͳεϖʔ ε͕ͳ͍ • ߦಈ: Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε
111. Tokyo/2010-03-03/04 Ωϟογϡ • ঢ়گ: - ϩʔυ͠ͳ͚Ε͹ͳΒͳ͍ΦϒδΣΫτ͕͋Δ: Ϩίʔυ,ΞυϨεςʔϒϧ, ... - ॆ෼ͳεϖʔ ε͕ͳ͍ • ߦಈ: Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε
112. Tokyo/2010-03-03/04 Ωϟογϡ • ঢ়گ: - ϩʔυ͠ͳ͚Ε͹ͳΒͳ͍ΦϒδΣΫτ͕͋Δ: Ϩίʔυ,ΞυϨεςʔϒϧ, ... - ॆ෼ͳεϖʔ ε͕ͳ͍ • ߦಈ: Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε
113. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ?
114. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ
115. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ
116. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
117. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ ϝϞϦΛΞϩέʔτ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
118. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ OK? ϝϞϦΛΞϩέʔτ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
119. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ OK? ϝϞϦΛΞϩέʔτ ͸͍ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
120. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ OK? ϝϞϦΛΞϩέʔτ FLUSH BUFFERS ͍͍͑ ͸͍ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
121. Tokyo/2010-03-03/04 Repeat Ωϟογϡͷ
     10%Λ
     ύʔδ ΦϒδΣΫτΛ
     Ξϩέʔτ Until ॆ෼ͷεϖʔ ε Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸ ? ֬อͨ͠Ωϟογϡ߹ܭͷ10% Ωϟογϡ͕1GBͷ৔߹,ΩϟογϡϚωʔ
     δϟʔ͸ 100MBύʔδ͠Α͏ͱ͢Δ ύʔδ OK? ϝϞϦΛΞϩέʔτ FLUSH BUFFERS ͍͍͑ ͸͍ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
122. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
123. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? • ϑϥογϡ͢Δ࠷ॳͷΦϒδΣΫτ·Ͱδϟϯϓ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
124. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? • ϑϥογϡ͢Δ࠷ॳͷΦϒδΣΫτ·Ͱδϟϯϓ ➡ Ωϟογϡ͕ઌʹϑϥογϡ͢ΔΦϒδΣΫτ͸͍ ͭ΋Ұॹͱ͸ݶΒͳ͍ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
125. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? • ϑϥογϡ͢Δ࠷ॳͷΦϒδΣΫτ·Ͱδϟϯϓ ➡ Ωϟογϡ͕ઌʹϑϥογϡ͢ΔΦϒδΣΫτ͸͍ ͭ΋Ұॹͱ͸ݶΒͳ͍ • σΟεΫͰͷۙ઀౓Λߟྀͯ͠࠷దͷϑϥογϡΛࢼΈΔ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
126. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
127. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? v11͸2004ΑΓ΋ܶతʹ଎͘ͳͬͨ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
128. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? v11͸2004ΑΓ΋ܶతʹ଎͘ͳͬͨ • 2004: ϋϯυϧ Mac ͱ࿈݁Ϧετ ➡ ΦϒδΣΫτ͸ಈ͍ͨ ➡ 4D͸ϦετશମΛͨͲΔඞཁ͕͋ͬͨ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
129. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? v11͸2004ΑΓ΋ܶతʹ଎͘ͳͬͨ • 2004: ϋϯυϧ Mac ͱ࿈݁Ϧετ ➡ ΦϒδΣΫτ͸ಈ͍ͨ ➡ 4D͸ϦετશମΛͨͲΔඞཁ͕͋ͬͨ • V11: ϙΠϯλͱҰछͷΞυϨεςʔϒϧ ➡ ΦϒδΣΫτ͸ಈ͔ͳ͍ ➡ ࠷େ
     3 ΞΫηεͰΦϒδΣΫτʹ౸ୡ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
130. Tokyo/2010-03-03/04 Ωϟογϡ Ωϟογϡ͕ϝϞϦΛඞཁͱ͢Δͱ͖͸
     ? v11͸2004ΑΓ΋ܶతʹ଎͘ͳͬͨ • 2004: ϋϯυϧ Mac ͱ࿈݁Ϧετ ➡ ΦϒδΣΫτ͸ಈ͍ͨ ➡ 4D͸ϦετશମΛͨͲΔඞཁ͕͋ͬͨ • V11: ϙΠϯλͱҰछͷΞυϨεςʔϒϧ ➡ ΦϒδΣΫτ͸ಈ͔ͳ͍ ➡ ࠷େ
     3 ΞΫηεͰΦϒδΣΫτʹ౸ୡ v11ͷ৽͍͠ΩϟογϡϝϞϦϚωʔδϟʔͷ͓͔͛ ԚΕ͍ͯͳ͍ΦϒδΣΫτΛύʔδ
131. Tokyo/2010-03-03/04 Ωϟογϡ • 4D 32 Ϗοτ ࠷େαΠζ͸
     ?
132. Tokyo/2010-03-03/04 Ωϟογϡ • 4D 32 Ϗοτ ➡ ࠷େ 2.5 GB ➡ OS 32/64 ʹؔ܎ͳ͘ ‣ ϋʔυίʔυ͞Εͨ஋ ‣ Ϣʔβʔ͕
     > 2.5 Λઃఆͨ͠৔߹͸Լํमਖ਼ ࠷େαΠζ͸
     ?
133. Tokyo/2010-03-03/04 Ωϟογϡ • 4D 32 Ϗοτ ➡ ࠷େ 2.5 GB ➡ OS 32/64 ʹؔ܎ͳ͘ ‣ ϋʔυίʔυ͞Εͨ஋ ‣ Ϣʔβʔ͕
     > 2.5 Λઃఆͨ͠৔߹͸Լํमਖ਼ • 4D 64 Ϗοτ 4D Server v12ͷΈ ࠷େαΠζ͸
     ?
134. Tokyo/2010-03-03/04 Ωϟογϡ • 4D 32 Ϗοτ ➡ ࠷େ 2.5 GB ➡ OS 32/64 ʹؔ܎ͳ͘ ‣ ϋʔυίʔυ͞Εͨ஋ ‣ Ϣʔβʔ͕
     > 2.5 Λઃఆͨ͠৔߹͸Լํमਖ਼ • 4D 64 Ϗοτ 4D Server v12ͷΈ ➡ «੍ݶͳ͠» ࠷େαΠζ͸
     ?
135. 4D v11 SQL in Depth #2
136. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ
137. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 4D Server ϓϦΤϯϓςΟϒ ίΦϖϥςΟϒ 19813 19814 ϓϩηε U1-1 Req1... ORDER BY (Table1) R2…⋯ R3 Ϣʔβʔ 1 ϓϩηε U1-1 ϓϩηε U1-1
138. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3
139. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3
140. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3
141. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου
142. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ
143. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ
144. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ
145. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ
146. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ
147. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ
148. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ (*) τϦΨͷςʔϒϧͷΈ (*)
149. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ 44 ίΦϖϥςΟϒ ϓϩηε U1-1 ϓϩηε U1-1 Req1... R2…⋯ R3 ίΦϖϥςΟϒπΠϯϓϩηε͕࢖༻͢Δ΋ͷ: - τϦΨ - “αʔόʔͰ࣮ߦ” ϓϩύςΟ͕༗ޮʹ͞Εͨϝιου “αʔόʔͰ࣮ߦ” τϦΨ τϥϯβΫγϣϯεςʔτ ϨίʔυϩοΩϯά ϓϩηεηοτ ϓϩηε໋໊ηϨΫγϣϯ ΧϨϯτηϨΫγϣϯ ΧϨϯτϨίʔυ (*) τϦΨͷςʔϒϧͷΈ (*)
150. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ • ྫ: ϦϨʔτηϨΫγϣϯͷsumΛτϦΨͰܭࢉ ‣ ΫϥΠΞϯταΠυ: . . . QUERY([OrderLines];[OrderLines]_OrderID=[Order]ID) SAVE RECORD([Order]) . . . ‣ αʔόʔαΠυ («On save existing record») [Order]Total:=Sum([OrderLines]Price)
151. Tokyo/2010-03-03/04 σʔλϕʔ είϯςΩετ • ྫ: ϦϨʔτηϨΫγϣϯͷsumΛτϦΨͰܭࢉ ‣ ΫϥΠΞϯταΠυ: . . . QUERY([OrderLines];[OrderLines]_OrderID=[Order]ID) SAVE RECORD([Order]) . . . ‣ αʔόʔαΠυ («On save existing record») [Order]Total:=Sum([OrderLines]Price) [OrderLines] ͷηϨΫγϣϯ͸ۭ
152. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ)
153. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ) • ΫϥΠΞϯταʔόʔ: : ‣ ηϨΫγϣϯͱΧϨϯτϨίʔυ (ΧϨϯτςʔϒϧͷϨίʔυҎ֎) ‣ ΫϥΠΞϯτͱಉظ͕औΒΕ͍ͯͳ͍ => ࠶ݱ͢Δඞཁ͕͋Δ ≠ 2004
154. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ) • ΫϥΠΞϯταʔόʔ: : ‣ ηϨΫγϣϯͱΧϨϯτϨίʔυ (ΧϨϯτςʔϒϧͷϨίʔυҎ֎) ‣ ΫϥΠΞϯτͱಉظ͕औΒΕ͍ͯͳ͍ => ࠶ݱ͢Δඞཁ͕͋Δ ϓϩηεηοτ,ϓϩηε໋໊ηϨΫγϣϯ,ϨίʔυϩοΩϯά,τϥϯβΫ ≠ 2004
155. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ) • ΫϥΠΞϯταʔόʔ: : ‣ ηϨΫγϣϯͱΧϨϯτϨίʔυ (ΧϨϯτςʔϒϧͷϨίʔυҎ֎) ‣ ΫϥΠΞϯτͱಉظ͕औΒΕ͍ͯͳ͍ => ࠶ݱ͢Δඞཁ͕͋Δ ϓϩηεηοτ,ϓϩηε໋໊ηϨΫγϣϯ,ϨίʔυϩοΩϯά,τϥϯβΫ γϣϯεςʔτ͸ಉظ͕ͱΒΕ͍ͯΔ ≠ 2004
156. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ) • ΫϥΠΞϯταʔόʔ: : ‣ ηϨΫγϣϯͱΧϨϯτϨίʔυ (ΧϨϯτςʔϒϧͷϨίʔυҎ֎) ‣ ΫϥΠΞϯτͱಉظ͕औΒΕ͍ͯͳ͍ => ࠶ݱ͢Δඞཁ͕͋Δ ϓϩηεηοτ,ϓϩηε໋໊ηϨΫγϣϯ,ϨίʔυϩοΩϯά,τϥϯβΫ γϣϯεςʔτ͸ಉظ͕ͱΒΕ͍ͯΔ • ෳ਺͕ “ಉ࣌ʹ૸Δ” (ίΦϖϥςΟϒεϨουͷϓʔϧͷதͰ) • ੍ݶ ≠ 2004
157. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ) • ΫϥΠΞϯταʔόʔ: : ‣ ηϨΫγϣϯͱΧϨϯτϨίʔυ (ΧϨϯτςʔϒϧͷϨίʔυҎ֎) ‣ ΫϥΠΞϯτͱಉظ͕औΒΕ͍ͯͳ͍ => ࠶ݱ͢Δඞཁ͕͋Δ ϓϩηεηοτ,ϓϩηε໋໊ηϨΫγϣϯ,ϨίʔυϩοΩϯά,τϥϯβΫ γϣϯεςʔτ͸ಉظ͕ͱΒΕ͍ͯΔ • ෳ਺͕ “ಉ࣌ʹ૸Δ” (ίΦϖϥςΟϒεϨουͷϓʔϧͷதͰ) • ੍ݶ ‣ ίΦϖϥςΟϒ લड़ͷͱ͓Γ ≠ 2004
158. Tokyo/2010-03-03/04 τϦΨ • (ಛੑͱ໨తΛߟྀ͢Δ) • ΫϥΠΞϯταʔόʔ: : ‣ ηϨΫγϣϯͱΧϨϯτϨίʔυ (ΧϨϯτςʔϒϧͷϨίʔυҎ֎) ‣ ΫϥΠΞϯτͱಉظ͕औΒΕ͍ͯͳ͍ => ࠶ݱ͢Δඞཁ͕͋Δ ϓϩηεηοτ,ϓϩηε໋໊ηϨΫγϣϯ,ϨίʔυϩοΩϯά,τϥϯβΫ γϣϯεςʔτ͸ಉظ͕ͱΒΕ͍ͯΔ • ෳ਺͕ “ಉ࣌ʹ૸Δ” (ίΦϖϥςΟϒεϨουͷϓʔϧͷதͰ) • ੍ݶ ‣ ίΦϖϥςΟϒ લड़ͷͱ͓Γ ‣ ࠷୹ͷ࣌ؒͰऴྃ͠ͳ͚Ε͹ͳΒͳ͍= ൚༻తͰͳ͍ ≠ 2004
159. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ
160. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ • εέδϡʔϥʔΛཧղ͢Δ
161. Tokyo/2010-03-03/04 εέδϡʔϥʔ • εέδϡʔϥʔͷ໨త ? • ͳͥv11ʹͳͬͯ΋εέδϡʔϥʔ͕ඞཁͳͷ͔ ?
162. Tokyo/2010-03-03/04 εέδϡʔϥʔ • εέδϡʔϥʔͷ໨త ? • ͳͥv11ʹͳͬͯ΋εέδϡʔϥʔ͕ඞཁͳͷ͔ ? ‣ 4Dϥϯήʔδ͸εϨουηʔ ϑͰ͸ͳ͍͔Β
163. Tokyo/2010-03-03/04 εέδϡʔϥʔ • εέδϡʔϥʔͷ໨త ? • ͳͥv11ʹͳͬͯ΋εέδϡʔϥʔ͕ඞཁͳͷ͔ ? ‣ 4Dϥϯήʔδ͸εϨουηʔ ϑͰ͸ͳ͍͔Β • εέδϡʔϥʔͷٖࣅίʔυ: For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
164. Tokyo/2010-03-03/04 εέδϡʔϥʔ For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
165. Tokyo/2010-03-03/04 εέδϡʔϥʔ • 4D͸֤ϓϩηε1 tickͷపఈΛࢼΈΔ For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
166. Tokyo/2010-03-03/04 εέδϡʔϥʔ • 4D͸֤ϓϩηε1 tickͷపఈΛࢼΈΔ • εέδϡʔϥʔʹ੍ޚΛฦ͞ͳ͍ϓϩηε͸ଞ͢΂ ͯΛ๦֐͢ΔʢϢʔβʔΠϯλϑΣʔ ε΋ !ʣ: For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
167. Tokyo/2010-03-03/04 εέδϡʔϥʔ • 4D͸֤ϓϩηε1 tickͷపఈΛࢼΈΔ • εέδϡʔϥʔʹ੍ޚΛฦ͞ͳ͍ϓϩηε͸ଞ͢΂ ͯΛ๦֐͢ΔʢϢʔβʔΠϯλϑΣʔ ε΋ !ʣ: ‣ ΠϯλϓϦλϞʔυͰ͸େৎ෉ For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
168. Tokyo/2010-03-03/04 εέδϡʔϥʔ • 4D͸֤ϓϩηε1 tickͷపఈΛࢼΈΔ • εέδϡʔϥʔʹ੍ޚΛฦ͞ͳ͍ϓϩηε͸ଞ͢΂ ͯΛ๦֐͢ΔʢϢʔβʔΠϯλϑΣʔ ε΋ !ʣ: ‣ ΠϯλϓϦλϞʔυͰ͸େৎ෉ ‣ ίϯύΠϧϞʔυͰ͸ى͜ΓಘΔʢయܕతͳ ྫ͸IDLEΛίʔϧ͠ͳ͍ߴີ౓ϧʔ ϓʣ For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
169. Tokyo/2010-03-03/04 εέδϡʔϥʔ • 4D͸֤ϓϩηε1 tickͷపఈΛࢼΈΔ • εέδϡʔϥʔʹ੍ޚΛฦ͞ͳ͍ϓϩηε͸ଞ͢΂ ͯΛ๦֐͢ΔʢϢʔβʔΠϯλϑΣʔ ε΋ !ʣ: ‣ ΠϯλϓϦλϞʔυͰ͸େৎ෉ ‣ ίϯύΠϧϞʔυͰ͸ى͜ΓಘΔʢయܕతͳ ྫ͸IDLEΛίʔϧ͠ͳ͍ߴີ౓ϧʔ ϓʣ ‣ ϓϥάΠϯ͸ PA_Yield() ͋Δ͍͸ PA_PieldAbsolute()Λίʔϧ͢Δ΂͖ For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
170. Tokyo/2010-03-03/04 εέδϡʔϥʔ ࣮ࡍʹ͸
171. Tokyo/2010-03-03/04 1.ΠϕϯτΛνΣοΫʢϚ΢ε, ΩʔϘʔυ, ...ʣ ➡ ద੾ͳ4Dϓϩηεʹ఻ୡ͢Δ 2.ͦͷޙ, ΞΫςΟϒϓϩηεʹ1 tickͣͭͷϧʔ ϓʹಥೖ εέδϡʔϥʔ ࣮ࡍʹ͸ For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
172. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
173. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while For 1͔Βϓϩηε਺·Ͱ If ϓϩηε͕஗Ԇ͋Δ͍͸ఀࢭ͞Ε͍ͯͳ͚Ε͹ ͦͷίʔυΛ 1 tick ࣮ߦ͢Δ(16 ms)
174. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
175. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
176. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
177. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while SET DATABASE PARAMETER 4D Server Scheduler 4D Remote Scheduler 4D Local Mode Scheduler
178. Tokyo/2010-03-03/04 εέδϡʔϥʔ σϑΥϧτ஋
179. Tokyo/2010-03-03/04 εέδϡʔϥʔ σϑΥϧτ஋ λΠϜΞ΢τ_࠷୹ λΠϜΞ΢τ_࠷௕ νΣοΫ_ִؒ 4DΛ࠷ߴʹ 0 1 5 4DΛඪ४ʹ 0 8 0 4DΛ࠷௿ʹ 1 16 0
180. Tokyo/2010-03-03/04 εέδϡʔϥʔ While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If νΣοΫ_ִؒ ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = λΠϜΞ΢τ_࠷୹ Else λΠϜΞ΢τ = λΠϜΞ΢τ_࠷௕ End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
181. Tokyo/2010-03-03/04 εέδϡʔϥʔ: 4DΛ࠷ߴʹ While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If 5 ticks ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = 0 tick Else λΠϜΞ΢τ = 1 ticks End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
182. Tokyo/2010-03-03/04 εέδϡʔϥʔ: 4DΛඪ४ʹ While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If 0 ticks ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = 0 tick Else λΠϜΞ΢τ = 8 ticks End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while
183. Tokyo/2010-03-03/04 While 4D ࣮ߦத // γεςϜΠϕϯτΛॲཧ Repeat If 0 ticks ͕ܦաͨ͠ If 4D͸ϏδʔͰ͋Δ λΠϜΞ΢τ = 1 tick Else λΠϜΞ΢τ = 16 ticks End if // ͜͜ͰγεςϜʹ੍ޚΛฦ͢ Get Πϕϯτ͋Δ͍͸ λΠϜΞ΢τ ·Ͱ଴ػ If Πϕϯτ͸4Dϓϩηεʹؔ܎ Pass ΠϕϯτΛϓϩηεʹ఻ୡ End if End if Until Πϕϯτ͕ͳ͍ // ͦΕͧΕͷ4Dϓϩηεʹ࣌ؒΛ༩͑Δ For 4D ϓϩηεͦΕͧΕʹ͖ͭ Give ࠷௿ 1 tick ΞΫςΟϒϓϩηεΛ࣮ߦ End while εέδϡʔϥʔ: 4DΛ࠷௿ʹ
184. Tokyo/2010-03-03/04 εέδϡʔϥʔ • SET DATABASE PARAMETERʢείʔ ϓ;஋ʣ νϡʔχϯά
185. Tokyo/2010-03-03/04 εέδϡʔϥʔ • SET DATABASE PARAMETERʢείʔ ϓ;஋ʣ ‣ είʔ ϓ: - 4D Server εέδϡʔϥʔ - 4D Remote εέδϡʔϥʔ - 4D Local Mode εέδϡʔϥʔ νϡʔχϯά
186. Tokyo/2010-03-03/04 εέδϡʔϥʔ • SET DATABASE PARAMETERʢείʔ ϓ;஋ʣ ‣ είʔ ϓ: - 4D Server εέδϡʔϥʔ - 4D Remote εέδϡʔϥʔ - 4D Local Mode εέδϡʔϥʔ ‣ ஋: - 16ਐ਺Ͱදه: 0x00mmMMBB ‣ λΠϜΞ΢τ_࠷୹: 0 ͔Β 100 (0x00 ͔Β 0x64) ‣ λΠϜΞ΢τ_࠷௕: 0 ͔Β 100 (0x00 ͔Β 0x64) ‣ νΣοΫ_ִؒ: 0 ͔Β 20 (0x00 ͔Β 0x14) νϡʔχϯά
187. Tokyo/2010-03-03/04 εέδϡʔϥʔ • SET DATABASE PARAMETERʢείʔ ϓ;஋ʣ ‣ είʔ ϓ: - 4D Server εέδϡʔϥʔ - 4D Remote εέδϡʔϥʔ - 4D Local Mode εέδϡʔϥʔ ‣ ஋: - 16ਐ਺Ͱදه: 0x00mmMMBB ‣ λΠϜΞ΢τ_࠷୹: 0 ͔Β 100 (0x00 ͔Β 0x64) ‣ λΠϜΞ΢τ_࠷௕: 0 ͔Β 100 (0x00 ͔Β 0x64) ‣ νΣοΫ_ִؒ: 0 ͔Β 20 (0x00 ͔Β 0x14) - σϑΥϧτ஋: -1ʢ࠷ߴ/ӈʣ-2ʢඪ४/தԝʣ-3ʢ࠷௿/ࠨʣ νϡʔχϯά
188. Tokyo/2010-03-03/04 εέδϡʔϥʔ • SET DATABASE PARAMETERʢείʔ ϓ;஋ʣ ‣ είʔ ϓ: - 4D Server εέδϡʔϥʔ - 4D Remote εέδϡʔϥʔ - 4D Local Mode εέδϡʔϥʔ ‣ ஋: - 16ਐ਺Ͱදه: 0x00mmMMBB ‣ λΠϜΞ΢τ_࠷୹: 0 ͔Β 100 (0x00 ͔Β 0x64) ‣ λΠϜΞ΢τ_࠷௕: 0 ͔Β 100 (0x00 ͔Β 0x64) ‣ νΣοΫ_ִؒ: 0 ͔Β 20 (0x00 ͔Β 0x14) - σϑΥϧτ஋: -1ʢ࠷ߴ/ӈʣ-2ʢඪ४/தԝʣ-3ʢ࠷௿/ࠨʣ • ࣮ߦதͷΤϯδϯʹϩʔΧϧͷ஋,อଘ͞Εͳ͍ νϡʔχϯά
189. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ • εέδϡʔϥʔΛཧղ͢Δ
190. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ • εέδϡʔϥʔΛཧղ͢Δ • ελοΫʢϝϞϦʣ
191. Tokyo/2010-03-03/04 ελοΫͱ͸ ? • ϝϞϦͷྖҬ
192. Tokyo/2010-03-03/04 ελοΫͱ͸ ? • ϝϞϦͷྖҬ • ίʔυͷ࣮ߦʹෆՄܽͳ «ΦϒδΣΫτ» Λऩ༰
193. Tokyo/2010-03-03/04 ελοΫͱ͸ ? • ϝϞϦͷྖҬ • ίʔυͷ࣮ߦʹෆՄܽͳ «ΦϒδΣΫτ» Λऩ༰ • LIFOελοΫ: ‣ ฦΓ஋͕ऩ༰͞ΕΔ৔ॴ ‣ ύϥϝʔλʔ ‣ ϩʔΧϧม਺ ‣ ʢαϒϧʔνϯຖʣ
194. Tokyo/2010-03-03/04 ελοΫͷαΠζ ϓϦΤϯϓςΟϒ εϨου: σϑΥϧταΠζ
195. Tokyo/2010-03-03/04 ελοΫͷαΠζ ϓϦΤϯϓςΟϒ εϨου: σϑΥϧταΠζ OS αΠζ Windows 1 MB Leopard 512 KB Snow Leopard 1 MB
196. Tokyo/2010-03-03/04 ελοΫͷαΠζ ϓϦΤϯϓςΟϒ εϨου: σϑΥϧταΠζ OS αΠζ Windows 1 MB Leopard 512 KB Snow Leopard 1 MB • DB4D αʔόʔ • SQL ωοτηογϣϯϚωʔδϟʔ • SQL ωοτίωΫγϣϯ • ༧උ SQL • ΫϥΠΞϯτάϩʔόϧϓϩηεͷϓϦΤϯϓςΟ ϒπΠϯ
197. Tokyo/2010-03-03/04 ελοΫͷαΠζ ϓϦΤϯϓςΟϒ εϨου: σϑΥϧταΠζ OS αΠζ Windows 1 MB Leopard 512 KB Snow Leopard 1 MB • DB4D αʔόʔ • SQL ωοτηογϣϯϚωʔδϟʔ • SQL ωοτίωΫγϣϯ • ༧උ SQL • ΫϥΠΞϯτάϩʔόϧϓϩηεͷϓϦΤϯϓςΟ ϒπΠϯ GET/SET DATABASE PARAMETER(53;όΠτ਺)
198. Tokyo/2010-03-03/04 ελοΫͷαΠζ ϓϦΤϯϓςΟϒεϨου: ϋʔυίʔυ஋ ➡ ϑϥογϡϚωʔδϟʔ (512 KB) ➡ ΠϯσοΫεϏϧμʔ (512 KB)
199. Tokyo/2010-03-03/04 ελοΫͷαΠζ ίΦϖϥςΟϒεϨου
200. Tokyo/2010-03-03/04 ελοΫͷαΠζ • 4DίʔυΛ࣮ߦ͢ΔͨΊ • ىݯ: ‣ ϥϯήʔδ - New process / Execute on server - ࣗಈ ‣ Web/SOAP αʔόʔϓϩηε ‣ ϝχϡʔΞΠςϜͷϓϩύςΟ, ... ‣ On exit σʔλϕʔεϝιου ‣ ಺෦ίʔυ - ϥϯλΠϜΤΫεϓϩʔϥʔ, ϦϞʔτ؅ཧը໘, SQL ϓϩηε, ... ίΦϖϥςΟϒεϨου
201. Tokyo/2010-03-03/04 ελοΫͷαΠζ • ࠷ऴతʹ഑෼͞ΕΔ஋͸ৗʹ૿ྔ͞Ε͍ͯΔ ίΦϖϥςΟϒεϨου
202. Tokyo/2010-03-03/04 ελοΫͷαΠζ • ࠷ऴతʹ഑෼͞ΕΔ஋͸ৗʹ૿ྔ͞Ε͍ͯΔ ‣ Windows - realSize = requested + 40 KB ‣ Mac - realSize = requested + (requested / 2) + 128 KB ίΦϖϥςΟϒεϨου
203. Tokyo/2010-03-03/04 ελοΫͷαΠζ • ࠷ऴతʹ഑෼͞ΕΔ஋͸ৗʹ૿ྔ͞Ε͍ͯΔ ‣ Windows - realSize = requested + 40 KB ‣ Mac - realSize = requested + (requested / 2) + 128 KB • 512 KBཁٻͨ͠৔߹, ഑෼͞ΕΔͷ͸: ‣ Windows Ͱ͸ 552 KB ‣ Mac Ͱ͸ 896 KB ίΦϖϥςΟϒεϨου
204. Tokyo/2010-03-03/04 ελοΫͷαΠζ ίΦϖϥςΟϒεϨου New process() ͱελοΫ New process() ͱελοΫ New process() ͱελοΫ New process() ͱελοΫ ཁٻ஋ (rs) ϓϥοτϑΥ ʔϜ ࠶ఆٛ ഑෼஋ 0 Windows 512 KB 552 KB 0 Mac 512 KB 896 KB > 0 ͓Αͼ < 16 KB Windows 16 KB 56 KB > 0 ͓Αͼ < 16 KB Mac 16 KB 152 KB > 16 KB Windows มߋͳ͠ rs + 40 KB > 16 KB Mac OS มߋͳ͠ rs + (rs/2) + 128 KB < 0 Windows Mac มߋͳ͠ rs + 40 KB rs + (rs/2) + 128 KB ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ
205. Tokyo/2010-03-03/04 ελοΫͷαΠζ ίΦϖϥςΟϒεϨου New process() ͱελοΫ New process() ͱελοΫ New process() ͱελοΫ New process() ͱελοΫ ཁٻ஋ (rs) ϓϥοτϑΥ ʔϜ ࠶ఆٛ ഑෼஋ 0 Windows 512 KB 552 KB 0 Mac 512 KB 896 KB > 0 ͓Αͼ < 16 KB Windows 16 KB 56 KB > 0 ͓Αͼ < 16 KB Mac 16 KB 152 KB > 16 KB Windows มߋͳ͠ rs + 40 KB > 16 KB Mac OS มߋͳ͠ rs + (rs/2) + 128 KB < 0 Windows Mac มߋͳ͠ rs + 40 KB rs + (rs/2) + 128 KB ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ ઈରʹμϝ. ྫ͑͹, -128*1024 Λཁٻͨ͠৔߹, 4D͸4GBΛ഑෼͠Α͏ͱͯ͠͠· ͏ʢූ߸͖ͭ/ූ߸ͳ͠ͷม׵ʣ Execute on serverʹ-1͸New processʹ0ͱಉ͡
206. Tokyo/2010-03-03/04 ελοΫͷαΠζ ίΦϖϥςΟϒεϨου
207. Tokyo/2010-03-03/04 ελοΫͷαΠζ • σϑΥϧτ஋: ‣ '4STK' Ϧιʔ ε ίΦϖϥςΟϒεϨου ID ໊শ ஋ 1 On event call 512 KB 2 On serial port call 512 KB 3 Exec on server, on client, ϝιου࣮ߦ, ϚΫϩ 512 KB 4 ϝχϡʔ৽ϓϩηε 512 KB 5 αʔόʔλεΫ 256 KB 6 چɾόοΫΞοϓ 512 KB 7 چɾ෮ݩ 512 KB 8 Web 256 KB 9 Server event loop, cache, runtime explorer 512 KB 10 ΞοϓϧΠϕϯτ 512 KB
208. Tokyo/2010-03-03/04 ελοΫͷαΠζ • σϑΥϧτ஋: ‣ '4STK' Ϧιʔ ε ίΦϖϥςΟϒεϨου ID ໊শ ஋ 1 On event call 512 KB 2 On serial port call 512 KB 3 Exec on server, on client, ϝιου࣮ߦ, ϚΫϩ 512 KB 4 ϝχϡʔ৽ϓϩηε 512 KB 5 αʔόʔλεΫ 256 KB 6 چɾόοΫΞοϓ 512 KB 7 چɾ෮ݩ 512 KB 8 Web 256 KB 9 Server event loop, cache, runtime explorer 512 KB 10 ΞοϓϧΠϕϯτ 512 KB ΫϥΠΞϯτάϩʔόϧϓϩηε ͷαʔόʔίΦϖϥςΟϒπΠϯ
209. Tokyo/2010-03-03/04 ελοΫͷαΠζ • σϑΥϧτ஋: ‣ '4STK' Ϧιʔ ε ίΦϖϥςΟϒεϨου ID ໊শ ஋ 1 On event call 512 KB 2 On serial port call 512 KB 3 Exec on server, on client, ϝιου࣮ߦ, ϚΫϩ 512 KB 4 ϝχϡʔ৽ϓϩηε 512 KB 5 αʔόʔλεΫ 256 KB 6 چɾόοΫΞοϓ 512 KB 7 چɾ෮ݩ 512 KB 8 Web 256 KB 9 Server event loop, cache, runtime explorer 512 KB 10 ΞοϓϧΠϕϯτ 512 KB ΫϥΠΞϯτάϩʔόϧϓϩηε ͷαʔόʔίΦϖϥςΟϒπΠϯ ࣮ࡍͷ஋ 552-896 KB 552-896 KB 552-896 KB 552-896 KB 296-512 KB 552-896 KB 552-896 KB 296-512 KB 552-896 KB 552-896 KB
210. Tokyo/2010-03-03/04 4D Server Operating System Cooperatives Preemptives Core 1 Core 2 Core 3 Core 4 Scheduler
211. Tokyo/2010-03-03/04 4D Server Operating System Cooperatives Preemptives Core 1 Core 2 Core 3 Core 4 Scheduler 100 ΫϥΠΞϯτ - 2 άϩʔόϧϓϩηε / ΫϥΠΞϯτ ɹ αʔόʔͷπΠϯεϨου͕઎༗͢ΔϝϞϦͷαΠζ͸?
212. Tokyo/2010-03-03/04 4D Server Operating System Cooperatives Preemptives Core 1 Core 2 Core 3 Core 4 Scheduler 100 ΫϥΠΞϯτ - 2 άϩʔόϧϓϩηε / ΫϥΠΞϯτ ɹ αʔόʔͷπΠϯεϨου͕઎༗͢ΔϝϞϦͷαΠζ͸? 258 MB (W) 300 MB (SL) 200 MB (L)
213. Tokyo/2010-03-03/04 4D Server Operating System Cooperatives Preemptives Core 1 Core 2 Core 3 Core 4 Scheduler 100 ΫϥΠΞϯτ - 2 άϩʔόϧϓϩηε / ΫϥΠΞϯτ «Begin SQL» Λ֤ϓϩηεͰ࣮ߦͨ͠৔߹ αʔόʔͷπΠϯεϨου͕઎༗͢ΔϝϞϦͷαΠζ͸?
214. Tokyo/2010-03-03/04 4D Server Operating System Cooperatives Preemptives Core 1 Core 2 Core 3 Core 4 Scheduler 100 ΫϥΠΞϯτ - 2 άϩʔόϧϓϩηε / ΫϥΠΞϯτ «Begin SQL» Λ֤ϓϩηεͰ࣮ߦͨ͠৔߹ αʔόʔͷπΠϯεϨου͕઎༗͢ΔϝϞϦͷαΠζ͸?
215. Tokyo/2010-03-03/04 4D Server Operating System Cooperatives Preemptives Core 1 Core 2 Core 3 Core 4 Scheduler 100 ΫϥΠΞϯτ - 2 άϩʔόϧϓϩηε / ΫϥΠΞϯτ «Begin SQL» Λ֤ϓϩηεͰ࣮ߦͨ͠৔߹ αʔόʔͷπΠϯεϨου͕઎༗͢ΔϝϞϦͷαΠζ͸? 458 MB (W) 500 MB (SL) 300 MB (L)
216. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ • εέδϡʔϥʔΛཧղ͢Δ • ελοΫʢϝϞϦʣ
217. 4D v11 SQL in Depth #2 • σʔλϕʔείϯςΩετʢτϦΨ, ...ʣ • εέδϡʔϥʔΛཧղ͢Δ • ελοΫʢϝϞϦʣ • ύϥμΠϜγϑτ
218. Tokyo/2010-03-03/04 ഇࢭ༧ఆ
219. Tokyo/2010-03-03/04 ഇࢭ༧ఆ • 4D஀ੜ͔Β25೥͕ܦա !
220. Tokyo/2010-03-03/04 ഇࢭ༧ఆ • 4D஀ੜ͔Β25೥͕ܦա ! • ͜ͷؒʹछʑͷίϯηϓτ͸ਐԽͨ͠ • OS͕มΘͬͨ, ͜Ε͔Β΋มΘΓଓ͚Δ ‣ 68k, PPC, x86, 64Bits ‣ OS9, OSX, Carbon, Cocoa • 4Dίʔυͷޓ׵ੑ͕ࣦΘΕͯ͸͍͚ͳ͍ • ͔͠͠, ͦ͏͸͍ͬͯ΋...
221. Tokyo/2010-03-03/04 4D Draw
222. Tokyo/2010-03-03/04 4D Draw • QuickDrawΛ࢖༻͍ͯ͠Δ • AlturaͰΤϛϡϨʔγϣϯ • ࠲ඪܥʹ੔਺Λ࢖༻, ϑΥϯτ൪߸, ໛༷ύλʔϯ, ... • ݱߦͷը૾ܗ͕ࣜ։͚ͳ͍, ಠࣗͷϑΥʔϚοτΛ࢖༻ • 4D DrawจॻΛ4Dͷ֎෦Ͱฤू͢Δज़͕ͳ͍
223. Tokyo/2010-03-03/04 SVG
224. Tokyo/2010-03-03/04 SVG • CoreGraphics & CoreText, GDI+Λ࢖༻ • ඪ४ςΩετܗࣜ (xml) • ߴ౓ͳΤϑΣΫτ: άϥσʔγϣϯ, ಁ໌౓, ϨΠϠʔ, ճస, มܗ, ૊ΈࠐΈ,... • 4DϐΫνϟૢ࡞ίϚϯυ͸͢΂ͯͦͷ··࢖༻Ͱ͖Δ • ϑΥʔϜΦϒδΣΫτͱͯ͠දࣔ΍ૢ࡞΋Ͱ͖Δ ‣ MiniDraw (v12) • ݄̍, SVGϫʔΩϯάάϧʔ ϓʹIEνʔϜ͕Ճೖ !
225. Tokyo/2010-03-03/04 4D Open
226. Tokyo/2010-03-03/04 4D Open • 4D Open͸4D v11Ͱ΋ಈ࡞͢Δ ‣ ͨͩ͠ΠϯλϓϦλϞʔυͷΈ • ͞·͟·ͳํ๏Ͱஔ͖׵͑ΒΕΔ: ‣ HTTP - DOM Parse XML source( «http://site.com») ‣ WebαʔϏε ‣ SQLύεεϧʔ ‣ ෳ੡ͱಉظ (v12)
227. Tokyo/2010-03-03/04 PICT
228. Tokyo/2010-03-03/04 PICT • 4D͸WindowsͰ΋ը૾ΛPICTͰอଘ͍ͯͨ͠ • 4D v11͸PICT͕౉͞Εͨͱ͖͚ͩPICTΛ࢖༻͢Δ • Apple͸PICTϑΥʔϚοτΛഇࢭ͢Δ༧ఆ • 4D͸AppleʹཔͬͯMacͰPICTΛղಡ͍ͯ͠Δ • 4D͸Altura·ͨ͸QuickTimeʹཔͬͯWindowsͰ PICTΛղಡ͍ͯ͠Δ • CONVERT PICTUREΛਪ঑ • BLOB TO PICTURE( «.4dblob»)
229. Tokyo/2010-03-03/04 uickTime
230. Tokyo/2010-03-03/04 uickTime • QuickTime ͸͍·΍ಈըॲཧʹ஫ྗ͍ͯ͠Δٕज़ • 4D v11͸QuickTimeΛ΋͸΍ඞཁͱ͸͠ͳ͍ • 4D v12͸ImageIO͓Αͼ Windows Imaging Component (WIC) Λαϙʔτ • QuickTimeΛ࢖༻͢ΔίϚϯυ͸4D v12Ͱ͢΂ͯ઀಄ ࣙ‘QT’͕෇͖, ഇࢭ༧ఆʹ ‣ QT COMPRESS PICTURE ‣ QT LOAD COMPRESSED PICTURE FROM FILE ‣ QT COMPRESS PICTURE FILE ‣ CONVERT PICTURE, READ PICTURE FILE, WRITE PICTURE FILEͰ୅༻
231. Tokyo/2010-03-03/04 ϐΫνϟ
232. Tokyo/2010-03-03/04 ϐΫνϟ • ผ໊Ͱอଘ: • Πϯετʔϧ͞ΕͨυϥΠόʔ࣍ୈͰ, ΄ͱΜͲͷϝʔ ΧʔͷΧϝϥܗࣜΛαϙʔτ • 4D Pictureܗࣜ͸ෳ਺ͷϑΥʔϚοτ͓ΑͼมܗΛอ ଘͰ͖Δಠࣗͷίϯςφܗࣜ
233. Tokyo/2010-03-03/04 Ϧιʔ ε
234. Tokyo/2010-03-03/04 Ϧιʔ ε • UnicodeඇରԠ, Ϧιʔ εͷ্ݶ͸2727ݸ·ͨ͸16MB • Apple͸αϙʔτΛதࢭ, WindowsΤσΟλແ͠ • ςΩετ͸xliff, ϐΫνϟ͸ png͕ओྲྀ • ϑΥʔϜΤσΟλͱϥϯήʔδͰxliffͱϐΫνϟϑΝΠϧ Λαϙʔτ • 4D͸͍ͣΕϦιʔ εͷॻ͖ग़͕͠ෆՄೳʹ • ಡΈऔΓ͸౰໘Ͱ͖Δ͸͕ͣͩ, PICTϦιʔ ε͸ແཧ
235. Tokyo/2010-03-03/04
236. Tokyo/2010-03-03/04 • 4DͷWindowsҠ২ʹҰ໾ങٕͬͨज़ • ຖճͷ4DόʔδϣϯΞοϓͰগͣͭ͠Mac2WinґଘΛ ͳ͖ͯͨ͘͠ • ޓ׵ੑͷͨΊʹ͍·ͩଟ͘ґଘ͕࢒͞Ε͍ͯΔ: ‣ Ϧιʔ ε, PICT, ϓϥά Πϯ • Mac2WinΛ࢖༻͍ͯ͠Δϓϥά Πϯ͸, ґଘؔ܎Λ੾Δ, ͞΋ͳ͚Ε͹4Dʹݟ੾ΒΕΔӡ໋... • ͍·͸·ͩAsifont.mapΛ࢖༻
237. Tokyo/2010-03-03/04 ੲͷϧοΫε System 7 Windows 3.11 Mac OS 9 Windows 95
238. Tokyo/2010-03-03/04 ੲͷϧοΫε • QuickDraw ͓Αͼ Altura ࢖༻ͷΧελϜίʔυ • 4D 2004 Ͱഇࢭ༧ఆͷର৅ʹ • 4D v13ͰγεςϜΞϐΞϥϯεʹม׵͞ΕΔӡ໋ • 4D v13·ͰઌԆ͹͠ʹ͠ͳ͍Ͱ ! System 7 Windows 3.11 Mac OS 9 Windows 95
239. Tokyo/2010-03-03/04 ੲͷϧοΫε • ࣌ʑ, ΤϯυϢʔβʔͷ൓Ԡ͕ؾʹͳΓ·ͤΜ͔ ?
240. Tokyo/2010-03-03/04 ੲͷϧοΫε • ࣌ʑ, ΤϯυϢʔβʔͷ൓Ԡ͕ؾʹͳΓ·ͤΜ͔ ?
241. Tokyo/2010-03-03/04 αϒςʔϒϧ
242. Tokyo/2010-03-03/04 αϒςʔϒϧ • ಛघͳϦϨʔγϣϯʹม׵͞ΕΔ • αϒςʔϒϧίϚϯυ͸͢΂ͯ·ͩಈ࡞͢Δ ‣ ྫ֎ SEND RECORD, DUPLICATE RECORD • ͍·͙͢ഇࢭ͞ΕΔ༁Ͱ͸ͳ͍ • ςʔϒϧ΁ͷม׵͕׬ྃ͢Δ·Ͱͷ༛༧Λઃ͚͍ͯΔ
243. Tokyo/2010-03-03/04 MODIFY SELECTION DISPLAY SELECTION
244. Tokyo/2010-03-03/04 MODIFY SELECTION DISPLAY SELECTION • ഇࢭ༧ఆͰ͸ͳ͍͚ΕͲ, 4DΞϓϦέʔγϣϯ͕Ϣʔβ ʔ͔Β௿͍ධՁΛड͚ͯ͠·͏ཧ༝ͷͻͱͭ
245. Tokyo/2010-03-03/04
246. Tokyo/2010-03-03/04 MODIFY SELECTION DISPLAY SELECTION • ഇࢭ༧ఆͰ͸ͳ͍͚ΕͲ, 4DΞϓϦέʔγϣϯ͕Ϣʔβ ʔ͔Β௿͍ධՁΛड͚ͯ͠·͏ཧ༝ͷͻͱͭ
247. Tokyo/2010-03-03/04 MODIFY SELECTION DISPLAY SELECTION ‣ ϦετϘοΫε·ͨ͸αϒϑΥʔϜΛਪ঑ • ཁ݅ʹ߹͏ͷͳΒ͹ϦετϘοΫεʢ഑ྻɾηϨΫγϣϯʣΛ࢖༻ ! • ಛघͳඞཁ͕͋Γ, ϦετϘοΫε͕μϝͳΒ͹αϒϑΥʔϜΛ࢖༻ ! • ഇࢭ༧ఆͰ͸ͳ͍͚ΕͲ, 4DΞϓϦέʔγϣϯ͕Ϣʔβ ʔ͔Β௿͍ධՁΛड͚ͯ͠·͏ཧ༝ͷͻͱͭ
248. Tokyo/2010-03-03/04 ϥϕϧΤσΟλʔ
249. Tokyo/2010-03-03/04 ϥϕϧΤσΟλʔ • 4D ࠷ݹͷΤσΟλʔͷͻͱͭ • PRINT OBJECT (v12) ͸͘͢͝ศར ! • ৽͍͠ 4D ίϯϙʔωϯτΛݱࡏݕ౼த
250. 4D v12 The Next Version