Postgresql big data efficient maintenance-free automatic partition method
An automatic partitioning and maintenance-free technology, applied in database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve problems such as data overflow, low DML efficiency, and increased code maintenance difficulty, so as to save storage costs, Concise logic and the effect of solving code efficiency problems
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
example 1
[0034] Example 1: Efficient and maintenance-free automatic partitioning method for PostgreSQL big data, see figure 1 , figure 2 shown, including the following steps:
[0035] (1) Create an entry table, and the application program of the business side parallel data DML only interacts with the entry table.
[0036] (2) According to the characteristics of the partition value, abstractly convert the value into a cyclic value over time, such as a time field, which can be evolved into a cyclic value over time: cycle by month (1-12), cycle by week (1 -53), cycle by day (1-366), cycle by hour (1-24), cycle by minute (1-60), cycle by second (1-60), cycle by half hour (0100-2400), etc. , which provides a basis for solving partition logic code maintenance.
[0037] (3) Create a fixed partition logic according to the canned cycle value, and the partition logic code of the partition logic is distributed to the corresponding inheritance table according to the field value. For example, ...
example 2
[0047] Example 2: PostgreSQL big data efficient and maintenance-free automatic partition method, see figure 1 , figure 2 shown, including the following steps:
[0048] 1. Entrance table and partition logic implementation for business interaction.
[0049] 1-1. Create an entry table tbl, and specify a partition field such as ctime. It is required to distinguish which inheritance table the row is inserted into from the content of the field, for example, the type is timestamp. The application only interacts with the entry table.
[0050] 1-2. Create the inheritance table of the entry table, for example, create 24 inheritance tables by hour, tbl_01 to tbl_24, add necessary constraints to the ctime of each inheritance table, for example, tbl_01 constraint checkto_char(ctime,'hh24')=01 .
[0051] 1-3. Create an insert trigger function, and insert the corresponding inheritance table according to the value of the ctime function field. For example, 2014-01-0112:01:01 is inserted ...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
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