强大的SQL语法分析器：SQLReader

说起SQL语法分析器，可能很多人首先会想到antlr、calcite或者sqlparser等。


这里给大家介绍一款强大的国产SQL语法分析器：SQLReader。


它具有以下特点：

1、独立性，不依赖任何第三方工具；

2、高效性，一秒以内可以分析多个SQL脚本；

3、结果详细，兼顾到字段级血缘和条件级血缘；

4、兼容性，支持各种常见数据库的语法；

5、智能识别，可以自动识别出各种脚本(如：perl、shell、存储过程)中的SQL语句；

6、易用性，无需过多配置，一步分析，结果自动结构化保存到数据库表中；


SQLReader是基于SQL图形化数据血缘系统的核心，是数据资产地图实现的基础。


围绕SQLReader的出现，相信将来会衍生出越来越多强大的功能或产品。


这些功能或产品，将会大幅度提升企业对数据管理和治理的效率。






2020-07-23 16:46:02 | 张良 | 技术 & 提问 | 阅读2326次

回 复 :

2022-09-03 22:41:31 | :

收费吗？

2022-09-07 14:23:48 | tomjim2 :

免费？？？？


2023-02-15 17:50:08 | :

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV19LP1','BAY106','BDEV19LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL03LP1','BAY202','BRFL03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL03LP2','BAY202','BRFL03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL04LP1','BAY202','BRFL04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE107-MI1','BAY107','OPE107-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE107-MO1','BAY107','OPE107-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT15LP2','BAY213','BPLT15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT14LP2','BAY213','BPLT14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX213-0A','BAY02','EX213-0A','PORT','0','0','EX213-01','BAY213',5,0,5,0,'0'),

('EX213-0B','BAY02','EX213-0B','PORT','0','1','EX213-02','BAY213',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX213-01','BAY213','EX213-01','PORT','0','1','EX213-0A','BAY02',5,0,5,0,'0'),

('EX213-02','BAY213','EX213-02','PORT','0','0','EX213-0B','BAY02',5,0,5,0,'0'),

('OPE213-MI1','BAY213','OPE213-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE213-MO1','BAY213','OPE213-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM03LP1','BAY208','BATM03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM03LP2','BAY208','BATM03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI06LP1','BAY109','BAOI06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI06LP2','BAY109','BAOI06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX105-02','BAY105','EX105-02','PORT','0','1','EX105-0B','BAY01',5,0,5,0,'0'),

('OPE105-MI1','BAY105','OPE105-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OPE105-MO1','BAY105','OPE105-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM02LP1','BAY106','BATM02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM02LP2','BAY106','BATM02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX106-01','BAY106','EX106-01','PORT','0','0','EX106-0A','BAY01',5,0,5,0,'0'),

('EX106-02','BAY106','EX106-02','PORT','0','1','EX106-0B','BAY01',5,0,5,0,'0'),

('OPE106-MI1','BAY106','OPE106-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE106-MO1','BAY106','OPE106-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BSOT01LP2','BAY108','BSOT01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT01LP3','BAY108','BSOT01LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT02LP1','BAY108','BSOT02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSOT02LP2','BAY108','BSOT02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT02LP3','BAY108','BSOT02LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX108-01','BAY108','EX108-01','PORT','0','1','EX108-0A','BAY01',5,0,5,0,'0'),

('EX108-02','BAY108','EX108-02','PORT','0','0','EX108-0B','BAY01',5,0,5,0,'0'),

('OPE108-MI1','BAY108','OPE108-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE108-MO1','BAY108','OPE108-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD01LP1','BAY109','BPVD01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD01LP2','BAY109','BPVD01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD02LP1','BAY109','BPVD02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD02LP2','BAY109','BPVD02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPVD03LP1','BAY109','BPVD03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD03LP2','BAY109','BPVD03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD04LP1','BAY109','BPVD04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD04LP2','BAY109','BPVD04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD05LP1','BAY109','BPVD05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD05LP2','BAY109','BPVD05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX109-01','BAY109','EX109-01','PORT','0','0','EX109-0A','BAY01',5,0,5,0,'0'),

('EX109-02','BAY109','EX109-02','PORT','0','1','EX109-0B','BAY01',5,0,5,0,'0'),

('OPE109-MI1','BAY109','OPE109-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE109-MO1','BAY109','OPE109-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX110-01','BAY110','EX110-01','PORT','0','1','EX110-0A','BAY01',5,0,5,0,'0'),

('EX110-02','BAY110','EX110-02','PORT','0','0','EX110-0B','BAY01',5,0,5,0,'0'),

('EX110-03','BAY110','EX110-03','PORT','0','1','EX110-0C','BAY01',5,0,5,0,'0'),

('EX110-04','BAY110','EX110-04','PORT','0','0','EX110-0D','BAY01',5,0,5,0,'0'),

('OPE110-MI1','BAY110','OPE110-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE110-MO1','BAY110','OPE110-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX111-01','BAY111','EX111-01','PORT','0','1','EX111-0A','BAY01',5,0,5,0,'0'),

('EX111-02','BAY111','EX111-02','PORT','0','1','EX111-0B','BAY01',5,0,5,0,'0'),

('OPE111-MI1','BAY111','OPE111-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE111-MO1','BAY111','OPE111-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX112-01','BAY112','EX112-01','PORT','0','0','EX112-0A','BAY01',5,0,5,0,'0'),

('EX112-02','BAY112','EX112-02','PORT','0','0','EX112-0B','BAY01',5,0,5,0,'0'),

('OPE112-MI1','BAY112','OPE112-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE112-MO1','BAY112','OPE112-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX201-01','BAY201','EX201-01','PORT','0','1','EX201-0A','BAY02',5,0,5,0,'0'),

('EX201-02','BAY201','EX201-02','PORT','0','0','EX201-0B','BAY02',5,0,5,0,'0'),

('EX202-01','BAY202','EX202-01','PORT','0','1','EX202-0A','BAY02',5,0,5,0,'0'),

('EX202-02','BAY202','EX202-02','PORT','0','0','EX202-0B','BAY02',5,0,5,0,'0'),

('EX203-01','BAY203','EX203-01','PORT','0','1','EX203-0A','BAY02',5,0,5,0,'0'),

('EX203-02','BAY203','EX203-02','PORT','0','0','EX203-0B','BAY02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV21LP1','BAY105','BDEV21LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX204-01','BAY204','EX204-01','PORT','0','1','EX204-0A','BAY02',5,0,5,0,'0'),

('EX204-02','BAY204','EX204-02','PORT','0','0','EX204-0B','BAY02',5,0,5,0,'0'),

('EX204-03','BAY204','EX204-03','PORT','0','1','EX204-0C','BAY02',5,0,5,0,'0'),

('EX204-04','BAY204','EX204-04','PORT','0','0','EX204-0D','BAY02',5,0,5,0,'0'),

('EX205-01','BAY205','EX205-01','PORT','0','1','EX205-0A','BAY02',5,0,5,0,'0'),

('EX205-02','BAY205','EX205-02','PORT','0','0','EX205-0B','BAY02',5,0,5,0,'0'),

('EX206-01','BAY206','EX206-01','PORT','0','1','EX206-0A','BAY02',5,0,5,0,'0'),

('EX206-02','BAY206','EX206-02','PORT','0','0','EX206-0B','BAY02',5,0,5,0,'0'),

('EX207-01','BAY207','EX207-01','PORT','0','1','EX207-0A','BAY02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BID