Invention Grant
- Patent Title: System for providing structured query language access to non-relational data stores
-
Application No.: US13098298Application Date: 2011-04-29
-
Publication No.: US09886483B1Publication Date: 2018-02-06
- Inventor: Guy Anthony Harrison , Gregory John Cottman , Timothy Harold Jarvis , Kieron Spencer Briggs , Ben Kersten , Johny Mattsson
- Applicant: Guy Anthony Harrison , Gregory John Cottman , Timothy Harold Jarvis , Kieron Spencer Briggs , Ben Kersten , Johny Mattsson
- Applicant Address: US CA Aliso Viejo
- Assignee: Quest Software Inc.
- Current Assignee: Quest Software Inc.
- Current Assignee Address: US CA Aliso Viejo
- Agency: Winstead PC
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Systems and methods for providing structured query language (SQL) access to non-relational data stores are described. SQL access can be provided to a non-relational data store in one embodiment by mapping storage attributes of the data store to one or more virtual relational tables. The virtual tables can include a schema representation of data stored in a non-relational data store without actually including the data in the virtual tables. In some embodiments, these systems and methods therefore advantageously merge certain benefits of relational database architectures with the scalability benefits of certain non-relational data store architectures. Certain features of the systems and methods described herein can also be used with existing relational databases. For example, the systems and methods described herein can perform join or similar operations between a relational table in one data store and a data object in another data store.
Information query