Body Head Hemisphere Body Cylinder Tail Cone     Leg 1 Segment 1 Segment 2 Segment 3     Leg 2 Segment 1 Segment 2 Segment 3     Leg 3 Segment 1 Segment 2 Segment 3       Perimeter* Water Strider Body Segment Dimensions Radius Length Contact Perimeter (mm) (mm) (mm) 0.55 ----0.55 6.4 --0.55 2.6 --      Volume (mm3) 0.348 6.082 0.824   0.08 0.04 0.02   1.5 1.5 1.0   ----2   0.030 0.008 0.001   0.08 0.04 0.02   4.5 4.5 3.0   ----6   0.090 0.023 0.004   3.0 3.0 2.0 ----4 0.015 0.004 0.003 24       7.61 0.009132 0.04 0.02 0.02 Total Contact Total Volume** Body Mass (g) *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Body Head Hemisphere Body Cylinder Tail Cone     Leg 1 Segment 1 Segment 2 Segment 3     Leg 2 Segment 1 Segment 2 Segment 3     Leg 3 Segment 1 Segment 2 Segment 3       Perimeter* Water Strider Body Segment Dimensions Radius Length Contact Perimeter (mm) (mm) (mm) 0.55 ----0.55 6.4 --0.55 2.6 --      Volume (mm3) 0.348 6.082 0.824   0.08 0.04 0.02   1.5 1.5 1.0   ----2   0.030 0.008 0.001   0.08 0.04 0.02   4.5 4.5 3.0   ----6   0.090 0.023 0.004   3.0 3.0 2.0 ----4 0.015 0.004 0.003 24       7.61 0.009132 0.04 0.02 0.02 Total Contact Total Volume** Body Mass (g) *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Body Head Hemisphere Body Cylinder Tail Cone     Leg 1 Segment 1 Segment 2 Segment 3     Leg 2 Segment 1 Segment 2 Segment 3     Leg 3 Segment 1 Segment 2 Segment 3       Perimeter* Water Strider Body Segment Dimensions Radius Length Contact Perimeter (mm) (mm) (mm) 0.55 ----0.55 6.4 --0.55 2.6 --      Volume (mm3)   0.08 0.04 0.02   1.5 1.5 1.0   ----    0.08 0.04 0.02   4.5 4.5 3.0   ----- 0.090 0.023 0.004   3.0 3.0 2.0 ----- 0.04 0.02 0.02 Total Contact Total Volume** Body Mass (g)   0.015 0.004 0.003       *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Body Head Hemisphere Body Cylinder Tail Cone     Leg 1 Segment 1 Segment 2 Segment 3     Leg 2 Segment 1 Segment 2 Segment 3     Leg 3 Segment 1 Segment 2 Segment 3       Perimeter* Water Strider Body Segment Dimensions Radius Length Contact Perimeter (mm) (mm) (mm) 0.55 ----0.55 6.4 --0.55 2.6 --      Volume (mm3)   0.08 0.04 0.02   1.5 1.5 1.0   ----2     0.08 0.04 0.02   4.5 4.5 3.0   ----6   0.090 0.023 0.004   3.0 3.0 2.0 ----4 0.015 0.004 0.003 24   0.04 0.02 0.02 Total Contact Total Volume** Body Mass (g)     *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




