CN111221798A - Construction method of administrative division and government agency special color library - Google Patents
Construction method of administrative division and government agency special color library Download PDFInfo
- Publication number
- CN111221798A CN111221798A CN201911124972.0A CN201911124972A CN111221798A CN 111221798 A CN111221798 A CN 111221798A CN 201911124972 A CN201911124972 A CN 201911124972A CN 111221798 A CN111221798 A CN 111221798A
- Authority
- CN
- China
- Prior art keywords
- government
- code
- administrative
- administrative division
- agency
- 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
- 238000010276 construction Methods 0.000 title claims abstract description 11
- 238000013507 mapping Methods 0.000 claims abstract description 26
- 238000000034 method Methods 0.000 claims abstract description 25
- 230000008520 organization Effects 0.000 claims abstract description 20
- 239000000470 constituent Substances 0.000 claims description 12
- 230000008859 change Effects 0.000 claims description 6
- 238000010586 diagram Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 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
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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/24—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for constructing a special color library of an administrative division and a government organization, and belongs to the technical field of database construction of software architecture. The invention relates to a construction method of a special color library of an administrative division and a government organization, which comprises the following specific steps: adding two fields of an administrative division internal code and an administrative division code in an administrative division table, adding two fields of a government agency internal code and a government agency code in a government agency table, adding a mapping field of the administrative division and the government agency in the government agency table, and establishing the relationship between the administrative division and the administrative division internal code through the mapping field by the administrative division and the government agency. The construction method of the administrative division and the special color library of the government organization can solve the problem that the government information system is difficult to modify after the administrative division code and the government organization code are changed, and has good popularization and application values.
Description
Technical Field
The invention relates to the technical field of database construction of software architecture, and particularly provides a construction method of administrative divisions and special color libraries of government agencies.
Background
Administrative division data and government agency data are basic data for government information resource management, and changes of the administrative division data and the government agency data have a great influence on a government information system. In most conventional government information system software, administrative division codes and government agency codes are directly used for business data processing, and the first few bits of the government agency codes are the administrative division codes. Administrative code changes can cause administrative division data and government agency data and related business data to be difficult to process and government information systems to respond in time. The design of government information systems therefore generally places two requirements on the alteration of administrative division data and government agency data: firstly, timely responding to changes of administrative divisions and government agencies in a government information system; and secondly, the influence of administrative divisions on the existing service data is reduced as much as possible.
Disclosure of Invention
The technical task of the invention is to provide a construction method of an administrative division and a special color library of government agencies aiming at the existing problems, which is used for solving the problem that a government information system is difficult to modify after the codes of the administrative division and the codes of the government agencies are changed.
In order to achieve the purpose, the invention provides the following technical scheme:
a method for constructing a special color library of an administrative division and government agencies is characterized in that two fields of an administrative division internal code and an administrative division code are added in an administrative division table, two fields of a government agency internal code and a government agency code are added in a government agency table, mapping fields of the administrative division and the government agencies are added in the government agency table, and the administrative division and the government agencies establish the relation between the government agencies and the administrative division internal code through the mapping fields. Through the established mapping relation, direct contact is cut off, and the influence of administrative division change on government organization data is reduced. By the method for constructing the administrative division and the special color library of the government agency, the influence of administrative division codes and government agency code changes on government information service data can be reduced, the maintenance difficulty of a government information system on the administrative division codes and the government agency codes is reduced, and therefore timely response is obtained.
Preferably, the method for constructing the special color library of the administrative division and the government agency comprises the following steps:
s1, adding an administrative division internal code and an administrative division code into the administrative division table, wherein the administrative division code is adjusted and changed along with the administrative division, and the administrative division internal code is kept unchanged;
s2, adding two fields of a government agency internal code and a government agency code in a government agency table, wherein the government agency code is adjusted and changed along with the government agency, and the government agency internal code is kept unchanged;
and S3, adding mapping fields of the government agencies and the administrative divisions into the government agency table, and establishing the relation between the government agencies and the internal codes of the administrative divisions by the administrative divisions and the government agencies through the mapping fields so as to reduce the influence of the change of the administrative divisions on the data of the government agencies.
Preferably, in step S1, the administrative division code is set as the primary key, and the administrative division code are in one-to-one correspondence.
Preferably, in step S2, the government agency code is used as the primary key, and the government agency code are in one-to-one correspondence.
Preferably, in step S2, when the internal government code field is added to the government agency table, the internal government code of the government or the administration committee is the internal government agency code of the government or the administration committee.
Preferably, when the internal government code field is added to the government agency table, the internal government code of the constituent government agency of the government agency is the internal government code of the government or the administration of the government agency of the constituent agency of the government agency.
Preferably, when the government code field is added to the government agency table, the government code of the institution to which the government or the administrative commission is directly affiliated or the constituent department thereof is the government code of the government or the administrative commission to which the government or the administrative commission is directly affiliated or the constituent department thereof is affiliated.
Preferably, in step S3, when the mapping fields of the government agencies and the administrative divisions are added to the government agency table, the corresponding administrative division internal code is filled in by the government or the administrative committee, the filling in of the government agency component is null, and the filling in of the business entity to which the government or the administrative committee directly belongs or the component department thereof belongs is null.
Compared with the prior art, the construction method of the administrative division and the special color library of the government organization has the following outstanding beneficial effects: the method for constructing the special color library of the administrative division and the government agency establishes the connection between the administrative division and the government agency through the mapping fields, cuts off direct connection, reduces the influence of the change of the administrative division on the data of the government agency, thereby reducing the influence of the change of the administrative division code and the government agency code on the government information service data, reducing the maintenance difficulty of the government information system on the administrative division code and the government agency code, obtaining timely response and having good popularization and application values.
Drawings
FIG. 1 is a diagram illustrating the mapping between administrative divisions and government agencies according to the present invention;
FIG. 2 is a schematic diagram of a search for government agencies based on administrative divisions;
figure 3 is a schematic diagram of finding administrative divisions from a government agency.
Detailed Description
The method for constructing the administrative division and the special color library of the government agency according to the present invention will be described in further detail with reference to the accompanying drawings and examples.
Examples
The invention relates to a construction method of an administrative division and a special color library of government institutions. Two fields of government agency internal code and government agency code are added in the government agency table. And adding a mapping field of the administrative division and the government organization in the government organization table, and establishing the relation between the administrative division and the internal code of the administrative division by the administrative division and the government organization through the mapping field.
The method specifically comprises the following steps:
and S1, adding an administrative division internal code and an administrative division code in the administrative division table, wherein the administrative division code is adjusted and changed along with the administrative division, and the administrative division internal code is kept unchanged.
The administrative division internal code is used as a main key, and the administrative division code and the administrative division internal code are in one-to-one correspondence.
And S2, adding two fields of the government agency code and the government agency code in the government agency table, wherein the government agency code is changed along with the adjustment of the government agency, and the government agency code is kept unchanged.
The government agency code is used as a main key, and the government agency code corresponds to the government agency code one by one.
When a government code field is added to the government agency table, the government code of the government or the administrative commission is the government agency code of the government or the administrative commission.
When the government code field is added to the government agency table, the government code of the constituent government agency is the government code of the government or the administration of the government agency in which the constituent government agency is located.
When the government code field is added into the government agency table, the government code of the institution to which the government or the administrative committee directly belongs or the constituent department thereof belongs is the government code of the government or the administrative committee to which the government or the administrative committee directly belongs or the constituent department thereof belongs.
And S3, adding mapping fields of the government agencies and the administrative divisions into the government agency table, and establishing the relation between the government agencies and the internal codes of the administrative divisions by the administrative divisions and the government agencies through the mapping fields so as to reduce the influence of the change of the administrative divisions on the data of the government agencies.
When the mapping fields of the government agencies and the administrative divisions are added into the government agency table, the corresponding administrative division internal codes are filled in by the government or the administrative committee, the filling in of the government agency composition departments is null, and the filling in of the government or the administrative committee directly or the business units to which the composition departments belong is null.
As shown in fig. 1, the map of the administrative division and the government agency is a map in which the country, province, city, and county of the administrative division correspond to the country, province, city, and county of the government agency, respectively, via the map field.
As shown in fig. 2, the specific process of finding a government agency according to an administrative division is as follows:
1) when searching for the government or administrative committee according to the administrative division, the internal code of the administrative division is inquired, and then the mapping fields of the government agency and the administrative division are found, so that the government or administrative committee is found.
2) When searching for a government component according to the administrative division, the internal code of the administrative division is inquired, then the mapping fields of the government institutions and the administrative division are found, and then the internal code of the government or the administration is found, so that the government component, such as a certain office, is found.
3) When searching for a business unit according to an administrative district, the internal code of the administrative district is inquired, then the mapping fields of government institutions and the administrative district are inquired, and then the internal code of the government or a management committee is found, so that the business unit, such as a certain office, is found.
As shown in fig. 3, the specific process of finding an administrative division according to a government agency is as follows:
1) when the administrative division is searched according to the government or the administrative committee, the internal code of the government organization is inquired, and then the mapping fields of the government organization and the administrative division are inquired, so that the administrative division is found.
2) When the administrative division is searched according to the government component department, the government internal code of the government or the administration is inquired, and then the mapping fields of the government organization and the administrative division are inquired, so that the administrative division is found.
3) When an administrative division is searched according to a business unit, the internal code of a government agency is inquired, and then mapping fields of the government agency and the administrative division are inquired, so that the administrative division is found.
The above-described embodiments are merely preferred embodiments of the present invention, and general changes and substitutions by those skilled in the art within the technical scope of the present invention are included in the protection scope of the present invention.
Claims (8)
1. A construction method of a special color library of an administrative division and a government organization is characterized by comprising the following steps: the method comprises the steps of adding two fields of an administrative division internal code and an administrative division code in an administrative division table, adding two fields of a government organization internal code and a government organization code in a government organization table, adding a mapping field of the administrative division and the government organization in the government organization table, and establishing the relationship between the government organization and the administrative division internal code through the mapping field by the administrative division and the government organization.
2. The method of claim 1, wherein the method comprises the steps of: the method specifically comprises the following steps:
s1, adding an administrative division internal code and an administrative division code into the administrative division table, wherein the administrative division code is adjusted and changed along with the administrative division, and the administrative division internal code is kept unchanged;
s2, adding two fields of a government agency internal code and a government agency code in a government agency table, wherein the government agency code is adjusted and changed along with the government agency, and the government agency internal code is kept unchanged;
and S3, adding mapping fields of the government agencies and the administrative divisions into the government agency table, and establishing the relation between the government agencies and the internal codes of the administrative divisions by the administrative divisions and the government agencies through the mapping fields so as to reduce the influence of the change of the administrative divisions on the data of the government agencies.
3. The method of claim 2, wherein the method comprises the steps of: in step S1, the administrative division code is used as the primary key, and the administrative division code are in one-to-one correspondence.
4. The method of claim 3, wherein the method comprises the steps of: in step S2, the government agency codes are used as the primary keys, and the government agency codes correspond to the government agency codes one to one.
5. The method of claim 4, wherein the method comprises the steps of: in step S2, when the internal government code field is added to the government agency table, the internal government code of the government or the administration committee is the internal government code of the government or the administration committee.
6. The method of claim 4, wherein the method comprises the steps of: when the government code field is added to the government agency table, the government code of the constituent government agency is the government code of the government or the administration of the government agency in which the constituent government agency is located.
7. The method of claim 4, wherein the method comprises the steps of: when the government code field is added into the government agency table, the government code of the institution to which the government or the administrative committee directly belongs or the constituent department thereof belongs is the government code of the government or the administrative committee to which the government or the administrative committee directly belongs or the constituent department thereof belongs.
8. The method for constructing the distinctive color library of administrative divisions and government agencies according to any one of claims 2 to 7, wherein: in step S3, when the mapping fields of the government agencies and the administrative divisions are added to the government agency table, the corresponding administrative division internal code is filled in by the government or the administrative committee, the filling in of the government agency component is null, and the filling in of the business entity to which the government or the administrative committee directly belongs or the component department thereof is null.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911124972.0A CN111221798A (en) | 2019-11-18 | 2019-11-18 | Construction method of administrative division and government agency special color library |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911124972.0A CN111221798A (en) | 2019-11-18 | 2019-11-18 | Construction method of administrative division and government agency special color library |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111221798A true CN111221798A (en) | 2020-06-02 |
Family
ID=70810829
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911124972.0A Pending CN111221798A (en) | 2019-11-18 | 2019-11-18 | Construction method of administrative division and government agency special color library |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111221798A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102023983A (en) * | 2009-09-11 | 2011-04-20 | 首都师范大学 | Statistical space-time database and managing method thereof |
| CN109739832A (en) * | 2018-11-30 | 2019-05-10 | 北京大数元科技发展有限公司 | A kind of method and system of government information resource management |
-
2019
- 2019-11-18 CN CN201911124972.0A patent/CN111221798A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102023983A (en) * | 2009-09-11 | 2011-04-20 | 首都师范大学 | Statistical space-time database and managing method thereof |
| CN109739832A (en) * | 2018-11-30 | 2019-05-10 | 北京大数元科技发展有限公司 | A kind of method and system of government information resource management |
Non-Patent Citations (2)
| Title |
|---|
| 王建弟: "土地利用数据库变更实现" * |
| 门葆红 等: "测绘生产计划信息一体化管理的解决方案" * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101313300B (en) | Local search | |
| CN112860689B (en) | Platform system based on space-time grid data | |
| CN116680648A (en) | Service fusion data generation method and system for digital twin city | |
| CN111125496B (en) | Price query method, device and system | |
| CA2606148A1 (en) | Method of building a validation database | |
| CN110175211B (en) | Data synchronization method and device | |
| CN112988715B (en) | Construction method of global network place name database based on open source mode | |
| CN104461544A (en) | Dynamic code generation device and method | |
| CN107741982A (en) | A kind of coordinate and administrative region matching system and method | |
| CN107203642A (en) | A kind of method of data synchronization and device | |
| CN110879812B (en) | Spark-based data synchronization method in e-commerce platform | |
| Teo et al. | A novel systematic approach of constructing protests repertoires from social media: comparing the roles of organizational and non-organizational actors in social movement | |
| US7729997B2 (en) | Determination of an entity's assets associated with an event | |
| CN103324749A (en) | Spatial analysis and correction method based on standard text addresses | |
| CN111221798A (en) | Construction method of administrative division and government agency special color library | |
| CN101673257B (en) | Copying and pasting method of complex object data and device | |
| CN105701220A (en) | Internal business data system and processing method of enterprise | |
| CN113220762A (en) | Method, device, processor and storage medium for realizing general record processing of key service field change in big data application | |
| Caldwell et al. | It is time to recognize communications as a mode of transportation | |
| CN115599787A (en) | Level sub-metering method and device, electronic equipment and storage medium | |
| CN106056458B (en) | Digital oil field comprehensive application system | |
| CN114493527A (en) | Public service platform of wisdom district name based on wisdom civil affairs | |
| CN105844403A (en) | Enterprise management system information global searching and tracing method | |
| CN108228694A (en) | Catalogue generation method based on refining data item | |
| CN112364651A (en) | Express bill two-segment code generation method, device, equipment and storage medium |
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: 20200602 |