CA3154337A1 - Spreadsheet with dynamic database queries - Google Patents

Spreadsheet with dynamic database queries Download PDF

Info

Publication number
CA3154337A1
CA3154337A1 CA3154337A CA3154337A CA3154337A1 CA 3154337 A1 CA3154337 A1 CA 3154337A1 CA 3154337 A CA3154337 A CA 3154337A CA 3154337 A CA3154337 A CA 3154337A CA 3154337 A1 CA3154337 A1 CA 3154337A1
Authority
CA
Canada
Prior art keywords
cell
cells
spreadsheet
updating
data source
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.)
Pending
Application number
CA3154337A
Other languages
English (en)
French (fr)
Inventor
Dean Andrew ZARRAS
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Goldman Sachs and Co LLC
Original Assignee
Goldman Sachs and Co LLC
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 Goldman Sachs and Co LLC filed Critical Goldman Sachs and Co LLC
Publication of CA3154337A1 publication Critical patent/CA3154337A1/en
Pending legal-status Critical Current

Links

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)
CA3154337A 2019-09-13 2020-09-12 Spreadsheet with dynamic database queries Pending CA3154337A1 (en)

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 (1)

Publication Number Publication Date
CA3154337A1 true CA3154337A1 (en) 2021-03-18

Family

ID=72521683

Family Applications (1)

Application Number Title Priority Date Filing Date
CA3154337A Pending CA3154337A1 (en) 2019-09-13 2020-09-12 Spreadsheet with dynamic database queries

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

Family Cites Families (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070022120A1 (en) 2005-07-25 2007-01-25 Microsoft Corporation Caching and modifying portions of a multi-dimensional database on a user device
US7805433B2 (en) * 2005-10-14 2010-09-28 Microsoft Corporation Multidimensional cube functions
US20070168323A1 (en) * 2006-01-03 2007-07-19 Microsoft Corporation Query aggregation
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
US10140352B2 (en) 2014-07-17 2018-11-27 Oracle International Corporation Interfacing with a relational database for multi-dimensional analysis via a spreadsheet application
US11016986B2 (en) 2017-12-04 2021-05-25 Palantir Technologies Inc. Query-based time-series data display and processing system
US10810192B2 (en) * 2018-09-18 2020-10-20 Sigma Computing, Inc. Generating a database query to dynamically aggregate rows of a data set

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
JP7688815B2 (ja) 2025-06-05
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
IL291289A (en) 2022-05-01

Similar Documents

Publication Publication Date Title
US11704304B2 (en) Spreadsheet with dynamic database queries
US12306844B2 (en) User interfaces for database visualizations
US8612438B2 (en) Techniques for dynamic cross-filtering
US20140317563A1 (en) Generate field mapping
WO2011067080A1 (en) A method for retrieving a data item annotation in a view
US10645090B2 (en) Access control for objects having attributes defined against hierarchically organized domains containing fixed number of values
US9547646B2 (en) User-created members positioning for OLAP databases
CN109359141B (zh) 一种可视化报表数据展示方法及装置
US10360245B2 (en) Attribute value derivation
US12339861B2 (en) Identity resolution in knowledge graph databases
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
US20250315407A1 (en) Systems and methods for data translation of source data files
US20250335461A1 (en) User interfaces for data traversal of knowledge graphs
US12423333B2 (en) Data processing for visualizing hierarchical data
US11080903B2 (en) Visualization with conditional characteristic
US10417185B2 (en) Gesture based semantic enrichment
US11960829B1 (en) Fast input window
JP7807468B2 (ja) データアセットのためのメタデータ継承
CA2663859C (en) Apparatus and method for updating a report through view time interaction

Legal Events

Date Code Title Description
EEER Examination request

Effective date: 20220311