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
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.
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)
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)
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 |
-
2013
- 2013-03-14 EP EP13159301.4A patent/EP2672397B1/en active Active
- 2013-03-15 US US13/840,899 patent/US9311357B2/en active Active
- 2013-03-15 MX MX2013003003A patent/MX338018B/es active IP Right Grant
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 |