RE: swizzle?

I have heard this phrase used in the context of persistently storing objects in a relational database. When the object id (OID) is resolved to the location of the object within the database it is said to have been swizzled. Not sure if I remember this correctly, but that is my recollection.

Erik

> -----Original Message-----
> From: Hately Mike [SMTP:Mike.Hately_at_churchill.com]
> Sent: Wednesday, June 19, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: swizzle?
>
> Wow,
> I've never heard of this before but apparently it's :
>
> swizzle v. To convert external names, array indices, or references
> within a data structure into address pointers when the data structure is
> brought into main memory from external storage (also called `pointer
> swizzling'); this may be done for speed in chasing references or to
> simplify
> code (e.g., by turning lots of name lookups into pointer dereferences).
> The
> converse operation is sometimes termed `unswizzling'.
>
> Regards,
> Mike
>
> -----Original Message-----
> Sent: 19 June 2002 16:23
> To: Multiple recipients of list ORACLE-L
>
>
> I'm RTFM the 9i R2 docs & I just read the following...
>
> ALTER_TABLE_REFERENCEABLE Procedure
> This procedure reorganizes object tables and swizzles references. For
> example, assume you have an object table FOO and that
> references in other tables point to objects stored in FOO. If you want to
> change some of the table organization--for example, you
> want to make it an IOT or a partitioned table, or you want to reorganize
> the
> data more efficiently--you copy all data from FOO
> into FOO2. Then you use the alter_table_referenceable and
> alter_table_not_referenceable procedures to swizzle all existing
> references to point to FOO2 instead of FOO.
>
> I'd like to know the definition of "swizzle", 'cuz I just don't grok it
> used
> in this context.
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct.
> 858-831-2229 San Diego, CA 92131
> There are no stupid questions, but there are many inquisitive idiots!
>
>
>
> __________________________________________________________________________
> __
> ________________________
>
> This email and any attached to it are confidential and intended only for
> the
> individual or
> entity to which it is addressed. If you are not the intended recipient,
> please let us know
> by telephoning or emailing the sender. You should also delete the email
> and
> any attachment
> from your systems and should not copy the email or any attachment or
> disclose their content
> to any other person or entity. The views expressed here are not
> necessarily
> those of
> Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
> you.
> Churchill Insurance Group plc. Company Registration Number - 2280426.
> England.
> Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
> 1DP.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hately Mike
> INET: Mike.Hately_at_churchill.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Erik Williams
  INET: ewilliams_at_brownco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).