Integration in amateur astronomy website

[mandimastro]

Hi,
First of all I would like to give congratulations for this project. It
is a very promising for the future in amateur astronomy. I'm building
an astronomy portal in Greece and I would like to create a database
that would be compliant with the <OAL> standard. My goal is to create
a database for the Greek Amateurs to give the opportunity to add or
search for observations.

I was tried to create a relational database from the xml schema but I
couldn't figure it out. What is the xml schema that I need and if
there is away to create the db from the xsd. I've search in google but
didn't find any information.

Thanks in advance.

[Dirk Lehmann]

Hi Mandimastro,

have you seen http://www.deepskylog.org? I think that just what you
have in mind. And it offers <OAL> import and export.
Wim DeMeester (one of the authors of DeepSkyLog) is also member of
this group, maybe you can talk to him.
Maybe all it needs is a greek transaltion for DeepSkyLog.org...

On the schema itself, in the files section there is a file called
OAL20.zip. This contains the current release (2.0) of <OAL>.
From a structure point of view, you'll find a base.xsd which contains
all the basic elements (optics, scope, eyepiece, ...) and several
extensions
that are specialized for e.g. DeepSky, VariableStar, etc.
(In order to be <OAL> compliant, you only need to support the base.xsd
elements)

Whether there's a tool that directly maps xsd structures to a
relational database design, I'm not sure. But I'm also not too deep
into that. Maybe
the others can answer here/have more ideas...

Best regards

Dirk

[Wim De Meester]

Hi Mandimastro,

DeepskyLog looks indeed as the web application you are looking for. We would
love it when you would want to help to add a Greek translation to DeepskyLog!

If you are interesting in a Greek version of http:://www.deepskylog.org please
contact me on my mailaddress.

Cheers,

Wim

> --
>
> You received this message because you are subscribed to the Google Groups
> "openastronomylog" group. To post to this group, send email to
> openastr...@googlegroups.com. For more options, visit this group at
> http://groups.google.com/group/openastronomylog?hl=.
>

--
Wim De Meester
Katholieke Universiteit Leuven
Instituut voor sterrenkunde tel: +32 (0)16 327914
Celestijnenlaan 200 D fax: +32 (0)16 327999
B - 3001 Leuven email: wim.de...@ster.kuleuven.be
Belgium http://www.ster.kuleuven.be/~wim

[Tom]

Hi,

Please let me just point out an importnat feature of our XML schema
and the deepskylog.org web application: language tags. They are used
to indicate in which language the descriptive text of an observation
is written. In the user interface (on deepskylog.org or desktop
applications like Dirks Observation Manager or my next release of
Eye&Telescope) you can filter for languages you understand. With this,
we can have an international pool of observations (= deepskylog.org)
and national contributors, filtering out what they do not want or
understand. But even if I cannot understand a descriptive text in
Greek, Hungarian or Finnish (and many other languages ;-)) I can look
for the ratings (1 to 7 scale) given and draw some valuable
information from the observations.

What I don't know and what might cause some trouble: Greek
characters / codepages / charsets. Never saw a Greek PC and what
glyphs appear on the screen...

Best wishes and clear skies to you!

Tom

[mandimastro]

Thank you for your answers. Actually the reason that I want to create
the database is to integrate it with additional astronomical
informations that would be in the portal (not just a web-application
that stores observations) in Greek language. Of course any of the
observation that would exists in the greek portal would possibly
imported also in the deepskylog.org.

Best wishes,

Dimitris

[Wim De Meester]

Hi Dimitris,

DeepskyLog can generate an RSS feed of all new observations. So maybe you can
add the observations from the RSS feed to the Greek portal (we can make an RSS
feed which only shows the Greek observations).

Cheers,

Wim

> --
>
> You received this message because you are subscribed to the Google Groups
> "openastronomylog" group. To post to this group, send email to

> openastr...@googlegroups.com. To unsubscribe from this group, send
> email to openastronomyl...@googlegroups.com. For more options,