METHOD FOR AUTOMATED DOCUMENTATION OF STRUCTURED QUERY LANGUAGE INCLUDING WORKFLOW AND DATA DEPENDENCIES

摘要

An improved documentation tool for software database systems is provided that self- documents and stores code segments in uncompiled form to increase efficiency of code development and operation. Embodiments of the documentation tool provide a methodology for obtaining all detailed information about SQL code including workflow, and all detailed dependencies. The inventive methodology will work with all current database platforms, and is intended to be primarily rules-driven, although the latter is not necessary. Embodiments of the methodology leverage readily identifiable keywords within SQL to make it possible to establish a rules-based process which can then be applied to all other database platforms and coding languages.

主权项

1. A method for automated documentation of structured query language (SQL) comprising:
removing keywords, symbols or command phrases not relating to data movement in a database and noting their positions for alternate use; mapping existing rules to the result set or applying rules individually; parsing the core code; and generating the automated documentation.