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

* 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
US9633060B2 (en) 2015-05-14 2017-04-25 Walleye Software, LLC Computer data distribution architecture with table data cache proxy
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
US10866943B1 (en) 2017-08-24 2020-12-15 Deephaven Data Labs Llc Keyed row selection
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
WO2023205053A1 (en) * 2022-04-18 2023-10-26 Preventice Solutions, Inc. Real-time ecg report generation
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
US9311357B2 (en) 2016-04-12
EP2672397A1 (en) 2013-12-11
EP2672397B1 (en) 2018-08-22
US20130332487A1 (en) 2013-12-12
MX2013003003A (es) 2013-12-16

Similar Documents

Publication Publication Date Title
MX338018B (es) Generacion de informes basada en una vista materializada.
CA2834864C (en) Database system and method
AU2016204542A1 (en) Modifying structured search queries on online social networks
WO2014099234A3 (en) Method for storage, querying, and analysis of time series data
GB2503391A (en) Graph databases for storing multidimensional models of software offerings
GB2542053A (en) Automatically generating a semantic mapping for a relational database
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
IN2015DN03160A (es)
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.
WO2016026407A3 (en) System and method for metadata enhanced inventory management of a communications system
IN2013CH06086A (es)
WO2011130706A3 (en) Methods and systems for performing cross store joins in a multi-tenant store
MY176870A (en) Process system management system, server apparatus, management program, and management method
MX2015015041A (es) Compilacion de datos de situaciones hipoteticas de perforacion a partir de fuentes de datos dispares.
WO2011140532A3 (en) System and method for re-using xbrl-tags across period boundaries
MX2015008571A (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

Legal Events

Date Code Title Description
FG Grant or registration