Data migration in a networked computer environment

    公开(公告)号:US10783124B2

    公开(公告)日:2020-09-22

    申请号:US15833339

    申请日:2017-12-06

    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.

    Data migration in a networked computer environment

    公开(公告)号:US10649965B2

    公开(公告)日:2020-05-12

    申请号:US15350435

    申请日:2016-11-14

    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.

    Processing database statements for a relational database

    公开(公告)号:US10592471B2

    公开(公告)日:2020-03-17

    申请号:US14948847

    申请日:2015-11-23

    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.

    Outer join optimizations in database management systems

    公开(公告)号:US10127277B2

    公开(公告)日:2018-11-13

    申请号:US14814544

    申请日:2015-07-31

    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.

    Creating a social group with mobile phone vibration

    公开(公告)号:US10834543B2

    公开(公告)日:2020-11-10

    申请号:US16199861

    申请日:2018-11-26

    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.

    DATA MIGRATION IN A NETWORKED COMPUTER ENVIRONMENT

    公开(公告)号:US20180137112A1

    公开(公告)日:2018-05-17

    申请号:US15350435

    申请日:2016-11-14

    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.

    TEST DATA MANAGEMENT
    8.
    发明申请

    公开(公告)号:US20170351746A1

    公开(公告)日:2017-12-07

    申请号:US15173982

    申请日:2016-06-06

    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.

    Test data management
    9.
    发明授权

    公开(公告)号:US10860616B2

    公开(公告)日:2020-12-08

    申请号:US15173982

    申请日:2016-06-06

    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.

Patent Agency Ranking