-
公开(公告)号：US20160092134A1
公开(公告)日：2016-03-31
申请号：US14865476
申请日：2015-09-25
Applicant: Oracle International Corporation
Inventor： John Raitto , Uri Shaft
CPC classification number: G06F3/0673 , G06F3/0608 , G06F3/0632 , G06F3/0638 , G06F16/283
Abstract: According to an embodiment, storage configurations are identified for storing items, such as database tables, partitions, or any other types of objects or data structures, within a desired storage area, such as an in-memory data store or any other limited storage resource. Each of the storage configurations is assigned to a particular item of the items. Each of the storage configurations associates the assigned particular item with one or more storage configuration options. Storage recommendations are generated for at least a set of the storage configurations. A different storage recommendation exists for each storage configuration in the set of the storage configurations. The storage recommendation associates the storage configuration with a range of possible storage sizes for a particular storage area of a system. Based on the storage recommendations, recommended system configurations a generated for different possible storage sizes of the particular storage area.
Abstract translation: 根据实施例，存储配置被识别用于在期望的存储区域（诸如存储器内数据存储器或任何其他有限的存储资源）内存储诸如数据库表，分区或任何其它类型的对象或数据结构之类的项目 。 每个存储配置被分配给项目的特定项目。 每个存储配置将分配的特定项目与一个或多个存储配置选项相关联。 为至少一组存储配置生成存储建议。 对存储配置集中的每个存储配置存在不同的存储建议。 存储建议将存储配置与系统的特定存储区域的可能存储大小的范围相关联。 根据存储建议，为特定存储区域的不同可能的存储大小生成推荐的系统配置。
-
公开(公告)号：US09639562B2
公开(公告)日：2017-05-02
申请号：US13842843
申请日：2013-03-15
Applicant: Oracle International Corporation
Inventor： John Raitto , Tirthankar Lahiri , Marie-Anne Neimat , Chih-Ping Wang
IPC: G06F17/30
CPC classification number: G06F17/30292 , G06F17/30442 , G06F17/30463 , G06F17/30575
Abstract: A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.
-
公开(公告)号：US10466936B2
公开(公告)日：2019-11-05
申请号：US14865476
申请日：2015-09-25
Applicant: Oracle International Corporation
Inventor： John Raitto , Uri Shaft
Abstract: According to an embodiment, storage configurations are identified for storing items, such as database tables, partitions, or any other types of objects or data structures, within a desired storage area, such as an in-memory data store or any other limited storage resource. Each of the storage configurations is assigned to a particular item of the items. Each of the storage configurations associates the assigned particular item with one or more storage configuration options. Storage recommendations are generated for at least a set of the storage configurations. A different storage recommendation exists for each storage configuration in the set of the storage configurations. The storage recommendation associates the storage configuration with a range of possible storage sizes for a particular storage area of a system. Based on the storage recommendations, recommended system configurations a generated for different possible storage sizes of the particular storage area.
-
-
Search Results
3
records
(took 0.012 seconds)
