CL2022001932A1 - Sistema y método para agregación y transformación de datos usando criterios específicos de cliente - Google Patents

Sistema y método para agregación y transformación de datos usando criterios específicos de cliente

Info

Publication number
CL2022001932A1
CL2022001932A1 CL2022001932A CL2022001932A CL2022001932A1 CL 2022001932 A1 CL2022001932 A1 CL 2022001932A1 CL 2022001932 A CL2022001932 A CL 2022001932A CL 2022001932 A CL2022001932 A CL 2022001932A CL 2022001932 A1 CL2022001932 A1 CL 2022001932A1
Authority
CL
Chile
Prior art keywords
management system
data
client
retrieve
determining
Prior art date
Application number
CL2022001932A
Other languages
English (en)
Inventor
Hermogenes Jerome
Roy Hartwig Michael
Original Assignee
Optx Solutions 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 Optx Solutions Llc filed Critical Optx Solutions Llc
Publication of CL2022001932A1 publication Critical patent/CL2022001932A1/es

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/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and management
    • G06F16/212—Schema design and management with details for data modelling support
    • 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/2443—Stored procedures
    • 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/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24554—Unary operations; Data partitioning operations
    • G06F16/24556—Aggregation; Duplicate elimination
    • 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/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N20/00—Machine learning

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Artificial Intelligence (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Evolutionary Computation (AREA)
  • Medical Informatics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Investigating Or Analysing Biological Materials (AREA)

Abstract

A method may include receiving, at a first time, an instruction to execute a stored procedure at a database system, retrieving a schema of a structure of a database used by a management system of a client entity, determining an identity of a management system and a type of data to retrieve for the client entity. The method may also include, responsive to determining the identity and the type of data to retrieve, determining a criteria to use in a dynamic query based on the identity and the type of data to retrieve. The method may also include, responsive to determining the criteria, generating, in the stored procedure, the dynamic query comprising the criteria, and executing the stored procedure to retrieve raw data from the database used by the management system and transform the raw data to transformed data using the dynamic query.
CL2022001932A 2020-01-16 2022-07-18 Sistema y método para agregación y transformación de datos usando criterios específicos de cliente CL2022001932A1 (es)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US202062962084P 2020-01-16 2020-01-16

Publications (1)

Publication Number Publication Date
CL2022001932A1 true CL2022001932A1 (es) 2023-11-24

Family

ID=76857850

Family Applications (1)

Application Number Title Priority Date Filing Date
CL2022001932A CL2022001932A1 (es) 2020-01-16 2022-07-18 Sistema y método para agregación y transformación de datos usando criterios específicos de cliente

Country Status (8)

Country Link
US (1) US20210224262A1 (es)
CN (1) CN115698976A (es)
AU (1) AU2021207514A1 (es)
CA (1) CA3165184A1 (es)
CL (1) CL2022001932A1 (es)
GB (1) GB2607515A (es)
PE (1) PE20230318A1 (es)
WO (1) WO2021146538A1 (es)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11720534B2 (en) * 2021-03-18 2023-08-08 Sap Se Remote code execution
CN115269932B (zh) * 2022-09-29 2022-12-20 江西联创精密机电有限公司 模拟训练设备的训练评分方法、装置、存储介质及设备

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5555403A (en) * 1991-11-27 1996-09-10 Business Objects, S.A. Relational database access system using semantically dynamic objects
US20020029207A1 (en) * 2000-02-28 2002-03-07 Hyperroll, Inc. Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
US6643635B2 (en) * 2001-03-15 2003-11-04 Sagemetrics Corporation Methods for dynamically accessing, processing, and presenting data acquired from disparate data sources
US8812433B2 (en) * 2005-02-07 2014-08-19 Mimosa Systems, Inc. Dynamic bulk-to-brick transformation of data
US8862537B1 (en) * 2011-06-30 2014-10-14 Sumo Logic Selective structure preserving obfuscation
US9798788B1 (en) * 2012-12-27 2017-10-24 EMC IP Holding Company LLC Holistic methodology for big data analytics
US10290126B2 (en) * 2014-07-01 2019-05-14 Oath Inc. Computerized systems and methods for graph data modeling
US11188529B2 (en) * 2018-06-04 2021-11-30 International Business Machines Corporation Autonomous generation of a graph query language interface on top of an application programming interface
CA3050220A1 (en) * 2018-07-19 2020-01-19 Bank Of Montreal Systems and methods for data storage and processing

Also Published As

Publication number Publication date
WO2021146538A1 (en) 2021-07-22
CA3165184A1 (en) 2021-07-22
GB2607515A (en) 2022-12-07
CN115698976A (zh) 2023-02-03
US20210224262A1 (en) 2021-07-22
AU2021207514A1 (en) 2022-09-22
GB202211952D0 (en) 2022-09-28
PE20230318A1 (es) 2023-02-22

Similar Documents

Publication Publication Date Title
CL2022001932A1 (es) Sistema y método para agregación y transformación de datos usando criterios específicos de cliente
US11281669B2 (en) Parallel processing database system
US11567956B2 (en) Background format optimization for enhanced queries in a distributed computing cluster
Rautmare et al. MySQL and NoSQL database comparison for IoT application
US8977646B2 (en) Leveraging graph databases in a federated database system
CN104516979B (zh) 一种基于二次检索的数据查询方法及系统
US9424291B2 (en) Efficient multi-tenant spatial and relational indexing
JP7100422B2 (ja) データプロパティ認識のための装置、プログラム、及び方法
WO2016082468A1 (zh) 数据图形化方法、装置及数据库服务器
CN105138661A (zh) 一种基于Hadoop的网络安全日志k-means聚类分析系统及方法
WO2014099234A3 (en) Method for storage, querying, and analysis of time series data
US20150363467A1 (en) Performing an index operation in a mapreduce environment
WO2019222141A8 (en) Flexibly managing records to match searches
US9069681B1 (en) Real-time log joining on a continuous stream of events that are approximately ordered
EP4300324A3 (en) Selecting backing stores based on data request
US20160070707A1 (en) Keyword search on databases
US9378243B1 (en) Predicate-based range set generation
RU2015112157A (ru) Система и способ поиска данных в базе данных графов
US9092338B1 (en) Multi-level caching event lookup
US11567957B2 (en) Incremental addition of data to partitions in database tables
US11397781B2 (en) Database search integration
US20200151178A1 (en) System and method for sharing database query execution plans between multiple parsing engines
CN106845787A (zh) 一种数据自动交换方法及装置
US11243967B2 (en) Metadata search for remote applications
Weise et al. FDA-DBRepo: A Data Preservation Repository Supporting FAIR Principles, Data Versioning and Reproducible Queries.