CN105446991B - 数据存储方法、查询方法及设备 - Google Patents

数据存储方法、查询方法及设备 Download PDF

Info

Publication number
CN105446991B
CN105446991B CN201410320794.XA CN201410320794A CN105446991B CN 105446991 B CN105446991 B CN 105446991B CN 201410320794 A CN201410320794 A CN 201410320794A CN 105446991 B CN105446991 B CN 105446991B
Authority
CN
China
Prior art keywords
value
information table
combination
identifier value
storage
Prior art date
Legal status (The legal status 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 status listed.)
Active
Application number
CN201410320794.XA
Other languages
English (en)
Chinese (zh)
Other versions
CN105446991A (zh
Inventor
储晓颖
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Advanced New Technologies Co Ltd
Original Assignee
Alibaba Group Holding 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 Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Priority to CN201410320794.XA priority Critical patent/CN105446991B/zh
Priority to US15/324,661 priority patent/US10489372B2/en
Priority to PCT/CN2015/081651 priority patent/WO2016004813A1/zh
Priority to JP2017500353A priority patent/JP6744854B2/ja
Priority to EP15819546.1A priority patent/EP3168758A1/en
Publication of CN105446991A publication Critical patent/CN105446991A/zh
Application granted granted Critical
Publication of CN105446991B publication Critical patent/CN105446991B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2457—Query processing with adaptation to user needs
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201410320794.XA 2014-07-07 2014-07-07 数据存储方法、查询方法及设备 Active CN105446991B (zh)

Priority Applications (5)

Application Number Priority Date Filing Date Title
CN201410320794.XA CN105446991B (zh) 2014-07-07 2014-07-07 数据存储方法、查询方法及设备
US15/324,661 US10489372B2 (en) 2014-07-07 2015-06-17 Data storage methods, query methods, and apparatuses thereof
PCT/CN2015/081651 WO2016004813A1 (zh) 2014-07-07 2015-06-17 数据存储方法、查询方法及设备
JP2017500353A JP6744854B2 (ja) 2014-07-07 2015-06-17 データ記憶方法、データ照会方法、およびそれらの装置
EP15819546.1A EP3168758A1 (en) 2014-07-07 2015-06-17 Data storage method, query method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410320794.XA CN105446991B (zh) 2014-07-07 2014-07-07 数据存储方法、查询方法及设备

Publications (2)

Publication Number Publication Date
CN105446991A CN105446991A (zh) 2016-03-30
CN105446991B true CN105446991B (zh) 2018-10-30

Family

ID=55063565

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410320794.XA Active CN105446991B (zh) 2014-07-07 2014-07-07 数据存储方法、查询方法及设备

Country Status (5)

Country Link
US (1) US10489372B2 (enExample)
EP (1) EP3168758A1 (enExample)
JP (1) JP6744854B2 (enExample)
CN (1) CN105446991B (enExample)
WO (1) WO2016004813A1 (enExample)

Families Citing this family (29)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107038579B (zh) * 2016-02-04 2020-05-05 阿里巴巴集团控股有限公司 一种电子支付业务处理、电子支付方法及装置
CN107153651B (zh) * 2016-03-03 2021-04-02 阿里巴巴集团控股有限公司 一种多维交叉数据处理方法及装置
CN108255877B (zh) * 2016-12-29 2020-11-24 北京国双科技有限公司 裁判文书的存储方法及装置
US10685026B2 (en) * 2017-04-11 2020-06-16 Sap Se Database query based match engine
CN108647280A (zh) * 2018-05-03 2018-10-12 北京云中融信网络科技有限公司 一种存储通讯信息的方法和装置
CN109284260B (zh) * 2018-10-16 2023-10-13 平安证券股份有限公司 大数据文件读取方法、装置、计算机设备及存储介质
CN111382197B (zh) * 2018-12-28 2023-10-27 杭州海康威视数字技术股份有限公司 分区管理、数据存储和查询方法及装置、设备、介质
CN112148512B (zh) * 2019-06-27 2024-07-12 腾讯科技（深圳）有限公司 一种内容库管理方法、装置、设备及存储介质
US11474977B2 (en) 2019-09-30 2022-10-18 Dropbox, Inc. Snapshot isolation in a distributed storage system
CN111258981A (zh) * 2020-01-13 2020-06-09 中国建设银行股份有限公司 一种数据处理方法、装置、设备和存储介质
CN111506600B (zh) * 2020-03-23 2023-06-16 杭州海康威视系统技术有限公司 分页查询方法、装置和电子设备
CN111488386B (zh) * 2020-04-14 2023-09-29 北京易数科技有限公司 数据查询方法和装置
CN112100226B (zh) * 2020-09-18 2024-06-21 腾讯科技（深圳）有限公司 一种数据查询方法及计算机可读存储介质
CN112115147B (zh) * 2020-09-25 2024-04-30 北京百度网讯科技有限公司 数据处理的方法、装置、设备和存储介质
CN114490627A (zh) * 2020-10-27 2022-05-13 杭州数梦工场科技有限公司 一种数据处理方法、装置及电子设备和存储介质
CN112527828B (zh) * 2020-12-10 2023-03-14 福建新大陆支付技术有限公司 一种税控机税控记录存储方法及检索查询方法
CN112732761B (zh) * 2021-01-13 2022-08-23 青岛海信网络科技股份有限公司 一种数据碰撞方法及装置
CN112749541A (zh) * 2021-01-14 2021-05-04 京东数字科技控股股份有限公司 数据校验系统、方法、装置、电子设备和计算机可读介质
CN112800179B (zh) * 2021-02-02 2022-02-15 浙江公共安全技术研究院有限公司 关联数据库查询方法、装置、存储介质及电子设备
CN113254447A (zh) * 2021-05-27 2021-08-13 平安普惠企业管理有限公司 Id生成方法、装置、电子设备及存储介质
CN113342832B (zh) * 2021-08-04 2021-11-02 北京快立方科技有限公司 一种数据库索引方法
CN113705184B (zh) * 2021-09-01 2023-09-22 同盾科技有限公司 自定义报表的生成方法及装置、存储介质、电子设备
CN113934746A (zh) * 2021-09-08 2022-01-14 所托(杭州)汽车智能设备有限公司 一种记录的分片方法、装置、设备及存储介质
CN113821514B (zh) * 2021-09-26 2024-08-30 维沃移动通信有限公司 数据拆分方法、装置、电子设备和可读存储介质
CN114064494A (zh) * 2021-11-19 2022-02-18 北京每日菜场科技有限公司 数据异常报警方法、装置、电子设备和计算机可读介质
CN115100757B (zh) * 2022-06-20 2023-05-09 重庆长安汽车股份有限公司 汽车数据的存储方法、装置、车辆及存储介质
CN115295164A (zh) * 2022-07-21 2022-11-04 泰康保险集团股份有限公司 医保数据的处理方法、装置、电子设备和存储介质
CN115344576A (zh) * 2022-08-05 2022-11-15 中国平安财产保险股份有限公司 一种数据空间查询方法、装置、电子设备及存储介质
CN116405271A (zh) * 2023-03-23 2023-07-07 中国电子科技集团公司第三十研究所 一种基于标识的数据安全策略分类方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101968806A (zh) * 2010-10-22 2011-02-09 天津南大通用数据技术有限公司 数据存储方法、查询方法及装置
CN102521303A (zh) * 2011-11-30 2012-06-27 北京人大金仓信息技术股份有限公司 一种用于列数据库的单表多列序存储方法
CN102999526A (zh) * 2011-09-16 2013-03-27 阿里巴巴集团控股有限公司 一种数据库关系表的拆分、查询方法及系统
CN103902544A (zh) * 2012-12-25 2014-07-02 中国移动通信集团公司 一种数据处理方法及系统

Family Cites Families (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5732257A (en) * 1995-09-13 1998-03-24 Hewlett-Packard Co. Object conversion method from a flat object space to a class structured space
US5943665A (en) * 1997-09-09 1999-08-24 Netscape Communications Corporation Method and system for performing conceptual joins across fields of a database
US7739224B1 (en) * 1998-05-06 2010-06-15 Infor Global Solutions (Michigan), Inc. Method and system for creating a well-formed database using semantic definitions
US6189004B1 (en) * 1998-05-06 2001-02-13 E. Piphany, Inc. Method and apparatus for creating a datamart and for creating a query structure for the datamart
SE516562C2 (sv) * 1999-03-12 2002-01-29 Qliktech Internat Ab Förfarande för extrahering av information från en databas
JP3626632B2 (ja) * 1999-06-18 2005-03-09 エヌイーシーシステムテクノロジー株式会社 データーベースアクセス方式，方法および記憶媒体
JP3711817B2 (ja) * 1999-11-05 2005-11-02 日本電気株式会社 データベースアクセス方法及びその装置並びにプログラムを記録した機械読み取り可能な記録媒体
GB2363221B (en) * 2000-06-09 2002-05-01 Oracle Corp Summary creation
WO2002044943A2 (en) * 2000-11-29 2002-06-06 Lafayette Software Inc. Methods of organizing data and processing queries in a database system, and database system and software product for implementing such methods
US7181450B2 (en) * 2002-12-18 2007-02-20 International Business Machines Corporation Method, system, and program for use of metadata to create multidimensional cubes in a relational database
US7895191B2 (en) * 2003-04-09 2011-02-22 International Business Machines Corporation Improving performance of database queries
US20050102326A1 (en) * 2003-10-22 2005-05-12 Nitzan Peleg Method and apparatus for performing conflict resolution in database logging
US7392242B1 (en) * 2004-02-27 2008-06-24 Hyperion Solutions Corporation Query costing in a multidimensional database
US7584178B2 (en) * 2006-04-20 2009-09-01 International Business Machines Corporation Query condition building using predefined query objects
JP4914117B2 (ja) * 2006-05-22 2012-04-11 株式会社野村総合研究所 データ処理システム
CN101533414A (zh) * 2009-04-15 2009-09-16 阿里巴巴集团控股有限公司 一种数据库记录唯一标识符生成的方法及装置
US8190557B2 (en) * 2009-11-25 2012-05-29 Barber Paul Grant Processor and method configured for executing data transfer or data adjustment functions on OLAP based data
US20120197900A1 (en) * 2010-12-13 2012-08-02 Unisys Corporation Systems and methods for search time tree indexes
EP2490135A1 (en) * 2011-02-21 2012-08-22 Amadeus S.A.S. Method and system for providing statistical data from a data warehouse
JP5604403B2 (ja) * 2011-10-26 2014-10-08 株式会社野村総合研究所 データ利用システム
US8676772B2 (en) * 2011-12-09 2014-03-18 Telduráðgevin Sp/f Systems and methods for improving database performance
US8447730B1 (en) * 2012-01-31 2013-05-21 Yahoo! Inc. Probe system for replication monitoring
CN103577456B (zh) * 2012-07-31 2016-12-21 国际商业机器公司 用于处理时序数据的方法和装置
GB2510626A (en) * 2013-02-11 2014-08-13 Face Recording And Measurement Systems Ltd Organising data entry forms
US9298521B1 (en) * 2013-04-29 2016-03-29 Seagate Technology Llc Command sets and functions
US11138243B2 (en) * 2014-03-06 2021-10-05 International Business Machines Corporation Indexing geographic data
US10360196B2 (en) * 2014-04-15 2019-07-23 Splunk Inc. Grouping and managing event streams generated from captured network data
US10346358B2 (en) * 2014-06-04 2019-07-09 Waterline Data Science, Inc. Systems and methods for management of data platforms

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101968806A (zh) * 2010-10-22 2011-02-09 天津南大通用数据技术有限公司 数据存储方法、查询方法及装置
CN102999526A (zh) * 2011-09-16 2013-03-27 阿里巴巴集团控股有限公司 一种数据库关系表的拆分、查询方法及系统
CN102521303A (zh) * 2011-11-30 2012-06-27 北京人大金仓信息技术股份有限公司 一种用于列数据库的单表多列序存储方法
CN103902544A (zh) * 2012-12-25 2014-07-02 中国移动通信集团公司 一种数据处理方法及系统

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
基于RDBMS的大规模非关系型数据存储技术研究;张勋;《中国优秀硕士学位论文全文数据库》;20140615(第6期);第I138-542页 *

Also Published As

Publication number Publication date
WO2016004813A1 (zh) 2016-01-14
EP3168758A4 (en) 2017-05-17
JP2017523513A (ja) 2017-08-17
EP3168758A1 (en) 2017-05-17
JP6744854B2 (ja) 2020-08-19
US20180181606A1 (en) 2018-06-28
CN105446991A (zh) 2016-03-30
US10489372B2 (en) 2019-11-26

Similar Documents

Publication Publication Date Title
CN105446991B (zh) 数据存储方法、查询方法及设备
US10949447B2 (en) Blockchain-based data synchronizing and data block parsing method and device
CN110390596B (zh) 一种金融期货交易系统
CN108647361A (zh) 一种基于区块链的数据存储方法、装置及系统
US20180004781A1 (en) Data lineage analysis
CN107247758B (zh) 基于银行核心系统的数据处理方法
CN105528447B (zh) 一种对特定数据逐层边剔除边汇总的方法
CN105590216A (zh) 实时监控交易风险的方法及系统
CN111400356A (zh) 数据查询方法、装置及设备
CN107391532B (zh) 数据过滤的方法和装置
CN108090759A (zh) 一种支付渠道智能路由算法
CN114116908A (zh) 一种数据管理方法、装置及电子设备
CN109033248A (zh) 存储数据记录的方法与装置、查询数据记录的方法和装置
CN110363515B (zh) 权益卡账户信息查询方法、系统、服务器及可读存储介质
CN109241121A (zh) 时间序列数据的存储和查询方法、装置、系统及电子设备
CN104599181A (zh) 一种货币类产品的查询方法及装置
CN113179294B (zh) 一种基于智能合约的schema统一存取方法
CN109409650A (zh) 一种企业资源的erp管理系统
CN106951452A (zh) 用于账务追溯的数据查询方法及装置
CN111159353B (zh) 基于多维数据构建智能报告机器人的系统及方法
JP2017167843A (ja) 取引明細管理システムおよび取引明細管理方法
CN114896285A (zh) 一种基于多维中间态聚合的银行流计算业务实时指标系统
CN107436903A (zh) 一种基于NoSQL的数据库管理方法
CN108961039A (zh) 交易处理方法、装置及系统
CN120523817B (zh) 基于多模态gis系统的中药材数据管理方法和系统

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right
TR01 Transfer of patent right

Effective date of registration: 20191206

Address after: P.O. Box 31119, grand exhibition hall, hibiscus street, 802 West Bay Road, Grand Cayman, Cayman Islands

Patentee after: Innovative advanced technology Co., Ltd

Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands

Patentee before: Alibaba Group Holding Co., Ltd.