Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These are guidelines for using the Local Schemas on the Cornell LDP (Library Data Platform) reporting database. All users have access to create and delete tables on LDP local schemas, so it is important to be careful to follow the guidelines for using them.


Schema Usage GuidelinesWhere Schemas Implemented
localThe local schema is available to all reporting users. Please precede any tables you create in this schema with your netid, as in netid_mytable. LDP Test and LDP Production
local_automationThis schema is
for use
used by the
library automation team.
Automation Team.LDP Production only
local_coreThis schema is
for use by the library reporting team.
used by the Reporting Team.LDP Test and LDP Production
local_digpresThis schema is used by the HathiTrust team.LDP Production only
local_hathitrustThis schema is
for use
used by the HathiTrust team.LDP Production only
local_protectedThis schema is used to store tables capturing daily updates that cannot be deletedLDP Test and LDP Production
local_statisticsThis schema is
for use
used by
Library
the Assessment and Planning
for annual statistics
teamLDP Production only