#1 Phase mole transfers: Halite 1.600e-005 Gypsum 1.500e-005 Kaolinite -1.295e-004 CO2(g) 3.088e-004 Calcite 1.079e-004 Chalcedony -1.108e-004 Biotite 1.370e-005 Plag(An38) 1.777e-004 Minimum 1.490e-005 1.412e-005 -1.403e-004 2.527e-004 8.680e-005 -1.473e-004 1.317e-005 1.629e-004 Maximum 1.710e-005 1.587e-005 -1.193e-004 3.702e-004 1.144e-004 -7.528e-005 1.370e-005 1.934e-004 NaCl CaSO4:2H2O Al2Si2O5(OH)4 CO2 CaCO3 SiO2 KMg3AlSi3O10(OH)2 Na0.62Ca0.38Al1.38Si2.62O8 #2 Phase mole transfers: Halite 1.600e-005 Gypsum 1.500e-005 Kaolinite -3.316e-005 Ca-Montmorillon -8.269e-005 CO2(g) 2.951e-004 Calcite 1.216e-004 Biotite 1.370e-005 Plag(An38) 1.777e-004 Minimum 1.490e-005 1.412e-005 -5.381e-005 -1.099e-004 2.392e-004 1.007e-004 1.317e-005 1.629e-004 Maximum 1.710e-005 1.587e-005 -1.223e-005 -5.618e-005 3.563e-004 1.279e-004 1.370e-005 1.934e-004 NaCl CaSO4:2H2O Al2Si2O5(OH)4 Ca0.165Al2.33Si3.67O10(OH)2 CO2 CaCO3 KMg3AlSi3O10(OH)2 Na0.62Ca0.38Al1.38Si2.62O8 Minimum 1.490e-005 1.412e-005 -1.204e-004 2.358e-004 1.067e-004 1.407e-005 1.317e-005 1.629e-004 Maximum 1.710e-005 1.587e-005 -1.024e-004 3.503e-004 1.313e-004 6.189e-005 1.370e-005 1.934e-004 NaCl CaSO4:2H2O Ca0.165Al2.33Si3.67O10(OH)2 CO2 CaCO3 SiO2 KMg3AlSi3O10(OH)2 Na0.62Ca0.38Al1.38Si2.62O8 #3 Phase mole transfers: Halite 1.600e-005 Gypsum 1.500e-005 Ca-Montmorillon -1.112e-004 CO2(g) 2.904e-004 Calcite 1.262e-004 Chalcedony 3.814e-005 Biotite 1.370e-005 Plag(An38) 1.777e-004
View full slide show




#1 Phase mole transfers: Halite 1.600e-005 Gypsum 1.500e-005 Kaolinite -1.295e-004 CO2(g) 3.088e-004 Calcite 1.079e-004 Chalcedony -1.108e-004 Biotite 1.370e-005 Plag(An38) 1.777e-004 Minimum 1.490e-005 1.412e-005 -1.403e-004 2.527e-004 8.680e-005 -1.473e-004 1.317e-005 1.629e-004 Maximum 1.710e-005 1.587e-005 -1.193e-004 3.702e-004 1.144e-004 -7.528e-005 1.370e-005 1.934e-004 NaCl CaSO4:2H2O Al2Si2O5(OH)4 CO2 CaCO3 SiO2 KMg3AlSi3O10(OH)2 Na0.62Ca0.38Al1.38Si2.62O8 #2 Phase mole transfers: Halite 1.600e-005 Gypsum 1.500e-005 Kaolinite -3.316e-005 Ca-Montmorillon -8.269e-005 CO2(g) 2.951e-004 Calcite 1.216e-004 Biotite 1.370e-005 Plag(An38) 1.777e-004 Minimum 1.490e-005 1.412e-005 -5.381e-005 -1.099e-004 2.392e-004 1.007e-004 1.317e-005 1.629e-004 Maximum 1.710e-005 1.587e-005 -1.223e-005 -5.618e-005 3.563e-004 1.279e-004 1.370e-005 1.934e-004 NaCl CaSO4:2H2O Al2Si2O5(OH)4 Ca0.165Al2.33Si3.67O10(OH)2 CO2 CaCO3 KMg3AlSi3O10(OH)2 Na0.62Ca0.38Al1.38Si2.62O8 Minimum 1.490e-005 1.412e-005 -1.204e-004 2.358e-004 1.067e-004 1.407e-005 1.317e-005 1.629e-004 Maximum 1.710e-005 1.587e-005 -1.024e-004 3.503e-004 1.313e-004 6.189e-005 1.370e-005 1.934e-004 NaCl CaSO4:2H2O Ca0.165Al2.33Si3.67O10(OH)2 CO2 CaCO3 SiO2 KMg3AlSi3O10(OH)2 Na0.62Ca0.38Al1.38Si2.62O8 #3 Phase mole transfers: Halite 1.600e-005 Gypsum 1.500e-005 Ca-Montmorillon -1.112e-004 CO2(g) 2.904e-004 Calcite 1.262e-004 Chalcedony 3.814e-005 Biotite 1.370e-005 Plag(An38) 1.777e-004
View full slide show




