Re: Re: Help! License is...

anthony berglas <[email protected]> Thu, 3 Jan 2013 10:55:12 +1000
Newsgroups gmane.comp.java.orm.simpleorm
Message-ID <CA+_PZMe2Ec6Q4YGvUUyrh0rzmSc-bQbVVF-BV9nz_5SjYPCTNg@mail.gmail.com>
--e89a8fb1f6c81eeb8104d257d345
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Hello John,

Sounds like you have a really interesting project.  I had always thought of
SimpleOrm as mainly for CRUDy applications with lots of single row updates,
it is interesting that you are using it more for its data sets.  One thing
that I would like to add to SimpleOrm is to be able to output a Data Set as
CSV.  That should be really easy to do.

Thanks for the info.

Anthony

On Thu, Jan 3, 2013 at 10:07 AM, <[email protected]> wrote:

> **
>
>
> Thanks Anthony.
>
> I see the license requires me to tell you that we are using SimpleORM in
> the PECAS software for spatial economic modelling and forecasting. PECAS =
is
> used by public agencies for long-range planning of land use and
> transportation, in particular land use regulations and transportation
> infrastructure and services provision.
>
> http://www.hbaspecto.com/pecas/
>
> One of the two main PECAS modules is the Space Development (SD) module,
> which annually considers each bit of land (legal parcel or grid cell) and
> uses a monte-carlo simulation (ie. random number generator with probabili=
ty
> functions) to select developer actions for each bit of land. Developers a=
re
> more likely to build specific types of buildings on specific bits of land
> that 1) are in desireable locations (i.e. can be rented out at a good
> price), 2) can be constructed cheaply, and 3) are allowed (or not
> discouraged) by the regulations.
>
> SD uses three threads, one thread grabs groups of parcels and puts them i=
n
> a SimpleORM dataset. Another thread grabs the "local effect distances" fo=
r
> the group the parcels, which is very time consuming depending on the
> indexing and clustering in the database. These local effect distances are
> things like distance to a major road, distance to a major transit station=
,
> distance to the beach, that make a parcel more or less desireable for
> certain uses. The third thread processes the parcels, and ends up using t=
he
> internal simpleorm indices and caches to get the attributes that have
> already been retrieved into memory by the other two threads.
>
> Since updates and inserts are so slow in most databases (e.g. PostgreSQL)=
,
> we batch all of them into a separate process. We process all the parcels
> and write out the list of changes and inserts to a text file, then apply
> the full list of changes directly with a database query. (So we rarely us=
e
> SimpleORM to write data to the database.)
>
> Speed is important, since we are processing millions of parcels in each
> year of a 30 year simulation run. Clarity of code is important, partly
> because speed is important but also because we like to test internal
> mathematics and logic using the java debugger.
>
> The other PECAS module, "Activity Allocation (AA)", reads everything into
> memory and then undertakes a computationally intensive search process to
> solve for the annual spatial economic equilibrium, then writes out the
> output files. Currently it uses CSV files, rather than a database, since
> the data flow is so simple. A big advantage of CSV files is we can versio=
n
> control them using subversion. But someday we may use a database (and
> SimpleORM) for AA as well.
>
>
> --- In [email protected], anthony berglas <anthony@...> wrote:
> >
> > Hello John,
> >
> > I have attached the Copyright notice from the source.
> >
> > I'd be interested to know something about the project you use SimpleOrm
> > for, and how you use it, and any general feedback.
> >
> > Anthony
> >
> > On Fri, Dec 21, 2012 at 8:35 AM, <jea@...> wrote:
> >
> > > **
>
> > >
> > >
> > > A client has asked me to specify the libraries I use and their
> licenses,
> > > to ensure that I have permission to release my entire project under
> Apache
> > > V2.
> > >
> > > On the SimpleORM website is says "Apache style license". I can't find
> any
> > > documentation of the actual license used... If you haven't decided,
> then
> > > Apache V2 would be the most convenient.
> > >
> > > Thanks for your (hopefully prompt) response!
> > >
> > > --
> > > John
> > >
> > >
> > >
> >
> >
> >
> > --
> >
> > Dr Anthony Berglas, anthony@... Mobile: +61 4 4838 8874
>
> > Just because it is possible to push twigs along the ground with ones no=
se
> > does not necessarily mean that that is the best way to collect firewood=
.
> >
>
>=20=20
>



--=20

Dr Anthony Berglas, [email protected]       Mobile: +61 4 4838 8874
Just because it is possible to push twigs along the ground with ones nose
does not necessarily mean that that is the best way to collect firewood.

--e89a8fb1f6c81eeb8104d257d345
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable





<head>

<style type=3D"text/css">
<!--

