The invention relates to a
data processing task relation setting method and
system. The method includes the steps of obtaining at least one
SQL script in a
data processing task, carrying out morphology analysis and semantic analysis on
SQL sentences in each
SQL script in the at least one SQL script to build a
data lineage relation of the SQL sentences, building a
data lineage relation of the SQL scripts according to the
data lineage relation of the SQL sentences, building a data lineage relation of the
data processing task according to the data lineage relation of the SQL scripts in the at least one SQL script, determining
data input and output of a
data level and a
task level of the data
processing task, and determining and setting the relation between the data
processing task and another data
processing task according to the data lineage relation and the
data level of the data processing task. Intelligent analysis and setting of the relation of the SQL data processing tasks can be achieved, the
automation degree of data task scheduling configuration is improved and accuracy and efficiency of data operation and maintenance are achieved.