Shouldn't indices be - this_is_an_index_called_ instead of a_index_?

Just a curious thought

-----Original Message-----
From: Obnoxio The Clown [SMTPbnoxio@hotmail.com]
Sent: Thursday, November 20, 2003 12:50 PM
To: informix-list@iiug.org
Subject: Re: Naming Convention for Informix Database Objects

Christopher wrote:

> Can anyone recommend a good naming convention for database objects in
> Informix?
>
> Generally, I use my own variation on Hungarian, but I wondered if
> there is an equivalent of the RVBA (also known as Leszynski/Reddick)
> standard among Informix developers.
>
> I would also be thrilled to find a write-up I can reuse or just plain
> plagiarize.
>
> As an aside, this is to be implemented on IDS 9.4, so long identifiers
> are not an issue.

I generally prefix tables with this_is_a_table_called_, views with
this_is_a_view_called_, indexes with this_is_a_index_called_ ...

--
"C'est pas parce qu'on n'a rien a dire qu'il faut fermer sa gueule"
- Coluche

sending to informix-list

Dusty Haas wrote:

> Shouldn't indices be - this_is_an_index_called_ instead of a_index_?
>
> Just a curious thought

You're quite right to do that nit pick
and I do feel just like a right dick
your razor sharp eyes
affirm the surmise
"to cut and paste is lazy and thick"

> -----Original Message-----
> From: Obnoxio The Clown [SMTPbnoxio@hotmail.com]
> Sent: Thursday, November 20, 2003 12:50 PM
> To: informix-list@iiug.org
> Subject: Re: Naming Convention for Informix Database Objects
>
> Christopher wrote:
>
>> Can anyone recommend a good naming convention for database objects in
>> Informix?
>>
>> Generally, I use my own variation on Hungarian, but I wondered if
>> there is an equivalent of the RVBA (also known as Leszynski/Reddick)
>> standard among Informix developers.
>>
>> I would also be thrilled to find a write-up I can reuse or just plain
>> plagiarize.
>>
>> As an aside, this is to be implemented on IDS 9.4, so long identifiers
>> are not an issue.
>
> I generally prefix tables with this_is_a_table_called_, views with
> this_is_a_view_called_, indexes with this_is_a_index_called_ ...
>

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

Obnoxio The Clown wrote:
>
> Dusty Haas wrote:
>
> > Shouldn't indices be - this_is_an_index_called_ instead of a_index_?
> >
> > Just a curious thought
>
> You're quite right to do that nit pick
> and I do feel just like a right dick
> your razor sharp eyes
> affirm the surmise
> "to cut and paste is lazy and thick"

Justy is right - almost.
you need at least 2 different praefixes (and their variations)

this_is_an_unique_index_(not_)used_as_primary_key_ later_on_after_we_done_with_alter_table_
this_is_a_compound_index-.......

and so on.

Of course when IFX dev ppl are done with auto change of
praefix_part_of_index_name
when you insert into a table with a cluster index in such a way, that
is is no more
truely clustered, they might concentrate on indexes having an entry
lenth of
greater than 16 TeraByte

I hope this answeres another posting I had to read today

dic_k

PS: if you do not stop top posting, I might turn on my HTML feature
here
this is usenet & if you want to learn about netiquette the rough
way, then
TOFU post into a more fundamentalistic group like clpm.
This is still the fastest way to learn all about links to
netiquette
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

Richard Kofler wrote:

> Obnoxio The Clown wrote:
>>
>> Dusty Haas wrote:
>>
>> > Shouldn't indices be - this_is_an_index_called_ instead of a_index_?
>> >
>> > Just a curious thought
>>
>> You're quite right to do that nit pick
>> and I do feel just like a right dick
>> your razor sharp eyes
>> affirm the surmise
>> "to cut and paste is lazy and thick"
>
> Justy is right - almost.
> you need at least 2 different praefixes (and their variations)
>
>
this_is_an_unique_index_(not_)used_as_primary_key_ later_on_after_we_done_with_alter_table_
> this_is_a_compound_index-.......
>
> and so on.
>
> Of course when IFX dev ppl are done with auto change of
> praefix_part_of_index_name
> when you insert into a table with a cluster index in such a way, that
> is is no more
> truely clustered, they might concentrate on indexes having an entry
> lenth of
> greater than 16 TeraByte
>
> I hope this answeres another posting I had to read today
>
> dic_k
>
> PS: if you do not stop top posting, I might turn on my HTML feature
> here
> this is usenet & if you want to learn about netiquette the rough
> way, then
> TOFU post into a more fundamentalistic group like clpm.
> This is still the fastest way to learn all about links to
> netiquette

Where did I top post?

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

Obnoxio The Clown wrote:

[ ... stuff snipped .. ]

> Where did I top post?
>

I apologize.
You did not top post.
I must learn all about that buttons scrolling down the pages ....

The good thing is: I will not use HTML (for now

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

Richard Kofler wrote:

> Obnoxio The Clown wrote:
>
> [ ... stuff snipped .. ]
>
>> Where did I top post?
>>
>
> I apologize.
> You did not top post.
> I must learn all about that buttons scrolling down the pages ....
>
> The good thing is: I will not use HTML (for now

Just as well, too. I would have hated to humiliate you twice in a public
forum. )

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche