会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 4. 发明授权
    • Automatic detection and correction of hot pages in a database system
    • 在数据库系统中自动检测和更正热页
    • US08250111B2
    • 2012-08-21
    • US12394786
    • 2009-02-27
    • Matthew Albert HurasKeriley Kay RomanufaAamer SachedinaXun Xue
    • Matthew Albert HurasKeriley Kay RomanufaAamer SachedinaXun Xue
    • G06F17/30
    • G06F17/30306
    • According to one embodiment of the present invention, a method of detecting and correcting hot pages in a database system includes monitoring transactions involving pages in a database and determining if one of the transactions had to wait for access to one of the pages; incrementing a page contention counter each time one of the transactions had to wait for access to one of the pages. The method then determines if the page contention counter exceeds a predetermined threshold and monitors transactions on one of the pages for which the page contention count was exceeded. The method then determines if a row was accessed in the page for which the page contention count was exceeded and increments a reference count for the accessed row. The accessed rows are flagged when the reference count exceeds a second predetermined threshold. The flagged rows are moved to another page in the database.
    • 根据本发明的一个实施例,一种在数据库系统中检测和校正热页面的方法包括监视涉及数据库中的页面的事务,并且确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时,增加页面争用计数器。 该方法然后确定页面争用计数器是否超过预定阈值,并且监视超出页面争用次数的页面之一上的事务。 该方法然后确定在超出页面争用次数的页面中是否访问了一行,并增加访问行的引用计数。 当参考计数超过第二预定阈值时,所访问的行被标记。 标记的行被移动到数据库中的另一个页面。
    • 7. 发明申请
    • COMMITMENT OF TRANSACTIONS IN A DISTRIBUTED SYSTEM
    • 分布式系统中的交易承诺
    • US20080235245A1
    • 2008-09-25
    • US12131006
    • 2008-05-30
    • Matthew Albert HURASTimothy Jon Vincent
    • Matthew Albert HURASTimothy Jon Vincent
    • G06F17/30
    • G06F9/466
    • A computer program product and system for committing transactions in a distributed system are provided. The method, computer program product, and system provide for receiving a request from a client to commit a transaction at a coordinator node in the distributed system, tracking a tail log sequence number for every other node in the distributed system, determining a max log sequence number associated with the transaction for each participant node in the distributed system, and committing the transaction at the coordinator node when the tail log sequence number for each participant node is greater than or equal to the max log sequence number associated with the transaction at the respective participant node.
    • 提供了一种用于在分布式系统中进行交易的计算机程序产品和系统。 方法,计算机程序产品和系统提供从客户端接收在分布式系统中的协调器节点处提交事务的请求,跟踪分布式系统中每个其他节点的尾部日志序列号,确定最大对数序列 与分布式系统中的每个参与者节点的事务相关联的号码,并且当每个参与者节点的尾部日志序列号大于或等于与相应的交易相关联的最大对数序列号时,在协调器节点处提交事务 参与者节点。
    • 8. 发明申请
    • ENHANCED RELATIONAL DATABASE MANAGEMENT SYSTEM AND METHOD
    • 增强的关系数据库管理系统和方法
    • US20080154842A1
    • 2008-06-26
    • US11613773
    • 2006-12-20
    • Matthew Albert HurasKeriley Kay RomanufaAamer Sachedina
    • Matthew Albert HurasKeriley Kay RomanufaAamer Sachedina
    • G06F17/30
    • G06F16/2453G06F16/21G06F16/284
    • A method to enhance relational database management system resiliency and query operations by minimizing CPU overhead and database page access latency and by facilitating database restoration and query efficiency. The method includes creating a clean database page in a buffer pool of a relational database management system, granting exclusive access to the clean database page within the buffer pool to an application that transitions the clean database page to a dirty database page by altering data store thereon, immediately downgrading exclusive access to the dirty database page to shared access in response to receiving an exclusive access termination request from the application, writing the dirty database page to a physical log, and releasing share access to the dirty database page.
    • 通过最小化CPU开销和数据库页面访问延迟以及促进数据库恢复和查询效率来增强关系数据库管理系统弹性和查询操作的方法。 该方法包括在关系数据库管理系统的缓冲池中创建干净的数据库页面,授予对缓冲池内的干净数据库页面的独占访问权,通过改变其上的数据存储将清理数据库页面转换到脏数据库页面的应用程序 响应于从应用程序接收到独占访问终止请求,将脏数据库页面写入物理日志,并释放对脏数据库页面的共享访问,立即将对脏数据库页面的独占访问权降级到共享访问。