What is an xref table

[Gyankr]

Hi everybody,

Could someone explain me what this xref table is all about.I googled and found only things about design consideration or some things involving cross reference.
If you could give me an example that would be very useful.

Regards,
Gyan

[VK2COT]

Hello,

Your question is too generic and undefined.
Difficult to answer.

Here are some examples of xrefs that relate to HP-UX and Unix/Linux in general:

a) MPE to HP-UX programming API xref guide;

MPE to HP-UX Commands XREF web reference tool;

MPE to HP-UX System Administration XREF web reference tool;

b) Solaris Patchdiag tool uses patchdiag.xref
file to verify patches on a given server
against latest recommended cluster;

c) SunSolve database at sunsolve.sun.com
uses "Xref:" headers to cross-reference
their documents and/or patches;

d) HP-UX swainv uses inventory.xml file
to verify patches on a given server against
latest ITRC patches;

e) B::Xref generates cross reference reports for Perl programs;

f) Rosetta Stone for Unix is an xref table:

http://bhami.com/rosetta.html

g) Various security sites provide
cross-reference tables of security bugs
and incidents;

h) Email header can have an optional field -
the contents of the "Xref:", to allow cross-post management.

In essence, xref can relate to any
cross-reference document or table...

Cheers,

VK2COT

[Gyankr]

Thank you,this is vast info,i wanted to know xref from sql (database) point of view.

Regards,
Gyan

[VK2COT]

Hello,

Ahh, your question is clearer now :)

Here is an example for xfer table
in SQL:

Let's say users are defined in categories.
Depending on what category they are in,
they have a different set of functions that
are possible. There is an xref table that
defines which functions they actually have.

As far as SQL categories are concerned,
here they are:

* Data definition statements,
* Data manipulation statements,
* Cursor manipulation statements,
* Dynamic management statements,
* Data access statements,
* Data integrity statements,
* Optimization statements,
* Routine definition statements,
* Client/server connection statements,
* Auxiliary statements,
* Optical subsystem statements.

Cheers,

VK2COT

[Gyankr]

Thanks for the information.

Regards,
Gyan