Performing spreadsheet-like calculations in a database system

G - Physics – 06 – F

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

G06F 17/00 (2006.01) G06F 17/30 (2006.01)

Patent

CA 2415183

A method and system for performing spereadsheet-like operations in a database system is described herein. As explained, a database language is extended to introduce new clauses ("spreadsheet-like clauses"), for defining and executing spreadsheet-like operations on data contained within a RDBMS. According to one aspect of the invention, in response to receiving a database query that specifies an operation for manipulating data, data from a relational structure is retrieved and stored in a non-relational structure that can be addressed as a multi-dimensional array. The operation specified in the database query is then performed on the data.

L'invention concerne un procédé et un système qui permettent d'effectuer des opérations du type tableur dans un système de base de données. Un langage de base de données est étendu de façon à introduire de nouvelles clauses ("clauses du type tableur") permettant de définir et d'exécuter des opérations du type tableur sur des données présentes dans un SGBDR. Dans un aspect de l'invention, après réception d'une interrogation de base de données indiquant une opération destinée à manipuler des données, des données provenant d'une structure relationnelle sont extraites et stockées dans une structure non relationnelle adressable comme un réseau multidimensionnel. L'opération indiquée dans l'interrogation de base de données est alors effectuée sur les données.

LandOfFree

Say what you really think

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

Rating

Performing spreadsheet-like calculations in a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Performing spreadsheet-like calculations in a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Performing spreadsheet-like calculations in a database system will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFCA-PAI-O-1433892

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