Create a .dbd file [message #59793] |
Thu, 10 April 2008 09:38  |
vino
Messages: 36 Registered: March 2008
|
Member |
|
|
Hi!
I want to create a database for my stellar photometry data. Can
someone please help me in creating a .dbd file ?
Thanks for your help,
vino
|
|
|
Re: Create a .dbd file [message #59849 is a reply to message #59793] |
Thu, 17 April 2008 08:40  |
vino
Messages: 36 Registered: March 2008
|
Member |
|
|
On Apr 12, 3:57 am, wlandsman <wlands...@gmail.com> wrote:
>>>> > > On Apr 10, 11:38 am, vino <astrocr...@gmail.com> wrote:
>
>> i am sure i am talking about a .dbd (database definition) file rather
>> than a .dbf file.Only if .dbd file exists can i create a .dbf file..:(
>> thanks and regards,
>> vino
>
> You are almost certainly referring to the IDL database format designed
> by Don Lindler more than 20 years ago, mainly for astronomy. This is
> a simple, flat database format but I still find it useful for small
> ( < 3 million entries) databases, when one does not need to often add
> new columns or perform exotic searches. The main advantage is that
> the database entries map easily into IDL vectors and arrays, so it is
> easy to plot or process the data. The procedures and a README file
> located athttp://idlastro.gsfc.nasa.gov/ftp/pro/database/ and a
> LaTEX file database.tex located athttp://idlastro.gsfc.nasa.gov/ftp/text. The LaTex file gives a
> description of how to create the .dbd file, which is an ASCII file
> made with an ordinary editor, which describes the data type and other
> information about the database columns. It would probably be
> useful to examine one of the .dbd files for some of the astronomy
> databases stored athttp://idlastro.gsfc.nasa.gov/ftp/zdbase.
>
> For a completely different approach, you might look at Marc Buie's IDL
> interface to a MYSQL database athttp://www.lowell.edu/users/buie/idl/#categ9
>
> --Wayne
Hello Wayne,
I found your manuel on using UIT database system. It is very helpful
to me. Thanks again.
regards,
vino
|
|
|
Re: Create a .dbd file [message #59850 is a reply to message #59793] |
Thu, 17 April 2008 08:17  |
vino
Messages: 36 Registered: March 2008
|
Member |
|
|
On Apr 12, 3:57 am, wlandsman <wlands...@gmail.com> wrote:
>>>> > > On Apr 10, 11:38 am, vino <astrocr...@gmail.com> wrote:
>
>> i am sure i am talking about a .dbd (database definition) file rather
>> than a .dbf file.Only if .dbd file exists can i create a .dbf file..:(
>> thanks and regards,
>> vino
>
> You are almost certainly referring to the IDL database format designed
> by Don Lindler more than 20 years ago, mainly for astronomy. This is
> a simple, flat database format but I still find it useful for small
> ( < 3 million entries) databases, when one does not need to often add
> new columns or perform exotic searches. The main advantage is that
> the database entries map easily into IDL vectors and arrays, so it is
> easy to plot or process the data. The procedures and a README file
> located athttp://idlastro.gsfc.nasa.gov/ftp/pro/database/ and a
> LaTEX file database.tex located athttp://idlastro.gsfc.nasa.gov/ftp/text. The LaTex file gives a
> description of how to create the .dbd file, which is an ASCII file
> made with an ordinary editor, which describes the data type and other
> information about the database columns. It would probably be
> useful to examine one of the .dbd files for some of the astronomy
> databases stored athttp://idlastro.gsfc.nasa.gov/ftp/zdbase.
>
> For a completely different approach, you might look at Marc Buie's IDL
> interface to a MYSQL database athttp://www.lowell.edu/users/buie/idl/#categ9
>
> --Wayne
Hi Wayne,
I am refering to the IDL database which you were mentioned since i am
dealing with only about a million stars. Another reason is my
laziness to learn SQL..:(
Thanks to you for i found information to create my .dbd file.I am now
struggling with bits and pieces which should be done within the next
couple of days..
regards,
vino
Hi Rick,
I am doing stellar photometry of around a million stars which i
thought might be easy to access and analyse if i store it in the form
of a database. Since i am not familiar with SQL or any other language,
i wanted to store it in IDL database.
regards,
vino
|
|
|
Re: Create a .dbd file [message #59909 is a reply to message #59793] |
Fri, 11 April 2008 09:40  |
Rick Towler
Messages: 821 Registered: August 1998
|
Senior Member |
|
|
vino wrote:
> Hi!
> I want to create a database for my stellar photometry data. Can
> someone please help me in creating a .dbd file ?
Hi Vino,
I've been following this thread trying to understand why you need to
create a .dbd file and I'm just not seeing it. I think we need to take
a step back.
What exactly do you want to do? You say you want to put your data into
a database? What kind of database? What is a .dbd file? Is this .dbd
file some format specific to stellar photometry? Or do you want to
stick it in a generic relational database?
What references to "to different commands regarding database access and
modification" are you referring to?
-Rick
|
|
|