Water Strider Body Segment Dimensions x 2 Radius Length Contact Perimeter Body (mm) (mm) (mm) Head Hemisphere 1.1 ----Body Cylinder 1.1 12.8 --Tail Cone 1.1 5.2 --          Leg 1 Segment 1 0.16 3.0 --Segment 2 0.08 3.0 --Segment 3 0.04 2.0           Leg 2 Segment 1 0.16 9.0 --Segment 2 0.08 9.0 --Segment 3 0.04 6.0           Leg 3 Segment 1 0.08 6.0 --Segment 2 0.04 6.0 --Segment 3 0.04 4.0 Total Contact   Perimeter*   Total Volume**     Body Mass (g)   Volume (mm3)     0.724 0.181 0.030   0.121 0.030 0.020   *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Water Strider Body Segment Dimensions x 2 Radius Length Contact Perimeter Body (mm) (mm) (mm) Head Hemisphere 1.1 ----Body Cylinder 1.1 12.8 --Tail Cone 1.1 5.2 --          Leg 1 Segment 1 0.16 3.0 --Segment 2 0.08 3.0 --Segment 3 0.04 2.0 4           Leg 2 Segment 1 0.16 9.0 --Segment 2 0.08 9.0 --Segment 3 0.04 6.0 12           Leg 3 Segment 1 0.08 6.0 --Segment 2 0.04 6.0 --Segment 3 0.04 4.0 8 Total Contact   48 Perimeter*   Total Volume**     Body Mass (g)   Volume (mm3) 2.788 48.657 6.589   0.241 0.060 0.010   0.724 0.181 0.030   0.121 0.030 0.020   60.868 0.0730416 *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Water Strider Body Segment Dimensions x 4 Radius Length Contact Perimeter Body (mm) (mm) (mm) Head Hemisphere 2.2 ----Body Cylinder 2.2 25.6 --Tail Cone 2.2 10.4 --          Leg 1 Segment 1 0.32 6 --Segment 2 0.16 6 --Segment 3 0.08 4           Leg 2 Segment 1 0.32 18 --Segment 2 0.16 18 --Segment 3 0.08 12           Leg 3 Segment 1 0.16 12 --Segment 2 0.08 12 --Segment 3 0.08 8 Total Contact   Perimeter*   Total Volume**     Body Mass (g)   Volume (mm3)     5.791 1.448 0.241   0.965 0.241 0.161   *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Water Strider Body Segment Dimensions x 8 Radius Length Contact Perimeter Body (mm) (mm) (mm) Head Hemisphere 4.4 ----Body Cylinder 4.4 51.2 --Tail Cone 4.4 20.8 --          Leg 1 Segment 1 0.64 12 --Segment 2 0.32 12 --Segment 3 0.16 8           Leg 2 Segment 1 0.64 36 --Segment 2 0.32 36 --Segment 3 0.16 24           Leg 3 Segment 1 0.32 24 --Segment 2 0.16 24 --Segment 3 0.16 16 Total Contact   Perimeter*   Total Volume**     Body Mass (g)   Volume (mm3)     46.325 11.581 1.930   7.721 1.930 1.287   *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Water Strider Body Segment Dimensions x 4 Radius Length Contact Perimeter Body (mm) (mm) (mm) Head Hemisphere 2.2 ----Body Cylinder 2.2 25.6 --Tail Cone 2.2 10.4 --          Leg 1 Segment 1 0.32 6 --Segment 2 0.16 6 --Segment 3 0.08 4 8           Leg 2 Segment 1 0.32 18 --Segment 2 0.16 18 --Segment 3 0.08 12 24           Leg 3 Segment 1 0.16 12 --Segment 2 0.08 12 --Segment 3 0.08 8 16 Total Contact   96 Perimeter*   Total Volume**     Body Mass (g)   Volume (mm3) 22.301 389.256 52.712   1.930 0.483 0.080   5.791 1.448 0.241   0.965 0.241 0.161   486.949 0.5843388 *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Water Strider Body Segment Dimensions x 8 Radius Length Contact Perimeter Body (mm) (mm) (mm) Head Hemisphere 4.4 ----Body Cylinder 4.4 51.2 --Tail Cone 4.4 20.8 --          Leg 1 Segment 1 0.64 12 --Segment 2 0.32 12 --Segment 3 0.16 8 16           Leg 2 Segment 1 0.64 36 --Segment 2 0.32 36 --Segment 3 0.16 24 48           Leg 3 Segment 1 0.32 24 --Segment 2 0.16 24 --Segment 3 0.16 16 32 Total Contact   192 Perimeter*   Total Volume**     Body Mass (g)   Volume (mm3) 178.409 3114.047 421.694   15.442 3.860 0.643   46.325 11.581 1.930   7.721 1.930 1.287   3895.588 4.6747056 *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Body Head Hemisphere Body Cylinder Tail Cone     Leg 1 Segment 1 Segment 2 Segment 3     Leg 2 Segment 1 Segment 2 Segment 3     Leg 3 Segment 1 Segment 2 Segment 3       Perimeter* Water Strider Body Segment Dimensions Radius Length Contact Perimeter (mm) (mm) (mm) 0.55 ----0.55 6.4 --0.55 2.6 --      0.08 0.04 0.02   1.5 1.5 1.0   ----- 0.08 0.04 0.02   4.5 4.5 3.0   ----- 3.0 3.0 2.0 ----- 0.04 0.02 0.02 Total Contact Total Volume** Body Mass (g)     Volume (mm3)             *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Body Head Hemisphere Body Cylinder Tail Cone     Leg 1 Segment 1 Segment 2 Segment 3     Leg 2 Segment 1 Segment 2 Segment 3     Leg 3 Segment 1 Segment 2 Segment 3       Perimeter* Water Strider Body Segment Dimensions Radius Length Contact Perimeter (mm) (mm) (mm) 0.55 ----0.55 6.4 --0.55 2.6 --      Volume (mm3)   0.08 0.04 0.02   1.5 1.5 1.0   ----2     0.08 0.04 0.02   4.5 4.5 3.0   ----6     3.0 3.0 2.0 ----4 0.04 0.02 0.02 Total Contact Total Volume** Body Mass (g) 24       *Contact perimeter for Legs 1, 2, & 3 must be multiplied by 2 to account for the legs on either side of the body. **Total volume must include the volume of the body and the volume of the legs multiplied by 2 to
View full slide show




