CN110427413A - Lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite - Google Patents
Lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite Download PDFInfo
- Publication number
- CN110427413A CN110427413A CN201910599242.XA CN201910599242A CN110427413A CN 110427413 A CN110427413 A CN 110427413A CN 201910599242 A CN201910599242 A CN 201910599242A CN 110427413 A CN110427413 A CN 110427413A
- Authority
- CN
- China
- Prior art keywords
- scientific research
- project
- module
- research project
- scientific
- 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
- 238000011160 research Methods 0.000 title claims abstract description 108
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000012423 maintenance Methods 0.000 claims abstract description 24
- 238000012795 verification Methods 0.000 claims description 7
- 238000012545 processing Methods 0.000 claims description 6
- 230000008676 import Effects 0.000 claims description 5
- 238000007726 management method Methods 0.000 claims 19
- 238000013502 data validation Methods 0.000 claims 1
- 230000008569 process Effects 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 238000007689 inspection Methods 0.000 description 4
- 238000013461 design Methods 0.000 description 3
- 230000002452 interceptive effect Effects 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000002085 persistent effect Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Marketing (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to a kind of lightweight Project Management System of Scientific based on Sqlite, including scientific research project data input module, for realizing monofile typing and batch documents typing, and carry out data legitimacy verifies；In library item mesh enquiry module, for inquiring the project in database；In library item mesh management service module, is compared for realizing editor's scientific research project information, scientific research project the file information and scientific research project information exports；Project funds management module, for realizing the inquiry and maintenance of scientific research item funds.The invention further relates to a kind of lightweight scientific research project management control methods realized based on Sqlite.Using the lightweight Project Management System of Scientific of the invention based on Sqlite and corresponding scientific research project management control method, support the typing and maintenance of a variety of scientific research project excel Template Informations, it supports scientific research project declare, approve and initiate a project in advance, the multistages maintenance needs such as the project implementation, has the characteristics of broad covered area.Database has light weight, feature easy to use using the sqlite3 file based database application for supporting SQL.
Description
Technical field
The present invention relates to the automatic processing field of text carrier information more particularly to scientific research project information technology field,
Specifically refer to a kind of lightweight Project Management System of Scientific based on Sqlite and corresponding scientific research project management control method.
Background technique
The entire management process of scientific research project be related to it is pre- declare, formal check, formally declare, approve and initiate a project, the project implementation,
The processes such as project intermediate inspection, the project acceptance inspection.Any one stage be all a workload is huge, time-consuming information management with
The process of maintenance.Currently, having all types of mature and stable scientific research project management softwares in industry.In rear end memory technology side
Face, for most management system bases using Sql Server as the storage and retrieval technology of data, the shortcomings that technology, is that it is deposited
Storage relies on greatly, erroneous for installation, is unfavorable for quick deployment, remaining technology based on Access database then lacks the branch of affair mechanism
It holds, influences the consistency of data.The present invention gives a kind of lightweight Project Management System of Scientific based on C/S framework, this is
System can support the project information based on Excel file to automate typing and export, the management of scientific research project performance assessment criteria and project
The year of funds executes the functions such as management.
Summary of the invention
The purpose of the present invention is overcoming the above-mentioned prior art, provides and a kind of meet lightweight, automation, behaviour
Make the easy lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite.
To achieve the goals above, the lightweight Project Management System of Scientific of the invention based on Sqlite and corresponding section
It is as follows to grind project management control method:
The lightweight Project Management System of Scientific based on Sqlite, is mainly characterized by, and the system includes:
Scientific research project data input module for realizing monofile typing and batch documents typing, and carries out data conjunction
Method verification；
In library item mesh enquiry module, it is connected with the scientific research project data input module, for inquiring in database
Project；
In library item mesh management service module, with the scientific research project data input module and in library item mesh enquiry module phase
Connection compares for realizing editor's scientific research project information, scientific research project the file information and scientific research project information exports；
Project funds management module, with the scientific research project data input module, in library item mesh enquiry module and in library
Project management maintenance module is connected, for realizing the inquiry and maintenance of scientific research item funds.
Preferably, the scientific research project data input module includes:
Monofile typing unit is passed through with described in library item mesh enquiry module, in library item mesh management service module and project
Expense management module is connected, and operates for realizing the typing of monofile；
Batch documents typing unit, with it is described in library item mesh enquiry module, in library item mesh management service module and project
Funds management module is connected, and operates for realizing the typing of batch documents.
Preferably, described include: in library item mesh management service module
Project information edit cell is connected with the scientific research project data input module and in library item mesh enquiry module
It connects, for being edited to scientific research project information；
Spanned item mesh the file information comparing unit, with the scientific research project data input module and in library item mesh enquiry module
It is connected, for comparing the information of different scientific research project files；
Project information lead-out unit is connected with the scientific research project data input module and in library item mesh enquiry module
It connects, for exporting scientific research project information.
Preferably, the project funds management module includes:
Funds query unit, with the scientific research project data input module, in library item mesh enquiry module and in library item mesh
Management service module is connected, for realizing the query function of scientific research item funds；
Funds maintenance unit, with the scientific research project data input module, in library item mesh enquiry module and in library item mesh
Management service module is connected, for realizing the maintenance function of scientific research item funds.
This realizes the lightweight scientific research project management control method based on Sqlite, main feature using above system
Be, the method the following steps are included:
(1) the scientific research project data input module described in carries out monofile to the scientific research project information based on Excel file
It imports or batch imports；
(2) the scientific research project data input module described in carries out legitimacy verifies processing to the file of importing；
(3) typing operation is carried out to the successful item file of verification.
Preferably, the method is further comprising the steps of:
Scientific research project information is edited, compared and exported in library item mesh management service module described in (4-1).
Preferably, the method is further comprising the steps of:
Project funds management module described in (4-2) being inquired and being safeguarded to scientific research item funds.
Using the lightweight Project Management System of Scientific of the invention based on Sqlite and corresponding scientific research project management
Control method supports the typing and maintenance of a variety of scientific research project excel Template Informations, supports scientific research project to declare in advance, project is stood
The multistages maintenance needs such as item, project implementation, have the characteristics of broad covered area.Choosing software and hardware necessary to system running environment
Suitably, system design not only considers long term growth, but also Lay Importance on Practical, and the type selecting of software and hardware has higher cost performance.Database is adopted
With the sqlite3 file based database application for supporting SQL, have light weight, feature easy to use.
Detailed description of the invention
Fig. 1 is the logical architecture figure of the lightweight Project Management System of Scientific of the invention based on Sqlite.
Fig. 2 is the functional module structure figure of the lightweight Project Management System of Scientific of the invention based on Sqlite.
Fig. 3 is the flow chart of the lightweight scientific research project management control method of realization of the invention based on Sqlite.
Specific embodiment
It is further to carry out combined with specific embodiments below in order to more clearly describe technology contents of the invention
Description.
Of the invention is somebody's turn to do the lightweight Project Management System of Scientific based on Sqlite, including:
Scientific research project data input module for realizing monofile typing and batch documents typing, and carries out data conjunction
Method verification；
In library item mesh enquiry module, it is connected with the scientific research project data input module, for inquiring in database
Project；
In library item mesh management service module, with the scientific research project data input module and in library item mesh enquiry module phase
Connection compares for realizing editor's scientific research project information, scientific research project the file information and scientific research project information exports；
Project funds management module, with the scientific research project data input module, in library item mesh enquiry module and in library
Project management maintenance module is connected, for realizing the inquiry and maintenance of scientific research item funds.
As the preferred embodiment of the present invention, the scientific research project data input module includes:
Monofile typing unit is passed through with described in library item mesh enquiry module, in library item mesh management service module and project
Expense management module is connected, and operates for realizing the typing of monofile；
Batch documents typing unit, with it is described in library item mesh enquiry module, in library item mesh management service module and project
Funds management module is connected, and operates for realizing the typing of batch documents.
It is described to include: in library item mesh management service module as the preferred embodiment of the present invention
Project information edit cell is connected with the scientific research project data input module and in library item mesh enquiry module
It connects, for being edited to scientific research project information；
Spanned item mesh the file information comparing unit, with the scientific research project data input module and in library item mesh enquiry module
It is connected, for comparing the information of different scientific research project files；
Project information lead-out unit is connected with the scientific research project data input module and in library item mesh enquiry module
It connects, for exporting scientific research project information.
As the preferred embodiment of the present invention, the project funds management module includes:
Funds query unit, with the scientific research project data input module, in library item mesh enquiry module and in library item mesh
Management service module is connected, for realizing the query function of scientific research item funds；
Funds maintenance unit, with the scientific research project data input module, in library item mesh enquiry module and in library item mesh
Management service module is connected, for realizing the maintenance function of scientific research item funds.
This of the invention realizes the lightweight scientific research project management control method based on Sqlite using above system, wherein
The following steps are included:
(1) the scientific research project data input module described in carries out monofile to the scientific research project information based on Excel file
It imports or batch imports；
(2) the scientific research project data input module described in carries out legitimacy verifies processing to the file of importing；
(3) typing operation is carried out to the successful item file of verification.
As the preferred embodiment of the present invention, the method is further comprising the steps of:
Scientific research project information is edited, compared and exported in library item mesh management service module described in (4-1).
As the preferred embodiment of the present invention, the method is further comprising the steps of:
Project funds management module described in (4-2) being inquired and being safeguarded to scientific research item funds.
In a specific embodiment of the invention, it is an object of the invention to design and Implement the full mistake of support scientific research project
The tool of journey information system management, thus greatly reduce project information typing processing, editor maintenance work, reduce business manpower at
This, improves the execution efficiency of person in charge of the project department, ensures the good operation of project.
The present invention relates to the automatic processing of common text carrier information and scientific research project information daily maintenance administrative skill,
Creative stores by rear end of lightweight document data bank, realizes front end interactive interface by Pyqt5, is based on Excel file
The automation typing and the execution management of whole life cycle of the information of information realization scientific research project.
The entire management process of scientific research project is related to pre- declaring, formal check, formally declaring, reply, the project implementation, project
The processes such as intermediate inspection, the project acceptance inspection.The management process of entire project needs to handle bulk information, and process takes time and effort to project
The daily management mission of responsible institution brings great difficulty.The present invention is primarily based on Excel text information and realizes scientific research project letter
Then the batch automatic input of breath and validity checking realize scientific research project using the storage capacity of lightweight SQLite database
The persistent storage of information, and the daily management maintenance function based on transactional mechanism realization project information, to guarantee data
Consistency.Interactive interface is finally designed and developed based on PyQt5, realizes user's interaction.
The present invention carries out the importing of monofile or batch to the scientific research project information based on Excel file first, is importing
While support to handle the legitimacy verifies of file.Secondly, carrying out typing operation, realization section to by the item file of verification
Grind the persistent storage of project information.Then basic query, project information editor and project funds pipe can be carried out in library item mesh
The operation such as reason.
Using the lightweight Project Management System of Scientific of the invention based on Sqlite and corresponding scientific research project management
Control method supports the typing and maintenance of a variety of scientific research project excel Template Informations, supports scientific research project to declare in advance, project is stood
The multistages maintenance needs such as item, project implementation, have the characteristics of broad covered area.Choosing software and hardware necessary to system running environment
Suitably, system design not only considers long term growth, but also Lay Importance on Practical, and the type selecting of software and hardware has higher cost performance.Database is adopted
With the sqlite3 file based database application for supporting SQL, have light weight, feature easy to use.
In this description, the present invention is described with reference to its specific embodiment.But it is clear that can still make
Various modifications and alterations are without departing from the spirit and scope of the invention.Therefore, the description and the appended drawings should be considered as illustrative
And not restrictive.
Claims (7)
1. a kind of lightweight Project Management System of Scientific based on Sqlite, which is characterized in that the system includes:
Scientific research project data input module for realizing monofile typing and batch documents typing, and carries out data validation
Verification；
In library item mesh enquiry module, it is connected with the scientific research project data input module, for inquiring the item in database
Mesh；
In library item mesh management service module, it is connected with the scientific research project data input module and in library item mesh enquiry module
It connects, is compared for realizing editor's scientific research project information, scientific research project the file information and scientific research project information exports；
Project funds management module, with the scientific research project data input module, in library item mesh enquiry module and in library item mesh
Management service module is connected, for realizing the inquiry and maintenance of scientific research item funds.
2. the lightweight Project Management System of Scientific according to claim 1 based on Sqlite, which is characterized in that described
Scientific research project data input module includes:
Monofile typing unit, with it is described in library item mesh enquiry module, in library item mesh management service module and project funds pipe
Reason module is connected, and operates for realizing the typing of monofile；
Batch documents typing unit, with it is described in library item mesh enquiry module, in library item mesh management service module and project funds
Management module is connected, and operates for realizing the typing of batch documents.
3. the lightweight Project Management System of Scientific according to claim 1 based on Sqlite, which is characterized in that described
Include: in library item mesh management service module
Project information edit cell is connected with the scientific research project data input module and in library item mesh enquiry module, uses
It is edited in scientific research project information；
Spanned item mesh the file information comparing unit is connected with the scientific research project data input module and in library item mesh enquiry module
It connects, for comparing the information of different scientific research project files；
Project information lead-out unit is connected with the scientific research project data input module and in library item mesh enquiry module, uses
In export scientific research project information.
4. the lightweight Project Management System of Scientific according to claim 1 based on Sqlite, which is characterized in that described
Project funds management module includes:
Funds query unit, with the scientific research project data input module, in library item mesh enquiry module and in library project management
Maintenance module is connected, for realizing the query function of scientific research item funds；
Funds maintenance unit, with the scientific research project data input module, in library item mesh enquiry module and in library project management
Maintenance module is connected, for realizing the maintenance function of scientific research item funds.
5. a kind of realize the lightweight scientific research project management control method based on Sqlite using system described in claim 1,
It is characterized in that, the method the following steps are included:
(1) the scientific research project data input module described in carries out monofile importing to the scientific research project information based on Excel file
Or batch imports；
(2) the scientific research project data input module described in carries out legitimacy verifies processing to the file of importing；
(3) typing operation is carried out to the successful item file of verification.
6. lightweight scientific research project management control method of the realization based on Sqlite according to claim 5, feature exist
In the method is further comprising the steps of:
Scientific research project information is edited, compared and exported in library item mesh management service module described in (4-1).
7. lightweight scientific research project management control method of the realization based on Sqlite according to claim 5, feature exist
In the method is further comprising the steps of:
Project funds management module described in (4-2) being inquired and being safeguarded to scientific research item funds.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910599242.XA CN110427413A (en) | 2019-07-04 | 2019-07-04 | Lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910599242.XA CN110427413A (en) | 2019-07-04 | 2019-07-04 | Lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110427413A true CN110427413A (en) | 2019-11-08 |
Family
ID=68408942
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910599242.XA Pending CN110427413A (en) | 2019-07-04 | 2019-07-04 | Lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110427413A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115358708A (en) * | 2022-08-16 | 2022-11-18 | 中国水产科学研究院长江水产研究所 | Scientific research project management system and method under local area network |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9946971B1 (en) * | 2013-12-20 | 2018-04-17 | Massachusetts Mutual Life Insurance Company | Method for the management of artifacts in knowledge ecosystems |
| CN109492921A (en) * | 2018-11-20 | 2019-03-19 | 南京江业软件科技有限公司 | A kind of Scientific Research Projects management system |
-
2019
- 2019-07-04 CN CN201910599242.XA patent/CN110427413A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9946971B1 (en) * | 2013-12-20 | 2018-04-17 | Massachusetts Mutual Life Insurance Company | Method for the management of artifacts in knowledge ecosystems |
| CN109492921A (en) * | 2018-11-20 | 2019-03-19 | 南京江业软件科技有限公司 | A kind of Scientific Research Projects management system |
Non-Patent Citations (3)
| Title |
|---|
| 安天浩等: "SQLite软件建设PRB数据库的应用", 《矿产勘查》 * |
| 柳智等: "基于SQLite的C/S架构用于医院资产管理系统的研究", 《科技经济市场》 * |
| 王德丰等: "基于C/S模式下大型综合性医院科研管理信息系统的开发", 《医学信息》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115358708A (en) * | 2022-08-16 | 2022-11-18 | 中国水产科学研究院长江水产研究所 | Scientific research project management system and method under local area network |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10061827B2 (en) | Mechanism for synchronizing OLAP system structure and OLTP system structure | |
| US8060553B2 (en) | Service oriented architecture for a transformation function in a data integration platform | |
| US8041760B2 (en) | Service oriented architecture for a loading function in a data integration platform | |
| US7814142B2 (en) | User interface service for a services oriented architecture in a data integration platform | |
| US7814470B2 (en) | Multiple service bindings for a real time data integration service | |
| US20180330412A1 (en) | Systems and methods for processing and reconciling an invoice data file | |
| US20050262189A1 (en) | Server-side application programming interface for a real time data integration service | |
| US20060069717A1 (en) | Security service for a services oriented architecture in a data integration platform | |
| US20050235274A1 (en) | Real time data integration for inventory management | |
| US20050223109A1 (en) | Data integration through a services oriented architecture | |
| US20060010195A1 (en) | Service oriented architecture for a message broker in a data integration platform | |
| US20050234969A1 (en) | Services oriented architecture for handling metadata in a data integration platform | |
| US20050262190A1 (en) | Client side interface for real time data integration jobs | |
| US20050240354A1 (en) | Service oriented architecture for an extract function in a data integration platform | |
| US20050262193A1 (en) | Logging service for a services oriented architecture in a data integration platform | |
| US20050228808A1 (en) | Real time data integration services for health care information data integration | |
| US20050240592A1 (en) | Real time data integration for supply chain management | |
| US20050232046A1 (en) | Location-based real time data integration services | |
| CN107918836A (en) | A kind of intelligence clearance system and method | |
| CN110827132A (en) | Automatic reconciliation method for marketing account of power enterprise | |
| CN112214536B (en) | Enterprise account data real-time import management system | |
| CN110427413A (en) | Lightweight Project Management System of Scientific and corresponding scientific research project management control method based on Sqlite | |
| CN112232934A (en) | Tax-related data acquisition and automatic batch tax declaration method based on RPA | |
| EP2413272A1 (en) | Capturing and processing data generatid in an erp interim phase | |
| CN111125045A (en) | Lightweight ETL processing platform |
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: 20191108 |
|
| RJ01 | Rejection of invention patent application after publication |