专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20150081666A1 SYSTEMS AND METHODS FOR OPTIMIZING DATABASE QUERIES 有权
标题翻译：优化数据库查询的系统和方法
公开(公告)号：US20150081666A1
公开(公告)日：2015-03-19
申请号：US14486706
申请日：2014-09-15
申请人： MasterCard International Incorporated
发明人： Kenneth L. Long
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30451 , G06F17/30584
摘要： A computer-based method for optimizing database queries is provided. The method uses a server computer device including a processor communicatively coupled to a database. The method includes receiving a main query requesting data from a partitioned database table within the database. The partitioned database table includes a plurality of partitions. The method also includes determining a partition list. The partition list includes two or more partitions of the plurality of partitions and excludes at least one partition of the plurality of partitions. The method further includes generating a plurality of sub-queries where each sub-query is associated with one partition included within the partition list, and processing each sub-query of the plurality of sub-queries on the associated partition included within the partition list.
摘要翻译：提供了一种用于优化数据库查询的基于计算机的方法。该方法使用包括通信地耦合到数据库的处理器的服务器计算机设备。该方法包括从数据库中的分区数据库表接收请求数据的主查询。分区数据库表包括多个分区。该方法还包括确定分区列表。分区列表包括多个分区中的两个或多个分区，并且排除多个分区中的至少一个分区。该方法还包括生成多个子查询，其中每个子查询与分区列表中包括的一个分区相关联，以及处理分区列表中包括的关联分区上的多个子查询的每个子查询。

2. 发明申请

US20200137178A1 Systems and Methods for Use In Geolocation Resolution Of Computer Network Nodes 审中-公开
公开(公告)号：US20200137178A1
公开(公告)日：2020-04-30
申请号：US16175257
申请日：2018-10-30
申请人： MASTERCARD INTERNATIONAL INCORPORATED
发明人： Gary R. Horn , Kenneth L. Long
IPC分类号： H04L29/08 , G06Q40/00
摘要： Disclosed are exemplary embodiments of systems and methods for use in assigning locations to network records. One exemplary system includes a processor coupled to a data structure including network records, each record including a network node identifier and a boundary identifier. The processor is configured to, for each boundary identifier, access each of the network records including the boundary identifier. The accessed records include reference and target network records. Each reference network record includes location data indicative of a location of the network node identified in the reference record within the boundary. The processor is configured to determine an aggregate location as a median of the location data for the network nodes identified in the reference network records and assign the aggregate location to each of the target network records as location data indicative of the location of each network node identified in the target records within the boundary.

3. 发明授权

US10963484B2 Systems and methods for use in data access 有权
公开(公告)号：US10963484B2
公开(公告)日：2021-03-30
申请号：US16043539
申请日：2018-07-24
申请人： MASTERCARD INTERNATIONAL INCORPORATED
发明人： Kenneth L. Long
IPC分类号： G06F21/62 , G06F16/27 , G06F16/22 , G06F16/23
摘要： Systems and methods are provided for use in accessing data stored in multiple databases. One exemplary system includes first and second databases. The first database includes a first primary tablespace having first data, a first standby tablespace having first standby data, and a first journal. The first database is configured, in response to a request including a change instruction for the first data, to alter the first data consistent with the change instruction, append a change description indicative of the alteration to the journal, and transmit the journal to the second database. The second database is configured to then receive the journal from the first database and to alter second standby data included in a second standby tablespace of the second database consistent with the change description, thereby maintaining the second standby data in the second standby tablespace as a replicate of the first data in the first primary tablespace.

4. 发明授权

US10827009B2 Systems and methods for use in geolocation resolution of computer network nodes 有权
公开(公告)号：US10827009B2
公开(公告)日：2020-11-03
申请号：US16175257
申请日：2018-10-30
申请人： MASTERCARD INTERNATIONAL INCORPORATED
发明人： Gary R. Horn , Kenneth L. Long
IPC分类号： H04L29/08 , G06Q40/00
摘要： Disclosed are exemplary embodiments of systems and methods for use in assigning locations to network records. One exemplary system includes a processor coupled to a data structure including network records, each record including a network node identifier and a boundary identifier. The processor is configured to, for each boundary identifier, access each of the network records including the boundary identifier. The accessed records include reference and target network records. Each reference network record includes location data indicative of a location of the network node identified in the reference record within the boundary. The processor is configured to determine an aggregate location as a median of the location data for the network nodes identified in the reference network records and assign the aggregate location to each of the target network records as location data indicative of the location of each network node identified in the target records within the boundary.