Goodness of Prediction Comparison using MSE std for 30-day readmission problems on longitudinal EHRs. Model HF-cohort EHR-0 EHR-1 EHR-2 EHR-3 EHR-4 Logit 0.21030.008 0.20560.004 0.23330.006 0.22540.010 0.21940.008 0.22830.011 GAM 0.18110.005 0.21220.010 0.21970.004 0.22460.009 0.23080.011 0.24880.014 GA2M 0.22380.010 0.27360.023 0.31540.048 0.31770.028 0.30890.038 0.33020.019 hiernet-weak 0.19140.008 0.22320.010 0.22260.002 0.22930.004 0.23090.010 0.25510.002 hiernet-strong 0.19330.007 0.22560.007 0.22970.005 0.23350.009 0.22500.008 0.25590.019 EN-linear 0.18320.003 0.20590.001 0.20750.002 0.21520.004 0.21450.004 0.22630.001 EN-logit 0.18330.006 0.20610.008 0.20770.009 0.21530.002 0.21460.004 0.22650.004 SGL 0.18160.003 0.20500.004 0.20650.008 0.21490.007 0.21510.009 0.22720.009 L1-SVR 0.71660.022 0.95850.037 0.97560.027 1.06350.041 1.08610.053 1.08140.107 L2-SVR 0.24020.007 0.29850.016 0.31040.026 0.33330.028 0.34410.049 0.39800.016 CRISP(se) 0.17750.002 0.20300.003 0.20500.003 0.21100.003 0.20830.004 0.22020.003
View full slide show




