CN105243162A - Relational database storage-based objective data model query method and device - Google Patents
Relational database storage-based objective data model query method and device Download PDFInfo
- Publication number
- CN105243162A CN105243162A CN201510726279.6A CN201510726279A CN105243162A CN 105243162 A CN105243162 A CN 105243162A CN 201510726279 A CN201510726279 A CN 201510726279A CN 105243162 A CN105243162 A CN 105243162A
- Authority
- CN
- China
- Prior art keywords
- model
- inquiry request
- element value
- value
- record
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a relational database storage-based objective data model query method and device. The method comprises the following steps: receiving a query request transmitted by a user, wherein the query request comprises one or more conditional terms or a combination relation thereof; associating tables with an association relation in a relation database in advance according to a data model structure of a structured object, and setting the conditional terms and optional combination relation between the conditional terms; determining an expansion method on the basis of the association relation between the tables in a relational database and query request conditions, and expanding the content recorded in all tables into a two-dimensional virtual view including a plurality of records according to the determined expansion method, wherein one record comprises the content of all elements included in various branches in the data model of the structured object; and searching the records which conform to the query conditions in the two-dimensional virtual view, and displaying the records in a query interface according to the form of the data model of the structured object. According to the relational database storage-based objective data model query method and device, the retrieval efficiency of the relational database is improved.
Description
Technical field
The present invention relates to field of database query technology, particularly relate to a kind of objectification data model querying method based on relational data library storage and device.
Background technology
Structural data for conventional data centers all uses relevant database to store, and advantage is that relation is clear and definite, and data query access efficiency is high, shortcoming is that multiple tables of data scatter store, remote with service concept gap, poor intuition, understanding has difficulties.So start in recent years to rise master data management (MDM) system gradually, master data management system carrys out management data in the mode of objectification data model, more be close to business practice, concerning all more directly perceived and easy-to-use the supvr of data or user.
But be all relevant database because current data center is widely used, therefore based on the data management of object model, its bottom stores still mainly relevant database.Due to the difference that object-oriented model access and relational data are accessed, the object model data based on relational data library storage is made to run into very large obstacle when access queries, mode and the result of inquiry are all restricted, and are difficult to the retrieval given full play to based on object model and are intended to.
The existing inquiry mode based on object model, is substantially all the condition based on master cast element, filters master cast object.Or although the conditional combination of master cast element condition and its embedded submodel array can be set simultaneously, but can only position master cast object, qualified master cast object and its embedded submodel object combination can not be oriented exactly, greatly limit the range of application of object model data management, make it be difficult to comparatively complicated query function.
Summary of the invention
The invention provides a kind of objectification data model querying method based on relational data library storage and device, the inquiry of objectification model can be converted to easily the inquiry based on bivariate table, improve the search efficiency to relevant database.
The invention provides a kind of objectification data model querying method based on relational data library storage, comprising:
Receive the inquiry request that user sends on query interface, described inquiry request comprises a condition entry, or comprise multiple condition entry and syntagmatic thereof, wherein, in advance by the data model structure of structured object, table relevant in relevant database is associated, and on query interface optional syntagmatic between setting model item and condition entry, the element value of the arbitrary element of a condition entry corresponding objects;
Based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, wherein, the content of all elements recording the data model Zhong Ge branch that comprises structured object and comprise;
Based on described two-dimensional virtual view, in described two-dimensional virtual view, search the record meeting querying condition, each element in record is displayed at query interface according to the form of the data model of structured object.
Preferably, in described relevant database, for the basic model of object, adopt an element showing to store basic model, an element of the corresponding basic model of a field in table; For the Derived model derived from by basic model, adopt another table to store the element of described Derived model, table relevant in relevant database associated, specifically comprises:
Adopt the specific field in the table of basic model and the table of Derived model, two tables are associated; Or
A newly-built table, associates the table of basic model and the table of Derived model.
Preferably, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded minor structure wherein, embedded minor structure and element at the same level use same to table or use another kind to show to store, when using another table to store, table relevant in relevant database being associated, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded minor structure, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded minor structure.
Preferably, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded subobject array wherein, embedded subobject array uses another kind of table to store, and is associated by table relevant in relevant database, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded subobject array, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded subobject array.
Preferably, in described relevant database, the element at the same level of object is stored in same table, arbitrary element content for object adopts the element of code, the content mapped by this code stores dictionary table and stores, table relevant in relevant database is associated, specifically comprises:
The table of code is adopted to associate with dictionary table by storing content.
Preferably, based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, specifically comprises:
Based on the incidence relation in relevant database between table, determine all elements included by data model Zhong Ge branch of structured object, and retrieve all elements value of each element;
Determine the element value of each element comprised in inquiry request, if in inquiry request each element only corresponding element value, the element value extracting each element in all elements included by each branch retrieved forms one and records and launch;
If corresponding N number of element value of at least one element in inquiry request and be or relation, in all elements included by each branch that extraction retrieves, an element value of each element forms one and records and launch;
If the corresponding N number of element value of at least one element in inquiry request and N number of element value be and relation, for the element comprising N number of element value in inquiry request, extract N number of element value, one formed for other element extraction element value and records and launch, N be greater than 1 positive integer.
Preferably, each element in record is displayed at query interface according to the form of the data model of structured object, specifically comprises:
By many records that in record, the element value of other element is identical except the element belonged in inquiry request, be a record according to the model combination of object, if the element value belonging to element in inquiry request in many records merged is one, then in the record merged, show this element value, if the element value belonging to element in inquiry request in many records merged is multiple, the plurality of element value is shown with the form of array.
Preferably, by record in each element according to the model of structured object form query interface show before, also comprise:
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, be many records that the element value of the element of fundamental element is identical by type in record, be a record according to the model combination of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
The present invention also provides a kind of objectification data model inquiry unit based on relational data library storage, it is characterized in that, comprising:
Request reception unit, for receiving the inquiry request that user sends on query interface, described inquiry request comprises a condition entry, or comprise multiple condition entry and syntagmatic thereof, wherein, in advance by the data model structure of structured object, table relevant in relevant database is associated, and on query interface optional syntagmatic between setting model item and condition entry, the element value of the arbitrary element of a condition entry corresponding objects;
View expanding unit, for based in relevant database table between incidence relation and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, wherein, the content of all elements recording the data model Zhong Ge branch that comprises structured object and comprise;
Query display unit, for based on described two-dimensional virtual view, searches the record meeting querying condition in described two-dimensional virtual view, is displayed by each element in record according to the form of the data model of structured object at query interface.
Preferably, in described relevant database, for the basic model of object, adopt an element showing to store basic model, an element of the corresponding basic model of a field in table; For the Derived model derived from by basic model, adopt another table to store the element of described Derived model, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of basic model and the table of Derived model, two tables are associated; Or
A newly-built table, associates the table of basic model and the table of Derived model.
Preferably, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded minor structure wherein, embedded minor structure and element at the same level use same to table or use another kind to show to store, when using another table to store, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded minor structure, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded minor structure.
Preferably, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded subobject array wherein, embedded subobject array uses another kind of table to store, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded subobject array, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded subobject array.
Preferably, in described relevant database, the element at the same level of object is stored in same table, arbitrary element content for object adopts the element of code, the content mapped by this code stores dictionary table and stores, table relevant in relevant database associates by request reception unit, specifically comprises:
The table of code is adopted to associate with dictionary table by storing content.
Preferably, the content of all table records, based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, specifically comprises by view expanding unit:
Based on the incidence relation in relevant database between table, determine all elements included by data model Zhong Ge branch of structured object, and retrieve all elements value of each element;
Determine the element value of each element comprised in inquiry request, if in inquiry request each element only corresponding element value, the element value extracting each element in all elements included by each branch retrieved forms one and records and launch;
If corresponding N number of element value of at least one element in inquiry request and be or relation, in all elements included by each branch that extraction retrieves, an element value of each element forms one and records and launch;
If the corresponding N number of element value of at least one element in inquiry request and N number of element value be and relation, for the element comprising N number of element value in inquiry request, extract N number of element value, one formed for other element extraction element value and records and launch, N be greater than 1 positive integer.
Preferably, each element in record displays at query interface according to the form of the data model of structured object by view expanding unit, specifically comprises:
By many records that in record, the element value of other element is identical except the element belonged in inquiry request, be a record according to the model combination of object, if the element value belonging to element in inquiry request in many records merged is one, then in the record merged, show this element value, if the element value belonging to element in inquiry request in many records merged is multiple, the plurality of element value is shown with the form of array.
Preferably, view expanding unit by record in each element according to the model of structured object form query interface show before, also comprise:
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, be many records that the element value of the element of fundamental element is identical by type in record, be a record according to the model combination of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
Objectification data model querying method based on relational data library storage provided by the invention and device, have following beneficial effect:
The inquiry of objectification data model can be converted to easily the inquiry based on bivariate table, user can use the element of master cast and embedded submodel the element even element of grandson's model to carry out combination in any as querying condition intuitively, retrieve the combination of qualified master cast record and embedded descendants's model record thereof exactly, and result is represented user with the form that represents of model object, the recall precision of its recall precision and universal relation type storehouse bivariate table is basically identical simultaneously.
Accompanying drawing explanation
The objectification data model querying method process flow diagram based on relational data library storage that Fig. 1 provides for the embodiment of the present invention;
The objectification data model inquiry unit structural drawing based on relational data library storage that Fig. 2 provides for the embodiment of the present invention.
Embodiment
Below in conjunction with drawings and Examples, the objectification data model querying method based on relational data library storage provided by the invention is illustrated in greater detail.
One large feature of master data management system is exactly carry out data of description in the mode of objectification data model, and ways of presentation and storage inside mode are separated, representing of data is carried out in the mode of business object more.But be limited by the bivariate table memory module of bottom relevant database, its queried access based on business object is subject to severely restricts, simple attributes condition can only be set using master cast object as searched targets, combination condition cannot be used or embedded submodel object cannot be located, there is various defect.
Object of the present invention, the data management solved exactly based on object model changes difference with based on being connected between relational data library storage, the data management query and search function based on object model is made to have with more directly perceived while of equally powerful based on the database retrieval of bivariate table and press close to business, and ensure the efficiency be close, meet actual business requirement, advance the widespread use of object model data management mode, improve search efficiency.
The invention provides a kind of objectification pattern query method based on relevant database, as shown in Figure 1, comprising:
Step 101, receive the inquiry request that user sends on query interface, described inquiry request comprises a condition entry, or comprise multiple condition entry and syntagmatic thereof, wherein, in advance by the data model structure of structured object, table relevant in relevant database is associated, and on query interface optional syntagmatic between setting model item and condition entry, the element value of the arbitrary element of a condition entry corresponding objects;
Object-oriented model data management, what first set up is the business description model of objectification, the data model of object comprises basic model, Derived model, basic model comprises at least one element, Derived model is inherited by basic model, except the element with mistake basic model, Derived model comprises at least one element, such as people is as a basic model, the element of people comprises name, sex, age, student, doctor is the Derived model of people, the element of student comprises I.D., student number, school, contact method etc., the element of doctor comprises hospital, academic title, section office, the place etc. be.
Embedded minor structure and embedded subobject array are two kinds of common forms of element, embedded minor structure comprises multiple element, multiple element is under the jurisdiction of embedded minor structure, and such as contact method can be embedded minor structure, and contact method can comprise the elements such as mobile phone, mail, mailing address.When an element comprises the content of multiple same nature, this element is embedded subobject array, and the place that such as doctor has been can be embedded subobject array, and the place that doctor has been can be Tianjin, Guangzhou, Sanya etc.
The data model of object can be divided into basic model and Derived model from whether having derived relation, from whether having embedded subobject array, father's model-submodel-grandson's model etc. can be divided into, multiple separate submodel object array can be comprised in father's model, multiple independently grandson model object array can be comprised again in each submodel object, so nested, a complicated multi-level structured object data model can be formed.Nested owing to allowing, finally can form the object model of a tree structure, so object model, can be understood as the tree structure comprising multiple multiple branches from start node to end node, node at different levels can be understood as the element of object.
Widespread demand is there is in the object model with multiple descendants array in real service application, such as: school-class-student+course prototype, hospital-section office-doctor's model, family-member-contact method model etc., although show as a complete object model in appearance, when backstage uses relational data library storage, its data may be disperseed to store corresponding on several even tens tables.
Particularly, the embodiment of the present invention, in relevant database, for the basic model of object, adopts an element showing to store basic model, an element of the corresponding basic model of a field in table; For the Derived model derived from by basic model, another table is adopted to store the element of described Derived model.
Preferably, table relevant in relevant database associates by the embodiment of the present invention in advance, can adopt following either type:
1) adopt the specific field in the table of basic model and the table of Derived model, two tables are associated;
Such as the basic model of people, one can be adopted to table to store, field in table is identification card number, name, sex, age, for the Derived model of student, another kind of table can be adopted to store, and the field in table is student number, school and admission time etc., because identification card number can unique identification object, therefore by increasing identification card number in the table of student, two tables are associated.
2) a newly-built table, associates the table of basic model and the table of Derived model.
Can a newly-built table, the field in table is I.D. and student number, sets up corresponding relation, thus associated by two tables by the student number during the identification card number in people's base table and student show.
The embodiment of the present invention is in relevant database, and the element at the same level of object is stored in same table, and when an element is embedded minor structure wherein, embedded minor structure and element at the same level can use same to table or use another kind to show to store.In the objectification data model of tree structure, the element being under the jurisdiction of same node can be understood as element at the same level, and the form of element may be Derived model, may be embedded minor structure, also can be embedded subobject array, also can be the fundamental element only comprising a content.Under normal circumstances, element at the same level is stored in same table, is the element of embedded minor structure for form, same can be used to table to store with element at the same level, and another table also can be used to store.
Preferably, when using another table to store, table relevant in relevant database being associated, specifically can adopt following either type:
1) adopt the specific field in the table of the table of element at the same level and embedded minor structure, two tables are associated;
The element of such as people comprises name, age, sex, contact method, contact method comprises mobile phone, mail, mailing address, contact method is embedded minor structure, name, age, sex can be stored as a table, mobile phone, mail, mailing address are stored as another kind of table, during two can be utilized to show, two tables are associated by the number field of representative's unique identities.
2) a newly-built table, associates the table of the table of element at the same level and embedded minor structure.
The element of such as people comprises name, age, sex, contact method, contact method comprises mobile phone, mail, mailing address, contact method is embedded minor structure, name, age, sex can be stored as a table, mobile phone, mail, mailing address are stored as another kind of table, can a newly-built table again, the relative recording belonged in two tables of same person is associated.
The embodiment of the present invention is in relevant database, and the element at the same level of object is stored in same table, and when an element is embedded subobject array wherein, embedded subobject array uses another kind of table to store.In the objectification model of tree structure, the element being under the jurisdiction of same node can be understood as element at the same level, and the form of element may be Derived model, may be embedded minor structure, also can be embedded subobject array, also can be the fundamental element only comprising a content.
Table relevant in relevant database associates by the embodiment of the present invention, specifically can adopt following either type:
1) adopt the specific field in the table of the table of element at the same level and embedded subobject array, two tables are associated;
Such as hospital, its element comprises the section office of hospital name, hospital's numbering, hospital, the section office of hospital are embedded subobject array, one can be used to table to store hospital name, hospital's numbering, another kind of table stores hospital's numbering, section office's title, section office's brief introduction etc., thus can be associated by two tables by the numbering of hospital.
2) a newly-built table, associates the table of the table of element at the same level and embedded subobject array.
Such as hospital, its element comprises the section office of hospital name, hospital's numbering, hospital, the section office of hospital are embedded subobject array, one can be used to table to store hospital name, hospital's numbering, another kind of table stores section office's numbering, section office's title, a newly-built table, stores hospital's numbering, section office's numbering, thus can be associated by two tables by hospital's numbering and section office's numbering.
In relevant database, the element at the same level of object is stored in same table, in the objectification model of tree structure, the element being under the jurisdiction of same node can be understood as element at the same level, the form of element may be Derived model, may be embedded minor structure, also can be embedded subobject array, also can be the fundamental element only comprising a content.
Arbitrary element content for object adopts the element of code, and its content needs to rely on other explanation type contents and just can correctly represent.The content mapped by this code stores dictionary table and stores, and is associated by table relevant in relevant database, specifically comprises:
The table of code is adopted to associate with dictionary table by storing content.
Such as section office, can its concrete corresponding section office's title of the code representative such as 11,12, dictionary table at least comprises code field, code interpreter field.In order to prevent the code content that possibility is corresponding different in multiple table, preferably, can increase a type field in field, the implication representated by code is mapped to this field, searches the code interpreter content that corresponding code is corresponding in the record that field is corresponding.
The embodiment of the present invention is according to the common pattern of the model of object, give and table relevant in relevant database is associated, concrete interrelational form is not limited thereto, and the object of association to find the arbitrary element of in the object model of tree structure arbitrary grade.
Owing to establishing the incidence relation between table in advance, therefore relative to multiple mapping relations shown of the data model and database that establish object, realized the tree structure of simulated object data model by the incidence relation of relevant database bivariate table.
In order to realize can carrying out combination in any to the object of tree structure element at different levels as querying condition, the invention process adds query interface, this query interface is the interface of dynamic adding conditional item, the number of condition entry dynamically can increase according to the needs of inquiry, each condition entry is to an element setting model, can the element value of arbitrary element of alternative, operational character can be equal, be not equal to, be greater than, be less than, comprise, interval, same element in embedded subobject array allows to appear in more than one condition item, can arrange and/or composition of relations between condition entry, thus realize the setting of complex combination condition.
Step 102, based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, wherein, the content of all elements recording the data model Zhong Ge branch that comprises structured object and comprise;
As previously mentioned, based on the incidence relation in relevant database between table, can find from start node to all elements included by each branch of each end node in the object of tree structure, and retrieve all elements value of each element.
This step is actual is based on the incidence relation in relevant database between table, multiple tables of backstage relevant database reality (are derived from by join or leftjoin pattern and use join pattern, embedded subobject array adopts leftjoin) expand into a large two-dimensional virtual view, article one, record can be understood as the record comprising each branch all elements, therefore in this two-dimensional virtual view, it is no matter the element of which rank of node, namely no matter be the element of main object or the element of descendants, be all unfolded as the element at the same level in two-dimensional virtual view.
Step 103, based on described two-dimensional virtual view, searches the record meeting querying condition in described two-dimensional virtual view, is displayed by each element in record according to the form of the data model of structured object at query interface.
Each branch all elements of object can be comprised in record, and querying condition is the setting of object-based arbitrary element, therefore, the element value of element in inquiry request and the element value of respective element in record can be compared, thus filtering out qualified record, the form that represents of this record is that element at different levels is represented form as element at the same level, needs the data model according to object, what be converted into tree structure represents form, thus meets query demand.
Preferably, in step 102, each element in record is displayed at query interface according to the form of the data model of structured object, specifically comprises:
Based on the incidence relation in relevant database between table, determine all elements included by data model Zhong Ge branch of structured object, and retrieve all elements value of each element;
Determine the element value of each element comprised in inquiry request, if in inquiry request each element only corresponding element value, the element value extracting each element in all elements included by each branch retrieved forms one and records and launch;
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, in all elements included by each branch that extraction retrieves, an element value of each element forms one and records and launch;
If the corresponding N number of element value of at least one element in inquiry request and N number of element value be and relation, for the element comprising N number of element value in inquiry request, extract N number of element value, one formed for other element extraction element value and records and launch, N be greater than 1 positive integer.
Illustrate, people-name+age+occupation in place+be engaged in of sex+be, the place be is subobject array 1, the occupation be engaged in is also subobject array 2, and for this object of Zhang San, subobject array 1 can comprise following content: Tianjin, Guangzhou, Sanya, Haikou, subobject array 2 comprises teacher, doctor, based on the incidence relation between table, when carrying out two-dimensional virtual view shows, need Zhang San name+age+occupation in place+be engaged in of sex+be.If what arrange in inquiry request is to inquire about the record being Tianjin, then need to arrange an element value (Tianjin) for the place be, then the expansion form for the record of Zhang San is:
Zhang San, 40, man, Tianjin, teacher;
Zhang San, 40, man, Guangzhou, teacher;
Zhang San, 40, man, Sanya, teacher;
Zhang San, 40, man, Haikou, teacher;
Zhang San, 40, man, Tianjin, doctor;
Zhang San, 40, man, Guangzhou, doctor;
Zhang San, 40, man, Sanya, doctor;
Zhang San, 40, man, Haikou, doctor.
Equally, for other objects such as Li Sis, be also adopt this expansion form, the element value namely extracting each element in all elements included by each branch retrieved forms one and records and launch, when identity element has multiple different element value, adopt many record displays.
If the corresponding N number of element value of at least one element in inquiry request, such as need to inquire about the people being not only Tianjin but also being Guangzhou, if what arrange in inquiry request is will inquire about to be Tianjin and the record being Guangzhou, then need to arrange two element values (Tianjin, Guangzhou) for the place be, arrange its syntagmatic be and relation, then when showing, for this element of the place be, need extraction 2 values, form one for other element extraction element value record and launch, concrete expansion mode is as follows:
Zhang San, 40, man, Tianjin, Guangzhou, teacher;
Zhang San, 40, man, Tianjin, Sanya, teacher;
Zhang San, 40, man, Tianjin, Haikou, teacher;
Zhang San, 40, man, Guangzhou, Sanya, teacher;
Zhang San, 40, man, Guangzhou, Haikou, teacher;
Zhang San, 40, man, Haikou, Sanya, teacher;
Zhang San, 40, man, Tianjin, Guangzhou, doctor;
Zhang San, 40, man, Tianjin, Sanya, doctor;
Zhang San, 40, man, Tianjin, Haikou, doctor;
Zhang San, 40, man, Guangzhou, Sanya, doctor;
Zhang San, 40, man, Guangzhou, Haikou, doctor;
Zhang San, 40, man, Haikou, Sanya, doctor.
Equally, for other objects such as Li Sis, be also adopt this expansion form.
Step 102, what realize is the querying condition be converted to by the querying condition arranged for element each in object model for the element in virtual two-dimensional view, identity element for same subobject is set up two or more and requires qualified situation simultaneously, because the table of its correspondence is by leftjoin many times, multiple condition must be corresponded on different elements respectively.
Preferably, in step 103, each element in record is displayed at query interface according to the form of the data model of structured object, specifically comprises:
Be many records that the element value of the element of fundamental element is identical by type in record, a record is merged into according to the data model of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
Still be described with above-mentioned citing, if what arrange in inquiry request is to inquire about the record being Tianjin, then can retrieve following record:
Zhang San, 40, man, Tianjin, teacher;
Zhang San, 40, man, Tianjin, doctor;
Due in the model of object, name, sex and age are fundamental element, therefore a record can be merged in Zhang San's two record:
Zhang San, 40, man, Tianjin, { teacher, doctor }
If what arrange in inquiry request is will inquire about to be Tianjin and the record being Guangzhou, then can retrieve following record:
Zhang San, 40, man, Tianjin, Guangzhou, teacher;
Zhang San, 40, man, Tianjin, Guangzhou, doctor;
Due in the model of object, name, sex and age are fundamental element, therefore a record can be merged in Zhang San's two record:
Zhang San, 40, man, { Tianjin, Guangzhou }, { teacher, doctor }
Visible, each element value on the record be retrieved is corresponding with the element of virtual two-dimensional table.After obtaining these qualified records, again assemble the element of these records, the mode launched according to two dimension view carries out reverse folding mapping, is corresponded to by each element value on the corresponding element of object model again.Same element for same subobject is set up two or more and requires qualified situation simultaneously, can produce two or more similar subobjects, form array after folding mapping.
Preferably, the embodiment of the present invention by record in each element according to the data model of structured object form query interface show before, also comprise:
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, be many records that the element value of the element of fundamental element is identical by type in record, be a record according to the model combination of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
Still be described with above-mentioned citing, if what arrange in inquiry request is to inquire about the record being Tianjin or Guangzhou, then can retrieve following record:
Zhang San, 40, man, Tianjin, teacher;
Zhang San, 40, man, Tianjin, doctor;
Zhang San, 40, man, Guangzhou, teacher;
Zhang San, 40, man, Guangzhou, doctor.
Due in the model of object, name, sex and age are fundamental element, therefore a record can be merged in Zhang San's two record:
Zhang San, 40, man, { Tianjin, Guangzhou }, { teacher, doctor }
The result of virtual two-dimensional view query is the result launched completely, the results conversion launched completely can be the form of expression of object model by the assembling carried out in step 103, and it takes the form of all enumerates one time by qualified permutation and combination in the mode of object model.
On this basis, the merging carrying out result can be needed according to what apply, such as carry out uniqueness merging according to main object, so just Query Result is carried out uniqueness merger according to main object, the subobject array of each correspondence also carries out merger respectively, so be just met all main object of querying condition, the subobject array simultaneously occurred in these main objects also meets querying condition.
The present invention uses relevant database to carry out the object model of structured, all use certain relation table and mutual relationship to be described the characteristics such as the base attribute of structured object model, derivation, embedded minor structure, embedded subobject array, make structured object data that multiple relation tables can be used to carry out storing and mapping.Multiple relation tables of backstage corresponding for object model are built into a virtual two dimension view according to the characteristic of object model and querying condition characteristic; By the querying condition that the structured combinations querying condition conversion map arranged for structured object model is for virtual two-dimensional view; Folded inverted mapping mode is used to be assemblied into data structure corresponding to structural model object by inquiring about the single record of the result obtained for two dimension view; The merger item that the data structure that multiple structural model objects inquiry obtained are corresponding needs according to application carries out array merger, obtains meeting the main object of querying condition and result formats and the subobject array of correspondence thereof.
Adopt apparatus and method of the present invention, the inquiry of objectification data model can be converted to easily the inquiry based on bivariate table, user can use the element of master cast and embedded submodel the element even element of grandson's model to carry out combination in any as querying condition intuitively, retrieve the combination of qualified master cast object record and embedded descendants's model object record thereof exactly, and its Query Result is re-assemblied the form of expression meeting model object appearance, the recall precision of its recall precision and universal relation type storehouse bivariate table is basically identical simultaneously, make the retrieval and inquisition ability based on model object can meet the demand of practical application.
Based on same inventive concept, a kind of objectification data model inquiry unit based on relational data library storage is additionally provided in the embodiment of the present invention, the principle of dealing with problems due to this device is similar to a kind of objectification pattern query method based on relevant database, therefore the enforcement of this device see the enforcement of method, can repeat part and repeats no more.
The invention provides a kind of objectification pattern query device based on relevant database, as shown in Figure 2, comprising:
Request reception unit 201, for receiving the inquiry request that user sends on query interface, described inquiry request comprises a condition entry, or comprise multiple condition entry and syntagmatic thereof, wherein, in advance by the data model structure of structured object, table relevant in relevant database is associated, and on query interface optional syntagmatic between setting model item and condition entry, the element value of the arbitrary element of a condition entry corresponding objects;
View expanding unit 202, for based in relevant database table between incidence relation and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, wherein, the content of all elements recording the data model Zhong Ge branch that comprises structured object and comprise;
Query display unit 203, for based on described two-dimensional virtual view, searches the record meeting querying condition in described two-dimensional virtual view, is displayed by each element in record according to the form of the data model of structured object at query interface.
Preferably, in described relevant database, for the basic model of object, adopt an element showing to store basic model, an element of the corresponding basic model of a field in table; For the Derived model derived from by basic model, adopt another table to store the element of described Derived model, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of basic model and the table of Derived model, two tables are associated; Or
A newly-built table, associates the table of basic model and the table of Derived model.
Preferably, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded minor structure wherein, embedded minor structure and element at the same level use same to table or use another kind to show to store, when using another table to store, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded minor structure, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded minor structure.
Preferably, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded subobject array wherein, embedded subobject array uses another kind of table to store, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded subobject array, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded subobject array.
Preferably, in described relevant database, the element at the same level of object is stored in same table, arbitrary element content for object adopts the element of code, the content mapped by this code stores dictionary table and stores, table relevant in relevant database associates by request reception unit, specifically comprises:
The table of code is adopted to associate with dictionary table by storing content.
Preferably, the content of all table records, based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, specifically comprises by view expanding unit:
Based on the incidence relation in relevant database between table, determine all elements included by data model Zhong Ge branch of structured object, and retrieve all elements value of each element;
Determine the element value of each element comprised in inquiry request, if in inquiry request each element only corresponding element value, the element value extracting each element in all elements included by each branch retrieved forms one and records and launch;
If corresponding N number of element value of at least one element in inquiry request and be or relation, in all elements included by each branch that extraction retrieves, an element value of each element forms one and records and launch;
If the corresponding N number of element value of at least one element in inquiry request and N number of element value be and relation, for the element comprising N number of element value in inquiry request, extract N number of element value, one formed for other element extraction element value and records and launch, N be greater than 1 positive integer.
Preferably, each element in record displays at query interface according to the form of the data model of structured object by view expanding unit, specifically comprises:
By many records that in record, the element value of other element is identical except the element belonged in inquiry request, be a record according to the model combination of object, if the element value belonging to element in inquiry request in many records merged is one, then in the record merged, show this element value, if the element value belonging to element in inquiry request in many records merged is multiple, the plurality of element value is shown with the form of array.
Preferably, view expanding unit by record in each element according to the model of structured object form query interface show before, also comprise:
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, be many records that the element value of the element of fundamental element is identical by type in record, be a record according to the model combination of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
The existing inquiry mode based on object model, is substantially all the condition based on master cast element, filters master cast object.Or although the conditional combination of master cast element condition and its embedded submodel array can be set simultaneously, can only position master cast object, qualified master cast object and its embedded submodel object combination can not be oriented exactly.
Adopt apparatus and method of the present invention, the inquiry of objectification model can be converted to easily the inquiry based on bivariate table, user can use the element of master cast and embedded submodel the element even element of grandson's model to carry out combination in any as querying condition intuitively, retrieve the combination of qualified master cast object record and embedded descendants's model object record thereof exactly, and result is represented user with the form that represents of model object, the recall precision of its recall precision and universal relation type storehouse bivariate table is basically identical simultaneously.
The present invention describes with reference to according to the process flow diagram of the method for the embodiment of the present invention, equipment (system) and computer program and/or block scheme.Should understand can by the combination of the flow process in each flow process in computer program instructions realization flow figure and/or block scheme and/or square frame and process flow diagram and/or block scheme and/or square frame.These computer program instructions can being provided to the processor of multi-purpose computer, special purpose computer, Embedded Processor or other programmable data processing device to produce a machine, making the instruction performed by the processor of computing machine or other programmable data processing device produce device for realizing the function of specifying in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
These computer program instructions also can be stored in can in the computer-readable memory that works in a specific way of vectoring computer or other programmable data processing device, the instruction making to be stored in this computer-readable memory produces the manufacture comprising command device, and this command device realizes the function of specifying in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
These computer program instructions also can be loaded in computing machine or other programmable data processing device, make on computing machine or other programmable devices, to perform sequence of operations step to produce computer implemented process, thus the instruction performed on computing machine or other programmable devices is provided for the step realizing the function of specifying in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
Although describe the preferred embodiments of the present invention, those skilled in the art once obtain the basic creative concept of cicada, then can make other change and amendment to these embodiments.So claims are intended to be interpreted as comprising preferred embodiment and falling into all changes and the amendment of the scope of the invention.
Obviously, those skilled in the art can carry out various change and modification to the present invention and not depart from the spirit and scope of the present invention.Like this, if these amendments of the present invention and modification belong within the scope of the claims in the present invention and equivalent technologies thereof, then the present invention is also intended to comprise these change and modification.
Claims (16)
1., based on an objectification data model querying method for relational data library storage, it is characterized in that, comprising:
Receive the inquiry request that user sends on query interface, described inquiry request comprises a condition entry, or comprise multiple condition entry and syntagmatic thereof, wherein, in advance by the data model structure of structured object, table relevant in relevant database is associated, and on query interface optional syntagmatic between setting model item and condition entry, the element value of the arbitrary element of a condition entry corresponding objects;
Based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, wherein, the content of all elements recording the data model Zhong Ge branch that comprises structured object and comprise;
Based on described two-dimensional virtual view, in described two-dimensional virtual view, search the record meeting querying condition, each element in record is displayed at query interface according to the form of the data model of structured object.
2. the method for claim 1, is characterized in that, in described relevant database, for the basic model of object, adopts an element showing to store basic model, an element of the corresponding basic model of a field in table; For the Derived model derived from by basic model, adopt another table to store the element of described Derived model, table relevant in relevant database associated, specifically comprises:
Adopt the specific field in the table of basic model and the table of Derived model, two tables are associated; Or
A newly-built table, associates the table of basic model and the table of Derived model.
3. the method for claim 1, it is characterized in that, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded minor structure wherein, embedded minor structure and element at the same level use same to table or use another kind to show to store, when using another table to store, table relevant in relevant database is associated, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded minor structure, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded minor structure.
4. the method for claim 1, it is characterized in that, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded subobject array wherein, embedded subobject array uses another kind of table to store, and is associated by table relevant in relevant database, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded subobject array, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded subobject array.
5. the method for claim 1, it is characterized in that, in described relevant database, the element at the same level of object is stored in same table, arbitrary element content for object adopts the element of code, the content mapped by this code stores dictionary table and stores, and is associated by table relevant in relevant database, specifically comprises:
The table of code is adopted to associate with dictionary table by storing content.
6. the method for claim 1, it is characterized in that, based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, specifically comprises:
Based on the incidence relation in relevant database between table, determine all elements included by data model Zhong Ge branch of structured object, and retrieve all elements value of each element;
Determine the element value of each element comprised in inquiry request, if in inquiry request each element only corresponding element value, the element value extracting each element in all elements included by each branch retrieved forms one and records and launch;
If corresponding N number of element value of at least one element in inquiry request and be or relation, in all elements included by each branch that extraction retrieves, an element value of each element forms one and records and launch;
If the corresponding N number of element value of at least one element in inquiry request and N number of element value be and relation, for the element comprising N number of element value in inquiry request, extract N number of element value, one formed for other element extraction element value and records and launch, N be greater than 1 positive integer.
7. the method for claim 1, is characterized in that, is displayed by each element in record, specifically comprise according to the form of the data model of structured object at query interface:
By many records that in record, the element value of other element is identical except the element belonged in inquiry request, be a record according to the model combination of object, if the element value belonging to element in inquiry request in many records merged is one, then in the record merged, show this element value, if the element value belonging to element in inquiry request in many records merged is multiple, the plurality of element value is shown with the form of array.
8. the method for claim 1, is characterized in that, by record in each element according to the model of structured object form query interface show before, also comprise:
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, be many records that the element value of the element of fundamental element is identical by type in record, be a record according to the model combination of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
9., based on an objectification data model inquiry unit for relational data library storage, it is characterized in that, comprising:
Request reception unit, for receiving the inquiry request that user sends on query interface, described inquiry request comprises a condition entry, or comprise multiple condition entry and syntagmatic thereof, wherein, in advance by the data model structure of structured object, table relevant in relevant database is associated, and on query interface optional syntagmatic between setting model item and condition entry, the element value of the arbitrary element of a condition entry corresponding objects;
View expanding unit, for based in relevant database table between incidence relation and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, wherein, the content of all elements recording the data model Zhong Ge branch that comprises structured object and comprise;
Query display unit, for based on described two-dimensional virtual view, searches the record meeting querying condition in described two-dimensional virtual view, is displayed by each element in record according to the form of the data model of structured object at query interface.
10. device as claimed in claim 9, is characterized in that, in described relevant database, for the basic model of object, adopts an element showing to store basic model, an element of the corresponding basic model of a field in table; For the Derived model derived from by basic model, adopt another table to store the element of described Derived model, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of basic model and the table of Derived model, two tables are associated; Or
A newly-built table, associates the table of basic model and the table of Derived model.
11. devices as claimed in claim 9, it is characterized in that, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded minor structure wherein, embedded minor structure and element at the same level use same to table or use another kind to show to store, when using another table to store, table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded minor structure, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded minor structure.
12. devices as claimed in claim 9, it is characterized in that, in described relevant database, the element at the same level of object is stored in same table, when an element is embedded subobject array wherein, embedded subobject array uses another kind of table to store, and table relevant in relevant database associates by request reception unit, specifically comprises:
Adopt the specific field in the table of the table of element at the same level and embedded subobject array, two tables are associated; Or
A newly-built table, associates the table of the table of element at the same level and embedded subobject array.
13. devices as claimed in claim 9, it is characterized in that, in described relevant database, the element at the same level of object is stored in same table, arbitrary element content for object adopts the element of code, the content mapped by this code stores dictionary table and stores, and table relevant in relevant database associates by request reception unit, specifically comprises:
The table of code is adopted to associate with dictionary table by storing content.
14. devices as claimed in claim 9, it is characterized in that, view expanding unit is based on the incidence relation in relevant database between table and inquiry request condition determination method of deploying, the content of all table records is expanded into by the method for deploying determined the two-dimensional virtual view that comprises many records, specifically comprises:
Based on the incidence relation in relevant database between table, determine all elements included by data model Zhong Ge branch of structured object, and retrieve all elements value of each element;
Determine the element value of each element comprised in inquiry request, if in inquiry request each element only corresponding element value, the element value extracting each element in all elements included by each branch retrieved forms one and records and launch;
If corresponding N number of element value of at least one element in inquiry request and be or relation, in all elements included by each branch that extraction retrieves, an element value of each element forms one and records and launch;
If the corresponding N number of element value of at least one element in inquiry request and N number of element value be and relation, for the element comprising N number of element value in inquiry request, extract N number of element value, one formed for other element extraction element value and records and launch, N be greater than 1 positive integer.
15. devices as claimed in claim 9, is characterized in that, each element in record displays at query interface according to the form of the data model of structured object by view expanding unit, specifically comprises:
By many records that in record, the element value of other element is identical except the element belonged in inquiry request, be a record according to the model combination of object, if the element value belonging to element in inquiry request in many records merged is one, then in the record merged, show this element value, if the element value belonging to element in inquiry request in many records merged is multiple, the plurality of element value is shown with the form of array.
16. devices as claimed in claim 9, is characterized in that, view expanding unit by record in each element according to the model of structured object form query interface show before, also comprise:
Determine the element value of each element comprised in inquiry request, if corresponding N number of element value of at least one element in inquiry request and be or relation, be many records that the element value of the element of fundamental element is identical by type in record, be a record according to the model combination of object, if the element value of element is one in many records merged, then in the record merged, show this element value, if the element value of element is multiple in many records merged, the plurality of element value is shown with the form of array.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510726279.6A CN105243162B (en) | 2015-10-30 | 2015-10-30 | Objectification data model querying method and device based on relational data library storage |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510726279.6A CN105243162B (en) | 2015-10-30 | 2015-10-30 | Objectification data model querying method and device based on relational data library storage |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105243162A true CN105243162A (en) | 2016-01-13 |
| CN105243162B CN105243162B (en) | 2018-10-30 |
Family
ID=55040810
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510726279.6A Active CN105243162B (en) | 2015-10-30 | 2015-10-30 | Objectification data model querying method and device based on relational data library storage |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105243162B (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
| CN107273394A (en) * | 2016-03-31 | 2017-10-20 | Sap欧洲公司 | The deep filter stated using explicit correlation in data model and equivalence is propagated |
| CN107341238A (en) * | 2017-07-04 | 2017-11-10 | 北京京东尚科信息技术有限公司 | Data processing method and system |
| CN107526781A (en) * | 2017-07-25 | 2017-12-29 | 无锡天脉聚源传媒科技有限公司 | A kind of information search method and device |
| CN107832349A (en) * | 2017-10-18 | 2018-03-23 | 金蝶软件（中国）有限公司 | The management method and information management system of a kind of business object |
| CN108038135A (en) * | 2017-11-21 | 2018-05-15 | 平安科技（深圳）有限公司 | Electronic device, the method for multilist correlation inquiry and storage medium |
| CN108268536A (en) * | 2016-12-30 | 2018-07-10 | 北京国双科技有限公司 | Database aggregation processing method and device |
| CN108496190A (en) * | 2016-01-27 | 2018-09-04 | 甲骨文国际公司 | Annotation system for extracting attribute from electronic-data structure |
| CN108710693A (en) * | 2018-05-22 | 2018-10-26 | 浪潮软件集团有限公司 | Data visualization method and device |
| CN109382750A (en) * | 2017-08-04 | 2019-02-26 | 杉野机械股份有限公司 | Selection method, selection device and the storage medium of the type of polishing tool |
| CN109918363A (en) * | 2019-02-25 | 2019-06-21 | 江苏电力信息技术有限公司 | The method for carrying out data model coherency management based on view integration across database type |
| CN112632037A (en) * | 2020-12-24 | 2021-04-09 | 山东浪潮通软信息科技有限公司 | Method and device for graphically defining query data set |
| CN113744359A (en) * | 2021-08-02 | 2021-12-03 | 苏州热工研究院有限公司 | Method and system for constructing nuclear power station system flow chart |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081661A (en) * | 2011-01-19 | 2011-06-01 | 吉林大学 | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) |
| CN103092998A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Data query system and data query method |
| CN104679248A (en) * | 2015-03-03 | 2015-06-03 | 江苏科技大学 | Multi-scenario interactive data visualization system and working method |
| CN104899225A (en) * | 2014-03-07 | 2015-09-09 | 北京四达时代软件技术股份有限公司 | Object relational mapping method and device as well as processor |
-
2015
- 2015-10-30 CN CN201510726279.6A patent/CN105243162B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081661A (en) * | 2011-01-19 | 2011-06-01 | 吉林大学 | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) |
| CN103092998A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Data query system and data query method |
| CN104899225A (en) * | 2014-03-07 | 2015-09-09 | 北京四达时代软件技术股份有限公司 | Object relational mapping method and device as well as processor |
| CN104679248A (en) * | 2015-03-03 | 2015-06-03 | 江苏科技大学 | Multi-scenario interactive data visualization system and working method |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108496190A (en) * | 2016-01-27 | 2018-09-04 | 甲骨文国际公司 | Annotation system for extracting attribute from electronic-data structure |
| CN107273394A (en) * | 2016-03-31 | 2017-10-20 | Sap欧洲公司 | The deep filter stated using explicit correlation in data model and equivalence is propagated |
| CN107273394B (en) * | 2016-03-31 | 2021-10-12 | Sap欧洲公司 | Depth filter propagation with explicit dependency and equivalence declarations in data models |
| CN108268536A (en) * | 2016-12-30 | 2018-07-10 | 北京国双科技有限公司 | Database aggregation processing method and device |
| CN107273506B (en) * | 2017-06-19 | 2020-06-16 | 西安电子科技大学 | Method for multi-table combined query of database |
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
| CN107341238A (en) * | 2017-07-04 | 2017-11-10 | 北京京东尚科信息技术有限公司 | Data processing method and system |
| CN107341238B (en) * | 2017-07-04 | 2020-12-22 | 北京京东尚科信息技术有限公司 | Data processing method and system |
| CN107526781A (en) * | 2017-07-25 | 2017-12-29 | 无锡天脉聚源传媒科技有限公司 | A kind of information search method and device |
| CN109382750A (en) * | 2017-08-04 | 2019-02-26 | 杉野机械股份有限公司 | Selection method, selection device and the storage medium of the type of polishing tool |
| CN107832349A (en) * | 2017-10-18 | 2018-03-23 | 金蝶软件（中国）有限公司 | The management method and information management system of a kind of business object |
| CN108038135A (en) * | 2017-11-21 | 2018-05-15 | 平安科技（深圳）有限公司 | Electronic device, the method for multilist correlation inquiry and storage medium |
| CN108710693A (en) * | 2018-05-22 | 2018-10-26 | 浪潮软件集团有限公司 | Data visualization method and device |
| CN109918363A (en) * | 2019-02-25 | 2019-06-21 | 江苏电力信息技术有限公司 | The method for carrying out data model coherency management based on view integration across database type |
| CN109918363B (en) * | 2019-02-25 | 2023-01-24 | 江苏电力信息技术有限公司 | Method for carrying out data model consistency management based on view cross-database type |
| CN112632037A (en) * | 2020-12-24 | 2021-04-09 | 山东浪潮通软信息科技有限公司 | Method and device for graphically defining query data set |
| CN112632037B (en) * | 2020-12-24 | 2023-04-07 | 浪潮通用软件有限公司 | Method and device for graphically defining query data set |
| CN113744359A (en) * | 2021-08-02 | 2021-12-03 | 苏州热工研究院有限公司 | Method and system for constructing nuclear power station system flow chart |
| CN113744359B (en) * | 2021-08-02 | 2023-05-30 | 苏州热工研究院有限公司 | Method and system for constructing system flow chart of nuclear power station |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105243162B (en) | 2018-10-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105243162A (en) | Relational database storage-based objective data model query method and device | |
| CN107545046B (en) | Fusion method and device for multi-source heterogeneous data | |
| CN103390015B (en) | Based on mass data stored in association method and the search method of unified index | |
| CN106933833B (en) | Method for quickly querying position information based on spatial index technology | |
| US9098530B2 (en) | Scalable rendering of large spatial databases | |
| US8495007B2 (en) | Systems and methods for hierarchical aggregation of multi-dimensional data sources | |
| US8880463B2 (en) | Standardized framework for reporting archived legacy system data | |
| US11216516B2 (en) | Method and system for scalable search using microservice and cloud based search with records indexes | |
| CN107368527B (en) | Multi-attribute index method based on data stream | |
| CN103631909A (en) | System and method for combined processing of large-scale structured and unstructured data | |
| EP2836928B1 (en) | Full text search using r-trees | |
| CN108009265B (en) | Spatial data indexing method in cloud computing environment | |
| CN103678550A (en) | Mass data real-time query method based on dynamic index structure | |
| CN104090962A (en) | Nested query method oriented to mass distributed-type database | |
| WO2020215438A1 (en) | Spatial keyword query distributed indexing system and method for electronic map | |
| CN110750599A (en) | Associated information extraction and display method based on entity modeling | |
| CN110837506A (en) | Mycat-based data fragmentation and read-write separation method and system | |
| CN102591935A (en) | Distributive data storage management method and distributive data storage management system | |
| CN103177046B (en) | A kind of data processing method based on row storage data base and equipment | |
| CN116992887A (en) | Metadata data catalog processing method, device and processing equipment | |
| CN112699187B (en) | Associated data processing method, device, equipment, medium and product | |
| CN110019593B (en) | Map data acquisition method, device and system, server and storage medium | |
| CN117216109A (en) | Data query method, device and storage medium for multi-type mixed data | |
| CN109933567B (en) | Mapping file spatialization processing application system and method based on GIS model technology | |
| Liu et al. | Analysis of spatial indexing mechanism and its application in data management: A case study on spatialite database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |