<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>arjuna del toso</title>
	
	<link>http://arjuna.deltoso.net</link>
	<description />
	<pubDate>Mon, 01 Mar 2010 10:26:41 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.6</generator>
	<language>en</language>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/adt-en" /><feedburner:info uri="adt-en" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><feedburner:browserFriendly></feedburner:browserFriendly><item>
		<title>Inst. El. s.n.c. - Hydroelectric Energy</title>
		<link>http://arjuna.deltoso.net/progetti/inst-el-snc-hydroelectric-energy/en/</link>
		<comments>http://arjuna.deltoso.net/progetti/inst-el-snc-hydroelectric-energy/en/#comments</comments>
		<pubDate>Mon, 01 Mar 2010 10:25:52 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[progetti]]></category>

		<category><![CDATA[freelance]]></category>

		<category><![CDATA[inst. el.]]></category>

		<category><![CDATA[web development]]></category>

		<category><![CDATA[wordpress]]></category>

		<category><![CDATA[work]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=281</guid>
		<description><![CDATA[http://www.inst-el.org/

Using Wordpress as a CMS allowed to quickly build a full featured website for a small but dynamic company, Wordpress also ensures that all the future needs and changes on the web presence of the company (i.e. blogs, newsletters, forums, &#8230;) will be easily deployed using it&#8217;s powerful plugin system.
Inst.El. snc. is an Italian company [...]]]></description>
			<content:encoded><![CDATA[<h4><a title="Inst.El. snc - Hydroelectric Energy" href="http://www.inst-el.org/">http://www.inst-el.org/</a></h4>
<p style="text-align: center;">
<p><em>Using Wordpress as a CMS allowed to quickly build a full featured website for a small but dynamic company, Wordpress also ensures that all the future needs and changes on the web presence of the company (i.e. blogs, newsletters, forums, &#8230;) will be easily deployed using it&#8217;s powerful plugin system.</em></p>
<p><a title="Inst.El. snc - Hydroelectric Energy" href="http://www.inst-el.org/">Inst.El. snc.</a> is an Italian company specialized in the production of <a href="http://www.inst-el.org/energia-pulita-energia-idroelettrica/">Hydroelectric Energy</a> using the best technology on the market, the so called <a href="http://www.inst-el.org/energia-pulita-energia-idroelettrica/come-funziona-la-coclea-idraulica-o-vite-di-archimede-e-applicazioni/">Archimedes screw turbines</a>. Inst.El. has also a wide experience on <a href="http://www.inst-el.org/altri-servizi/">solar photovoltaic systems and electric plants for home and business</a>.</p>
<p><em>Note: the website is in Italian language only</em></p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/progetti/inst-el-snc-hydroelectric-energy/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>Google pushes advertisement on new design</title>
		<link>http://arjuna.deltoso.net/articoli/google-pushes-advertisement-on-new-design/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/google-pushes-advertisement-on-new-design/en/#comments</comments>
		<pubDate>Tue, 01 Dec 2009 06:12:53 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[advertising]]></category>

		<category><![CDATA[design]]></category>

		<category><![CDATA[google]]></category>

		<category><![CDATA[hci]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=247</guid>
		<description><![CDATA[Recently Google started testing a new massive redesign of the search engine interface (here instructions on how to activate the new design), Peter Van Dijck wrote a comprehensive article on the major changes (sidebar, input field, &#8230;). Here I would like to point out some details about the new design of the &#8220;Sponsored links&#8221; banner [...]]]></description>
			<content:encoded><![CDATA[<p>Recently Google started testing a new massive redesign of the search engine interface (<a title="External link (new window)" href="http://blogoscoped.com/archive/2009-11-25-n78.html" target="_blank">here</a> instructions on how to activate the new design), <a title="External link (new window)" href="http://poorbuthappy.com/ease/archives/2009/11/30/4670/the-new-google-design-nothing-between-me-and-my-search-bar" target="_blank">Peter Van Dijck</a> wrote a comprehensive article on the major changes (sidebar, input field, &#8230;). Here I would like to point out some details about the new design of the &#8220;Sponsored links&#8221; banner (Hey it&#8217;s where the G makes money).</p>
<p>First of all the old interface:</p>
<p style="text-align: center;"><a href="http://arjuna.deltoso.net/wp-content/uploads/2009/12/screenshot-7.png"><img class="size-medium wp-image-250 aligncenter" title="Google search results - Old design" src="http://arjuna.deltoso.net/wp-content/uploads/2009/12/screenshot-7-300x270.png" alt="" width="300" height="270" /></a></p>
<p>And now the new design:</p>
<p style="text-align: center;"><a href="http://arjuna.deltoso.net/wp-content/uploads/2009/12/screenshot-91.png"><img class="alignnone size-medium wp-image-252" title="Google search results - New disgn" src="http://arjuna.deltoso.net/wp-content/uploads/2009/12/screenshot-91-300x270.png" alt="" width="300" height="270" /></a></p>
<p>And a detail of the main advertisement area:</p>
<div id="attachment_253" class="wp-caption aligncenter" style="width: 409px"><a href="http://arjuna.deltoso.net/wp-content/uploads/2009/12/ads-old.png"><img class="size-full wp-image-253" title="Old Ads design" src="http://arjuna.deltoso.net/wp-content/uploads/2009/12/ads-old.png" alt="Old Ads design" width="399" height="122" /></a><p class="wp-caption-text">Old Ads design</p></div>
<p style="text-align: center;">
<div id="attachment_254" class="wp-caption aligncenter" style="width: 409px"><a href="http://arjuna.deltoso.net/wp-content/uploads/2009/12/ads-new.png"><img class="size-full wp-image-254" title="New Ads design" src="http://arjuna.deltoso.net/wp-content/uploads/2009/12/ads-new.png" alt="New Ads design" width="399" height="126" /></a><p class="wp-caption-text">New Ads design</p></div>
<p><strong>Some thoughts</strong></p>
<p>As you can see, the new left sidebar forces the width of the light yellow box to a shorter version, the effect is that now it is more likely for an <strong>ad description text to be splitted in 2 lines</strong>, using more vertical space and thus having a higher probability to attract the eye of the user (compare the first and second ads on the two designs).</p>
<p>Without the horizontal bar (the one with &#8220;Web + Show options&#8221; button and the count of search results) the <strong>sponsor listing are much more closer</strong> to the input box, where the users is supposed to have the mouse pointer as he was just writing the search query text there (if he was already on a search result page).</p>
<p>The &#8220;Sponsored links&#8221; text now has a <strong>reduced font size </strong>(11px), it&#8217;s much less prominent and, with the use of a gray text color, it&#8217;s more difficult to spot it out at a first quick <span class="clickable" onclick="dr4sdgryt(event,&quot;Ox&quot;)"><span class="sg"><span class="se1"><span class="trn">sight</span>.</span></span></span></p>
<p>On the right ad box (the vertical one, without background color) there is an <strong>increased line height and white space</strong> between the sponsor listings. The law of proximity (from the <a title="External link (new window)" href="http://www.interaction-design.org/encyclopedia/gestalt_principles_of_form_perception.html" target="_blank">gestalt principles</a>) tells us that the single add will still be perceived as a unit, due to the bigger distance from one ad to the other, but now with more white space between the lines that perception is less strong, IMHO. Note also that the last ads, the less valuable, are more or less still under the fold.</p>
<p>Looking at the big screenshot, the map now occupies all the width of the central column; I think that this is done to <strong>discourage the user from scrolling</strong> and have him<strong> focusing on the sponsored listing</strong>. Such a strong visual block will for sure break the user&#8217;s &#8220;scan&#8221; of the page avoiding, or trying to avoid, him to &#8220;jump&#8221; under the map. For reference read the interesting research &#8220;<a title="External link (new window)" href="http://www.cxpartners.co.uk/thoughts/the_myth_of_the_page_fold_evidence_from_user_testing.htm" target="_blank">The myth of the page fold: evidence from user testing</a>&#8221; by <em>cxpartners</em>, where they found that &#8220;Stark, horizontal lines discourage scrolling&#8221;.</p>
<p>Last thing to note is that the <strong>first organic result is really close to the page fold</strong>, of course, it&#8217;s not paying <img src='http://arjuna.deltoso.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </p>
<p>I personally believe that a lot of these changes are aimed to <strong>increase the <a title="External link (new window)" href="http://en.wikipedia.org/wiki/Click-through_rate" target="_blank">CTR</a></strong> on the first 3 ads on google&#8217;s search results pages. What do you think?</p>
<p><em>Double disclaimer: if you have read this post up to here you may have guessed that I&#8217;m not so good in english, so report any error on the comments. More important, I&#8217;m not a interaction designer nor hci expert or wathever, these are only thought of a web programmer but I would like to know the opinion of the experts.</em></p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/google-pushes-advertisement-on-new-design/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>My configuration of xmonad window manager with xmobar and trayer</title>
		<link>http://arjuna.deltoso.net/articoli/my-configuration-of-xmonad-window-manager-with-xmobar-and-trayer/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/my-configuration-of-xmonad-window-manager-with-xmobar-and-trayer/en/#comments</comments>
		<pubDate>Wed, 12 Aug 2009 22:06:07 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[configuration]]></category>

		<category><![CDATA[window manager]]></category>

		<category><![CDATA[xmonad]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=242</guid>
		<description><![CDATA[I&#8217;ll write here my configuration of xmonad in order to find it easily in the future. xmonad is a dynamically tiling X11 window manager that is written             and configured in Haskell (http://xmonad.org/). I find xmonad really useful on systems with small screens and [...]]]></description>
			<content:encoded><![CDATA[<p>I&#8217;ll write here my configuration of xmonad in order to find it easily in the future. xmonad is a dynamically tiling X11 window manager that is written             and configured in Haskell (<a href="http://xmonad.org/" target="_blank">http://xmonad.org/</a>). I find xmonad really useful on systems with small screens and on laptops to avoid using the touchpad.</p>
<h3>Software</h3>
<ol>
<li><a href="http://xmonad.org/" target="_blank">xmonad</a> (0.8) - the window manager</li>
<li><a href="http://code.haskell.org/~arossato/xmobar/" target="_blank">xmobar</a> (0.9) - a status bar also in haskell</li>
<li>trayer (1.0) - small app for a systray</li>
<li><a href="http://linuxbrit.co.uk/feh/" target="_blank">feh</a> (1.3.4) -to set the background image</li>
<li>gdm, kmix, network-manager, &#8230;</li>
</ol>
<h3>How to install stuff</h3>
<p>You&#8217;ll find more or less all the software needed on the repositories of the distribution of your choice (if you use ubuntu, like me, this should install the window manager <em><code>apt-get install xmonad libghc6-xmonad-contrib-dev libghc6-xmonad-dev dwm-tools</code></em>).</p>
<h3>Configuration</h3>
<p>Following the config files of the various softwares:</p>
<p><strong>xmonad</strong> - <code>~/.xmonad/xmonad.hs</code></p>
<pre>import XMonad
import XMonad.Hooks.DynamicLog
import XMonad.Hooks.ManageDocks
import XMonad.Util.Run(spawnPipe)
import XMonad.Util.EZConfig(additionalKeys)
import System.IO

myManageHook = composeAll
    [ className =? "Gimp"      --&gt; doFloat
    , className =? "Vncviewer" --&gt; doFloat
    ]

main = do
    xmproc &lt;- spawnPipe "xmobar"
    xmonad $ defaultConfig
        { manageHook = manageDocks &lt;+&gt; myManageHook -- make sure to include myManageHook definition from above
                        &lt;+&gt; manageHook defaultConfig
        , layoutHook = avoidStruts  $  layoutHook defaultConfig
        , logHook = dynamicLogWithPP $ xmobarPP
                        { ppOutput = hPutStrLn xmproc
                        , ppTitle = xmobarColor "green" "" . shorten 50
                        }
        , modMask = mod4Mask     -- Rebind Mod to the Windows key
        } `additionalKeys`
        [ ((controlMask, xK_Print), spawn "sleep 0.2; scrot -s")
        , ((0, xK_Print), spawn "scrot")
        ]</pre>
<p><strong>xmobar</strong> - <code>~/.xmobarrc</code></p>
<pre>Config { font = "-misc-fixed-*-*-*-*-13-*-*-*-*-*-*-*"
       , bgColor = "black"
       , fgColor = "grey"
       , position = TopW L 85
       , commands = [ Run Network "wlan0" ["-L","0","-H","32","--normal","green","--high","red"] 10
                    , Run Cpu ["-L","15","-H","50","--normal","green","--high","red"] 10
                    , Run Memory ["-t","Mem: %"] 10
                    , Run Swap [] 10
                    , Run Date "%a %b %_d %Y %H:%M:%S" "date" 10
                    , Run StdinReader
                    ]
       , sepChar = "%"
       , alignSep = "}{"
       , template = "%StdinReader% }{ %cpu% | %memory% * %swap% | %wlan0% | %date%"
       }</pre>
<p><strong>gdm</strong> - <code>/usr/share/xsessions/xmonad.desktop</code></p>
<pre>[Desktop Entry]
Encoding=UTF-8
Name=XMonad
Comment=Leightweight tiling window manager
Exec=xmonad.start
Icon=xmonad.png
Type=XSession</pre>
<p><em>xmonad.start</em> is a custom script.</p>
<p><strong>xmonad.start</strong> - <code>/usr/local/bin/xmonad.start</code></p>
<pre>#!/bin/bash

xrdb -merge .Xresources

trayer --edge top --align right --SetDockType true --SetPartialStrut true --expand true --width 15 --height 12 --transparent true --tint 0x000000 &amp;

gnome-screensaver

gnome-settings-daemon

if [ -x /usr/bin/gnome-power-manager ] ; then
   sleep 1
   gnome-power-manager
fi

if [ -x /usr/bin/nm-applet ] ; then
   nm-applet --sm-disable &amp;
fi

kmix --keepvisibility

#feh --bg-scale /mnt/archivio/foto/2008-2009-dublino/2009-04-10-stefano/hapenny-desktop.jpg &amp;

exec xmonad</pre>
<p>Notes:</p>
<ul>
<li>using gnome-settings-daemon (i.e. for multimedia keys) the use of feh for setting the background image is <span class="clickable" onclick="dr4sdgryt(event,&quot;Ox&quot;)"><span class="sg"><span class="se1"><span class="trn">unnecessary.</span></span></span></span></li>
</ul>
<h3>Screenshots</h3>
<p>A screenshot of the desktop without applications (only xmonad and trayer), the background image is the Ha&#8217;Penny Bridge, Dublin, by <a href="http://www.panoramio.com/user/2081797" target="_blank">Steve</a>:</p>
<p><a href="http://arjuna.deltoso.net/wp-content/uploads/2009/08/2009-08-08-134614_1280x800_scrot.jpg"><img class="alignnone size-thumbnail wp-image-237" title="xmonad" src="http://arjuna.deltoso.net/wp-content/uploads/2009/08/2009-08-08-134614_1280x800_scrot-150x150.jpg" alt="" width="150" height="150" /></a></p>
<p>now with some apps:</p>
<p><a href="http://arjuna.deltoso.net/wp-content/uploads/2009/08/2009-08-08-142957_1280x800_scrot.jpg"><img class="alignnone size-thumbnail wp-image-239" title="xmonad, xmobar, traye, emacs, xterm, ..." src="http://arjuna.deltoso.net/wp-content/uploads/2009/08/2009-08-08-142957_1280x800_scrot-150x150.jpg" alt="" width="150" height="150" /></a></p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/my-configuration-of-xmonad-window-manager-with-xmobar-and-trayer/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>Ecofont, reduce ink consumption saving the green (and money)</title>
		<link>http://arjuna.deltoso.net/articoli/ecofont-reduce-ink-consumption-saving-the-green-and-money/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/ecofont-reduce-ink-consumption-saving-the-green-and-money/en/#comments</comments>
		<pubDate>Sat, 14 Feb 2009 17:52:32 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[font]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=227</guid>
		<description><![CDATA[Quick post only to point out a nice project of Spranq.nl called Ecofont. The aim of the project is to help people reducing the amount of ink used for printing, and save money too  
&#8220;The font produced uses up to 20% less ink&#8221; - they say. You can download it for free here http://www.ecofont.eu/downloads_en.html, [...]]]></description>
			<content:encoded><![CDATA[<p><img class="alignleft size-full wp-image-228" title="ecofont_logo_witte_bg" src="http://arjuna.deltoso.net/wp-content/uploads/2009/02/ecofont_logo_witte_bg.jpg" alt="" width="200" height="108" />Quick post only to point out a nice project of <a href="http://www.spranq.nl/" target="_blank">Spranq.nl</a> called <a href="http://www.ecofont.eu/ecofont_en.html" target="_blank">Ecofont</a>. The aim of the project is to help people reducing the amount of ink used for printing, and save money too <img src='http://arjuna.deltoso.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </p>
<p>&#8220;The font produced uses <a href="http://www.ecofont.eu/results.html" target="_blank">up to 20% less</a> ink&#8221; - they say. You can download it for free here <a href="http://www.ecofont.eu/downloads_en.html" target="_blank">http://www.ecofont.eu/downloads_en.html</a>, instructions on how to install under Linux can be found at this page <a href="http://www.ecofont.eu/linux_en.html" target="_blank">http://www.ecofont.eu/linux_en.html</a> (little tip: if you are on Ubuntu and don&#8217;t have <code>ttmkfdir</code> just <code>sudo apt-get install ttmkfdir</code> on a terminal).</p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/ecofont-reduce-ink-consumption-saving-the-green-and-money/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>Pligg Italian Language for version 9.9.5</title>
		<link>http://arjuna.deltoso.net/progetti/pligg-italian-language-for-version-995/en/</link>
		<comments>http://arjuna.deltoso.net/progetti/pligg-italian-language-for-version-995/en/#comments</comments>
		<pubDate>Wed, 28 Jan 2009 22:36:16 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[progetti]]></category>

		<category><![CDATA[language]]></category>

		<category><![CDATA[pligg]]></category>

		<category><![CDATA[translation]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=218</guid>
		<description><![CDATA[Pligg is a MYODLWSMS (Make Your Own Digg Like Web Site Management System) written in PHP and it is used to make digg-like websites (this can&#8217;t surprise you, right?).
Since I wasn&#8217;t able to find a translation into Italian, I made one by myself starting from a previous version (I can&#8217;t remember where I found that [...]]]></description>
			<content:encoded><![CDATA[<p><a title="Pligg Home Page" href="http://www.pligg.com/" target="_blank">Pligg</a> is a MYODLWSMS (Make Your Own Digg Like Web Site Management System) written in PHP and it is used to make <a title="Digg - A web site with something social" href="http://digg.com/" target="_blank">digg</a>-like websites (this can&#8217;t surprise you, right?).</p>
<p>Since I wasn&#8217;t able to find a translation into Italian, I made one by myself starting from a previous version (I can&#8217;t remember where I found that translation, if you recognize it as yours drop a message and I will give credit).</p>
<p>Here you can download the file:</p>
<h4><a href="http://file.deltoso.net/language_italian_pligg_9_9_5.zip">Pligg 9.9.5 Italian Translation</a></h4>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/progetti/pligg-italian-language-for-version-995/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>“The Fundamentals of Graphic Design” Wordpress Theme</title>
		<link>http://arjuna.deltoso.net/progetti/the-fundamentals-of-graphic-design-wordpress-theme-2/en/</link>
		<comments>http://arjuna.deltoso.net/progetti/the-fundamentals-of-graphic-design-wordpress-theme-2/en/#comments</comments>
		<pubDate>Wed, 24 Dec 2008 23:58:21 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[progetti]]></category>

		<category><![CDATA[design]]></category>

		<category><![CDATA[themes]]></category>

		<category><![CDATA[wordpress]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=153</guid>
		<description><![CDATA[Recently I have bought a book called &#8220;The Fundamentals of Graphic Design&#8221; by Gavin Ambrose &#38; Paul Harris  (AVA Academia).
Finding the design of the book interesting I used it as an inspiration for this wordpress theme.

The theme has been selected by Wordpress authors and now you can grab it from the official wordpress themes [...]]]></description>
			<content:encoded><![CDATA[<p>Recently I have bought a book called &#8220;<a href="http://www.avabooks.ch/index.php/ava/bookdetails/978-2-940373-82-6" target="_blank">The Fundamentals of Graphic Design</a>&#8221; by Gavin Ambrose &amp; Paul Harris  (AVA Academia).</p>
<p>Finding the design of the book interesting I used it as an inspiration for this wordpress theme.</p>
<p style="text-align: center;"><img class="aligncenter size-full wp-image-208" title="The Fundamentals of Graphics Design" src="http://arjuna.deltoso.net/wp-content/uploads/2009/01/screenshot.png" alt="" width="300" height="225" /></p>
<p style="text-align: left;">The theme has been selected by Wordpress authors and now you can grab it from the official wordpress themes directory: <a title="The Fundamentals of graphic design wordpress theme" href="http://wordpress.org/extend/themes/the-fundamentals-of-graphic-design">http://wordpress.org/extend/themes/the-fundamentals-of-graphic-design</a></p>
<p style="text-align: left;">The theme features:</p>
<ul>
<li> a <strong>widgetized</strong> bottom sidebar;</li>
<li><strong>excerpts</strong> exposed before the post content;</li>
<li><strong>hierachical</strong> categories;</li>
<li>customizable <strong>colors</strong> and blog <strong>position</strong>.</li>
</ul>
<p>For support please use the official wordpress forum at <a href="http://wordpress.org/tags/the-fundamentals-of-graphic-design?forum_id=10#postform" target="_blank">http://wordpress.org/tags/ the-fundamentals-of-graphic-design ?forum_id=10#postform</a></p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/progetti/the-fundamentals-of-graphic-design-wordpress-theme-2/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>Automatic Oracle 10g Startup and Shutdown at Ubuntu Linux system boot</title>
		<link>http://arjuna.deltoso.net/articoli/automatic-oracle-10g-startup-and-shutdown-at-ubuntu-linux-system-boot/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/automatic-oracle-10g-startup-and-shutdown-at-ubuntu-linux-system-boot/en/#comments</comments>
		<pubDate>Wed, 15 Oct 2008 13:09:56 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[Database]]></category>

		<category><![CDATA[linux]]></category>

		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=111</guid>
		<description><![CDATA[Set the restart flag to &#8220;Y&#8221; in /etc/oratab, from something like this
dbname:/u01/app/oracle/product/10.2.0/db_1:N
to something like
dbname:/u01/app/oracle/product/10.2.0/db_1:Y
Copy&#38;paste the boot script code that follows into /etc/init.d/dbora (the file dbora doesn&#8217;t exists, so create it) and modify the bold values to reflect your installation:
#!/bin/sh
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you [...]]]></description>
			<content:encoded><![CDATA[<p>Set the restart flag to &#8220;Y&#8221; in /etc/oratab, from something like this</p>
<p>dbname:/u01/app/oracle/product/10.2.0/db_1:<strong>N</strong></p>
<p>to something like</p>
<p>dbname:/u01/app/oracle/product/10.2.0/db_1:<strong>Y</strong></p>
<p>Copy&amp;paste the boot script code that follows into /etc/init.d/dbora (the file dbora doesn&#8217;t exists, so create it) and modify the bold values to reflect your installation:</p>
<pre>#!/bin/sh
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORACLE_HOME=<strong>/u01/app/oracle/product/10.2.0/db_1</strong>
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME PATH

ORA_HOME=<strong>/u01/app/oracle/product/10.2.0/db_1</strong>
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi

case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        su $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        su $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
        ;;
esac</pre>
<p>Assign proper script privileges:</p>
<p><code>chmod 750 /etc/init.d/dbora</code></p>
<p>Create the symbolic links related to boot runlevels [since I'm a long-time-Slackware-user and pretty new to Ubuntu, I'm not well versed about Ubuntu boot system so feel free to correct me (the comments are at the end of the post)]:</p>
<pre>ln -s /etc/init.d/dbora /etc/rc0.d/k01dbora
ln -s /etc/init.d/dbora /etc/rc1.d/k01dbora
ln -s /etc/init.d/dbora /etc/rc2.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc4.d/S99dbora</pre>
<p>at the end you should have something like this:</p>
<pre>lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc0.d/k01dbora -&gt; /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc1.d/k01dbora -&gt; /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc2.d/S99dbora -&gt; /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc3.d/S99dbora -&gt; /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc4.d/S99dbora -&gt; /etc/init.d/dbora</pre>
<p>Release 2 bug: inside /u01/app/oracle/product/10.2.0/db_1/bin/dbstart there is a bug that will prevent the listener to start (<em>Failed to auto-start Oracle Net Listener using /ade/vikrkuma_new/oracle/bin/tnslsnr</em>); to solve change line 78 from</p>
<pre>ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle/bin/tnslsnr</pre>
<p>to</p>
<pre>ORACLE_HOME_LISTNER=$ORACLE_HOME</pre>
<p><em>(in this article a modified version of the script at <a href="http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php" target="_blank">http://www.oracle-base.com/articles/linux/ AutomatingDatabaseStartupAndShutdownOnLinux.php</a>)</em></p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/automatic-oracle-10g-startup-and-shutdown-at-ubuntu-linux-system-boot/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>Auto increment Integer Value on Oracle Database (10g)</title>
		<link>http://arjuna.deltoso.net/articoli/auto-increment-integer-value-on-oracle-database-10g/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/auto-increment-integer-value-on-oracle-database-10g/en/#comments</comments>
		<pubDate>Mon, 22 Sep 2008 13:30:27 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[10g]]></category>

		<category><![CDATA[auto increment]]></category>

		<category><![CDATA[Database]]></category>

		<category><![CDATA[Oracle]]></category>

		<category><![CDATA[sequence]]></category>

		<category><![CDATA[trigger]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=99</guid>
		<description><![CDATA[Using databases it is often useful to have rows identified by a unique numeric value (mainly for ID columns), no matter what the value is. If, like me, you have a background of MySQL (where auto increment values are easy like saying AUTO_INCREMENT) but for some reasons you have to develop something on Oracle Database [...]]]></description>
			<content:encoded><![CDATA[<p>Using databases it is often useful to have rows identified by a <strong>unique numeric value</strong> (mainly for ID columns), no matter what the value is. If, like me, you have a background of <em>MySQL</em> (where auto increment values are easy like saying <a id="pax." title="Autoincrement on MySQL database" href="http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html" target="_blank">AUTO_INCREMENT</a>) but for some reasons you have to develop something on <a id="dwtr" title="Oracle Database 10g" href="http://www.oracle.com/technology/products/database/oracle10g/index.html" target="_blank">Oracle Database 10g</a> you&#8217;ll be a little confused about the lack of a single auto increment function.</p>
<p>Here is a simple <em>howto</em> on how to have an <strong>auto incremented numeric column value on Oracle Database</strong> using a <strong>sequence</strong> and a <strong>trigger</strong> (if you find some errors please use the comments):</p>
<p><em>Tested on: Oracle Database 10g Enterprise Edition</em><br id="hfwk" /> <br id="hfwk0" /> <em>Precondition: a numeric type (INTEGER is ok) column in a table (in this example the schema is PROVA01 and the table is UTENTI with ID as column).</em></p>
<ol>
<li id="es640"> Log in Oracle Enterprise Manager (probably http://servername:1158/em/) as     user with proper privileges (SYS as SYSDBA will work);</li>
<li id="ka.n"> Go to &#8220;Administration&#8221;;</li>
<li id="ka.n0"> Under &#8220;Schemas &gt; Database Objects&#8221; open &#8220;Sequence&#8221;;</li>
<li id="auwc"> Select proper schema (in this how to is <em>PROVA01</em>, the table is <em>UTENTI</em> and the field is <em>ID</em>);</li>
<li id="v9bb"> Create a new sequence by filling:
<ol>
<li id="e:5c0"> Name: choose a name, something like <em>UTENTI_ID</em>_SEQ should be fine;</li>
<li id="e:5c0"> Schema: select PROVA01;</li>
<li id="e:5c0">Max value: no limit;</li>
<li id="e:5c0">Min value: enter value 1;</li>
<li id="e:5c0">Increment: 1;</li>
<li id="e:5c0">Start: 1;</li>
<li id="e:5c0">De-select &#8220;Use Cache&#8221;</li>
<li id="e:5c0">When done click &#8220;OK&#8221; button <em>(the screenshot is in italian)</em><br />
<a href="http://arjuna.deltoso.net/wp-content/uploads/2008/09/oracle_sequence.png"><img class="alignnone size-medium wp-image-100" title="oracle_sequence" src="http://arjuna.deltoso.net/wp-content/uploads/2008/09/oracle_sequence-218x300.png" alt="" width="218" height="300" /></a></li>
</ol>
</li>
<li>Return back to administration page and go to &#8220;Programs &gt; Triggers&#8221; and create a new trigger:
<ol>
<li>Name: TRIGGER_SEQ_UTENTI is a good choice;</li>
<li>Schema: PROVA01;</li>
<li>Select &#8220;Replace if exists&#8221;</li>
<li>Trigger body (in bold values you may change):
<pre>BEGIN
SELECT <strong>UTENTI_ID_SEQ</strong>.NEXTVAL
INTO   :NEW.<strong>ID</strong>
FROM   DUAL;
END <strong>UTENTE_SEQ_TRIGGER</strong>;</pre>
</li>
<li>Go to &#8220;Event&#8221; tab and configure the trigger:
<ol>
<li>&#8220;Execute the trigger&#8221; on Table;</li>
<li>Table: in this case PROVA01.UTENTI;</li>
<li>Start trigger: before;</li>
<li>Event: INSERT;</li>
</ol>
</li>
<li>Go to &#8220;Advanced&#8221; and select &#8220;FOR EACH ROW&#8221;;</li>
</ol>
</li>
<li>Save the trigger and, if any, check out the errors.</li>
</ol>
<p>Test the sequence and trigger by inserting a new table row, the ID value will be auto-inserted (and incremented).</p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/auto-increment-integer-value-on-oracle-database-10g/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>A List Apart - Survey 2008 for people who make web sites</title>
		<link>http://arjuna.deltoso.net/articoli/a-list-apart-survey-2008-for-people-who-make-web-sites/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/a-list-apart-survey-2008-for-people-who-make-web-sites/en/#comments</comments>
		<pubDate>Thu, 07 Aug 2008 12:06:15 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[A Lists Apart]]></category>

		<category><![CDATA[Survey]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=80</guid>
		<description><![CDATA[Last year nearly 33,000 developers, designers, editors, &#8230; took the survey. Now it&#8217;s out the 2008 edition.

The data gathered by the 2007 Survey spotlighted the identikit of the &#8220;person who make web sites&#8221;: male (82,8%) white (84,6%), aged between 25 and 32 years (43,6%), from United States (48,1%) and developer (25,3%).
The full findings are available [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.alistapart.com/articles/webdesignsurvey" target="_blank">Last year</a> nearly 33,000 developers, designers, editors, &#8230; took the survey. Now it&#8217;s out the 2008 edition.</p>
<p style="text-align: center;"><a href="http://www.alistapart.com/articles/survey2008"><img class="aligncenter size-full wp-image-78" title="i-took-the-2008-survey" src="http://arjuna.deltoso.net/wp-content/uploads/2008/08/i-took-the-2008-survey.gif" alt="" width="180" height="46" /></a></p>
<p>The data gathered by the 2007 Survey <span onclick="dr4sdgryt(event)">spotlight</span>ed the identikit of the &#8220;person who make web sites&#8221;: male (82,8%) white (84,6%), aged between 25 and 32 years (43,6%), from United States (48,1%) and developer (25,3%).</p>
<p>The full findings are available here <a href="http://www.alistapart.com/articles/2007surveyresults" target="_blank">http://www.alistapart.com/articles/2007surveyresults</a>.</p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/a-list-apart-survey-2008-for-people-who-make-web-sites/en/feed/en/</wfw:commentRss>
		</item>
		<item>
		<title>Load the MeSH vocabulary into a MySQL database. A simple script.</title>
		<link>http://arjuna.deltoso.net/articoli/load-the-mesh-vocabulary-into-a-mysql-database-a-simple-script/en/</link>
		<comments>http://arjuna.deltoso.net/articoli/load-the-mesh-vocabulary-into-a-mysql-database-a-simple-script/en/#comments</comments>
		<pubDate>Sat, 19 Apr 2008 19:07:24 +0000</pubDate>
		<dc:creator>Arjuna Del Toso</dc:creator>
		
		<category><![CDATA[articoli]]></category>

		<category><![CDATA[java]]></category>

		<category><![CDATA[mesh]]></category>

		<category><![CDATA[programming]]></category>

		<guid isPermaLink="false">http://arjuna.deltoso.net/?p=30</guid>
		<description><![CDATA[A simple script written in Java to load the MeSH terms into a MySQL database.
This script simply loads the MeSH terms (the value of &#8220;/DescriptorRecordSet &#62; DescriptorRecord &#62; DescriptorName &#62; String&#8221; XML tag) that can be found in the MeSH XML formatted version of the vocabulay (http://www.nlm.nih.gov/mesh/filelist.html) into a MySQL relational database.
Download the script or [...]]]></description>
			<content:encoded><![CDATA[<p><em>A simple script written in <a title="Java Programming Language" href="http://www.java.com" target="_blank">Java</a> to load the <a title="MeSH Home Page" href="http://www.nlm.nih.gov/mesh/meshhome.html" target="_blank">MeSH</a> terms into a <a title="MySQL Home Page" href="http://www.mysql.com/" target="_blank">MySQL</a> database.</em></p>
<p>This script simply loads the <strong>MeSH terms</strong> (the value of &#8220;<code>/DescriptorRecordSet &gt; DescriptorRecord &gt; DescriptorName &gt; String</code>&#8221; XML tag) that can be found in the MeSH XML formatted version of the vocabulay (<a title="Download MeSH vocabulary" href="http://www.nlm.nih.gov/mesh/filelist.html" target="_blank">http://www.nlm.nih.gov/mesh/filelist.html</a>) into a MySQL relational database.</p>
<p><a href="http://arjuna.deltoso.net/wp-content/uploads/2008/07/mesh2database.zip">Download the script</a> or read it:</p>
<div class="highlight">
<pre><span style="font-style: italic; color: #60a0b0;">/**</span>
<span style="font-style: italic; color: #60a0b0;"> * @author Arjuna Del Toso</span>
<span style="font-style: italic; color: #60a0b0;"> * @url http://arjuna.deltoso.net/</span>
<span style="font-style: italic; color: #60a0b0;"> * </span>
<span style="font-style: italic; color: #60a0b0;"> * @FAQ: what the hell is this?</span>

<span style="font-style: italic; color: #60a0b0;"> * A simple, very simple, program to load the MESH Terms to a MySQL database</span>
<span style="font-style: italic; color: #60a0b0;"> * </span>
<span style="font-style: italic; color: #60a0b0;"> * @USAGE</span>
<span style="font-style: italic; color: #60a0b0;"> * 1-configure some stuff in the code ("//: CHANGE A VALUE HERE" string is a placeholder for what to change);</span>
<span style="font-style: italic; color: #60a0b0;"> * 2-install the required packages (jdbc connector [http://www.mysql.com/products/connector/j/] and dom4j [http://www.dom4j.org/]);</span>
<span style="font-style: italic; color: #60a0b0;"> * 3-compile it ($javac mesh2database.java);</span>

<span style="font-style: italic; color: #60a0b0;"> * 4-put the MESH Descriptor XML file and the MESH Descriptor DTD file in the current directory;</span>
<span style="font-style: italic; color: #60a0b0;"> * 5-run the program ($java mesh2database) and wait;</span>
<span style="font-style: italic; color: #60a0b0;"> * 6-enjoy the 20.000+ records inserted in your database.</span>
<span style="font-style: italic; color: #60a0b0;"> * </span>
<span style="font-style: italic; color: #60a0b0;"> */</span>

<span style="font-style: italic; color: #60a0b0;">// Some imports in order to run this program; you need</span>

<span style="font-style: italic; color: #60a0b0;">// the jdbc driver for connecting to MySQL database</span>
<span style="font-style: italic; color: #60a0b0;">// and the dom4j package for XML manipulation</span>
import java.io.<span style="color: #666666;">F</span>ile<span style="color: #666666;">;</span>
import org.dom4j.<span style="color: #666666;">D</span>ocument<span style="color: #666666;">;</span>
import org.dom4j.<span style="color: #666666;">D</span>ocumentException<span style="color: #666666;">;</span>

import org.dom4j.<span style="color: #666666;">E</span>lement<span style="color: #666666;">;</span>
import org.dom4j.<span style="color: #666666;">E</span>lementHandler<span style="color: #666666;">;</span>
import org.dom4j.<span style="color: #666666;">E</span>lementPath<span style="color: #666666;">;</span>
import org.dom4j.io.<span style="color: #666666;">SAXR</span>eader<span style="color: #666666;">;</span>

import java.sql.<span style="color: #666666;">*;</span>

<span style="font-style: italic; color: #60a0b0;">// a very fanciful name</span>
public class mesh2database {

	<span style="font-style: italic; color: #60a0b0;">// all work done here</span>
	public static void main(<span style="color: #666666;">S</span>tring<span style="color: #666666;">[</span>] args) throws <span style="color: #666666;">SQLE</span>xception {

		<span style="font-style: italic; color: #60a0b0;">// load the jdbc driver</span>

		<span style="font-weight: bold; color: #007020;">try</span> {
			<span style="color: #666666;">C</span>lass.forName(<span style="color: #4070a0;">"com.mysql.jdbc.Driver"</span>).newInstance();
		} <span style="font-weight: bold; color: #007020;">catch</span> (<span style="color: #666666;">I</span>nstantiationException e1) {
		} <span style="font-weight: bold; color: #007020;">catch</span> (<span style="color: #666666;">I</span>llegalAccessException e1) {
		} <span style="font-weight: bold; color: #007020;">catch</span> (<span style="color: #666666;">C</span>lassNotFoundException e1) {}

		<span style="font-style: italic; color: #60a0b0;">// the connection to mysql db</span>

<span style="font-style: italic; color: #60a0b0;">//: CHANGE A VALUE HERE</span>
<span style="font-style: italic; color: #60a0b0;">//: set your database values</span>
		final <span style="color: #666666;">C</span>onnection con <span style="color: #666666;">=</span> <span style="color: #666666;">D</span>riverManager.getConnection(<span style="color: #4070a0;">"jdbc:mysql://localhost/table"</span><span style="color: #666666;">,</span> <span style="color: #4070a0;">"user"</span><span style="color: #666666;">,</span> <span style="color: #4070a0;">"password"</span>);
		<span style="font-style: italic; color: #60a0b0;">// a preparedStatement in the hope to improve speed</span>

<span style="font-style: italic; color: #60a0b0;">//: CHANGE A VALUE HERE</span>
<span style="font-style: italic; color: #60a0b0;">//: configure to match your database schema</span>
		final <span style="color: #666666;">P</span>reparedStatement s <span style="color: #666666;">=</span> con.prepareStatement(<span style="color: #4070a0;">"INSERT IGNORE INTO `table`.`mesh` (`id` , `mesh` ) VALUES (NULL , ?)"</span>);

		<span style="font-style: italic; color: #60a0b0;">// the MESH Descriptors XML file,</span>
		<span style="font-style: italic; color: #60a0b0;">// can be found at http://www.nlm.nih.gov/mesh/</span>

<span style="font-style: italic; color: #60a0b0;">//: CHANGE A VALUE HERE</span>
<span style="font-style: italic; color: #60a0b0;">//: insert the path to your mesh file</span>
		<span style="color: #666666;">F</span>ile file <span style="color: #666666;">=</span> <span style="font-weight: bold; color: #007020;">new</span> <span style="color: #666666;">F</span>ile(<span style="color: #4070a0;">"desc2007"</span>);

		<span style="font-style: italic; color: #60a0b0;">// enable pruning mode to call me back as each node is complete</span>

		<span style="color: #666666;">SAXR</span>eader reader <span style="color: #666666;">=</span> <span style="font-weight: bold; color: #007020;">new</span> <span style="color: #666666;">SAXR</span>eader(<span style="font-weight: bold; color: #007020;">false</span>);

		reader.addHandler( <span style="color: #4070a0;">"/DescriptorRecordSet/DescriptorRecord/DescriptorName/String"</span><span style="color: #666666;">,</span>
				<span style="font-weight: bold; color: #007020;">new</span> <span style="color: #666666;">E</span>lementHandler() {
			public void onStart(<span style="color: #666666;">E</span>lementPath path) {}
			public void onEnd(<span style="color: #666666;">E</span>lementPath path) {
				<span style="font-style: italic; color: #60a0b0;">// process a single element</span>

				<span style="color: #666666;">E</span>lement meshDescriptorValue <span style="color: #666666;">=</span> path.getCurrent();
				<span style="color: #666666;">E</span>lement descname <span style="color: #666666;">=</span> meshDescriptorValue.getParent();
				<span style="color: #666666;">E</span>lement descrecord <span style="color: #666666;">=</span> descname.getParent();

				<span style="font-style: italic; color: #60a0b0;">// remove .toLowerCase() if you are Case Sensitive <img src='http://arjuna.deltoso.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </span>

				<span style="color: #666666;">S</span>tring meshHeading <span style="color: #666666;">=</span> meshDescriptorValue.getText().toLowerCase();

				<span style="font-style: italic; color: #60a0b0;">// i just don't want something like</span>
				<span style="font-style: italic; color: #60a0b0;">// "DNA Degradation, Apoptotic"</span>
				<span style="font-style: italic; color: #60a0b0;">// as single record in my database</span>
				<span style="font-weight: bold; color: #007020;">if</span>(<span style="color: #666666;">!</span>meshHeading.contains(<span style="color: #4070a0;">","</span>)){

					<span style="font-style: italic; color: #60a0b0;">// simple debug code (outputs the MESH DESCRIPTORS) </span>

					<span style="color: #666666;">S</span>ystem.out.println(meshHeading);

					<span style="font-style: italic; color: #60a0b0;">// the database INSERTs executed here</span>
					<span style="font-weight: bold; color: #007020;">try</span> {
						<span style="font-style: italic; color: #60a0b0;">// insert current value in the preparedStatement</span>
						s.setString(<span style="color: #40a070;">1</span><span style="color: #666666;">,</span> meshHeading);
						<span style="font-style: italic; color: #60a0b0;">// execute the statement</span>

						s.executeUpdate();
					} <span style="font-weight: bold; color: #007020;">catch</span> (<span style="color: #666666;">SQLE</span>xception e1) {}
				}
				<span style="font-style: italic; color: #60a0b0;">// prune the tree</span>
				descrecord.detach();
			}
		}
		);

		<span style="font-style: italic; color: #60a0b0;">// just reading the file will do all the work</span>
		<span style="font-weight: bold; color: #007020;">try</span> {
			<span style="color: #666666;">D</span>ocument <span style="color: #007020;">document</span> <span style="color: #666666;">=</span> reader.read(file);
		} <span style="font-weight: bold; color: #007020;">catch</span> (<span style="color: #666666;">D</span>ocumentException e) {}

		<span style="font-style: italic; color: #60a0b0;">// closing statement and connection</span>

		s.close();
		con.close();
	}

}</pre>
</div>
<p>In order to run this script you need the <a title="Download Java compiler" href="http://java.sun.com/" target="_blank">Java compiler</a>, the <a title="MeSH on XML file" href="http://www.nlm.nih.gov/mesh/filelist.html" target="_blank">MeSH XML file</a>, a <strong>MySQL installation</strong> and <em>two java libraries</em>: <a title="MySQL Java Connector" href="http://www.mysql.com/products/connector/j/" target="_blank">MySQL Connector/J</a> and <a title="DOM4J" href="http://www.dom4j.org/" target="_blank">dom4j</a>.</p>
]]></content:encoded>
			<wfw:commentRss>http://arjuna.deltoso.net/articoli/load-the-mesh-vocabulary-into-a-mysql-database-a-simple-script/en/feed/en/</wfw:commentRss>
		</item>
	</channel>
</rss>