5. 发明授权

US10567258B2 Systems, methods, apparatus, and computer-readable media for monitoring a data stream 有权
公开(公告)号：US10567258B2
公开(公告)日：2020-02-18
申请号：US15066764
申请日：2016-03-10
申请人： MasterCard International Incorporated
发明人： Kenneth L. Long
IPC分类号： G06F15/16 , H04L12/26 , G06F16/955
摘要： Systems, methods, and apparatus for monitoring flow of data traffic are described. For each of a plurality of transfer units from a data stream (e.g., messages from a message queue), a value of a first field of the transfer unit is mapped to a corresponding counter in random-access memory and the counter is updated. Counter values are periodically copied to a user-accessible region. In one example, message field values are obtained from database log files. In another example, message field values are obtained via an interface called by a database management system.

6. 发明申请

US20200034559A1 SYSTEMS AND METHODS FOR USE IN DATA ACCESS 审中-公开
公开(公告)号：US20200034559A1
公开(公告)日：2020-01-30
申请号：US16043539
申请日：2018-07-24
申请人： MASTERCARD INTERNATIONAL INCORPORATED
发明人： Kenneth L. Long
IPC分类号： G06F21/62 , G06F17/30
摘要： Systems and methods are provided for use in accessing data stored in multiple databases. One exemplary system includes first and second databases. The first database includes a first primary tablespace having first data, a first standby tablespace having first standby data, and a first journal. The first database is configured, in response to a request including a change instruction for the first data, to alter the first data consistent with the change instruction, append a change description indicative of the alteration to the journal, and transmit the journal to the second database. The second database is configured to then receive the journal from the first database and to alter second standby data included in a second standby tablespace of the second database consistent with the change description, thereby maintaining the second standby data in the second standby tablespace as a replicate of the first data in the first primary tablespace.

7. 发明授权

US09607042B2 Systems and methods for optimizing database queries 有权
公开(公告)号：US09607042B2
公开(公告)日：2017-03-28
申请号：US14486706
申请日：2014-09-15
申请人： MasterCard International Incorporated
发明人： Kenneth L. Long
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30451 , G06F17/30584
摘要： A computer-based method for optimizing database queries is provided. The method uses a server computer device including a processor communicatively coupled to a database. The method includes receiving a main query requesting data from a partitioned database table within the database. The partitioned database table includes a plurality of partitions. The method also includes determining a partition list. The partition list includes two or more partitions of the plurality of partitions and excludes at least one partition of the plurality of partitions. The method further includes generating a plurality of sub-queries where each sub-query is associated with one partition included within the partition list, and processing each sub-query of the plurality of sub-queries on the associated partition included within the partition list.

8. 发明申请

US20140201228A1 SYSTEMS AND METHODS FOR MANAGING OFFLINE DATABASE ACCESS 审中-公开
标题翻译：用于管理离线数据库访问的系统和方法
公开(公告)号：US20140201228A1
公开(公告)日：2014-07-17
申请号：US14074245
申请日：2013-11-07
申请人： MASTERCARD INTERNATIONAL INCORPORATED
发明人： Kenneth L. Long
IPC分类号： G06F21/62
摘要： A computer-implemented method for managing access to data stored in a database is provided. The method includes storing in the database a switch parameter having a first value, storing in the database at least two instances of a data object wherein each of the instances includes a unique identifier, receiving a client query from a requestor, determining by the computing device an active instance from the at least two instances based at least in part on comparing the first value of the switch parameter to the unique identifier of each instance, modifying by the computing device the client query at least in part based on the determined active instance to create a resultant query, executing the resultant query against the active instance to generate a resultant data, and providing the resultant data to the requestor.
摘要翻译：提供了一种用于管理对存储在数据库中的数据的访问的计算机实现的方法。该方法包括在数据库中存储具有第一值的交换参数，在数据库中存储数据对象的至少两个实例，其中每个实例包括唯一标识符，从请求者接收客户端查询，由计算设备至少部分地基于将所述切换参数的所述第一值与每个实例的所述唯一标识符进行比较，所述至少两个实例的活动实例至少部分地基于所确定的活动实例来由所述计算设备修改所述客户端查询，创建结果查询，针对活动实例执行结果查询以生成结果数据，并将结果数据提供给请求者。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式