Results: Geometry Molecule MP4 CCSD(T) H2O Coordinate HF MP2 CCSD Error in Bond Length (Å) O-H -0.006 0.005 0.004 0.005 0.005 NH3 N-H -0.011 0.002 0.003 0.004 0.004 CH4 C-H -0.001 0.003 0.005 0.006 0.006 C2H2 C-H C-C C-H C=O C-H C-N N-H C-N -0.002 -0.012 -0.005 -0.015 -0.003 -0.017 -0.008 -0.010 0.006 0.024 0.003 0.022 0.004 0.032 0.007 0.025 0.007 0.016 0.004 0.015 0.005 0.019 0.006 0.017 0.008 0.025 0.008 0.023 0.006 0.030 0.007 0.031 0.008 0.023 0.006 0.021 0.006 0.024 0.008 0.024 0.028 0.015 0.018 0.013 0.0 0.0 CH2O HCN HCN CO2 C-O Average Abs. Error () H2O H-O-H -0.015 0.022 0.012 -0.009 0.013 0.009 Error in Bond Angle (deg.) 2.1 -0.1 0.1 NH3 H-N-H 1.5 0.0 -0.2 -0.3 -0.4 -0.3 1.3 -0.2 -0.1 -0.2 -0.1 -0.6 -0.3 -0.2 -0.2 CH20 H-C-O Average Error (deg.)
View full slide show




Some Random Results Sample means from 15 trials: A B C 1 Random # Outcome Profit 2 0.4619 Tail -$1.00 3 0.4118 Tail -$1.00 4 0.5815 Tail -$1.00 5 0.9792 Tail -$1.00 6 0.2852 Head $3.00 7 0.9064 Tail -$1.00 8 0.9855 Tail -$1.00 9 0.9988 Tail -$1.00 10 0.2206 Head $3.00 11 0.0986 Head $3.00 12 0.9696 Tail -$1.00 13 0.8026 Tail -$1.00 14 0.8189 Tail -$1.00 15 0.7137 Tail -$1.00 16 0.9258 Tail -$1.00 17 -$0.20 D E =AVERAGE(C2:C16) Operations -- Prof. Juran F A B C 1 Random # Outcome Profit 2 0.1979 Head $3.00 3 0.9185 Tail -$1.00 4 0.4688 Tail -$1.00 5 0.6670 Tail -$1.00 6 0.0902 Head $3.00 7 0.3757 Tail -$1.00 8 0.1492 Head $3.00 9 0.4518 Tail -$1.00 10 0.8503 Tail -$1.00 11 0.1392 Head $3.00 12 0.1924 Head $3.00 13 0.0179 Head $3.00 14 0.4799 Tail -$1.00 15 0.5064 Tail -$1.00 16 0.3051 Head $3.00 17 $0.87 D E F =AVERAGE(C2:C16) 17 © The McGraw-Hill Companies, Inc.,
View full slide show




Normalisierung – 1.NF SS 2017– IBB4C Datenmanagement Fr 15:15 – 16:45 R 0.009 Filialen_ID 001 023 072 023 072 001 072 072 Filiale Stadt Region Artikel Marke Farben Filialen_ID Artikel Farben Filialen_ID Stadt Region Artikel Marke Farben in OEZ München Filiale Süd Trikot Deutschland Adidas weiß, rot, schwarz in PEP München Süd Trikot Italien Puma blau, weiß 001 Trikot Deutschland weiß, rot, schwarz Fußgängerzone München inSüd Trikot Frankreich München Adidas blau 001 OEZ Süd Trikot Deutschland Adidas weiß, rot, schwarz in PEP München Süd Trikot Deutschland Adidas weiß, rot, schwarz 023 Trikot Italien blau, Fußgängerzone München Süd Trikot Italien Puma blau, weiß 023in OEZ München inSüdPEP München Süd weiß Trikot Italien Puma blau, weiß Trikot Frankreich Adidas blau, weiß 072 Fußgängerzone München Trikot Süd TrikotFrankreich Deutschland Adidas weiß, rot, schwarz blau 072 Fußgängerzone München Süd Trikot Frankreich Filialen_IDAdidasArtikel blau Farbe Fußgängerzone München Süd Italien Puma blau 023 Trikot Trikot Deutschland weiß, rot, schwarz 023 in PEP München Süd Trikot Deutschland Adidas weiß, rot, schwarz 001 Trikot Deutschland weiß 072 Trikot Italien blau, weiß 072 Fußgängerzone München blau, Süd weiß Trikot Italien 001 Puma Trikot Deutschland blau, weiß rot 001 Trikot Frankreich 001 Trikot Deutschland 001 in OEZDeutschland München Trikot Frankreich Adidas blau, weiß schwarz 072 Trikot weiß,Süd rot, schwarz 023 Trikot Italien 072 Fußgängerzone München Süd 072 Trikot Italien blau Trikot Deutschland Adidas weiß, rot, schwarzblau 023 Trikot Italienblau weiß 072 Fußgängerzone München Süd Trikot Italien Puma 072 Trikot Frankreich blau 023 Trikot Deutschland weiß 023 Trikot Deutschland rot 023 Trikot Deutschland schwarz 072 Trikot Italien weiß 072 Trikot Italien blau 001 Trikot Frankreich weiß 001 Trikot Frankreich blau 072 Trikot Deutschland weiß 072 Trikot Deutschland rot 072 Trikot Deutschland schwarz 072 Trikot Italien blau © Bojan Milijaš, 28.04.2017 Normalisierung - Denormalisierung 3
View full slide show




