Abstract: Demand Chain Management (DCM) refers to a suite of analytical applications for retail business, that provides retailers with the tools they need for product demand forecasting, planning and replenishment. The reliable development and user-friendly interface of DCM applications ensures improved customer satisfaction, increased sales, improved inventory turns and significant return on investment. The present subject matter provides a self-contained reusable smart cache component for DCM development and interface. The smart cache component gives a DCM developer the ability to automatically have a configurable amount of information temporarily stored in readily available memory on an application server. The information can be retrieved in a high speed fashion without the need for additional calls to the original location of the information.

Abstract: Apparatus, systems, and methods may operate to receive a designation of multiple rows to supply data to a single user defined function, which is made available in a structured query language SELECT statement. Further activities may include retrieving the data from at least one storage medium, packing each of the multiple rows having a common key into a single row, and transforming the data from a first state into a second state by applying the single function to the data using a single access module processor. Other apparatus, systems, and methods are disclosed.

Abstract: A method of providing enterprise applications with shared access to a data warehouse. A web service request is issued over a data network from a first client enterprise application to a second server enterprise application. A database query is then constructed at the second server enterprise application. It is then determined whether a response to the web service request will include the results of posing the database query against the data warehouse, or the SQL syntax necessary to pose the query. If the response is to include the results of posing then the second server enterprise application poses the query against the data warehouse and issues the results to the first client enterprise application. If the response to the request is to include the SQL syntax necessary to pose the query, then the second server enterprise application provides the database query syntax to the first client enterprise application.

Abstract: Apparatus, systems, and methods may operate to receive a designation of multiple rows to supply data to a single user defined function, which is made available in a structured query language SELECT statement. Further activities may include retrieving the data from at least one storage medium, packing each of the multiple rows having a common key into a single row, and transforming the data from a first state into a second state by applying the single function to the data using a single access module processor. Other apparatus, systems, and methods are disclosed.

Abstract: An aggregate User Defined Function (UDF) processing used for multi-regression is provided. The aggregate UDF initializes storage space for multiple nodes of a database environment. Data is then extracted from a relational database and populated according to groupings on each of the nodes. Multiple rows or records are then processed to create a merge and multi-regression processed.

Abstract: Demand Chain Management (DCM) refers to a suite of analytical applications for retail business, that provides retailers with the tools they need for product demand forecasting, planning and replenishment. The reliable development and user-friendly interface of DCM applications ensures improved customer satisfaction, increased sales, improved inventory turns and significant return on investment. The present subject matter provides a self-contained reusable smart cache component for DCM development and interface. The smart cache component gives a DCM developer the ability to automatically have a configurable amount of information temporarily stored in readily available memory on an application server. The information can be retrieved in a high speed fashion without the need for additional calls to the original location of the information.

Abstract: A method of providing enterprise applications with shared access to a data warehouse. A web service request is issued over a data network from a first client enterprise application to a second server enterprise application. A database query is then constructed at the second server enterprise application. It is then determined whether a response to the web service request will include the results of posing the database query against the data warehouse, or the SQL syntax necessary to pose the query. If the response is to include the results of posing then the second server enterprise application poses the query against the data warehouse and issues the results to the first client enterprise application. If the response to the request is to include the SQL syntax necessary to pose the query, then the second server enterprise application provides the database query syntax to the first client enterprise application.

Abstract: Methods, systems, and data stores are provided for managing interactions between applications and a data store. Threaded applications do not directly read from or write to the data store. An extract utility performs an initial query against the data store on behalf of multiple instances of the applications. The query results service the applications from an application queue. The applications produce application data from processing the query results. The application data is streamed to a load queue and streamed out of the load queue for purposes of creating a temporary table. The temporary table is then merged into an application table of the data store, once all instances of the applications finish processing.

Abstract: An aggregate User Defined Function (UDF) processing used for multi-regression is provided. The aggregate UDF initializes storage space for multiple nodes of a database environment. Data is then extracted from a relational database and populated according to groupings on each of the nodes. Multiple rows or records are then processed to create a merge and multi-regression processed.

Abstract: Techniques for log file processing are provided. Multiple user-defined functions process in parallel on different nodes of a network. Each user-defined function on a particular node creates its own log file. All the log files are represented by the same identifier within their respective node environments. When access to the log files is requested, all the log files are accessed and merged automatically into a single database table for centralized viewing and access.