Detecting and applying database schema changes to reports
US8204848B2 · kind B2 · utility
6Cited by
2References
17Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Nov 17, 2009 |
| Grant date | Jun 19, 2012 |
| Priority date | — |
| Expiry date | May 23, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/217
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method to detect database schema changes are described. In various embodiments, a method of the embodiments detects database schema changes via triggers. In various embodiments, the changes are detected by comparing database schemas and determining modifications to database tables and database columns thereof. In various embodiments, the detected changes are applied to a report by generating a parse tree relevant for the modifications to database tables and columns; and traversing the tree to produce a statement to change the report to be relevant for the modifications to database tables and columns.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.