-
公开(公告)号:US10783124B2
公开(公告)日:2020-09-22
申请号:US15833339
申请日:2017-12-06
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Konrad Emanowicz , Gareth Jenkins , Enda McCallig , Lei Pan
Abstract: Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.
-
公开(公告)号:US10649965B2
公开(公告)日:2020-05-12
申请号:US15350435
申请日:2016-11-14
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Konrad Emanowicz , Gareth Jenkins , Enda McCallig , Lei Pan
Abstract: Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.
-
公开(公告)号:US10592471B2
公开(公告)日:2020-03-17
申请号:US14948847
申请日:2015-11-23
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Joseph Duffy , Lei Pan , David M. Tilson
IPC: G06F16/2455 , G06F16/16
Abstract: A computer-implemented method of a database statement for a relational database. The database comprises one or more tables comprising one or more data rows. A database statement is received. A set of predicates from the database statement and a set of data rows from the tables to use to generate the result of the database statement are determined. A set of interdiction statements applicable to one or more data rows is obtained. For each predicate, a set of masks applicable to one or more data rows is obtained, where for each mask, the data masked by the mask is used by the predicate. It is determined if a data row has an applicable interdiction statement, and contains data masked by a mask. If so, the result of the database statement without using the result of applying the predicate to the data row.
-
公开(公告)号:US10127277B2
公开(公告)日:2018-11-13
申请号:US14814544
申请日:2015-07-31
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Peter J. Duffy , Lei Pan , David M. Tilson
IPC: G06F17/30
Abstract: In one embodiment, a method of processing a structured query language (SQL) statement is provided, comprising: determining whether a first query and a second query are equivalent, the first and second queries being respectively the left side and the right side operands of the OUTER JOIN operation; determining whether a SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation; and responsive to determining that the first query and the second query are equivalent and that the SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation, transforming the SQL statement into an optimized query SQL statement by removing the OUTER JOIN operation.
-
公开(公告)号:US11054925B2
公开(公告)日:2021-07-06
申请号:US16256621
申请日:2019-01-24
Applicant: International Business Machines Corporation
Inventor: Bin Xu , Yin Xia , Lu Fu , Lei Pan , Xiao Lin Sun
IPC: G06F3/0488 , G06F3/041 , G06F9/30 , B60K37/06 , B60K35/00
Abstract: A computer-implemented method, a computer system and a computer program product that facilitate adjusting screen sensitivity of a touch screen are proposed. The computer-implemented method comprises: determining, by a device operatively coupled to one or more processing units, one or more operational areas for an interface of an application running on a touch screen device; and determining, by the device, a screen sensitivity for each of the one or more operational areas respectively.
-
公开(公告)号:US10834543B2
公开(公告)日:2020-11-10
申请号:US16199861
申请日:2018-11-26
Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor: Yin Xia , Lu Fu , Zhang Yu Lin , Lei Pan , Jie Hu , Bin Xu , Xiao Lin Sun
Abstract: Initiating a communication group of devices using device vibration includes encoding a message into a vibration signal using an encoder in a master device, the message including a connection request. A vibration pattern is emitted using a vibration motor by controlling the vibration motor to vibrate with a pattern corresponding to modulations of the vibration signal to send the message through a medium in contact with the master device. A response vibration pattern is received from responding devices using a sensor, the response vibration pattern carrying a response message. The response vibration pattern is decoded with a decoder of the master device to extract the response message from the response vibration pattern. A communication group is established at a host according to the response message for communication between the master device and the responding devices.
-
公开(公告)号:US20180137112A1
公开(公告)日:2018-05-17
申请号:US15350435
申请日:2016-11-14
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Konrad Emanowicz , Gareth Jenkins , Enda McCallig , Lei Pan
CPC classification number: G06F16/214 , H04L67/10
Abstract: Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.
-
公开(公告)号:US20170351746A1
公开(公告)日:2017-12-07
申请号:US15173982
申请日:2016-06-06
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Konrad Emanowicz , Enda McCallig , Aslam F. Nomani , Lei Pan
CPC classification number: G06F16/285 , G06F11/3684 , G06F16/221 , G06F16/2237 , G06F16/2365
Abstract: As disclosed herein, a method includes receiving a plurality of datasets from a database, wherein each dataset comprises one or more data fields represented in a single data format, and wherein the data fields from at least two of the datasets are represented in different data formats, combining the plurality of datasets to provide a created data column corresponding to all of the data fields from the plurality of datasets, organizing the data column into data clusters, wherein each data cluster includes data fields represented in a single data format, and wherein each data field belongs to a data cluster, providing a key-value map referencing data fields with respect to their corresponding data formats, and verifying the database with respect to the created column. A corresponding computer program product and computer system are also disclosed.
-
公开(公告)号:US10860616B2
公开(公告)日:2020-12-08
申请号:US15173982
申请日:2016-06-06
Applicant: International Business Machines Corporation
Inventor: Pedro M. Barbas , Konrad Emanowicz , Enda McCallig , Aslam F. Nomani , Lei Pan
Abstract: As disclosed herein, a method includes receiving a plurality of datasets from a database, wherein each dataset comprises one or more data fields represented in a single data format, and wherein the data fields from at least two of the datasets are represented in different data formats, combining the plurality of datasets to provide a created data column corresponding to all of the data fields from the plurality of datasets, organizing the data column into data clusters, wherein each data cluster includes data fields represented in a single data format, and wherein each data field belongs to a data cluster, providing a key-value map referencing data fields with respect to their corresponding data formats, and verifying the database with respect to the created column. A corresponding computer program product and computer system are also disclosed.
-
公开(公告)号:US20200241674A1
公开(公告)日:2020-07-30
申请号:US16256621
申请日:2019-01-24
Applicant: International Business Machines Corporation
Inventor: Bin Xu , Yin Xia , Lu Fu , Lei Pan , Xiao Lin Sun
IPC: G06F3/041 , G06F3/0488 , G06F9/30 , B60K37/06
Abstract: A computer-implemented. method, a computer system and a computer program product that facilitate adjusting screen sensitivity of a touch screen are proposed. The computer-implemented method comprises: determining, by a device operatively coupled to one or more processing units, one or more operational areas for an interface of an application running on a touch screen device; and determining, by the device, a screen sensitivity for each of the one or more operational areas respectively.
-
-
-
-
-
-
-
-
-