InnovationQ will be updated on Sunday, May 20, from 10am - noon ET. You may experience brief service interruptions during that time.
Browse Prior Art Database

GRC Query Language

IP.com Disclosure Number: IPCOM000233185D
Publication Date: 2013-Nov-29
Document File: 1 page(s) / 36K

Publishing Venue

The IP.com Prior Art Database


Disclosed is a method to provide a simple and generic declarative syntax (query language) and method to access data for the Governance, Risk and Compliance (GRC) application domain.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 61% of the total text.

Page 01 of 1

GRC Query Language

A method is needed to greatly simplify data access employed internally for building applications, simplify integration with other products, and simplify the use by external customers and the internal service organization.

The solution to do so is a method based on a subset of Structured Query Language (SQL)-92 + extensions, is read-only, and supports metadata based queries and full-text search queries. Extensions to joins allow for hierarchal traversal between entities defined by the domain model.

The novel method consists of an SQL-like query language tailored to access data from a specific application domain such as Governance, Risk and Compliance (GRC). ANother Tool for Language Recognition (ANTLR) has been used to specify the formal grammar for this language. Queries refer to application domain constructs that are well understood and often defined by standards . This query language maps these domain level objects to tables and columns from a Relational Database Management System (RDBMS), relieving users from having any knowledge or understanding of the underlying physical database model for these objects. In fact, the query language is entirely responsible for mapping the domain level objects (from user specified models) to the physical RDBMS physical model. Given the scope and extent of the models supported, the physical model can become quite complex. A metadata layer has been introduced to maintain mapping information between the domain...