MX338018B - Generacion de informes basada en una vista materializada. - Google Patents

Generacion de informes basada en una vista materializada.

Info

Publication number
MX338018B
MX338018B MX2013003003A MX2013003003A MX338018B MX 338018 B MX338018 B MX 338018B MX 2013003003 A MX2013003003 A MX 2013003003A MX 2013003003 A MX2013003003 A MX 2013003003A MX 338018 B MX338018 B MX 338018B
Authority
MX
Mexico
Prior art keywords
query
materialized view
trigger
table schema
generating
Prior art date
Application number
MX2013003003A
Other languages
English (en)
Other versions
MX2013003003A (es
Inventor
Rajini Ramesh
Madhavi Garlapati
Mutharasi Thenmani
Original Assignee
Tata Consultancy Services Ltd
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 Tata Consultancy Services Ltd filed Critical Tata Consultancy Services Ltd
Publication of MX2013003003A publication Critical patent/MX2013003003A/es
Publication of MX338018B publication Critical patent/MX338018B/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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • 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/23—Updating
    • G06F16/2393—Updating materialised views
    • 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/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Se describe un sistema y un método para generar un informe en una vista materializada; el método incluye la generación de una primera consulta, mediante un módulo de consultas, basada en la selección de por lo menos un atributo a partir de una pluralidad de atributos asociados con un caso particular de un recurso asociado con una estructura controlada por metadatos; además, la primera consulta se almacena en un esquema de tabla, asociado con un primer disparador, mediante el módulo de generación de consultas; además, el primer disparador es activado mediante un módulo de análisis tras el almacenamiento de la primera consulta en el esquema de tabla; el primer disparador está configurado para ejecutar la primera consulta para generar una vista materializada con base en una salida de la primera consulta; además, una segunda consulta es ejecutada en la vista materializada, mediante un módulo de representación para generar el informe; la segunda consulta se puede crear con base en los datos de la vista materializada.
MX2013003003A 2012-06-06 2013-03-15 Generacion de informes basada en una vista materializada. MX338018B (es)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
IN1665MU2012 2012-06-06

Publications (2)

Publication Number Publication Date
MX2013003003A MX2013003003A (es) 2013-12-16
MX338018B true MX338018B (es) 2016-03-29

Family

ID=47900824

Family Applications (1)

Application Number Title Priority Date Filing Date
MX2013003003A MX338018B (es) 2012-06-06 2013-03-15 Generacion de informes basada en una vista materializada.

Country Status (3)

Country Link
US (1) US9311357B2 (es)
EP (1) EP2672397B1 (es)
MX (1) MX338018B (es)

Families Citing this family (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9734183B2 (en) * 2013-08-08 2017-08-15 Hong Kong Baptist University System and method for performing view updates in database systems
US9256641B1 (en) * 2013-10-18 2016-02-09 Ca, Inc. Dynamic optimization of data aggregation
US10635645B1 (en) 2014-05-04 2020-04-28 Veritas Technologies Llc Systems and methods for maintaining aggregate tables in databases
US10127252B2 (en) * 2015-03-23 2018-11-13 Oracle International Corporation History and scenario data tracking
WO2016183539A1 (en) 2015-05-14 2016-11-17 Walleye Software, LLC Data partitioning and ordering
KR101706252B1 (ko) * 2016-02-29 2017-02-13 주식회사 티맥스데이터 이기종 데이터베이스들 간의 쿼리 결과를 동기화하기 위한 방법, 서버 및 컴퓨터-판독가능 매체에 저장된 컴퓨터 프로그램
CN107967274A (zh) * 2016-10-19 2018-04-27 航天信息软件技术有限公司 数据库中数据同步的方法和装置
US11016947B1 (en) * 2016-12-20 2021-05-25 Cloudera, Inc. Apparatus and method for recommending and maintaining analytical views
US11222171B2 (en) 2017-02-17 2022-01-11 Microsoft Technology Licensing, Llc Enhanced pivot table creation and interaction
US10628441B1 (en) * 2017-04-28 2020-04-21 EMC IP Holding Company LLC System and method for selective storage transformation
US10621161B2 (en) * 2017-06-05 2020-04-14 International Business Machines Corporation User defined heuristic refresh of a materialized query table
US10241965B1 (en) 2017-08-24 2019-03-26 Deephaven Data Labs Llc Computer data distribution architecture connecting an update propagation graph through multiple remote query processors
US10719508B2 (en) 2018-04-19 2020-07-21 Risk Management Solutions, Inc. Data storage system for providing low latency search query responses
US11681691B2 (en) * 2018-11-19 2023-06-20 Numetric, Inc. Presenting updated data using persisting views
US11698938B2 (en) * 2019-10-24 2023-07-11 Target Brands, Inc. System and method for data event management system
US11086841B1 (en) * 2020-01-31 2021-08-10 Snowflake Inc. Streams on shared database objects
US12094585B2 (en) * 2022-04-18 2024-09-17 Boston Scientific Cardiac Diagnostics, Inc. Real-time ECG report generation
CN114969044B (zh) * 2022-05-30 2024-10-11 北京火山引擎科技有限公司 一种基于数据湖的物化列创建方法以及数据查询方法
US11567936B1 (en) 2022-09-19 2023-01-31 Keebo Inc. Platform agnostic query acceleration

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6493678B1 (en) * 1998-05-22 2002-12-10 Connectrix Systems, Inc. Method, apparatus and system for merchandising related applications
US6708164B1 (en) * 2000-03-17 2004-03-16 Microsoft Corporation Transforming query results into hierarchical information
US7158994B1 (en) * 2001-09-28 2007-01-02 Oracle International Corporation Object-oriented materialized views
US7895191B2 (en) 2003-04-09 2011-02-22 International Business Machines Corporation Improving performance of database queries
US7516161B1 (en) * 2003-08-27 2009-04-07 Sparta Systems, Inc. Administrative triggers
US8019735B2 (en) * 2004-05-21 2011-09-13 Oracle International Corporation Systems and methods for query caching
US7844587B2 (en) * 2004-07-23 2010-11-30 Oracle International Corporation Web-based user interface for searching metadata-driven relational databases
US8281282B2 (en) * 2005-04-26 2012-10-02 Ca, Inc. Method and apparatus for in-built searching and aggregating functionality
US7844600B2 (en) * 2007-07-13 2010-11-30 Oracle International Corp. Materialized views with user-defined aggregates
US7774354B2 (en) * 2007-08-02 2010-08-10 International Business Machines Corporation Method and system for response time optimization for task list retrieval from databases
US20100100562A1 (en) * 2008-10-01 2010-04-22 Jerry Millsap Fully Parameterized Structured Query Language
US8285708B2 (en) * 2008-10-21 2012-10-09 Microsoft Corporation Query submission pipeline using LINQ
US8065269B2 (en) * 2008-12-19 2011-11-22 Ianywhere Solutions, Inc. Immediate maintenance of materialized views

Also Published As

Publication number Publication date
MX2013003003A (es) 2013-12-16
EP2672397B1 (en) 2018-08-22
US9311357B2 (en) 2016-04-12
EP2672397A1 (en) 2013-12-11
US20130332487A1 (en) 2013-12-12

Similar Documents

Publication Publication Date Title
MX2013003003A (es) Generacion de informes basada en una vista materializada.
CA2834864C (en) Database system and method
WO2014099234A3 (en) Method for storage, querying, and analysis of time series data
GB2503391A (en) Graph databases for storing multidimensional models of software offerings
MX347812B (es) Uso de operadores inversos para consultas en redes sociales en linea.
WO2015195830A3 (en) Data query method and apparatus
MX353716B (es) Consultas de busqueda estructuradas basadas en informacion de grafica social.
WO2014035879A3 (en) Operating a distributed database with foreign tables
WO2013066889A3 (en) Oracle rewind: metadata-driven undo
GB2524934A (en) Method and apparatus for document planning
WO2013033716A3 (en) Dynamic tagging to create logical models and optimize caching in energy management systems
WO2013188795A3 (en) Simplified interaction with complex database
MX2015016737A (es) Sistema automatizado para organizar diapositivas de presentaciones.
MX2015007707A (es) Dispositivo de computacion que comprende red de tablas.
IN2013CH04496A (es)
WO2016026407A3 (en) System and method for metadata enhanced inventory management of a communications system
IN2015DN01406A (es)
MX2015015041A (es) Compilacion de datos de situaciones hipoteticas de perforacion a partir de fuentes de datos dispares.
IN2012DE00401A (es)
WO2011140532A3 (en) System and method for re-using xbrl-tags across period boundaries
MX363282B (es) Consultas de busqueda estructuradas ambiguas en redes sociales en linea.
MX2018001255A (es) SISTEMA Y Mí‰TODO PARA LA CREACIí“N Y USO DE ESTRUCTURAS DE DATOS VISUALES DINíMICOS DE CALIDAD ALTA VISUALMENTE DIVERSOS.
EP2779035A3 (en) Methods and systems for creating a complex user interface adapting a generic database software application to individually manage subset domains in complex database
IN2015DN01231A (es)
WO2014025946A3 (en) Automatic verification of data sources

Legal Events

Date Code Title Description
FG Grant or registration