Abstract: According to one embodiment of the present invention, a system determines key relationships between database tables and includes a computer system including at least one processor. The system determines a sampling range for one or more matching columns between first and second database tables. The matching columns satisfy one or more matching criteria and the sampling range is based on quantities of distinct values within the matching columns. Data is sampled from the first and second database tables in accordance with the sampling ranges to determine a sample set. Keys between the first and second database tables are determined based on matching between columns within the sample set. Embodiments of the present invention further include a method and computer program product for determining key relationships between database tables in substantially the same manner described above.

Abstract: According to one embodiment of the present invention, a system determines key relationships between database tables and includes a computer system including at least one processor. The system determines a sampling range for one or more matching columns between first and second database tables. The matching columns satisfy one or more matching criteria and the sampling range is based on quantities of distinct values within the matching columns. Data is sampled from the first and second database tables in accordance with the sampling ranges to determine a sample set. Keys between the first and second database tables are determined based on matching between columns within the sample set. Embodiments of the present invention further include a method and computer program product for determining key relationships between database tables in substantially the same manner described above.

Abstract: Systems and methods in accordance with various embodiments of the present invention provide for a system and method for simultaneous price optimization and asset allocation to maximize manufacturing profits. In one embodiment, a set of price points for the item and a set of expected demand values for each price point are determined. A supply-side constraint which models inventory, replenishment, and capacities associated with replenishment and a joining constraint, which requires that the set of expected demand values be equal to a planned supply of the item, are determined. A demand-side constraint is determined. Further, an objective function to maximize profits is determined, based on the set of price points, the set of expected demand values, and subject to the supply-side, joining, and demand-side constraints. Based on the objective function, an optimal price profile for the item is provided.

Abstract: Systems and methods in accordance with various embodiments of the present invention provide for a system and method for simultaneous price optimization and asset allocation to maximize manufacturing profits. In one embodiment, a set of price points for the item and a set of expected demand values for each price point are determined. A supply-side constraint which models inventory, replenishment, and capacities associated with replenishment and a joining constraint, which requires that the set of expected demand values be equal to a planned supply of the item, are determined. A demand-side constraint is determined. Further, an objective function to maximize profits is determined, based on the set of price points, the set of expected demand values, and subject to the supply-side, joining, and demand-side constraints. Based on the objective function, an optimal price profile for the item is provided.