#11587: update Cremona's tables for Sage
-------------------------------+--------------------------------------------
Reporter: was | Owner: cremona
Type: enhancement | Status: needs_review
Priority: major | Milestone: sage-4.7.2
Component: elliptic curves | Keywords:
Work_issues: | Upstream: N/A
Reviewer: John Cremona | Author:
Merged: | Dependencies:
-------------------------------+--------------------------------------------
Changes (by rohana):
* status: needs_info => needs_review
Old description:
> John Cremona tells me that: "All data for elliptic curves of conductors
> from 130k to 170k is at
> http://www.warwick.ac.uk/staff/J.E.Cremona/ftp/data/ and also as a tar
> file at
> http://www.warwick.ac.uk/staff/J.E.Cremona/ftp/ecdata-2011-07-26.tgz
> -- not to mention at http://code.google.com/p/ecdata/ !"
>
> The goal of this ticket is to:
>
> (1) Create a new drop-in-replacement sqlite database that has the data up
> to level 10000, which will be included standard with Sage.
>
> (2) Create a new sqlite database that has the data up to level 170000,
> which will be an optional spkg.
>
> This is complicated because the current packages in Sage use ZODB. Also,
> Cremona's database format has changed somewhat.
>
> There is now a patch that depends upon #11642
New description:
John Cremona tells me that: "All data for elliptic curves of conductors
from 130k to 170k is at
http://www.warwick.ac.uk/staff/J.E.Cremona/ftp/data/ and also as a tar
file at
http://www.warwick.ac.uk/staff/J.E.Cremona/ftp/ecdata-2011-07-26.tgz
-- not to mention at http://code.google.com/p/ecdata/ !"
The goal of this ticket is to:
(1) Create a new drop-in-replacement sqlite database that has the data up
to level 10000, which will be included standard with Sage.
(2) Create a new sqlite database that has the data up to level 170000,
which will be an optional spkg.
This is complicated because the current packages in Sage use ZODB. Also,
Cremona's database format has changed somewhat.
There is now a patch that depends upon #11642 (which depends upon #11640).
You can find updated elliptic_curve and database_cremona_ellcurve spkgs at
http://wstein.org/home/ohanar/cremona-database
--
Comment:
Replying to [comment:5 cremona]:
> There are two spkgs at the link, and one patch on this ticket. Please
can you explain how they are related?
The patch updates sage.databases.cremona to wrap the new SQLite databases.
It provides about the same functionality as the old ZODB (there are some
slight modifications to actually reflect the documentation, which wasn't
respected before -- specifically the mini-database only has data from
allcurves).
> Is one of the spkgs intended to be part of the standard Sage
distribution so that every copy of Sage has the mini-database, as is the
case now? And is the other one a replacement for the optional large
database?
Correct. The elliptic_curve spkg is included every copy of sage, and
includes both the mini-database, as well as a very small database of
curves William finds interesting. The database_cremona_ellcurve spkg
includes (most of) the data from allcurves, allgens, allbsd, and degphi
for every curve that you have listed.
> Secondly, you warn that the database takes some time to create. Is this
once-only time which you had to spend in creating the database which is
part of the spkg, or is it time which must be spent by anyone installing
the large optional spkg?
Currently the spkgs simply install pre-built SQL databases, so currently
this is a once-only thing. That said, on my home system it only takes
~4mins to create the database from scratch.
> To test this, I assume that the following steps are necessary; please
correct me if I am wrong.
1. apply patches at #11642
2. apply the patch here (trac_11587.patch)
3. sage -b
4. sage -i http://wstein.org/home/ohanar/cremona-
database/elliptic_curves-0.2.spkg
5. sage -b, test everything works
6. sage -i http://wstein.org/home/ohanar/cremona-
database/database_cremona_ellcurve-20110801.spkg
7. sage -b, test everything still works
Yes, that looks correct. The only thing to be aware of is that #11642
depends on #11640 (which is just a small patch), and that there are
optional doctests you should run in step 7.
> Lastly: I expect that at regular intervals over the next few months I
will be releasing updates to the database (for example, the range
170k=180k is about 70% done already). Please leave rather clear
instructions for what to do for future updates; in particular, will it be
neceaary to rebuild everything, or just to read in the new files (e.g.
*.170000-179999 next time)?
Currently there is simple script to rebuild everything, but (in theory) it
is also possible to simply add the new files. The former:
{{{
rm SAGE_ROOT/data/cremona/cremona.db
SAGE_ROOT/sage
sage: sage.databases.cremona.build('cremona','/path/to/ecdata.tgz')
}}}
the later should be (although I haven't tested it):
{{{
make a directory that only contains the new files
SAGE_ROOT/sage
sage: cData = sage.databases.cremona.LargeCremonaDatabase('cremona',False)
sage: cData._init_from_ftpdata('/path/to/said/directory')
}}}
That said, I've marked myself as the maintainer of the
database_cremona_ellcurve spkg, so I'll try to keep it up to date (of
course it would help if you let me know when you update your tables of
course (: ).
--
Ticket URL: <http://trac.sagemath.org/sage_trac/ticket/11587#comment:6>
Sage <http://www.sagemath.org>
Sage: Creating a Viable Open Source Alternative to Magma, Maple, Mathematica,
and MATLAB
--
You received this message because you are subscribed to the Google Groups
"sage-trac" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sage-trac?hl=en.
