CN107766519A - A kind of method of visual configuration data structure - Google Patents
A kind of method of visual configuration data structure Download PDFInfo
- Publication number
- CN107766519A CN107766519A CN201711001413.1A CN201711001413A CN107766519A CN 107766519 A CN107766519 A CN 107766519A CN 201711001413 A CN201711001413 A CN 201711001413A CN 107766519 A CN107766519 A CN 107766519A
- Authority
- CN
- China
- Prior art keywords
- data structure
- data
- field
- definition
- basic
- 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.)
- Granted
Links
Abstract
The invention discloses a kind of method of visual configuration data structure, comprise the steps of：A. the basic data element storehouse being made up of some basic datas is created；B. data structure definition table is created, the data structure definition table is used for the base attribute for preserving the data structure for needing to configure and the field needed；C. create and deposit value table, the value of field in the table for depositing value table for storing all table structures；D. financial master data element is sorted out and by financial master data element input system and definition data structure.A kind of method of visual configuration data structure of the present invention, using the financial element that basis is defined by business personnel, again by financial staff's method that independent assortment configures required data structure on web page of specialty, solves the unfamiliar problem of developer's professional knowledge, developer is set not have to learn substantial amounts of financial savvy, development efficiency is greatly improved, while flexible business model configuration is provided for system, improves the scope of application of system.
Description
Technical field
The present invention relates to financial software technical field of automation, more particularly to a kind of side of visual configuration data structure
Method.
Background technology
In financial software tradition development process, it is necessary first to collect business demand, required table is taken out further according to demand
Structure, then the corresponding relation between table is determined, then code development could be carried out according to table structure, due to being soft for finance
Part, it is related to more financial professional knowledge, and developer is difficult quickly to grasp the professional knowledge in terms of these finance, is often opened
Hair progress is slow, newly enter developer learning cost it is high the problem of.
The content of the invention
The purpose of the present invention is to overcome deficiency in above-mentioned background technology, there is provided a kind of side of visual configuration data structure
Method, cost high the shortcomings that slow for being developed in Financial Software System development process, the finance member on basis is defined by business personnel
Element, then by professional financial staff, independent assortment configures required data structure on web page, solves developer's business
The unfamiliar problem of knowledge, make developer not have to excessively go to pay close attention to substantial amounts of financial savvy, greatly promote development efficiency, simultaneously
Flexible business model configuration is provided for system, improves the scope of application of system.
In order to reach above-mentioned technique effect, the present invention takes following technical scheme：
A kind of method of visual configuration data structure, is comprised the steps of：
A. the basic data element storehouse being made up of some basic datas is created；
B. data structure definition table is created, the data structure definition table is used for the base for preserving the data structure for needing to configure
This attribute and the field needed；
C. create and deposit value table, the value of field in the table for depositing value table for storing all table structures；
D. financial master data element is sorted out and by financial master data element input system and definition data structure.
Further, when basic data element storehouse is created in the step A, the data type of each basic data need to be determined,
Wherein, the data type is at least divided into character, numeral, enumerated, and basic data must be smallest particles, and has versatility
And stationarity, it should be tried one's best after establishment and avoid modifying and delete, otherwise can influence other data structures based on it.
Further, the outer of infrastructure elements storehouse major key is preserved comprising one in the data structure definition table in the step B
The uniqueness mark of key field and a preservation data structure definition table definition structure, then again to the field of needs, according to base
Basic data in plinth data element storehouse is combined, and user can carry out intuitively field selection and configuration in web page, create
Go out the related required data structure of business, i.e. table structure, so as to realize that table structure customizes, after the completion of configuration, you can find out gained
The overall condition of data structure, embody visual feature.
Further, the incidence relation of field including data structure definition table in the table deposited in value table in the step C,
Uniqueness mark, the data structure table of data line define the incidence relation and the corresponding value of each field of field, if being
Data volume is bigger in system, can be by the way of table is divided.
Further, defined in the step D during data structure, the data structure being created that comprises at least the name of data
Title, field, type, and after creating data structure, then corresponding data manipulation can be carried out, including increase, delete, change, look into, for
It is consistent with common table structure application method for user, it is highly convenient for user's use.
The present invention compared with prior art, has following beneficial effect：
The method of a kind of visual configuration data structure of the present invention, for being developed in Financial Software System development process
Slowly, the shortcomings that cost is high, the financial element on basis is defined by business personnel, then by professional financial staff on web page
Independent assortment configures required data structure, solves the unfamiliar problem of developer's professional knowledge, does not have to developer
Excessively go to pay close attention to substantial amounts of financial savvy, reduce the learning time of developer, greatly promote development efficiency, while be system
Flexible business model configuration is provided, table structure can be increased newly at any time, improve the telescopic joint and applicability of system.
Brief description of the drawings
Fig. 1 is the interface schematic diagram of master data element database in one embodiment of the present of invention；
Fig. 2 is the interface schematic diagram that master data defines in one embodiment of the present of invention；
Fig. 3 is the interface schematic diagram for carrying out data manipulation in one embodiment of the present of invention to data structure definition table.
Embodiment
With reference to embodiments of the invention, the invention will be further elaborated.
Embodiment：
From the example for applying to this method in certain cloud service financial management platform in this implementation.
The first step, managed in cloud service financial management platform using the mode of configuration data structure in cloud service finance
In the granular center of platform, the basic data element storehouse being made up of some basic datas is created, wherein specifically including basic number
According to additions and deletions look into and change, the function such as import and export, and each basic data is respectively provided with title, mark, type, length, precision etc..
Wherein, basic data must be smallest particles and have versatility and stationarity, avoid being repaiied as far as possible after establishment
Change and delete, avoid influenceing other data structures based on it, and data type is at least divided into character, numeral, enumerated, such as
The fruit basic data is enumeration type, then also needs to define the span of the element, the interface of specific master data element database is such as
Shown in Fig. 1.
Second step, after creating basic data element storehouse, data structure definition table is created, the table, which is used for preservation, to be needed to configure
Data structure base attribute and need field.Specially enter in the master data definition module of cloud service financial management platform
Row data structure customizes, including master data title, type and the basic data quoted, and quotes basic data using selection
Mode, basic data is first shown, then double-click the basic data quoted needed for selection as table texture field, what master data defined
Interface is as shown in Figure 2.
3rd step, after creating data structure definition table, establishment one is used for the value for storing the middle field of all table structures
Value table is deposited, specially when carrying out data manipulation to data structure definition table, first according to the uniqueness mark of table structure, in number
Defined according to structure and all fields of the table are found in table, be illustrated according to order of the field on the page, user of service is to each field
After carrying out data inputting, according to the unique designation of each field, value deposit is deposited in value table, pays attention to needing preservation one per data
Individual row unique designation, and corresponding table structure unique designation, interface such as Fig. 3 of data manipulation is carried out to data structure definition table
It is shown.
Wherein, it is some the basic finance for sorting out user when user of service carries out data inputting to each field
Master data element, in input system, the base defined in the first step then can be then used in definition data structure
Notebook data element, and the data structure being created that includes title, field, type etc., after creating data structure, then it can carry out pair
The data manipulation answered, including increase, delete, change, look into, it is for a user, consistent with common table structure application method.
From the foregoing, it will be observed that the present invention a kind of visual configuration data structure method in, by traditional approach by exploit person
These data structure customized developments that member is carried out, turn to configure completion step by step by the business personnel for being familiar with financial savvy, so as to
Reduce the learning time of developer, improve development efficiency, while table structure can be increased newly at any time, improve system
Telescopic joint and applicability.
It is understood that the principle that embodiment of above is intended to be merely illustrative of the present and the exemplary implementation that uses
Mode, but the invention is not limited in this.For those skilled in the art, the essence of the present invention is not being departed from
In the case of refreshing and essence, various changes and modifications can be made therein, and these variations and modifications are also considered as protection scope of the present invention.
Claims (5)
- A kind of 1. method of visual configuration data structure, it is characterised in that comprise the steps of：A. the basic data element storehouse being made up of some basic datas is created；B. data structure definition table is created, the data structure definition table is used for the basic category for preserving the data structure for needing to configure Property and need field；C. create and deposit value table, the value of field in the table for depositing value table for storing all table structures；D. financial master data element is sorted out and by financial master data element input system and definition data structure.
- 2. the method for a kind of visual configuration data structure according to claim 1, it is characterised in that in the step A When creating basic data element storehouse, the data type of each basic data need to be determined, wherein, the data type is at least divided into word Symbol, numeral, enumerate.
- 3. the method for a kind of visual configuration data structure according to claim 1, it is characterised in that in the step B Data structure definition table in the foreign key field comprising major key for preserving infrastructure elements storehouses and one preserve data structure and determine The uniqueness mark of the definition structure of adopted table.
- 4. the method for a kind of visual configuration data structure according to claim 1, it is characterised in that in the step C The table deposited in value table in field include the incidence relation of each basic data, the uniqueness of data line in data structure definition table Mark, data structure table define the incidence relation and the corresponding value of each field of field.
- 5. the method for a kind of visual configuration data structure according to claim 1, it is characterised in that in the step D During definition data structure, the data structure being created that comprises at least title, field, the type of data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711001413.1A CN107766519B (en) | 2017-10-24 | 2017-10-24 | Method for visually configuring data structure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711001413.1A CN107766519B (en) | 2017-10-24 | 2017-10-24 | Method for visually configuring data structure |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107766519A true CN107766519A (en) | 2018-03-06 |
| CN107766519B CN107766519B (en) | 2021-01-26 |
Family
ID=61269509
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711001413.1A Active CN107766519B (en) | 2017-10-24 | 2017-10-24 | Method for visually configuring data structure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107766519B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110413620A (en) * | 2019-07-31 | 2019-11-05 | 四川长虹电器股份有限公司 | Visualized data structure configuration method and system |
| CN110971974A (en) * | 2019-12-06 | 2020-04-07 | 北京小米移动软件有限公司 | Configuration parameter creating method, device, terminal and storage medium |
| CN112508667A (en) * | 2020-12-08 | 2021-03-16 | 安徽经邦软件技术有限公司 | Financial data analysis system based on cloud native micro-service architecture |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040243593A1 (en) * | 2003-06-02 | 2004-12-02 | Chris Stolte | Computer systems and methods for the query and visualization of multidimensional databases |
| CN1773453A (en) * | 2004-11-10 | 2006-05-17 | 东软集团有限公司 | System constituting method based on data definition |
| CN107273104A (en) * | 2016-04-08 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of configuration data structure |
-
2017
- 2017-10-24 CN CN201711001413.1A patent/CN107766519B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040243593A1 (en) * | 2003-06-02 | 2004-12-02 | Chris Stolte | Computer systems and methods for the query and visualization of multidimensional databases |
| CN1773453A (en) * | 2004-11-10 | 2006-05-17 | 东软集团有限公司 | System constituting method based on data definition |
| CN107273104A (en) * | 2016-04-08 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of configuration data structure |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110413620A (en) * | 2019-07-31 | 2019-11-05 | 四川长虹电器股份有限公司 | Visualized data structure configuration method and system |
| CN110971974A (en) * | 2019-12-06 | 2020-04-07 | 北京小米移动软件有限公司 | Configuration parameter creating method, device, terminal and storage medium |
| CN110971974B (en) * | 2019-12-06 | 2022-02-15 | 北京小米移动软件有限公司 | Configuration parameter creating method, device, terminal and storage medium |
| CN112508667A (en) * | 2020-12-08 | 2021-03-16 | 安徽经邦软件技术有限公司 | Financial data analysis system based on cloud native micro-service architecture |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107766519B (en) | 2021-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Welsh | Dealing with data: Using NVivo in the qualitative data analysis process | |
| CN103810196B (en) | The method that database performance measurement is carried out based on business model | |
| CN105094707B (en) | A kind of data storage, read method and device | |
| Gilbert | Simulation: A new way of doing social science | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| CN103177329B (en) | Rule-based determination and checking in business object processing | |
| CN110633364A (en) | Graph database-based food safety knowledge graph construction method and display mode | |
| CN107644286A (en) | Workflow processing method and device | |
| CN102122280B (en) | Method and system for intelligently extracting content object | |
| EP2463790A1 (en) | Manipulation of elements and their attributes in graphical user interfaces | |
| CN103617047A (en) | Method, device and processor for developing business processes | |
| CN103810150A (en) | Automatic relation nestable questionnaire generating method and device | |
| CN107766519A (en) | A kind of method of visual configuration data structure | |
| CN108536718A (en) | A kind of method and system for the IT application in management realized based on input and output semantization | |
| CN105279255A (en) | Utilization method of structured teaching resources of knowledge and skill dependency relationship | |
| US20140229222A1 (en) | Integrated project planning and management application | |
| Newton | Minitab cookbook | |
| CN104866598A (en) | Heterogeneous database integrating method based on configurable templates | |
| CN104182226B (en) | A kind of General Mobile information system adaptation method and device | |
| CN107943455A (en) | A kind of list rendering system based on JSON data formats | |
| CN108153754A (en) | A kind of data processing method and its device | |
| CN104199648B (en) | A kind of General Mobile information system adaptation method and device | |
| CN109522336A (en) | A kind of decision analysis system and method based on E-government Intranet information resources | |
| CN105474208A (en) | Document-based search with facet information | |
| CN106156352A (en) | Visual content management method and system |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |