DE60130475D1 - Durchführung von kalkulationen des tabellenkalkulationstyps in einem datenbanksystem - Google Patents
Durchführung von kalkulationen des tabellenkalkulationstyps in einem datenbanksystemInfo
- Publication number
- DE60130475D1 DE60130475D1 DE60130475T DE60130475T DE60130475D1 DE 60130475 D1 DE60130475 D1 DE 60130475D1 DE 60130475 T DE60130475 T DE 60130475T DE 60130475 T DE60130475 T DE 60130475T DE 60130475 D1 DE60130475 D1 DE 60130475D1
- Authority
- DE
- Germany
- Prior art keywords
- data
- calculations
- database system
- implementation
- spreadsheet
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Lifetime
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/244—Grouping and aggregation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/953—Organization of data
- Y10S707/954—Relational
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99932—Access augmentation or optimizing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
- Y10S707/99945—Object-oriented database structure processing
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US21885100P | 2000-07-13 | 2000-07-13 | |
US218851P | 2000-07-13 | ||
PCT/US2001/041094 WO2002006999A2 (en) | 2000-07-13 | 2001-06-20 | Performing spreadsheet-like calculations in a database system |
Publications (2)
Publication Number | Publication Date |
---|---|
DE60130475D1 true DE60130475D1 (de) | 2007-10-25 |
DE60130475T2 DE60130475T2 (de) | 2008-06-19 |
Family
ID=22816749
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
DE60130475T Expired - Lifetime DE60130475T2 (de) | 2000-07-13 | 2001-06-20 | Durchführung von kalkulationen eines tabellenkalkulationstyps in einem datenbanksystem |
Country Status (9)
Country | Link |
---|---|
US (1) | US6985895B2 (de) |
EP (1) | EP1323066B1 (de) |
JP (1) | JP4465147B2 (de) |
AT (1) | ATE373272T1 (de) |
AU (2) | AU2002222963B2 (de) |
CA (1) | CA2415183C (de) |
DE (1) | DE60130475T2 (de) |
HK (1) | HK1052777B (de) |
WO (1) | WO2002006999A2 (de) |
Families Citing this family (58)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7228300B2 (en) | 1998-10-05 | 2007-06-05 | Oracle International Corporation | Caching the results of security policy functions |
US8275974B2 (en) * | 2001-01-16 | 2012-09-25 | Outlooksoft Corporation | Systems and methods providing dynamic spreadsheet functionality |
US7251776B2 (en) * | 2001-07-13 | 2007-07-31 | Netview Technologies, Inc. | System and method for efficiently and flexibly utilizing spreadsheet information |
US6907422B1 (en) * | 2001-12-18 | 2005-06-14 | Siebel Systems, Inc. | Method and system for access and display of data from large data sets |
DE10300334A1 (de) * | 2003-01-02 | 2004-07-22 | Kalsbach, Jörg | Verfahren und Datenablage zur Auswertung von Massendaten |
WO2004092977A2 (en) * | 2003-04-18 | 2004-10-28 | International Business Machines Corporation | System and method in a data table for creating recursive scalable template instances |
US7320083B2 (en) * | 2003-04-23 | 2008-01-15 | Dot Hill Systems Corporation | Apparatus and method for storage controller to deterministically kill one of redundant servers integrated within the storage controller chassis |
US7243096B2 (en) * | 2003-04-29 | 2007-07-10 | International Business Machines Corporation | Method and system in an electronic data table for managing order oriented criteria |
CA2427202A1 (en) * | 2003-04-30 | 2004-10-30 | Ibm Canada Limited - Ibm Canada Limitee | Method and system for aggregation subquery join elimination |
US7530012B2 (en) * | 2003-05-22 | 2009-05-05 | International Business Machines Corporation | Incorporation of spreadsheet formulas of multi-dimensional cube data into a multi-dimensional cube |
CA2429910A1 (en) * | 2003-05-27 | 2004-11-27 | Cognos Incorporated | System and method of query transformation |
US7530013B2 (en) * | 2003-06-13 | 2009-05-05 | Ultimate Risk Solutions, Llc | Optimizer of interdependent information |
US7233956B2 (en) * | 2003-08-12 | 2007-06-19 | International Business Machines Corporation | Method and apparatus for data migration between databases |
US7251650B2 (en) * | 2003-08-25 | 2007-07-31 | International Business Machines Corporation | Method, system, and article of manufacture for processing updates to insert operations |
US7979384B2 (en) * | 2003-11-06 | 2011-07-12 | Oracle International Corporation | Analytic enhancements to model clause in structured query language (SQL) |
FR2864275A1 (fr) * | 2003-12-19 | 2005-06-24 | Thales Sa | Procede de mise a jour d'une base de donnees creee avec un tableur |
US7676453B2 (en) * | 2004-04-22 | 2010-03-09 | Oracle International Corporation | Partial query caching |
US7664804B2 (en) * | 2004-06-01 | 2010-02-16 | Microsoft Corporation | Method, system, and apparatus for exposing workbook ranges as data sources |
US7707490B2 (en) * | 2004-06-23 | 2010-04-27 | Microsoft Corporation | Systems and methods for flexible report designs including table, matrix and hybrid designs |
US20060026498A1 (en) * | 2004-07-30 | 2006-02-02 | Microsoft Corporation | Systems and methods for controlling report properties based on aggregate scope |
US7559023B2 (en) | 2004-08-27 | 2009-07-07 | Microsoft Corporation | Systems and methods for declaratively controlling the visual state of items in a report |
US20060085386A1 (en) * | 2004-10-19 | 2006-04-20 | Microsoft Corporation | Two pass calculation to optimize formula calculations for a spreadsheet |
US7590972B2 (en) * | 2004-10-28 | 2009-09-15 | Cogency Software, Inc. | Role-oriented development environment |
US7779008B2 (en) * | 2005-02-16 | 2010-08-17 | Oracle International Corporation | Parallel partition-wise aggregation |
US20080010237A1 (en) * | 2006-07-06 | 2008-01-10 | American Express Travel Related Services Company, Inc. | System and Method for Managing Multi-Dimensional Data |
US20080140623A1 (en) * | 2006-12-11 | 2008-06-12 | Microsoft Corporation | Recursive reporting via a spreadsheet |
US7779031B2 (en) * | 2007-02-15 | 2010-08-17 | International Business Machines Corporation | Multidimensional query simplification using data access service having local calculation engine |
US20080222601A1 (en) * | 2007-03-06 | 2008-09-11 | Cauvin Kenneth L | Method and system for processing data contained within COBOL or PL/I record description entries and storage medium for storing instructions which effectuate the method |
US9715710B2 (en) * | 2007-03-30 | 2017-07-25 | International Business Machines Corporation | Method and system for forecasting using an online analytical processing database |
US20080294612A1 (en) * | 2007-05-22 | 2008-11-27 | It-Workplace | Method For Generating A Representation Of A Query |
US7747657B2 (en) * | 2007-06-08 | 2010-06-29 | International Business Machines Corporation | Mapping hierarchical data from a query result into a tabular format with jagged rows |
US20090108858A1 (en) * | 2007-10-24 | 2009-04-30 | Industrial Technology Research Institute | Methods and systems for calibrating rc circuits |
US7836100B2 (en) * | 2007-10-26 | 2010-11-16 | Microsoft Corporation | Calculating and storing data structures including using calculated columns associated with a database system |
US8140549B2 (en) | 2007-10-31 | 2012-03-20 | Juan Carlos Barinaga | Methods and arrangements of processing and presenting information |
US9164978B2 (en) * | 2008-06-17 | 2015-10-20 | Microsoft Technology Licensing, Llc | Identifying objects within a multidimensional array |
US9424287B2 (en) * | 2008-12-16 | 2016-08-23 | Hewlett Packard Enterprise Development Lp | Continuous, automated database-table partitioning and database-schema evolution |
AU2010302939B2 (en) * | 2009-09-29 | 2013-06-06 | Zap Holdings Limited | A content based approach to extending the form and function of a business intelligence system |
US20110161796A1 (en) * | 2009-12-31 | 2011-06-30 | Edward Charles Laikin | FormDB: a process to create a forms database in Excel without user programming |
US9069747B2 (en) | 2010-08-26 | 2015-06-30 | Sap Se | Methods, apparatus, systems and computer readable mediums for use in association with electronic spreadsheets |
US8479089B2 (en) * | 2011-03-08 | 2013-07-02 | Certusoft, Inc. | Constructing and applying a constraint-choice-action matrix for decision making |
US11093702B2 (en) | 2012-06-22 | 2021-08-17 | Microsoft Technology Licensing, Llc | Checking and/or completion for data grids |
US10685062B2 (en) | 2012-12-31 | 2020-06-16 | Microsoft Technology Licensing, Llc | Relational database management |
US9626397B2 (en) * | 2013-02-13 | 2017-04-18 | Business Objects Software Limited | Discounted future value operations on a massively parallel processing system and methods thereof |
US9619210B2 (en) | 2015-05-14 | 2017-04-11 | Walleye Software, LLC | Parsing and compiling data system queries |
US10521431B2 (en) * | 2016-05-09 | 2019-12-31 | Sap Se | Relational conversion of multiprovider operations in a calculation scenario for executing a query |
US10102241B2 (en) * | 2016-05-20 | 2018-10-16 | Microsoft Technology Licensing, Llc | Detecting errors in spreadsheets |
US10366082B2 (en) | 2016-12-09 | 2019-07-30 | Oracle International Corporation | Parallel processing of queries with inverse distribution function |
US11222172B2 (en) | 2017-05-18 | 2022-01-11 | Lakebolt Research | System and method for reactive computing |
US11354494B2 (en) | 2017-07-10 | 2022-06-07 | Adaptam Inc. | Methods and systems for connecting a spreadsheet to external data sources with formulaic specification of data retrieval |
US10198469B1 (en) | 2017-08-24 | 2019-02-05 | Deephaven Data Labs Llc | Computer data system data source refreshing using an update propagation graph having a merged join listener |
US11036929B2 (en) | 2017-11-15 | 2021-06-15 | Adaptam Inc. | Methods and systems for connecting a spreadsheet to external data sources with ordered formulaic use of data retrieved |
US11416262B1 (en) * | 2018-05-22 | 2022-08-16 | Workday, Inc. | Systems and methods for improving computational speed of planning by enabling interactive processing in hypercubes |
AU2018449013A1 (en) | 2018-11-12 | 2021-05-20 | Hanyi Bio-Technology (Beijing) Co., Ltd | Use of cannabinoid compound in neurodermatitis treatment |
US11086894B1 (en) | 2019-06-25 | 2021-08-10 | Amazon Technologies, Inc. | Dynamically updated data sheets using row links |
US11194793B1 (en) * | 2019-06-25 | 2021-12-07 | Amazon Technologies, Inc. | Dynamically materialized views for sheets based data |
US11657217B2 (en) | 2020-06-26 | 2023-05-23 | Adaptam Inc. | Methods and systems for presenting drop-down, pop-up or other presentation of a multi-value data set in a spreadsheet cell |
CN112925800A (zh) * | 2021-02-26 | 2021-06-08 | 平安普惠企业管理有限公司 | 数据依赖判断方法、装置、计算机设备及存储介质 |
US11880381B1 (en) * | 2023-07-13 | 2024-01-23 | Snowflake Inc. | Notebooks with predictable behavior |
Family Cites Families (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5319777A (en) * | 1990-10-16 | 1994-06-07 | Sinper Corporation | System and method for storing and retrieving information from a multidimensional array |
US5359724A (en) * | 1992-03-30 | 1994-10-25 | Arbor Software Corporation | Method and apparatus for storing and retrieving multi-dimensional data in computer memory |
JP4121566B2 (ja) * | 1993-03-23 | 2008-07-23 | 株式会社野村総合研究所 | データベースからのデータ抽出方法 |
EP0667586A3 (de) * | 1994-02-14 | 1996-08-28 | Digital Equipment Corp | System zur Erzeugung von Datenbanken. |
US5943668A (en) * | 1997-06-30 | 1999-08-24 | International Business Machines Corporation | Relational emulation of a multi-dimensional database |
US5978796A (en) * | 1997-06-30 | 1999-11-02 | International Business Machines Corporation | Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database |
EP1031087A1 (de) * | 1997-07-18 | 2000-08-30 | Net Exchange, Inc. | Vorrichtung und verfahren für die realisation von briefpartner-orientierterelektronischen post |
JPH11161656A (ja) * | 1997-11-27 | 1999-06-18 | Asahi Chem Ind Co Ltd | データベース検索・抽出システムおよびデータベース検索・抽出用制御プログラムを記録した記録媒体 |
US6298342B1 (en) * | 1998-03-16 | 2001-10-02 | Microsoft Corporation | Electronic database operations for perspective transformations on relational tables using pivot and unpivot columns |
US6317750B1 (en) * | 1998-10-26 | 2001-11-13 | Hyperion Solutions Corporation | Method and apparatus for accessing multidimensional data |
US6408292B1 (en) * | 1999-08-04 | 2002-06-18 | Hyperroll, Israel, Ltd. | Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions |
US7761403B2 (en) | 2001-06-20 | 2010-07-20 | Oracle International Corporation | Run-time optimizations of queries with SQL spreadsheet |
US7177855B2 (en) | 2001-06-20 | 2007-02-13 | Oracle International Corporation | Compile-time optimizations of queries with SQL spreadsheet |
-
2001
- 2001-06-20 DE DE60130475T patent/DE60130475T2/de not_active Expired - Lifetime
- 2001-06-20 US US09/886,839 patent/US6985895B2/en not_active Expired - Lifetime
- 2001-06-20 EP EP01984272A patent/EP1323066B1/de not_active Expired - Lifetime
- 2001-06-20 AT AT01984272T patent/ATE373272T1/de not_active IP Right Cessation
- 2001-06-20 JP JP2002512841A patent/JP4465147B2/ja not_active Expired - Lifetime
- 2001-06-20 AU AU2002222963A patent/AU2002222963B2/en not_active Expired
- 2001-06-20 WO PCT/US2001/041094 patent/WO2002006999A2/en active IP Right Grant
- 2001-06-20 CA CA2415183A patent/CA2415183C/en not_active Expired - Lifetime
- 2001-06-20 AU AU2296302A patent/AU2296302A/xx active Pending
-
2003
- 2003-07-14 HK HK03105068.3A patent/HK1052777B/zh not_active IP Right Cessation
Also Published As
Publication number | Publication date |
---|---|
AU2296302A (en) | 2002-01-30 |
HK1052777A1 (en) | 2003-09-26 |
CA2415183A1 (en) | 2002-01-24 |
US20020059203A1 (en) | 2002-05-16 |
DE60130475T2 (de) | 2008-06-19 |
WO2002006999A3 (en) | 2003-03-13 |
US6985895B2 (en) | 2006-01-10 |
EP1323066A2 (de) | 2003-07-02 |
HK1052777B (zh) | 2007-11-09 |
JP4465147B2 (ja) | 2010-05-19 |
CA2415183C (en) | 2011-01-11 |
EP1323066B1 (de) | 2007-09-12 |
JP2004504672A (ja) | 2004-02-12 |
AU2002222963B2 (en) | 2007-05-10 |
ATE373272T1 (de) | 2007-09-15 |
WO2002006999A2 (en) | 2002-01-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
DE60130475D1 (de) | Durchführung von kalkulationen des tabellenkalkulationstyps in einem datenbanksystem | |
CA2392675A1 (en) | Database system and method | |
WO2004036456A3 (en) | Method and system for online analytical processing (olap) | |
WO2003069554A3 (en) | Method and system for interactive ground-truthing of document images | |
ATE179815T1 (de) | Rechnersystem um semantische objektmodelle von existierenden relationellen datenbanksystemen herzustellen | |
AU3092099A (en) | Perspective transformations on relational database tables | |
DK2362346T3 (da) | Fremgangsmåde og computerprogramprodukt til volumenrendering | |
CA2429338A1 (en) | Method and apparatus for categorizing and presenting documents of a distributed database | |
CA2170235A1 (en) | Method and apparatus for the modeling and query of database structures using natural language-like constructs | |
EP0320266A3 (de) | Zusammensetzung von Ansichten in einem Datenbankverwaltungssystem | |
EP0860786A3 (de) | System und Verfahren zum hierarchischen Zusammenstellen und Einordnen eines Satzes von Objekten in einem Abfragekontext | |
CA2373568A1 (en) | Method of searching similar document, system for performing the same and program for processing the same | |
ATE246824T1 (de) | Verfahren und systeme um olap hierarchien zusammenfassbar zu machen | |
CA2452226A1 (en) | Update propagation to a data warehouse with specified latency | |
WO2001084374A3 (en) | Information access method | |
WO2001008032A3 (en) | Method and storage/retrieval system of chemical substances in a database | |
EP1298543A3 (de) | Bereitstellen eines join-Planes unter Benutzung des group-by-Operators | |
IL161381A0 (en) | Digital ink database searching using handwriting feature synthesis | |
TW200517887A (en) | Methods and apparatus for query rewrite with auxiliary attributes in query processing operations | |
CN110399395B (zh) | 基于预计算的加速查询方法、存储介质 | |
WO2000079436A3 (en) | Search engine interface | |
WO2004088456A3 (en) | A computer implemented compact 0-complete tree dynamic storage structure and method of processing stored data | |
Li et al. | A fast algorithm for maintenance of association rules in incremental databases | |
CA2235089A1 (en) | Object search method and object search system | |
WO2000043916A3 (en) | Database item versioning |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
8364 | No opposition during term of opposition |