Updating existing records in a dataset

For example, if the existing record has one standard attribute named Color with a value of "red" and the request adds a Color property with a value of "blue", then the resulting record will have two Color key-value pair assignments.

updating existing records in a dataset-19updating existing records in a dataset-13updating existing records in a dataset-35

Changes to the release date will be automatically propagated to all your private Samples contained within that Series.

Alternatively, feel free to e-mail the revised release date to us, with the corresponding GEO accession(s), and we will update or release your records on your behalf.

Using a single transaction also reduces the number of commits, which saves time and resources.

If you are overwriting all of the columns in the target table, the fastest method for performing a merge is by replacing the existing rows because it scans the target table only once, by using an inner join to delete rows that will be updated.

Nor can you overwrite an attribute value using this component.

If you want to modify an attribute value, you must delete the value then add the new value. When you add incremental data to the data store, the records are generally in a similar format to the records that have already been loaded.

Updating your Series record with the corresponding publication is strongly advised as it ensures your data are properly linked and referenced in Pub Med.

You can update your records yourself: log in to your GEO account, go to your Series (GSExxxx) record, click on the 'update' link next to the 'Citation missing' line, and enter the Pub Med Identifier (PMID) into the 'Pub Med ID' box; the PMID number can be found at the foot of your Pub Med entry.

When adding a PMID to a private Series record, please also remember to release the Series and any associated records to the public (see Change the release date of your private records above).

Tags: , ,