Abstract: The present application describes a database performance and usage footprint monitoring and analysis platform and related user application, which may provide insights across the whole of an enterprise's database inventory to increase visibility, accountability, and efficiency. The platform and related application may provide insight into enterprise database footprint and utilization, including displaying the data and associated metrics and analysis in a customizable interface. The platform may ingest and capture performance data and events to provide resource properties and cost analyses across enterprise groups. Future performance may be predicted by the platform, future data trends identified, and platform may provide usage prediction, perform root cause analysis to recommend action items, and provide alerts, among other functions.

Abstract: Methods and systems for managing synchronization among databases are described. One method includes establishing a trigger within a transactional database storing a plurality of transaction records, the trigger having a trigger condition associated with storing a new transaction record in the transactional database. The method includes, in response to each occurrence of the trigger condition, storing a primary key of the new transaction record into a primary key table. The method also includes aggregating transaction record information into a transaction dataset, the transaction record information being from each of a plurality of transaction records that are associated with primary keys stored in the primary key table during a predetermined time period; and transmitting the transaction dataset to a remote analysis database as streaming data.

Abstract: Methods and systems for managing attribute data for shipping and handling within a retail supply chain are disclosed. Item attributes of new items are recorded upon first receipt at a distribution center and are stored in a local database. This attribute data is synchronized to a centralized database. Data from the centralized database is pushed out to other distribution centers. The use of a centralized database of item attributes streamlines the process of inputting data for new items. This database is accessible by multiple systems with the supply chain to determine how the items should be processed. A pathfinding system utilizes item attribute data and facility data to determine a processing route for each item passing through a distribution facility.

Abstract: Methods and systems for managing synchronization among databases are described. One method includes establishing a trigger within a transactional database storing a plurality of transaction records, the trigger having a trigger condition associated with storing a new transaction record in the transactional database. The method includes, in response to each occurrence of the trigger condition, storing a primary key of the new transaction record into a primary key table. The method also includes aggregating transaction record information into a transaction dataset, the transaction record information being from each of a plurality of transaction records that are associated with primary keys stored in the primary key table during a predetermined time period; and transmitting the transaction dataset to a remote analysis database as streaming data.