知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

18 records (took 0.015 seconds)

    Hierarchical tablespace space management
    2.
    发明授权
    Hierarchical tablespace space management 有权
    分层表空间管理

    公开(公告)号：US09576012B2

    公开(公告)日：2017-02-21

    申请号：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）中，可以向数据库最终用户透明地提供实现，而不需要任何额外的管理，维护或开发负担。

    Self-optimizing database objects using virtual segments
    3.
    发明授权
    Self-optimizing database objects using virtual segments 有权

    公开(公告)号：US12287784B2

    公开(公告)日：2025-04-29

    申请号：US18138242

    申请日：2023-04-24

    Applicant: Oracle International Corporation

    Inventor： Teck Hua Lee ,  Yu Chieh Fu ,  Sujatha Muthulingam ,  Vicente Hernandez Jimenez

    IPC: G06F16/30 ,  G06F16/11 ,  G06F16/21 ,  G06F16/2453 ,  G06F16/28

    Abstract: Techniques are provided for optimizing storage of database data records in segments using sub-segments. A segment may be comprised of a plurality of extents that contain data blocks and a plurality of references to sub-segments. Sub-segments are containers that contain other extents. A request to insert a set of records into a segment may be received by a database management system. Upon receiving the request, a particular sub-segment is selected to temporarily store the set of records. The set of records are inserted into data blocks belonging to an extent of the sub-segment. Access frequency for the set of records is monitored to determine whether the access frequency is less than a first threshold. When the access frequency of a subset of records is less than a first threshold, the subset of records is compressed and inserted into a particular extent of a particular segment.

    SCAN SERVER FOR DUAL-FORMAT DATABASE
    4.
    发明申请
    SCAN SERVER FOR DUAL-FORMAT DATABASE 有权

    公开(公告)号：US20170116043A1

    公开(公告)日：2017-04-27

    申请号：US14922084

    申请日：2015-10-23

    Applicant: Oracle International Corporation

    Inventor： Sujatha Muthulingam ,  Amit Ganesh ,  Vineet Marwah

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

    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 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.

    SELF-OPTIMIZING DATABASE OBJECTS USING VIRTUAL SEGMENTS
    5.
    发明公开
    SELF-OPTIMIZING DATABASE OBJECTS USING VIRTUAL SEGMENTS 审中-公开

    公开(公告)号：US20240354299A1

    公开(公告)日：2024-10-24

    申请号：US18138242

    申请日：2023-04-24

    Applicant: Oracle International Corporation

    Inventor： Teck Hua Lee ,  Yu Chieh Fu ,  Sujatha Muthulingam ,  Vicente Hernandez Jimenez

    IPC: G06F16/2453 ,  G06F16/11 ,  G06F16/21 ,  G06F16/28

    CPC classification number: G06F16/2453 ,  G06F16/113 ,  G06F16/214 ,  G06F16/282

    Abstract: Techniques are provided for optimizing storage of database data records in segments using sub-segments. A segment may be comprised of a plurality of extents that contain data blocks and a plurality of references to sub-segments. Sub-segments are containers that contain other extents. A request to insert a set of records into a segment may be received by a database management system. Upon receiving the request, a particular sub-segment is selected to temporarily store the set of records. The set of records are inserted into data blocks belonging to an extent of the sub-segment. Access frequency for the set of records is monitored to determine whether the access frequency is less than a first threshold. When the access frequency of a subset of records is less than a first threshold, the subset of records is compressed and inserted into a particular extent of a particular segment.

    Tracking Row And Object Database Activity Into Block Level Heatmaps
    7.
    发明申请
    Tracking Row And Object Database Activity Into Block Level Heatmaps 审中-公开

    公开(公告)号：US20200257663A1

    公开(公告)日：2020-08-13

    申请号：US16861180

    申请日：2020-04-28

    Applicant: Oracle International Corporation

    Inventor： Vineet Marwah ,  Sujatha Muthulingam ,  Amit Ganesh

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

    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.

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

    公开(公告)号：US20160371314A1

    公开(公告)日：2016-12-22

    申请号：US15250788

    申请日：2016-08-29

    Applicant: Oracle International Corporation

    Inventor： Wei Zhang ,  Sujatha Muthulingam ,  Amit Ganesh

    IPC: G06F17/30 ,  G06F12/02

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

    Abstract: A method, non-transitory computer readable media, 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 blocks are stored as a shared data structure and map free space in a tablespace, whereas level 2 or L2 blocks are stored as separate local copies at each database instance and map to the L1 bitmap blocks. The L2 blocks each indicate, for each L1 block of a respective subset of a plurality of L1 blocks, a maximum size of a largest extent that can be allocated.

    Abstract translation: 提供了一种用于数据库中的表空间空闲元数据的层次组织的方法，非暂时性计算机可读介质和系统。 层次分为至少两个层次：级别1或L1块作为共享数据结构存储，并映射表空间中的可用空间，而层2或L2块则作为单独的本地副本存储在每个数据库实例中并映射到 L1位图块。 L2块对于多个L1块的相应子集的每个L1块指示可以被分配的最大范围的最大大小。

Patent Agency Ranking