CN106815353A - 一种数据查询的方法及设备 - Google Patents
一种数据查询的方法及设备 Download PDFInfo
- Publication number
- CN106815353A CN106815353A CN201710042222.3A CN201710042222A CN106815353A CN 106815353 A CN106815353 A CN 106815353A CN 201710042222 A CN201710042222 A CN 201710042222A CN 106815353 A CN106815353 A CN 106815353A
- Authority
- CN
- China
- Prior art keywords
- data
- checked
- database
- user
- definition
- 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
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000006870 function Effects 0.000 claims description 66
- 238000003860 storage Methods 0.000 claims description 49
- 238000001914 filtration Methods 0.000 claims description 14
- 238000004458 analytical method Methods 0.000 claims description 12
- 230000002452 interceptive effect Effects 0.000 claims description 12
- 230000007246 mechanism Effects 0.000 claims description 11
- 230000011514 reflex Effects 0.000 claims description 11
- 230000002688 persistence Effects 0.000 claims description 5
- 230000008569 process Effects 0.000 description 8
- 238000005516 engineering process Methods 0.000 description 7
- 238000007726 management method Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 238000013500 data storage Methods 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 238000004590 computer program Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000014759 maintenance of location Effects 0.000 description 3
- 239000004744 fabric Substances 0.000 description 2
- 230000000977 initiatory effect Effects 0.000 description 2
- 238000002955 isolation Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 239000007787 solid Substances 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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/242—Query formulation
-
- 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/24553—Query execution of query operations
-
- 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)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (24)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710042222.3A CN106815353B (zh) | 2017-01-20 | 2017-01-20 | 一种数据查询的方法及设备 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710042222.3A CN106815353B (zh) | 2017-01-20 | 2017-01-20 | 一种数据查询的方法及设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106815353A true CN106815353A (zh) | 2017-06-09 |
CN106815353B CN106815353B (zh) | 2020-02-21 |
Family
ID=59111186
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710042222.3A Active CN106815353B (zh) | 2017-01-20 | 2017-01-20 | 一种数据查询的方法及设备 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106815353B (zh) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107665233A (zh) * | 2017-07-24 | 2018-02-06 | 上海壹账通金融科技有限公司 | 数据库数据处理方法、装置、计算机设备和存储介质 |
CN107862097A (zh) * | 2017-12-21 | 2018-03-30 | 上海新炬网络技术有限公司 | 一种基于TimesTen内存库的表数据智能清理方法 |
CN109344165A (zh) * | 2018-11-23 | 2019-02-15 | 福建榕基软件股份有限公司 | 一种查询方法及存储设备 |
CN110110108A (zh) * | 2019-04-09 | 2019-08-09 | 苏宁易购集团股份有限公司 | 一种图数据库的数据导入方法及装置 |
CN113297139A (zh) * | 2021-04-28 | 2021-08-24 | 上海淇玥信息技术有限公司 | 元数据查询方法、系统及电子设备 |
JP2021522570A (ja) * | 2018-04-19 | 2021-08-30 | リスク マネジメント ソリューションズ, インコーポレイテッド | 少ない待ち時間の検索問合せ応答を提供するためのデータ記憶システム |
CN117407430A (zh) * | 2023-12-05 | 2024-01-16 | 支付宝(杭州)信息技术有限公司 | 数据查询方法、装置、计算机设备及存储介质 |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1652112A (zh) * | 2005-03-02 | 2005-08-10 | 北京北方烽火科技有限公司 | 一种嵌入式环境下数据字典的实现方法 |
CN101043648A (zh) * | 2007-03-09 | 2007-09-26 | 中国移动通信集团福建有限公司 | 业务服务交换系统 |
CN101382957A (zh) * | 2008-10-24 | 2009-03-11 | 用友软件股份有限公司 | 建立查询模型的系统及建立方法 |
CN101673287A (zh) * | 2009-10-16 | 2010-03-17 | 金蝶软件(中国)有限公司 | 一种sql语句生成方法及系统 |
CN103177046A (zh) * | 2011-12-26 | 2013-06-26 | 中国移动通信集团公司 | 一种基于行存储数据库的数据处理方法和设备 |
CN105183735A (zh) * | 2014-06-18 | 2015-12-23 | 阿里巴巴集团控股有限公司 | 数据的查询方法及查询装置 |
US20170017690A1 (en) * | 2009-10-05 | 2017-01-19 | Salesforce.Com, Inc. | Methods and systems for joining indexes for query optimization in a multi-tenant database |
-
2017
- 2017-01-20 CN CN201710042222.3A patent/CN106815353B/zh active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1652112A (zh) * | 2005-03-02 | 2005-08-10 | 北京北方烽火科技有限公司 | 一种嵌入式环境下数据字典的实现方法 |
CN101043648A (zh) * | 2007-03-09 | 2007-09-26 | 中国移动通信集团福建有限公司 | 业务服务交换系统 |
CN101382957A (zh) * | 2008-10-24 | 2009-03-11 | 用友软件股份有限公司 | 建立查询模型的系统及建立方法 |
US20170017690A1 (en) * | 2009-10-05 | 2017-01-19 | Salesforce.Com, Inc. | Methods and systems for joining indexes for query optimization in a multi-tenant database |
CN101673287A (zh) * | 2009-10-16 | 2010-03-17 | 金蝶软件(中国)有限公司 | 一种sql语句生成方法及系统 |
CN103177046A (zh) * | 2011-12-26 | 2013-06-26 | 中国移动通信集团公司 | 一种基于行存储数据库的数据处理方法和设备 |
CN105183735A (zh) * | 2014-06-18 | 2015-12-23 | 阿里巴巴集团控股有限公司 | 数据的查询方法及查询装置 |
Non-Patent Citations (1)
Title |
---|
张欢: "mysql视图和临时表的区别", 《HTTPS://MY.OSCHINA.NET/U/2000675/BLOG/718585》 * |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2019019361A1 (zh) * | 2017-07-24 | 2019-01-31 | 上海壹账通金融科技有限公司 | 数据库数据处理方法、装置、计算机设备和存储介质 |
CN107665233A (zh) * | 2017-07-24 | 2018-02-06 | 上海壹账通金融科技有限公司 | 数据库数据处理方法、装置、计算机设备和存储介质 |
CN107665233B (zh) * | 2017-07-24 | 2020-07-31 | 深圳壹账通智能科技有限公司 | 数据库数据处理方法、装置、计算机设备和存储介质 |
CN107862097A (zh) * | 2017-12-21 | 2018-03-30 | 上海新炬网络技术有限公司 | 一种基于TimesTen内存库的表数据智能清理方法 |
JP2021522570A (ja) * | 2018-04-19 | 2021-08-30 | リスク マネジメント ソリューションズ, インコーポレイテッド | 少ない待ち時間の検索問合せ応答を提供するためのデータ記憶システム |
JP2022088603A (ja) * | 2018-04-19 | 2022-06-14 | リスク マネジメント ソリューションズ, インコーポレイテッド | 少ない待ち時間の検索問合せ応答を提供するためのデータ記憶システム |
JP7053885B2 (ja) | 2018-04-19 | 2022-04-12 | リスク マネジメント ソリューションズ, インコーポレイテッド | 少ない待ち時間の検索問合せ応答を提供するためのデータ記憶システム |
CN109344165A (zh) * | 2018-11-23 | 2019-02-15 | 福建榕基软件股份有限公司 | 一种查询方法及存储设备 |
CN110110108B (zh) * | 2019-04-09 | 2021-03-30 | 苏宁易购集团股份有限公司 | 一种图数据库的数据导入方法及装置 |
CN110110108A (zh) * | 2019-04-09 | 2019-08-09 | 苏宁易购集团股份有限公司 | 一种图数据库的数据导入方法及装置 |
CN113297139A (zh) * | 2021-04-28 | 2021-08-24 | 上海淇玥信息技术有限公司 | 元数据查询方法、系统及电子设备 |
CN117407430A (zh) * | 2023-12-05 | 2024-01-16 | 支付宝(杭州)信息技术有限公司 | 数据查询方法、装置、计算机设备及存储介质 |
CN117407430B (zh) * | 2023-12-05 | 2024-04-16 | 支付宝(杭州)信息技术有限公司 | 数据查询方法、装置、计算机设备及存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN106815353B (zh) | 2020-02-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106815353A (zh) | 一种数据查询的方法及设备 | |
US20200226151A1 (en) | System and method for supporting queries having sub-select constructs in a multidimensional database environment | |
US11468103B2 (en) | Relational modeler and renderer for non-relational data | |
US10747762B2 (en) | Automatic generation of sub-queries | |
US20210049163A1 (en) | Data preparation context navigation | |
US10083227B2 (en) | On-the-fly determination of search areas and queries for database searches | |
US9684699B2 (en) | System to convert semantic layer metadata to support database conversion | |
US20060020619A1 (en) | Database generation systems and methods | |
US20120166620A1 (en) | System and method for integrated real time reporting and analytics across networked applications | |
US10592509B2 (en) | Declarative rules for optimized access to data | |
US20070214104A1 (en) | Method and system for locking execution plan during database migration | |
US11442934B2 (en) | Database calculation engine with dynamic top operator | |
US10885062B2 (en) | Providing database storage to facilitate the aging of database-accessible data | |
US20140244573A1 (en) | Data warehouse with cloud fact table | |
US11550790B2 (en) | Object relational mapper for non-relational databases | |
US20200250192A1 (en) | Processing queries associated with multiple file formats based on identified partition and data container objects | |
EP2939150A2 (en) | Systems and methods for multi-source data-warehousing | |
US9195736B2 (en) | System and method for content storage | |
US20190340272A1 (en) | Systems and related methods for updating attributes of nodes and links in a hierarchical data structure | |
US7440969B2 (en) | Data processing systems and methods for processing a plurality of application programs requiring an input database table having a predefined set of attributes | |
JP2017537398A (ja) | 一組の構造化データタームからの非構造化検索クエリの生成 | |
Sreemathy et al. | Data validation in ETL using TALEND | |
JP7373663B2 (ja) | 迅速なデータ探索のためのユニバーサルデータインデックス | |
Nielsen | Microsoft Sql Server 2000 Bible (W/Cd) | |
Chandramouli et al. | READY: Completeness is in the Eye of the Beholder |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP01 | Change in the name or title of a patent holder | ||
CP01 | Change in the name or title of a patent holder |
Address after: 200233 11-12 / F, building B, 88 Hongcao Road, Xuhui District, Shanghai Patentee after: Star link information technology (Shanghai) Co.,Ltd. Address before: 200233 11-12 / F, building B, 88 Hongcao Road, Xuhui District, Shanghai Patentee before: TRANSWARP TECHNOLOGY (SHANGHAI) Co.,Ltd. |
|
PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A Method and Equipment for Data Query Effective date of registration: 20230616 Granted publication date: 20200221 Pledgee: Bank of China Limited by Share Ltd. Shanghai Xuhui branch Pledgor: Star link information technology (Shanghai) Co.,Ltd. Registration number: Y2023310000252 |
|
PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
PC01 | Cancellation of the registration of the contract for pledge of patent right |
Granted publication date: 20200221 Pledgee: Bank of China Limited by Share Ltd. Shanghai Xuhui branch Pledgor: Star link information technology (Shanghai) Co.,Ltd. Registration number: Y2023310000252 |