Operational Data Store (ODS)

What is the ODS?

The Operational Data Store (ODS) is a database copy of InPort metadata-related tables and views, which can be accessed by NOAA organizations on InPort. This allows organizations to run their own custom queries and generate reports on their metadata in InPort, including both published and unpublished metadata.

The ODS is refreshed nightly at 11:55pm Eastern, except when periodic server and database maintenance windows overlap with this time.

If your organization is interested in obtaining access to the ODS, please contact InPort Support.

ODS Changelog

The versions listed below correspond to InPort Release Versions.

Note that object names accessible to you are prefixed with your line office acronym (e.g. NMFS_INP_CATALOG_ITEMS or NOS_INP_CATALOG_ITEMS).

Release 5.3.5

April 4, 2024

Object	Action / Notes
INP_CATALOG_ITEMS > BEST_AVAIL_META_YN, INP_RBR_DS_SCORES > BEST_AVAIL_META_YN	Add Indicates whether the record has the "Best Available Metadata" designation.
INP_CATALOG_ITEMS > BEST_AVAIL_META_EXPLAIN	Add An explanation for why the record has the "Best Available Metadata" designation.
INP_RBR_AGG_SCORES > BEST_AVAIL_META_YN_COUNT	Add The number of catalog items that have the "Best Available Metadata" designation under the project or library.
INP_RBR_ADJ_SCORES	Add New materialized view which calculates adjusted aggregate scores, by removing any Data Sets with the "Best Available Metadata" designation from the calculation.
INP_RBR_ADJ_SCORES > ADJUSTED_SCORE	Add The adjusted aggregate score after any Data Sets with the Best Available Metadata designation are excluded.
INP_RBR_ADJ_SCORES > PROJECT_CAT_ID, CAT_TYPE_CODE, METADATA_FOLDER, PROGRAM	Add Same meanings as the similarly named columns in INP_RBR_AGG_SCORES.

Object

Action / Notes

INP_CATALOG_ITEMS > BEST_AVAIL_META_YN,
INP_RBR_DS_SCORES > BEST_AVAIL_META_YN

Add
Indicates whether the record has the "Best Available Metadata" designation.

INP_CATALOG_ITEMS > BEST_AVAIL_META_EXPLAIN

Add
An explanation for why the record has the "Best Available Metadata" designation.

INP_RBR_AGG_SCORES > BEST_AVAIL_META_YN_COUNT

Add
The number of catalog items that have the "Best Available Metadata" designation under the project or library.

INP_RBR_ADJ_SCORES

Add
New materialized view which calculates adjusted aggregate scores, by removing any Data Sets with the "Best Available Metadata" designation from the calculation.

INP_RBR_ADJ_SCORES > ADJUSTED_SCORE

Add
The adjusted aggregate score after any Data Sets with the Best Available Metadata designation are excluded.

INP_RBR_ADJ_SCORES > PROJECT_CAT_ID, CAT_TYPE_CODE, METADATA_FOLDER, PROGRAM

Add
Same meanings as the similarly named columns in INP_RBR_AGG_SCORES.

Release 5.3.4

February 29, 2024

Object	Action / Notes
INP_CC_ACCESS_INFO > DATA_LICENSE_TYPE	Add Indicates whether a premade data license and statement is being used, such as the NOAA standard open data license ("STANDARD"), or a custom one ("CUSTOM").
INP_CC_ACCESS_INFO > DATA_LICENSE	Add The name of the data license being used.
INP_CC_ACCESS_INFO > DATA_LICENSE_URL	Add The URL of the data license being used.
INP_CC_ACCESS_INFO > DATA_LICENSE_STMT	Add A statement on how the data can be used in conjunction with the specified data license.

Object

Action / Notes

INP_CC_ACCESS_INFO > DATA_LICENSE_TYPE

Add
Indicates whether a premade data license and statement is being used, such as the NOAA standard open data license ("STANDARD"), or a custom one ("CUSTOM").

INP_CC_ACCESS_INFO > DATA_LICENSE

Add
The name of the data license being used.

INP_CC_ACCESS_INFO > DATA_LICENSE_URL

Add
The URL of the data license being used.

INP_CC_ACCESS_INFO > DATA_LICENSE_STMT

Add
A statement on how the data can be used in conjunction with the specified data license.

