Creating a Data Dictionary

--000e0cd32fccb5f3e7048b31b69d
Content-Type: text/plain; charset=ISO-8859-1

Hi;
Perhaps I have a conflict of terms here, but my googling "mysql data
dictionary" turned up material that didn't seem to correspond with my
problem. In python I can create dictionaries:
my_dict = {'1': 'one', '2': 'two'}
Now, I would like to create the equivalent of an enum in which I could
utilize data like that. Of course, I could lump the whole key-value pairs
into one data and create an enum like that, then parse them later. I'm just
wondering if there's a more elegant way to do this.
TIA,
Victor

--000e0cd32fccb5f3e7048b31b69d--

Re: Creating a Data Dictionary

No such thing in SQL

On Mon, Jul 12, 2010 at 10:39 AM, Victor Subervi
wrote:
> Hi;
> Perhaps I have a conflict of terms here, but my googling "mysql data
> dictionary" turned up material that didn't seem to correspond with my
> problem. In python I can create dictionaries:
> my_dict =3D {'1': 'one', '2': 'two'}
> Now, I would like to create the equivalent of an enum in which I could
> utilize data like that. Of course, I could lump the whole key-value pairs
> into one data and create an enum like that, then parse them later. I'm ju=
st
> wondering if there's a more elegant way to do this.
> TIA,
> Victor
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Creating a Data Dictionary

[snip]
Perhaps I have a conflict of terms here, but my googling "mysql data
dictionary" turned up material that didn't seem to correspond with my
problem. In python I can create dictionaries:
my_dict =3D {'1': 'one', '2': 'two'}
Now, I would like to create the equivalent of an enum in which I could
utilize data like that. Of course, I could lump the whole key-value
pairs
into one data and create an enum like that, then parse them later. I'm
just
wondering if there's a more elegant way to do this.
[/snip]

There is an enumerated type
http://dev.mysql.com/doc/refman/5.1/en/enum.html and there are data
dictionaries
http://dev.mysql.com/tech-resources/articles/mysql-datadicti onary.html
but neither are really what you want.

Actually what you're describing the reason that we have databases in the
first place - the ability to have data in one column ('1') related to
data in another column ('one') in a record. The most elegant way of
using a database is to use it as it was designed.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Creating a Data Dictionary

A data dictionary, as the term is generally used, is what is contained
in INFORMATION_SCHEMA. It is meta data describing the types and names
and structure of the data within a given domain.

Python's concept of a dictionary is what other language call a hash
(perl), an associative array (awk,php) or a Map (Java/JVM). None of
them implement 'data dictionaries' as the term is used.

- md

On Mon, Jul 12, 2010 at 11:24 AM, Jay Blanchard wro=
te:
> [snip]
> Perhaps I have a conflict of terms here, but my googling "mysql data
> dictionary" turned up material that didn't seem to correspond with my
> problem. In python I can create dictionaries:
> my_dict =3D {'1': 'one', '2': 'two'}
> Now, I would like to create the equivalent of an enum in which I could
> utilize data like that. Of course, I could lump the whole key-value
> pairs
> into one data and create an enum like that, then parse them later. I'm
> just
> wondering if there's a more elegant way to do this.
> [/snip]
>
> There is an enumerated type
> http://dev.mysql.com/doc/refman/5.1/en/enum.html and there are data
> dictionaries
> http://dev.mysql.com/tech-resources/articles/mysql-datadicti onary.html
> but neither are really what you want.
>
> Actually what you're describing the reason that we have databases in the
> first place - the ability to have data in one column ('1') related to
> data in another column ('one') in a record. The most elegant way of
> using a database is to use it as it was designed.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg