pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedAbbreviation list
24+ messages / 13 participants
[nested] [flat]
* Abbreviation list
@ 2007-10-18 18:55 Steve Crawford <scrawford@pinpointresearch.com>
0 siblings, 1 reply; 24+ messages in thread
From: Steve Crawford @ 2007-10-18 18:55 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Is there a comprehensive (or semi-comprehensive) on-line list of
commonly used PG-related abbreviations used in PostgreSQL documentation,
mail-lists, etc.? If there is not, would such a list make a reasonable
one-page addition to the PG manual?
Things like GUC and DDL for example. Couldn't find them in the user
documentation index.
I looked at what Google offered up with "GUC site:www.postgresql.org"
and got 64 results. Virtually all were links to the weekly news but I
found no result that said what GUC means.
Cheers,
Steve
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-18 19:10 Alvaro Herrera <alvherre@commandprompt.com>
parent: Steve Crawford <scrawford@pinpointresearch.com>
0 siblings, 1 reply; 24+ messages in thread
From: Alvaro Herrera @ 2007-10-18 19:10 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: pgsql-general@postgresql.org
Steve Crawford wrote:
> Is there a comprehensive (or semi-comprehensive) on-line list of
> commonly used PG-related abbreviations used in PostgreSQL documentation,
> mail-lists, etc.? If there is not, would such a list make a reasonable
> one-page addition to the PG manual?
I don't think we have one, but IMHO it would be an excellent idea. We
do have some abbreviations, e.g. HOT, TOAST, WAL are the ones that
jump immediately to mind (besides the ones you mentioned).
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Granting software the freedom to evolve guarantees only different results,
not better ones." (Zygo Blaxell)
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-18 23:46 Steve Crawford <scrawford@pinpointresearch.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 4 replies; 24+ messages in thread
From: Steve Crawford @ 2007-10-18 23:46 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-general@postgresql.org
Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Is there a comprehensive (or semi-comprehensive) on-line list of
>> commonly used PG-related abbreviations used in PostgreSQL documentation,
>> mail-lists, etc.? If there is not, would such a list make a reasonable
>> one-page addition to the PG manual?
>
> I don't think we have one, but IMHO it would be an excellent idea. We
> do have some abbreviations, e.g. HOT, TOAST, WAL are the ones that
> jump immediately to mind (besides the ones you mentioned).
>
My vote is to add "Appendix I. Abbreviations". Don't know if it's
practical for 8.3 documentation but it would be nice to add even if it
only has a few entries as additional ones could be collected via the
user notes.
I suggest as a discussion starting-point the following inclusion criteria:
1. Any abbreviation/acronym that appears in the PostgreSQL documentation
(even if those terms may not be PG specific - we shouldn't assume that
everyone knows them). Good documentation practice recommends defining
abbreviations the first time they are used. Better still, ensure that
they are in the abbreviation list.
2. PostgreSQL-specific abbreviations/acronyms commonly used in on-line
conversations, news-releases, notes, etc. even if not (or not yet) in
the official documentation.
3. Abbreviations/acronyms that do not meet criteria 1 or 2 but which are
likely to clarify PG related conversations (optional, lower priority and
within the limitations of avoiding appendix bloat).
So BSD, STONITH, DBA, DBMS, RDBMS, GEQO would meet both criteria 1 and
criteria 2.
GUC and DDL (currently) only meet the second criteria.
A starter list mostly gleaned from PG documentation (typing defs quickly
and from memory - feel free to make corrections):
BKI - Backend Interface
CID - Command Identifier
CLI - Call Level Interface / Command Line Interface
CVE - Common Vulnerabilities and Exposures
CVS - Concurrent Version System
DBA - Database Administrator
DBMS - Database Management System
DDL - Data Definition Language
DML - Data Manipulation Language
DSN - Data Source Name
ECPG - Embedded SQL in C ??
GEQO - Genetic Query Optimizer
GIN - Generalized Inverted Index
GIST - Generalized Search Tree
GNU - Gnu's Not Unix
GSSAPI - Generic Security Services Application Programming Interface
GUC - Global User Configuration
HOT - Heap Oriented Tuples
IEC - International Electrotechnical Commission
ISO - International Standards Organization
JDBC - Java Database Connectivity
JRT - Java Routines and Types
LDAP - Lightweight Directory Access Protocol
MED - Management of External Data
MVCC - Multi Version Concurrency Control
NLS - Natural Language Support
ODBC - Open Database Connectivity
OID - Object Identifier
OLAP - Online Analytical Processing
OLB - Object Language Bindings
PAM - Pluggable Authentication Modules
PITR - Point In Time Recovery
POSIX - Portable Operating System Interface
PSM - Persistent Stored Modules
RPM - Redhat Package Manager
SSPI - Security Support Provider Interface
SQL - Structured Query Language
SSL - Secure Sockets Layer
STONITH - Shoot The Other Node In The Head
TOAST - The Oversize Attribute Storage Technique
UUID - Universally Unique Identifier
WAL - Write Ahead Log
XID - Transaction Identifier
XML - Extensible Markup Language
Cheers,
Steve
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 03:13 Tom Lane <tgl@sss.pgh.pa.us>
parent: Steve Crawford <scrawford@pinpointresearch.com>
3 siblings, 1 reply; 24+ messages in thread
From: Tom Lane @ 2007-10-19 03:13 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
Steve Crawford <scrawford@pinpointresearch.com> writes:
> My vote is to add "Appendix I. Abbreviations".
It seems more like FAQ material than something for the manual.
regards, tom lane
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 04:02 Bruce Momjian <bruce@momjian.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 24+ messages in thread
From: Bruce Momjian @ 2007-10-19 04:02 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Steve Crawford <scrawford@pinpointresearch.com>; Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
Tom Lane wrote:
> Steve Crawford <scrawford@pinpointresearch.com> writes:
> > My vote is to add "Appendix I. Abbreviations".
>
> It seems more like FAQ material than something for the manual.
I prefer the manual. I would think the list would be pretty long and
deal with lots of internals terms.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 04:18 Harald Armin Massa <haraldarminmassa@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 24+ messages in thread
From: Harald Armin Massa @ 2007-10-19 04:18 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-general@postgresql.org
> I prefer the manual. I would think the list would be pretty long and
> deal with lots of internals terms.
Also the manual has more "reference" character; as we saw with GUC in
this discussion it is still possible to find a CORRECT definition of
them.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 10:41 Alban Hertroys <a.hertroys@magproductions.nl>
parent: Steve Crawford <scrawford@pinpointresearch.com>
3 siblings, 1 reply; 24+ messages in thread
From: Alban Hertroys @ 2007-10-19 10:41 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
Steve Crawford wrote:
> My vote is to add "Appendix I. Abbreviations". Don't know if it's
> practical for 8.3 documentation but it would be nice to add even if it
> only has a few entries as additional ones could be collected via the
> user notes.
>
> I suggest as a discussion starting-point the following inclusion criteria:
>
> 1. Any abbreviation/acronym that appears in the PostgreSQL documentation
> (even if those terms may not be PG specific - we shouldn't assume that
> everyone knows them). Good documentation practice recommends defining
> abbreviations the first time they are used. Better still, ensure that
> they are in the abbreviation list.
Isn't this just what the ABBR tag in html is for?
--
Alban Hertroys
a.hertroys@magproductions.nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 11:19 Thomas Pundt <mlists@rp-online.de>
parent: Alban Hertroys <a.hertroys@magproductions.nl>
0 siblings, 1 reply; 24+ messages in thread
From: Thomas Pundt @ 2007-10-19 11:19 UTC (permalink / raw)
To: Alban Hertroys <a.hertroys@magproductions.nl>; +Cc: Steve Crawford <scrawford@pinpointresearch.com>; Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
Alban Hertroys schrieb:
> Steve Crawford wrote:
>> My vote is to add "Appendix I. Abbreviations". Don't know if it's
>> practical for 8.3 documentation but it would be nice to add even if it
>> only has a few entries as additional ones could be collected via the
>> user notes.
>>
>> I suggest as a discussion starting-point the following inclusion criteria:
>>
>> 1. Any abbreviation/acronym that appears in the PostgreSQL documentation
>> (even if those terms may not be PG specific - we shouldn't assume that
>> everyone knows them). Good documentation practice recommends defining
>> abbreviations the first time they are used. Better still, ensure that
>> they are in the abbreviation list.
>
> Isn't this just what the ABBR tag in html is for?
Well, yes; according w3.org its purpose is to describe the
abbreviation/acronym inline in a document using a title attribute:
<acronym title="Grand Unified Configuration">GUC</acronym>
Firefox by default underlines the abbreviation with a dotted line and
displays the title when leaving the cursor on it. In a way this means
probably defining the abbreviation.
Reference: http://www.w3.org/TR/html401/struct/text.html#edef-ABBR
--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 13:59 Alvaro Herrera <alvherre@commandprompt.com>
parent: Thomas Pundt <mlists@rp-online.de>
0 siblings, 1 reply; 24+ messages in thread
From: Alvaro Herrera @ 2007-10-19 13:59 UTC (permalink / raw)
To: thomas.pundt@rp-online.de; +Cc: Alban Hertroys <a.hertroys@magproductions.nl>; Steve Crawford <scrawford@pinpointresearch.com>; pgsql-general@postgresql.org
Thomas Pundt wrote:
> Alban Hertroys schrieb:
>> Isn't this just what the ABBR tag in html is for?
>
> Well, yes; according w3.org its purpose is to describe the
> abbreviation/acronym inline in a document using a title attribute:
Can you do that from a SGML DocBook source?
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 17:19 Joshua D. Drake <jd@commandprompt.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 24+ messages in thread
From: Joshua D. Drake @ 2007-10-19 17:19 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: thomas.pundt@rp-online.de, Alban Hertroys <a.hertroys@magproductions.nl>; Steve Crawford <scrawford@pinpointresearch.com>; pgsql-general@postgresql.org
On Fri, 19 Oct 2007 10:59:20 -0300
Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Thomas Pundt wrote:
> > Alban Hertroys schrieb:
>
> >> Isn't this just what the ABBR tag in html is for?
> >
> > Well, yes; according w3.org its purpose is to describe the
> > abbreviation/acronym inline in a document using a title attribute:
>
> Can you do that from a SGML DocBook source?
>
http://www.oasis-open.org/docbook/documentation/reference/html/acronym.html
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 17:28 Alvaro Herrera <alvherre@commandprompt.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 24+ messages in thread
From: Alvaro Herrera @ 2007-10-19 17:28 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: thomas.pundt@rp-online.de, Alban Hertroys <a.hertroys@magproductions.nl>; Steve Crawford <scrawford@pinpointresearch.com>; pgsql-general@postgresql.org
Joshua D. Drake wrote:
> On Fri, 19 Oct 2007 10:59:20 -0300
> Alvaro Herrera <alvherre@commandprompt.com> wrote:
>
> > Thomas Pundt wrote:
> > > Alban Hertroys schrieb:
> >
> > >> Isn't this just what the ABBR tag in html is for?
> > >
> > > Well, yes; according w3.org its purpose is to describe the
> > > abbreviation/acronym inline in a document using a title attribute:
> >
> > Can you do that from a SGML DocBook source?
> >
> http://www.oasis-open.org/docbook/documentation/reference/html/acronym.html
That seems pretty useless.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 17:33 Joshua D. Drake <jd@commandprompt.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 24+ messages in thread
From: Joshua D. Drake @ 2007-10-19 17:33 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: thomas.pundt@rp-online.de, Alban Hertroys <a.hertroys@magproductions.nl>; Steve Crawford <scrawford@pinpointresearch.com>; pgsql-general@postgresql.org
On Fri, 19 Oct 2007 14:28:30 -0300
Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Joshua D. Drake wrote:
> > On Fri, 19 Oct 2007 10:59:20 -0300
> > Alvaro Herrera <alvherre@commandprompt.com> wrote:
> >
> > > Thomas Pundt wrote:
> > > > Alban Hertroys schrieb:
> > >
> > > >> Isn't this just what the ABBR tag in html is for?
> > > >
> > > > Well, yes; according w3.org its purpose is to describe the
> > > > abbreviation/acronym inline in a document using a title
> > > > attribute:
> > >
> > > Can you do that from a SGML DocBook source?
> > >
> > http://www.oasis-open.org/docbook/documentation/reference/html/acronym.html
>
> That seems pretty useless.
>
*shrug*
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 18:04 Michael Meskes <meskes@postgresql.org>
parent: Steve Crawford <scrawford@pinpointresearch.com>
3 siblings, 1 reply; 24+ messages in thread
From: Michael Meskes @ 2007-10-19 18:04 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
On Thu, Oct 18, 2007 at 04:46:00PM -0700, Steve Crawford wrote:
> ECPG - Embedded SQL in C ??
Correct. And the PG part should be obvious. :-)
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 18:15 Joshua D. Drake <jd@commandprompt.com>
parent: Michael Meskes <meskes@postgresql.org>
0 siblings, 0 replies; 24+ messages in thread
From: Joshua D. Drake @ 2007-10-19 18:15 UTC (permalink / raw)
To: Michael Meskes <meskes@postgresql.org>; +Cc: Steve Crawford <scrawford@pinpointresearch.com>; Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
On Fri, 19 Oct 2007 20:04:27 +0200
Michael Meskes <meskes@postgresql.org> wrote:
> On Thu, Oct 18, 2007 at 04:46:00PM -0700, Steve Crawford wrote:
> > ECPG - Embedded SQL in C ??
>
> Correct. And the PG part should be obvious. :-)
Pretty Good?
>
> Michael
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 18:20 Steve Crawford <scrawford@pinpointresearch.com>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 2 replies; 24+ messages in thread
From: Steve Crawford @ 2007-10-19 18:20 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
Bruce Momjian wrote:
> Tom Lane wrote:
>> Steve Crawford <scrawford@pinpointresearch.com> writes:
>>> My vote is to add "Appendix I. Abbreviations".
>> It seems more like FAQ material than something for the manual.
>
> I prefer the manual. I would think the list would be pretty long and
> deal with lots of internals terms.
>
My vote too. Just noticed I missed (probably one of many):
BLOB - Binary Large Object
Cheers,
Steve
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 19:36 Alvaro Herrera <alvherre@commandprompt.com>
parent: Steve Crawford <scrawford@pinpointresearch.com>
1 sibling, 2 replies; 24+ messages in thread
From: Alvaro Herrera @ 2007-10-19 19:36 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Bruce Momjian <bruce@momjian.us>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-general@postgresql.org
Steve Crawford wrote:
> Bruce Momjian wrote:
> > Tom Lane wrote:
> >> Steve Crawford <scrawford@pinpointresearch.com> writes:
> >>> My vote is to add "Appendix I. Abbreviations".
> >> It seems more like FAQ material than something for the manual.
> >
> > I prefer the manual. I would think the list would be pretty long and
> > deal with lots of internals terms.
>
> My vote too. Just noticed I missed (probably one of many):
> BLOB - Binary Large Object
Do we use that term? Normally for us it's "large objects".
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 19:53 Erik Jones <erik@myemma.com>
parent: Steve Crawford <scrawford@pinpointresearch.com>
1 sibling, 0 replies; 24+ messages in thread
From: Erik Jones @ 2007-10-19 19:53 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Bruce Momjian <bruce@momjian.us>; Tom Lane <tgl@sss.pgh.pa.us>; Alvaro Herrera <alvherre@commandprompt.com>; pgsql-general@postgresql.org
On Oct 19, 2007, at 1:20 PM, Steve Crawford wrote:
> Bruce Momjian wrote:
>> Tom Lane wrote:
>>> Steve Crawford <scrawford@pinpointresearch.com> writes:
>>>> My vote is to add "Appendix I. Abbreviations".
>>> It seems more like FAQ material than something for the manual.
>>
>> I prefer the manual. I would think the list would be pretty long and
>> deal with lots of internals terms.
>>
>
> My vote too. Just noticed I missed (probably one of many):
> BLOB - Binary Large Object
As far as missed goes, I believe I saw OLAP but not OLTP.
Erik Jones
Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 20:29 Steve Crawford <scrawford@pinpointresearch.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 1 reply; 24+ messages in thread
From: Steve Crawford @ 2007-10-19 20:29 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Bruce Momjian <bruce@momjian.us>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-general@postgresql.org
Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Bruce Momjian wrote:
>>> Tom Lane wrote:
>>>> Steve Crawford <scrawford@pinpointresearch.com> writes:
>>>>> My vote is to add "Appendix I. Abbreviations".
>>>> It seems more like FAQ material than something for the manual.
>>> I prefer the manual. I would think the list would be pretty long and
>>> deal with lots of internals terms.
>> My vote too. Just noticed I missed (probably one of many):
>> BLOB - Binary Large Object
>
> Do we use that term? Normally for us it's "large objects".
>
Perhaps we should add "LO" but the documentation does refer to the term
BLOB though typically in the context of "The SQL standard defines a
different binary string type, called BLOB..." or in the list of reserved
words.
Cheers,
Steve
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 20:35 Ron Johnson <ron.l.johnson@cox.net>
parent: Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 0 replies; 24+ messages in thread
From: Ron Johnson @ 2007-10-19 20:35 UTC (permalink / raw)
To: pgsql-general@postgresql.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 10/19/07 14:36, Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Bruce Momjian wrote:
>>> Tom Lane wrote:
>>>> Steve Crawford <scrawford@pinpointresearch.com> writes:
>>>>> My vote is to add "Appendix I. Abbreviations".
>>>> It seems more like FAQ material than something for the manual.
>>> I prefer the manual. I would think the list would be pretty long and
>>> deal with lots of internals terms.
>> My vote too. Just noticed I missed (probably one of many):
>> BLOB - Binary Large Object
>
> Do we use that term? Normally for us it's "large objects".
Good news everyone! "Large objects" is generic enough that if PG is
ever ported to the IBM 1400 that you won't have to come up with a
new acronym: DLOB (Decimal Large OBject).
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHGRT8S9HxQb37XmcRAvnnAJwO9RVzeNwFWh5hCdQNnUihDuy2QQCeJyUL
SHMDqqSUmIPbTLU5d+/LmKI=
=y/Vu
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: Abbreviation list
@ 2007-10-19 20:59 Dimitri Fontaine <dfontaine@hi-media.com>
parent: Steve Crawford <scrawford@pinpointresearch.com>
0 siblings, 0 replies; 24+ messages in thread
From: Dimitri Fontaine @ 2007-10-19 20:59 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: Steve Crawford <scrawford@pinpointresearch.com>; Alvaro Herrera <alvherre@commandprompt.com>; Bruce Momjian <bruce@momjian.us>; Tom Lane <tgl@sss.pgh.pa.us>
Hi,
Le Friday 19 October 2007 22:29:37 Steve Crawford, vous avez écrit :
> > Do we use that term? Normally for us it's "large objects".
>
> Perhaps we should add "LO" but the documentation does refer to the term
> BLOB though typically in the context of "The SQL standard defines a
> different binary string type, called BLOB..." or in the list of reserved
> words.
This topic was discussed on IRC the other day, and we seemed to conclude that
what standard SQL refers to as CLOB and BLOB can be compared to PostgreSQL
text and bytea types with TOAST storage, which makes them out-of-line text or
binary objects.
Large Objects seems to be another beast when compared to blobs...
As I'm still pretty ignorant on the matter, though, I'd appreciate it if some
light was to be made ;)
Regards,
--
dim
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: [GENERAL] Abbreviation list
@ 2007-11-01 17:25 Bruce Momjian <bruce@momjian.us>
parent: Steve Crawford <scrawford@pinpointresearch.com>
3 siblings, 1 reply; 24+ messages in thread
From: Bruce Momjian @ 2007-11-01 17:25 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-docs
I have created an acronyms documentation section for the 8.3 Postgres
manual. It is at:
http://momjian.us/main/writings/pgsql/sgml/acronyms.html
I used some of your suggestions in the list. Comments? Additions?
---------------------------------------------------------------------------
Steve Crawford wrote:
> Alvaro Herrera wrote:
> > Steve Crawford wrote:
> >> Is there a comprehensive (or semi-comprehensive) on-line list of
> >> commonly used PG-related abbreviations used in PostgreSQL documentation,
> >> mail-lists, etc.? If there is not, would such a list make a reasonable
> >> one-page addition to the PG manual?
> >
> > I don't think we have one, but IMHO it would be an excellent idea. We
> > do have some abbreviations, e.g. HOT, TOAST, WAL are the ones that
> > jump immediately to mind (besides the ones you mentioned).
> >
>
> My vote is to add "Appendix I. Abbreviations". Don't know if it's
> practical for 8.3 documentation but it would be nice to add even if it
> only has a few entries as additional ones could be collected via the
> user notes.
>
> I suggest as a discussion starting-point the following inclusion criteria:
>
> 1. Any abbreviation/acronym that appears in the PostgreSQL documentation
> (even if those terms may not be PG specific - we shouldn't assume that
> everyone knows them). Good documentation practice recommends defining
> abbreviations the first time they are used. Better still, ensure that
> they are in the abbreviation list.
>
> 2. PostgreSQL-specific abbreviations/acronyms commonly used in on-line
> conversations, news-releases, notes, etc. even if not (or not yet) in
> the official documentation.
>
> 3. Abbreviations/acronyms that do not meet criteria 1 or 2 but which are
> likely to clarify PG related conversations (optional, lower priority and
> within the limitations of avoiding appendix bloat).
>
> So BSD, STONITH, DBA, DBMS, RDBMS, GEQO would meet both criteria 1 and
> criteria 2.
>
> GUC and DDL (currently) only meet the second criteria.
>
> A starter list mostly gleaned from PG documentation (typing defs quickly
> and from memory - feel free to make corrections):
>
> BKI - Backend Interface
> CID - Command Identifier
> CLI - Call Level Interface / Command Line Interface
> CVE - Common Vulnerabilities and Exposures
> CVS - Concurrent Version System
> DBA - Database Administrator
> DBMS - Database Management System
> DDL - Data Definition Language
> DML - Data Manipulation Language
> DSN - Data Source Name
> ECPG - Embedded SQL in C ??
> GEQO - Genetic Query Optimizer
> GIN - Generalized Inverted Index
> GIST - Generalized Search Tree
> GNU - Gnu's Not Unix
> GSSAPI - Generic Security Services Application Programming Interface
> GUC - Global User Configuration
> HOT - Heap Oriented Tuples
> IEC - International Electrotechnical Commission
> ISO - International Standards Organization
> JDBC - Java Database Connectivity
> JRT - Java Routines and Types
> LDAP - Lightweight Directory Access Protocol
> MED - Management of External Data
> MVCC - Multi Version Concurrency Control
> NLS - Natural Language Support
> ODBC - Open Database Connectivity
> OID - Object Identifier
> OLAP - Online Analytical Processing
> OLB - Object Language Bindings
> PAM - Pluggable Authentication Modules
> PITR - Point In Time Recovery
> POSIX - Portable Operating System Interface
> PSM - Persistent Stored Modules
> RPM - Redhat Package Manager
> SSPI - Security Support Provider Interface
> SQL - Structured Query Language
> SSL - Secure Sockets Layer
> STONITH - Shoot The Other Node In The Head
> TOAST - The Oversize Attribute Storage Technique
> UUID - Universally Unique Identifier
> WAL - Write Ahead Log
> XID - Transaction Identifier
> XML - Extensible Markup Language
>
> Cheers,
> Steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: [GENERAL] Abbreviation list
@ 2007-11-01 18:28 Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 24+ messages in thread
From: Bruce Momjian @ 2007-11-01 18:28 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; pgsql-docs
Steve Crawford wrote:
> Bruce Momjian wrote:
> > I have created an acronyms documentation section for the 8.3 Postgres
> > manual. It is at:
> >
> > http://momjian.us/main/writings/pgsql/sgml/acronyms.html
> >
> > I used some of your suggestions in the list. Comments? Additions?
>
> Nice work.
>
> Without searching the documentation for references...
>
> Do we use DST to generically refer to all time-shifting worldwide or do
> we have specific references to New Zealand Summer Time, European Summer
> Time, Moscow Summer Time, etc.?
We talk about DST when we are discussing DST changes in general.
> Do we refer to URIs or only URLs?
Mostly only URLs.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: [GENERAL] Abbreviation list
@ 2007-11-01 20:56 Peter Eisentraut <peter_e@gmx.net>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 24+ messages in thread
From: Peter Eisentraut @ 2007-11-01 20:56 UTC (permalink / raw)
To: pgsql-docs; +Cc: Bruce Momjian <bruce@momjian.us>
Bruce Momjian wrote:
> I have created an acronyms documentation section for the 8.3 Postgres
> manual. It is at:
>
> http://momjian.us/main/writings/pgsql/sgml/acronyms.html
Should this be a glossary?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: [GENERAL] Abbreviation list
@ 2007-11-01 21:19 Bruce Momjian <bruce@momjian.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 24+ messages in thread
From: Bruce Momjian @ 2007-11-01 21:19 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > I have created an acronyms documentation section for the 8.3 Postgres
> > manual. It is at:
> >
> > http://momjian.us/main/writings/pgsql/sgml/acronyms.html
>
> Should this be a glossary?
Uh, you mean have actual terms and definitions in there? Yea, we could
do that but it seemed best to just link to the content, particuarly
because some of the terms are complicated.
I didn't see too many terms I wanted to add that were not already
acronyms, and I figured they could be looked up in the index.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 24+ messages in thread
end of thread, other threads:[~2007-11-01 21:19 UTC | newest]
Thread overview: 24+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-18 18:55 Abbreviation list Steve Crawford <scrawford@pinpointresearch.com>
2007-10-18 19:10 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-10-18 23:46 ` Steve Crawford <scrawford@pinpointresearch.com>
2007-10-19 03:13 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-10-19 04:02 ` Bruce Momjian <bruce@momjian.us>
2007-10-19 04:18 ` Harald Armin Massa <haraldarminmassa@gmail.com>
2007-10-19 18:20 ` Steve Crawford <scrawford@pinpointresearch.com>
2007-10-19 19:36 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-10-19 20:29 ` Steve Crawford <scrawford@pinpointresearch.com>
2007-10-19 20:59 ` Dimitri Fontaine <dfontaine@hi-media.com>
2007-10-19 20:35 ` Ron Johnson <ron.l.johnson@cox.net>
2007-10-19 19:53 ` Erik Jones <erik@myemma.com>
2007-10-19 10:41 ` Alban Hertroys <a.hertroys@magproductions.nl>
2007-10-19 11:19 ` Thomas Pundt <mlists@rp-online.de>
2007-10-19 13:59 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-10-19 17:19 ` Joshua D. Drake <jd@commandprompt.com>
2007-10-19 17:28 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-10-19 17:33 ` Joshua D. Drake <jd@commandprompt.com>
2007-10-19 18:04 ` Michael Meskes <meskes@postgresql.org>
2007-10-19 18:15 ` Joshua D. Drake <jd@commandprompt.com>
2007-11-01 17:25 ` Bruce Momjian <bruce@momjian.us>
2007-11-01 20:56 ` Peter Eisentraut <peter_e@gmx.net>
2007-11-01 21:19 ` Bruce Momjian <bruce@momjian.us>
2007-11-01 18:28 Re: [GENERAL] Abbreviation list Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox