Method and system for defining sets by querying relational...

G - Physics – 06 – F

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

G06F 17/30 (2006.01)

Patent

CA 2530056

The present invention relates to the usage pattern, commonly found in many software applications, of defining sets of objects based on object attributes. A specifically designed set definition language for defining sets, called SDL, is described and a software system that implements this language efficiently on top of a standard relational database management system (RDBMS) is presented. The unique features of the SDL language are the implicit constraints that are enforced on the relational data that belong to the objects. Unique to the SDL system is also the logical metadata of dimensions that enables the SDL system to enforce these constraints across relations. The SDL system utilizes several optimization techniques to enable efficient implementation on top of RDBMS. It is also shown how the SDL language and the SQL language can be merged with bidirectional inlining using syntactic gates. Query composition tools are also described that facilitate the creation of SDL expressions.

L'invention concerne le modèle d'utilisation qui fait normalement partie de nombreuses applications logicielles et qui consiste à définir des ensembles d'objets sur la base des attributs des objets. L'invention décrit un langage de définition d'ensembles spécifiquement conçu pour définir des ensembles, appelé SDL, ainsi qu'un système logiciel qui met efficacement en oeuvre ce langage par-dessus un système standard de gestion de banques de données relationnelles (RDBMS). Les caractéristiques uniques du langage SDL sont les contraintes implicites appliquées aux données relationnelles qui appartiennent aux objets. Une caractéristique unique du système SDL sont aussi les métadonnées logiques de dimensions qui permettent au système SDL d'appliquer ces contraintes par-dessus les relations. Le système SDL utilise plusieurs techniques d'optimisation pour permettre sa mise en oeuvre efficace par-dessus un système RDBMS. L'invention montre également comment le langage SDL et le langage SQL peuvent fusionner avec une inclusion par référence bidirectionnelle en utilisant des éléments logiques syntaxiques. L'invention concerne également des outils de composition de consultations qui facilitent la création d'expressions en langage SDL.

LandOfFree

Say what you really think

Search LandOfFree.com for Canadian inventors and patents. Rate them and share your experience with other people.

Rating

Method and system for defining sets by querying relational... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for defining sets by querying relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for defining sets by querying relational... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFCA-PAI-O-1613058

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.