/* start of attachment style */
       .ygrp-photo-title{
         clear: both;
         font-size: smaller;
         height: 15px;
         overflow: hidden;
         text-align: center;
         width: 75px;
       }
       div.ygrp-photo{
         background-position: center;
         background-repeat: no-repeat;
         background-color: white;
         border: 1px solid black;
         height: 62px;
         width: 62px;
       }

       div.photo-title=20
         a,
         div.photo-title a:active,
         div.photo-title a:hover,
         div.photo-title a:visited {
           text-decoration: none;=20
       }

       div.attach-table div.attach-row {
         clear: both;
       }

       div.attach-table div.attach-row div {
         float: left;
         /* margin: 2px;*/
       }

       p {
         clear: both;
         padding: 15px 0 3px 0;
	 overflow: hidden;
       }

       div.ygrp-file {
         width: 30px;
         valign: middle;
       }
       div.attach-table div.attach-row div div a {
         text-decoration: none;
       }

       div.attach-table div.attach-row div div span {
         font-weight: normal;
       }

       div.ygrp-file-title {
         font-weight: bold;
       }
 /* end of attachment style */
        -->
        </style>
        </head>
<html>
<head>
<style type=3D"text/css">
<!--
#ygrp-mkp {
  border: 1px solid #d8d8d8;
  font-family: Arial;
  margin: 10px 0;
  padding: 0 10px;
}

#ygrp-mkp hr {
  border: 1px solid #d8d8d8;
}

#ygrp-mkp #hd {
  color: #628c2a;
  font-size: 85%;
  font-weight: 700;
  line-height: 122%;
  margin: 10px 0;
}

#ygrp-mkp #ads {
  margin-bottom: 10px;
}

#ygrp-mkp .ad {
  padding: 0 0;
}

#ygrp-mkp .ad p {
  margin: 0;
}

#ygrp-mkp .ad a {
  color: #0000ff;
  text-decoration: none;
}
-->
</style>
</head>
<body>





Hello John,<div><br></div><div>Sounds like you have a really interesting pr=
oject. =A0I had always thought of SimpleOrm as mainly for CRUDy application=
s with lots of single row updates, it is interesting that you are using it =
more for its data sets. =A0One thing that I would like to add to SimpleOrm =
is to be able to output a Data Set as CSV. =A0That should be really easy to=
 do.</div>

<div><br></div><div>Thanks for the info.</div><div><br></div><div>Anthony</=
div><div><br><div class=3D"gmail_quote">On Thu, Jan 3, 2013 at 10:07 AM,  <=
span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=3D"_blank"=
>[email protected]</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">


<u></u>










<div style>
<span>=A0</span>


<div>
  <div>


    <div>
=20=20=20=20=20=20
=20=20=20=20=20=20
      <p>Thanks Anthony.<br>
<br>
I see the license requires me to tell you that we are using SimpleORM in th=
e PECAS software for spatial economic modelling and forecasting.  PECAS is =
used by public agencies for long-range planning of land use and transportat=
ion, in particular land use regulations and transportation infrastructure a=
nd services provision.<br>


<br>
<a href=3D"http://www.hbaspecto.com/pecas/" target=3D"_blank">http://www.hb=
aspecto.com/pecas/</a><br>
<br>
One of the two main PECAS modules is the Space Development (SD) module, whi=
ch annually considers each bit of land (legal parcel or grid cell) and uses=
 a monte-carlo simulation (ie. random number generator with probability fun=
ctions) to select developer actions for each bit of land.  Developers are m=
ore likely to build specific types of buildings on specific bits of land th=
at 1) are in desireable locations (i.e. can be rented out at a good price),=
 2) can be constructed cheaply, and 3) are allowed (or not discouraged) by =
the regulations.<br>


<br>
SD uses three threads, one thread grabs groups of parcels and puts them in =
a SimpleORM dataset.  Another thread grabs the &quot;local effect distances=
&quot; for the group the parcels, which is very time consuming depending on=
 the indexing and clustering in the database.  These local effect distances=
 are things like distance to a major road, distance to a major transit stat=
ion, distance to the beach, that make a parcel more or less desireable for =
certain uses.  The third thread processes the parcels, and ends up using th=
e internal simpleorm indices and caches to get the attributes that have alr=
eady been retrieved into memory by the other two threads.<br>


<br>
Since updates and inserts are so slow in most databases (e.g. PostgreSQL), =
we batch all of them into a separate process.  We process all the parcels a=
nd write out the list of changes and inserts to a text file, then apply the=
 full list of changes directly with a database query. (So we rarely use Sim=
pleORM to write data to the database.)<br>


<br>
Speed is important, since we are processing millions of parcels in each yea=
r of a 30 year simulation run.  Clarity of code is important, partly becaus=
e speed is important but also because we like to test internal mathematics =
and logic using the java debugger.<br>


<br>
The other PECAS module, &quot;Activity Allocation (AA)&quot;, reads everyth=
ing into memory and then undertakes a computationally intensive search proc=
ess to solve for the annual spatial economic equilibrium, then writes out t=
he output files. Currently it uses CSV files, rather than a database, since=
 the data flow is so simple.  A big advantage of CSV files is we can versio=
n control them using subversion.  But someday we may use a database (and Si=
mpleORM) for AA as well.</p>