Normalisierung – 1.NF SS 2010 – IBB4C Datenmanagement Fr 15:15 – 16:45 R 1.007 Filialen_ID 001 023 072 023 072 001 072 072 Filiale Stadt Region Artikel Marke Farben Filialen_ID Artikel Farben Filialen_ID Stadt Region Artikel Marke Farben in OEZ München Filiale Süd Trikot Deutschland Adidas weiß, rot, schwarz in PEP München Süd Trikot Italien Puma blau, weiß 001 Trikot Deutschland weiß, rot, schwarz Fußgängerzone München inSüd Trikot Frankreich München Adidas blau 001 OEZ Süd Trikot Deutschland Adidas weiß, rot, schwarz in PEP München Süd Trikot Deutschland Adidas weiß, rot, schwarz 023 Trikot Italien blau, Fußgängerzone München Süd Trikot Italien Puma blau, weiß 023in OEZ München inSüdPEP München Süd weiß Trikot Italien Puma blau, weiß Trikot Frankreich Adidas blau, weiß 072 Fußgängerzone München Trikot Süd TrikotFrankreich Deutschland Adidas weiß, rot, schwarz blau 072 Fußgängerzone München Süd Trikot Frankreich Filialen_IDAdidasArtikel blau Farbe Fußgängerzone München Süd Italien Puma blau 023 Trikot Trikot Deutschland weiß, rot, schwarz 023 in PEP München Süd Trikot Deutschland Adidas weiß, rot, schwarz 001 Trikot Deutschland weiß 072 Trikot Italien blau, weiß 072 Fußgängerzone München blau, Süd weiß Trikot Italien 001 Puma Trikot Deutschland blau, weiß rot 001 Trikot Frankreich 001 Trikot Deutschland 001 in OEZDeutschland München Trikot Frankreich Adidas blau, weiß schwarz 072 Trikot weiß,Süd rot, schwarz 023 Trikot Italien 072 Fußgängerzone München Süd 072 Trikot Italien blau Trikot Deutschland Adidas weiß, rot, schwarzblau 023 Trikot Italienblau weiß 072 Fußgängerzone München Süd Trikot Italien Puma 072 Trikot Frankreich blau 023 Trikot Deutschland weiß 023 Trikot Deutschland rot 023 Trikot Deutschland schwarz 072 Trikot Italien weiß 072 Trikot Italien blau 001 Trikot Frankreich weiß 001 Trikot Frankreich blau 072 Trikot Deutschland weiß 072 Trikot Deutschland rot 072 Trikot Deutschland schwarz 072 Trikot Italien blau © Bojan Milijaš, 03/17/19 Normalisierung - Denormalisierung 3
View full slide show




Column-oriented DBMS ( https://en.wikipedia.org/wiki/Column-oriented_DBMS ) RowId 001 002 003 004 EmpId 10 12 11 22 Lastname Smith Jones Johnson Jones Firstname Joe Mary Cathy Bob Salary 40000 50000 44000 55000 001:10,Smith,Joe,40000; 002:12,Jones,Mary,50000; 003:11,Johnson,Cathy,44000; 004:22,Jones,Bob,55000; 10:001,12:002,11:003,22:004; Smith:001,Jones:002,Johnson:003,Jones:004; Joe:001,Mary:002,Cathy:003,Bob:004; 40000:001,50000:002,44000:003,55000:004; Row-oriental Column-oriented
View full slide show