Mixed service concurrent access method and device

A mixed business and transaction technology, applied in the database application field, can solve problems such as isolation performance and overhead, and achieve the effects of avoiding overuse, reducing overhead, and improving timeliness

Active Publication Date: 2014-09-03
HUAWEI CLOUD COMPUTING TECH CO LTD
View PDF5 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a method and device for concurrent access to mixed services, which realizes concurrent read and write access to mixed services of the database, allows lock-free concurrency of query and modification operations, and solves the problem of using the lock mechanism and the main / subprocess The problem of performance overhead caused by the isolation of data read and write processes

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
  • Mixed service concurrent access method and device
  • Mixed service concurrent access method and device
  • Mixed service concurrent access method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0072] Embodiments of the present invention provide a method for concurrent access of mixed services, refer to figure 2 As shown, the method includes the following steps:

[0073] 101. The apparatus for concurrent access of mixed services divides a data table into at least one data group.

[0074] Wherein, each data group includes at least one column in the data table, and the columns in the data group are continuous.

[0075] Specifically, data in an analytical database is generally organized in columns, and each field of the same record is identified by a column offset (that is, a logical row ID RowID). Since most of the data query and modification operations only involve specific columns in the record, the data table is divided vertically to obtain data groups, which is convenient for querying or modifying the data in the database.

[0076] 102. The apparatus for concurrent access of mixed services decomposes the modification or query operation on the data table into at ...

Embodiment 2

[0085] Embodiments of the present invention provide a method for concurrent access of mixed services, refer to image 3 As shown, the method includes the following steps:

[0086] 201. The device for concurrent access of mixed services defines the attributes of the data table.

[0087] Wherein, the attributes of the data table include: the type of data stored in the data table, the length of the data table, and the association relationship between the fields of the data table.

[0088] Specifically, the attributes of the data table can be realized by the device for concurrent access of the mixed business by using the database language and editing the program.

[0089]202. The device for concurrent access of mixed services applies for memory space to establish a data table and a data copy area according to the attributes of the data table.

[0090] Among them, the actual data can be stored in the data table, and the ID value corresponding to the specific location where the id...

Embodiment 3

[0105] Embodiments of the present invention provide a method for concurrent access of mixed services, refer to Figure 5 As shown, the method includes the following steps:

[0106] 301. The device for concurrent access of mixed services defines attributes of a data table.

[0107] Wherein, the attributes of the data table include: the type of data stored in the data table, the length of the data table, and the association relationship between the fields of the data table.

[0108] Specifically, the attributes of the data table can be realized by the device for concurrent access of the mixed business by using the database language and editing the program.

[0109] 302. The device for concurrent access of mixed services applies for memory space to establish a data table and a data copy area according to the attributes of the data table.

[0110] Among them, the actual data can be stored in the data table, and the ID value corresponding to the specific location where the identi...

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 embodiment of the invention provides a mixed service concurrent access method and device, and relates to the field of application of databases. Database service read-write concurrent access is achieved, lock-free concurrency of inquiry and modification operations is supported, operation complexity, cost and memory waste are reduced, and data timeliness is improved. The method includes the steps that a data table is divided to obtain at least one data set; the modification or inquiry operation for the data table is decomposed into at least one point operation; whether point operation processing data to be processed are distributed on multiple rows or not is judged; if the data to be processed are distributed on the multiple rows, whether the data to be processed are in the same data set or not is judged, and the modification or inquiry operation is conducted on the data to be processed according to the judgment result. The method and device are applied to read-write concurrent access of the data table.

Description

technical field [0001] The invention relates to the technical field of database application, in particular to a method and device for concurrent access of mixed services. Background technique [0002] For traditional database applications, frequent updates of data are mainly processed through On-Line Transaction Processing (OLTP) in business scenarios, and the extraction-transformation-loading (Extraction-Transformation-Loading, ELT) operation will The data is imported into the data warehouse, and On-Line Analytical Processing (OLAP for short) is implemented in the data warehouse to support complex structured query language (Structured Query Language, SQL for short) query and generate reports. Since the concurrent read and write operations at the bottom of the database need to be protected by a complex lock mechanism, frequent updates of data will cause interruption of OLAP queries and reduce query efficiency. Therefore, in order to improve query efficiency, OLTP and OLAP s...

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/2308G06F16/25G06F16/278G06F16/2453G06F16/2365G06F16/23G06F16/283G06F16/2455
Inventor 欧伟杰陈志标
Owner HUAWEI CLOUD COMPUTING TECH 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