公开(公告)号：US12028336B2

公开(公告)日：2024-07-02

申请号：US18453057

申请日：2023-08-21

Applicant: Xactly Corporation

Inventor： Steve Bogrett

IPC: G06F16/00 ,  G06F16/9038 ,  G06F16/95 ,  G06F16/958 ,  H04L9/40 ,  H04L67/01 ,  H04L67/02 ,  H04L67/1001 ,  H04L67/60

CPC classification number: H04L63/083 ,  G06F16/9038 ,  G06F16/95 ,  G06F16/958 ,  H04L63/08 ,  H04L67/01 ,  H04L67/02 ,  H04L67/1001 ,  H04L67/60

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. A request coordinator store coupled to the one or more of the multiple web server is queried. to determine a state of the database request. Based at least in part on the state of the database request, the first web server requests the database management system to execute the one or more first database instructions and update the state.

公开(公告)号：US11863610B2

公开(公告)日：2024-01-02

申请号：US17743066

申请日：2022-05-12

Applicant: XACTLY CORPORATION

Inventor： Steven Bogrett ,  Oleksandr Podoprygora

IPC: H04L67/02 ,  H04L67/1097 ,  G06F16/27 ,  G06F11/14 ,  H04L67/561

CPC classification number: H04L67/02 ,  G06F11/1471 ,  G06F16/27 ,  H04L67/1097 ,  H04L67/561 ,  G06F2201/80

Abstract: A method for managing multiple REST requests of a browser or other client to resources in an atomic transaction using a transaction management process that is communicatively coupled to a cluster of computer-executed server processes. In one approach, the process is programmed for receiving from a browser process a request to start a transaction associated with a data access process; acquiring a database connection from the data access process and storing the database connection in an open state; receiving from the browser process REST queries for execution; forwarding the REST queries to the data access process, and forwarding responses from the data access process to the browser process; receiving a request from the browser process to end the transaction, and only in response to the second request, completing the transaction in communication with the data access process, and changing the database connection to a closed state. As the connection to the database remains open, multiple REST queries may be sent for updating multiple resources in a single transaction efficiently through the same data access process without occupying extra server processes.

公开(公告)号：US11327954B2

公开(公告)日：2022-05-10

申请号：US16732170

申请日：2019-12-31

Applicant: XACTLY CORPORATION

Inventor： Ron Rasmussen ,  Vasu Krishnamoorthy ,  Denis Gefter

IPC: G06F16/23 ,  G06F16/16 ,  G06Q40/00

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.

公开(公告)号：US11218470B2

公开(公告)日：2022-01-04

申请号：US16551538

申请日：2019-08-26

Applicant: XACTLY CORPORATION

Inventor： Steve Bogrett

IPC: G06F16/00 ,  H04L29/06 ,  H04L29/08 ,  G06F16/95 ,  G06F16/9038 ,  G06F16/958

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. A request coordinator store coupled to the one or more of the multiple web server is queried to determine a state of the database request. Based at least in part on the state of the database request, the first web server requests the database management system to execute the one or more first database instructions and update the state.

公开(公告)号：US20220374452A1

公开(公告)日：2022-11-24

申请号：US17325574

申请日：2021-05-20

Applicant: XACTLY CORPORATION

Inventor： ANDREW SALCHERT

IPC: G06F16/28 ,  G06F9/50 ,  G06F16/25 ,  G06F16/29 ,  G06F3/0481

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.

公开(公告)号：US20220124083A1

公开(公告)日：2022-04-21

申请号：US17566813

申请日：2021-12-31

Applicant: XACTLY CORPORATION

Inventor： STEVE BOGRETT

IPC: H04L67/01 ,  H04L67/02 ,  H04L67/60 ,  G06F16/95 ,  G06F16/9038 ,  G06F16/958 ,  H04L67/1001

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. A request coordinator store coupled to the one or more of the multiple web server is queried. to determine a state of the database request. Based at least in part on the state of the database request, the first web server requests the database management system to execute the one or more first database instructions and update the state.

公开(公告)号：US20200059464A1

公开(公告)日：2020-02-20

申请号：US16551538

申请日：2019-08-26

Applicant: XACTLY CORPORATION

Inventor： STEVE BOGRETT

IPC: H04L29/06 ,  G06F16/9038 ,  G06F16/95 ,  H04L29/08 ,  G06F16/958

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. A request coordinator store coupled to the one or more of the multiple web server is queried to determine a state of the database request. Based at least in part on the state of the database request, the first web server requests the database management system to execute the one or more first database instructions and update the state.

公开(公告)号：US10235400B2

公开(公告)日：2019-03-19

申请号：US14788645

申请日：2015-06-30

Applicant: Xactly Corporation

Inventor： Kandarp Mahadev Desai ,  Gowri Shankar Ravindran

IPC: G06F17/30

Abstract: A data processing method comprising the computer-implemented steps of using a database index key processing module in a computer, generating row keys for a data store, the data store comprising data records, each comprising at least a first element and a second element, each of the row keys comprising at least: a first portion comprising a first encoded value for the first element of a corresponding data item of the data records, a second portion comprising a second encoded value for the second element of the corresponding data item of the data records, storing the data records using the row keys, using a query processing module of the computer, receiving a search query comprising a first filter for the first element, translating the first filter into at least the first portion of a search key, and searching the dataset using the search key.

公开(公告)号：US20180219852A1

公开(公告)日：2018-08-02

申请号：US15728421

申请日：2017-10-09

Applicant: XACTLY CORPORATION,

Inventor： STEVE BOGRETT

IPC: H04L29/06 ,  H04L29/08 ,  G06F17/30

CPC classification number: H04L63/083 ,  G06F16/9038 ,  G06F16/95 ,  G06F16/958 ,  H04L63/08 ,  H04L67/02 ,  H04L67/1002 ,  H04L67/32 ,  H04L67/42

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. A request coordinator store coupled to the one or more of the multiple web server is queried. to determine a state of the database request. Based at least in part on the state of the database request, the first web server requests the database management system to execute the one or more first database instructions and update the state.

公开(公告)号：US20160335295A1

公开(公告)日：2016-11-17

申请号：US14788645

申请日：2015-06-30

Applicant: Xactly Corporation

Inventor： Kandarp Mahadev Desai ,  Gowri Shankar Ravindran

IPC: G06F17/30

CPC classification number: G06F17/30315

Abstract: A data processing method comprising the computer-implemented steps of using a database index key processing module in a computer, generating row keys for a data store, the data store comprising data records, each comprising at least a first element and a second element, each of the row keys comprising at least: a first portion comprising a first encoded value for the first element of a corresponding data item of the data records, a second portion comprising a second encoded value for the second element of the corresponding data item of the data records, storing the data records using the row keys, using a query processing module of the computer, receiving a search query comprising a first filter for the first element, translating the first filter into at least the first portion of a search key, and searching the dataset using the search key.

Abstract translation: 一种数据处理方法，包括在计算机中使用数据库索引关键字处理模块的计算机实现步骤，生成用于数据存储的行密钥，所述数据存储器包括数据记录，每个数据记录包括至少第一元素和第二元素， 包括至少包括：第一部分，包括数据记录的对应数据项的第一元素的第一编码值，第二部分包括数据的相应数据项的第二元素的第二编码值 记录，使用计算机的查询处理模块存储数据记录，接收包括第一元素的第一过滤器的搜索查询，将第一过滤器转换成至少搜索关键字的第一部分，以及搜索 数据集使用搜索键。