-
公开(公告)号：US20150310045A1
公开(公告)日：2015-10-29
申请号：US14292229
申请日：2014-05-30
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , G06F17/2264 , G06F17/30339 , G06F17/30477
摘要： A method, a system, and a computer program product for managing a database are disclosed. Managing the database includes managing an index of a table of the database. Managing the index includes determining the table includes a first field having a first input value configured to identify a first dynamic data function utilized to determine a first output value for the first field. In embodiments, managing the index includes determining the first dynamic data function is deterministic, determining the first output value for the first field using the first dynamic data function, and storing the first output value for the first field. In embodiments, managing the index includes determining the first dynamic data function is nondeterministic, determining a first special value to represent the first output value for the first field, and storing the first special value for the first field.
摘要翻译： 公开了一种用于管理数据库的方法，系统和计算机程序产品。 管理数据库包括管理数据库表的索引。 管理索引包括确定该表包括第一字段，其具有被配置为识别用于确定第一字段的第一输出值的第一动态数据功能的第一输入值。 在实施例中，管理索引包括确定第一动态数据功能是确定性的，使用第一动态数据功能确定第一场的第一输出值，并存储第一场的第一输出值。 在实施例中，管理索引包括确定第一动态数据功能是非确定性的，确定第一特殊值以表示第一字段的第一输出值，以及存储第一字段的第一特殊值。
-
公开(公告)号：US20150213254A1
公开(公告)日：2015-07-30
申请号：US14246665
申请日：2014-04-07
IPC分类号： G06F21/44
CPC分类号： H04W12/08 , G06F21/35 , G06F21/44 , G06F21/554 , H04L63/083 , H04W12/06
摘要： A wireless access point receives a set of invalid passwords from at least one wireless device attempting to connect to a network through the wireless access point. The wireless access point reduces RF signal power in response to receiving the set of invalid passwords.
-
公开(公告)号：US20150163223A1
公开(公告)日：2015-06-11
申请号：US14100923
申请日：2013-12-09
发明人： Bin Cao , Jessica R. Eidem , Brian R. Muras
CPC分类号： G06F21/602 , G06F9/5022 , G06F2209/5011 , H04L41/0896 , H04L41/5096 , H04L63/061 , H04L63/102 , H04L67/1008
摘要： Methods, apparatuses, and computer program products for managing resources in a distributed computing environment that includes a plurality of resources and a resource recycling unit for storing discarded resources are provided. Embodiments include a management system maintaining within a resource recycling unit, a plurality of discarded resources of the distributed computing environment. Embodiments also include the management system receiving from a user, a request for a resource of the distributed computing environment and in response to receiving the request, selecting a first discarded resource from the plurality of discarded resources of the resource recycling unit. Embodiments also include the management system providing the selected first discarded resource to the user.
摘要翻译： 提供了用于在包括多个资源的分布式计算环境中管理资源的方法，设备和计算机程序产品以及用于存储丢弃的资源的资源回收单元。 实施例包括维护在资源回收单元内的管理系统，分布式计算环境的多个丢弃的资源。 实施例还包括从用户接收的管理系统对分布式计算环境的资源的请求，并且响应于接收到该请求，从资源回收单元的多个丢弃的资源中选择第一丢弃的资源。 实施例还包括向用户提供所选择的第一丢弃资源的管理系统。
-
公开(公告)号：US20150142762A1
公开(公告)日：2015-05-21
申请号：US14604737
申请日：2015-01-25
IPC分类号： G06F17/30
CPC分类号： G06F17/30501 , G06F17/30289 , G06F17/30463 , G06F17/3048 , G06F17/30483
摘要： In an embodiment, a query plan is compressed to data in a cache at a high compression level if a runtime of a query that the query plan implements is greater than a high time threshold. The query plan is compressed to the data in the cache at a medium compression level if the runtime of the query that the query plan implements is less than the high time threshold and greater than a low time threshold. The query plan is stored to the data in the cache at an uncompressed level if the runtime of the query that the query plan implements is less than the low time threshold.
摘要翻译： 在一个实施例中，如果查询计划实现的查询的运行时间大于高时间阈值，则在高压缩级别将查询计划压缩到高速缓存中的数据。 如果查询计划实现的查询的运行时间小于高时间阈值且大于低时间阈值，则查询计划将以中等压缩级别压缩到缓存中的数据。 如果查询计划实现的查询的运行时间小于低时间阈值，则查询计划将以未压缩级别存储在缓存中的数据中。
-
45.发明申请DATA ALLOCATION CONTAINERS IN A PARTITIONED TABLE OF A COMPUTER DATABASE SYSTEM FOR HOLDING DATA BASED ON USAGE 有权用于基于使用保存数据的计算机数据库系统的分区表中的数据分配容器公开(公告)号：US20150088903A1
公开(公告)日：2015-03-26
申请号：US14253583
申请日：2014-04-15
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F17/30315 , G06F17/30551
摘要： An apparatus and method utilize partitioned database tables divided into data allocation containers (DACs) where data is placed into the DACs based on usage of the data in past queries. Records that are used most often are placed together and records that are used less often are placed together to improve database performance. In preferred embodiments, a database manager determines where to place data into the DACs based on how often the data is selected by a database query using a DAC selection ratio (DSR). The database manager may determine when to perform table maintenance to move rows of data to the appropriate DACs based on a timestamp or last check date (LCD) stored in the database.
摘要翻译： 一种装置和方法利用划分成数据分配容器（DAC）的分区数据库表，其中数据被放置到DAC中，基于过去查询中数据的使用。 最经常使用的记录放在一起，而不常使用的记录放在一起，以提高数据库性能。 在优选实施例中，数据库管理器基于使用DAC选择比（DSR）通过数据库查询选择数据的频率来确定将数据放入DAC的位置。 数据库管理器可以基于存储在数据库中的时间戳或最后检查日期（LCD）来确定何时执行表维护以将数据行移动到适当的DAC。
-
公开(公告)号：US20140324876A1
公开(公告)日：2014-10-30
申请号：US14060219
申请日：2013-10-22
IPC分类号： G06F17/30
CPC分类号： G06F17/30631 , G06F17/30312 , G06F17/30324 , G06F17/30339 , G06F17/30377
摘要： A method, system, and computer program product to manage a database is disclosed. The method, system, and computer program product may include structuring the database to have a first table having an index and a second table. A first key of the first table may be related to a second key of the second table. The method, system, and computer program product may include creating an entry locator in the index. The method, system, and computer program product may include maintaining an association between the second key of the second table and the entry locator of the index.
摘要翻译： 公开了一种管理数据库的方法，系统和计算机程序产品。 方法，系统和计算机程序产品可以包括构造数据库以具有具有索引的第一表和第二表。 第一表的第一个键可能与第二个表的第二个键有关。 方法，系统和计算机程序产品可以包括在索引中创建条目定位符。 方法，系统和计算机程序产品可以包括维持第二表的第二密钥和索引的入口定位器之间的关联。
-
公开(公告)号：US20140324874A1
公开(公告)日：2014-10-30
申请号：US13870158
申请日：2013-04-25
IPC分类号： G06F17/30
CPC分类号： G06F17/30631 , G06F17/30312 , G06F17/30324 , G06F17/30339 , G06F17/30377
摘要： A method, system, and computer program product to manage a database is disclosed. The method, system, and computer program product may include structuring the database to have a first table having an index and a second table. A first key of the first table may be related to a second key of the second table. The method, system, and computer program product may include creating an entry locator in the index. The method, system, and computer program product may include maintaining an association between the second key of the second table and the entry locator of the index.
-
公开(公告)号：US08849797B2
公开(公告)日：2014-09-30
申请号：US13772228
申请日：2013-02-20
发明人： James L. Denton , Brian R. Muras
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , G06F17/30442
摘要： A query governor intelligently sets tailored thresholds for a query accessing a computer database. The query governor preferably generates a tailored threshold for each query sent to the database for execution. The tailored threshold for the query is preferably compared to an estimated query execution time to determine whether to execute the query. The query governor uses one or more factors applied to a standard threshold to generate the tailored threshold. The factors preferably include user factors and query factors. These factors are dynamically adjusted by the query governor in an intelligent way to increase optimal use of the database. Other factors may include factors such as job priority factor, resource factor and an application factor.
摘要翻译： 查询调控器智能地设置访问计算机数据库的查询的定制阈值。 查询调控器优选地为发送到数据库的每个查询生成修改的阈值以供执行。 优选地将查询的定制阈值与估计的查询执行时间进行比较，以确定是否执行查询。 查询调控器使用应用于标准阈值的一个或多个因子来生成修改的阈值。 这些因素最好包括用户因素和查询因素。 这些因素由查询调控器以智能方式动态调整，以增加数据库的最佳使用。 其他因素可能包括诸如工作优先级因素，资源因素和应用因素等因素。
-
公开(公告)号：US20140229428A1
公开(公告)日：2014-08-14
申请号：US13764040
申请日：2013-02-11
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30339
摘要： A method and computer-readable storage media are provided for reorganizing a database. The method may monitor the database to determine whether the database reorganization is required. The method may also include determining the database reorganization is required. The method may further include determining a first and second amount of space to add to the database for additional entries of a category of data according to a first and second predictive sizing calculation. The method may further include the selecting of either the first or second amount of space to add to the database for additional entries of the category of data during the reorganization. The method may further include performing the reorganization of the database including allocating the selected amount of space to add to the database for additional entries in the database of the category of data by using the computer system operatively coupled to the storage device.
-
50.发明申请公开(公告)号：US20140172905A1
公开(公告)日：2014-06-19
申请号：US13718097
申请日：2012-12-18
IPC分类号： G06F17/30
CPC分类号： G06F17/30864 , G06F17/30286 , G06F17/30477
摘要： In an embodiment, a request is received that specifies a function and a specified key value. Rows from all tables that are accessible from the specified key value are transitively searched, wherein the transitively searching further comprises finding values in a plurality of pairs of columns, wherein found rows that are found by the transitively searching comprise values in a respective first column of the plurality of pairs of columns that satisfy a dependency relationship with values in a respective second column of the plurality of pairs of columns. The function is executed against only the found rows.
摘要翻译： 在一个实施例中，接收到指定功能和指定的键值的请求。 从指定的键值可访问的来自所有表的行都被传递性地搜索，其中，所述传递性搜索还包括查找多对列中的值，其中通过所述传递性搜索找到的找到的行包括相应的第一列中的值 满足与所述多对列的相应第二列中的值的依赖关系的多对列。 该函数仅对所找到的行执行。
-
-
-
-
-
-
-
-
-
搜索结果
305 条记录 (耗时 0.031 秒)
