Stratified sampling method and device and computer equipment

A computer equipment and stratified sampling technology, applied in the field of data processing, can solve problems such as low efficiency, high resource occupation, time-consuming and labor-intensive problems

Active Publication Date: 2018-08-28
TENCENT TECH (SHENZHEN) CO LTD
View PDF8 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the user access records of each layer are stored in the same table and the amount of data in the table is relatively large, the efficiency of stratified sampling using the indirect method is low, it takes up more resources, and it is more time-consuming and labor-intensive.

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
  • Stratified sampling method and device and computer equipment
  • Stratified sampling method and device and computer equipment
  • Stratified sampling method and device and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0030] figure 1 A flowchart of an embodiment of the stratified sampling method for the present application, such as figure 1 As shown, the above stratified sampling method may include:

[0031] Step 101, storing the data to be sampled in the database into a data table.

[0032] see figure 2 , figure 2 It is a schematic diagram of an embodiment of setting up a data table in the str...

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 provides a stratified sampling method and device and computer equipment. The stratified sampling method includes: storing to-be-sampled data in a database into a data table; acquiring to-be-sampled layers, partitioning the data table according to the to-be-sampled layers, and sorting data in each partition corresponding to each to-be-sampled layer; acquiring the sampling proportion corresponding to each to-be-sampled layer, and sampling the sorted data according to the sampling proportion. The stratified sampling method has the advantages that direct stratified sampling can be achieved on the basis of SQL, additional data process scripts for reading and processing the data do not need to be compiled, the data sources are stored in the same table, and data redundancy caused byindependent table building for each layer of data; in addition, independent sampling is performed on the partition corresponding to each to-be-sampled layer, and high resource occupation caused by one-step whole-table scanning can be avoided.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a stratified sampling method, device and computer equipment. Background technique [0002] Sampling, also known as sampling, refers to a common statistical method for estimating and inferring all samples by taking a part of the samples from all the samples to be studied. The basic requirement of sampling is to ensure that the sample drawn is sufficiently representative of the population. Commonly used sampling methods include simple random sampling, systematic sampling, stratified sampling, and cluster sampling. [0003] Among them, stratified sampling refers to a method of randomly selecting samples from different layers according to a specified ratio from a population that can be divided into different layers. It is also called type sampling. representative. [0004] Structured Query Language (Structured Query Language; hereinafter referred to as: SQL) is an...

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
CPCG06F16/2282G06F16/2458
Inventor 苏聿王常伦石杨王万
Owner TENCENT TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap