CN102982186B - Based on maintaining method and the system of the range partition table of oracle database system - Google Patents
Based on maintaining method and the system of the range partition table of oracle database system Download PDFInfo
- Publication number
- CN102982186B CN102982186B CN201210573616.9A CN201210573616A CN102982186B CN 102982186 B CN102982186 B CN 102982186B CN 201210573616 A CN201210573616 A CN 201210573616A CN 102982186 B CN102982186 B CN 102982186B
- Authority
- CN
- China
- Prior art keywords
- subregion
- metadata
- partition
- range
- range partition
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of maintaining method and system of the range partition table based on oracle database system, wherein maintaining method comprises maintenance process at least one times, and maintenance process comprises: obtain the range partition table of a needs maintenance and the metadata of correspondence thereof; The metadata of the range partition table safeguarded as required and current date, obtain partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to current date; If the subregion in last cycle exists, delete the subregion in last cycle; If the subregion in next cycle does not exist, increase the subregion in next cycle; Range partition table index is re-established according to the deletion of subregion and/or increase; More new metadata, and the metadata of renewal is stored; The statistical information of the next cycle subregion increased is stored in partition table statistical information; Does the range partition table that can realize oracle database replace oracle by automatically safeguarding by method and system of the present invention? the manual maintenance of DBA.
Description
Technical field
The present invention relates to maintaining method and the system of partition table, especially, relate to a kind of maintaining method and system of the range partition table based on oracle database system.
Background technology
Subregion (partitioning) is an assembly of oracle database, and data partition technology is introduced the earliest in Oracle8.0, and subregion is that a table or index are physically decomposed into multiple less, more manageable part.With regard to the application of accessing database, one is only had to show or an index logically, but this table or index may be made up of dozens of Physical Extents physically, each subregion is an independently object, can process alone, also can process as a part for a more large objects.
At present, oracle relational database management system (RDBMS) develops into 11GR2, and the mode of subregion has the compound subregion of range partition (range subregion), list partition (list subregion), Hash subregion (hash subregion) and above-mentioned three kinds of partition conbinations.Wherein, range subregion is the partitioned mode that oracle releases the earliest, in the mass data oracle database system (as data mining, data warehouse etc.) of decision support type, uses range partitioning technique in a large number.To be exactly the subregion key of partition table be for the most distinguishing feature of range subregion according to time sequencing or the numerical order standard as subregion, and data by date time shaft or numerical order increase progressively.Such tables of data in a database occupancy is huge, for oracle database keeper (DBA), safeguards that the workload of Range partition table is very large.
When range partitioning technique is applied to the association area of mass data, due to the One's name is legion of partition table, (tens open at least, up to a hundred at most), safeguard that the workload of these range partition tables is very large, each ins and outs error likely cause the hydraulic performance decline of whole oracle database system, even cause some business seriously to overstock and cannot normal process.Wherein, the maintenance content of Range partition table comprises: the maintenance of number of partitions in single range partition table, the newly-increased and deletion of such as subregion; The cleaning of stale data in single range partition table, such as clear up subregion according to different storage policies, wherein storage policy can set according to the traffic performance of partition table and demand data, such as partition table daily carrys out subregion, its storage policy can be set as the data in reservation 20 days, such as partition table monthly subregion, can be set as the data of reservation within 6 months by its storage policy; The reconstruction of actual effect index in single range partition table; The renewal of single range partition table statistical information, wherein statistical information is mainly shown in descriptive data base, the size of index, scale, one category information of Data distribution8 situation etc., such as, the line number of table, block number, average size of often going, the leafblocks of index, the line number of index field, the size of different value, all belongs to statistical information.
This external oracle11GR2 is also proposed Interval subregion, namely range subregion adds new subregion automatically according to partitioning key values, but Interval partitioning technique can only be accomplished temporally or scope newly-increased range partition table automatically, the data can not accomplishing in partition table are automatically deleted and index is safeguarded automatically, the real-time update etc. of statistical information, and these all also need oracleDBA to carry out manual maintenance.
In a word, the technical matters needing those skilled in the art urgently to solve is exactly: how to realize by the range partition table automatically safeguarded in oracle database to replace the range partition table in oracleDBA manual maintenance oracle database, thus reach the automatic O&M of range partition table.
Summary of the invention
In order to solve the problem, the invention provides the maintaining method based on the range partition table of oracle database system and system, can realize by the range partition table automatically safeguarded in oracle database to replace the range partition table in oracleDBA manual maintenance oracle database, thus effectively solve that DBA in prior art is complicated, uninteresting manual maintenance and easily because maloperation to bring the problem of performance hidden danger to oracle database.
One aspect of the present invention provides a kind of maintaining method of the range partition table based on oracle database system, and it comprises maintenance process at least one times, and described maintenance process comprises:
Obtain the metadata that needs range partition table and the correspondence thereof safeguarded;
According to the described metadata and the current date that need the range partition table safeguarded, obtain partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to described current date;
If the subregion in last cycle exists, then delete the subregion in last cycle;
If the subregion in next cycle does not exist, then increase the subregion in next cycle;
Range partition table index is re-established according to the deletion of subregion and/or increase;
More new metadata, and the metadata after upgrading is stored;
The statistical information of the next cycle subregion increased is stored in the statistical information of described range partition table.
Wherein, obtain the step that needs the metadata of range partition table and the correspondence thereof safeguarded, obtain specifically by current date and table storage policy the metadata needing range partition table and the correspondence thereof safeguarded.
Preferably, before carrying out maintenance process, also comprise the metadata table of the metadata created for storing all range partition tables.
Wherein, described metadata comprises table essential information, table partition information, table storage policy and table data report date.Concrete, described table essential information comprises table name, table owner; Described table partition information comprises subregion key, subregion sequence number and current data point zones values; Described table storage policy comprises current table space size, deposits vertex type, retains numerical value; The described table data report date comprises date, the Data Update date of data report daily record.
Preferably, described maintenance process triggers by scheduling tool or passes through task timer clocked flip.
The invention also proposes a kind of maintenance system of the range partition table based on oracle database system, comprising:
Partition table acquiring unit, for obtaining the metadata that needs range partition table and the correspondence thereof safeguarded;
Partition information acquiring unit, for according to the described metadata and the current date that need the range partition table safeguarded, obtain partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to described current date;
Subregion delete cells, for when the subregion in last cycle exists, deletes the subregion in last cycle;
Subregion increases unit, for when the subregion in next cycle does not exist, increases the subregion in next cycle;
Index reconstruction unit, for re-establishing range partition table index according to the deletion of subregion and/or increase;
Metadata updates unit, for more new metadata, and stores the metadata after upgrading;
Statistical information updating block, for being stored into the statistical information of the next cycle subregion increased in the statistical information of described range partition table.
Preferably, described system also comprises metadata table creating unit, for creating the metadata table of the metadata storing all partition tables.
Preferably, described metadata comprises table essential information, table partition information, table storage policy and table data report date.Concrete, described table essential information comprises table name, table owner; Described table partition information comprises subregion key, subregion sequence number and current data point zones values; Described table storage policy comprises current table space size, deposits vertex type, retains numerical value; The described table data report date comprises date, the Data Update date of data report daily record.
Wherein, partition table acquiring unit, obtains specifically by current date and table storage policy the metadata needing range partition table and the correspondence thereof safeguarded.
Preferably, described system also comprises scheduling tool or task timer, for triggering described maintenance system.
By maintaining method and the system of the range partition table based on oracle database system provided by the invention, can realize by the range partition table automatically safeguarded in oracle database to replace the range partition table in oracleDBA manual maintenance oracle database, thus effectively solve that oracleDBA in prior art is complicated, uninteresting manual maintenance and easily because maloperation to bring the problem of performance hidden danger to oracle database.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the maintaining method embodiment of the range partition table that the present invention is based on oracle database system;
Fig. 2 is the schematic diagram of the maintenance system embodiment of the range partition table that the present invention is based on oracle database system.
Embodiment
For enabling above-mentioned purpose of the present invention, feature and advantage become apparent more, and below in conjunction with the drawings and specific embodiments, the present invention is further detailed explanation.
With reference to Fig. 1, show the process flow diagram of the maintaining method embodiment of a kind of range partition table based on oracle database system of the present invention, it comprises maintenance process at least one times, described maintenance process is the storing process of an oracle, triggers or pass through task timer clocked flip by scheduling tool.Preferably, a step judging whether to be applicable to using maintaining method of the present invention can also be comprised, use if be not suitable for, then adopt the manual mode safeguarded of DBA to safeguard; Use if be applicable to, then adopt maintenance process provided by the invention.
Described maintenance process comprises: S1, obtain the metadata that needs range partition table and the correspondence thereof safeguarded, as the foundation of subsequent step, the metadata needing range partition table and the correspondence thereof safeguarded is obtained specifically by current date and table storage policy, wherein, table storage policy can as follows but be not limited to as under type formulate, such as, partition table daily carrys out subregion, and service needed retains the data in 20 days; Partition table monthly divides, and service needed retains the data etc. within 6 months; S2, according to the described metadata and the current date that need the range partition table safeguarded, obtains partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to described current date; S3, judges whether the subregion in last cycle exists, if the subregion in last cycle does not exist, then without the need to any operation, if the subregion in last cycle exists, is then deleted the subregion in last cycle by sql statement, to carry out the cleaning of data in subregion; S4, judges whether the subregion in next cycle exists, if the subregion in next cycle does not exist, is then increased the subregion in next cycle by sql statement, if the subregion in next cycle exists, then without the need to any operation; S5, according to deletion and/or the increase of subregion, sets up index maintenance sql script, for circulation is used to re-establish partition table index, delete with the subregion solving partition table and/or increase the variation issue of rear partition table index, certainly, except the table index of Local partition; S6, more new metadata, and the metadata of renewal is stored, such as the data report date at every turn upgraded, Data Update time, partition information etc. are updated in metadata table, so that next time safeguards; S7, the statistical information of the next cycle subregion increased is carried out collecting, adding up, and generate corresponding sql script, by performing sql script, the statistical information in the next cycle increased is stored in the statistical information of described partition table, to solve the problem of the statistical information in next cycle not newly-increased in the statistical information of partition table, thus complete the maintenance of range partition table.
Above-mentioned maintenance process can be carried out repeatedly, such as, undertaken by for circulation, until safeguarded all range partition tables needing to safeguard of database.
Preferably, before carrying out above-mentioned maintenance process, also comprise the step of the metadata table of the metadata created for storing all range partition tables, the metadata of range partition tables all in database can be initialised in metadata table by sql statement, so that carry out unified management to the metadata of range partition tables all in database.Wherein, metadata comprises the information such as table essential information, table partition information, table storage policy and table data report date, and in more detail, described table essential information comprises the information such as table name, table owner; Described table partition information comprises the information such as subregion key, subregion sequence number and current data point zones values; Described table storage policy comprises current table space size, deposits vertex type, retains the information such as numerical value; The described table data report date comprises the information such as date, Data Update date of data report daily record.
By the maintaining method of the range partition table based on oracle database system provided by the invention, can realize by the range partition table automatically safeguarded in oracle database to replace the range partition table in oracleDBA manual maintenance oracle database, thus effectively solve that oracleDBA in prior art is complicated, uninteresting manual maintenance and easily because maloperation to bring the problem of performance hidden danger to oracle database.
Meanwhile, the maintenance system that the maintaining method also proposing to show a kind of and above-mentioned partitions of database is corresponding, described system comprises scheduling tool or task timer, for triggering described maintenance system.It is the schematic diagram of the maintenance system embodiment of the range partition table that the present invention is based on oracle database system referring to Fig. 2, comprise: partition table acquiring unit 21, for obtaining the metadata needing range partition table and the correspondence thereof safeguarded, as the foundation of subsequent step, the metadata needing range partition table and the correspondence thereof safeguarded is obtained specifically by current date and table storage policy, wherein, table storage policy can as follows but be not limited to as under type formulate, such as, if partition table daily carrys out subregion, service needed retains the data in 20 days, partition table monthly divides, service needed retains the data etc. within 6 months, partition information acquiring unit 22, for according to the described metadata and the current date that need the range partition table safeguarded, obtain partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to described current date, subregion delete cells 23, for when the subregion in last cycle exists, deletes the subregion in last cycle, to carry out the cleaning of data in subregion, if the subregion in last cycle does not exist, then without the need to any operation by sql statement, subregion increases unit 24, for when the subregion in next cycle does not exist, is increased the subregion in next cycle by sql statement, if the subregion in next cycle exists, then without the need to any operation, index reconstruction unit 25, for re-establishing partition table index according to the deletion of subregion and/or increase, to solve the deletion of subregion and/or increase and the problem of the partition table index change caused, according to deletion and/or the increase of subregion, set up index maintenance sql script, use for circulation to re-establish partition table index, delete with the subregion solving range partition table and/or increase the variation issue of rear partition table index, certainly, for except the table index of Local partition, metadata updates unit 26, for more new metadata, and stores the metadata of renewal, such as, is updated in metadata table by the data report date upgraded, Data Update time, partition information etc. at every turn, so that next time safeguards, statistical information updating block 27, for the statistical information of the next cycle subregion increased is carried out collecting, adding up, and generate corresponding sql script, by performing sql script, the statistical information in the next cycle increased is stored in the statistical information of described range partition table, to solve the problem of the statistical information in next cycle not newly-increased in the statistical information of range partition table, thus complete the maintenance of range partition table.
Preferably, described system also comprises metadata table creating unit 20, for creating the metadata table of the metadata storing all range partition tables, realizes the unified management to all metadata by metadata table.Wherein, metadata comprises the information such as table essential information, table partition information, table storage policy and table data report date, and in more detail, described table essential information comprises the information such as table name, table owner; Described table partition information comprises the information such as subregion key, subregion sequence number and current data point zones values; Described table storage policy comprises current table space size, deposits vertex type, retains the information such as numerical value; The described table data report date comprises the information such as date, Data Update date of data report daily record.
By the maintenance system of the range partition table based on oracle database system provided by the invention, can realize by the range partition table automatically safeguarded in oracle database to replace the range partition table in oracleDBA manual maintenance oracle database, thus effectively solve that oracleDBA in prior art is complicated, uninteresting manual maintenance and easily because maloperation to bring the problem of performance hidden danger to oracle database.
Each embodiment in this instructions all adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar part mutually see.For system embodiment, due to itself and embodiment of the method basic simlarity, so description is fairly simple, relevant part illustrates see the part of embodiment of the method.
Above the maintaining method of a kind of partitions of database provided by the present invention table and system are described in detail, apply specific case herein to set forth principle of the present invention and embodiment, the explanation of above embodiment just understands method of the present invention and core concept thereof for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (8)
1. based on a maintaining method for the range partition table of oracle database system, it is characterized in that, comprise maintenance process at least one times, described maintenance process comprises:
Create the metadata table of the metadata for storing all range partition tables, be specially and the metadata of range partition tables all in database is initialised in metadata table by sql statement, wherein, metadata comprises table essential information, table partition information, table storage policy and table data report date;
Obtain the metadata that needs range partition table and the correspondence thereof safeguarded;
According to the described metadata and the current date that need the range partition table safeguarded, obtain partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to described current date;
If the subregion in last cycle exists, then delete the subregion in last cycle;
If the subregion in next cycle does not exist, then increase the subregion in next cycle;
Range partition table index is re-established according to the deletion of subregion and/or increase;
More new metadata, and the metadata after upgrading is stored;
The statistical information of the next cycle subregion increased is stored in the statistical information of described range partition table.
2. the method for claim 1, it is characterized in that, obtain the step that needs the metadata of range partition table and the correspondence thereof safeguarded, obtain specifically by current date and table storage policy the metadata needing range partition table and the correspondence thereof safeguarded.
3. the method for claim 1, is characterized in that, described maintenance process triggers by scheduling tool or passes through task timer clocked flip.
4. the method for claim 1, is characterized in that, described table essential information comprises table name, table owner; Described table partition information comprises subregion key, subregion sequence number and current data point zones values; Described table storage policy comprises current table space size, deposits vertex type, retains numerical value; The described table data report date comprises date, the Data Update date of data report daily record.
5., based on a maintenance system for the range partition table of oracle database system, it is characterized in that, comprising:
Metadata table creating unit, for creating the metadata table of the metadata for storing all range partition tables, be specially and the metadata of range partition tables all in database is initialised in metadata table by sql statement, wherein, metadata comprises table essential information, table partition information, table storage policy and table data report date;
Partition table acquiring unit, for obtaining the metadata that needs range partition table and the correspondence thereof safeguarded;
Partition information acquiring unit, for according to the described metadata and the current date that need the range partition table safeguarded, obtain partition name and the partition name in next cycle, table space value, the subregion key divide value in the last cycle of subregion corresponding to described current date;
Subregion delete cells, for when the subregion in last cycle exists, deletes the subregion in last cycle;
Subregion increases unit, for when the subregion in next cycle does not exist, increases the subregion in next cycle;
Index reconstruction unit, for re-establishing range partition table index according to the deletion of subregion and/or increase;
Metadata updates unit, for more new metadata, and stores the metadata after upgrading;
Statistical information updating block, for being stored into the statistical information of the next cycle subregion increased in the statistical information of described range partition table.
6. system as claimed in claim 5, is characterized in that, partition table acquiring unit, obtains specifically by current date and table storage policy the metadata needing range partition table and the correspondence thereof safeguarded.
7. system as claimed in claim 5, it is characterized in that, described system also comprises scheduling tool or task timer, for triggering described maintenance system.
8. system as claimed in claim 5, is characterized in that, described table essential information comprises table name, table owner; Described table partition information comprises subregion key, subregion sequence number and current data point zones values; Described table storage policy comprises current table space size, deposits vertex type, retains numerical value; The described table data report date comprises date, the Data Update date of data report daily record.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210573616.9A CN102982186B (en) | 2012-12-26 | 2012-12-26 | Based on maintaining method and the system of the range partition table of oracle database system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210573616.9A CN102982186B (en) | 2012-12-26 | 2012-12-26 | Based on maintaining method and the system of the range partition table of oracle database system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102982186A CN102982186A (en) | 2013-03-20 |
| CN102982186B true CN102982186B (en) | 2016-01-20 |
Family
ID=47856202
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210573616.9A Active CN102982186B (en) | 2012-12-26 | 2012-12-26 | Based on maintaining method and the system of the range partition table of oracle database system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102982186B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103500229B (en) * | 2013-10-24 | 2017-04-19 | 北京奇虎科技有限公司 | Database synchronization method and database system |
| CN105069134B (en) * | 2015-08-18 | 2018-07-27 | 上海新炬网络信息技术股份有限公司 | A kind of automatic collection method of Oracle statistical informations |
| CN105893531B (en) * | 2016-03-31 | 2019-07-23 | 武汉虹信技术服务有限责任公司 | PostgreSQL database mass data management method and system |
| CN109117423B (en) * | 2017-06-23 | 2022-05-03 | 阿里巴巴集团控股有限公司 | Table partition configuration method, device and system of database system |
| CN110019436B (en) * | 2017-07-14 | 2021-04-09 | 北京国双科技有限公司 | Data import \ export method and device and data table processing method and device |
| CN108197267B (en) * | 2018-01-02 | 2021-04-27 | 武汉斗鱼网络科技有限公司 | Expansion analysis method and device for database partition table and terminal equipment |
| CN108509636A (en) * | 2018-04-10 | 2018-09-07 | 浙江知水信息技术有限公司 | It is a kind of to realize that the big data of read and write abruption manages disaster recovery method based on partition table technology |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216821A (en) * | 2007-01-05 | 2008-07-09 | 中兴通讯股份有限公司 | Data acquisition system storage management method |
| CN102486798A (en) * | 2010-12-03 | 2012-06-06 | 腾讯科技（深圳）有限公司 | Data loading method and device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101086732A (en) * | 2006-06-11 | 2007-12-12 | 上海全成通信技术有限公司 | A high magnitude of data management method |
| US8135688B2 (en) * | 2007-06-15 | 2012-03-13 | Oracle International Corporation | Partition/table allocation on demand |
| US8209294B2 (en) * | 2007-06-15 | 2012-06-26 | Oracle International Corporation | Dynamic creation of database partitions |
| CN101556589A (en) * | 2008-04-09 | 2009-10-14 | 北京闻言科技有限公司 | Method for Oracle regularly deleting stale data in database |
-
2012
- 2012-12-26 CN CN201210573616.9A patent/CN102982186B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216821A (en) * | 2007-01-05 | 2008-07-09 | 中兴通讯股份有限公司 | Data acquisition system storage management method |
| CN102486798A (en) * | 2010-12-03 | 2012-06-06 | 腾讯科技（深圳）有限公司 | Data loading method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102982186A (en) | 2013-03-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102982186B (en) | Based on maintaining method and the system of the range partition table of oracle database system | |
| JP5826831B2 (en) | Data mart automation | |
| CN105930387A (en) | Data operation system and method based on data routing and sharding | |
| CN106599043A (en) | Middleware used for multilevel database and multilevel database system | |
| CN107273482A (en) | Alarm data storage method and device based on HBase | |
| CN107003935A (en) | Optimize database duplicate removal | |
| CN106407308A (en) | Method and device for expanding capacity of distributed database | |
| CN104239377A (en) | Platform-crossing data retrieval method and device | |
| CN101937474A (en) | Mass data query method and device | |
| CN102591864B (en) | Data updating method and device in comparison system | |
| CN114116716A (en) | Hierarchical data retrieval method, device and equipment | |
| CN104951462B (en) | Method and system for managing database | |
| CN104142930A (en) | Universal Delta data loading technology | |
| CN105335822B (en) | Big data analysis-oriented unified data model modeling method for smart power grid | |
| CN107783988A (en) | The locking method and equipment of a kind of directory tree | |
| CN103678712A (en) | Disaster information spatial-temporal database | |
| CN107704573A (en) | A kind of intelligent buffer method coupled with business | |
| CN107491558B (en) | Metadata updating method and device | |
| CN110706125A (en) | Water conservancy big data analysis information service system and platform service system | |
| US11036761B1 (en) | Configurable database management | |
| CN103258047B (en) | A kind of data organization method towards medicine enterprise Activity-Based Cost Control data warehouse | |
| CN104462462A (en) | Service change frequency based data warehouse modeling method and device | |
| CN105930380A (en) | Chart monitor method and device based on HADOOP | |
| CN106354824A (en) | Data management method and data management device | |
| Lee et al. | A big data management system for energy consumption prediction models |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| EE01 | Entry into force of recordation of patent licensing contract | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20130320 Assignee: Xiaoma Baoli (Xiamen) Network Technology Co.,Ltd. Assignor: XIAMEN MEIYA PICO INFORMATION Co.,Ltd. Contract record no.: X2023350000036 Denomination of invention: Maintenance method and system of range partition table based on oracle database system Granted publication date: 20160120 License type: Common License Record date: 20230301 |