Release 5.3.2

November 16, 2023

Object	Action / Notes
INP_CONTACTS > NOTES	Add Additional details about a Contact for internal use. Not visible in metadata records.

Object

Action / Notes

INP_CONTACTS > NOTES

Add
Additional details about a Contact for internal use. Not visible in metadata records.

Release 5.3.0

August 15, 2023

Object	Action / Notes
INP_CC_DISTRIBUTIONS > COMPRESS_STATUS	Deprecate This column has been replaced by COMPRESSION_RC_ID, and will be removed in a future release (1 year or later).
INP_CC_DISTRIBUTIONS > COMPRESSION_RC_ID	Add A controlled reference code ID signifying the Distribution's compression status.
INP_CC_DISTRIBUTIONS > COMPRESSION_DESCR	Add A convenience lookup column for the Reference Code description associated with COMPRESSION_RC_ID.
INP_CC_DISTRIBUTIONS > COMPRESSION_CODE	Add A convenience lookup column for the Reference Code code associated with COMPRESSION_RC_ID. While Reference Code descriptions may change over time, the code should always stay the same, and is consequently more reliable to use in application logic.
INP_CC_DISTRIBUTIONS > FILE_TYPE	Deprecate This column has been replaced by DIST_FORMAT_RC_ID, and will be removed in a future release (1 year or later).
INP_CC_DISTRIBUTIONS > DIST_FORMAT_RC_ID	Add A controlled reference code ID signifying the underlying format of the Distribution. Note: This field is not being added to the InPort application until Release 5.3.1, but has been added ahead of time. ODS users should not expect any data to appear in this column until 5.3.1.
INP_CC_DISTRIBUTIONS > DIST_FORMAT_DESCR	Add A convenience lookup column for the Reference Code description associated with DIST_FORMAT_RC_ID. Note: This field is not being added to the InPort application until Release 5.3.1, but has been added ahead of time. ODS users should not expect any data to appear in this column until 5.3.1.

Object

Action / Notes

INP_CC_DISTRIBUTIONS > COMPRESS_STATUS

Deprecate
This column has been replaced by COMPRESSION_RC_ID, and will be removed in a future release (1 year or later).

INP_CC_DISTRIBUTIONS > COMPRESSION_RC_ID

Add
A controlled reference code ID signifying the Distribution's compression status.

INP_CC_DISTRIBUTIONS > COMPRESSION_DESCR

Add
A convenience lookup column for the Reference Code description associated with COMPRESSION_RC_ID.

INP_CC_DISTRIBUTIONS > COMPRESSION_CODE

Add
A convenience lookup column for the Reference Code code associated with COMPRESSION_RC_ID. While Reference Code descriptions may change over time, the code should always stay the same, and is consequently more reliable to use in application logic.

INP_CC_DISTRIBUTIONS > FILE_TYPE

Deprecate
This column has been replaced by DIST_FORMAT_RC_ID, and will be removed in a future release (1 year or later).

INP_CC_DISTRIBUTIONS > DIST_FORMAT_RC_ID

Add
A controlled reference code ID signifying the underlying format of the Distribution. Note: This field is not being added to the InPort application until Release 5.3.1, but has been added ahead of time. ODS users should not expect any data to appear in this column until 5.3.1.

INP_CC_DISTRIBUTIONS > DIST_FORMAT_DESCR

Add
A convenience lookup column for the Reference Code description associated with DIST_FORMAT_RC_ID. Note: This field is not being added to the InPort application until Release 5.3.1, but has been added ahead of time. ODS users should not expect any data to appear in this column until 5.3.1.

Release 5.2.3

November 29, 2022

Object	Action / Notes
INP_KEYWORD_LINKS	Drop The original intended use for the underlying table in InPort is no longer needed.
INP_KEYWORDS > LEAF_NAME	Increase Length The max length has been increased to 500 characters.
INP_CC_ISO_FILES	Drop The underlying table was previously deprecated and has now been removed.

Object

Action / Notes

INP_KEYWORD_LINKS

Drop
The original intended use for the underlying table in InPort is no longer needed.

INP_KEYWORDS > LEAF_NAME

Increase Length
The max length has been increased to 500 characters.

INP_CC_ISO_FILES

Drop
The underlying table was previously deprecated and has now been removed.