会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明申请
    • System and method for optimally configuring software systems for a NUMA platform
    • 用于为NUMA平台优化配置软件系统的系统和方法
    • US20060206489A1
    • 2006-09-14
    • US11077579
    • 2005-03-11
    • James FinnieTaavi BurnsMatthew HurasSunil KamathLan PhamKevin RoseAamer SachedinaRoger Zheng
    • James FinnieTaavi BurnsMatthew HurasSunil KamathLan PhamKevin RoseAamer SachedinaRoger Zheng
    • G06F17/30
    • G06F9/5016G06F9/5061
    • A method and system for improving memory access patterns of software systems on NUMA systems discovers NUMA system resources, where the NUMA system resources comprises a plurality of NUMA nodes; determines a plurality of database threads, processes, and objects for a database configuration; and generates a policy which assigns the plurality of database threads, processes, and objects to the plurality of NUMA nodes, wherein the generating is performed prior to initialization of the plurality of database threads, processes, and objects. The assignment of the database threads, processes, or objects to NUMA nodes is such that the amount of remote memory accesses is reduced. When the database thread, process, or object initializes, the database server queries the policy for its assigned NUMA node(s). The database thread, process, or object is then bound to the assigned NUMA node(s). In this manner, the costs from remote memory accesses are significantly reduced.
    • 用于改进NUMA系统上的软件系统的存储器访问模式的方法和系统发现NUMA系统资源,其中NUMA系统资源包括多个NUMA节点; 确定数据库配置的多个数据库线程,进程和对象; 并且生成将多个数据库线程,进程和对象分配给多个NUMA节点的策略,其中在多个数据库线程,进程和对象的初始化之前执行生成。 将数据库线程,进程或对象分配给NUMA节点使得远程内存访问量减少。 当数据库线程,进程或对象初始化时,数据库服务器向其分配的NUMA节点查询策略。 然后将数据库线程,进程或对象绑定到已分配的NUMA节点。 以这种方式,远程存储器访问的成本显着降低。
    • 5. 发明申请
    • System and method for starting a buffer pool
    • 启动缓冲池的系统和方法
    • US20050050443A1
    • 2005-03-03
    • US10921469
    • 2004-08-19
    • Aamer SachedinaMatthew HurasKeriley Romanufa
    • Aamer SachedinaMatthew HurasKeriley Romanufa
    • G06F17/00G06F17/30H04L12/16
    • G06F17/30312
    • For an information retrieval system coupled to a buffer pool maintaining a plurality of pages of recently accessed information for subsequent re-access, a technique for starting the buffer pool is provided. The technique facilitates a quicker start to the buffer pool by deferring allocation of page storing portions, for example, until they are needed. The technique makes the buffer pool available for storing pages while deferring allocation of a page storing portion of the buffer pool and allocates the page storing portion of the buffer pool in response to a demand to store pages to the buffer pool. The technique may be used to re-start a buffer pool with pages stored to a memory coupled to the information retrieval system where the pages where stored upon a buffer pool shutdown. Further, buffer pool readers or prefetchers may be configured to read pages for storing to the buffer pool and allocate the page storing portions of the buffer pool in response to instructions to read particular pages.
    • 对于一个信息检索系统,耦合到缓冲池,保持多页最近访问的信息用于随后的重新访问,提供了启动缓冲池的技术。 该技术通过延迟页面存储部分的分配来促进对缓冲池的更快启动,例如直到需要它们。 该技术使得缓冲池可用于存储页面,同时延迟缓冲池的页面存储部分的分配,并且响应于将页面存储到缓冲池的需求而分配缓冲池的页面存储部分。 该技术可用于重新启动缓冲池,其中页面存储到耦合到信息检索系统的存储器,其中存储在缓冲池关闭时的页面。 此外,缓冲池读取器或预取器可以被配置为读取用于存储到缓冲池的页面,并响应于读取特定页面的指令来分配存储缓冲器池的部分的页面。
    • 7. 发明申请
    • System and method for discriminatory replaying of log files during tablespace recovery in a database management system
    • 在数据库管理系统中的表空间恢复期间,用于区分性地重播日志文件的系统和方法
    • US20050278393A1
    • 2005-12-15
    • US10425804
    • 2003-04-29
    • Matthew HurasDale McInnisEffi OfarMichael WinerRoger Zheng
    • Matthew HurasDale McInnisEffi OfarMichael WinerRoger Zheng
    • G06F17/30
    • G06F17/30368Y10S707/99953
    • A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on a lock instruction.
    • 系统和相关方法通过仅处理所需的日志文件,并选择在恢复期间进行恢复时要处理的日志文件来选择性地处理日志文件以增强表空间恢复的性能。 系统和方法跳过不包含要恢复的表空间的感兴趣记录的日志文件的处理,并确定日志文件是否包含任何需要播放的内容,特别是用于恢复数据库中的子系统,例如 一个表空间。 日志文件的预处理未完成,而在创建日志文件时收集与日志文件ID信息相关的表空间ID。 在表空间恢复期间使用交叉相关信息来选择性地确定要处理哪些日志文件。 在没有全部数据库系统正在恢复的情况下,可能会跳过某些日志文件。 可以恢复数据库的子集,例如表空间,以及基于锁定指令确定要处理哪些日志文件。