CN103164209A - 'Electronic patient' edit method based on combination of extensive makeup language (XML) database and relational database - Google Patents
'Electronic patient' edit method based on combination of extensive makeup language (XML) database and relational database Download PDFInfo
- Publication number
- CN103164209A CN103164209A CN2011104256884A CN201110425688A CN103164209A CN 103164209 A CN103164209 A CN 103164209A CN 2011104256884 A CN2011104256884 A CN 2011104256884A CN 201110425688 A CN201110425688 A CN 201110425688A CN 103164209 A CN103164209 A CN 103164209A
- Authority
- CN
- China
- Prior art keywords
- database
- xml
- data
- software
- electronic patient
- 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
Abstract
The invention relates to an 'Electronic patient' edit method based on combination of an extensive makeup language (XML) database and a relational database. In the aspect of a software module, a modularization development mode of high portability is adopted, and an 'electronic patient' case edit module can be transplanted to various medical teaching software and emergency system software. According to the 'Electronic patient' edit method based on combination of the XML database and the relational database, the defects in a traditional type database that query efficiency is low, maintenance is inconvenient, and development cycle is long are overcome. A data storage mode which combines the XML database and the relational database is adopted, the requirements that 'electronic patient' edit information is large, and operation speed is high are met, and a software system which is capable of effectively resolving contradiction between software operation efficiency and development efficiency and is convenient and fast in implementation process and is stable, safe and reliable.
Description
Technical field
The present invention relates to the develop computer software field, specifically refer to a kind of program developing method that is applied to first aid teaching software aspect.
Background technology
The programming language aspect:
Computing machine can not directly be understood higher level lanquage, can only directly understand machine language, so must translate into machine language to higher level lanquage, computing machine could be carried out the program of high level language.
Therefore also just having produced corresponding compiler language offers the programming personnel, and the type of interpretive language has two kinds, compiling type and explanation type, and the difference of dual mode is the just asynchronism(-nization) of translation substantially:
One, before the program that compiling type language is write is carried out, need a special compilation process, program compilation is become the file of machine language, such as the exe file, just to move later on and need not again translate, the result of directly using compiling just (exe file) because translation has only been done once, do not need translation during operation, so the executing efficiency of compiling type language is high.
Two, explanation type is different, and the program of interpreted languages does not need compiling, has economized procedure, interpreted language is just translated in working procedure, such as explanatory BASIC, there is specially an interpreter can directly carry out the basic program, when being execution, just translates each statement.The every execution of interpreted language once will be translated once like this, and efficient is lower.Explanation is the translation of.
Compiling type and explanation type, both cut both ways.The former is because program execution speed is fast, lower to system requirements under equal conditions, therefore all adopt it during as development and operation system, large-scale application program, Database Systems etc., picture C/C++, Pascal/Object Pascal (Delphi) etc. are compiler languages, but it is to just relatively stricter in developer's requirement, and the cycle of grasping from geting started to is long.And the software transportability that most of traditional compiling type language developments go out is not strong, more single to system requirements, some page scripts, server script and auxiliary development interface such not high to rate request, the program that has certain requirements of the compatibility between different system platform is used interpreted language usually, as Java, JavaScript, VBScript, Perl, Python, Ruby, MATLAB etc.
Like this, high-level efficiency has just become a kind of problem that looks contradiction with low-cost, and the problem that also has some code confidentiality is also corresponding and go out.
So in this case, if the development mode of above two types of a kind of combination is arranged, can not only shorten the process of software development and make the software of developing more efficient, have more security.
Data storage aspect:
In society, have a large amount of information datas to need storage, so the development of database technology is also with rapid changepl. never-ending changes and improvements, is broadly divided into:
Relevant database and XML database, traditional relevant database, for example SqlServer/Orcale has faced following problem on obstacle:
1, the demand of High performance-to the high concurrent reading and writing of database
The web2.0 website will generate in real time dynamic page and multidate information is provided according to user personalized information, thus basically can't use the staticize of dynamic page technology, so the database concurrency load is very high, often will reach up to ten thousand read-write requests of per second.Relational database is dealt with up to ten thousand SQL query and is also stood up to reluctantly, but deals with the SQL write data requests up to ten thousand times, and hard disk IO just can't bear.
2, Huge Storage-is to the high-level efficiency storage of mass data and the demand of access
For relational database, carry out SQL query inside the table of 2.5 hundred million records, efficient is extremely low and even insufferable.The logging in system by user of large-scale web website for example, Tengxun for example, magnificence, hundreds of millions of account number easily, relational database also is difficult to deal with.
3, High Scalability ﹠amp; ﹠amp; High Availability-is to the enhanced scalability of database and the demand of high availability
In the middle of the framework based on web, database be the most difficult carry out extending transversely, when the customer volume of an application system and visit capacity grew with each passing day, your database but had no idea simply as web server and app server to come scalability and load capacity by adding more hardware and service node.The website of 24 hours persistent services is provided for a lot of needs, and Database Systems are upgraded and expanded is very painful thing, often needs to shut down to safeguard and Data Migration.
The XMl database: the XML database is that a kind of the support stored and the data management system of the operation such as inquiry the XML format file.In system, the developer can inquire about the XML document in database, the serializing of derivation and specified format.
Compare with traditional database, the XML database has following advantage:
1, the XML database can carry out effective access and management to semi-structured data.Be exactly a kind of semi-structured data as web page contents, and traditional relational database can't effectively be managed for this class semi-structured data of similar web page contents.
2, provide operation to label and path.The traditional database language allows the value of data element is operated, and can not operate element term, and the semi-structured data storehouse provides the operation to bookmark name, has also comprised the operation to the path.
3, when data itself have level characteristics, due to the XML data layout can clear expression data level characteristics, so the XML database is convenient to the data of stratification are operated.The XML database is fit to the data set of complex management data structure, if with the XML format storage information, the XML database is beneficial to document storage and retrieval; Can be with convenient and practical mode search file, and high-quality full-text search engine can be provided.The file structure of xenogenesis can be stored and inquire about to the XML database in addition, and the support to the xenogenesis Information Access is provided.
Summary of the invention
The present invention seeks to overcome the prior art above shortcomings, " electronics patient " edit methods that provides a kind of XML-based database to be combined with relevant database.
The present invention is avoiding traditional Query Efficiency low aspect the data storage, safeguard not convenient, the shortcoming that construction cycle is long, the data storage method that utilizes the XML database to combine with relevant database, can satisfy " electronics patient " edit file amount large, travelling speed is fast, can solve effectively for it provides a kind of that contradiction, implementation procedure between software operation efficiency and development efficiency is convenient and swift, the reliable software systems of stability and safety.
" electronics patient " edit methods that XML-based database provided by the invention is combined with relevant database, aspect software module, adopted the strong Development of Modular mode of transplantability, " electronics patient " case editor module can be transplanted in the middle of different medical educationals or first-aid system software, described module operating procedure is as follows:
(1) system shows the case editing interface, an input of receiving information.Wait for user's operation (preserve, revise, deletion) instruction.
(2) when the trigger data storage operation, at first system carries out data check, and after verification was passed through, internal system XML database engine generated the XML file of regulation structure automatically.And carry out initialization operation.
(3) when trigger data inquiry or deletion action, at first system carries out data check to querying condition, after verification succeeds, travels through the XML storehouse by querying condition, finds respective labels, and data are carried out corresponding operating.
(4) when data volume is excessive when needing backup, for grouped data and carrying out safety backup, take the mode of being combined with relevant database, the XML file is set up index with key value directly deposit in relevant database.
Extracting certain segment data can inquire about according to key value.
Embodiment
For can clearer understanding technology contents of the present invention, describe in detail especially exemplified by following examples.
Above XML structure is a data structure that comprises two groups of cases, a case is wherein carried out explanation of field here.
The data sheet field that case need to be edited is as follows
Patient's content (PatientContent)
1, essential information (BasicInfo)
Name, (PatientName)
Height, (PatientHeight)
Sex, (PatientSex)
Body weight, (PatientWeight)
Age (PatientAge)
2, patient condition editor (PatientStateEditor)
Pupil diameter, (PupilDiameter) are set
Electrocardio (ECG) is set
Blood pressure, (BloodPressure) are set
Airway obstruction (Air WayObSrtuction) is set
Laryngospasm, (Laryngismus) are set
Breath sound (BreathSound) is set
Respiratory rate, (RespiratoryRate) are set
Blood oxygen saturation, (BloodOxyGenSaturation) are set
3, operation editor (PatientOpEditor)
Setting plays open and air flue is closed, (setAriWayOpen)
Setting is carried out trachea cannula and is cancelled trachea cannula, (SetBronChialCannula)
Defibrillation number of times, (SetDefibllationNum) are set
Arrange and check carotid pulsation (SetCarotidWave)
The CPR duration (SetCPRTime) is set
The consciousness that arranges checks (SetConsciousnessCheck)
XML data list structure example:
In superincumbent example:
At first, the shared hard drive space of XML document is very little, does not also take too many resource space even comprise mass data, different XML can be divided according to unit fully, is convenient to management.＜PatientCase〉content that comprises of node represented a case, with the Name attribute of this node as unique sign.
Secondly, minimum child node unlabeled data field, unified field format, format conversion mistake when having avoided the data storage, Value attribute representation node value, the Unit attribute represents numerical value unit.If for sky just proves judgement attribute or without the unit attribute.Avoided the defective that null field is made mistakes in relevant database.
Above XML structural table can be avoided the inconvenience that large database brings is installed, and has improved the transplantability of data.The software configuration of mating die blocking, can freely transplant the case editor module by the interface that module discharges when large change appears in software systems again, and the assurance data can not lose or damage.
In this instructions, the present invention is described with reference to its specific embodiment.But, still can make various modifications and conversion obviously and not deviate from the spirit and scope of the present invention.Therefore, it is illustrative that instructions should be considered to, and nonrestrictive.
Claims (1)
1. " electronics patient " edit methods that the XML-based database is combined with relevant database, aspect software module, adopted the strong Development of Modular mode of transplantability, " electronics patient " case editor module can be transplanted in the middle of different medical educationals or first-aid system software, be it is characterized in that described module operating procedure is as follows:
(1) system shows the case editing interface, and user's operation (preserve, revise, deletion) instruction is waited in an input of receiving information;
(2) when the trigger data storage operation, at first system carries out data check, and after verification was passed through, internal system XML database engine generated the XML file of regulation structure automatically.And carry out initialization operation,
(3) when trigger data inquiry or deletion action, at first system carries out data check to querying condition, after verification succeeds, travels through the XML storehouse by querying condition, finds respective labels, and data are carried out corresponding operating;
(4) when data volume is excessive when needing backup, for grouped data and carrying out safety backup, take the mode of being combined with relevant database, the XML file is set up index with key value directly deposit in relevant database; Extracting certain segment data can inquire about according to key value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104256884A CN103164209A (en) | 2011-12-19 | 2011-12-19 | 'Electronic patient' edit method based on combination of extensive makeup language (XML) database and relational database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104256884A CN103164209A (en) | 2011-12-19 | 2011-12-19 | 'Electronic patient' edit method based on combination of extensive makeup language (XML) database and relational database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103164209A true CN103164209A (en) | 2013-06-19 |
Family
ID=48587334
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011104256884A Pending CN103164209A (en) | 2011-12-19 | 2011-12-19 | 'Electronic patient' edit method based on combination of extensive makeup language (XML) database and relational database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103164209A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107368500A (en) * | 2016-05-13 | 2017-11-21 | 北京京东尚科信息技术有限公司 | Data pick-up method and system |
-
2011
- 2011-12-19 CN CN2011104256884A patent/CN103164209A/en active Pending
Non-Patent Citations (1)
| Title |
|---|
| 杨小兵: ""基于关系数据库的XML电子病历系统研究"", 《万方学术期刊数据库》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107368500A (en) * | 2016-05-13 | 2017-11-21 | 北京京东尚科信息技术有限公司 | Data pick-up method and system |
| CN107368500B (en) * | 2016-05-13 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Data extraction method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220043813A1 (en) | Method and system for ontology driven data collection and processing | |
| US7921416B2 (en) | Formal language and translator for parallel processing of data | |
| Barga et al. | Automatic capture and efficient storage of e‐Science experiment provenance | |
| US8689008B2 (en) | Operating system | |
| EP2425383B1 (en) | Method and device for ontology evolution | |
| Haldar | SQLite Database System Design and Implementation (Version 2):(See other editions and books at https://books. google. com/books/? id= zSbxCwAAQBAJ and decide one) | |
| US8359568B2 (en) | Method and system for automatically adding generic change log to legacy application | |
| US11386084B2 (en) | Systems and methods for deriving database semantic information using artificial intelligence | |
| Aldwairi et al. | Graph-based data management system for efficient information storage, retrieval and processing | |
| Butler et al. | INVocD: Identifier name vocabulary dataset | |
| CN103164209A (en) | 'Electronic patient' edit method based on combination of extensive makeup language (XML) database and relational database | |
| CN110989998A (en) | Method for writing code into dynamic sql statement, program code execution method and platform | |
| Brandt et al. | Fusing data management services with file systems | |
| JPH1021125A (en) | System for managing location of distributed database system | |
| Gradl et al. | Data integration for the arts and humanities: a language theoretical concept | |
| Wittek et al. | XML processing in the cloud: large-scale digital preservation in small institutions | |
| Keator | Management of information in distributed biomedical collaboratories | |
| CN116010445B (en) | Processing method and device of database SQL script | |
| Anton et al. | A Patient Data Management System for Medical Services and Training | |
| Grandi et al. | Towards Patient-Centric Healthcare: Multi-Version Ontology-Based Personalization of Clinical Guidelines | |
| Kirsch et al. | The snippet system-Reusing and connecting documents | |
| Zhou et al. | The Editing method of" Electronic patients" based on XML DataBase and Relational DataBase | |
| Fathollahzadeh et al. | GIO: Generating Efficient Matrix and Frame Readers for Custom Data Formats by Example | |
| Soundrarajan et al. | An interface for rapid natural language processing development in UIMA | |
| Tancer et al. | Cloud technology and EHR data management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130619 |
|
| WD01 | Invention patent application deemed withdrawn after publication |