CN1376995A - Management system for database of sperm bank - Google Patents
Management system for database of sperm bank Download PDFInfo
- Publication number
- CN1376995A CN1376995A CN 02118205 CN02118205A CN1376995A CN 1376995 A CN1376995 A CN 1376995A CN 02118205 CN02118205 CN 02118205 CN 02118205 A CN02118205 A CN 02118205A CN 1376995 A CN1376995 A CN 1376995A
- Authority
- CN
- China
- Prior art keywords
- management system
- donor
- forms
- aid
- data
- 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
Images
Landscapes
- Medical Treatment And Welfare Office Work (AREA)
Abstract
A database management system for sperm bank is composed of hardware, software and 4 tables containing the document about the sperm bank for quick and safe search.
Description
The present invention relates to computer management system, particularly adopt computing machine that the relevant data of human sperm bank is carried out permanent preservation, carry out the management system of multiple inquiry, statistics, analysis, form.
Human sperm's library management at present generally is manual operations.To data, comprise extremely inconvenience of statistics, moon or annual report form, doctor's inquiry of retrieval for situations such as smart persons, fertilization person, frozen semen, the seminal fluid that thaws, laboratory examination, AID treatment, data, the management that particularly accumulates data, Data Update is particularly difficult.Along with the increase year by year of AID number, the increasing of fertilization person's absolute quantity, year after year the increase of accumulating data, above problem seems more and more outstanding.
The objective of the invention is by the management of computer realization human sperm bank great mass of data data, it not only easily and fast, safety, and can long preservation, at any time inquire about certain year certain month success ratio, inquire about certain patient's AID treatment situation, inquire about pregnant number of certain Donor or the like, the more important thing is when can inquire relevant information, can prevent from again to divulge a secret (as relating to social ethics, privacy).
Technical scheme of the present invention is; The human sperm bank data base management system (DBMS) is by the hardware and the software support of following computing machine.
I. hardware: main frame: 1. IBM586 1200 microcomputers, 64MB internal memory, 3.2G hard disk, 24 fast CD-ROM drives; 2. high-resolution color display.
II. software: 1. Microsoft, windows98; 2. Office97 assembly.
It is characterized in that:
At first set up three data management systems that satisfy multiple managerial demand, design four forms of testing then through repeatedly, the related data of sperm bank is all comprised wherein, and input data one by one, set up database, computing machine manages, and the operator inquires the information of wanting from four forms.
Advantage and good effect that the human management system for database of sperm bank of the present invention is manifested in actual applications be that management hand-manipulated can't be accomplished, and it has realized easily and fast, safely to retrieval, statistics, renewal, form, the inquiry of human sperm's data information.
Below in conjunction with description of drawings:
＜1〉sets up data base management system (DBMS) 1,2,3, to satisfy the needs of multiple management;
Fig. 7 is a management system 1, for establishing close system, can only be opened by the sperm bank keeper, and the details of Donor (for smart person), AID (fertilization person) treatment situation etc. are being put down in writing in this storehouse; Its menu has information slip, inquiry, forms, the form for smart person and fertilization person.
Fig. 5 is a management system 2, imports treatment back result for AID implements the doctor; Its menu only has inquiry.
Fig. 6 is a management system 3, is open resource, can be the supvr, the doctor shares, and this system data can not be changed, and can only inquire about and reading of data, and the doctor can access the situation of certain patient's AID fertilization etc. at clinic; Its menu only has inquiry and report form preview.
Management system 2 and management system 3 have linking relationship with the correlation table of management system 1.The data of input in management system 1, related data is transfused to simultaneously in management system 2 and the management system 3.
＜2〉according to the demand, design four forms, the related data data of sperm bank are included wherein;
Fig. 1: four forms that the human management system for database of sperm bank of the present invention is designed and the synoptic diagram of all data input databases
Fig. 2: the synoptic diagram of the present invention's inquiry
Fig. 3: the forms synoptic diagram of data input of the present invention
Fig. 4: AID treatment monthly magazine hoist pennants of the present invention
Fig. 5: data base management system (DBMS) 2 synoptic diagram
Fig. 6: data base management system (DBMS) 3 synoptic diagram
Fig. 7: data base management system (DBMS) 1 synoptic diagram
Fig. 1 to Fig. 4 is form planning, the data of Fig. 7 data base management system 1 of the present invention The schematic diagram of the management processes such as input, data modification, inquiry, form.
Fig. 1 at first plans four forms, comprises the foundation of field:
1. Donor (for smart person) ordinary circumstance table, comprise password, name, date of filing, Age, address, ID card No., date of birth, race, blood group, father/mother plant Family, physique, height, body weight, skin color, wink and whether double-edged eyelid, eyesight situation (left and right), color development and a shape, educational background, native place, special hobby, remarks (comprise the individual History, past medical histroy, martial history, its wife's childbearing history, hereditary medical history, family history, family's fertility History etc.).
2. Donor detects table, and comprise two big contents: one for the project of semen efamination, comprises Seminal fluid cultivation, trichomonad, mould, gonococcus; Two are blood test, comprise blood group, dyeing The aobvious band of the conventional G of body, hepatitis B, syphilis, AIDS. This table is designed to two stages, Phase I is that project comprises above each project when supplying smart beginning; Second stage is for offering essence Finish after 6 months the check of HIV.
3. freeze-thaw table, field comprises Donor password, blood group, freezing date, solution Freeze rear residue pipe number, the date of thawing, freeze rear motility rate, detection method, operator, other.
4. AID (fertilization person) treatment statistical form: field comprise the AID medical record number, which Inferior treatment cycle, treatment cycle Start Date, treatment cycle stop the date, the Donor password, Freezing date, the date of thawing, other, the date of writing in reply, gestation treatment be no, end treatment, Feedback information, this treatment cycle are not cancelled reason.
More than four forms each field and the order have through conscientious design and Form through repeatedly revising in practice.
＜3〉set up four tables on the basis of having set up field, then one by one input money Material, building database creates table.
1. create for smart person's ordinary circumstance table: be sure of to have listed table object in the database window Name, click " newly-built " button, newly show dialog box and show.
Access allows you select to be and creates a new table, still uses table wizard to help build Vertical table. Guide can guide and progressively finish the process that creates various objects.
Double-click Design view, open the Design view window. At planned network the 1st row field name Claim in the cell that input Donor password navigates to the data type row by tab key then. It is text that Access selects data type acquiescently.
Its drop-down list comprises text, remarks, numeral, date/time, currency, automatic Coding, be not/no etc.
Can show the respective attributes of the text field in the bottom of table window this moment, and can be to field Size and other attribute are inserted default value, show on the status bar. This moment, available F6 key switched To the field attribute district. Press the F6 key and switch to the field attribute zone, in the field size frame, select Get default value, example 50, i.e. 50 bytes or 25 Chinese characters; This value as required can be any Choose. Design Donor password default value is for not having, so that the Donor password can ad infinitum continue Go down.
Setting up of other field is basic identical, and just " filling date " data type is the date / the time, the data type of " personal history etc. " changes " remarks " into. Memo field can hold 64000 Individual character, and the text field contains at most 255 characters, memo field can record long sentence Son utilizes these characteristics that medical history is recorded in the memo field just.
2. detect table for smart person, 3. freeze-thaw table, 4. fertilization person's method for building up for the treatment of statistical form with create 1. supply smart person's generalized case epiphase with.
Fig. 2 has at length listed the Query Information that the present invention uses always, comprises Donor figure and features card, AID patient status inquiry, Donor success 5 example inquiries, freeze-thaw table, the remaining pipe number inquiry of freezing date.The step of for example creating " Donor figure and features card " is as follows:
1. show the tabulation of query object at the database window;
2. click " newly-built " button and show " newly-built inquiry " dialog box, select the newly-built inquiry of query wizard;
3. in " indicator gauge " drop-down list, select by " Donor generalized case table ";
4. select field " password ", click " interpolation button ".
Add these fields with quadrat method and " whether can continue use, race, blood group, father/mother race, physique, height, body weight, skin-color, wink/eyelid, left eyesight, right eyesight, hair look/hair shape, educational background, native place, special hobby "; Click " next step ", add a title " Donor figure and features card ", click " finishing " to inquiry; Select " Donor figure and features card " at query window, be shown as "No", then finish " design "; At " table " window option table " Donor generalized case table ", it is selected to click the password that can be used for AID in whether its field " can continue to use ", promptly becomes complete " figure and features card ".The forms that Fig. 3 designs for Fig. 1 convenient input partly, it comprises Donor generalized case table forms 1, Donor generalized case table forms 2, AID patient statistical form forms, Donor detection table forms, freeze-thaw table forms.Forms can be checked data by the mode of wanting, and can use the mode of vertical hurdle table, also can once show the mode of a record with forms.
The method for building up of forms is an example with " Donor generalized case table forms 1 ":, click " forms " label at the database window, click " newly-built " button, show newly-built forms dialog box, click definite; Selected field in the selected Donor generalized case table promptly except all outer fields such as " personal history etc. " field, is clicked " next step ", selects " vertical hurdle table "; Click " next step ", selecting pattern is " standard "; Click " next step " mark-on and be entitled as " Donor generalized case table forms 1 "; Click definite.
Fig. 4 is the AID treatment situation moon form of becoming pregnant, and form is that data are revealed in the best approach on the paper.
Treating statistical form moon form with fertilization person below is that example is created a form.In the form window, click " newly-built ", open " newly-built form " dialog box, click " report wizard ", click definite; In table/inquiry drop-down list, selective fertilization person treats statistical form; Select field " AID medical record number ", " treatment cycle Start Date ", " gestation is not ", " continuing treatment not ", " ending treatment ", " not feedback information ".Click " next step ", selecting " treatment cycle Start Date " is " priority ".Click " next step ", selecting layout is " left-justify 1 ", and direction is " vertically ".Click " next step ", selecting pattern is " formal "; Click " next step ", mark-on is entitled as " AID treatment statistical form moon form ", clicks " finishing " and gets final product; Be revealed on the paper through printer prints.
Fig. 5 has described management system 2, is to design for the result who makes things convenient for the doctor to import the situation of becoming pregnant after the AID patient.
Open Access and set up new database " database of sperm bank 2 management systems "; " AID patient statistical form " at table window linked database 1 arrives the notebook data storehouse; In " inquiry " window newly-built " inquiry of patient's AID statistical form "; The field of selecting have " AID medical record number, treatment cycle Start Date, Donor password, the date of writing in reply, successfully deny, conceived, the miscarriage of writing in reply, continue treatment not, end treatment, write in reply, other, this treatment cancellation reason " etc.; The method that it is set up is seen the method that Fig. 2 illustrates.
Fig. 6 has described management system 3, is for making things convenient for the doctor in the future to be done the prepotency consulting and inquire about and use or inquire about patient's AID situation of being fertilized as the doctor and design by AID gives birth to filial generation.For safety, this storehouse is read-only, and can not be modified, in case operator's misoperation, change or deleted data.Open Access and set up new database " database of sperm bank 3 management systems "." AID patient statistical form " at table window linked database 1 arrives the notebook data storehouse; Then forms " window newly-built 1. ' AID patient Donor fertilization number of times inquiry forms ', its field comprise " AID medical record number, Donor password, successfully deny, continue treatment not, end treatment, write in reply "; 2. " patient AID be fertilized status inquiry forms ", its field comprise " AID medical record number, which time treatment cycle, treatment cycle Start Date, Donor password, successfully deny, the freezing date 1, freeze preceding 1, freeze back 1 ... the freezing date 5, freeze preceding 5, freeze back 5 " etc. the design forms be " tables of data " mode; Last permanent hide " AID patient statistical form " then finished the foundation in this storehouse.
The human management system for database of sperm bank of the present invention is imported the related data of Donor, AID patient every day by the operator, the inquiry theme is determined by the operator, computing machine manages, from four forms, draw information material automatically, reached human sperm's data information has been carried out multiple inquiry, analysis, statistics, renewal, form, the purpose of forever preserving.
Be described further below in conjunction with embodiment.
Embodiment 1:
As figure and features, but can not relate to better address, identity information for the ease of patient selection Donor, can be from for fields such as selected smart person's generalized case table " Donor passwords, whether can continue to use ".
Whether crossed quarantine and whether existing 5 and successfully become pregnant and just can in " whether can continue to use " field, select this Donor because relate to frozen semen again, can list in alternative figure and features card, as the frozen semen of certain Donor freezing 6 months, and it is qualified to recheck HIV, and insemination successfully becomes pregnant 5 people then to click " whether can continue to use " then selected.As above two do not reach requirement, then can not select.
As above two do not reach requirement, then can not select.In use, though check, it is all qualified to recheck, need to get rid of but certain Donor has made 5 people successfully become pregnant, then the operator only opens Donor generalized case table, clicks " whether can continue to use ", selected "No", then this Donor disappears from the figure and features card immediately, also just no longer makes AID with the sperm of this Donor clinically, can do well management to the routine number of the success of Donor.
This " Donor figure and features card " needs to use in the AID treatment everyday, and often change as import by manual method temporarily, is wasted time and energy very much.And, only need to change the figure and features card several seconds with the figure and features card of this system.Source book is not done any change.
The native system inquiry can repeatedly be inquired about as needing, and promptly carries out the inquiry second time on the basis of inquiry for the first time, inquires about for the third time
Embodiment 2:
Certain Donor has been used for those AID patient and those are pregnant as understanding, then can open " AID patient statistical query ", select field " Donor password ", it is strong " to search " Donor password → determine → the click right mouse that input will look for by instrument, selected following menu " pressing chosen content screens ".Then can list patient AID of useful this Donor.Look into the AID patient information slip of gestation, can carry out the inquiry second time.Method is as follows: on the basis of inquiry for the first time, select pregnant person in " gestation is not " field, selected more following menu can be listed the tabulation that this Donor has made patient's AID gestation by the chosen content screening.The method easily and fast (only needs about 15 seconds) and safety is not divulged a secret.If there is not this cover system, go statistics, inquiry must take several days a few evenings by artificial method, waste time and energy, very loaded down with trivial details.
For the second time the table of inquiry can be used for children that patient AID the gives birth to marriage afterwards of growing up and makes genetic counselling usefulness, sees whether the opposing party is given birth to children by same Donor.
Embodiment 3:
As inquiring about the fertilization situation in certain certain cycle of patient AID, then only need open the inquiry of AID patient information slip, select field AID medical record number, again from tool bar selected " inquiry ", the AID patient history number that input will be inquired about, determine to find this patient's fertilization situation at once,, then can hit " next time " and find that cycle that you want as not being the cycle that to look into.When being convenient to the doctor like this and inquiring the AID patient very soon, density, the motility rate of insemination sperm help the doctor and well understand patient, for diagnosis provides convenience, and can in time propose therapeutic scheme.
Embodiment 4:
As inquiring about those Donor 5 patients AID are successfully become pregnant? native system has been set up an inquiry and has been reminded us to get rid of Donor, opening in the inquiry " success 5 examples " can view those Donor 5 patients AID are successfully become pregnant, this inquiry sorts by date, we can inquire at any time recently that those Donor are excluded at work, can not clinical practice.
Embodiment 5:
How much manage number or manage number or freezing particular locations that are kept at liquid N jar as knowing that certain Donor also remains by all Donor frozen semen residues of the typing of blood, then can open " the remaining pipe number inquiry of freezing date of freeze-thaw table ", above queried for items homogeneous order is clear, and recognizes the i.e. resurrection rate of situation behind the semen thawing in the inquiry from then on.Be convenient to the tank farm stock (tank farm stock that comprises various blood types) that the sperm bank supvr can recognize sperm in time, exactly like this.In forms, as " Donor generalized case table forms 1 ", open it, then can singly the generalized case of Donor be imported.Some Donor data should not show with the mode of form, and has designed " Donor generalized case table forms 2 ", in these forms, has designed field " personal history etc. " with inputs such as personal history, medical history, family history, father and mother's gestation histories.And can print relevant information rather than the full detail of certain Donor in the mode of forms.Other treats situation as AID, frozen semen, Donor laboratory examination all can with the mode of forms import and also convenient, fast, save time.
Claims (8)
1. human sperm bank data base management system (DBMS), hardware and software support by computing machine is characterized in that:
At first set up three data management systems that satisfy multiple managerial demand, design four forms of testing then through repeatedly, the related data of sperm bank is all comprised wherein, and input data one by one, set up database, computing machine manages, and the operator inquires the information of wanting from four forms.
2. human sperm bank data base management system (DBMS) according to claim 1 is characterized in that:
Data base management system (DBMS) 1 can only be opened by the sperm bank keeper for establishing close system, and the details of Donor (for smart person), AID (fertilization person) treatment situation are being put down in writing in this storehouse; Its menu has information slip, inquiry, forms, the form for smart person and fertilization person;
Data base management system (DBMS) 2 is imported treatment back result for AID implements the doctor, and its menu only has inquiry;
Data base management system (DBMS) 3 can only be inquired about and reading of data, and the doctor can access situations such as certain patient's AID fertilization at clinic, but can not be modified, in case operator's misoperation, change or deleted data, its menu only have inquiry and report form preview.
3. data base management system (DBMS) according to claim 2 is characterized in that:
Management system 2 and management system 3 have linking relationship with the correlation table of management system 1; The data of input in management system 1, related data is transfused to simultaneously in management system 2 and the management system 3.
4. human sperm bank data base management system (DBMS) according to claim 1 is characterized in that: the planning of four forms, comprise the foundation of field,
1. Donor (for smart person) generalized case table;
2. Donor detects table;
3. freeze-thaw table;
4. AID (fertilization person) treats statistical form.
5. human sperm bank data base management system (DBMS) according to claim 1 is characterized in that Query Information, comprising:
Donor figure and features card, AID patient status inquiry, Donor success 5 example inquiries, freeze-thaw table, the remaining pipe number inquiry of freezing date.
6. human sperm bank data base management system (DBMS) according to claim 1 is characterized in that convenient input forms, comprising:
Donor generalized case table forms 1, Donor generalized case table forms 2, AID patient statistical form forms, Donor detect table forms, freeze-thaw table forms.
7. convenient the input according to claim 6 and forms that design is characterized in that: can be with the mode of vertical hurdle table, also can show that once the mode of a record checks data with forms.
8. human sperm bank data base management system (DBMS) according to claim 1 is characterized in that: the AID that manifests treats the situation moon form of becoming pregnant.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02118205 CN1376995A (en) | 2002-04-25 | 2002-04-25 | Management system for database of sperm bank |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02118205 CN1376995A (en) | 2002-04-25 | 2002-04-25 | Management system for database of sperm bank |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1376995A true CN1376995A (en) | 2002-10-30 |
Family
ID=4744615
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 02118205 Pending CN1376995A (en) | 2002-04-25 | 2002-04-25 | Management system for database of sperm bank |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1376995A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108288497A (en) * | 2018-04-18 | 2018-07-17 | 重庆市人口和计划生育科学技术研究院 | Human sperm bank is for essence, smart follow-up information management system |
| CN108537514A (en) * | 2018-04-18 | 2018-09-14 | 重庆市人口和计划生育科学技术研究院 | Human sperm bank is managed for essence, the method for smart follow-up information |
| CN109448831A (en) * | 2018-10-22 | 2019-03-08 | 温州医科大学附属第医院 | Sperm bank information management system |
| CN111276201A (en) * | 2020-01-15 | 2020-06-12 | 华中科技大学同济医学院附属协和医院 | Electronic medical record system based on intelligent voice recognition |
| CN112562832A (en) * | 2020-12-07 | 2021-03-26 | 四川大学华西第二医院 | Human sperm library information management system and method |
| CN112951352A (en) * | 2021-03-15 | 2021-06-11 | 河北省计划生育科学技术研究院 | Sperm bank self-sperm management system |
-
2002
- 2002-04-25 CN CN 02118205 patent/CN1376995A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108288497A (en) * | 2018-04-18 | 2018-07-17 | 重庆市人口和计划生育科学技术研究院 | Human sperm bank is for essence, smart follow-up information management system |
| CN108537514A (en) * | 2018-04-18 | 2018-09-14 | 重庆市人口和计划生育科学技术研究院 | Human sperm bank is managed for essence, the method for smart follow-up information |
| CN109448831A (en) * | 2018-10-22 | 2019-03-08 | 温州医科大学附属第医院 | Sperm bank information management system |
| CN109448831B (en) * | 2018-10-22 | 2021-08-31 | 温州医科大学附属第一医院 | Sperm library information management system |
| CN111276201A (en) * | 2020-01-15 | 2020-06-12 | 华中科技大学同济医学院附属协和医院 | Electronic medical record system based on intelligent voice recognition |
| CN112562832A (en) * | 2020-12-07 | 2021-03-26 | 四川大学华西第二医院 | Human sperm library information management system and method |
| CN112951352A (en) * | 2021-03-15 | 2021-06-11 | 河北省计划生育科学技术研究院 | Sperm bank self-sperm management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Clarke et al. | An algebra for structured text search and a framework for its implementation | |
| CN107122443A (en) | A kind of distributed full-text search system and method based on Spark SQL | |
| US6859805B1 (en) | Method and apparatus for generating page-level security in a computer generated report | |
| US8423565B2 (en) | Information life cycle search engine and method | |
| Burkowski | Retrieval activities in a database consisting of heterogeneous collections of structured text | |
| CN104050615A (en) | System for generating structured electronic medical record | |
| AU2012327168B2 (en) | Amethod and structure for managing multiple electronic forms and their records using a static database | |
| CN103530358A (en) | Electronic medical record rapid recording system based on incremental type term bank | |
| CN1376995A (en) | Management system for database of sperm bank | |
| Janaki Raman et al. | Automatic text summarization of article (NEWS) using lexical chains and wordnet—A review | |
| Dong et al. | Semex: Toward on-the-fly personal information integration | |
| US8112458B1 (en) | User segmentation user interface | |
| US7966333B1 (en) | User segment population techniques | |
| Chen | PE Teaching Activities in Colleges and Universities Based on Decision Tree. | |
| Weller et al. | Seeding, weeding, fertilizing. different tag gardening activities for folksonomy maintenance and enrichment | |
| WO2006005715A1 (en) | System for interrogating heterogeneous databases and method for interrogation | |
| Mathisen | Medieval prosopography and computers: theoretical and methodological considerations | |
| Allkin et al. | Handling the taxonomic structure of biological data | |
| EP2312463A1 (en) | Data provider with transcient universe | |
| Jilek et al. | Towards Self-organizing Personal Knowledge Assistants in Evolving Corporate Memories | |
| CN117290304A (en) | Retrieval system and method based on medical big data establishment | |
| Rubinoff | Man-Machine Communication Through a Teletypewriter. | |
| Miñarro-Giménez et al. | A semantic query interface for the OGO platform | |
| Helms et al. | The conflict between relational databases and the hierarchical structure of clinical trials data | |
| EllIEEEEElllm | EEEmhEEohhEshI IllllE EEEEI EllIEEEEElllm. ElllEllEEEEEEI |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |