CN110928857A - Data processing method of database and database - Google Patents
Data processing method of database and database Download PDFInfo
- Publication number
- CN110928857A CN110928857A CN201911056429.1A CN201911056429A CN110928857A CN 110928857 A CN110928857 A CN 110928857A CN 201911056429 A CN201911056429 A CN 201911056429A CN 110928857 A CN110928857 A CN 110928857A
- Authority
- CN
- China
- Prior art keywords
- data area
- data
- priority
- processing method
- access
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 26
- 230000005540 biological transmission Effects 0.000 claims description 5
- 238000012546 transfer Methods 0.000 claims description 2
- 238000004891 communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 238000000034 method Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 2
- HBBGRARXTFLTSG-UHFFFAOYSA-N Lithium ion Chemical compound [Li+] HBBGRARXTFLTSG-UHFFFAOYSA-N 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 229910001416 lithium ion Inorganic materials 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
Images
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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Abstract
The embodiment of the specification provides a data processing method of a database and the database, wherein the database comprises a priority access data area and a common access data area, and one of the data processing methods comprises the following steps: placing the data item with higher priority in a priority access data area; and transferring the data item of lower priority in the priority access data area to the normal access data area.
Description
Technical Field
The present disclosure relates to the field of database technologies, and in particular, to a database and a data processing method thereof.
Background
With the development of information technology, the amount of data stored in the database is increasing. When the amount of data is excessive, the speed of operating on the data becomes slower and slower. Even if the database is indexed in advance, the speed of inserting data items in the database can be slow.
Therefore, there is a need to provide a fast or reliable data processing scheme for databases.
Disclosure of Invention
The embodiment of the specification provides a new technical scheme for data processing of a database.
According to a first aspect of the present specification, there is provided a data processing method of a database, wherein the database includes a priority access data area and a general access data area, and the data processing method includes: placing the data item with higher priority in a priority access data area; and transferring the data item of lower priority in the priority access data area to the normal access data area.
According to a second aspect of the present description, there is provided an electronic device comprising a database, the database comprising a priority access data area and a general access data area, and the electronic device comprising a processor and a memory, the memory storing executable instructions that, when the database is executed, control the processor to perform the data processing method according to the various embodiments.
In various embodiments, the speed of data processing in the database may be increased to some extent.
Other features of embodiments of the present specification and advantages thereof will become apparent from the following detailed description of exemplary embodiments thereof, which proceeds with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments and together with the description, serve to explain the principles of the various embodiments.
Fig. 1 illustrates an exemplary network system.
FIG. 2 shows a block diagram of an exemplary database.
Fig. 3 shows a schematic flow chart of a data processing method of a database according to an embodiment.
FIG. 4 shows a schematic storage structure diagram of a database according to another embodiment.
Fig. 5 shows a schematic block diagram of an electronic device comprising a database according to yet another embodiment.
Detailed Description
In the following, different embodiments and examples of the present description are described with reference to the drawings.
Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
In the following, different embodiments and examples of the present description are described with reference to the drawings.
Fig. 1 illustrates an exemplary network system.
The network system shown in fig. 1 may include a network 110, user terminals 130, 142, 144. Electronic devices, e.g., servers 122, 124, etc., containing databases are disposed in network 110. The user terminals 130, 142, 144 are connected to the network 110 by wire or wirelessly.
For example, the user terminals 130, 142, 144 may access a database in the servers 122, 124 through a network. The user terminals 130, 142, 144 may retrieve data from the database or may store data to the database.
FIG. 2 illustrates a block diagram of an exemplary electronic device containing a database.
The electronic device 200 is, for example, a server as shown in fig. 1 and contains a database. The user may access a database in the electronic device 200 to retrieve data or store data to it.
As shown in fig. 2, the electronic device 200 includes a processor 202, a memory 204. The electronic device 200 may also include a display screen 210, a user interface 212, a camera 214, an audio/video interface 216, sensors 218, and a communications component 220, among other things. In addition, the electronic device 200 may further include a power management chip 206, a battery 208, and the like.
The processor 202 may be various processors. For example, it may be an ARM architecture processor, such as an apple applications processor, a high-traffic corporation processor, a Huanshi corporation processor, and so on.
Memory 204 may store the underlying software, system software, application software, data, etc. needed for computing device 200 to operate. The memory 204 may include various forms of memory, such as ROM, RAM, Flash, etc. The data items of the database may be stored in the memory 204.
The display screen 210 may be a liquid crystal display screen, an OLED display screen, or the like. In one example, the display screen 210 may be a touch screen. The administrator can perform input operations through the display screen 210. In addition, the administrator can perform fingerprint recognition and the like through a touch screen.
The user interface 212 may include a USB interface, a lightning interface, a keyboard, and the like.
The camera 214 may be a single camera or multiple cameras. In addition, camera 214 may be used for face recognition by an administrator.
The audio/video interface 216 may include, for example, a speaker interface, a microphone interface, a video transmission interface such as HDMI, and the like.
The sensors 218 may include, for example, gyroscopes, accelerometers, temperature sensors, humidity sensors, pressure sensors, and the like. For example, the environment around the computing device may be determined by sensors, and so on.
The communication component 220 may include, for example, a WiFi communication component, a bluetooth communication component, a 3G, 4G, and 5G communication component, and the like. Through the communication component 220, the computing device 200 can be arranged in a network.
The power management chip 206 may be used to manage the input computing device 200 power and may also manage the battery 208 to ensure greater utilization efficiency. The battery 208 is, for example, a lithium ion battery or the like.
The electronic device shown in fig. 2 is merely illustrative and is in no way intended to limit the present invention, its application, or uses.
Fig. 3 shows a schematic flow chart of a data processing method of a database according to an embodiment. The database includes a priority access data area and a general access data area.
As shown in fig. 3, in step S302, a data item of higher priority is placed in the priority access data area.
In step S304, the data items of lower priority in the priority access data area are transferred to the normal access data area.
Because two different access data areas are divided in the database, the data volume in each access data area is less than that of the whole database, and therefore, compared with the situation that the whole database is taken as a whole access data area, the access speed of the divided two access data areas is higher, and the data access speed is improved.
Further, the access speed of preferentially accessing the data items in the data area may be set to be greater than the access speed of commonly accessing the data items in the data area. For example, the priority access data area may have a smaller capacity than the normal access data area, or a faster storage device may be configured for the priority access data area, or an index may be established for the priority access data area so that the access speed of data items in the priority access data area is faster.
The priority may be set based on the importance of the data item. The priority may also be set based on the frequency of access to the data items. For example, the access frequency may include a frequency with which data items are selected and/or a frequency with which data items are updated.
For example, a data item that was first written to the database may be placed in the priority access data area. When the priority of data items in the general access data area rises, they can be shifted to the priority access data area.
Further, the first priority access data area and the second priority access data area may be set in the priority access data area. The priority of the data items in the first priority access data area is higher than the priority of the data items in the second priority access data area. And transferring the data items with lower priority in the first priority access data area to the second priority access data area. In this way, it is possible to more easily determine the data items of higher priority and the data items of lower priority in the priority access data area, thereby making preparations for transferring the data items to the normal access data area.
When the priority of the data items in the second priority access data area is raised, the data items may be transferred to the first priority access data area. When the priority of the data items in the first priority access data area is lowered, the data items may be transferred to the second priority access data area. Further, when a new data item is written to the first priority access data area, a data item of lower priority in the first priority access data area may be transferred to the second priority access data area.
For example, the second priority access data area includes a reception data area and a transmission data area. When the data item in the receiving data area is full, the data item in the current sending data area can be transferred to the common access data area; setting a current receiving data area as a sending data area; and setting the current transmission data area as a reception data area. In this way, since the priorities of different data items have been differentiated by dividing different areas, it is possible to save the checking process of the priorities of the data items at the time of transferring the data items, thereby improving the efficiency.
In addition, the priority of the data items in the sending data area can be increased to be transferred to the receiving data area or the first priority access data area; or the priority in the received data area may be raised until the data item is transferred to the first priority access data area.
FIG. 4 shows a schematic storage structure diagram of a database according to another embodiment.
As shown in fig. 4, the database includes a priority access data area 410 and a general access data area 420. The access speed of the data item in the priority access data area 410 is faster than that of the data item in the general access data area 420. The priority access data area 410 includes a first priority access data area 412 and a second priority access data area 414. The most frequently accessed data items may be placed in the first priority access data area 412. The data items of lower access frequency are stored in the second priority access data area 414. The transfer to the data item to the second priority access data area 414 may be determined by setting a threshold. For example, when the access frequency of a data item in the first priority access data area 412 is lower than a threshold value, the data item is transferred to the second priority access data area 414. It may also be determined that the frequency of access of data items in the first priority access data area 412 is below a threshold and transferred to the second priority access data area 414.
The second priority access data area 414 includes a reception data area 415 and a transmission data area 416. The data item is first stored in the received data area 415. When the current received data area 415 is full, the data items in the current transmitted data area 416 are transferred to the normal access data area, the current received data area 415 is set as the transmitted data area, and the current transmitted data area 415 is set as the received data area. In this way, data can be transferred to the general access data area in a simpler manner.
When the access frequency of data items in the general access data area increases, the data items can be shifted to the priority access data area.
Fig. 5 shows a schematic block diagram of an electronic device comprising a database according to yet another embodiment.
As shown in fig. 5, the electronic device 500 multiple databases include a priority access data area 506 and a general access data area 508. The electronic device 500 also includes a processor 504 and memory 502. The memory 502 stores executable instructions that, when executing the database, control the processor 504 to perform the data processing method according to various embodiments.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for system embodiments, since they are substantially similar to method embodiments, the description is relatively simple, and for related matters, reference may be made to some descriptions of method embodiments
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
Claims (12)
1. A data processing method of a database, wherein the database includes a priority access data area and a general access data area, and the data processing method includes:
placing the data item with higher priority in a priority access data area; and
and transferring the data items with lower priority in the priority access data area to the common access data area.
2. The data processing method of claim 1, wherein the priority is based on a frequency of access to data items.
3. The data processing method of claim 2, wherein the access frequency comprises at least one of a frequency with which data items are selected and a frequency with which data items are updated.
4. The data processing method of any of claims 1-3, further comprising:
and placing the data item which is written into the database for the first time into the priority access data area.
5. The data processing method of any of claims 1-3, further comprising:
and transferring the data items with the increased priority in the common access data area to the priority access data area.
6. The data processing method according to any one of claims 1 to 3, wherein the priority access data area includes a first priority access data area and a second priority access data area, and a priority of a data item in the first priority access data area is higher than a priority of a data item in the second priority access data area, and the data processing method further comprises:
and transferring the data items with lower priority in the first priority access data area to the second priority access data area.
7. The data processing method of claim 6, further comprising:
and transferring the data items with the increased priority in the second priority access data area to the first priority access data area.
8. The data processing method of claim 6, further comprising:
and transferring the data items with the lower priority in the first priority access data area to the common access data area.
9. The data processing method according to claim 6, wherein the second priority access data area includes a reception data area and a transmission data area, and when a data item in the reception data area is full, the data processing method further comprises:
transferring the data item in the current sending data area to the common access data area;
setting a current receiving data area as a sending data area; and
and setting the current sending data area as a receiving data area.
10. The data processing method of claim 6, further comprising:
increasing the priority of the data items in the sending data area to transfer the data items to the receiving data area or the first priority access data area; or
And transferring the data item with the priority raised in the received data area to the first priority access data area.
11. The data processing method according to claim 1, wherein an access speed of preferentially accessing the data items in the data area is higher than an access speed of the data items in the general access data area.
12. An electronic device comprising a database, the database comprising a priority access data area and a general access data area, and the electronic device comprising a processor and a memory, the memory storing executable instructions that, when the database is executed, control the processor to perform the data processing method according to any one of claims 1-11.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911056429.1A CN110928857A (en) | 2019-10-31 | 2019-10-31 | Data processing method of database and database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911056429.1A CN110928857A (en) | 2019-10-31 | 2019-10-31 | Data processing method of database and database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110928857A true CN110928857A (en) | 2020-03-27 |
Family
ID=69850128
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911056429.1A Pending CN110928857A (en) | 2019-10-31 | 2019-10-31 | Data processing method of database and database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110928857A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222107A (en) * | 2011-06-28 | 2011-10-19 | 中国联合网络通信集团有限公司 | Data access system and method |
| CN103412884A (en) * | 2013-07-18 | 2013-11-27 | 华中科技大学 | Method for managing embedded database in isomerism storage media |
| US9258579B1 (en) * | 2011-06-30 | 2016-02-09 | Sprint Communications Company L.P. | Temporal shift of object resolution and optimization |
-
2019
- 2019-10-31 CN CN201911056429.1A patent/CN110928857A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222107A (en) * | 2011-06-28 | 2011-10-19 | 中国联合网络通信集团有限公司 | Data access system and method |
| US9258579B1 (en) * | 2011-06-30 | 2016-02-09 | Sprint Communications Company L.P. | Temporal shift of object resolution and optimization |
| CN103412884A (en) * | 2013-07-18 | 2013-11-27 | 华中科技大学 | Method for managing embedded database in isomerism storage media |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102148948B1 (en) | Multi tasking method of electronic apparatus and electronic apparatus thereof | |
| US10631361B2 (en) | Method and apparatus for providing user with information received by electronic device | |
| EP4145286A1 (en) | Memory management method and electronic device | |
| EP3531290B1 (en) | Data backup method, apparatus, electronic device, storage medium, and system | |
| EP3160150A1 (en) | Electronic device and method for executing function using speech recognition thereof | |
| CN109074286B (en) | Control of applications using system resources | |
| US10402222B2 (en) | Task migration method and apparatus | |
| EP3333733A1 (en) | Method and device for use in parallel execution of terminal database | |
| CN104423804A (en) | Method and electronic device for displaying content | |
| EP3026782A1 (en) | Method for charging control and an electronic device thereof | |
| US20150113544A1 (en) | Method for controlling process of application and computer system | |
| KR20150066876A (en) | Method for controlling an user interface and an electronic device | |
| EP3525101A1 (en) | Data backup method, apparatus, storage medium, and terminal | |
| KR102137686B1 (en) | Method for controlling an content integrity and an electronic device | |
| EP3506599B1 (en) | Method for synchronizing contact information, apparatus and medium | |
| CN110881224B (en) | Network long connection method, device, equipment and storage medium | |
| EP3843356A1 (en) | Management method for model files and terminal device | |
| US10042856B2 (en) | Method and electronic device for processing data | |
| CN111008054A (en) | Page display method and equipment and electronic equipment | |
| US10643252B2 (en) | Banner display method of electronic device and electronic device thereof | |
| CN105830421B (en) | Electronic device and operation method thereof | |
| CN110928857A (en) | Data processing method of database and database | |
| CN113518431B (en) | Communication processing method, terminal, device and storage medium | |
| KR20230118391A (en) | Electronic apparatus and operating method thereof | |
| CN113010279A (en) | Application program process processing method and device for mobile terminal and electronic equipment |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200327 |