HK1130335A1 - 基於 環境的統計表應用方法及系統 - Google Patents

基於 環境的統計表應用方法及系統

Info

Publication number
HK1130335A1
HK1130335A1 HK09110060.5A HK09110060A HK1130335A1 HK 1130335 A1 HK1130335 A1 HK 1130335A1 HK 09110060 A HK09110060 A HK 09110060A HK 1130335 A1 HK1130335 A1 HK 1130335A1
Authority
HK
Hong Kong
Prior art keywords
oltp
statistics
environment
oltp environment
Prior art date
Application number
HK09110060.5A
Other languages
English (en)
Inventor
趙林
Original Assignee
阿里巴巴集團控股有限公司 號郵箱
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 阿里巴巴集團控股有限公司 號郵箱 filed Critical 阿里巴巴集團控股有限公司 號郵箱
Publication of HK1130335A1 publication Critical patent/HK1130335A1/zh

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/2452—Query translation
    • G06F16/24522—Translation of natural language queries to structured queries
    • 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462—Approximate or statistical queries
    • 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/2379—Updates performed during online database operations; commit processing
    • 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/24552—Database cache management
    • 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2477—Temporal data queries
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Artificial Intelligence (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
HK09110060.5A 2007-11-09 2009-10-29 基於 環境的統計表應用方法及系統 HK1130335A1 (zh)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN200710188104.XA CN101430687B (zh) 2007-11-09 2007-11-09 基于oltp环境的统计表应用方法及系统

Publications (1)

Publication Number Publication Date
HK1130335A1 true HK1130335A1 (zh) 2009-12-24

Family

ID=40626200

Family Applications (1)

Application Number Title Priority Date Filing Date
HK09110060.5A HK1130335A1 (zh) 2007-11-09 2009-10-29 基於 環境的統計表應用方法及系統

Country Status (7)

Country Link
US (3) US8290896B2 (zh)
EP (1) EP2210177A4 (zh)
JP (1) JP5364719B2 (zh)
CN (1) CN101430687B (zh)
HK (1) HK1130335A1 (zh)
TW (1) TWI536184B (zh)
WO (1) WO2009062067A1 (zh)

Families Citing this family (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101430687B (zh) 2007-11-09 2015-11-25 阿里巴巴集团控股有限公司 基于oltp环境的统计表应用方法及系统
CN102193981B (zh) * 2011-03-25 2013-01-02 北京世纪互联宽带数据中心有限公司 图形数据库联机事务中事务过期机制的实现方法
US20120291014A1 (en) * 2011-05-09 2012-11-15 Sridhar Shrinivasan System and method for testing the development and updates in a test system using production/live data
CN103023687A (zh) * 2012-05-31 2013-04-03 珠海市君天电子科技有限公司 一种关联于访问请求的统计方法及装置
CN103246727B (zh) * 2013-05-10 2016-09-21 四川省林业调查规划院 一种多用户森林资源时空数据库构建的方法
WO2015193988A1 (ja) * 2014-06-18 2015-12-23 株式会社日立製作所 計算機システム
CN105681254A (zh) * 2014-11-18 2016-06-15 阿里巴巴集团控股有限公司 一种用户身份验证方法及装置
CN104811349A (zh) * 2015-03-26 2015-07-29 浪潮集团有限公司 一种访问统计的方法和装置
US10114617B2 (en) 2016-06-13 2018-10-30 At&T Intellectual Property I, L.P. Rapid visualization rendering package for statistical programming language
US11281770B2 (en) * 2016-08-11 2022-03-22 Salesforce.Com, Inc. Detection of structured query language (SQL) injection events using simple statistical analysis
US10409701B2 (en) 2016-08-11 2019-09-10 Salesforce.Com, Inc. Per-statement monitoring in a database environment
US10922296B2 (en) * 2017-03-01 2021-02-16 Sap Se In-memory row storage durability
CN113515541A (zh) * 2020-04-09 2021-10-19 奇安信安全技术(珠海)有限公司 数据库的数据查询方法、装置和系统
US11275669B2 (en) * 2020-07-09 2022-03-15 Pensando Systems, Inc. Methods and systems for hardware-based statistics management using a general purpose memory
CN112256764A (zh) * 2020-10-29 2021-01-22 河南省科学院应用物理研究所有限公司 统计数据的快速查询方法、装置、计算机设备及存储介质
US11695849B2 (en) * 2021-01-19 2023-07-04 International Business Machines Corporation Transaction tracking for high availability architecture using a tracking token and middleware instance information
CN114722104B (zh) * 2022-06-07 2022-11-18 台州宏创电力集团有限公司科技分公司 基于区块链的企业碳排能耗数据管理运营系统及方法

Family Cites Families (45)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6009271A (en) * 1996-10-28 1999-12-28 Bmc Software, Inc. Method of retrieving data from a relational database
US5903893A (en) 1997-09-15 1999-05-11 International Business Machines Corporation Method and apparatus for optimizing a merge-join operation across heterogeneous databases
US5903887A (en) 1997-09-15 1999-05-11 International Business Machines Corporation Method and apparatus for caching result sets from queries to a remote database in a heterogeneous database system
AU2878499A (en) * 1998-02-26 1999-09-15 Sun Microsystems, Inc. Method and system for typesafe attribute matching
AU752473B2 (en) 1998-06-26 2002-09-19 Ajinomoto Co., Inc. Novel aspartyl dipeptide ester derivatives and sweeteners
US6487641B1 (en) 1999-04-19 2002-11-26 Oracle Corporation Dynamic caches with miss tables
JP2000353149A (ja) * 1999-06-09 2000-12-19 Nec Corp 統計業務情報作成方法及び装置並びに統計業務情報作成プログラムを記録した記録媒体
US6466931B1 (en) 1999-07-30 2002-10-15 International Business Machines Corporation Method and system for transparently caching and reusing query execution plans efficiently
US6668253B1 (en) * 1999-09-08 2003-12-23 Reynolds & Reynolds Holdings, Inc. Enterprise information management system and methods
AU2001257077A1 (en) * 2000-04-17 2001-10-30 Brio Technology, Inc. Analytical server including metrics engine
US6615317B2 (en) * 2000-07-07 2003-09-02 Fitech Laboratories, Inc. Methods and systems for providing a highly scalable synchronous data cache
US7464069B2 (en) 2002-02-21 2008-12-09 Bea Systems, Inc. System and method for eager relationship caching of entity beans
US7089228B2 (en) 2002-04-18 2006-08-08 International Business Machines Corporation Computer apparatus and method for caching results of a database query
US20040193656A1 (en) * 2003-03-28 2004-09-30 Pizzo Michael J. Systems and methods for caching and invalidating database results and derived objects
CA2425046C (en) 2003-04-08 2009-10-06 Ibm Canada Limited - Ibm Canada Limitee Method and system for caching database query statements
US8082210B2 (en) * 2003-04-29 2011-12-20 The Western Union Company Authentication for online money transfers
JP2004347448A (ja) * 2003-05-22 2004-12-09 Xanavi Informatics Corp ナビゲーション装置の経路探索方法
EP1501021A1 (en) * 2003-07-22 2005-01-26 Sap Ag A system and method for extracting data sets from an online relational database into a data warehouse
US20050033777A1 (en) * 2003-08-04 2005-02-10 Moraes Mark A. Tracking, recording and organizing changes to data in computer systems
US8543566B2 (en) * 2003-09-23 2013-09-24 Salesforce.Com, Inc. System and methods of improving a multi-tenant database query using contextual knowledge about non-homogeneously distributed tenant data
US7467131B1 (en) 2003-09-30 2008-12-16 Google Inc. Method and system for query data caching and optimization in a search engine system
US20050108204A1 (en) * 2003-11-13 2005-05-19 International Business Machines System and method for managing OLAP summary tables
US7624119B2 (en) * 2004-02-11 2009-11-24 International Business Machines Corporation Low-overhead built-in timestamp column for relational database systems
US7512693B2 (en) * 2004-05-13 2009-03-31 International Business Machines Corporation Dual-component state token with state data direct access index for systems with high transaction volume and high number of unexpired tokens
US20060004794A1 (en) * 2004-06-30 2006-01-05 Microsoft Corporation Rich application view system and method
US7464077B1 (en) 2004-07-29 2008-12-09 Starview Technology, Inc. Queryable cache in real-time data management system
US7395258B2 (en) 2004-07-30 2008-07-01 International Business Machines Corporation System and method for adaptive database caching
CN1744128A (zh) * 2004-08-31 2006-03-08 中国银联股份有限公司 一种新型银行卡交易交换系统
CN1588369A (zh) 2004-09-06 2005-03-02 杭州恒生电子股份有限公司 一种关系型数据库系统及其查询和报表方法
CN1588368A (zh) 2004-09-07 2005-03-02 孟小峰 基于模式的xml存储方法及应用
GB2418310B (en) 2004-09-18 2007-06-27 Hewlett Packard Development Co Visual sensing for large-scale tracking
US20060136504A1 (en) * 2004-12-17 2006-06-22 Dieter Babutzka Combined analysis of statistical and performance data in a computer based enterprise application environment
CN1632793A (zh) 2004-12-29 2005-06-29 复旦大学 一种利用缓存将关系数据发布为xml文档的优化方法
US7210620B2 (en) * 2005-01-04 2007-05-01 Ameriprise Financial, Inc. System for facilitating online electronic transactions
US20060271510A1 (en) * 2005-05-25 2006-11-30 Terracotta, Inc. Database Caching and Invalidation using Database Provided Facilities for Query Dependency Analysis
US7451155B2 (en) * 2005-10-05 2008-11-11 At&T Intellectual Property I, L.P. Statistical methods and apparatus for records management
US7620642B2 (en) * 2005-12-13 2009-11-17 Sap Ag Mapping data structures
US20070282837A1 (en) * 2006-05-31 2007-12-06 International Business Machines Corporation Measuring the Performance of Database Stored Procedures in a Multi-Tasking Execution Environment
US7418453B2 (en) * 2006-06-15 2008-08-26 International Business Machines Corporation Updating a data warehouse schema based on changes in an observation model
CN100498719C (zh) * 2006-12-30 2009-06-10 中国建设银行股份有限公司 一种执行批处理作业的方法及装置
US7720990B2 (en) * 2007-01-10 2010-05-18 International Business Machines Corporation Method and apparatus for handling service requests in a data processing system
US10394771B2 (en) * 2007-02-28 2019-08-27 International Business Machines Corporation Use of search templates to identify slow information server search patterns
WO2009052210A2 (en) * 2007-10-15 2009-04-23 I.D. Systems, Inc. System and method for managing work requests for mobile assets
CN101430687B (zh) 2007-11-09 2015-11-25 阿里巴巴集团控股有限公司 基于oltp环境的统计表应用方法及系统
US8239584B1 (en) * 2010-12-16 2012-08-07 Emc Corporation Techniques for automated storage management

Also Published As

Publication number Publication date
US20100223227A1 (en) 2010-09-02
JP5364719B2 (ja) 2013-12-11
TWI536184B (zh) 2016-06-01
US20130006918A1 (en) 2013-01-03
CN101430687A (zh) 2009-05-13
EP2210177A4 (en) 2014-06-04
WO2009062067A1 (en) 2009-05-14
JP2011505615A (ja) 2011-02-24
US8862539B2 (en) 2014-10-14
TW201013432A (en) 2010-04-01
CN101430687B (zh) 2015-11-25
US9146956B2 (en) 2015-09-29
US8290896B2 (en) 2012-10-16
EP2210177A1 (en) 2010-07-28
US20140365425A1 (en) 2014-12-11

Similar Documents

Publication Publication Date Title
HK1130335A1 (zh) 基於 環境的統計表應用方法及系統
HUE042697T2 (hu) ETL kisebb nulla redundancia rendszer és eljárás OLTP adatok jelentésére
EP2235620A4 (en) SYSTEM AND METHOD FOR PRODUCING METADATA
EP2029767A4 (en) DEVICES AND METHODS FOR REDUCING MATRIX EFFECTS
GB201109769D0 (en) System and method
EP2088097A4 (en) STORAGE SYSTEM AND STORAGE METHOD
GB0801176D0 (en) Device and method for use in construction
IL192544A0 (en) Lyophilization system and method
EP2227293A4 (en) MAGNARETRECTOR SYSTEM AND METHOD
IL192759A0 (en) New method and system
TWI348096B (en) Method and system for optimizing storage
EP2216429A4 (en) SILICO SCREENING SYSTEM AND SILICO SCREENING METHOD
GB2452895B (en) Method and system for document comparison using cross plane comparison
EP2149111A4 (en) DISTRIBUTION METHOD AND SYSTEM
GB2428324B (en) Apparatus and methods relating to voting systems
GB201002285D0 (en) Project management system and method
GB2453446B (en) Method and system for quantifying damage in a structure
TWI367430B (en) Circuit-design-modifying method executable in computer system
EP2187695A4 (en) METHOD, DEVICE AND SYSTEM FOR REALIZING A TASK IN A CLUSTER ENVIRONMENT
EP2106601A4 (en) SYSTEM AND METHOD FOR METADATA USE IN ADVERTISING
EP1899833A4 (en) DEVICE MANAGEMENT SYSTEM AND METHOD FOR SETTING A CONFIGURATION VALUE THEREIN
EP2015921A4 (en) METHOD AND DEVICE FOR REPLICATING A STRUCTURE
EP2088776A4 (en) METADATA USING EDITING DEVICE AND EDITING METHOD
HK1122923A1 (en) Method and system for charging in multi-pdp environment
GB2464225B (en) Containment extension and processing system and method