Overview of the RedPrairie Standard Solution

  • Use “INSTALLED” to indicate if the system is installed.
  • Use “REMOTE-HOST” to specify the host and port of the archive environment.
  • Use “LOCAL-ARCHIVE” to archive data to tables in the same instance. Use “TABLE-PREFIX” to determine the table name in that case. This is typically not used because in this case the existing applications cannot be used against the archive instance.

Issues with the standard solution

Archiving ++ by Smart IS

  • We will use the database features to connect multiple database instances. For example on Oracle we will use “Database Links” and for SQLServer we will use “Linked Servers”. Our preferred approach is to co-locate the archive database in the same instance as the online database — this improves the performance even further.
  • We will use the “insert into <target> select * from <source>” technique for moving the data.
  • We will use “delete” with a where clause to delete the data rather than a delete that processes the data one row at a time.
  • For updating the archive instance, we will do it in two steps:
  • We will use correlated queries between the two instances
  • We will have generic, central components to do the work for any table.
  • We will utilize the information in the database data dictionary to streamline the process of moving the data from the primary instance to the archive instance.

Implementation Details

Archiving Logic

Summary

--

--

--

Smart-IS is a consulting firm that leverages IT to enhance your business processes. Specialties: Microsoft, Oracle, SharePoint, PeopleSoft, & WMS practices

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Tracing Requests in Serverless Architectures with AWS CloudWatch ServiceLens

To Buy or to Build?: The Healthcare Technology Conundrum

Part 1. Asynchronous actions within AWS Step Functions without servers

Pinterest: presentable White CZ

Kafka, (Producers & Consumers)

Scaling Android Deployment with Bitbucket Pipelines and Fastlane — Bitbucket

[OSD600] Build a static site generator with Picocli

Bonus Content — Ionic Part 6

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Smart IS International

Smart IS International

Smart-IS is a consulting firm that leverages IT to enhance your business processes. Specialties: Microsoft, Oracle, SharePoint, PeopleSoft, & WMS practices

More from Medium

Team dependent

4 Reasons IT Teams Must Talk About Deadlines More Often

Move quality left

The disarticulated centipede