Data movement from a database to a distributed file system

摘要

Provided are techniques for data movement. An activity is created that overrides existing security, that is associated with a user, that defines one or more source tables in a relational database and one or more target tables that are available to the user for the activity, and that provides security credentials of an author of the activity for use by the user, wherein the one or more target tables represent data in one or more target files in a file system. The activity is executed using the security credentials of the author to move data in a source table of the one or more source tables to a target file of the one or more target files, wherein a target table of the one or more target tables is defined over the target file. Access is provided to the user to the moved data using the target table.

主权项

1. A computer system, comprising:
one or more processors, one or more computer-readable memories and one or more computer-readable, tangible storage devices; and program instructions, stored on at least one of the one or more computer-readable, tangible storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, to perform operations of: creating an activity that overrides existing security, that is associated with a user, that defines one or more source tables in a relational database that are available to the user for the activity, and that provides security credentials of an author of the activity for use by the user; executing the activity using the security credentials of the author to move relational data in a source table of the one or more source tables to the file system by:reading the relational data;
converting the read relational data to a target file in the file system, wherein the data in the target file is not relational;defining a target table over the target file;
creating an index that maps the relational data to data in the target file; and providing access to the user to the data in the target file in the file system using the defined target table and the created index.