知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

18 records (took 0.023 seconds)

    HIERARCHICAL TABLESPACE SPACE MANAGEMENT
    11.
    发明申请
    HIERARCHICAL TABLESPACE SPACE MANAGEMENT 有权
    分层空间管理

    公开(公告)号：US20140279849A1

    公开(公告)日：2014-09-18

    申请号：US13804197

    申请日：2013-03-14

    Applicant: ORACLE INTERNATIONAL CORPORATION

    Inventor： Wei Zhang ,  Sujatha Muthulingam ,  Amit Ganesh

    IPC: G06F17/30

    CPC classification number: G06F17/30339 ,  G06F12/023 ,  G06F17/30002 ,  G06F17/30312 ,  G06F17/30324 ,  G06F2212/1032 ,  G06F2212/163

    Abstract: A method, apparatus, and system for hierarchical organization of tablespace free space metadata in a database are provided. The hierarchy is divided into at least two levels: level 1 or L1 bitmap blocks are stored as a shared data structure and map free space in a tablespace, whereas level 2 or L2 bitmap blocks are stored as separate local copies at each database instance and map to the L1 bitmap blocks. This hierarchical organization provides a mechanism for finer grained concurrency control, enabling highly parallel tablespace metadata processing to accommodate the performance requirements of large tablespaces with big data sets. By integrating the hierarchical organization as part of the tablespace stack layer in a database management system (DBMS), implementations can be provided transparently to database end users without demanding any additional administrative, maintenance, or development burdens.

    Abstract translation: 提供了一种用于在数据库中分层组织表空间可用空间元数据的方法，装置和系统。 层次结构分为至少两个层次：级别1或L1位图块作为共享数据结构存储，并映射表空间中的可用空间，而2或L2位图块则作为单独的本地副本存储在每个数据库实例和映射 到L1位图块。 这种分层组织提供了一种更精细并发控制的机制，实现高度并行的表空间元数据处理，以适应具有大数据集的大型表空间的性能要求。 通过将分层组织作为表空间堆栈层的一部分集成到数据库管理系统（DBMS）中，可以向数据库最终用户透明地提供实现，而不需要任何额外的管理，维护或开发负担。

    Tracking row and object database activity into block level heatmaps
    15.
    发明授权
    Tracking row and object database activity into block level heatmaps 有权

    公开(公告)号：US10678760B2

    公开(公告)日：2020-06-09

    申请号：US13804884

    申请日：2013-03-14

    Applicant: Oracle International Corporation

    Inventor： Vineet Marwah ,  Sujatha Muthulingam ,  Amit Ganesh

    IPC: G06F16/00 ,  G06F16/185 ,  G06F3/06 ,  G06F16/21 ,  G06F16/22 ,  G06F16/27 ,  G06F16/11

    Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.

    Scan server for dual-format database
    16.
    发明授权
    Scan server for dual-format database 有权

    公开(公告)号：US09715414B2

    公开(公告)日：2017-07-25

    申请号：US14922084

    申请日：2015-10-23

    Applicant: Oracle International Corporation

    Inventor： Sujatha Muthulingam ,  Amit Ganesh ,  Vineet Marwah

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

    CPC classification number: G06F9/5083 ,  G06F17/30445 ,  G06F17/30595 ,  H04L67/1008 ,  H04L67/42

    Abstract: A method, apparatus, and system for a multi-instance database scan server is provided to process data scan operations for segments within in-memory stores, such as in-memory columnar (IMC) stores. The scan server uses a client/server based model, wherein each database instance in the database management system (“DBMS”) is associated with a client-side scan server and a server-side scan server. The client-side scan server can reside in the data and/or index layer of the DBMS, receiving requests for scan operations on in-memory segments. After receiving a data scan request from an IMC client, the client-side scan server can create several independently executable scanning tasks to process the request. The scanning tasks are each assigned to a particular server-side scan server for processing based on one or more factors, which may include a load balancing component. Additional factors to be considered may include instance affinity and/or NUMA (Non-Uniform Memory Access) affinity.

    PRIORITIZING REPOPULATION OF IN-MEMORY COMPRESSION UNITS
    17.
    发明申请
    PRIORITIZING REPOPULATION OF IN-MEMORY COMPRESSION UNITS 有权
    内存压缩单元的重新排列

    公开(公告)号：US20160085834A1

    公开(公告)日：2016-03-24

    申请号：US14823393

    申请日：2015-08-11

    Applicant: Oracle International Corporation

    Inventor： Michael J. Gleeson ,  Jesse Kamp ,  Vineet Marwah ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Sanket Hase ,  Niloy Mukherjee ,  Sujatha Muthulingam ,  Atrayee Mullick ,  Allison L. Holloway

    IPC: G06F17/30

    CPC classification number: G06F17/30339 ,  G06F17/30377 ,  G06F17/30578

    Abstract: To prioritize repopulation of in-memory compression units (IMCU), a database server compresses, into an IMCU, a plurality of data units from a database table. In response to changes to any of the plurality of data units within the database table, the database server performs the steps of: (a) invalidating corresponding data units in the IMCU; (b) incrementing an invalidity counter of the IMCU that reflects how many data units within the IMCU have been invalidated; (c) receiving a data request that targets one or more of the plurality of data units of the database table; (d) in response to receiving the data request, incrementing an access counter of the IMCU; and (e) determining a priority for repopulating the IMCU based, at least in part, on the invalidity counter and the access counter.

    Abstract translation: 为了优先重新填充内存中的压缩单元（IMCU），数据库服务器从数据库表将多个数据单元压缩到IMCU中。 响应于对数据库表内的多个数据单元中的任一个的改变，数据库服务器执行以下步骤：（a）使IMCU中的相应数据单元无效; （b）增加反映IMCU内有多少数据单位无效的IMCU的无效计数器; （c）接收针对所述数据库表的所述多个数据单元中的一个或多个的数据请求; （d）响应于接收到数据请求，递增IMCU的访问计数器; 以及（e）至少部分地基于无效计数器和访问计数器确定重新填充IMCU的优先级。

    TRACKING ROW AND OBJECT DATABASE ACTIVITY INTO BLOCK LEVEL HEATMAPS
    18.
    发明申请
    TRACKING ROW AND OBJECT DATABASE ACTIVITY INTO BLOCK LEVEL HEATMAPS 审中-公开
    跟踪和对象数据库活动进入块级热源

    公开(公告)号：US20140095438A1

    公开(公告)日：2014-04-03

    申请号：US13804884

    申请日：2013-03-14

    Applicant: ORACLE INTERNATIONAL CORPORATION

    Inventor： Vineet Marwah ,  Sujatha Muthulingam ,  Amit Ganesh

    IPC: G06F17/30

    Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.

    Abstract translation: 提供了一种用于将行和对象数据库活动跟踪到块级散热图的方法，装置和系统。 数据库活动（包括读取，写入和创建）可以由数据库管理系统以最高级别的粒度或行和对象级别进行跟踪。 为了有效地记录跟踪的数据库活动，描述了将活动写入热图的两部分结构。 分层内存组件可以使用动态分配的位图块的稀疏池。 定期地，存储器内部件被持久化到存储的表示组件，可与多个数据库实例共享，这可以包括合并的最后访问时间和/或热图快照的历史以反映随时间的访问。 然后，热图可以被外部化为数据库用户和应用程序，以提供和支持各种功能。

Patent Agency Ranking