JP7688815B2 - 動的なデータベースクエリを伴うスプレッドシート - Google Patents

動的なデータベースクエリを伴うスプレッドシート Download PDF

Info

Publication number
JP7688815B2
JP7688815B2 JP2022516334A JP2022516334A JP7688815B2 JP 7688815 B2 JP7688815 B2 JP 7688815B2 JP 2022516334 A JP2022516334 A JP 2022516334A JP 2022516334 A JP2022516334 A JP 2022516334A JP 7688815 B2 JP7688815 B2 JP 7688815B2
Authority
JP
Japan
Prior art keywords
cell
spreadsheet
cells
data source
updating
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.)
Active
Application number
JP2022516334A
Other languages
English (en)
Japanese (ja)
Other versions
JP2022548605A (ja
JPWO2021048823A5 (https=
JP2022548605A5 (https=
Inventor
アンドリュー ザラス ディーン
Original Assignee
クリアファクター インコーポレイテッド
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by クリアファクター インコーポレイテッド filed Critical クリアファクター インコーポレイテッド
Publication of JP2022548605A publication Critical patent/JP2022548605A/ja
Publication of JPWO2021048823A5 publication Critical patent/JPWO2021048823A5/ja
Publication of JP2022548605A5 publication Critical patent/JP2022548605A5/ja
Application granted granted Critical
Publication of JP7688815B2 publication Critical patent/JP7688815B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/245—Query processing
    • G06F16/2457—Query processing with adaptation to user needs
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2022516334A 2019-09-13 2020-09-12 動的なデータベースクエリを伴うスプレッドシート Active JP7688815B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US201962900434P 2019-09-13 2019-09-13
US62/900,434 2019-09-13
PCT/IB2020/058488 WO2021048823A1 (en) 2019-09-13 2020-09-12 Spreadsheet with dynamic database queries

Publications (4)

Publication Number Publication Date
JP2022548605A JP2022548605A (ja) 2022-11-21
JPWO2021048823A5 JPWO2021048823A5 (https=) 2023-09-01
JP2022548605A5 JP2022548605A5 (https=) 2023-09-01
JP7688815B2 true JP7688815B2 (ja) 2025-06-05

Family

ID=72521683

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2022516334A Active JP7688815B2 (ja) 2019-09-13 2020-09-12 動的なデータベースクエリを伴うスプレッドシート

Country Status (6)

Country Link
US (4) US11550778B2 (https=)
EP (1) EP4028905A1 (https=)
JP (1) JP7688815B2 (https=)
CA (1) CA3154337A1 (https=)
IL (1) IL291289A (https=)
WO (1) WO2021048823A1 (https=)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11694023B2 (en) * 2020-07-13 2023-07-04 Adaptam Inc. Method and system for improved spreadsheet analytical functioning
US11972204B2 (en) * 2020-07-13 2024-04-30 Adaptam Inc. Method and system for improved ordering of output from spreadsheet analytical functions
US12450426B1 (en) * 2020-12-21 2025-10-21 Mehrdad Samadani Method and system for cellular computation and display
CN113220752A (zh) * 2021-05-06 2021-08-06 北京字跳网络技术有限公司 展示方法、装置和电子设备
US12050859B2 (en) 2021-09-03 2024-07-30 Adaptam Inc. Method and system for improved 2D ordering of output from spreadsheet analytical functions
US12001782B2 (en) 2021-09-24 2024-06-04 Google Llc Personalized autonomous spreadsheets
US12547823B2 (en) * 2021-09-24 2026-02-10 Google Llc Dynamically and selectively updated spreadsheets based on knowledge monitoring and natural language processing
US12001783B2 (en) 2021-09-24 2024-06-04 Google Llc Autonomous spreadsheet creation
US11966690B2 (en) 2022-08-29 2024-04-23 Microsoft Technology Licensing, Llc Enhanced integration of spreadsheets with external environments
US12333241B2 (en) 2023-08-16 2025-06-17 Microsoft Technology Licensing, Llc Integrating non-native dependencies in spreadsheet applications

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070168323A1 (en) 2006-01-03 2007-07-19 Microsoft Corporation Query aggregation
JP2009512909A (ja) 2005-07-25 2009-03-26 マイクロソフト コーポレーション ユーザ装置上の多次元データベースの部分的キャッシングおよび修正
US20160019281A1 (en) 2014-07-17 2016-01-21 Oracle International Corporation Interfacing with a Relational Database for Multi-Dimensional Analysis via a Spreadsheet Application
US20190171748A1 (en) 2017-12-04 2019-06-06 Palantir Technologies Inc. Query-based time-series data display and processing system

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7805433B2 (en) * 2005-10-14 2010-09-28 Microsoft Corporation Multidimensional cube functions
EP2107474A1 (en) 2008-03-31 2009-10-07 British Telecommunications Public Limited Company Data access
US8527865B2 (en) * 2008-05-23 2013-09-03 Microsoft Corporation Spreadsheet formula translation of server calculation rules
WO2014001568A2 (en) 2012-06-29 2014-01-03 Reyntjens Nick Alex Lieven Method and apparatus for realizing a dynamically typed file or object system enabling a user to perform calculations over the fields associated with the files or objects in the system
US11361246B2 (en) * 2012-08-31 2022-06-14 DataRobot, Inc. Methods for automating aspects of machine learning, and related systems and apparatus
US9116931B2 (en) 2013-07-12 2015-08-25 Logic9S, Llc Integrated, configurable, analytical, temporal, visual electronic plan system
US10810192B2 (en) * 2018-09-18 2020-10-20 Sigma Computing, Inc. Generating a database query to dynamically aggregate rows of a data set

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2009512909A (ja) 2005-07-25 2009-03-26 マイクロソフト コーポレーション ユーザ装置上の多次元データベースの部分的キャッシングおよび修正
US20070168323A1 (en) 2006-01-03 2007-07-19 Microsoft Corporation Query aggregation
US20160019281A1 (en) 2014-07-17 2016-01-21 Oracle International Corporation Interfacing with a Relational Database for Multi-Dimensional Analysis via a Spreadsheet Application
US20190171748A1 (en) 2017-12-04 2019-06-06 Palantir Technologies Inc. Query-based time-series data display and processing system

Also Published As

Publication number Publication date
EP4028905A1 (en) 2022-07-20
WO2021048823A1 (en) 2021-03-18
US20240143578A1 (en) 2024-05-02
US20220121654A1 (en) 2022-04-21
US11704304B2 (en) 2023-07-18
US20260064665A1 (en) 2026-03-05
US20210081405A1 (en) 2021-03-18
US11550778B2 (en) 2023-01-10
JP2022548605A (ja) 2022-11-21
CA3154337A1 (en) 2021-03-18
IL291289A (en) 2022-05-01

Similar Documents

Publication Publication Date Title
JP7688815B2 (ja) 動的なデータベースクエリを伴うスプレッドシート
US12306844B2 (en) User interfaces for database visualizations
KR101639292B1 (ko) 데이터 요소 사이의 관계를 시각화하는 방법
US8612438B2 (en) Techniques for dynamic cross-filtering
US9465523B2 (en) Visual exploration of multidimensional data
US12430335B2 (en) System and method for improved cache utilization using an organizational memory to generate a dashboard
CN109359141B (zh) 一种可视化报表数据展示方法及装置
US20100318943A1 (en) Unified Interface for Display and Modification of Data Arrays
US8788956B2 (en) Symbolic tree node selector
CN110020277A (zh) 通过指标关联树查询指标关联关系和数值变化原因的方法
US20200372019A1 (en) System and method for automatic completion of queries using natural language processing and an organizational memory
EP2887240B1 (en) Electronic product information display system
US8694918B2 (en) Conveying hierarchical elements of a user interface
US9996559B2 (en) Maintenance actions and user-specific settings of the attribute value derivation instruction set user interface
US12423333B2 (en) Data processing for visualizing hierarchical data
US20240160639A1 (en) Cascading Data Impact Visualization Tool
US20190171747A1 (en) Simplified access for core business with enterprise search
US9811931B2 (en) Recommendations for creation of visualizations
US10417185B2 (en) Gesture based semantic enrichment
US11080903B2 (en) Visualization with conditional characteristic
CA2663859C (en) Apparatus and method for updating a report through view time interaction
CA3191333A1 (en) Graph framework (database methods) to analyze trillion cell reservoir and basin simulation results

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20230824

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20230824

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20240913

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20241001

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20241217

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20250304

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20250403

A711 Notification of change in applicant

Free format text: JAPANESE INTERMEDIATE CODE: A711

Effective date: 20250501

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20250502

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A821

Effective date: 20250501

R150 Certificate of patent or registration of utility model

Ref document number: 7688815

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150