3 results about "OLAP cube" patented technology

The invention discloses a multi-objective optimization decision-making method and system for sewage treatment based on OLAP reinforcement learning, and solves the problems that an existing sewage treatment control method neglects carbon emission, is extensive in cost control and does not integrate a carbon transaction mechanism. The method comprises the following steps: constructing an OLAP cube, and generating an optimal historical strategy set; establishing a state set according to the sewage environment parameters and the carbon price; an action set is established according to the optimal historical strategy set, and an action priority strategy is set according to the carbon emission weight partition; establishing a multi-target reward function dynamically adjusted according to the carbon price; constructing each controller agent model for training until the strategy converges; and dynamically outputting an optimal strategy by the intelligent agent according to the change of the carbon price. According to the method, a multi-dimensional OLAP cube is constructed to analyze the incidence relation between key variables, a plurality of process control agents are constructed, reinforcement learning collaborative optimization of working condition adjustment is achieved, the carbon emission item optimization weight is adjusted according to the real-time carbon transaction price, and dynamic policy adaptation is achieved.

An enhanced multidimensional data management system significantly reduces the resources required to convert a spreadsheet into an enterprise collaborative system. A spreadsheet may be imported as is without modifications. Additional information that cannot be automatically inferred about the data model used in the spreadsheet is obtained. Dimensions, timescale, and measure data are clearly defined and located. The spreadsheet is kept in the system in the form of both a spreadsheet and as a multidimensional data structure such as an online analytical processing (OLAP) cube or structure. This duality allows the spreadsheet to be manipulated as if it was an OLAP cube, modifying iterations within the dimensions, and the OLAP cube to be computed as if it was a spreadsheet.

A multidimensional data aggregation and ingestion system includes a multidimensional data aggregation and ingestion computing device that ingests data received from one or more sources. During operation, data is received from one or more internal or external data sources. Next, received data is aggregated in accordance with aggregation rules. Next, delta information is determined by comparing received data to stored data in accordance with delta determination rules. Next, delta information is appended to the stored data. Data is ingested without deleting stored data. A stored multidimensional array data structure is updated based on received data without generating a new stored multidimensional array data structure. For example, a “Process Add” method provided by SQL Server Analysis Services (SSAS) is used to append delta information to a stored Online Analytical Processing (OLAP) cube. The novel system ingests significant quantities of data without needing to generate new OLAP cubes on each ingestion operation.