CN100527131C - Interdynamic access method and tool of IMS data base - Google Patents
Interdynamic access method and tool of IMS data base Download PDFInfo
- Publication number
- CN100527131C CN100527131C CNB2006101732252A CN200610173225A CN100527131C CN 100527131 C CN100527131 C CN 100527131C CN B2006101732252 A CNB2006101732252 A CN B2006101732252A CN 200610173225 A CN200610173225 A CN 200610173225A CN 100527131 C CN100527131 C CN 100527131C
- Authority
- CN
- China
- Prior art keywords
- database
- data
- ims
- user
- definition
- 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.)
- Active
Links
Images
Abstract
An interdynamic-calling method of IMS databank includes exhibiting data stored in IMS databank to be display data, generating object data according to said display data, using said object data and relevant command information to generate operation data according to preset rule and using generated operation data to call IMS databank.
Description
Technical field
The present invention relates to database access technology, particularly relate to a kind of based on interactive access tool of IBM main frame ims database and method.
Background technology
IMS (Information Management System) database is based on a kind of topmost hierarchical data storehouse of IBM main frame, have that memory capacity is big, the concurrent access performance outstanding, series of advantages such as safe and reliable is a kind of data base management system (DBMS) that is extensively adopted by numerous ultra-large type enterprises in worldwide.
IMS uses DL/I call statement as service data (DML, Data ManipulationLanguage).Because IMS self does not possess the interactive operation interface, therefore, many at present employing precompile methods are operated database.The basic thought of precompile method is: after the user has submitted the DML statement to, before operation it is carried out process of compilation, preserve the executable code that produces through compiling.When needs are carried out, take out the executable code of preserving and carried out.Adopt the precompile method, the DML statement need combine with the host language program and could be carried out by compiling.For example, if process object is a C linguistic source program module P, it at first can be handled by a precompile device.The precompile device is discerned the DML statement that embeds in this source module, they is replaced to the Call statement of C language.Amended C source program according to common mode compiled, connection processing, generate loading module.Simultaneously DML statement is wherein generated database request module (DBRM, Data Base Request Module).Then the DBRM that generates is fettered to handle generating application planning, comprised in this application planning, finish the function of the source DML statement of DBRM correspondence the calling of basic access module.When operation, behind the CALL statement that runs into data base call in the loading module implementation, just find application corresponding planning and it is called in the data access that internal memory goes to carry out reality, and the result is returned to c program.Host language commonly used has C, COBOL, PL/1 etc.
For these reasons, when the user need operate IMS, must and carry out operation and call these programs and realize visit by coding to the ims database data.For example, if need make amendment to data, general flow process is: at first submit to an operation to carry out a polling routine, the numerical value before confirming to revise; And then submit the operation of a modification to, data are made amendment; Amended data are confirmed in the last operation of carrying out an inquiry once more.Like this, not only the maintenance to the IMS data message is relatively more difficult, and has expended more resource and cost.
Summary of the invention
The purpose of this invention is to provide a kind of ims database interdynamic access method and instrument, to solve in the prior art owing to can't carry out the access efficiency problem low, difficult in maintenance that interactive visit was brought to ims database.
For addressing the above problem, the invention discloses a kind of ims database interdynamic access method, it is characterized in that, may further comprise the steps:
The database structure definition of ims database is resolved and generate the database structure metadata by presetting rule, and fragment field metadata is resolved and generated in the fragment field definition of ims database by presetting rule;
According to the definition of described database structure metadata and/or fragment field metadata, the data of storing in the described ims database are generated video data; Described video data is the analysis result of the data of being stored in the described ims database;
According to the definition of database structure metadata and/or fragment field metadata, described video data and/or user input data that the user is selected generate target data, and described target data is used for the data that identifying user need be visited;
Described target data and corresponding instruction information are generated database manipulation language DML by presetting rule, and described command information is the concrete visit behavior of user to data;
Utilize described DML to visit described ims database.
Preferably, also comprise:
Described video data is carried out dynamic translation by predetermined multiple form.
Preferably, described predetermined multiple form includes but not limited to database structure definition and/or the definition of fragment field and/or the hexadecimal format of described ims database.
Preferably, also comprise: control of authority is carried out in the visit behavior to the user.
Preferably, also comprise: the operation of record access ims database also generates log information.
For addressing the above problem, the invention also discloses the interactive access tool of a kind of ims database, comprise interactive device, service data maker and addressed location, wherein,
Described interactive device also comprises:
The database structure resolution unit is used for resolving the database structure information of ims database and generating the database structure metadata by presetting rule;
Fragment field resolution unit is used for resolving the fragment field information of ims database and generating fragment field metadata by presetting rule;
Display unit is used for data that ims database is stored and is shown as video data by the database structure definition and/or the definition of fragment field of described ims database; Described video data is the analysis result of the data of being stored in the described ims database;
Input block is used to receive user's input;
The target data generation unit, be used for definition according to database structure metadata and/or fragment field metadata, video data and/or user input data that the user is selected generate target data, described user input data is received by described input block, and described target data is used for the data that identifying user need be visited;
The service data maker is used for the command information of target data and input block reception is generated database manipulation language DML, and described command information is the concrete visit behavior of user to data;
Addressed location is used for visiting described ims database by described DML.
Preferably, also comprise:
The dynamic format converting unit, be used for the video data of display unit is carried out dynamic translation by predetermined multiple form, described predetermined multiple form includes but not limited to database structure definition and/or the definition of fragment field and/or the hexadecimal format of ims database.
Preferably, also comprise: the safety control unit is used for control of authority is carried out in user's visit behavior.
Preferably, also comprise: log unit is used to write down visit and generation log information to IMS.
Compared with prior art, the present invention has the following advantages:
At first, because the present invention adopts the mode of What You See Is What You Get, ims database is carried out interactive visit, therefore, the user can see data in the database and the result after the visit in real time, has solved in the prior art and must write DML and host program, could visit the problem difficult in maintenance that IMS brings after compiling is carried out, so, greatly improved the efficient of user capture IMS.
Secondly, meeting of the present invention dynamically generates DML and finishes visit to IMS according to operation and the data of input or the command information of user on the interface.Therefore, even the user does not understand the grammer and the rule of DML statement, also can finish visit to ims database by Method and kit for of the present invention, like this, not only simplify user's operation, avoided the issuable mistake of artificial input DML, and reduced user's use difficulty.
In addition, the present invention shows data in the database according to the form of the form of database structure or fragment field.Because such form very near the form of ims database organization definition, therefore, will provide very familiar, a friendly operating environment to the user by using the present invention.In addition, owing to when the data in the database being converted to video data and video data or user input data being converted to the required data of operation IMS, all will carry out format conversion according to database structure definition and/or fragment field.And the present invention generates database structure metadata and fragment field metadata by database structure and fragment field are resolved, and like this, has reduced data capacity and to the taking of Installed System Memory, has improved the real-time in the access process.
Use the present invention, have only user could visit ims database through authorizing.Simultaneously, in access process, can write down all operations and generate log information.Like this, made all visits all be among strict monitoring and the management, avoided illegal and malicious act effectively, strengthened safeguard protection ims database to IMS.
Description of drawings
Fig. 1 is the structural representation of an ims database;
Fig. 2 is the flow chart of steps according to a preferred embodiment of ims database interdynamic access method of the present invention;
Fig. 3 is the structured flowchart according to a preferred embodiment of the interactive access tool of ims database of the present invention;
Fig. 4 is an effect synoptic diagram using the interactive access tool of ims database of the present invention;
Fig. 5 is another effect synoptic diagram of using the interactive access tool of ims database of the present invention.
Embodiment
Before system and method for the present invention is described in conjunction with specific embodiments, the general considerations in IMS hierarchical data storehouse once is discussed at first.
Usually, the inner three-level schema structure that adopts of database comprises external schema, pattern and internal schema, and its structure is as follows:
| External schema |
| Pattern |
| Internal schema |
Wherein, pattern also claims logical schema, is the description of the logical organization and the feature of all data of database.Not only want the logical organization of definition of data during defining mode, for example data recording is made of those data item, and the name of data item, type etc. are also wanted the contact between the definition of data, usually based on a certain data model.The hierarchical data storehouse is the basis definition with the hierarchical model.
External schema also claims user model, is the logical organization of the database user local data that can see and use and the description of feature.External schema is the subclass of pattern.
Internal schema is the description of data physical structure and storage mode.
Data model is the abstract of real world data characteristics.In data model, there be " type " (Type) and " value " notion (Value).Type is meant that to the structure of a certain class data and the explanation of attribute value is a concrete assignment of type.For example: student's record is defined as (sex is not, age, native place for student number, name) such recordable type, and (600201, Li Hua, man, computing machine, 22, Shandong) then are record values of this recordable type.
The organizational form of hierarchical model as data adopted in the hierarchical data storehouse.Hierarchical model is represented the contact of all kinds of entities and inter-entity with tree structure.The contact of many inter-entity itself just presents a kind of very natural hierarchical relationship in the real world, as administrative organization, kinship etc.
The set of the basic layer of two conditions contact is a hierarchical model below satisfying in database definition (mode-definition): (1) has and has only a node not have parent node, and this node is called root node; (2) other node beyond the root has and has only a parent node.In hierarchical model, each node is represented a recordable type, and the contact between the recordable type represents that with the contact between the node this contact is the contact of one-to-many between the father and son.Each recordable type can comprise several fields, and wherein, what recordable type was described is entity, field description be attributes of entities.Each recordable type and its field all must names.Each field can not be of the same name in each recordable type, the same recordable type.Sort field of each recordable type definable, if the value of this sort field is unique, then it can record value of unique identification.
In ims database, can use some special-purpose terms usually, below, based on foregoing, introduce the key concept of ims database.
The indivisible least unit of data is field (Field) among the IMS, and some field groups become fragment (Segment).Fragment be among the IMS application program to the base unit of database access.That is to say that what describe an entity among the IMS is fragment, it is equivalent to recordable type mentioned above.The tree-like hierarchical structure that the Data Structures of IMS is made up of some fragments that are associated.The overall data model of an IMS is the set of several trees.
Among the IMS hierarchical tree structure of being made up of some sheet segment types that are associated is called physical data baserecord type (PDBR, Physical Date Base Record), be designated as the PDBR type.Its heel piece segment value and descendants's fragment values thereof have constituted a value of this PDBR type, i.e. data-base recording or example.A physical database (PDB, Physical Date Base) is exactly the ordered set of whole values of a PDBR type.For example, there are 16 systems in a university, and then PDB is exactly to be that 16 data-base recordings of heel piece segment value are formed with 16.Set that database is several PDB among the IMS.For example the database of a school can be relevant for undergraduate's PDB, relevant for postgraduate's PDB with about doctor's PDB.
The pattern of IMS is one group of PDBR type, and each PDBR type defines its logical organization and storage organization reflection thereof by a database structure definition (DBD, DataBase Definition) statement group.That is to say that the definition of IMS pattern is the arrangement of one group of DBD definition.The content that DBD describes generally includes some significant fields that title, fragment and this fragment of database comprise.The whole fields that comprise for a fragment are described with fragment field definition (COPYBOOK) usually.
In ims database, being used for the language (DML, Data ManipulationLanguage) of operating database is DL/1call; Described DBD and COPYBOOK are described by data definition language (DDL) (DDL, Data Definition Language).
As shown in Figure 1, be the structural representation of a database among the IMS.3 sheet segment types are arranged in this database.Wherein, root node M1 is sheet segment type SEGA, is made up of FieldA1, FieldA2, FieldA3, FieldA4 and FieldA5; Child node M21 is sheet segment type SEGB, is made up of field FieldB1 and FieldB2; Byte point M22 is sheet segment type SEGC, is made up of field FieldC1 and field FieldC2.
More than introduced the key concept of hierarchical model and ims database, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
Ims database interdynamic access method of the present invention comprises: with the data display of storing in the ims database is video data; Generate target data according to described video data and/or user input data; Described target data and/or user input data and corresponding instruction information are generated DML by presetting rule; Utilize described DML visit ims database.
With reference to Fig. 2, Fig. 2 shows the flow chart of steps of interactive IMS access method in accordance with a preferred embodiment of the present invention.Below with reference to Fig. 2 this preferred embodiment of the present invention is described in detail.
Step 201: resolve the DBD information of ims database and generate DBD metadata by presetting rule.
Meta data claims metadata again, is to be used for the data of data of description.Described DBD meta data is that the database structure metadata is that DBD original description information is generated after by certain rule parsing, and this process is called the parsing of DDL again.DBD is being resolved in the process of DBD meta data, removed the content that has nothing to do with the visit ims database in the DBD raw information, the more original DBD of DBD meta data that make to generate has reduced capacity, to the taking of Installed System Memory, has improved the efficient of visit when having reduced operation; In addition,, like this use of DBD information no longer is limited by the influence of data layout in the DBD raw information, has not only simplified use-pattern, and more helped function expansion because DBD meta data generates according to the rule that presets.
By above describing as can be known, DBD has defined each sheet segment type (Segment type) that comprises among the IMS, and important field, key assignments etc. in each fragment.Behind the database of having selected to visit as the user, its corresponding D BD descriptor is also definite.Certainly, adopt which kind of rule that DBD is resolved, the present invention does not limit this, and those skilled in the art can define when enforcement is of the present invention voluntarily.With an example DBD being resolved the process that generates DBD meta data below is described further:
At first provide an original DBD definition:
(1)DBD NAME＝DB1，ACCESS＝DEDB，RMNAME＝M1
(2)SEGM NAME＝SEGA，PARENT＝0，BYTES＝(387，30)
(3)FIELD NAME＝(FieldA1，SEQ，U)，BYTES＝28，START＝3，TYPE＝C
(4)SEGM NAME＝SEGB，PARENT＝SEGA，BYTES＝(424，5)
(5)FIELD NAME＝(FieldB1，SEQ，U)，BYTES＝3，START＝3，TYPE＝C
(6)DBDGEN
(7)FINISH
(8)END
Wherein, (1) has defined the title DB1 of database; (2) defined a fragment, the name of this fragment is called SEGA; PARENT=0 represents that this node is a root node; This node ' s length is 30-387byte.(3) define a field FieldA1, be the key assignments field of fragment SEGA; Since the 3rd, length is 28byte.(4) defined a fragment, name is called SEGB, and its father node is SEGA; This node ' s length is 5-425byte.(5) define a field FieldB1, be the key assignments field of SEGB; Since the 3rd since the 3rd; Node ' s length is 3.Above-mentioned DBD thes contents are as follows through the DBD metadata that resolves the back generation:
％％B DB1
％％E
Wherein, the %%B of first row is an opening flag, and DB1 is a database-name; Second the row SEGA be the fragment name, 1 the expression this fragment be ground floor, FieldA1 is a field name, this field be initiated with 3, length 28, the length of fragment SEGA are 30-387,0 the expression this fragment father node be 0, promptly this fragment is a root node; Second the row SEGB be the fragment name, 2 the expression these fragments be the second layer, FieldB1 is a field name, this field be initiated with 3, length 3, the length of fragment SEGB are 30-387, the father node of this fragment is SEGA; The third line %%E is an end mark.Certainly, except that the content of having described, can also comprise other guide among the metadata, those skilled in the art can be provided with as required voluntarily, and the present invention does not limit this.
Step 202: is video data by initialize format with the data display of storing in the ims database.
The present invention is by the mode of What You See Is What You Get, and the data of being stored in the ims database that the user visited are resolved and the result is showed the user as video data.For example, behind the database that the user has selected to visit by database-name, show all sheet segment types that this database comprises with the form of tabulating.Further, if the user selects to visit a fragment, just show whole fields that this fragment comprises.
Preferably, be video data according to database structure definition with the data display of database storing.Because the data of obtaining from ims database still belong to storage-type data, wherein partial content can not be discerned by the user, for example, can't be that the data of compression-type directly show the user with field type.Therefore,, when showing data, can not be shown after the data-switching of user's Direct Recognition, made friendly more with becoming alternately of user by database structure definition.For example, show whole fragment in the database according to the formal definition of DBD; Formal definition according to COPYBOOK represents fields whole in the fragment.
Preferably, using presetting rule that COPYBOOK is resolved to COPYBOOK meta data is fragment field metadata.Formal definition according to DBD meta data and COPYBOOK meta data shows corresponding data respectively.Like this, not only reduced the time that video data spent, and the data seen of user are to show with the form of its DBD that is familiar with the most and the form of COPYBOOK, have improved the convenience of using greatly.
Be example with fragment SEGA below, the process that the COPYBOOK that resolves this fragment is generated COPYBOOKmeta data is described in further details.
At first provide the complete description of the COPYBOOK of fragment SEGA, comprised whole fields of SEGA:
FieldA1 PIC X (28) field FieldA1 be that length is 28 character type
FieldA2 PIC 9(4)COMP
FieldA3 PIC 9(15)COMP-3
FieldA4 PIC X(3)
FieldA5 PIC X(8)
Result after the parsing is:
++K SEGA
FieledA1 C 28 K 0003:0028
++E
++B SEGA
FieledA1 C 28 K 0003:0028
FieldA3 P 15 0031:0008
FieldA4 C 3 0039:0003
FieldA5 C 8 0042:0008
++E
Wherein, ++ K: the start bit that key assignments is described; ++ E: the stop bit that key assignments is described; ++ B has described title, length, field type, start bit of all fields of this copybook etc. to ++ E.
Certainly, the present invention can also use the extended formatting video data, for example, shows etc. according to 16 system form demonstrating datas or according to user-defined form.Preferably, the user can be by order or the button conversion arbitrarily between multiple form that sets in advance.So, made user capture IMS interface friendly more, also more direct, convenient to the operation of IMS data, improved user's access efficiency.
Step 203: generate target data according to described video data and/or user input data.
Because the video data that the user sees is exactly the data content of ultimate demand operation, therefore, the user can locate and select data easily, for example can select all fragment values that a fragment is checked this fragment.In addition, the user also can import data, and for example selected field is imported the value that this field will be upgraded.Among the present invention, as target data, this target data is the necessary data of visit IMS with the data of user-selected needs operation and/or user input data.For example, if need check whole frag infos that certain database comprises, database name need be referred to as target data; If check certain fragment values information, then need key assignments with fragment as target data.
Step 204: described target data and corresponding instruction information are generated DML by presetting rule.
Command information has comprised the concrete visit behavior of user to data, as: read, delete, revise, insertion etc.Command information can produce when operation behavior takes place the user, also can be imported by the user.For example, in the time of need checking the content of a fragment as if the user, need in shown data, select a fragment, simultaneously according to the interface prompt input command, as " carriage return " key.In this process, user-selected fragment is exactly a target data, and " carriage return " key of being imported is exactly a command information.Generate the DM that visits ims database, i.e. DL/Icall according to described target data and command information then.For example, the user selects a fragment in the interface after, import a value value 10 of this fragment, input command GU simultaneously, the meaning is to read the information that value is 10 fragment, the DL/Icall:GU SEGA (FieldA1=10) of generation.
Preferably, the present invention carries out control of authority to user's visit behavior.For example, can limit which database of which user capture, in which way visit.Further, can also control the detailed content of this customer data base.For example can control the operation of field in a fragment or this fragment with regard to the user.After must obtaining the authorization, the user could operate this fragment.In addition, meeting of the present invention generates log information according to all visit and operations to IMS, for example view log, modification log information etc.By above-mentioned control of authority and log information, the visit of IMS all is in strict control and the management, effectively avoided to ims database visit behavior illegally, mala fide, improved the safeness of Data Bank protection.
Step 205: utilize described DML visit ims database and display access result.
Use described DL/I call visit IMS by the access interface that calls IMS and provide, and receive return results.Be shown to the user after at last return results being resolved with the formal definition of DBD meta data or COPYBOOK meta data.If the visit failure then shows error message.
More than, a kind of ims database interdynamic access method of the present invention has been described in conjunction with specific embodiments.With reference to above relevant introduction of the present invention, as shown in Figure 3, be the interactive access tool of a kind of ims database of the present invention, comprise interactive device 3100, DML maker 3200 and addressed location 3300, wherein,
Described interactive device 3100 comprises:
Target data generation unit 3130 is used for video data and/or user input data are generated target data, and described user input data is received by described input block 3120;
Preferably, described display unit 3110 is shown as video data with the data of storing in the ims database by the DBD definition and/or the COPYBOOK definition of described ims database.
Preferably, described access tool also comprises:
Described display unit 3110 is shown as video data with the data of storing in the ims database by the definition of DBD meta data and/or COPYBOOK meta data.
Preferably, described target data generation unit 3130 also is used for video data and/or user input data are generated target data according to the formal definition of DBD meta data and/or COPYBOOK meta data.
Preferably, described access tool also comprises:
Dynamic format converting unit 3140, be used for the video data of display unit 3110 is carried out dynamic translation by predetermined multiple form, described predetermined multiple form includes but not limited to DBD definition and/or the COPYBOOK definition and/or the hexadecimal format of ims database.
Preferably, described access tool also comprises: safety control unit 3600 is used for control of authority is carried out in user's visit behavior.
Preferably, described access tool also comprises: log unit 3700 is used to write down visit and generation log information to IMS.
At first, DBD resolution unit 3400 is resolved the DBD information of ims database and is generated DBD meta data by presetting rule; COPYBOOK resolution unit 3500 is resolved the COPYBOOK information of ims database and is generated COPYBOOK meta data by presetting rule; Described display unit 3110 is shown as video data with the data of storing in the ims database by the definition of DBD meta data and/or COPYBOOK meta data.Wherein, if when showing the frag info that a database or this database comprise, display unit 3110 shows according to DBD meta data form, if when showing the full detail that a fragment comprises, then the form according to COPYBOOK meta data shows; In addition, display unit 3110 can also be showed video data according to hexadecimal format or user-defined format, and, between multiple form, carry out dynamic translation by the video data in 3140 pairs of display units 3110 of dynamic format converting unit; Target data generation unit 3130 generates target data with video data and/or by the input data that input block 3120 receives.This target data is the necessary data of visit IMS, for example, if need check whole frag infos that certain database comprises, database name need be referred to as target data; If check certain fragment values information, need be with the key assignments of fragment as target data; DML maker 3200 generates DML with the command information that described target data and input block 3120 receives, and wherein command information is used to illustrate the operation to target data, for example checks, revises, deletion etc.; Addressed location 3300 utilizes described DML visit ims database, and the result is passed through display unit 3110 according to described DBD meta data and/or COPYBOOK meta data form or the demonstration of other form.
Above-mentioned about not detailed part in the description of instrument of the present invention, can be referring to the aforementioned relevant portion of this instructions.
In order to make those skilled in the art a more intuitive understanding be arranged, instrument of the present invention is described further below in conjunction with concrete applied environment to ims database access method of the present invention and the obtained effect of instrument.
In this example, described IMS access tool is made up of master routine REXX (Restructured extenderexecutor) program and COBOL (Common Business Oriented Language) program.Wherein, REXX is used for the DBD of database and/or COPYBOOK are resolved generation meta data or format displaying by presetting rule, and calls the COBOL entry program, finishes the preliminary work of visit IMS; Cobol program generates the DL/1call of visit ims database according to the data received and instruction, then by calling the access interface visit IMS that IMS provides, and the result is returned to master routine; Press form by master routine at last and show the visit result.
Its detailed process is: at first, the user starts instrument, behind the input database title DB1, shows the frag info in this database, as shown in Figure 4.Then, the user selects fragment SEGA, imports a key assignments 10001 of this fragment, the input S that reads instruction simultaneously, and the meaning is to read the information that key assignments is 10001 fragment SEGA.Then, instrument generates DML and visits ims database according to the key assignments 10001 and the instruction S of user's input.Last display access result, as shown in Figure 5.
More than to a kind of Method and kit for of visiting ims database provided by the present invention, be described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (9)
1, a kind of ims database interdynamic access method is characterized in that, may further comprise the steps:
The database structure definition of ims database is resolved and generate the database structure metadata by presetting rule, and fragment field metadata is resolved and generated in the fragment field definition of ims database by presetting rule;
According to the definition of described database structure metadata and/or fragment field metadata, the data of storing in the described ims database are generated video data; Described video data is the analysis result of the data of being stored in the described ims database;
According to the definition of database structure metadata and/or fragment field metadata, described video data and/or user input data that the user is selected generate target data, and described target data is used for the data that identifying user need be visited;
Described target data and corresponding instruction information are generated database manipulation language DML by presetting rule, and described command information is the concrete visit behavior of user to data;
Utilize described DML to visit described ims database.
2, ims database interdynamic access method according to claim 1 is characterized in that, also comprises:
Described video data is carried out dynamic translation by predetermined multiple form.
3, ims database interdynamic access method according to claim 2 is characterized in that, described predetermined multiple form includes but not limited to database structure definition and/or the definition of fragment field and/or the hexadecimal format of described ims database.
4, ims database interdynamic access method according to claim 3 is characterized in that, also comprises:
Control of authority is carried out in visit behavior to the user.
5, ims database interdynamic access method according to claim 4 is characterized in that, also comprises:
The operation of record access ims database also generates log information.
6, the interactive access tool of a kind of ims database is characterized in that, comprises interactive device, service data maker and addressed location, wherein,
Described interactive device also comprises:
The database structure resolution unit is used for resolving the database structure information of ims database and generating the database structure metadata by presetting rule;
Fragment field resolution unit is used for resolving the fragment field information of ims database and generating fragment field metadata by presetting rule;
Display unit is used for data that ims database is stored and is shown as video data by the database structure definition and/or the definition of fragment field of described ims database; Described video data is the analysis result of the data of being stored in the described ims database;
Input block is used to receive user's input;
The target data generation unit, be used for definition according to database structure metadata and/or fragment field metadata, video data and/or user input data that the user is selected generate target data, described user input data is received by described input block, and described target data is used for the data that identifying user need be visited;
The service data maker is used for the command information of target data and input block reception is generated database manipulation language DML, and described command information is the concrete visit behavior of user to data;
Addressed location is used for visiting described ims database by described DML.
7, the interactive access tool of ims database according to claim 5 is characterized in that, also comprises:
The dynamic format converting unit, be used for the video data of display unit is carried out dynamic translation by predetermined multiple form, described predetermined multiple form includes but not limited to database structure definition and/or the definition of fragment field and/or the hexadecimal format of ims database.
8, the interactive access tool of ims database according to claim 7 is characterized in that, also comprises:
The safety control unit is used for control of authority is carried out in user's visit behavior.
9, the interactive access tool of ims database according to claim 8 is characterized in that, also comprises:
Log unit is used to write down visit and generation log information to IMS.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101732252A CN100527131C (en) | 2006-12-30 | 2006-12-30 | Interdynamic access method and tool of IMS data base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101732252A CN100527131C (en) | 2006-12-30 | 2006-12-30 | Interdynamic access method and tool of IMS data base |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101000621A CN101000621A (en) | 2007-07-18 |
| CN100527131C true CN100527131C (en) | 2009-08-12 |
Family
ID=38692593
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2006101732252A Active CN100527131C (en) | 2006-12-30 | 2006-12-30 | Interdynamic access method and tool of IMS data base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100527131C (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101237449B (en) * | 2008-02-01 | 2012-08-22 | 中国建设银行股份有限公司 | Method and system for access to IMS database |
| CN101446962B (en) * | 2008-12-31 | 2011-02-02 | 中国建设银行股份有限公司 | Data conversion method, device thereof and data processing system |
| EP2399192A4 (en) * | 2009-02-13 | 2016-09-07 | Ab Initio Technology Llc | Communicating with data storage systems |
| CA2782414C (en) | 2009-12-14 | 2021-08-03 | Ab Initio Technology Llc | Specifying user interface elements |
| US11423083B2 (en) | 2017-10-27 | 2022-08-23 | Ab Initio Technology Llc | Transforming a specification into a persistent computer program |
| CN112115122A (en) * | 2020-09-18 | 2020-12-22 | 北京金山云网络技术有限公司 | Data access method and device and electronic equipment |
-
2006
- 2006-12-30 CN CNB2006101732252A patent/CN100527131C/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN101000621A (en) | 2007-07-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107247808B (en) | Distributed NewSQL database system and picture data query method | |
| US9830341B2 (en) | Resource name generation and derivation utilizing attribute space monikers and their associated context | |
| US8346812B2 (en) | Indexing in a resource description framework environment | |
| US20060020578A1 (en) | Time stamp methods for unified plant model | |
| CN100527131C (en) | Interdynamic access method and tool of IMS data base | |
| CN112685433B (en) | Metadata updating method and device, electronic equipment and computer-readable storage medium | |
| US20140046928A1 (en) | Query plans with parameter markers in place of object identifiers | |
| TW200903324A (en) | Systems and methods for modeling partitioned tables as logical indexes | |
| CN111324610A (en) | Data synchronization method and device | |
| US7937686B2 (en) | Name-based identifiers of model elements | |
| CN102708203A (en) | Database dynamic management method based on XML metadata | |
| CN110134681B (en) | Data storage and query method and device, computer equipment and storage medium | |
| US5742809A (en) | Database generic composite structure processing system | |
| CN112507067B (en) | Cache plug-in annotating device and annotation method | |
| KR101877828B1 (en) | User interface integrated platform system based on artificial intelligence | |
| CN111240772A (en) | Data processing method and device based on block chain and storage medium | |
| CN116610694A (en) | Rule verification method and system based on relation between columns and access sentences | |
| US8005844B2 (en) | On-line organization of data sets | |
| CN111752549A (en) | SQL function generation method and device | |
| CN111125216A (en) | Method and device for importing data into Phoenix | |
| US20070239794A1 (en) | Method and system for updating logical information in databases | |
| CN115114297A (en) | Data lightweight storage and search method and device, electronic equipment and storage medium | |
| CN111259003B (en) | Database establishment method and device | |
| US6925630B1 (en) | Method for generating code for processing a database | |
| WO2017072872A1 (en) | Business program generation assistance system and business program generation assistance method |
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 |