Performing spreadsheet-like calculations in a database system

A method and system for performing spreadsheet-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 RD...

Full description

Saved in:
Bibliographic Details
Main Authors GREGORY DORMAN, FRED ZEMKE, ANDREW WITKOWSKI, MARTIN ROTH, GETIN OZBUTUN
Format Patent
LanguageEnglish
Published 10.05.2007
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

Abstract A method and system for performing spreadsheet-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 the performed on then data.
AbstractList A method and system for performing spreadsheet-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 the performed on then data.
Author GREGORY DORMAN
ANDREW WITKOWSKI
GETIN OZBUTUN
MARTIN ROTH
FRED ZEMKE
Author_xml – fullname: GREGORY DORMAN
– fullname: FRED ZEMKE
– fullname: ANDREW WITKOWSKI
– fullname: MARTIN ROTH
– fullname: GETIN OZBUTUN
BookMark eNrjYmDJy89L5WSwDUgtSssvys3MS1coLihKTUwpzkhNLdHNycxOVUhOzEkuzUksyczPK1bIzFNIVEhJLElMSixOVSiuLC5JzeVhYE1LzClO5YXS3Awqbq4hzh66qQX58anFBYnJqXmpJfGOoUYGBkZAYGlm7ORkZEykMgCFqjOL
ContentType Patent
DBID EVB
DatabaseName esp@cenet
DatabaseTitleList
Database_xml – sequence: 1
  dbid: EVB
  name: esp@cenet
  url: http://worldwide.espacenet.com/singleLineSearch?locale=en_EP
  sourceTypes: Open Access Repository
DeliveryMethod fulltext_linktorsrc
Discipline Medicine
Chemistry
Sciences
Physics
ExternalDocumentID AU2002222963BB2
GroupedDBID EVB
ID FETCH-epo_espacenet_AU2002222963BB23
IEDL.DBID EVB
IngestDate Fri Jul 19 14:20:30 EDT 2024
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-epo_espacenet_AU2002222963BB23
Notes Application Number: AU20020222963
OpenAccessLink https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20070510&DB=EPODOC&CC=AU&NR=2002222963B2
ParticipantIDs epo_espacenet_AU2002222963BB2
PublicationCentury 2000
PublicationDate 20070510
PublicationDateYYYYMMDD 2007-05-10
PublicationDate_xml – month: 05
  year: 2007
  text: 20070510
  day: 10
PublicationDecade 2000
PublicationYear 2007
RelatedCompanies ORACLE INTERNATIONAL CORPORATION
RelatedCompanies_xml – name: ORACLE INTERNATIONAL CORPORATION
Score 2.677644
Snippet A method and system for performing spreadsheet-like operations in a database system is described herein. As explained, a database language is extended to...
SourceID epo
SourceType Open Access Repository
SubjectTerms CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Title Performing spreadsheet-like calculations in a database system
URI https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20070510&DB=EPODOC&locale=&CC=AU&NR=2002222963B2
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwhV1LS8QwEB6W9XnTqvhayWHprVj7ih4WsS8WYR_IruxtadIUi0u32Ip_30m21T3pLSQQwiQz3ySZ-Qagz6llpbjvhpUx03BsygzE-dRwKUV_grvCozLBeTT2hnPneeEuOrBqc2EUT-iXIkdEjeKo77Wy1-XvI1aoYiurW5Zj1_oxng1Cvb0dU3nG9NAfRNNJOAn0IMCbpD5-UUU8ZOlqz_bRYO9IR1oy7UevvsxLKbdBJT6C3SnOV9TH0BGFBgdBW3tNg_1R8-WtwZ6K0eQVdjZ6WJ0AWjIV74-4Q6oS_b60ehOiNlb5uyAodd4U5apIXpCEyDBQCVdkw9t8Cv04mgVDA1e0_BHA8mm-tXzfss-gW6wLcQ6EmpmT2A-cZhwb7C5hnslo5kqvyjPv-QX0_pzq8p_xKzjcPGZKutJr6NYfn6KHKFyzGyW8b2Dqijs
link.rule.ids 230,309,786,891,25594,76906
linkProvider European Patent Office
linkToHtml http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwhV3dT8IwEL8Q_MA3RY1faB_I3hbnxlZ9IMZtLFNhEAOGN0K7Li6SQdyM_77XsilP-ta0SdNce_e7tne_A2hzapox7rtuJszQOxZlOuJ8rNuUoj_BbeFQmeA8iJxw0nma2tMaLKpcGMUT-qXIEVGjOOp7oez16vcRy1exlfk1S7FreR-Mu75W3Y6pPGOa73Z7o6E_9DTPw5ukFr2oIh6ydLVjuWiwt6jk55XO06sr81JWm6AS7MP2COfLigOoiawJDa-qvdaE3UH55d2EHRWjyXPsLPUwPwS0ZCreH3GH5Cv0--L8TYhCX6TvgqDUeVmUKydpRuZEhoFKuCJr3uYjaAe9sRfquKLZjwBmD5ON5bumdQz1bJmJEyDUSDpz647ThGOD3cyZYzCa2NKrcoxbfgqtP6c6-2f8ChrheNCf9R-j53PYWz9sSurSC6gXH5-ihYhcsEslyG8A740o
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=Performing+spreadsheet-like+calculations+in+a+database+system&rft.inventor=GREGORY+DORMAN&rft.inventor=FRED+ZEMKE&rft.inventor=ANDREW+WITKOWSKI&rft.inventor=MARTIN+ROTH&rft.inventor=GETIN+OZBUTUN&rft.date=2007-05-10&rft.externalDBID=B2&rft.externalDocID=AU2002222963BB2