VERSIONED RELATIONAL DATASET MANAGEMENT
    55.
    发明公开

    公开(公告)号:US20230334031A1

    公开(公告)日:2023-10-19

    申请号:US18336743

    申请日:2023-06-16

    CPC classification number: G06F16/219 G06F16/2393 G06F16/2237 G06F16/2358

    Abstract: A versioned dataset is managed. An updated versioned dataset is created by applying a structured query to a specific version of multiple versions of the versioned dataset stored in the backing dataset. Data of the versions including the specific version remain unchanged. A versioned dataset catalogue is updated to include in association with the updated dataset version, the structured query and lineage indicating that the updated versioned dataset includes a successor of the specific version. An affiliation encoding associated with the updated versioned dataset indicating which data of the updated versioned dataset matches data of the specific version and which data of the updated versioned dataset is deleted relative to data of the specific version, is updated. A database view of the updated versioned dataset is generated by selecting rows and projecting columns of the backing dataset corresponding to the updated versioned dataset according to the affiliation encoding.

    ABSTRACT DEFAULT COLUMN TYPE IN TABLES
    59.
    发明申请

    公开(公告)号:US20180341689A1

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

    申请号:US15602373

    申请日:2017-05-23

    Applicant: SAP SE

    Abstract: Methods, systems, and computer-readable storage media for providing a table in a database system, the table including a column having a column data type set to an abstract data type, receiving a first data record to be added to the table, the first data record including a first data value to be included in the column, determining a first data type corresponding to a data type of the first data value, changing the column data type from the abstract data type to the first data type, receiving a second data record to be added to the table, the second data record including a second data value to be including in the column, determining a second data type corresponding to the data type of the second data value, and selectively changing the column data type to the second data type.

Patent Agency Ranking