defaria.com/blogs/Status/archives/week_2007_04_08.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
  11
  12    <title>Status for Andrew DeFaria: April  8, 2007 - April 14, 2007 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2007_03_25.html" title="March 25, 2007 - March 31, 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2007_04_15.html" title="April 15, 2007 - April 21, 2007" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/week_2007_03_25.html">&laquo; March 25, 2007 - March 31, 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2007_04_15.html">April 15, 2007 - April 21, 2007 &raquo;</a>
  38                      </p>
  39
  40
  41                      <!--
  42 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  43          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  44          xmlns:dc="http://purl.org/dc/elements/1.1/">
  45 <rdf:Description
  46     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_04_08.html#entry-000631"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/20"
  48     dc:title="Deleting Site Domains"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_08.html#entry-000631"
  50     dc:subject="Texas Instruments"
  51     dc:description=" Implemented gpdb_deleteSiteDomain..."
  52     dc:creator=""
  53     dc:date="2007-04-13T21:44:25-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">April 13, 2007</h2>
  59                      <a id="a000631"></a>
  60                      <div class="entry" id="entry-631">
  61                         <h3 class="entry-header">Deleting Site Domains</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <li>Implemented gpdb_deleteSiteDomain</li>
  66 </ul>
  67
  68                               <p>As we know, in GPDB there's very little in the realm of editing or validating of data. We've seen this with IP ranges where we let any old data in, including invalid IP ranges (let along the fact that the whole concept of IP ranges identifying sites is flawed to start with).</p>
  69
  70 <p>But as we can also see a site may have multiple domains (e.g. Dallas has many).</p>
  71
  72 <p>Site domains are implemented as their own table with the Site ID as the key and the "extended fields" of domain, IP range lower and upper being the data files.<p>
  73
  74 <div class=code><pre>
  75 -- site_domain_map: Table to map multiple domains to sites
  76 create table site_domain_map (
  77   id                number      (10)    not null,
  78   domain            varchar2    (256)   not null,
  79   ip_range_lower    varchar2    (15),
  80   ip_range_upper    varchar2    (15),
  81   foreign key (id) references sites (id)
  82 );
  83 </pre></div>
  84
  85 <p>But nothing stops the user or worse yet, a script, from adding more than one site domain that is exactly identical! So we can have, for example, two site domains for Dallas that have the domain name of "dal.design.ti.com".</p>
  86
  87 <p>As if that is not enough a real problem come when one attempts to delete. Let's say somebody added a second "dal.design.ti.com" Site Domain, notices the mistake and wants to delete the extra one.</p>
  88
  89 <p>Currently the code deletes site_domain_map entries using the following SQL statement:</p>
  90
  91 <div class=code><pre>
  92 DELETE FROM SITE_DOMAIN_MAP WHERE ID = 1000007 AND DOMAIN = 'dal.design.ti.com';
  93 </pre></div>
  94
  95 <p>This would delete both dal.design.ti.com entries, not just one.</p>
  96
  97 <p>I think the answer is to implement some validation such that people cannot add a second Site Domain of the same Domain name. Of course, this leaves the question is it considered legal to have two dal.design.ti.com Site Domains with different IP ranges. Which brings up the idea of validating not only a single IP range, but that no IP ranges overlap!</p>
  98
  99
 100                               <p class="entry-footer">
 101                                  <span class="post-footers">Posted by  at  9:44 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000631.html">Permalink</a>
 102
 103                                  | <a href="http://defaria.com/blogs/Status/archives/000631.html#trackback">TrackBacks (0)</a>
 104                               </p>
 105                            </div>
 106                         </div>
 107                      </div>
 108
 109                      <!--
 110 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 111          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 112          xmlns:dc="http://purl.org/dc/elements/1.1/">
 113 <rdf:Description
 114     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_04_08.html#entry-000630"
 115     trackback:ping="http://defaria.com/mt/mt-tb.cgi/19"
 116     dc:title="testcc.pl"
 117     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_08.html#entry-000630"
 118     dc:subject="Texas Instruments"
 119     dc:description=" Created testcc.pl. This script creates a test vob, test view, makes elements, checks them in, out, modifies them, checks them in again and compares! Basic Clearcase sanity testing......"
 120     dc:creator=""
 121     dc:date="2007-04-10T17:53:20-06:00" />
 122 </rdf:RDF>
 123 -->
 124
 125
 126                      <h2 class="date-header">April 10, 2007</h2>
 127                      <a id="a000630"></a>
 128                      <div class="entry" id="entry-630">
 129                         <h3 class="entry-header">testcc.pl</h3>
 130                         <div class="entry-content">
 131                            <div class="entry-body">
 132                               <ul>
 133   <li>Created testcc.pl. This script creates a test vob, test view, makes elements, checks them in, out, modifies them, checks them in again and compares! Basic Clearcase sanity testing...</li>
 134 </ul>
 135
 136                               <p class="entry-footer">
 137                                  <span class="post-footers">Posted by  at  5:53 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000630.html">Permalink</a>
 138
 139                                  | <a href="http://defaria.com/blogs/Status/archives/000630.html#trackback">TrackBacks (0)</a>
 140                               </p>
 141                            </div>
 142                         </div>
 143                      </div>
 144
 145                      <!--
 146 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 147          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 148          xmlns:dc="http://purl.org/dc/elements/1.1/">
 149 <rdf:Description
 150     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_04_08.html#entry-000629"
 151     trackback:ping="http://defaria.com/mt/mt-tb.cgi/18"
 152     dc:title="Convert Dallas/Licensing/Solaris 10 testing"
 153     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_08.html#entry-000629"
 154     dc:subject="Texas Instruments"
 155     dc:description=" Changed gpdb_convertuk.pl to open and use the new Dallas database cclic_report.pl reporting everybody as &quot;UNK&quot;. Tried to run this in debugger and it just worked! Hmmm... Is this a cron problem? Running again tonight Rick got the Jackson filer..."
 156     dc:creator=""
 157     dc:date="2007-04-09T19:23:36-06:00" />
 158 </rdf:RDF>
 159 -->
 160
 161
 162                      <h2 class="date-header">April  9, 2007</h2>
 163                      <a id="a000629"></a>
 164                      <div class="entry" id="entry-629">
 165                         <h3 class="entry-header">Convert Dallas/Licensing/Solaris 10 testing</h3>
 166                         <div class="entry-content">
 167                            <div class="entry-body">
 168                               <ul>
 169   <li>Changed gpdb_convertuk.pl to open and use the new Dallas database</li>
 170
 171   <li>cclic_report.pl reporting everybody as "UNK". Tried to run this in debugger and it just worked! Hmmm... Is this a cron problem? Running again tonight</li>
 172
 173   <li>Rick got the Jackson filer to mount to dslabcc01 however while I can create the vob storage area I cannot mount the vob!</li>
 174 </ul>
 175
 176                               <p class="entry-footer">
 177                                  <span class="post-footers">Posted by  at  7:23 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000629.html">Permalink</a>
 178
 179                                  | <a href="http://defaria.com/blogs/Status/archives/000629.html#trackback">TrackBacks (0)</a>
 180                               </p>
 181                            </div>
 182                         </div>
 183                      </div>
 184
 185                   </div>
 186                </div>
 187             </div>
 188          </div>
 189       </div>
 190    </div>
 191 </body>
 192 </html>