<div class=3D"im"><br>
<br>
--- In <a href=3D"mailto:SimpleORM%40yahoogroups.com" target=3D"_blank">Sim=
[email protected]</a>, anthony berglas &lt;anthony@...&gt; wrote:<br>
&gt;<br>
&gt; Hello John,<br>
&gt; <br>
&gt; I have attached the Copyright notice from the source.<br>
&gt; <br>
&gt; I&#39;d be interested to know something about the project you use Simp=
leOrm<br>
&gt; for, and how you use it, and any general feedback.<br>
&gt; <br>
&gt; Anthony<br>
&gt; <br></div>
&gt; On Fri, Dec 21, 2012 at 8:35 AM, &lt;jea@...&gt; wrote:<br>
&gt; <br>
&gt; &gt; **<div class=3D"im"><br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; A client has asked me to specify the libraries I use and their li=
censes,<br>
&gt; &gt; to ensure that I have permission to release my entire project und=
er Apache<br>
&gt; &gt; V2.<br>
&gt; &gt;<br>
&gt; &gt; On the SimpleORM website is says &quot;Apache style license&quot;=
. I can&#39;t find any<br>
&gt; &gt; documentation of the actual license used... If you haven&#39;t de=
cided, then<br>
&gt; &gt; Apache V2 would be the most convenient.<br>
&gt; &gt;<br>
&gt; &gt; Thanks for your (hopefully prompt) response!<br>
&gt; &gt;<br>
&gt; &gt; --<br>
&gt; &gt; John<br>
&gt; &gt;<br>
&gt; &gt;  <br>
&gt; &gt;<br>
&gt; <br>
&gt; <br>
&gt; <br></div>
&gt; -- <br>
&gt; <br>
&gt; Dr Anthony Berglas, anthony@...       Mobile: <a href=3D"tel:%2B61%204=
%204838%208874" value=3D"+61448388874" target=3D"_blank">+61 4 4838 8874</a=
><div class=3D"im"><br>
&gt; Just because it is possible to push twigs along the ground with ones n=
ose<br>
&gt; does not necessarily mean that that is the best way to collect firewoo=
d.<br>
&gt;<br>
<br>
</div><p></p>

    </div>
=20=20=20=20=20

=20=20=20=20
    <div style=3D"color:#fff;min-height:0"></div>


</div>



=20=20






</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><p>
</p><p>Dr Anthony Berglas, <a href=3D"mailto:[email protected]" target=3D=
"_blank">[email protected]</a>=A0=A0=A0=A0=A0=A0 Mobile: +61 4 4838 8874<=
br>
Just because it is possible to push twigs along the ground with ones nose<b=
r>
does not necessarily mean that that is the best way to collect firewood.</p=
>
</div>




<!-- |**|begin egp html banner|**| -->

<br>

=20=20=20=20
=20=20=20=20
<br>

<!-- |**|end egp html banner|**| -->


<div width=3D"1" style=3D"color: white; clear: both;"/>__._,_.___</div>

<!-- Start Recommendations -->
<!-- End Recommendations -->



<!-- |**|begin egp html banner|**| -->

  <img src=3D"http://geo.yahoo.com/serv?s=3D97476590/grpId=3D7360226/grpspI=
d=3D1705006905/msgId=3D2067/stime=3D1357174554" width=3D"1" height=3D"1"> <=
br>

<!-- |**|end egp html banner|**| -->

=20=20
<!-- |**|begin egp html banner|**| -->

<br>
      <div style=3D"font-family: verdana; font-size: 77%; border-top: 1px s=
olid #666; padding: 5px 0;" >
      Your email settings: Individual Email|Traditional <br>
      <a href=3D"http://groups.yahoo.com/group/SimpleORM/join;_ylc=3DX3oDMT=
JmNXVwdDRhBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlY=
wNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzNTcxNzQ1NTQ-">Change settings via the Web</a=
> (Yahoo! ID required) <br>
      Change settings via email: <a href=3D"mailto:SimpleORM-digest@yahoogr=
oups.com?subject=3DEmail Delivery: Digest">Switch delivery to Daily Digest<=
/a> | <a href =3D "mailto:[email protected]?subject=3D=
Change Delivery Format: Fully Featured">Switch to Fully Featured</a> <br>
           <a href=3D"http://groups.yahoo.com/group/SimpleORM;_ylc=3DX3oDMT=
JkM2NwNXNlBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlY=
wNmdHIEc2xrA2hwZgRzdGltZQMxMzU3MTc0NTU0">
        Visit Your Group=20
      </a> |
      <a href=3D"http://docs.yahoo.com/info/terms/">
        Yahoo! Groups Terms of Use
      </a> |
      <a href=3D"mailto:[email protected]?subject=3DUns=
ubscribe">
       Unsubscribe=20
      </a>=20
 <br>
    </div>
  <br>

<!-- |**|end egp html banner|**| -->


<div style=3D"color: white; clear: both;"/>__,_._,___</div>
</body>

</html>

--e89a8fb1f6c81eeb8104d257d345--