Abstract: The system includes a parsing module to receive one or more input constructs from a source database in a first syntactical dialect, parse the one or more input constructs received in the first syntactical dialect using an external domain specific language parser, converts the one or more input constructs upon parsing into an abstract syntax tree corresponding to the first syntactical dialect of the source database. A canonicalization module transforms the abstract syntax tree into a canonical abstract syntax tree by utilizing a library of a plurality of operators and expressions corresponding to the first syntactical dialect. A tree optimization module optimizes the canonical abstract syntax tree by utilizing a set of optimization rules. An input translation module converts the canonical abstract syntax tree into an output code corresponding to a second syntactical dialect associated with a target database for compatibility using a translation layer.

Abstract: A system for data warehouse migration is disclosed. The system 100 includes a parsing module 110 to receive one or more input constructs from a source database in a first syntactical dialect, parse the one or more input constructs received in the first syntactical dialect using an external domain specific language parser, converts the one or more input constructs upon parsing into an abstract syntax tree corresponding to the first syntactical dialect of the source database. A canonicalization module 120 transforms the abstract syntax tree into a canonical abstract syntax tree by utilizing a library of a plurality of operators and expressions corresponding to the first syntactical dialect. A tree optimization module 130 optimizes the canonical abstract syntax tree by utilizing a set of optimization rules.