CN101311926B - Notes data structuring system and method - Google Patents
Notes data structuring system and method Download PDFInfo
- Publication number
- CN101311926B CN101311926B CN2007102006835A CN200710200683A CN101311926B CN 101311926 B CN101311926 B CN 101311926B CN 2007102006835 A CN2007102006835 A CN 2007102006835A CN 200710200683 A CN200710200683 A CN 200710200683A CN 101311926 B CN101311926 B CN 101311926B
- Authority
- CN
- China
- Prior art keywords
- data
- notes
- domino
- server
- type
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention provides a system for structuring Notes data, which is used for transforming unstructured data input to the Domino server into structured data. The system comprises a data transformation server which connects the Domino server and an application system layer, and the data transformation server comprises: a document-type data receiving module, which is used for receiving the unstructured data from the Domino server; a data type transformation module, which is used for carrying out the transformation of data type to the received data so as to allow the data in the established datastructure to comply with the standard of a relation database; a data structured module, which is used for taking out the data, the type of which is transformed, the data taken out is encapsulated, independent objects are produced one by one, and the demanded data structure is established; an output module, which is used for outputting the structured data to the application system layer. A method for structuring Notes data is disclosed either. The system simplifies the Notes data structured system, reduces the flow distance and conversion times of the input data, thus reducing the ratio of data distortion.
Description
Technical field
The present invention relates to a kind of data structure system and method, especially refer to the data structure system and method for Notes.
Background technology
Data dealing between Notes and the Domino server in the past all is earlier data to be imported into relevant database, utilizes relevant database to carry out the analysis and the arrangement of data then, perhaps gives other system with the data support.Consulting shown in Figure 1ly, is traditional Notes and the communications rack composition between the Domino server.Data typing user 14 is with data typing Domino server 130, import remittance abroad program 131 by data the document-type data are exported to relevant database 132 from this Domino server 130, analyze and put in order by 132 pairs of the document types of this relevant database data, send to the system in the application system level 11 again, as web application 110, ERP (Enterprise Resource Planning) (ERP, Enterprise Resource Planning) 111, TIPTOPl 12 uses, finally be presented on these systems use user 10 in face of.
The shortcoming of this conventional architectures is that the structure of Data support is too complicated, and data use the distance between user's 10 uses long from being entered into by data typing user 14 by system, cause the probability raising of data distortion etc.
Therefore be necessary to provide a kind of system and method that can address the above problem.
Summary of the invention
The invention provides a kind of system of Notes data structureization, be used for converting the user to structural data to the unstructured data of Domino server typing.This system comprises data conversion server, and this data conversion server connects Domino server and application system level.
Wherein this data conversion server comprises: the document-type data reception module is used for receiving unstructured data from the Domino server; The data type conversion module is used for the data of above-mentioned reception are carried out the conversion of data type so that the standard of the data fit relational database of the data structure of setting up; The data structure module is used for the above-mentioned data of changing type are taken out, and uses OO notion that the data that obtain are encapsulated, and produces one by one independently object, sets up needed data structure then; And output module, be used for these structurized data are outputed to application system level, for other system use or carry out graphical treatment.
The present invention also provides a kind of method of Notes data structureization, and this method converts the unstructured data that the user is entered in the Domino server to structural data, and the method comprising the steps of: the typing unstructured data is to the Domino server; Data conversion server receives described unstructured data from this Domino server; The unstructured data type conversion that is received is become to meet the data type of relational database data structure standard; Take out above-mentioned data, the data that obtain are encapsulated, produce standalone object one by one, set up needed data structure then through type conversion; Should structurized data output to application system level, and use or carry out graphical treatment for other system.
See also Fig. 1 and Fig. 2 as can be known, utilize the system and method for Notes data structureization provided by the present invention, following advantage is arranged: simplified original system architecture of carrying out the Notes data structureization, the system of application system level directly provides structurized data by Notes/Domino; Reduce relevant database, therefore reduced a remittance program and remittance abroad program; Reduce distance and conversion times that logging data is flowed, therefore reduced the probability of data distortion; Data support is simple and clear.
Description of drawings
Fig. 1 is the system architecture diagram that carry out data structure conversion of the data structureization of Notes at traditional approach.
Fig. 2 is the system architecture diagram of the data structure system preferred embodiment of Notes of the present invention.
Fig. 3 is the functional block diagram of data conversion server of the present invention.
Fig. 4 is the process flow diagram of Notes data structure method of the present invention.
Embodiment
Consulting shown in Figure 2ly, is the system architecture diagram of the data structure system preferred embodiment of Notes of the present invention.Data typing user 14 can be the user side of Lotus Notes, also can be the browser client end.Domino server 130 logging datas of this data typing user 14 in Data support 13.The data of this typing are stored in the document database of Domino server 130.
The document database is the non-relational database, and it uses non-structured data element based on the file organization pattern.Therefore, in the document database, the data message that data typing user 14 submits to is that the form with document is kept in the database, for example, and a official document.A document (Document) is equivalent to a record in the relevant database.Wherein, non-structured data are the information that can't represent with numeral or unified structure, for example image etc.These unstructured datas both can be one section Word messages that comprises a large amount of additional informations (as composition information), and image blend information also may be one section image or even image.On the contrary, structurized data can be represented with data or unified structure.For example, cost, expense, personnel, wage and employee performance etc. can be described or represent with numeral or literal.Such data have identical level or network structure, are referred to as structural data.Unstructured data comprises structural data, but structural data not just; Structural data belongs to unstructured data, is the special case of unstructured data.
In this preferred embodiment, this data typing user 14 is Notes user sides.This data typing user 14 sets up being connected of Notes and Domino server by ODBC (OpenDatabaseConnectivity, Open Database Connection) or Diiop (Domino Internet Inter-ORBProtocol).
If link, require to set up ODBC-Notes and link program, and user side is configured at user side by ODBC.Do not need like this Domino server is configured, will drop to minimum yet the influence of Domino server.User side can use standard SQL sentence to carry out data access, and is easy to use.But binding speed is slow, is unfavorable for setting up the Buffer Pool of data.
If link, require at the open Diiop port of Diiop server end, if there is fire wall also to need to open by Diiop.Client also must be configured simultaneously, needs to use specific API (Application ProgrammingInterface, application programming interface) call format to conduct interviews.But binding speed is fast, can set up the data buffering pond of oneself.
Wherein, be stored in by data typing user 14 typings that data are non-structured in the described document database, texture ratio is chaotic, need utilize the formula of Notes/Domino that the data of above-mentioned typing are carried out pre-service by setting up special-purpose view and file in the Domino server.These pre-service comprise the filtration of data, the validation verification of data, to alleviate the computational burden of down-stream.As set up the view of a special use, utilize the formula of Notes/Domino that needed document data in the document database is concluded in this view again, and in formula, do to filter and the data validity processing.
This Domino server 130 sends to data conversion server 12 after the unstructured data of above-mentioned institute typing is carried out pre-service.This data conversion server 12 carries out structuring with described pretreated data, and the data after the structuring are outputed to application system level 11, and supply is used with the use user 10 of system in the system layer 11.System in this application system level 11 comprises web application 110, ERP (Enterprise Resource Planning) (ERP, Enterprise Resource Planning) 111 and TIPTOP112.
Consult shown in Figure 3ly, be the functional block diagram of data conversion server of the present invention.This data conversion server 12 comprises document-type data reception module 120, data type conversion module 121, data structure module 122 and output module 123.
The document type data reception module 120 is used for receiving pretreated unstructured data from Domino server 130.
This data type conversion module 121 is used for the data of above-mentioned reception are carried out the conversion of data type so that the standard of the data fit relevant database of the data structure of setting up makes things convenient for other language to use.Conversion as date data type, monetary data type and RichText field.
This data structure module 122 is used for the above-mentioned document-type data of changing type are taken out, and uses OO notion that the data that obtain are encapsulated, and produces independently object one by one, set up needed data structure then, as Array, Hashtable, Tree etc.Particularly, this data structure module 122 is set up earlier the class of oneself according to demand, and such structure upwards illustrates the data structure of Domino, will produce the needed data structure of user downwards.Data structure module 122 is taken out above-mentioned data again, and each data are put in each self-corresponding class, produces standalone object one by one.Utilize object to set up needed data structure then, as Array, Hashtable, Tree etc., also i.e. Array data structure if desired just is put into the above-mentioned object that produces in the structure of Array correspondence.The process of this data encapsulation also is the process that document data is reconstructed.In this process, document data and object are combined closely.Each node in the data structure that is produced is a document in the document database just.Like this data in follow-up use with data source in data kept consistent.
This output module 123 is used for these structurized data are outputed to application system level 11, is used for other system or carries out graphical treatment.
Consulting shown in Figure 4ly, is the process flow diagram of the data structure method of Notes of the present invention.
Step S400, the binding of setting up Notes/Domino by ODBC or Diiop.Data typing user 14 is in its user side enters data into document database in the Domino server 130.The data of above-mentioned typing are stored in the document database in Domino server 130.This Domino server 130 carries out pre-service to these data, comprises data filter, Validation of Data.For example, set up the view of a special use, utilize the formula of Notes/Domino that needed document data in the document database is concluded in this view again, and in formula, do to filter and the data validity processing.
Step S402, document-type data reception module 120 receives the above-mentioned pretreated data that Domino server 130 sends over.
Step S404, data type conversion module 121 becomes to meet the data type of relational database data standard with above-mentioned pretreated data type conversion, uses to make things convenient for other language.Conversion as date data type, monetary data type and RichText field.
Step S406, elder generation sets up the class of oneself according to demand, and such structure upwards illustrates the data structure of Domino, will produce the needed data structure of user downwards.Data structure module 122 is taken out above-mentioned data, uses OO notion that the data that obtain are encapsulated, and just each obtained data is put in each self-corresponding class, just produces standalone object one by one.Utilize object to set up needed data structure then, as Array, Hashtable, Tree etc., also i.e. Array data structure if desired just is put into the above-mentioned object that produces in the structure of Array correspondence.The process of this data encapsulation also is the process that document data is reconstructed.In this process, document data and object are combined closely.A document in the just above-mentioned document database of each node in the data structure that is produced like this, make data in follow-up use and the data in the data source be consistent.
Step S408, output module 123 output to the data of said structureization that the use user 10 for these systems uses in the system in the application system level 11.Wherein system comprises web application 110 in the application system level 11, ERP111 and TIPTOP112.This structural data of exporting can carry out graphical treatment for these systems.
Claims (8)
1. the system of a Notes data structureization, run in the data conversion server, be used for converting unstructured data to structural data, this data conversion server connects Domino server and application system level, this Domino server is used to set up special-purpose view and file, the formula that utilizes Notes/Domino carries out pre-service to the unstructured data of user's typing, pretreated data are sent to data conversion server, this pre-service comprises data filter and validation verification, it is characterized in that the system of this Notes data structureization comprises:
The document-type data reception module is used for receiving pretreated data from the Domino server;
The data type conversion module is used for the pretreated data of above-mentioned reception are carried out the conversion of data type so that the standard of the data fit relational database of the data structure of setting up;
The data structure module is used for the above-mentioned data of changing type are taken out, and uses OO notion that the data that obtain are encapsulated, and produces one by one independently object, sets up needed data structure then; And
Output module is used for these structurized data are outputed to application system level, uses or carries out graphical treatment for other system.
2. the system of Notes data structureization as claimed in claim 1, it is characterized in that, described data structure module also is used for setting up class according to demand earlier, and such structure upwards illustrates the data structure of Domino, will produce the needed data structure of user downwards.
3. the system of Notes data structureization as claimed in claim 1 is characterized in that, described user is the binding of setting up Notes/Domino by the mode of ODBC to the logging data of Domino server.
4. the system of Notes data structureization as claimed in claim 1 is characterized in that, described user is the binding of setting up Notes/Domino by the mode of Diiop to the logging data of Domino server.
5. the method for a Notes data structureization, this method converts the unstructured data that the user is entered in the Domino server to structural data, it is characterized in that, and this method comprises:
The typing unstructured data is to the Domino server;
The Domino server is set up special-purpose view and file, utilizes the formula of Notes/Domino that above-mentioned unstructured data is carried out pre-service, and pretreated data are sent to data conversion server, and this pre-service comprises data filter and validation verification;
Data conversion server receives described pretreated data from this Domino server;
The pretreated data type conversion that is received is become to meet the data type of relational database data structure standard;
Take out above-mentioned data, the data that obtain are encapsulated, produce standalone object one by one, set up needed data structure then through type conversion;
Should structurized data output to application system level, and use or carry out graphical treatment for other system.
6. the method for Notes data structureization as claimed in claim 5 is characterized in that, this method also comprises step:
The binding of setting up Notes/Domino by the mode of ODBC is with to the logging data of Domino server.
7. the method for Notes data structureization as claimed in claim 5 is characterized in that, this method also comprises step:
The binding of setting up Notes/Domino by the mode of Diiop is with to the logging data of Domino server.
8. the method for Notes data structureization as claimed in claim 5, it is characterized in that the data type and above-mentioned the process between the data of type conversion of taking-up that become to meet relational database data structure standard in the pretreated data type conversion that will be received also comprise:
Set up class according to demand, such structure upwards illustrates the data structure of Domino, will produce the needed data structure of user downwards.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007102006835A CN101311926B (en) | 2007-05-23 | 2007-05-23 | Notes data structuring system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007102006835A CN101311926B (en) | 2007-05-23 | 2007-05-23 | Notes data structuring system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101311926A CN101311926A (en) | 2008-11-26 |
| CN101311926B true CN101311926B (en) | 2011-01-05 |
Family
ID=40100574
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007102006835A Expired - Fee Related CN101311926B (en) | 2007-05-23 | 2007-05-23 | Notes data structuring system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101311926B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104240128A (en) * | 2013-06-09 | 2014-12-24 | 黄柯 | Fixed-income security quoted price information exhibiting and interacting method and system |
| CN104346334A (en) * | 2013-07-23 | 2015-02-11 | 上海化工宝电子商务有限公司 | Remote visual interface database system |
| CN104778165A (en) * | 2014-01-09 | 2015-07-15 | 山西太钢不锈钢股份有限公司 | Design method of Domino platform system and relational database system integration |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1537285A (en) * | 2001-08-03 | 2004-10-13 | �ʼҷ����ֵ��ӹɷ�����˾ | Method and system for updating document |
| EP1480138A1 (en) * | 2000-06-14 | 2004-11-24 | Matsushita Electric Industrial Co., Ltd. | Data processing apparatus and data processing method |
-
2007
- 2007-05-23 CN CN2007102006835A patent/CN101311926B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1480138A1 (en) * | 2000-06-14 | 2004-11-24 | Matsushita Electric Industrial Co., Ltd. | Data processing apparatus and data processing method |
| CN1537285A (en) * | 2001-08-03 | 2004-10-13 | �ʼҷ����ֵ��ӹɷ�����˾ | Method and system for updating document |
Non-Patent Citations (1)
| Title |
|---|
| JP特开2004-280785A 2004.10.07 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101311926A (en) | 2008-11-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107563725B (en) | Recruitment system for optimizing fussy talent recruitment process | |
| Zozmann et al. | 100% renewable energy scenarios for North America—spatial distribution and network constraints | |
| Masip-Bruin et al. | Unlocking the value of open data with a process-based information platform | |
| CN101311926B (en) | Notes data structuring system and method | |
| CN106407471B (en) | Figure code scanning data processing method, apparatus and system | |
| CN105701182A (en) | Information pushing method and apparatus | |
| CN109766085A (en) | A kind of method and device handling enumeration type code | |
| Partida et al. | Visibility graph analysis of IOTA and IoTeX price series: an intentional risk-based strategy to use 5G for IoT | |
| Aksakalli et al. | A model-driven architecture for automated deployment of microservices | |
| Hernández-Moral et al. | Big data value chain: multiple perspectives for the built environment | |
| Lee et al. | Agile software development and reuse approach with Scrum and software product line engineering | |
| Bragolusi et al. | The willingness to pay for residential PV plants in Italy: A discrete choice experiment | |
| Shang et al. | The efficiency of the Chinese prefabricated building industry and its influencing factors: An empirical study | |
| Ye et al. | Quasi-synchronization and quasi-uniform synchronization of Caputo fractional variable-parameter neural networks with probabilistic time-varying delays | |
| Zheng et al. | An efficient and low-power design of the SM3 hash algorithm for IoT | |
| CN111191419A (en) | Excel-to-xml method and system applicable to testlink | |
| Andrei et al. | Small and medium-sized enterprises, business demography and european socio-economic model: Does the paradigm really converge? | |
| Şenkardeş | A discussion on the effects of blockchain technology within the context of sustainable development | |
| Nakazato et al. | Joining Policy Forums Together to Develop Ki-no-Eki, a Community Currency System for Forest Management in Japan: Dynamics of Policy Communication Networks | |
| Shao et al. | Non-parametric model for evaluating the performance of Chinese Commercial Banks’ product innovation | |
| CN108416572B (en) | Method for integrating insurance company insurance application processes into general insurance application process | |
| Yang et al. | A guaranteed approximation algorithm for QoS anypath routing in WMNs | |
| CN109033447B (en) | Face recognition data visualization system | |
| CN108121537A (en) | A kind of software assembly line system and its production method | |
| Gore et al. | Network calculus approach for packet delay variation analysis of multi-hop wired networks |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20110105 Termination date: 20120523 |