Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for improving database performance in big-data environment

A database and big data technology, applied in the field of database management, can solve the problems of user impact, database performance degradation, slow query operation, etc., and achieve the effect of improving performance, reducing data processing delay, and improving insertion

Active Publication Date: 2014-11-19
UESTC COMSYS INFORMATION
View PDF4 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When there are frequent insert and update operations, database performance will drop significantly
The query operation will become slower and slower due to the increase of data or records, which will affect the user experience.

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 system for improving database performance in big-data environment
  • Method and system for improving database performance in big-data environment
  • Method and system for improving database performance in big-data environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0082] The present invention will be further elaborated below in conjunction with the accompanying drawings and specific embodiments.

[0083] A system for improving database performance in a big data environment, including: a database system, an insertion system, a deletion system, an update system, a query system, and a merge system, and the database system is used for processing primary tables, secondary tables, primary caches, and secondary caches The insertion system is used to insert data into the database; the deletion system is used to delete data records; the update system is used to update data records; the query system is used to query data in the database; to merge master-slave tables in the database.

[0084] A method for improving database performance in a big data environment includes the following steps:

[0085] S1. Define the database structure;

[0086] S2. Insert data into the database;

[0087] S3. Delete database data records;

[0088] S4. Update data...

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 system for improving database performance in a big-data environment. The system comprises a database system, an insertion system, a deletion system, an update system, a search system and a merging system. The method includes the steps of defining a database structure, inserting data into a database, deleting data recordings in the database, updating data of the database, and merging master and slave tables of the database; the step of inserting the data into the database includes sub-steps of after arrival of the inserted data, writing the data into a cache and setting corresponding field contents, setting a schedule level being adjustable, inserting the data into the slave table according to a cache strategy, updating the dependent cache after setting the corresponding field contents, and setting a schedule flag bit. The method and the system have the advantages that the original database is improved, cache and incremental data are processed respectively, the data can be inserted and searched more efficiently in the big-data environment, data processing delay is reduced, and database performance is improved.

Description

technical field [0001] The invention belongs to the technical field of database management, and in particular relates to a method and system for improving database performance in a big data environment. Background technique [0002] The database is a warehouse that organizes, stores and manages data according to the data structure. In simple terms, it can be regarded as an electronic file cabinet—a place where electronic files are stored. Users can add, intercept, and update data in files. , delete and other operations. A database refers to a collection of data that is stored together in a certain way, can be shared by multiple users, has as little redundancy as possible, and is independent of the application. The main features of the database are: (1) realize data sharing, data sharing includes all users can access the data in the database at the same time, also includes users can use the database in various ways through the interface, and provide data sharing; (2) reduce ...

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/22G06F16/23G06F16/24552
Inventor 唐雪飞边汤贵廖明焱倪季敏马晨曦
Owner UESTC COMSYS INFORMATION
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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