-
公开(公告)号:US20180349457A1
公开(公告)日:2018-12-06
申请号:US16039710
申请日:2018-07-19
发明人: Benoit Dageville , Thierry Cruanes , Marcin Zukowski , Allison Waingold Lee , Philipp Thomas Unterbrunner
CPC分类号: G06F17/30575 , G06F9/4881 , G06F9/5016 , G06F9/5044 , G06F9/5083 , G06F9/5088 , G06F17/30106 , G06F17/302 , G06F17/30292 , G06F17/30315 , G06F17/30371 , G06F17/30445 , G06F17/30463 , G06F17/30466 , G06F17/30469 , G06F17/30477 , G06F17/3048 , G06F17/30498 , G06F17/30545 , G06F17/30598 , G06F17/30864 , G06F17/30867 , G06F17/30914 , H04L67/1095 , H04L67/1097 , H04L67/2842
摘要: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.
-
公开(公告)号:US20180322127A1
公开(公告)日:2018-11-08
申请号:US15586119
申请日:2017-05-03
申请人: ServiceNow, Inc.
发明人: Joseph Michael Davis , Joey Mart
IPC分类号: G06F17/30
CPC分类号: G06F17/3056 , G06F17/30315 , G06F17/30336 , G06F17/30339 , G06F17/30584
摘要: The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.
-
公开(公告)号:US20180307731A1
公开(公告)日:2018-10-25
申请号:US15946128
申请日:2018-04-05
申请人: SAS Institute Inc.
发明人: Wei Xiao
CPC分类号: G06F17/30516 , G06F17/16 , G06F17/30315 , G06T11/206 , G06T2200/24
摘要: A data streaming environment provides a summary of streaming data from a sensor that is an Internet of things device. An input interface receives the streaming data. A processor is communicatively coupled to the input interface for processing the streaming data. The processed streaming data includes, but is not limited to, a plurality of records and variables that describe a characteristic of a physical object. A computer-readable medium has instructions stored thereon that, when executed by the processor, cause the processor to execute a correlation update application with the received streaming data to provide a correlation between two variables of the streaming data. The non-transitory computer-readable medium further stores sum and bin data for the correlation update application to compute the correlation. The output interface provides the processed streaming data to be visually presented in one or more data graphs on a display device.
-
公开(公告)号:US09965644B2
公开(公告)日:2018-05-08
申请号:US15702690
申请日:2017-09-12
CPC分类号: G06F21/6218 , G06F17/30032 , G06F17/30312 , G06F17/30315 , G06F17/30395 , G06F17/30424 , G06F17/30545 , G06F17/30595 , G06F17/30598 , G06F21/6227 , G06F21/6245
摘要: A database security system protects a data table at both the column level and the individual data record level. Access to data records within the data table is governed by categories assigned to data records, by user roles assigned to users, and by a set of security access tables. A first access table maps data record identifiers to data record categories, data record protection schemes, and corresponding scheme keys. A second access table maps user roles to data record categories. A third access table maps column identifiers to column protection schemes and corresponding scheme keys. A fourth access table maps user roles to column identifiers. If a user requests access to a data record, the security access tables are queried using the data record identifier, the associated column identifier, and the user roles associated with the user to determine if the user can access the requested data record.
-
公开(公告)号:US20180046400A1
公开(公告)日:2018-02-15
申请号:US15792895
申请日:2017-10-25
发明人: Kousei Kawamura , Koichi Masuda , Sosuke Matsui , Yutaka Oishi , Takahiro Tsuda
IPC分类号: G06F3/06
CPC分类号: G06F3/0644 , G06F3/0604 , G06F3/0643 , G06F3/0682 , G06F17/30315 , G11B5/00817 , G11B20/1201 , G11B27/032 , G11B27/107 , G11B2020/1295 , G11B2220/95
摘要: A method for writing data from a table to a tape includes setting a number of partitions on the tape, where the number of partitions is greater than or equal to a number of columns of the table to be written to the tape, and writing data from each column of the table to at least one partition of the tape, the at least one partition including two or more wraps, the data is written from a top of the two or more wraps towards a bottom of the two or more wraps in a direction of a width of the at least one partition. The written data is reciprocated from a beginning of the tape to an end of the tape in a longitudinal direction of the tape such that writing of a last data entry of one column ends at a beginning of the two or more wraps.
-
公开(公告)号:US09886459B2
公开(公告)日:2018-02-06
申请号:US14338219
申请日:2014-07-22
IPC分类号: G06F17/30 , G06F15/80 , G06F15/78 , G06F12/1018 , G06F3/06 , G06F12/0815
CPC分类号: G06F17/30315 , G06F3/0604 , G06F3/064 , G06F3/065 , G06F3/0689 , G06F12/0815 , G06F12/1018 , G06F15/78 , G06F15/8007 , G06F15/8076 , G06F15/8084 , G06F17/30312 , G06F17/30377 , G06F17/30477 , G06F17/30595 , G06F2003/0697 , G06F2212/1021 , G06F2212/1032 , G06F2212/2542 , G06F2212/313
摘要: Methods and apparatuses for determining set-membership using Single Instruction Multiple Data (“SIMD”) architecture are presented herein. Specifically, methods and apparatuses are discussed for determining, in parallel, whether multiple values in a first set of values are members of a second set of values. Many of the methods and systems discussed herein are applied to determining whether one or more rows in a dictionary-encoded column of a database table satisfy one or more conditions based on the dictionary-encoded column. However, the methods and systems discussed herein may apply to many applications executed on a SIMD processor using set-membership tests.
-
公开(公告)号:US09881041B2
公开(公告)日:2018-01-30
申请号:US14136724
申请日:2013-12-20
CPC分类号: G06F17/30362 , G06F11/1448 , G06F17/30309 , G06F17/30312 , G06F17/30315 , G06F17/30339 , G06F17/30368 , G06F17/30371 , G06F2201/80 , G06F2201/825 , G06F2201/84 , G06F2201/87
摘要: A delta store giving row-level versioning semantics to a non-row-level versioning underlying store is described. An example method includes establishing a column-based in-memory database including a main store and a delta store, where the main store allows only non-concurrent transactions on a same table and the delta store has a plurality of row-visibility bitmaps implementing a row-level versioning mechanism that allows concurrent transactions on the same table. A local RID space is established for a table fragment, that for each table in the database, the data of the table is stored in one or more main table fragment in the main store and in one or more delta table fragments in the delta store. Each table fragment has a local RID space, and the local RID space is a collection of one-based contiguous integer local RIDs (Row IDs) describing local positions of the rows of the table fragment.
-
8.
公开(公告)号:US20180011690A1
公开(公告)日:2018-01-11
申请号:US15693513
申请日:2017-09-01
发明人: Rini Kaushik
CPC分类号: G06F7/24 , G06F12/0246 , G06F17/30315 , G06F17/30519 , G06F2212/1044 , G06F2212/7208
摘要: A technique relates to flash-optimized data layout of a dataset for queries. Selection columns are stored in flash memory according to a selection optimized layout, where the selection optimized layout is configured to optimize predicate matching and data skipping. The selection optimized layout, for each selection column, is formed by storing a selection column dictionary filled with unique data values in a given selection column, where the unique data values are stored in sorted order in the selection column dictionary. Row position designations are stored corresponding to each row position that the unique data values are present within the given selection column, without duplicating storage of any of the unique data values that occur more than once in the given selection column.
-
公开(公告)号:US09858306B2
公开(公告)日:2018-01-02
申请号:US15397827
申请日:2017-01-04
发明人: Sridhar Shetty , Sugantha Subbiah
CPC分类号: G06F17/30339 , G06F12/1408 , G06F12/1458 , G06F17/30073 , G06F17/30076 , G06F17/30315 , G06F17/30477 , G06F2201/80 , G06F2212/163 , G06F2212/402
摘要: A method, and associated system, for archiving to a single database table information located across multiple database tables. A threshold number of times specified by the end user and a period of time specified by the end user are received. At least one archival data value is identified. Each archival data value corresponds to a unique data value of at least one data value residing in a table of the multiple database tables. A determination is made that the specified threshold number of times has not been exceeded, within the specified period of time, by a number of times each archival data value has been moved within the multiple database tables. At least one archive file in the single database table is stored. Each archive file of the at least one archive file includes the at least one archive data value.
-
公开(公告)号:US20170371949A1
公开(公告)日:2017-12-28
申请号:US15189220
申请日:2016-06-22
申请人: SAP SE
发明人: Yann Le Biannic
IPC分类号: G06F17/30
CPC分类号: G06F17/30598 , G06F17/30312 , G06F17/30315 , G06F17/30477
摘要: A system comprises reception of a dataset comprising at least one dataset attribute and one or more instances of each dataset attribute, determination of a similarity value between instances of each pair of one of the at least one dataset attribute and one of a plurality of stored attributes, determination of an intersection between instances of each pair of one of the at least one dataset attribute and one of the stored attributes having a similarity greater than a threshold, and generation of metadata associating a dataset attribute with a semantic entity with which a stored attribute having a similarity to the dataset attribute greater than the threshold is associated.
-
-
-
-
-
-
-
-
-