CN1588369A - Relation type data base system and its search and report method - Google Patents
Relation type data base system and its search and report method Download PDFInfo
- Publication number
- CN1588369A CN1588369A CN 200410074521 CN200410074521A CN1588369A CN 1588369 A CN1588369 A CN 1588369A CN 200410074521 CN200410074521 CN 200410074521 CN 200410074521 A CN200410074521 A CN 200410074521A CN 1588369 A CN1588369 A CN 1588369A
- Authority
- CN
- China
- Prior art keywords
- inquiry
- metadata
- server
- report
- condition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The relation-type data base system of the present invention includes data center for storing data object; metadata base for storing metadata; client sides; report server connected to the client sides; and intermediate server connected to the data center, the metadata base and the report server. The inquiry and report process includes the client side to input inquiry and report request, the report server to send metadata inquiry request, for the intermediate server to obtain metadata from the metadata base, for the report server to send metadata to the client side, for the client to input inquiring and report condition based on the metadata, for the report server to create command, for the intermediate server to execute the command in the data center and to return result to the report server, for the report server to store the result and return it to the client side, and for the client to show the result.
Description
Technical field
The present invention relates to data storage and treatment technology, particularly relate to a kind of system R and inquiry thereof and report method.
Background technology
Database technology has been widely used in various management information systems, becomes the basis of DSS and expert system. Particularly system R (RDBMS, Relation DataBase System) comes into one's own day by day.
System R is take the relational model of data as the basis, according to self-defining relation store, processing and management data library information. Usually, comprise mass data information in the relevant database, still, be not to need all data messages in the practical application, but need to meet some data messages of some condition, at this moment, can retrieve qualified data message by inquiry. In addition, can also by form realize data calculating, sort out, gather and sort.
Recently, the units such as large enterprise, stock trader, credit card company, insurance company and telephone operator are by general headquarters and be distributed in the branch company of various places or sales department forms, and the independent database operational mode of professional general employing of each branch company, the whole operation flow of complete independently is also deposited initial data. The variety of problems such as consider that this pattern exists that resource is disperseed, management difficulty is large, information asymmetry and risk control ability are poor, industry is generally built data center in general headquarters, be used for these business datums that are positioned at disparate databases being copied and concentrating and deposit, carry out comprehensive application, do not affect again the function of original operation system simultaneously. Take securities broker company as example, generally build a data center that concentrates each sales department's transaction data in general headquarters, on this basis, data center has comprised the miscellaneous service data such as finance, liquidation of a judicial person, exchange, checking up bank accounts toward contact. Therefore, how to use better these business datums to realize the application such as risk control, decision support, become more and more concerned topic.
At present, in the prior art, mainly contain two classes based on the inquiry of relevant database and the realization of form technology. One class is based on the technology of data warehouse, and representative have BO, Micro Strategy, a Microsoft Report Server etc.; Another kind of inquiry and the reporting system that is based on business.
Seeing also Fig. 1, is a kind of topology diagram of system of the Micro of employing Strategy technology. Wherein, data warehouse 810 is used for leaving in from the useful data of other system in the storage area of integrating, and its essence is exactly to integrate and the king-sized relevant database of capacity through processing; For the ease of the application of data analysis, data mining etc., data warehouse 810 is deposited is through arrangement and the business datum of cleaning.
Described metadatabase 820 is used for the storage data model. Described data model Data Warehouse--based is set up, and realizes inquiry and form by data model in this system.
Seeing also Fig. 2, is the level of the data model of Micro Strategy. Owing to can have between some level of this data model mutual nestedly, for sake of clarity, only provide the most basic level and hierarchical relationship. Wherein, the function of each several part is: table (Table): for the direct definition of raw data table, mainly be field and type thereof; True (Fact): computable field can be field or expression formula, mainly is the contents such as quantity, the amount of money; Tolerance (Metric): add the expression formula of the Fact that polymerization is calculated, such as SUM (F1*F2), MIN (F1)/AVG (F1) etc.; Latitude (Attribute): be used for determining the field of extent of polymerization, such as the year, month, day on date, the province in area, city, county etc.; Filter (Filter): be used for filtering data, with size relatively, the mode such as comprise is carried out the filtration of data, such as [year]=2004; Prompting (Prompt): can by the Filter of user's initial conditions, when carrying out form, input certain condition by the user; Form (Report): the definition of form comprises that form comprises basic element, display layout, form etc.
Based on the inquiry of this system and the implementation procedure of form be: private client 860 prior generating report forms metadata are stored in metadatabase 820; The user initiates to check the action of form by client 850; WEB server 840 receives request, obtains the form conditional definition by report server 830 from metadatabase 820, and the formation condition page, returns to client; User's initial conditions sends to WEB server 840; WEB server 840 condition of acceptances, and initiate to carry out the order of forms to report server 830; Report server 830 generates SQL statement according to condition and the metadata of user's input, and carries out to data warehouse 810; Report server 830 returns to WEB server 840 with the data format (XML) of execution result together with meta data definition generation standard; WEB server 840 generates results page according to execution result and meta data definition, returns to client 850.
Although this system can realize inquiry and form, and be not suitable for the construction of data center. This be because: at first, this system too depends on the data model of data warehouse, requires data are had to put in order preferably and clean, and data center then needs to guarantee the integrality of data as far as possible, and therefore arrangement and degree of cleaning are very little; Secondly, the complicated structure of the data model of this system generates the model object that an interactive form needs 7 levels at least; Again, this system is poor for the support of the inquiry of complexity and form, owing to be overly dependent upon data model, can't simply use inquiry and the form of the complexity of model description for some, support often needs to copy mechanically and apply indiscriminately with regard to non-constant, uncertain can getting a desired effect; Again, the common external software systems of this type of technology show that to the form of Chinese style form lacks support; In addition, report server adopts the mode in direct connection data storehouse, sandwich construction is supported relatively poor, is difficult to fulfillment database and report server separating on network, and security is relatively poor.
See also Fig. 3, be based on professional inquiry and the network topology structure figure of reporting system. This system is common in the miscellaneous service systems such as transaction system, financial system, liquidation of a judicial person system.
The inquiry of this system and the implementation procedure of form are as follows: at first, the user initiates to check the action of form; Secondly, client 910 is by the definition of code realization form, and the formation condition interface receives user's input; Subsequently, client 910 generates SQL statement according to the condition of user's input by code, and sends to execution on the middleware server 930 by using routing server 920; Middleware server 930 is carried out SQL statement at database 940, and execution result is returned to client 910; Client 910 generates as a result the interface to show the result by code with execution result.
There are some defectives in this system when being applied to data center: at first, the topmost characteristics of this system are to adopt for the demand of some business the form of hard coded, realize the demand of various inquiries and form by program code, realize (can in program code, write condition, result of form etc.) such as the definition of form with program code, so the development amount is large; And autgmentability is poor, and the definition of revising form such as needs just must realize by update routine code, recompility, is only suitable for the realization of specific transactions. And for this integrated miscellaneous service data of data center, and can increase at any time the system of new business datum, the extensibility of application is very important. Secondly, its development amount is equivalent to the summation of developing separately for every cover operation system, and the scale of workload and whole system is directly proportional, and every adding one cover business datum all can cause the change of each node.
Summary of the invention
The technical problem that the present invention solves provides a kind of system R and based on inquiry and the report method of system R; Its realization and independent of service and extensibility are better.
For this reason, the technical scheme of technical solution problem of the present invention is: a kind of system R is provided, comprises:
Data center is used for storing original data object;
Metadatabase is used for storing metadata, and described metadata comprises the definition of description, inquiry and the form of data object;
Client;
Report server connects described client;
Middleware server connects described data center, metadatabase and report server;
Wherein, described client realizes the input of inquiry and report request, described report server initiates to search the request of metadata according to described inquiry and report request, and described middleware server obtains metadata according to described request of searching metadata from metadatabase; Described report server is that reference format sends to client with the metadata conversion of obtaining; Described client realizes the input of the condition of inquiry and form according to the definition of the inquiry in the aforementioned metadata and form, described report server generates fill order according to the description of the data object in the described metadata, the inquiry of input and the condition of form, and described middleware server is carried out described fill order and the result is returned report server in data center; The result of the described inquiry of described report server buffer memory and form, and return client; Described client shows the result of inquiry and form.
Preferably, described report server comprises that performance element, metadata are written into the unit; Described performance element is used for generating fill order and being forwarded to middleware server, and with the result cache that obtains; Described metadata is written into the unit and is used for to the middleware server request metadata, is reference format with the metadata conversion that obtains.
Preferably, described report server also comprises the after-treatment unit, is used for the inquiry of buffer memory and the result of form are analyzed.
Preferably, described report server also comprises the interface processing unit, is used for formation condition interface and display interface as a result.
Preferably, described client comprises lead-out unit and form filter element; The results conversion that described lead-out unit is used for the inquiry of buffer memory and form is object format and storage; Described form filter element be used for show inquiry and form as a result the time realization format conversion.
Preferably, described client also comprises the interface input control, is used for realizing the input of aforementioned request and condition.
Preferably, also comprise the application routing server, connect described report server and middleware server, be used for transmitting the data between report server and the middleware server.
Preferably, the original data object of described data center storage comprises tables of data, view, storing process and storage function.
The present invention also provides a kind of inquiry based on system R and report method, comprises step:
1) data object of selection data center generates corresponding metadata and storage, and described metadata comprises the definition of description, inquiry and the form of described data object;
2) client is carried out inquiry and form to the report server request; Described report server according to described request to the middleware server request metadata; Described middleware server obtains metadata and returns report server; Described report server is that reference format sends to client with the metadata conversion of obtaining;
3) described client realizes the input of the condition of inquiry and form according to described metadata, and the condition that will input sends to report server; Described report server sends to middleware server according to the condition generation fill order of described metadata, inquiry and form; Described middleware server is carried out described fill order and the result is returned report server in data center;
4) result of the described inquiry of described report server buffer memory and form, and return client; Described client shows the result of inquiry and form.
Preferably, described step 1) in, the process of described generator data specifically: select data object; The generated data object factory; The definition of generated query and form itself; The formation condition field description; The conditional definition of generated query and form; The generation result field is described; The result of generated query and form shows definition; The process of described storing metadata is specifically deposited in metadata in database or the configuration file.
Preferably, described step 2) in, realize the input of inquiry and form condition specifically: resolve the metadata of returning, show according to the result of conditional definition, inquiry and the form of definition, inquiry and the form of inquiry and form itself to define the formation condition input interface; Described step 3) in, generates exectorial process specifically: splice result field according to the condition that result field is described and inputted; Condition specified data object according to data object description and input; Splice condition field according to the condition that condition field is described and inputted; Result field, data object and condition field are combined as complete fill order.
Preferably, described step 2) in, realize the input of inquiry and form condition specifically: resolve the metadata of returning, show according to the result of conditional definition, inquiry and the form of definition, inquiry and the form of inquiry and form itself to define the formation condition input interface; Described step 3) in, generates exectorial process specifically: splice condition field according to the condition that condition field is described and inputted; Condition specified data object according to data object description and input; Data object and condition field are combined as complete fill order.
Preferably, described step 4) in, show inquiry and form as a result the time carry out form and filter the format conversion of realization data.
Preferably, comprise that also with the inquiry of described buffer memory and the results conversion of form be that object format is derived.
Preferably, also comprise after-treatment is carried out in the inquiry of described buffer memory and the result of form.
Preferably, also comprise and use the step that routing server is transmitted the data between described report server and the middleware server.
With respect to prior art, the invention has the beneficial effects as follows: at first, because the present invention is the data object configure metadata of data center, data object and metadata all are again at database layer simultaneously, therefore when revising business datum or increasing new business datum, just only can cause the change of data center and metadata, can morely not affect the change of other nodes, thereby take full advantage of existing resource and can reduce the development amount, improved the autgmentability of Database Systems. Secondly, because during configure metadata of the present invention, with business datum as data object, the metadata part only comprises the element on basis, reduced inquiry and form to the dependence of data model, thus both kept using flexibly, reduced again the degree of dependence of metadata to the data Relations Among, be suitable for the business datum without arrangement and cleaning, and can realize professional independence. Again, the present invention adopts middleware server connection data storehouse and report server, thereby separating of supporting database server and Office Network guarantees the safety of database server; And by the cooperation of middleware server and report server, the type independence of all right fulfillment database system provides unified database access interface.
In addition, in the preferred embodiments of the present invention, the middleware server of Database Systems, report server and customer end adopted are connected the unit and are realized that mutual interface connects, and the more abundant extensibility that ensures system makes system can support better following new demand; System extension is very quick and simple, and development is lacked than direct hard coded, and the new function that can increase sharply the most important thing is to support fast the application of new business datum, reduces the input of the new system of exploitation.
In addition, inquiry and form are carried out and are adopted dynamic query of SQL statement and dynamic datastore calling technology; Simple professional direct structure by table or view realizes, complicated business realizes by storing process or storage function, simultaneously by the support to storing process and storage function, solved the problem of the form of the inquiry of calculation of complex and form and Chinese style, the form of form is more flexible, and the business datum of isomery can be merged the result of generated query and form, effectively makes up all kinds of business datums, compare with the modeling of copying mechanically and applying indiscriminately, obvious advantage is also arranged on the efficient of execution.
In addition, carry out the forwarding of order by using routing server, can be used for crossing over two or more network segments, reach the purpose to sandwich construction, further solved the problem of database security.
In addition, can realize that displaying and the data of inquiring about with form derive; Simultaneously also provide support for the after-treatment of data, the user can be according to the needs of oneself, and deal with data again is for excavation and the analysis of data provides preliminary support.
Description of drawings
Fig. 1 is a kind of topology diagram that adopts the system of data warehouse technology;
Fig. 2 is the level of the data model of system shown in Figure 1;
Fig. 3 is based on professional inquiry and the network topology structure figure of reporting system;
Fig. 4 is the block diagram of system R of the present invention;
Fig. 5 is the schematic diagram of the interface of Database Systems shown in Figure 4;
Fig. 6 is the flow chart of inquiry of the present invention and report method;
Fig. 7 is structure and the connection diagram of metadata in the embodiments of the invention;
Fig. 8 is the flow chart of the embodiment of inquiry of the present invention and report method;
Fig. 9 is the schematic diagram that the present invention is applied to the example of securities broker company.
The specific embodiment
The present invention fully takes into account the characteristics of data center, thereby has realized preferably the construction of data center and the realization of inquiry and form. From the angle of data, data center mainly contains two aspect characteristics: the one, and data centralization, data are from different operation systems; The 2nd, data keep reset condition, without cleaning. Therefore, the present invention adopts data center's storage to concentrate initial data, adopt the metadatabase storage for the description of initial data, thereby the realization of business is separated with form with inquiry, revising or increasing the variation that new business datum just only can cause data center and metadatabase, can too much not affect other nodes; In addition, adopt middleware server to realize the effective separation of data center and report server; The present invention also simplifies the description of data, only comprises basic element, thus both kept using flexibly, reduce again the description of data to the dependence of initial data.
Seeing also Fig. 4, is the block diagram of system R of the present invention.
This system R comprises data center 110, metadatabase 120, middleware server 130, report server 140 and client 150; Wherein, report server 140 connects client 150; Middleware server 130 connects described data center 110, metadatabase 120 and report servers 140, realizes report server 140 and data center 110, metadatabase 120 separating on network.
In order further to strengthen Security of the system, application routing server 160 can also be set between report server 140 and middleware server 130; This is used routing server 160 and is responsible for transmitting mutual data between report server 140 and the middleware server 130, but does not carry out the processing of data, is mainly used in crossing over a plurality of network segments, supports sandwich construction.
Deposit the data from other system of collection in the data center 110, comprise tables of data, view, storing process and storage function; Wherein, storing process and storage function can adopt the precompile set of SQL statement, and these statements are stored under a title and processed as a unit; Being similar to process and the function of common programming language, is to be used for the module of deal with data in the Database Systems.
Storing metadata in the metadatabase 120 comprises the definition of description, inquiry and the form of data object; Be used for realizing the parametrization configuration of inquiry and form. Wherein, the description of data object refers to that the data description with data center's storage is data object, comprise that data object is described, condition field is described and result field is described, its objective is that the different database objects such as above-mentioned tables of data, view, storing process and storage function are described with same form, convenient definition to inquiry and form; Inquiry and the definition of form comprise to be inquired about and the result of conditional definition, inquiry and the form of definition, inquiry and the form of form itself shows definition.
Described client 150 is used for receiving user's input, the displaying that realizes inquiry and form result and data to be derived.
Report server 140 is used for the input request metadata according to the user, buffer memory and the after-treatment that generates fill order and realize inquiry and form result.
Middleware server 130 is used for the execution of obtaining metadata, realizing inquiry and form according to fill order; The type of service independence of fulfillment database system.
In order to realize better the extensibility of system, make system can better support following new demand, adopt interface to connect between the each several part of the present invention, and open interface, support secondary development.
See also Fig. 5, in these Database Systems, report server 140 comprises that core processing unit 141, performance element 142 and metadata are written into unit 143; Described core processing unit 141 connects other unit, the mobile and processing of supported data; Described performance element 142 is used for generating fill order and being forwarded to middleware server 130, and with the result cache that obtains; Described metadata is written into unit 143 and is used for to middleware server 130 request metadata, is reference format with the metadata conversion that obtains.
For the inquiry of buffer memory and the result of form are analyzed, described report server can also comprise after-treatment unit 144, for operations such as the data to buffer memory sort, filter, gather, generate new data buffer storage, the user can be according to the needs of oneself, again deal with data is for excavation and the analysis of data provides preliminary support.
Client 150 comprises client control module 151, lead-out unit 152 and form filter element 153; Described client control module 151 connects other unit, the mobile and processing of supported data; The results conversion that described lead-out unit 152 is used for the inquiry of buffer memory and form is object format and storage; Described form filter element 153 be used for show inquiry and form as a result the time realization format conversion.
In order to expand user's input, described client 150 can also comprise interface input control 154.
The secondary development of described system R comprises: be written into unit 143 by metadata and support more multi-form metadata; Support more multi-form data object form by performance element 142, even support more multi-form data source; Again processing by after-treatment unit 144 is supported data improves the flexibility of showing and analyzing; Displaying form by 153 pairs of data of form filter unit provides abundanter support; Increase as required the support of other being derived form by lead-out unit 152.
In addition, secondary development also comprises the self-defined of inquiry and form itself: provide new inquiry and REPORT-OBJECT by increasing tables of data, view, storing process and query function; Increase the function of inquiry and form by revising metadata. Wherein, the modification of metadata and increase can be by realizing that the unit that metadata is written into interface realizes.
See also Fig. 4 and Fig. 6, the below introduces the flow process of inquiry of the present invention and report method.
At first, select the data object of data center 110, generate corresponding metadata and be stored in metadatabase 120, described metadata comprises the definition of description, inquiry and the form of described data object;
Secondly, user's input request, client 150 is carried out inquiry and form to report server 140 requests; Described report server 140 according to described request to middleware server 130 request metadata; Described middleware server 130 obtains metadata and returns report server 140 from metadatabase 120; Described report server 140 is that reference format sends to client 150 with the metadata conversion of obtaining;
Again, described client 150 is according to the definition formation condition interface of the inquiry in the described metadata and form, and for the condition of user input query and form, and the condition that will input sends to report server 140; Described report server 140 sends to middleware server 130 according to the description of the data object in the described metadata, the inquiry of input and the condition generation fill order of form; Described middleware server 130 is carried out described fill order and the result is returned report server 140 in data center 110;
Subsequently, the result of the described inquiry of described report server 140 buffer memorys and form, and return client 150; Described client 150 shows the result of inquiry and form.
For the ease of the understanding of the present invention, describe the present invention below in conjunction with embodiment.
Seeing also Fig. 7, is structure and the connection diagram of metadata in the embodiments of the invention.
Metadata comprises description, condition field and the result field of data object, is used for the different database objects such as tables of data, view, storing process and storage function of data center are described with same form convenient definition to inquiry and form.
Metadatabase comprises that also the result of conditional definition, inquiry and the form of inquiry and definition, inquiry and the form of form itself shows definition, inquires about and form for defining.
Wherein, the content of the description of data object comprises:
| Attribute | Explanation |
| Object number | The unique number of object |
| Object oriented | The sign of object in database |
| Object properties | Attribute is " table ", " view ", " storing process ", " storage function " etc. |
The content that condition field is described comprises:
| Attribute | Explanation |
| Object number | The numbering of affiliated partner |
| The condition field numbering | The unique number of condition field |
| Field name | The sign of condition field |
| Manner of comparison | Equal (=), be not equal to (unequal to), greater than (＞), less than (＜), |
| More than or equal to (＞=), less than or equal to (＜=), comprise (in), do not comprise (not in), character string comprises (charindex), character string does not comprise (not charindex), and coupling (like) is not mated (notlike) these 12 kinds of basic forms. | |
| Default value | Be used for insignificant condition |
The content that result field is described comprises:
| Attribute | Explanation |
| Object number | The numbering of affiliated partner |
| The result field numbering | The unique number of result field |
| Field name | The sign of result field |
| Calculation expression | The result field that support is calculated by expression formula, acquiescence is field name |
| Whether can sort | The field whether conduct can be sorted |
The definition of inquiry and form itself comprises:
| Attribute | Explanation |
| Inquiry and report number | The unique number of inquiry and form |
| Object number | The numbering of affiliated partner |
| Inquiry and report name | The Chinese title of inquiry and form |
| Display form | Form is or/and figure |
| The type of figure | Block diagram, pie chart, broken line graph etc. |
The conditional definition of inquiry and form comprises:
| Attribute | Explanation |
| Inquiry and report number | The numbering of correlation inquiry and report number |
| The condition numbering | The unique number of condition |
| The condition Chinese | The Chinese mark of condition |
| Ordinate | Determine condition position and size |
| Abscissa | |
| Vertically big or small | |
| Widthwise size | |
| The condition field numbering | Determining corresponding condition field, is 0 to represent not Correlation Criteria field, as the interface prompt text |
| The input control title | The sign of input control |
| The input control parameter | Various switches and the property parameters of input control |
The result of inquiry and form shows that definition comprises:
| Attribute | Explanation |
| Inquiry and report number | The numbering of correlation inquiry and report number |
| The result field numbering | Determine corresponding result field |
| Whether show | The switch of interface display |
| DISPLAY ORDER | The serial number that field shows |
| Position in the form | For showing in the master meter, show two kinds in the add list |
| Position among the figure | The reference axis of figure |
| Whether duplicate contents merges demonstration | Merge the cell content that repeats continuously in the form |
| Alignment direction | The alignment direction of horizontal and vertical |
| The link parameter | Be used for other inquiries of link and form, the result of this inquiry and form inquired about as the next one and the initial conditions of form |
| The form filter | Be used for as a result some form filters of Formatting Output |
| Derive form | Assignable derived type and length are defaulted as raw data format |
The present invention is realized by modeling tool that when configure metadata modeling tool is configured by graphical interfaces, finishes the rear modeling tool that just no longer needs when operation of configuration. Because the data of data center are from other system and without the business datum of putting in order and cleaning, configuration minute two levels carry out: the description of data and modeling; The definition of inquiry and form.
At first, select tables of data, view, storing process or the storage function of data center as data object. Specifically comprise: object number, take from database; Object oriented, the manual appointment; Object properties, automatic decision;
Secondly, given query and report number, title are selected the display form of inquiry and form, if be figure, the type of just specifying figure;
Again, list all fields of tables of data, view, the parameter of storing process or storage function is as alternative condition field; Condition field numbering, field name are directly obtained by data center. After which specifies by hand as condition field, specify again or input manner of comparison (only for showing and view) default value.
Again, formation condition is numbered automatically, condition Chinese, input control title, the input control parameter of manual appointment or initial conditions field;
Again, according to Chinese, the condition type of condition field, formation condition layout configurations interface, the drag and drop condition is carried out interface configurations, is automatically converted to position and the size of condition after finishing;
Subsequently, list all fields of tables of data, view, the execution result field of storing process or storage function (during execution, parameter is got the default value of middle configuration), as alternative result field, result field numbering, field name are directly obtained. Manual which specifies as a result of after the field, specify again or the input calculation expression, whether can sort.
Subsequently, specify or whether position, the position among the figure, DISPLAY ORDER, duplicate contents in whether the showing of input results, form merge demonstration, alignment direction, link parameter, form filter, derive form;
Selection will be changed directly to be saved in metadatabase and/or to generate SQL and be carried out script, finish configuration.
Seen from the above description, the meta data definition part only comprises most basic element, can reduce form to the dependence of data model as far as possible, simultaneously by the support to storing process and storage function, solved the problem of the form of the inquiry of calculation of complex and form and Chinese style, the form of form is more flexible.
Be appreciated that metadata is realized by the unit that the realization metadata is written into interface, therefore can reach the independence of metadata Store form by the realization of docking port, as leave in the Database Systems, perhaps leave in the configuration file.
See also Fig. 8, finish the configuration of metadata after, just can carry out inquiry and form, specifically comprise:.
At first, client is carried out inquiry and form to the report server request.
Metadata in the report server is written into the unit to the middleware server request metadata.
Secondly, middleware server obtains metadata and returns to metadata and is written into the unit; It is the core processing unit that reference format returns to report server with metadata conversion that metadata is written into the unit; Report server returns to client with metadata, by client formation condition interface; User's initial conditions, client is submitted report server with condition.
Subsequently, the performance element of report server generates fill order and submits middleware server according to metadata and condition. When generating fill order, for dissimilar data objects by different handling processes.
1) execution of tables of data, view
According to the definition of metadata, generate dynamic select statement, the structure of the select statement of generation is as follows:
1:select[expression formula 1] as[field 1], [expression formula 2] as[field 2] ... [expression formula n] as[field n]
The object oriented of 2:from[table or view]
3:where[condition 1] and[condition 2] ... and[condition n]
4:order by[result field 1] [dese], [result field 2] [desc] ... [result field n] [desc]
The step of carrying out is as follows: according to result field title and calculation expression, result field is spliced into 1 part; According to object oriented, generate 2 part; According to the condition field title, condition manner of comparison, and the condition value of user's input generate the such condition of [field] [comparison operator] [value], and a plurality of conditions are coupled together with " and ", generate 3 part; According to the result field definition, whether result field can sort, and the sort criteria of user's input, and result field is spliced into 4 part, if ordering adds in the field name back " desc " for backward; 1-4 is combined into complete statement.
The below is one and generates exectorial example. Be assumed to view vclientinfo and set up following metadata:
The description of data object
| Object number | Object oriented | Object properties |
| 640014 | hsrun..vclientinfo | View |
The description of condition field
| The condition field numbering | Field name | Manner of comparison | Default value | User input values |
| 1 | branch_no | Equal | Without default value | 1001 |
| 2 | fund_account | Equal | Without default value |
The description of result field
| The result field numbering | Field name | Calculation expression | Whether can sort | The user selection ordering |
| 1 | branch_no | No | ||
| 2 | branch_name | branch_no | No | |
| 3 | fund_account | Be | Backward | |
| 4 | client_name | No | ||
The statement that then generates is as follows:
1：select branch_no as branch_no，branch_no as branch_name，fund_account
as fund_account，client_name as client_name
2：from hsrun..vclientinfo
3：where branch_no＝1001
4：order bv fund_account desc
2) execution of storing process and storage function
Relatively simple for calling of storing process, according to the definition of condition field and the condition assignment procedure parameter of user selection, for the parameter of ignoring, transmit default value.
Then, the middleware server fill order returns the result to performance element; Performance element deposits data in the data buffer storage of report server. The realization of buffer memory is specifically: middleware server return results information; Report server is analyzed return results, sends result's numbering to middleware server, and the record of number is specified in request; In data buffer storage, add record. Processing when certainly, wherein also comprising execute exception.
Report server returns to client with as a result paging. As long as the data volume in the data buffer storage reaches the requirement of data page, just return to immediately client, with the request of the shortest time response of client;
Client shows the result of inquiry and form. Inquiry and the displaying of form mainly are explanation and the execution to the inquiry of metadata and report definition part, and the displaying form is divided into two kinds in form and figure:
The displaying groundwork of form is: generate form, carry out the form filter unit, the redirect link between generated query and the form etc. The form filter unit is the unit of realizing the data content conversion, is used for carrying out the Formatting Output of date, numeral, the functions such as the conversion of data dictionary.
The displaying of figure mainly is according to the definition of the coordinate of figure and the data in depositing, and directly generates and schemes, and supports common pie chart, block diagram, broken line graph, point diagram etc.
In addition, all right derived data, the data that are about in the buffer memory are converted to destination file format, such as text, the DBF file, Excel files etc. are realized the reservation of inquiry and report messages, data derive and realize by lead-out unit. Specifically:
The user initiates the request of deriving, and client is dealt into report server with request;
Report server calls the request that lead-out unit is carried out client, generates export, and returns to client.
Simultaneously, data buffer storage also provides support for the after-treatment of data, by to operations such as the data in the data buffer memory sort, filter, gather, generate new data buffer storage, the user can be according to the needs of oneself, again deal with data is for excavation and the analysis of data provides preliminary support.
The after-treatment function is realized by the after-treatment unit, can increase new processing mode by the form of plug-in unit, and operational process is as follows:
The user initiates the after-treatment request;
Report server accepts request, and carries out corresponding after-treatment unit according to the after-treatment request content, simultaneously with data buffer storage and the after-treatment request content execution parameter as the after-treatment unit;
Report server accepts to process later data buffer storage, result is returned client show.
Seeing also Fig. 9, is the example that the present invention is applied to securities broker company. The inquiry of internal control platform of securities broker company and being implemented as follows of report frame:
The central database 210 of internal control platform adopts MS SQL Server 2000 or Oracle 9i Database Systems, the metadata of the business datum of data center 211 and metadatabase 212 is stored in the same database instance, but separate in logic, be written into the storage mode that the other types such as text, XML can be supported in the unit by writing different metadata.
The business datum of at present internal control platform support has brokerage data, financial data, liquidation of a judicial person data, exchange's data, several classes of checking up bank accounts data, the operation system of different editions is also divided the data of different structure among every class, by inquiry and report frame the data of these isomeries is represented to the user with unified result formats.
Use routing server 230 and also adopt Hang Seng's component server, the forwarding of being responsible for the function request and replying. Simultaneously, also be fit to other commercial middleware products.
What the client part of internal control platform adopted is the B/S structure, comprises WEB server 240 and browser 250.
Customer end adopted browser 250 uses Java Script to realize the interactive function of boundary layer remainder, mainly is that the function of some interface controls realizes.
Need to prove, can be directly with report server 260 communications when adopting private client 270, then Business Logic is realized by report server 260, boundary layer is realized by private client 270 fully.
The above only is preferred embodiment of the present invention; should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (16)
1. a system R is characterized in that, comprising:
Data center is used for storing original data object;
Metadatabase is used for storing metadata, and described metadata comprises the definition of description, inquiry and the form of data object;
Client;
Report server connects described client;
Middleware server connects described data center, metadatabase and report server;
Wherein, described client realizes the input of inquiry and report request, described report server initiates to search the request of metadata according to described inquiry and report request, and described middleware server obtains metadata according to described request of searching metadata from metadatabase; Described report server is that reference format sends to client with the metadata conversion of obtaining; Described client realizes the input of the condition of inquiry and form according to the definition of the inquiry in the aforementioned metadata and form, described report server generates fill order according to the description of the data object in the described metadata, the inquiry of input and the condition of form, and described middleware server is carried out described fill order and the result is returned report server in data center; The result of the described inquiry of described report server buffer memory and form, and return client; Described client shows the result of inquiry and form.
2. system R according to claim 1, it is characterized in that: described report server comprises that performance element, metadata are written into the unit; Described performance element is used for generating fill order and being forwarded to middleware server, and with the result cache that obtains; Described metadata is written into the unit and is used for to the middleware server request metadata, is reference format with the metadata conversion that obtains.
3. system R according to claim 2, it is characterized in that: described report server also comprises the after-treatment unit, is used for the inquiry of buffer memory and the result of form are analyzed.
4. system R according to claim 2, it is characterized in that: described report server also comprises the interface processing unit, is used for formation condition interface and display interface as a result.
5. system R according to claim 1, it is characterized in that: described client comprises lead-out unit and form filter element; The results conversion that described lead-out unit is used for the inquiry of buffer memory and form is object format and storage; Described form filter element be used for show inquiry and form as a result the time realization format conversion.
6. system R according to claim 1, it is characterized in that: described client also comprises the interface input control, is used for realizing the input of aforementioned request and condition.
7. according to claim 1 to 6 each described system Rs, it is characterized in that: also comprise the application routing server, connect described report server and middleware server, be used for transmitting the data between report server and the middleware server.
8. system R according to claim 1 is characterized in that: the original data object of described data center storage comprises tables of data, view, storing process and storage function.
9. inquiry and report method based on a system R is characterized in that, comprise step:
1) data object of selection data center generates corresponding metadata and storage, and described countless certificates comprise the definition of description, inquiry and the form of described data object;
2) client is carried out inquiry and form to the report server request; Described report server according to described request to the middleware server request metadata; Described middleware server obtains metadata and returns report server; Described report server is that reference format sends to client with the metadata conversion of obtaining;
3) described client realizes the input of the condition of inquiry and form according to described metadata, and the condition that will input sends to report server; Described report server sends to middleware server according to the condition generation fill order of described metadata, inquiry and form; Described middleware server is carried out described fill order and the result is returned report server in data center;
4) result of the described inquiry of described report server buffer memory and form, and return client; Described client shows the result of inquiry and form.
10. inquiry according to claim 9 and report method is characterized in that, described step 1) in, the process of described generator data specifically: select data object; The generated data object factory; The definition of generated query and form itself; The formation condition field description; The conditional definition of generated query and form; The generation result field is described; The result of generated query and form shows definition; The process of described storing metadata is specifically deposited in metadata in database or the configuration file.
11. inquiry according to claim 10 and report method, it is characterized in that, described step 2) in, realize the input of inquiry and form condition specifically: resolve the metadata of returning, show according to the result of conditional definition, inquiry and the form of definition, inquiry and the form of inquiry and form itself to define the formation condition input interface; Described step 3) in, generates exectorial process specifically: splice result field according to the condition that result field is described and inputted; Condition specified data object according to data object description and input; Splice condition field according to the condition that condition field is described and inputted; Result field, data object and condition field are combined as complete fill order.
12. inquiry according to claim 10 and report method, it is characterized in that, described step 2) in, realize the input of inquiry and form condition specifically: resolve the metadata of returning, show according to the result of conditional definition, inquiry and the form of definition, inquiry and the form of inquiry and form itself to define the formation condition input interface; Described step 3) in, generates exectorial process specifically: splice condition field according to the condition that condition field is described and inputted; Condition specified data object according to data object description and input; Data object and condition field are combined as complete fill order.
13. inquiry according to claim 9 and report method is characterized in that: described step 4), show inquiry and form as a result the time carry out form and filter the format conversion of realization data.
14. inquiry according to claim 9 and report method is characterized in that: comprise that also with the inquiry of described buffer memory and the results conversion of form be that object format is derived.
15. inquiry according to claim 9 and report method is characterized in that: also comprise after-treatment is carried out in the inquiry of described buffer memory and the result of form.
16. inquiry according to claim 9 and report method is characterized in that: also comprise and use the step that routing server is transmitted the data between described report server and the middleware server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200410074521 CN1588369A (en) | 2004-09-06 | 2004-09-06 | Relation type data base system and its search and report method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200410074521 CN1588369A (en) | 2004-09-06 | 2004-09-06 | Relation type data base system and its search and report method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1588369A true CN1588369A (en) | 2005-03-02 |
Family
ID=34604840
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200410074521 Pending CN1588369A (en) | 2004-09-06 | 2004-09-06 | Relation type data base system and its search and report method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1588369A (en) |
Cited By (49)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010017737A1 (en) * | 2008-08-14 | 2010-02-18 | 中兴通讯股份有限公司 | Report form normalization processing method, apparatus and system |
| WO2010048789A1 (en) * | 2008-11-03 | 2010-05-06 | 中国移动通信集团公司 | Index building, querying method, device, and system for distributed column memory database |
| CN101145164B (en) * | 2007-10-30 | 2010-06-02 | 金蝶软件（中国）有限公司 | Chronological book inquiry method and device |
| CN101067822B (en) * | 2006-05-03 | 2010-06-02 | 国际商业机器公司 | Method and system for hierarchical storage management of metadata |
| CN101541021B (en) * | 2008-03-18 | 2010-07-21 | 中国移动通信集团天津有限公司 | Method for automatically generating capacity-warning reports |
| CN101789027A (en) * | 2010-03-15 | 2010-07-28 | 江苏大学 | Metadata management method based on DBMS and metadata server |
| CN101377774B (en) * | 2007-08-31 | 2010-12-08 | 上海证券交易所 | System and method for pre-analyzing according to relationship between metadata and data object |
| CN102024062A (en) * | 2011-01-06 | 2011-04-20 | 中国工商银行股份有限公司 | Device and method for realizing data dynamic cache |
| CN101072116B (en) * | 2007-04-28 | 2011-07-20 | 华为技术有限公司 | Service selecting method, device, system and client end application server |
| WO2011150645A1 (en) * | 2010-12-20 | 2011-12-08 | 华为技术有限公司 | Method for scheduling web hosting service, method for processing application access, apparatus and system thereof |
| CN102360374A (en) * | 2011-09-30 | 2012-02-22 | 南威软件股份有限公司 | User view configuration method |
| CN102541529A (en) * | 2010-12-30 | 2012-07-04 | 北京亿阳信通软件研究院有限公司 | Query page generating device and method |
| CN102663024A (en) * | 2012-03-22 | 2012-09-12 | 北京英孚斯迈特信息技术有限公司 | Data portal system for enterprise data unified platform |
| US8290896B2 (en) | 2007-11-09 | 2012-10-16 | Alibaba Group Holding Limited | Statistical applications in OLTP environment |
| CN101802813B (en) * | 2007-07-17 | 2013-01-02 | 甲骨文国际公司 | System and method for synchronizing service metadata |
| CN101645086B (en) * | 2009-08-28 | 2013-01-09 | 用友软件股份有限公司 | Retrieval method |
| CN101493827B (en) * | 2008-01-21 | 2013-08-21 | 鸿富锦精密工业（深圳）有限公司 | Storage process adaptive system and method |
| CN101305555B (en) * | 2005-10-12 | 2013-10-16 | 三星电子株式会社 | Multimedia middleware apparatus using metadata, method for controlling multimedia middleware |
| CN103473078A (en) * | 2013-09-30 | 2013-12-25 | 南京朗睿软件科技有限公司 | Method for generating report |
| CN103678591A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Device and method for automatically executing multi-service receipt statistical treatment |
| CN103744896A (en) * | 2013-12-24 | 2014-04-23 | 乐视网信息技术（北京）股份有限公司 | Method and device for data processing |
| CN104572049A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | Method based on WEB report definition template calculation |
| CN105183489A (en) * | 2015-10-10 | 2015-12-23 | 南京国电南自轨道交通工程有限公司 | Extjs frame based intelligent data analysis system and method |
| CN105404442A (en) * | 2015-09-24 | 2016-03-16 | 国网山东省电力公司 | Selection screen configuration method and system based on SAP (System Applications and Products in Data Processing) platform |
| CN105740286A (en) * | 2014-12-11 | 2016-07-06 | 华为技术有限公司 | Stored procedure processing method and device |
| CN105930325A (en) * | 2015-11-19 | 2016-09-07 | 中国银联股份有限公司 | Reverse analysis method and device for file report comparative difference |
| WO2016192583A1 (en) * | 2015-06-04 | 2016-12-08 | 阿里巴巴集团控股有限公司 | Data processing method and device for data warehouse |
| CN106547835A (en) * | 2016-08-04 | 2017-03-29 | 贵阳朗玛信息技术股份有限公司 | Call the method and device of database store process |
| CN107562708A (en) * | 2017-08-31 | 2018-01-09 | 顾杏春 | Form linkage methods of exhibiting and system |
| CN108170718A (en) * | 2017-12-05 | 2018-06-15 | 北京先进数通信息技术股份公司 | A kind for the treatment of method and apparatus of achievement data |
| CN103473234B (en) * | 2012-06-07 | 2018-07-06 | 中兴通讯股份有限公司 | A kind of method, apparatus and system from web-query system export report |
| CN108399177A (en) * | 2017-02-07 | 2018-08-14 | 杭州有好数据科技有限公司 | A kind of data processing method and its system based on database |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN109643305A (en) * | 2016-08-25 | 2019-04-16 | 阿里巴巴集团控股有限公司 | Data query method, application and database server, middleware and system |
| WO2019127956A1 (en) * | 2017-12-26 | 2019-07-04 | 平安科技（深圳）有限公司 | Calling method and device for storage process, and storage medium and terminal |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN110347974A (en) * | 2019-05-30 | 2019-10-18 | 重庆金融资产交易所有限责任公司 | Data processing method, device, computer equipment and storage medium |
| CN110489468A (en) * | 2019-07-09 | 2019-11-22 | 威富通科技有限公司 | A kind of deriving method of data sheet, device and server |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN111259038A (en) * | 2020-01-16 | 2020-06-09 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and equipment |
| CN111767117A (en) * | 2020-06-22 | 2020-10-13 | 博易智软(北京)技术有限公司 | Mobile-end BI middleware technology based on application container |
| CN112527868A (en) * | 2020-12-23 | 2021-03-19 | 东莞市盟大塑化科技有限公司 | Data acquisition method, device, equipment and storage medium |
| CN112766910A (en) * | 2021-01-21 | 2021-05-07 | 深圳市极致科技股份有限公司 | Document construction method, document generation device, electronic equipment and storage medium |
| CN113505181A (en) * | 2020-09-29 | 2021-10-15 | 西部证券股份有限公司 | Derivative time sequence data making method based on dolphindb database |
| CN113656479A (en) * | 2021-08-18 | 2021-11-16 | 国网北京市电力公司 | Data processing method and device |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| WO2023083114A1 (en) * | 2021-11-15 | 2023-05-19 | International Business Machines Corporation | Dynamic database object description adjustment |
| CN116389579A (en) * | 2023-03-22 | 2023-07-04 | 安芯网盾(北京)科技有限公司 | Report generation method and system based on micro-service |
| CN117251457A (en) * | 2023-11-20 | 2023-12-19 | 昆山华东信息科技有限公司 | Grid report making method and device |
-
2004
- 2004-09-06 CN CN 200410074521 patent/CN1588369A/en active Pending
Cited By (70)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101305555B (en) * | 2005-10-12 | 2013-10-16 | 三星电子株式会社 | Multimedia middleware apparatus using metadata, method for controlling multimedia middleware |
| CN101067822B (en) * | 2006-05-03 | 2010-06-02 | 国际商业机器公司 | Method and system for hierarchical storage management of metadata |
| CN101072116B (en) * | 2007-04-28 | 2011-07-20 | 华为技术有限公司 | Service selecting method, device, system and client end application server |
| US8219688B2 (en) | 2007-04-28 | 2012-07-10 | Huawei Technologies Co., Ltd. | Method, apparatus and system for service selection, and client application server |
| CN101802813B (en) * | 2007-07-17 | 2013-01-02 | 甲骨文国际公司 | System and method for synchronizing service metadata |
| CN101377774B (en) * | 2007-08-31 | 2010-12-08 | 上海证券交易所 | System and method for pre-analyzing according to relationship between metadata and data object |
| CN101145164B (en) * | 2007-10-30 | 2010-06-02 | 金蝶软件（中国）有限公司 | Chronological book inquiry method and device |
| US8290896B2 (en) | 2007-11-09 | 2012-10-16 | Alibaba Group Holding Limited | Statistical applications in OLTP environment |
| US9146956B2 (en) | 2007-11-09 | 2015-09-29 | Alibaba Group Holding Limited | Statistical applications in OLTP environment |
| CN101493827B (en) * | 2008-01-21 | 2013-08-21 | 鸿富锦精密工业（深圳）有限公司 | Storage process adaptive system and method |
| CN101541021B (en) * | 2008-03-18 | 2010-07-21 | 中国移动通信集团天津有限公司 | Method for automatically generating capacity-warning reports |
| WO2010017737A1 (en) * | 2008-08-14 | 2010-02-18 | 中兴通讯股份有限公司 | Report form normalization processing method, apparatus and system |
| CN101727465B (en) * | 2008-11-03 | 2011-12-21 | 中国移动通信集团公司 | Methods for establishing and inquiring index of distributed column storage database, device and system thereof |
| WO2010048789A1 (en) * | 2008-11-03 | 2010-05-06 | 中国移动通信集团公司 | Index building, querying method, device, and system for distributed column memory database |
| CN101645086B (en) * | 2009-08-28 | 2013-01-09 | 用友软件股份有限公司 | Retrieval method |
| CN101789027A (en) * | 2010-03-15 | 2010-07-28 | 江苏大学 | Metadata management method based on DBMS and metadata server |
| CN102577237A (en) * | 2010-12-20 | 2012-07-11 | 华为技术有限公司 | Method for scheduling web hosting service, method for processing application access, apparatus and system thereof |
| WO2011150645A1 (en) * | 2010-12-20 | 2011-12-08 | 华为技术有限公司 | Method for scheduling web hosting service, method for processing application access, apparatus and system thereof |
| CN102577237B (en) * | 2010-12-20 | 2014-04-02 | 华为技术有限公司 | Method for scheduling web hosting service, method for processing application access, apparatus and system thereof |
| CN102541529B (en) * | 2010-12-30 | 2015-12-16 | 北京亿阳信通科技有限公司 | A kind of query page generating device and method |
| CN102541529A (en) * | 2010-12-30 | 2012-07-04 | 北京亿阳信通软件研究院有限公司 | Query page generating device and method |
| CN102024062A (en) * | 2011-01-06 | 2011-04-20 | 中国工商银行股份有限公司 | Device and method for realizing data dynamic cache |
| CN102024062B (en) * | 2011-01-06 | 2012-12-12 | 中国工商银行股份有限公司 | Device and method for realizing data dynamic cache |
| CN102360374A (en) * | 2011-09-30 | 2012-02-22 | 南威软件股份有限公司 | User view configuration method |
| CN102663024A (en) * | 2012-03-22 | 2012-09-12 | 北京英孚斯迈特信息技术有限公司 | Data portal system for enterprise data unified platform |
| CN103473234B (en) * | 2012-06-07 | 2018-07-06 | 中兴通讯股份有限公司 | A kind of method, apparatus and system from web-query system export report |
| CN103473078A (en) * | 2013-09-30 | 2013-12-25 | 南京朗睿软件科技有限公司 | Method for generating report |
| CN103473078B (en) * | 2013-09-30 | 2017-10-17 | 南京朗睿软件科技有限公司 | A kind of method for generating form |
| CN104572049A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | Method based on WEB report definition template calculation |
| CN103678591A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Device and method for automatically executing multi-service receipt statistical treatment |
| CN103678591B (en) * | 2013-12-12 | 2017-07-11 | 用友网络科技股份有限公司 | The automatic apparatus and method for performing multiple services bills statistical disposition |
| CN103744896A (en) * | 2013-12-24 | 2014-04-23 | 乐视网信息技术（北京）股份有限公司 | Method and device for data processing |
| CN105740286A (en) * | 2014-12-11 | 2016-07-06 | 华为技术有限公司 | Stored procedure processing method and device |
| CN105740286B (en) * | 2014-12-11 | 2019-06-21 | 华为技术有限公司 | A kind of storing process treating method and apparatus |
| WO2016192583A1 (en) * | 2015-06-04 | 2016-12-08 | 阿里巴巴集团控股有限公司 | Data processing method and device for data warehouse |
| CN105404442A (en) * | 2015-09-24 | 2016-03-16 | 国网山东省电力公司 | Selection screen configuration method and system based on SAP (System Applications and Products in Data Processing) platform |
| CN105404442B (en) * | 2015-09-24 | 2018-09-18 | 国网山东省电力公司 | Selection screen configuration method and system based on SAP platforms |
| CN105183489A (en) * | 2015-10-10 | 2015-12-23 | 南京国电南自轨道交通工程有限公司 | Extjs frame based intelligent data analysis system and method |
| CN105930325B (en) * | 2015-11-19 | 2019-05-24 | 中国银联股份有限公司 | A kind of file report compares the conversed analysis method and device of difference |
| CN105930325A (en) * | 2015-11-19 | 2016-09-07 | 中国银联股份有限公司 | Reverse analysis method and device for file report comparative difference |
| CN106547835A (en) * | 2016-08-04 | 2017-03-29 | 贵阳朗玛信息技术股份有限公司 | Call the method and device of database store process |
| CN106547835B (en) * | 2016-08-04 | 2019-12-17 | 贵阳朗玛信息技术股份有限公司 | Method and device for calling database storage process |
| CN109643305A (en) * | 2016-08-25 | 2019-04-16 | 阿里巴巴集团控股有限公司 | Data query method, application and database server, middleware and system |
| CN108399177A (en) * | 2017-02-07 | 2018-08-14 | 杭州有好数据科技有限公司 | A kind of data processing method and its system based on database |
| CN108399177B (en) * | 2017-02-07 | 2020-09-11 | 杭州有好数据科技有限公司 | Data processing method and system based on database |
| CN107562708A (en) * | 2017-08-31 | 2018-01-09 | 顾杏春 | Form linkage methods of exhibiting and system |
| CN108170718A (en) * | 2017-12-05 | 2018-06-15 | 北京先进数通信息技术股份公司 | A kind for the treatment of method and apparatus of achievement data |
| WO2019127956A1 (en) * | 2017-12-26 | 2019-07-04 | 平安科技（深圳）有限公司 | Calling method and device for storage process, and storage medium and terminal |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN110347974B (en) * | 2019-05-30 | 2023-06-23 | 深圳市鼎为通信有限公司 | Data processing method, device, computer equipment and storage medium |
| CN110347974A (en) * | 2019-05-30 | 2019-10-18 | 重庆金融资产交易所有限责任公司 | Data processing method, device, computer equipment and storage medium |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN110298023B (en) * | 2019-07-04 | 2023-08-25 | 中原银行股份有限公司 | Report splicing method and system |
| CN110489468A (en) * | 2019-07-09 | 2019-11-22 | 威富通科技有限公司 | A kind of deriving method of data sheet, device and server |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN111259038A (en) * | 2020-01-16 | 2020-06-09 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and equipment |
| CN111259038B (en) * | 2020-01-16 | 2023-05-30 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and device |
| CN111767117B (en) * | 2020-06-22 | 2024-02-20 | 中兴智慧(北京)技术有限公司 | Mobile end BI middleware technology based on application container |
| CN111767117A (en) * | 2020-06-22 | 2020-10-13 | 博易智软(北京)技术有限公司 | Mobile-end BI middleware technology based on application container |
| CN113505181A (en) * | 2020-09-29 | 2021-10-15 | 西部证券股份有限公司 | Derivative time sequence data making method based on dolphindb database |
| CN112527868A (en) * | 2020-12-23 | 2021-03-19 | 东莞市盟大塑化科技有限公司 | Data acquisition method, device, equipment and storage medium |
| CN112766910B (en) * | 2021-01-21 | 2023-10-27 | 深圳市极致科技股份有限公司 | Document construction method, generation method, device, electronic equipment and storage medium |
| CN112766910A (en) * | 2021-01-21 | 2021-05-07 | 深圳市极致科技股份有限公司 | Document construction method, document generation device, electronic equipment and storage medium |
| CN113656479A (en) * | 2021-08-18 | 2021-11-16 | 国网北京市电力公司 | Data processing method and device |
| CN114064716B (en) * | 2021-10-29 | 2023-10-20 | 北京市农林科学院信息技术研究中心 | Metadata-based automatic WEB report generation method and device |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| WO2023083114A1 (en) * | 2021-11-15 | 2023-05-19 | International Business Machines Corporation | Dynamic database object description adjustment |
| CN116389579A (en) * | 2023-03-22 | 2023-07-04 | 安芯网盾(北京)科技有限公司 | Report generation method and system based on micro-service |
| CN117251457A (en) * | 2023-11-20 | 2023-12-19 | 昆山华东信息科技有限公司 | Grid report making method and device |
| CN117251457B (en) * | 2023-11-20 | 2024-03-12 | 昆山华东信息科技有限公司 | Grid report making method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1588369A (en) | Relation type data base system and its search and report method | |
| JP6962971B2 (en) | Systems and methods for implementing data storage services | |
| CN104216912B (en) | The implementation method and device of a kind of business form work fluidisation without intrusive mood | |
| CN1554046A (en) | System and method for transaction processing with transaction property feature | |
| RU2628902C2 (en) | Coordination mechanism for cloud choice | |
| US8856066B2 (en) | Sharing information between tenants of a multi-tenant database | |
| US7580946B2 (en) | Smart integration engine and metadata-oriented architecture for automatic EII and business integration | |
| US8266138B1 (en) | On-demand database service system, method and computer program product for generating a custom report | |
| CN1554056A (en) | System and method for transaction processing with synchronized callback processing feature | |
| JP4571636B2 (en) | Service management of service-oriented business framework | |
| CN1836232A (en) | Automatic and dynamic provisioning of databases | |
| US20050228790A1 (en) | Coherent categorization scheme | |
| CN1419186A (en) | Location price-quotation for search system paying according sequence | |
| CN1744120A (en) | Conversion between application objects and smart client objects | |
| US9342572B2 (en) | Workflow processing system and method with database system support | |
| CN1221908C (en) | Communication method and system between supplier and customer devices | |
| CN1744121A (en) | Add-in architecture for smart client applications | |
| CN1744122A (en) | Synchronization for smart clients | |
| US20080222163A1 (en) | Automatic Data Consolidation | |
| CN1856790A (en) | Information access using ontologies | |
| CN1875344A (en) | Introductory operation support system for integrated business software | |
| CN1464401A (en) | Object oriented system and method using shadow object for verification control | |
| CN107506442A (en) | The modeling method and device of a kind of model | |
| CN1295636C (en) | An efficient index structure to access hierarchical data in a relational database system | |
| CN1777893A (en) | Database coommnication system based on network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20050302 |