CN110032604A - 数据存储装置、转译装置及数据库访问方法 - Google Patents
数据存储装置、转译装置及数据库访问方法 Download PDFInfo
- Publication number
- CN110032604A CN110032604A CN201910107394.3A CN201910107394A CN110032604A CN 110032604 A CN110032604 A CN 110032604A CN 201910107394 A CN201910107394 A CN 201910107394A CN 110032604 A CN110032604 A CN 110032604A
- Authority
- CN
- China
- Prior art keywords
- access
- access request
- column
- column family
- field
- 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.)
- Granted
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/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/1734—Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/221—Column-oriented storage; Management thereof
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/242—Query formulation
- G06F16/2433—Query languages
- G06F16/244—Grouping and aggregation
-
- 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
-
- 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/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (30)
Priority Applications (7)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910107394.3A CN110032604B (zh) | 2019-02-02 | 2019-02-02 | 数据存储装置、转译装置及数据库访问方法 |
TW108131216A TWI710919B (zh) | 2019-02-02 | 2019-08-30 | 資料儲存裝置、轉譯裝置及資料庫存取方法 |
EP20708895.6A EP3857400B1 (en) | 2019-02-02 | 2020-01-30 | Data storage apparatus, translation apparatus, and database access method |
PCT/US2020/015872 WO2020160265A1 (en) | 2019-02-02 | 2020-01-30 | Data storage apparatus, translation apparatus, and database access method |
US16/779,531 US10853363B2 (en) | 2019-02-02 | 2020-01-31 | Data storage apparatus, translation apparatus, and database access method |
US17/107,534 US11226961B2 (en) | 2019-02-02 | 2020-11-30 | Data storage apparatus, translation apparatus, and database access method |
US17/574,419 US11797533B2 (en) | 2019-02-02 | 2022-01-12 | Data storage apparatus, translation apparatus, and database access method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910107394.3A CN110032604B (zh) | 2019-02-02 | 2019-02-02 | 数据存储装置、转译装置及数据库访问方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110032604A true CN110032604A (zh) | 2019-07-19 |
CN110032604B CN110032604B (zh) | 2021-12-07 |
Family
ID=67235636
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910107394.3A Active CN110032604B (zh) | 2019-02-02 | 2019-02-02 | 数据存储装置、转译装置及数据库访问方法 |
Country Status (5)
Country | Link |
---|---|
US (3) | US10853363B2 (zh) |
EP (1) | EP3857400B1 (zh) |
CN (1) | CN110032604B (zh) |
TW (1) | TWI710919B (zh) |
WO (1) | WO2020160265A1 (zh) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112347104A (zh) * | 2020-11-06 | 2021-02-09 | 中国人民大学 | 一种基于深度强化学习的列存储布局优化方法 |
CN112395294A (zh) * | 2020-11-27 | 2021-02-23 | 浪潮云信息技术股份公司 | 一种数据库数据管理方法及***、数据库 |
CN112434069A (zh) * | 2020-12-01 | 2021-03-02 | 天津市鑫联兴科技有限公司 | 一种多源异构数据库访问适配方法及适配器 |
CN112910980A (zh) * | 2021-01-27 | 2021-06-04 | ***股份有限公司 | 一种数据库访问***和方法 |
CN113254519A (zh) * | 2021-05-28 | 2021-08-13 | 北京奇岱松科技有限公司 | 多源异构数据库的访问方法、装置、设备和存储介质 |
CN116821139A (zh) * | 2023-08-25 | 2023-09-29 | 南方电网数字电网研究院有限公司 | 基于分布式数据库的分区表设计的混合负载方法及*** |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110032604B (zh) | 2019-02-02 | 2021-12-07 | 北京奥星贝斯科技有限公司 | 数据存储装置、转译装置及数据库访问方法 |
US11481391B1 (en) * | 2019-11-25 | 2022-10-25 | Amazon Technologies, Inc. | Query language operations using a scalable key-item data store |
JP7458259B2 (ja) * | 2020-07-15 | 2024-03-29 | 株式会社日立製作所 | データ管理装置及びデータ管理方法 |
CN111984745B (zh) * | 2020-08-18 | 2024-04-16 | 平安国际智慧城市科技股份有限公司 | 数据库字段动态扩展方法、装置、设备及存储介质 |
CN112395360B (zh) * | 2020-12-01 | 2023-06-23 | 中国联合网络通信集团有限公司 | 基于非关系型数据库的数据同步方法、设备、装置和介质 |
CN112765169A (zh) * | 2021-01-11 | 2021-05-07 | 北京众享比特科技有限公司 | 数据处理方法、装置、设备及存储介质 |
US20230138283A1 (en) * | 2021-10-29 | 2023-05-04 | Sap Se | Transformation of property-value table to facilitate search |
CN115599790B (zh) * | 2022-11-10 | 2024-03-15 | 星环信息科技(上海)股份有限公司 | 一种数据存储***、数据处理方法、电子设备和存储介质 |
Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1815468A (zh) * | 2005-01-31 | 2006-08-09 | 微软公司 | 非关系型查询语言与关系型数据存储的集成 |
CN103514201A (zh) * | 2012-06-27 | 2014-01-15 | 阿里巴巴集团控股有限公司 | 一种非关系型数据库的数据查询方法和装置 |
CN103823815A (zh) * | 2012-11-19 | 2014-05-28 | 中国联合网络通信集团有限公司 | 服务器及数据库访问方法 |
WO2014085624A2 (en) * | 2012-11-30 | 2014-06-05 | Orbis Technologies, Inc. | Ontology harmonization and mediation systems and methods |
CN105681477A (zh) * | 2016-04-08 | 2016-06-15 | 四川师范大学 | 一种数据访问方法和一种服务器 |
CN105868411A (zh) * | 2016-04-27 | 2016-08-17 | 国网上海市电力公司 | 一种非关系型与关系型数据库一体化数据查询方法与*** |
CN105938479A (zh) * | 2016-03-31 | 2016-09-14 | 华南师范大学 | 一种关系表与非关系表的结构转换方法 |
CN106126644A (zh) * | 2016-06-22 | 2016-11-16 | 中国南方电网有限责任公司 | 基于NoSQL数据库的录波文件存储方法 |
CN106294499A (zh) * | 2015-06-09 | 2017-01-04 | 阿里巴巴集团控股有限公司 | 一种数据库数据查询方法和设备 |
CN106326248A (zh) * | 2015-06-23 | 2017-01-11 | 阿里巴巴集团控股有限公司 | 数据库数据的存储方法和装置 |
CN106383850A (zh) * | 2016-08-31 | 2017-02-08 | 东软集团股份有限公司 | 数据处理方法及装置 |
US9607063B1 (en) * | 2015-12-10 | 2017-03-28 | International Business Machines Corporation | NoSQL relational database (RDB) data movement |
CN106897322A (zh) * | 2015-12-21 | 2017-06-27 | ***通信集团山西有限公司 | 一种数据库和文件***的访问方法和装置 |
CN107169033A (zh) * | 2017-04-17 | 2017-09-15 | 东北大学 | 基于数据模式转换和并行框架的关系数据查询优化方法 |
CN107193968A (zh) * | 2017-05-25 | 2017-09-22 | 努比亚技术有限公司 | 一种位置信息存储的方法、装置及计算机可读存储介质 |
CN108932313A (zh) * | 2018-06-20 | 2018-12-04 | 斑马网络技术有限公司 | 数据处理方法、装置、电子设备及存储介质 |
Family Cites Families (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8375044B2 (en) * | 2008-06-24 | 2013-02-12 | Microsoft Corporation | Query processing pipelines with single-item and multiple-item query operators |
US9436710B2 (en) * | 2010-09-28 | 2016-09-06 | Redis Labs Ltd. | Systems, methods, and media for managing an in-memory NoSQL database |
US20140214897A1 (en) * | 2013-01-31 | 2014-07-31 | Yuankai Zhu | SYSTEMS AND METHODS FOR ACCESSING A NoSQL DATABASE USING BUSINESS INTELLIGENCE TOOLS |
US10366056B2 (en) * | 2013-11-15 | 2019-07-30 | Salesforce.Com, Inc. | Asynchronous search for big objects |
CN103744952A (zh) * | 2014-01-02 | 2014-04-23 | 北京集奥聚合网络技术有限公司 | NoSQL数据库多表特性的实现方法及*** |
CN104794123B (zh) * | 2014-01-20 | 2018-07-27 | 阿里巴巴集团控股有限公司 | 一种为半结构化数据构建NoSQL数据库索引的方法及装置 |
US20150293764A1 (en) * | 2014-04-10 | 2015-10-15 | Omprakash VISVANATHAN | Method and system to compose and execute business rules |
US9430554B2 (en) * | 2014-08-28 | 2016-08-30 | Weebly, Inc. | Object-relational mapping based on virtual columns |
US10176153B1 (en) * | 2014-09-25 | 2019-01-08 | Amazon Technologies, Inc. | Generating custom markup content to deter robots |
CN106326309B (zh) * | 2015-07-03 | 2020-02-21 | 阿里巴巴集团控股有限公司 | 一种数据查询方法和装置 |
US10552443B1 (en) * | 2016-08-11 | 2020-02-04 | MuleSoft, Inc. | Schemaless to relational representation conversion |
US10216823B2 (en) * | 2017-05-31 | 2019-02-26 | HarperDB, Inc. | Systems, methods, and apparatus for hierarchical database |
CN110032604B (zh) | 2019-02-02 | 2021-12-07 | 北京奥星贝斯科技有限公司 | 数据存储装置、转译装置及数据库访问方法 |
-
2019
- 2019-02-02 CN CN201910107394.3A patent/CN110032604B/zh active Active
- 2019-08-30 TW TW108131216A patent/TWI710919B/zh active
-
2020
- 2020-01-30 EP EP20708895.6A patent/EP3857400B1/en active Active
- 2020-01-30 WO PCT/US2020/015872 patent/WO2020160265A1/en unknown
- 2020-01-31 US US16/779,531 patent/US10853363B2/en active Active
- 2020-11-30 US US17/107,534 patent/US11226961B2/en active Active
-
2022
- 2022-01-12 US US17/574,419 patent/US11797533B2/en active Active
Patent Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1815468A (zh) * | 2005-01-31 | 2006-08-09 | 微软公司 | 非关系型查询语言与关系型数据存储的集成 |
CN103514201A (zh) * | 2012-06-27 | 2014-01-15 | 阿里巴巴集团控股有限公司 | 一种非关系型数据库的数据查询方法和装置 |
CN103823815A (zh) * | 2012-11-19 | 2014-05-28 | 中国联合网络通信集团有限公司 | 服务器及数据库访问方法 |
WO2014085624A2 (en) * | 2012-11-30 | 2014-06-05 | Orbis Technologies, Inc. | Ontology harmonization and mediation systems and methods |
CN106294499A (zh) * | 2015-06-09 | 2017-01-04 | 阿里巴巴集团控股有限公司 | 一种数据库数据查询方法和设备 |
CN106326248A (zh) * | 2015-06-23 | 2017-01-11 | 阿里巴巴集团控股有限公司 | 数据库数据的存储方法和装置 |
US9607063B1 (en) * | 2015-12-10 | 2017-03-28 | International Business Machines Corporation | NoSQL relational database (RDB) data movement |
CN106897322A (zh) * | 2015-12-21 | 2017-06-27 | ***通信集团山西有限公司 | 一种数据库和文件***的访问方法和装置 |
CN105938479A (zh) * | 2016-03-31 | 2016-09-14 | 华南师范大学 | 一种关系表与非关系表的结构转换方法 |
CN105681477A (zh) * | 2016-04-08 | 2016-06-15 | 四川师范大学 | 一种数据访问方法和一种服务器 |
CN105868411A (zh) * | 2016-04-27 | 2016-08-17 | 国网上海市电力公司 | 一种非关系型与关系型数据库一体化数据查询方法与*** |
CN106126644A (zh) * | 2016-06-22 | 2016-11-16 | 中国南方电网有限责任公司 | 基于NoSQL数据库的录波文件存储方法 |
CN106383850A (zh) * | 2016-08-31 | 2017-02-08 | 东软集团股份有限公司 | 数据处理方法及装置 |
CN107169033A (zh) * | 2017-04-17 | 2017-09-15 | 东北大学 | 基于数据模式转换和并行框架的关系数据查询优化方法 |
CN107193968A (zh) * | 2017-05-25 | 2017-09-22 | 努比亚技术有限公司 | 一种位置信息存储的方法、装置及计算机可读存储介质 |
CN108932313A (zh) * | 2018-06-20 | 2018-12-04 | 斑马网络技术有限公司 | 数据处理方法、装置、电子设备及存储介质 |
Non-Patent Citations (3)
Title |
---|
ARUN KUMAR KALAKANTI ET AL.: ""A comprehensive evaluation of NoSQL datastores in the context of historians and sensor data analysis"", 《IEEE INTERNATIONAL CONFERENCE ON BIG DATA》 * |
CRAIG CHASSEUR ET AL.: ""Enabling JSON Document Stores in Relational Systems"", 《SIXTEENTH INTERNATIONAL WORKSHOP ON THE WEB AND DATABASES》 * |
李青云 等: ""关系型数据库到HBase的转换设计"", 《信息网络安全》 * |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112347104A (zh) * | 2020-11-06 | 2021-02-09 | 中国人民大学 | 一种基于深度强化学习的列存储布局优化方法 |
CN112395294A (zh) * | 2020-11-27 | 2021-02-23 | 浪潮云信息技术股份公司 | 一种数据库数据管理方法及***、数据库 |
CN112434069A (zh) * | 2020-12-01 | 2021-03-02 | 天津市鑫联兴科技有限公司 | 一种多源异构数据库访问适配方法及适配器 |
CN112910980A (zh) * | 2021-01-27 | 2021-06-04 | ***股份有限公司 | 一种数据库访问***和方法 |
CN112910980B (zh) * | 2021-01-27 | 2022-11-15 | ***股份有限公司 | 一种数据库访问***和方法 |
CN113254519A (zh) * | 2021-05-28 | 2021-08-13 | 北京奇岱松科技有限公司 | 多源异构数据库的访问方法、装置、设备和存储介质 |
CN116821139A (zh) * | 2023-08-25 | 2023-09-29 | 南方电网数字电网研究院有限公司 | 基于分布式数据库的分区表设计的混合负载方法及*** |
CN116821139B (zh) * | 2023-08-25 | 2024-01-23 | 南方电网数字电网研究院有限公司 | 基于分布式数据库的分区表设计的混合负载方法及*** |
Also Published As
Publication number | Publication date |
---|---|
TWI710919B (zh) | 2020-11-21 |
US20220138197A1 (en) | 2022-05-05 |
US11226961B2 (en) | 2022-01-18 |
US20200250190A1 (en) | 2020-08-06 |
TW202032386A (zh) | 2020-09-01 |
CN110032604B (zh) | 2021-12-07 |
EP3857400B1 (en) | 2023-05-24 |
US20210081416A1 (en) | 2021-03-18 |
US10853363B2 (en) | 2020-12-01 |
WO2020160265A1 (en) | 2020-08-06 |
EP3857400A1 (en) | 2021-08-04 |
US11797533B2 (en) | 2023-10-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110032604A (zh) | 数据存储装置、转译装置及数据库访问方法 | |
EP3446242B1 (en) | Query plan generation and execution in a relational database management system with a temporal-relational database | |
US9792327B2 (en) | Self-described query execution in a massively parallel SQL execution engine | |
JP3851493B2 (ja) | データベース検索方法及びデータベース検索システム並びにデータベース検索プログラムを記録したコンピュータ読み取り可能な記録媒体 | |
US5895465A (en) | Heuristic co-identification of objects across heterogeneous information sources | |
CN1705945B (zh) | 提供查询的属性的方法和*** | |
US7562086B2 (en) | Custom grouping for dimension members | |
US6480842B1 (en) | Dimension to domain server | |
US9081837B2 (en) | Scoped database connections | |
US5450581A (en) | System for copying from one database management system to another by translating authorization statements | |
KR102177190B1 (ko) | 유연한 스키마를 사용한 데이터 관리 | |
CN108228817A (zh) | 数据处理方法、装置和*** | |
EP2784700A2 (en) | Integration of transactional and analytical capabilities of a database management system | |
US7693911B2 (en) | Uniform metadata retrieval | |
US7979456B2 (en) | Method of managing and providing parameterized queries | |
US20140337287A1 (en) | Virtual repository management | |
US7617211B2 (en) | System and method for automatically synchronizing security-relevant information between a relational database and a multidimensional database | |
CN110019251A (zh) | 一种数据处理***、方法及设备 | |
JP2001056810A (ja) | データベースアクセスシステム | |
KR102034679B1 (ko) | 그리드 인터페이스 기반 데이터 입출력 시스템 | |
KR100529661B1 (ko) | 오브젝트 통합 관리 시스템 | |
US6678686B1 (en) | Method and apparatus for evaluating index predicates on complex data types using virtual indexed streams | |
US20080263142A1 (en) | Meta Data Driven User Interface System and Method | |
US20080263018A1 (en) | Method and System for Mapping Business Objects to Relational Database Tables | |
JP2002175327A (ja) | データベース管理方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20201016 Address after: English genus Applicant after: Innovative advanced technology Co.,Ltd. Address before: English genus Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201016 Address after: English genus Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210207 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province Applicant after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: English genus Applicant before: Innovative advanced technology Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210908 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Applicant after: Beijing Aoxing Beisi Technology Co.,Ltd. Address before: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Applicant before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant |