CN101436129A - Method for centralized managing basic information - Google Patents
Method for centralized managing basic information Download PDFInfo
- Publication number
- CN101436129A CN101436129A CNA2008101604516A CN200810160451A CN101436129A CN 101436129 A CN101436129 A CN 101436129A CN A2008101604516 A CNA2008101604516 A CN A2008101604516A CN 200810160451 A CN200810160451 A CN 200810160451A CN 101436129 A CN101436129 A CN 101436129A
- Authority
- CN
- China
- Prior art keywords
- data
- information
- coding
- string
- function
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a centralized management method for basic information, which is characterized in that centralized storage codes and name key item information are adopted to dispersedly store personalized information, so as to realize a centralized distribution application mode of enterprise information management; the input of other systems is shielded by establishing code/name input limiting technique in dispersed storage; the deletion and modification of code/name information in centralized storage are limited by quoting authorization technique; data centralization and dispersed unification and centralized management on basic information are realized; data input function is utilized to realize the input and adjustment of data coding information of an information center; code adjustment is limited by limit rule modification, that is, the data modification of a data center is limited by the data using condition in every distribution system; checking algorithm adopts a mode of stopping immediately after checkout; and checking is performed according to a path of checking first and then quoting, and processing is performed according to the algorithm that no checking is performed without quoting, thereby reducing invalid operation to minimum, ensuring high checking efficiency and ensuring the quoting flexibility of the distribution systems at the same time.
Description
Technical field
The present invention relates to a kind of Computer Applied Technology, use towards amateur or professional and technical personnel, can realize single enterprise software system associating fast by this technology, the digital coding standard between unified cartel, the while is not lost the flexible and applicability in inside of each system.
Background technology
Domestic a lot of outstanding management software products are applicable to that independent legal person enterprise uses, and at present a lot of group of enterprises carry out professional centralized management.The important prerequisite of centralized management is that all relevant enterprises adopt identical coding schemes, and coding information quantity is big, involves a wide range of knowledge, must be by the good technical means, and, just may realize the unification of encoding in conjunction with the realistic situation of business administration.Continue on the one hand for this reason the single business management software of performance advantage, the digital coding standard unification with relevant enterprise becomes a problem that urgency is to be solved on the other hand.
Summary of the invention
The objective of the invention is to overcome the deficiencies in the prior art, a kind of enterprise software that will be associated unified technology of encoding is provided, fully guarantee the continuation performance of the advantage function of original system simultaneously.
The objective of the invention is to realize in the following manner:
1) utilize the data hold function to realize the configuration of information center and dispersed information storage.
Type, address, log-on message, table prefix information, physical meaning information by tables of data recorded information source;
By allocation list storage data center sign, data center address;
Row, reading and writing by the authorization list configuration information, look into authority;
By the translation of statement translation realization original statement, realize the same script visit in data transinformation source;
Realize the configuration of the mutual verification relation of data by revising the verification configuration;
Realize priginal soft information input inefficacy by the import-restriction configuration, realize information source control.
2) utilize the data input function to realize information center's digital coding information input and adjust.Coding adjustment is subject to the modification restriction rule, and promptly data center's data modification is subject to the operating position of data in each compartment system.Check algorithm adopts the mode of promptly stopping that detects, by after quote and check not have route inspection to quote and do not check algorithm process earlier, invalid computing drops to minimum, verification efficient height guarantees that simultaneously compartment system quotes dirigibility.
3) be beneficial to data and introduce the foundation of function realization distributed data system coding.In separate data is quoted, adopt the data local cache, and merge filtering technique, realize reference data high-rate fitration, locate introducing information fast.The group string mode that buffer memory adopts biconditional operation query statement, operator, service data source to be correlated with mates, and reaches the recovery of transparent processing buffer memory.Filter algorithm adopts first quicksort, deque order way of contrast then, and the mating information buffer memory significantly promotes operating speed.The concrete operations item has:
Data download: after choosing, can download data to this locality, when opening, read local data earlier next time, not have the reading of data centre data as local data.
Refresh data: read up-to-date data from data center, data center's The data timestamp management.
Filtering data: from current tabulation, filter out the material content that has had.
Shortcut: can navigate to by alphabetical D and to search in the window, after the content that input is wanted to search, the data presentation that system will contain relevant information automatically after the carriage return is come out.After input space or the empty string, can cancel filtration.
4) be beneficial to item of information authority configuring technical, realize the unification and the Decentralization of concentrated message and dispersed information.Coding, the discrete management of title critical item information of same service attribute have guaranteed the dirigibility of unitarity with the business of coding, adapt to enterprise and use.
Of the present invention have function and a beneficial effect
1. towards the user of service, set up enterprise software associating use-pattern, can save enterprise and software development company and invest, keep simultaneously single business management software swift to operate, use advantage flexibly.
2. provide coded message center configuration, verification configuration, data to connect configuration management function, can make the user finish the foundation of application runtime environment.
3. provide coding to set up, encode and quote management function, can make the user finish the foundation and the daily use of company numbering.
4. by using this technology, improvement company standard management work that can be good by incremental, is selectively used coding, has unified coding on the one hand, and it is excessive also to have reduced certain company numbering amount on the other hand, operates cumbersome drawback.
5. by the control of authority mode in the technology, can guarantee effectively that the complete of coded message is with unified.
6. by the rule of quoting in the technology, the coding scheme that enterprise's original system is set up can be made full use of,, unified coding scheme can be effectively set up by the arrangement and the filtration of system.
Embodiment
Operating personnel by the mode of interface operation, realize operation accordingly by the software of this technology of employing is installed, and the major technique operation has:
1. finishing data center's storage environment sets up.
2. the decentralized data storage data connect, and are used in reference to each divided data storage.
3. data grant, it is right that each operates the user
4. data check relation configuration.
5. standard code and title foundation are set up in data center's storage.
6. decentralized data storage has the reference data of selection centre code.
The main program assembly:
1, data connect configuration component: w_wd_wdcxdb
Common way:
public?function?integer?wf_check_data()
Public function integer of_check_connect () communication method using common:
Corresponding tables of data
CREATE?TABLE?WDCXDB(
F_ID VARCHAR (10) NOT NULL ,/* be used for unique identification corresponding database numbering */
It is database where that F_NAME VARCHAR (100) NOT NULL ,/* are used to indicate, generally indicate the title * of factory/
F_TYPE VARCHAR (20) NOT NULL ,/* be used to indicate the type of database: ORACLE/SYC/MSS/ODBC*/
The connection configuration * of the server that F_SER VERVARCHAR (60) NOT NULL ,/* are used to indicate database on current machine/
F_DATABASE VARCHAR (60) NOT NULL ,/* be used to indicate be which database */
F_LOGID VARCHAR (60) NOT NULL/* login people */
F_PASSWORD VARCHAR (30) NULL ,/* login password */
F_BZ VARCHAR(200) NULL)
Go
2, public data coupling assembling: n_cst_wd_multi_database
Static variable:
// be used to store the corresponding database link information.When creating object, set up.
datastore?ids_db
// be used to indicate the concrete buffer zone that is connected with each database.
// when creating object, set up, get up with data consistent among the IDS_DB, but have only when use just to connect.
transaction?itr_db[]
// whether each affairs connects when being used in reference to sign
boolean?ib_iscon[]
// be used to carry out example count
long?il_ins_count
If // log-on message on being used to historify during information inconsistency, does not allow to carry out next step processing
string?is_logininfo
Communication method using common:
public?function?integer?of_exec_pre(string?as_id,string?as_arg[],stringas_data[])
public?function?integer?of_exec_sql(string?as_syntax)
public?function?long?of_get_database(stringas_string,ref?stringas_database[])
public?function?string?of_parse_xml_node(string?as_string,string?as_node)
public?function?BOOLEAN?of_lock(STRING?AS_ID,BOOLEAN?AB_LOCK)
public?function?integer?of_create_datastore(string?as_sql,ref?datastore?ads,transaction?atr,boolean?ab_update,string?as_table)
public?function?integer?of_connect(string?as_dbid,boolean?ab_con,reftransaction?atr)
public?function?string?of_get_sql(string?as_id)
public?function?string?of_set_sql(string?as_id,string?as_sql)
public?function?STRING?of_format_string_name(STRING?AS_OLD)
private?function?integer?of_initial_connect(long?al_id)
private?function?integer?of_di?sconnect(long?al_pos)
public?function?string?of_get_prefix(string?as_dbid)
public?function?string?of_get_prefix_for_group_db()
public?function?string?of_get_current_group_dbld()
public?function?BOOLEAN?of_group_is_center()
public?function?integer?of_check_delete(string?as_checkname,string?as_id,refstring?as_msg)
public?function?integer?of_group_get_wlzd_self_st(ref?string?as_column,refstring?as_text,transaction?atr)
public?function?string?of_change_sql_table_prefix(string?as_sql,stringas_prefix)
public?function?long?of_get_sql_key_pos(string?as_sql,string?as_key,longal_from)
public?function?integer?of_exists(string?as_table,string?as_where,transaction?atr,string?as_prefix)
public?function?integer?of_group_get_wldw_self_st(ref?string?as_column,refstring?as_text,transaction?atr)
3, public data is introduced assembly: w_pub_select_muldatabase
Communication method using common:
public?function?integer?wf_set_one()
public?function?integer?wf_set_search()
public?function?integer?of_gen_sele_dw(string?as_sql,string?as_text,datawindow?adw)
public?function?string?of_create_find(datawindow?adw,string?as_item)
public?function?integer?of_read_local_buf(datawindow?adw)
public?function?string?of_get_data_file(datawindow?adw,boolean?ab_add)
public?function?integer?of_add_local_buf(datawindow?adw)
public?function?integer?of_del_local_buf(datawindow?adw)
public?subroutine?of_post_show_time()
private?function?string?of_create_find_single(datawindow?adw,string?as_item)
4, common operation log processing assembly: n_cst_pub_wdmodifyrecord
Communication method using common:
public?function?string?of_get_DATETIME()
public?function?integer?of_record(datawindow?adw_resource,long?al_row,stringas_table,string?as_ttext,string?as_id)
public?function?integer?of_delete(string?as_table,string?as_ttext,stringas_id)
public?function?integer?of_save()
public?function?integer?of_insert(strlng?as_table,string?as_ttext,stringas_id)
public?function?integer?of_reset()
public?function?integer?of_show(string?as_table,string?as_id)
public?function?string?of_get_value(string?as_values,string?as_v)
5, configuration component: w_group_set_config
Communication method using common:
public?function?integer?of_set_center()
public?function?integer?of_get_right()
public?function?integer?of_set_group_center()
public?function?integer?of_set_checklist()
The present invention has effectively solved company standard information centralized management, disperses the requirement of using, and the bookkeeping flow process of using after this technology is unobstructed, easy to use, has made full use of the advantage of original single business management software simultaneously, has a good application prospect.
Embodiment:
Method of the present invention has successfully been tried out in the information-based project of Shandong pharmacy, by using, has realized the use in conjunction of tide ERP-PS management software, has guaranteed that the coded message of whole group is unified, the effect of application distribution.Effectively improved simultaneously the standard management of enterprise.
Claims (2)
1, a kind of method of Back ground Information centralized management, it is characterized in that, adopt centralized stores coding, title critical item information, disperse the storage customized information, realize the concentrated distribution applications pattern of enterprise information management, by in disperseing storage, setting up the import-restriction technology of coding, title, the input of shielding other system, authorization technique limits the coding in the centralized stores, the deletion and the modification of name information by reference; Realize data centralization and disperse unified and the Back ground Information centralized management that concrete steps are as follows:
1) utilize the data hold function to realize the configuration of information center and dispersed information storage;
Type, address, log-on message, table prefix information, physical meaning information by tables of data recorded information source;
By allocation list storage data center sign, data center address;
Row, reading and writing by the authorization list configuration information, look into authority;
By the translation of statement translation realization original statement, realize the same script visit in data transinformation source;
Realize the configuration of the mutual verification relation of data by revising the verification configuration;
Realize priginal soft information input inefficacy by the import-restriction configuration, realize information source control;
2) utilize the data input function to realize information center's digital coding information input and adjust, coding adjustment is subject to the modification restriction rule, it is the operating position that data center's data modification is subject to data in each compartment system, check algorithm adopts the mode of promptly stopping that detects, by after quote and check earlier not have route inspection to quote and do not check algorithm process, invalid computing drops to minimum, verification efficient height guarantees that simultaneously compartment system quotes dirigibility;
3) be beneficial to data and introduce the foundation of function realization distributed data system coding, in separate data is quoted, adopt the data local cache, and fusion filtering technique, realize reference data high-rate fitration, locate introducing information fast, the group string mode that buffer memory adopts biconditional operation query statement, operator, service data source to be correlated with mates, reach the recovery of transparent processing buffer memory, filter algorithm adopts first quicksort, deque order way of contrast then, mating information buffer memory, significantly promote operating speed, the concrete operations item has:
Data download: after choosing, can download data to this locality, when opening, read local data earlier next time, not have the reading of data centre data as local data;
Refresh data: read up-to-date data from data center, data center's The data timestamp management;
Filtering data: from current tabulation, filter out the material content that has had;
Shortcut: navigate to by alphabetical D and to search in the window, after the content that input is wanted to search, the data presentation that system will contain relevant information automatically after the carriage return is come out, and cancellation is filtered after input space or the empty string;
4) be beneficial to item of information authority configuring technical, realize the unification and the Decentralization of concentrated message and dispersed information, coding, the discrete management of title critical item information of same service attribute have guaranteed the dirigibility of unitarity with the business of coding, adapt to enterprise and use.
2, in separate data is quoted, adopt the data local cache, and the fusion filtering technique, realize reference data high-rate fitration, locate introducing information fast, the group string mode that buffer memory adopts biconditional operation query statement, operator, service data source to be correlated with mates, reach the recovery of transparent processing buffer memory, filter algorithm adopts first quicksort, then deque's order way of contrast, the mating information buffer memory significantly promotes operating speed.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2008101604516A CN101436129A (en) | 2008-11-18 | 2008-11-18 | Method for centralized managing basic information |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2008101604516A CN101436129A (en) | 2008-11-18 | 2008-11-18 | Method for centralized managing basic information |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101436129A true CN101436129A (en) | 2009-05-20 |
Family
ID=40710578
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNA2008101604516A Pending CN101436129A (en) | 2008-11-18 | 2008-11-18 | Method for centralized managing basic information |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101436129A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101727505A (en) * | 2010-02-03 | 2010-06-09 | 中兴通讯股份有限公司 | Efficient data processing method and device |
CN102402730A (en) * | 2010-09-15 | 2012-04-04 | 金蝶软件(中国)有限公司 | Dynamic business data distribution method and system |
CN102664758A (en) * | 2012-04-28 | 2012-09-12 | 沈阳通用软件有限公司 | Method for binding and automatically recovering network configuration |
-
2008
- 2008-11-18 CN CNA2008101604516A patent/CN101436129A/en active Pending
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101727505A (en) * | 2010-02-03 | 2010-06-09 | 中兴通讯股份有限公司 | Efficient data processing method and device |
CN102402730A (en) * | 2010-09-15 | 2012-04-04 | 金蝶软件(中国)有限公司 | Dynamic business data distribution method and system |
CN102664758A (en) * | 2012-04-28 | 2012-09-12 | 沈阳通用软件有限公司 | Method for binding and automatically recovering network configuration |
CN102664758B (en) * | 2012-04-28 | 2015-03-25 | 沈阳通用软件有限公司 | Method for binding and automatically recovering network configuration |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7792793B2 (en) | Data export/import from multiple data source to a destination data repository using corresponding data exporters and an importer | |
Devlin et al. | An architecture for a business and information system | |
US7401094B1 (en) | Automated generation of dynamic data entry user interface for relational database management systems | |
US6502088B1 (en) | Method and system for improved access to non-relational databases | |
Shu et al. | Specification of forms processing and business procedures for office automation | |
CN102567539B (en) | Intelligent WEB report implementation method and intelligent WEB report implementation system | |
US20090287737A1 (en) | Architecture for enabling rapid database and application development | |
US7958031B2 (en) | Apparatus, system, and method for automated identity relationship maintenance | |
US20090276717A1 (en) | Integrated deployment of software projects | |
US20070220065A1 (en) | Method, system, and product for maintaining software objects during database upgrade | |
CN107145480B (en) | Method for compiling XBRL report based on Word | |
CN110069246A (en) | The plateform system and its application that a kind of Java Web application is quickly developed | |
CN101706716A (en) | VO-based form customization, configuration and parsing operation method | |
CN104517181B (en) | Enterprise content management system and method for nuclear power station | |
CN100517229C (en) | Data version upgrading method | |
CN103077019A (en) | Batch maintenance method and device for graphical parameters | |
CN101403967A (en) | Interface preservation and indication method, client terminal and server | |
CN101436129A (en) | Method for centralized managing basic information | |
CN101706823B (en) | Inquiry system and method of customized database | |
CN111241065A (en) | Security multi-compatibility lightweight database adaptation development and operation device supporting domestic database | |
CN101174204A (en) | Device for upgrading data version | |
CN113190218A (en) | Target operation function generation method and device | |
US20040139087A1 (en) | Method, computer program product and article of manufacture for providing service-to-role assignment to launch application services in role-based computer system | |
AU2019203420A1 (en) | A method of tracing or tracking changes in data | |
CN115907938A (en) | Financial management system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Open date: 20090520 |