Supercharge Your Innovation With Domain-Expert AI Agents!

Method and device for associative table query of MONGODB shards

A query method and query condition technology, applied in the field of database cluster, can solve the problems of difficult MONGODB server join table group query, etc., to achieve the effect of improving speed, reducing workload, and improving work efficiency

Inactive Publication Date: 2012-07-25
BEIJING IZP NETWORK TECH CO LTD
View PDF2 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the inventors of the present invention have found through research that although the current MapReduce can implement data aggregation (ie, GROUP BY) between multiple MONGODB servers, it is difficult to perform joint table grouping queries between multiple MONGODB servers

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for associative table query of MONGODB shards
  • Method and device for associative table query of MONGODB shards
  • Method and device for associative table query of MONGODB shards

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0041] This embodiment provides a method for querying MONGODB sharding and joining tables in a database cluster environment configured with sharding (SHARDING).

[0042] For ease of description, an advertisement data table for storing advertisement information and a group mapping table for storing correspondence between advertisement information and advertisement information groups are set in the database cluster of this embodiment. The records of the advertisement data table include adid field, date field and so on. Among them, the adid field is used to identify the advertisement delivery created by the user, and a record in the advertisement data table includes the adid field, advertisement schedule, delivery status (start, delete, suspend), advertisement positioning (which regions to serve, which user groups , which industries) etc. In the advertising data table, adid is not required to uniquely identify a record, and multiple records can have the same adid. figure 1 Some...

no. 2 example

[0073] This embodiment provides a MONGODB shard join table query device. Figure 5 A schematic diagram of the structure of the device is shown.

[0074] The device for querying MONGODB fragmented joint tables according to this embodiment includes a determination unit 51 , a query unit 52 and a temporary table management unit 53 . Wherein, the determining unit performs operations corresponding to step S210 in the first implementation, and the query unit performs operations corresponding to steps S220, S230 and S250 in the first implementation. The descriptions about steps S210 to S250 in the first embodiment are all applicable to this embodiment, and will not be repeated here.

[0075] In addition, when the query condition is determined based on the user request received from the client via the network, the device for querying the MONGODB fragmented joint table according to this embodiment further includes a communication unit 54 . The communication unit 54 determines the que...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and a device for associative table query of MONGODB shards. The method includes: determining query conditions which are used for querying grouping summary information, corresponding to assigned grouping, in assigned data tables of all MONGDB shards; determining data recording marks of an optional grouping belongs to the assigned grouping in the assigned data tables and using the data recording marks as target data recording marks; obtaining data information of the data recording marks, belonging to one of the target data recording marks, in the assigned data tables of each MONGODB fragment; storing the obtained data information in a temporary data table; implementing grouping summary to the obtained data information based on the temporary data table to obtain the grouping summary information. The method and the device for associative table query of the MONGODB shards are capable of realizing high-efficient associative table grouping query of a plurality of MONGODB servers.

Description

technical field [0001] The invention relates to a database cluster technology based on distributed file storage, in particular to a method for querying MONGODB sliced ​​joint tables. Background technique [0002] Database cluster technology is a technology that combines multiple servers to form a cluster to achieve better overall performance than a single large server. [0003] MONGODB is a database based on distributed file storage, written in C++ language, designed to provide scalable high-performance data storage solutions for WEB applications. [0004] MAPREDUCE is a programming model for parallel operations on large-scale datasets (greater than 1TB). The concepts "Map" and "Reduce", and their main ideas, are borrowed from functional programming languages, with features borrowed from vector programming languages. It greatly facilitates programmers to run their programs on distributed systems without distributed parallel programming. The current software implementation...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 刘涛罗峰黄苏支李娜
Owner BEIJING IZP NETWORK TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com