WO2012095839A3 - Systems and methods for performing online analytical processing - Google Patents

Systems and methods for performing online analytical processing Download PDF

Info

Publication number
WO2012095839A3
WO2012095839A3 PCT/IL2012/000012 IL2012000012W WO2012095839A3 WO 2012095839 A3 WO2012095839 A3 WO 2012095839A3 IL 2012000012 W IL2012000012 W IL 2012000012W WO 2012095839 A3 WO2012095839 A3 WO 2012095839A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
analysis
database
aggregation module
aggregated
Prior art date
Application number
PCT/IL2012/000012
Other languages
French (fr)
Other versions
WO2012095839A4 (en
WO2012095839A2 (en
Inventor
Erez ALSHEICH
Danny ROSENSTEIN
Moshe Meiseles
Original Assignee
Optier 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 Optier Ltd. filed Critical Optier Ltd.
Publication of WO2012095839A2 publication Critical patent/WO2012095839A2/en
Publication of WO2012095839A3 publication Critical patent/WO2012095839A3/en
Publication of WO2012095839A4 publication Critical patent/WO2012095839A4/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3452—Performance evaluation by statistical analysis
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • G06F11/3419—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment by assessing time
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466—Performance evaluation by tracing or monitoring
    • G06F11/3495—Performance evaluation by tracing or monitoring for systems
    • 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/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; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80—Database-specific techniques
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/87—Monitoring of transactions

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Databases & Information Systems (AREA)
  • Quality & Reliability (AREA)
  • Data Mining & Analysis (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Evolutionary Biology (AREA)
  • Probability & Statistics with Applications (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Complex Calculations (AREA)

Abstract

Near real time online analytical processing system, the system includes an analysis and aggregation module, a database and a query engine, the analysis and aggregation module, the analysis and aggregation module receiving transactional data, the analysis and aggregation module producing raw data, measured metrics statistics data, aggregated transactional data, and aggregated measured metrics statistics data, the database being coupled with the analysis and aggregation module, the database storing the raw data, the measured metrics statistics data, the aggregated transactional data and the aggregated measured metrics statistics data, the query engine being coupled with the database, the query engine receiving a user query, and answering the user query by retrieving data from the database.
PCT/IL2012/000012 2011-01-10 2012-01-09 Systems and methods for performing online analytical processing WO2012095839A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US201161431175P 2011-01-10 2011-01-10
US61/431,175 2011-01-10

Publications (3)

Publication Number Publication Date
WO2012095839A2 WO2012095839A2 (en) 2012-07-19
WO2012095839A3 true WO2012095839A3 (en) 2012-12-06
WO2012095839A4 WO2012095839A4 (en) 2013-01-24

Family

ID=45755444

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/IL2012/000012 WO2012095839A2 (en) 2011-01-10 2012-01-09 Systems and methods for performing online analytical processing

Country Status (1)

Country Link
WO (1) WO2012095839A2 (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10169442B1 (en) * 2012-06-29 2019-01-01 Open Text Corporation Methods and systems for multi-dimensional aggregation using composition
US9430453B1 (en) 2012-12-19 2016-08-30 Emc Corporation Multi-page document recognition in document capture
WO2015131961A1 (en) * 2014-03-07 2015-09-11 Systema Systementwicklung Dip.-Inf. Manfred Austen Gmbh Real-time information systems and methodology based on continuous homomorphic processing in linear information spaces
US10419452B2 (en) 2015-07-28 2019-09-17 Sap Se Contextual monitoring and tracking of SSH sessions
US10015178B2 (en) 2015-07-28 2018-07-03 Sap Se Real-time contextual monitoring intrusion detection and prevention
CN109800129A (en) * 2019-01-17 2019-05-24 青岛特锐德电气股份有限公司 A kind of real-time stream calculation monitoring system and method for processing monitoring big data
WO2023219572A1 (en) * 2022-05-12 2023-11-16 Gp Network Asia Pte. Ltd. Method and system for adaptively processing a request for data

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1998042103A1 (en) * 1997-03-20 1998-09-24 Firstsense Software, Inc. Systems and methods for monitoring distributed applications
EP1603307A2 (en) * 2004-06-04 2005-12-07 OpTier Ltd System and method for performance managment in a multi-tier computing environment

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6480836B1 (en) 1998-03-27 2002-11-12 International Business Machines Corporation System and method for determining and generating candidate views for a database
US6385604B1 (en) 1999-08-04 2002-05-07 Hyperroll, Israel Limited Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1998042103A1 (en) * 1997-03-20 1998-09-24 Firstsense Software, Inc. Systems and methods for monitoring distributed applications
EP1603307A2 (en) * 2004-06-04 2005-12-07 OpTier Ltd System and method for performance managment in a multi-tier computing environment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
CHAUDHURI S ET AL: "An overview of data warehousing and OLAP technology", SIGMOD RECORD, ACM, NEW YORK, NY, US, vol. 26, no. 1, 1 March 1997 (1997-03-01), pages 65 - 74, XP002115173, ISSN: 0163-5808, DOI: 10.1145/248603.248616 *

Also Published As

Publication number Publication date
WO2012095839A4 (en) 2013-01-24
WO2012095839A2 (en) 2012-07-19

Similar Documents

Publication Publication Date Title
WO2012095839A3 (en) Systems and methods for performing online analytical processing
WO2012106378A3 (en) Real time searching and reporting
WO2014043348A3 (en) Systems and methods for dynamic analysis, sorting and active display of semantic-driven reports of communication repositories
WO2013110083A3 (en) Identification of a data record for communication to a receiver
WO2012100066A3 (en) Sentiment analysis
WO2016088069A3 (en) Method and system for legal parking
WO2013019879A3 (en) Asset model import connector
WO2014150214A3 (en) Questions answering to populate knowledge base
MX2013007804A (en) Data improvement system and method.
WO2011116296A3 (en) Systems and methods to enhance search data with transaction based data
WO2013066581A3 (en) Network analysis device and method
WO2012129149A3 (en) Aggregating search results based on associating data instances with knowledge base entities
CA2894429A1 (en) Extract operator
WO2012109580A3 (en) Method and system for interacting and servicing users by orientation
WO2010132624A3 (en) Method and system for analyzing ordered data using pattern matching in a relational database
WO2013001146A3 (en) Method and apparatus for real-time processing of data items
WO2013105911A3 (en) Recommending production plans
WO2012094551A8 (en) Method and apparatus for updating a database in a receiving device
WO2013085652A3 (en) Cognitive-impact modeling for users having divided attention
WO2013074378A3 (en) Locating relevant content items across multiple disparate content sources
WO2014046778A3 (en) System and method for camera photo analytics
EP2534621A4 (en) Method and system for e-commerce transaction data accounting
WO2013098663A3 (en) Cell clustering and aperture selection
MY158805A (en) Data analysis system
WO2015088556A3 (en) System and method for creating profile of fuel quality

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 12705458

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 12705458

Country of ref document: EP

Kind code of ref document: A2

WWE Wipo information: entry into national phase

Ref document number: 231202

Country of ref document: IL