Abstract: With digitally stored geographical maps, programmed algorithms can calculate a plurality of territories within a map, the territories being balanced with respect to metric data that is associated with units of the map, using channel flow-based principles of the Constructal Law. One field of application is balanced territories for sales representatives in which units of a map are associated with different customers or entities having different sales volume, unit volume, or other workload associated with the units. As the magnitude of workload metrics changes, territories can be rapidly and efficiently rebalanced.

Abstract: A data processing method comprises receiving a request to perform a prior period adjustment (PPA) for a tenant in which data values applicable to a time period earlier than a current time period will be modified, in response to the request, identifying a working subset of data from tenant data in the production database and copying the working subset to a calculation database separate from the production database, performing the PPA, using the working subset in the calculation database, to result in creating and storing a plurality of result data, receiving, while performing the PPA, an additional request using the tenant data in the production database, performing the additional request using the tenant data in the production database while performing the PPA and updating the replay log, after completing the PPA and using the replay log, transferring the plurality of results to the production database.

Abstract: Techniques are provided for a highly available web-based database interface system (WDIS) processing database requests that target one or more databases managed by a coupled DBMS. In an embodiment, a web server of multiple web servers receives a first client web-based request that includes one or more first database instructions of a database request. The multiple web servers are configured to balance client web-based requests among one or more of the multiple web servers. The one or more of the multiple web servers are coupled to a database management system that includes one or more database servers executing database instructions on one or more databases. Based on balancing client web-based requests among the one or more of the multiple web servers, routing the first client web-based request that includes the one or more first database instructions of the database request to the first web server of the one or more multiple web servers coupled to the database management system.

Abstract: Updating a data storage unit using tenant specific update policies is disclosed. In an embodiment, a plurality of application events from an events publisher is received at a data pipeline manager. The plurality of application events are associated with data at a source data storage unit and are stored at a data pipeline data storage unit. An update process is initiated, based on an update policy associated with a particular tenant. During the update process, one or more application events associated with the particular tenant are selected from among the plurality of application events stored at the data pipeline data storage unit. Data associated with the one or more selected application events is selected from the source data storage unit. Data selected from the source data storage unit is stored at a target data storage unit.

Abstract: A data processing method comprises receiving a request to perform a prior period adjustment (PPA) for a tenant in which data values applicable to a time period earlier than a current time period will be modified, in response to the request, identifying a working subset of data from tenant data in the production database and copying the working subset to a calculation database separate from the production database, performing the PPA, using the working subset in the calculation database, to result in creating and storing a plurality of result data, receiving, while performing the PPA, an additional request using the tenant data in the production database, performing the additional request using the tenant data in the production database while performing the PPA and updating the replay log, after completing the PPA and using the replay log, transferring the plurality of results to the production database.

Abstract: A data processing method comprises receiving a request to analyze a relationship between an explanatory element and a response element and obtaining, in response to the request, data associated with the explanatory element and the response element. The method further comprises determining coefficients for an equation and storing the coefficients in digital computer memory by: computing, using a plurality of processes in parallel and for each of the coefficients, summations derived from a zero first derivative of the equation with respect to each of the coefficients, computing a value for each of the coefficients using the summations, determining, in response to the computing, a vector of response element values in the digital computer memory using the value of each of the coefficients and values representing the explanatory element as input, and causing displaying a trend graph of the relationship.

Abstract: Techniques are provided for a highly available web-based database interface system (WDIS) processing database requests that target one or more databases managed by a coupled DBMS. In an embodiment, a web server of multiple web servers receives a first client web-based request that includes one or more first database instructions of a database request. The multiple web servers are configured to balance client web-based requests among one or more of the multiple web servers. The one or more of the multiple web servers are coupled to a database management system that includes one or more database servers executing database instructions on one or more databases. Based on balancing client web-based requests among the one or more of the multiple web servers, routing the first client web-based request that includes the one or more first database instructions of the database request to the first web server of the one or more multiple web servers coupled to the database management system.

Abstract: A data processing method comprises: using an application server computer, receiving a workflow for single period processing, the workflow comprising steps for processing data items related to the period, processing the data items according to the workflow to generate an output, capturing, during processing, metadata about the output, storing the output, the workflow, the data items, and the metadata in a database, receiving a modification to one or more of the data items and storing the modification to result in modified data items, receiving, during an open period, a request to reprocess the period using the modified data items, wherein the open period is subsequent to the SPP, in response to the request, processing, according to the workflow and the metadata, the modified data items to generate modified output, determining a difference between the output and the modified output, carrying the difference over to the open period.

Abstract: In an embodiment, a method is described for partitioning a data table into one or more partitions based on tenant specific partition strategies. In an embodiment, one or more tenant identifiers within a data store are identified. Each of the tenant identifiers identifies a unique tenant. The table of data is partitioned into partitions, and each partition is associated with a particular tenant identifier and comprises data associated with the particular tenant identifier. A particular partition from the partitions is partitioned into one or more sub partitions. A custom sub partition key is determined and associated, at least in part, with particular tenant identifier. In response to a data access query associated with the particular tenant identifier, a data storage unit is queried using the custom sub partition key stored in the metadata table.

Abstract: A data processing method comprises using an application server computer of an application service provider (ASP), establishing computerized shared multi-tenant data storage in which tenant data that is associated with a plurality of different tenants of the ASP is stored together in a first database associated with a distributed computation system that is separate from the application server computer, receiving an analytics request, determining, based on at least one attribute of the analytics request, the application server computer will process at least the analytics request, sending, to the distributed computation system, a first query for data needed by the analytics request, receiving, from the distributed computation system, an interim result set of data resulting from processing the first query against the first database, processing, by the application server computer, the interim result set of data for the analytics request to generate and digitally store a first result set.

Abstract: A data processing method comprising using an application server computer, establishing a shared multi-tenant system in which tenant data that is associated with tenants is stored together in a real shared data store system; providing to a tenant computing device identifiers that identify virtual objects, wherein each of the virtual objects represents a data entity that is stored in the real shared data store system; receiving a SQL query from the tenant computing device that specifies a data operation on a first virtual object of the virtual objects; rewriting the SQL query by dynamically replacing the first virtual object with an identifier of a function; executing the function and the rewritten query without explicit metadata to generate a result set; sending the result set to the tenant computing device.

Abstract: A data processing method comprising the computer-implemented steps of using a process management computer, receiving an electronic workflow document in response to execution of editing instructions at a user terminal that is coupled by network to the process management computer, wherein the electronic workflow document defines a workflow using a plurality of tags and statements that specify steps in the workflow, wherein each of the steps is either an atomic type step or a non-atomic type step, wherein at least a first step that is atomic comprises a plurality of instructions and is programmed to signal, to a second and successive non-atomic step, normal completion of execution of the first step; wherein at least a second step that is non-atomic is programmed to call a completion callback in response to the signal; using the process management computer, parsing the electronic workflow document to form an in-memory representation of the workflow in computer memory; using the process management computer and usi