Agents

Agents are people, organizations, groups, code, or any human entity that performs actions. Agents are collectors, authors of publications, users of objects, issuers of identifiers and, if you enter or edit data, you are an Agent. A single Agent can have many roles and many names. No matter how many roles or names an Agent has, there should be only one Agent profile in Arctos to represent them. Agents are not deleted, but may be default-hidden by a ‘bad duplicate of’ relationship.

Agent

Table Agent is the central or core Agent data table.

agent_id

Agent_ID is the internal primary key, and when prefixed with https://arctos.database.museum/agent/ becomes a stable actionable GUID suitable for external use.

agent_type

Agent Type is controlled by a code table.

preferred_agent_name

Preferred Name is the namestring displayed by default. Note that this is not unique within Arctos, and so cannot serve as a useful identifier. (That is, “Eduardo M. Spencer” might refer to any number of entities, even locally.)

created_by_agent_id

Foreign key to agent.agent_id, the person creating the Agent record.

created_date

Date on which record was created.

agent_attribute

Agent Attributes carries all name, address, identifier, remark, and other information regarding an Agent. Attributes cannot be deleted, but can be deprecated (thus a history of change is maintained).

attribute_id

Primary key, not exposed.

agent_id

Foreign key to agent.agent_id.

attribute_type

Attribute Type is controlled by a code table.

attribute_value

Some are vocabulary or datatype controlled.

begin_date

Date on which the assertion became active.

end_date

Date on which the assertion became inactive.

Foreign key to agent.agent_id; a relationship to another agent (required by some types).

determined_date

Date on which attribute was determined.

attribute_determiner_id

Foreign key to agent.agent_id; agent making the assertion.

attribute_method

Method by which determination is known.

attribute_remark

Things which don’t fit elsewhere.

created_by_agent_id

Foreign key to agent.agent_id; agent entering the data.

created_timestamp

Date on which data was entered.

deprecated_by_agent_id

Foreign key to agent.agent_id; agent deleting or changing an attribute; this is applied to “olds.”

deprecated_timestamp

deprecation_type

update or delete

Related Entities

Verbatim Agent Attribute

The catalog record attribute verbatim agent allows uncontrolled strings to be associated with individual catalog records.

This is preferable to creating low-data Agents when possible, and puts any necessary cleanup in the context of the catalog record data. For example, when working with bare agent names (as is often the case when importing data to Arctos), deciding if “J. Smith” and “J. D. Smith” are the same Agent is often impossible or impractical. Determining whether similar strings represent one entity is a much more robust exercise in the context of multiple catalog records, where it’s relatively straightforward to determine if the potential agents are conducting similar activity (in which case they probably are the same, and it’s easy to Agentify them using Arctos tools) or if they are probably different (in which case more research may be necessary, or multiple agents with differentiating relationships and addresses may be created and used). We recommend this approach for most incoming string-based “collector” information.

This data structure is suitable for any agents acting in any “role”. Attribute method is required in order to differentiate intended roles for verbatim agents.

When “bad duplicate of” agents are merged, verbatim agent Attributes for collector roles are automatically created for all affected catalog records.

Database Rules

Some database rules and suggestions exist in an attempt to provide some consistency and avoid the most obvious duplicates and ways of hiding data.

Pick

Many inputs (such as the record bulkloader) accept Agents as strings, and the database then attempts to resolve those strings to existing Agents using the following pathway.

Note: Agents marked ‘bad duplicate of’ are generally excluded from selection.

  1. Case-insensitive full login name. These are unique within Arctos; a match of a login name will be selected, even if the string is used for other purposes. Example: dlm
  2. AgentID. These are GUIDs which provide an unambiguous reference. Example: https://arctos.database.museum/agent/2072
  3. Controlled-type purpose=identifier attributes should be GUIDs which provide an unambiguous reference. Example: https://orcid.org/0000-0002-4848-5938
  4. Preferred Agent Name. These are nonunique personal identifiers, only a 1:1 match will be selected. There are many unexpected formats and duplicates within Arctos. Note that there are ~30,000 living people named ‘James Smith’; blindly accepting that the one in Arctos is the one you’re looking for is not recommended.
  5. Purpose=name attributes - some of these have been crafted to serve as selectors in certain situations.

Note that an ‘invalid agent’ message can result from, for example, zero or many “Preferred Agent Name” matches, and as mentioned above one match (which will result in a successful link) is no guarantee of the correct Agent being chosen. We recommend using only unambiguous identifiers.

How To

Instructions for doing specifc tasks related to Agents in Arctos

Edit this Documentation

If you see something that needs to be edited in this document, you can create an issue using the link under the search widget at the top left side of this page, or you can edit directly here.