CN101847153B - Dynamic data processing method and device - Google Patents
Dynamic data processing method and device Download PDFInfo
- Publication number
- CN101847153B CN101847153B CN2010101034882A CN201010103488A CN101847153B CN 101847153 B CN101847153 B CN 101847153B CN 2010101034882 A CN2010101034882 A CN 2010101034882A CN 201010103488 A CN201010103488 A CN 201010103488A CN 101847153 B CN101847153 B CN 101847153B
- Authority
- CN
- China
- Prior art keywords
- field
- data
- carrier
- database
- view
- 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.)
- Expired - Fee Related
Links
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24573—Query processing with adaptation to user needs using data annotations, e.g. user-defined metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/904—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/907—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
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)
- Library & Information Science (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a dynamic data processing method. The method comprises the following steps of: loading at least one database and loading at least one table or view in the database; inquiring all the fields of the loaded table or view and loading the fields on a first carrier; selecting any one or more of the fields from the first carrier and dragging the selected fields to a second carrier to establish a data relationship between the second carrier and the selected fields; and processing the data in the fields on the second carrier during application. Correspondingly, the invention also discloses a dynamic data processing system. In the method and the device, the data resources are abundant; and at the same time, the data relationship is established dynamically on a presentation layer, so that the presentation layer can process the data more intuitively and flexibly.
Description
Technical field
The present invention relates to database technical field, relate in particular to a kind of method and device of dynamic data processing.
Background technology
In network technology, the three-layer network structure applications is comparatively extensive.Said three-layer network structure refers to data handling procedure is divided into three parts: ground floor is presentation layer (also being client, user interface layer), and it provides the friendly visit between user and the system; The second layer is middle layer (also being application service layer), and it specially takes charge of the realization of service logic; The 3rd layer is database (also being data service layer, data source layer), is responsible for storage, visit and the optimization thereof of data message.
Existing presentation layer mainly plays the effect that represents (demonstration) to data; Its main scheme is: a plurality of tables or the view of retrieving same database; The literary name section that extraction is associated; At database or middle layer tissue or handle these literary name sections, confirm the data in the field that presentation layer will represent, show these established datas by presentation layer then.
The inventor finds that there is following defective in existing technical scheme:
1, the source of data is single.Existing scheme the data that will represent all from same database, its source is too single.
2, the data that presentation layer represented can not change.Because the tissue of data relationship and processing are in database or middle layer, it confirms in advance promptly that between presentation layer represents therefore, presentation layer only is responsible for representing its data, and its data that represent can not change.
3, the tissue treatment of data is directly perceived inadequately.Because presentation layer is merely data and represents, and does not carry out the processing of data relationship, its data relationship is based upon database or middle layer, and the processing of whole data relationship is directly perceived inadequately.
Summary of the invention
The objective of the invention is to, a kind of method and device of dynamic data processing is provided, its Data Source is horn of plenty more, simultaneously, dynamically sets up data relationship at presentation layer, makes presentation layer more directly perceived and flexible to the processing of data.
To achieve these goals, the embodiment of the invention discloses a kind of method of dynamic data processing, comprising:
Load at least one database and load at least one table or the view in the said database;
Inquire about all fields of the table or the view of said loading, said field is loaded on first carrier;
Select any or a plurality of field from said first carrier, the field of said selection is dragged to second carrier, make the field of said second carrier and said selection set up data relationship;
In application, handle the data in the field on said second carrier.
Correspondingly, the embodiment of the invention also provides a kind of dynamic data processing system, comprising:
First load-on module is used at least one table or the view that load at least one database and load said database;
Enquiry module is used to inquire about from the said table of said first load-on module loading or all fields of view;
Second load-on module is used for the said field that said enquiry module inquires is loaded into first carrier;
Dynamic relationship is set up module, is used for selecting any or a plurality of field from said first carrier, and the field of said selection is dragged to second carrier, makes the field of said second carrier and said selection set up data relationship;
Processing module is used for handling the data in the field on said second carrier in application.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
Description of drawings
Fig. 1 is the structural representation of the embodiment of dynamic data processing device of the present invention;
Fig. 2 is the DFD of the data processing of dynamic data processing device of the present invention;
Fig. 3 sets up the structural representation of the embodiment of module for the dynamic relationship of dynamic data processing device of the present invention;
Fig. 4 sets up the structural representation of embodiment of the loading unit of module for dynamic relationship of the present invention;
Fig. 5 is the structural representation of embodiment of the processing module of dynamic data processing device of the present invention;
Fig. 6 is the process flow diagram of first embodiment of data dynamically-processing method of the present invention;
Fig. 7 is the process flow diagram of second embodiment of data dynamically-processing method of the present invention;
Fig. 8 drags the synoptic diagram of realization for mouse;
Fig. 9 is the process flow diagram of the 3rd embodiment of data dynamically-processing method of the present invention;
Figure 10 is the synoptic diagram that the database of the 4th embodiment of data dynamically-processing method of the present invention loads;
Figure 11 is the synoptic diagram that table or view load in the database of the 4th embodiment of data dynamically-processing method of the present invention;
Figure 12 is the synoptic diagram that the field of table or view of the 4th embodiment of data dynamically-processing method of the present invention loads;
Figure 13 sets up first view in the process for the data relationship of the 4th embodiment of data dynamically-processing method of the present invention;
Figure 14 sets up second view in the process for the data relationship of the 4th embodiment of data dynamically-processing method of the present invention;
Figure 15 sets up the third state synoptic diagram in the process for the data relationship of the 4th embodiment of data dynamically-processing method of the present invention;
Figure 16 sets up the four condition synoptic diagram in the process for the data relationship of the 4th embodiment of data dynamically-processing method of the present invention;
Figure 17 is the synoptic diagram of application processes of the 4th embodiment of data dynamically-processing method of the present invention.
Embodiment
To combine the accompanying drawing in the embodiment of the invention below, the technical scheme in the embodiment of the invention is carried out clear, intactly description, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
See also Fig. 1, be the structural representation of the embodiment of dynamic data processing device of the present invention; As shown in Figure 1, this device comprises: first load-on module 10, and enquiry module 20, the second load-on modules 30, dynamic relationship is set up module 40 and processing module 50.
This first load-on module 10 is used at least one table or the view that load at least one database and load said database; In concrete the realization, can be through getting into the configuration management interface of database, the IP or the machine name at input database server place; The input or select one or more databases, import or select at least one database, load through this first load-on module 10; After database loads successfully, inquire the tables of data or the Data View that are comprised in the said loaded data storehouse, and therefrom select at least one these table or view to carry out; Load through this first load-on module 10; Particularly, tables of data or Data View also can be carried in carrier (such as: tree construction), concrete loading procedure is identical with the loading of the layoutprocedure of existing data source; When selecting a database to load, compatible with prior art.In addition, the configuration of data source is included, but are not limited to loading of databases, also can load XML (Extensible Markup Language; Extend markup language) data file; Or XSD (XML Schemas Definition, XML organization definition) data file or the like, do not give unnecessary details at this.
This enquiry module 20 is used for from the said table of said first load-on module 10 loadings or all fields of view;
This second load-on module 30 is used for the said field that said enquiry module 20 inquires is loaded into first carrier; In concrete the realization, this first carrier is positioned at presentation layer, is used for ccontaining or loading data.Particularly, this first carrier is the entity in the application program, can include but not limited to: any one or more in tree construction, window and the control.
This dynamic relationship is set up module 40, is used for selecting any or a plurality of field from said first carrier, and the field of said selection is dragged to second carrier, makes the field of said second carrier and said selection set up data relationship; In concrete the realization, this second carrier is used for ccontaining or loading data for being positioned at presentation layer.Particularly, this second carrier is the entity in the application program, can include but not limited to: any one or more in tree construction, window and the control.
This processing module 50 is used for handling the data in the field on said second carrier in application.In concrete the realization; The processing of processing module 50 in application is according to the difference of each application; Its processing mode is also different; Such as: this processing module 50 is handled the field on said second carrier in application processing mode can include but not limited to: show the data in this field, delete in data and the data of revising in this field in this field any one or more.
See also Fig. 1 again, this device also comprises: sending module 60.
This sending module 60 is used for the data of the field after said processing module 50 processing are sent to the database that said field belongs to; Said processing module 50 can also be sent to other databases with the data in the field after handling; In concrete the realization; After the data of 50 pairs of fields of this processing module are handled; This sending module 60 can resend the data after handling to database, so that the data in the database are used in follow-up application.
Or: this sending module 60 is used for the data of the field after said processing module 50 processing are sent to new application, in concrete the realization; Can there be a plurality of application simultaneously in data access; So, after the data of 50 pairs of fields of this processing module were handled accordingly, this sending module 60 can also send to the data after handling other application and use these data; Like this, can be implemented in other application of processing in the application program.
The data stream of the dynamic data processing of present embodiment specifically can be the DFD of dynamic data processing system of the present invention to the data processing referring to Fig. 2.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
For clearer explanation the present invention, will set up module to the dynamic relationship of dynamic data processing device of the present invention below and do detailed introduction.
See also Fig. 3, set up the structural representation of the embodiment of module for the dynamic relationship of dynamic data processing device of the present invention; This dynamic relationship is set up module 40 and comprised: selected cell 401 drags unit 402, storage unit 403, loading unit 404 and acquiring unit 405.
This selected cell 401 is used for selecting any or a plurality of field from said first carrier; In concrete the realization, can use some data,, in concrete the realization, can realize selection through click from one or more fields at these data places of said first carrier selection according to needs in using at this.
This drags unit 402, is used to drag field to the second carrier of said selection; In concrete the realization; This drags unit 402 can carry out dragging of field through mouse; Such as: with the field that left mouse button (or right button) some residence is selected, drag this field to the second carrier then after, unclamp left mouse button (or right button); Promptly realized the process that drags of field, this process that drags has been showed the dynamic foundation of data relationship comparatively intuitively.
This storage unit 403 is used for dragging the process that unit 402 drags said, writes down the table or the view at the said field that drags, the said field place that drags, and the database at the said field place that drags;
This loading unit 404 is used to load the said field that drags to said second carrier, and after loading through this loading unit 404, second carrier has promptly loaded this field that drags;
In concrete the realization, see also Fig. 4, set up the structural representation of embodiment of the loading unit of module for dynamic relationship of the present invention; This loading unit 404 comprises: judging unit 411, the first loading units 412 and second loading unit 413.
This judging unit 411 is used to judge on said second carrier whether field is arranged;
This first loading unit 412 is used for being judged as when being when said judging unit 411, loads the said field that drags to said second carrier to replace original field;
This second loading unit 413 is used for when said judging unit 411 is judged as not, directly loading the said field that drags to said second carrier.
See also Fig. 3 again:
This acquiring unit 405; Be used for obtaining the table at the said field place that drags or the database at view and place from said storage unit 403; After this acquiring unit 405 carries out corresponding obtaining, promptly set up the data relationship of second carrier and the field on it, in application; Promptly can be connected to the data of extracting in the field in the database and handle accordingly according to data relationship.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
For clearer explanation the present invention, will do detailed introduction to the processing module of dynamic data processing device of the present invention below.
See also Fig. 5, be the structural representation of the embodiment of the processing module of dynamic data processing device of the present invention; This processing module 50 comprises: data linkage unit 501 and data-reading unit 502.
This data linkage unit 501 is used for the said database, table or the view that obtain according to said acquiring unit 405, is connected to the said database that obtains, and inquires said table that obtains or view;
This data-reading unit 502 is used for finding the field on said second carrier from table or view that said data linkage unit 501 inquires, and reads the data in the said field.
See also Fig. 5 again, this processing module 50 also comprises: display unit 503, revise unit 504 and delete cells 505.
This display unit 503 is used for showing the data that said data-reading unit reads in application;
This revises unit 504, is used for revising the data that said data-reading unit reads in application;
This delete cells 505 is used for the data that read in the said data-reading unit of application deletion.
In concrete the realization; This processing module 50 comprises above-mentioned display unit 503, revises in unit 504 and the delete cells 505 any one or more, and this mainly is to be determined by the processing mode to each application; Because using, each has difference; Its processing mode is also different, and therefore, this processing module 50 is not limited to above-mentioned three kinds of pairing unit of processing mode.Particularly; Above-mentioned three kinds of processing modes of this processing module 50 can exist simultaneously; It is only handled simultaneously need read the data that will handle through above-mentioned data linkage unit 501 and data-reading unit 502; Handle accordingly then, so just overcome to handle in the prior art at every turn and all need set up specific database in advance and be connected this technological deficiency with tables of data.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
For clearer explanation the present invention, will do detailed introduction to data dynamically-processing method of the present invention below.
See also Fig. 6, be the process flow diagram of first embodiment of data dynamically-processing method of the present invention; As shown in Figure 6, this method comprises:
S101 loads at least one database and loads at least one table or the view in the said database;
S102, all fields of inquiring about the table or the view of said loading are loaded into said field on first carrier;
S103 selects any or a plurality of field from said first carrier, and the field of said selection is dragged to second carrier, makes the field of said second carrier and said selection set up data relationship;
S104 handles the data in the field on said second carrier in application.
In concrete the realization; Difference according to each application; The processing mode of S104 is also different; Such as: S104 handles the field on said second carrier in application processing mode can include but not limited to: show the data in this field, delete in data and the data of revising in this field in this field any one or more.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
See also Fig. 7, be the process flow diagram of second embodiment of data dynamically-processing method of the present invention; Particularly, the dynamically flow process of foundation of data relationship that embodied embodiment illustrated in fig. 7; As shown in Figure 7, this method comprises:
S201 selects any or a plurality of field from said first carrier; In concrete the realization, can use some data,, in concrete the realization, can realize selection through click from one or more fields at these data places of said first carrier selection according to needs in using at this.
S202, mouse drag field to the second carrier of said selection; In concrete the realization; Such as: with the field that left mouse button (or right button) some residence is selected, drag this field to the second carrier then after, unclamp left mouse button (or right button); Promptly realized the process that drags of field, this process that drags has been showed the dynamic foundation of data relationship comparatively intuitively.
In concrete the realization, mouse drags implementation procedure can drag the synoptic diagram of realization referring to Fig. 8 for mouse; As shown in Figure 8:
Left mouse button (right button) is selected a literary name section on the carrier, pins mouse and does not put, and drags field; In the process of dragging, the literary name section that drags of record in have storage unit, can begin to monitor mouse state by calling system API (Application Programming Interface, API) then; The field that mouse drags gets in second carrier, and second carrier is caught the cursor of mouse, changes the Show Styles of cursor; On second carrier, unclamp mouse, API monitors mousebutton and unclamps, and composes the data of the field of memory to second carrier then, discharges API, stops mouse and monitors, and it is initial state that mouse state is set.The process that mouse drags is not given unnecessary details at this with existing similar to utilizing of mouse.Use mouse to drag the foundation that realizes data relationship, more directly perceived.
See also Fig. 7 again:
S203 writes down the table or the view at the said field that drags, the said field place that drags, and the database at the said field place that drags;
S204, whether second carrier on have field, if judged result is for being then to carry out step S205 if judging; If judged result is then carried out step S206 for not;
S205 replaces original field; In concrete the realization, original field replaced through loading the said field that drags to said second carrier realize.
S206 directly loads the said field that drags to said second carrier;
S207 obtains said field place table or the view that drags, and the database at the said field place that drags.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
See also Fig. 9, be the process flow diagram of the 3rd embodiment of data dynamically-processing method of the present invention, this method comprises:
S301 according to the database that obtains, table or view, is connected to the said database that obtains, and inquires said table that obtains or view;
S302 finds the field on said second carrier, and reads the data on the said field from said table that inquires or view;
S303 shows the data that read among the S302 in application;
S304 revises the data that read among the S302 in application;
S305, the data that in application, read among the deletion S302;
S306 sends the database at data to the said data place after S303, S304 and S305 handle, or sends data to the new application after S303, S304 and S305 handle.
The present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
For clearer explanation the present invention, will do detailed introduction to data dynamically-processing method of the present invention with an instantiation below.
Figure 10-17 is the synoptic diagram of the 4th embodiment of data dynamically-processing method of the present invention.See also Figure 10, be the synoptic diagram that database loads, shown in figure 10:
Through the interface of database configuration management, the IP or the machine name at input database server place; Input or selection database; The input username and password; The description of input database (mainly being to manage for ease).Click to preserve then, attempt connecting the server at database place with username and password, if successful connection then add freelist to, otherwise prompting makes mistakes.After successfully connecting, then accomplished the loading of database.
See also Figure 11, be the synoptic diagram of the loading of any table or view in the database, shown in figure 11:
From above-mentioned freelist, select a database, click when confirming, can inquire tables of data or Data View that this database comprises.Then, can load these tables or view by tree construction (carrier).Further shown in figure 11, this tree construction is with database masterpiece root node, and table and view are done child node, and table name and view name are done leaf.
See also Figure 12, be the synoptic diagram that table or the field of view load, shown in figure 12:
Select any table or view, can inquire when click confirming this table or view all fields, add these fields on the tree construction (first carrier) to.Wherein, database masterpiece root node, table or view are done child node, and field is done leaf.
Figure 13-16 is field and the second carrier (control in the webpage: display field) set up synoptic diagram under each state in the process of data relationship.See also Figure 13, for data relationship of the present invention is set up first view in the process; Shown in figure 13:
As above-mentioned, database has been arranged, tables of data (view) and field;
See also Figure 14, for data relationship of the present invention is set up second view in the process, shown in figure 14:
The leaf node of click data table tree is chosen one of them field;
See also Figure 15, for data relationship of the present invention is set up the third state synoptic diagram in the process, shown in figure 15:
Press left mouse button (right button) and do not put, move to mouse in the applying web page, in the process of dragging, write down this leaf node and monitor mouse state, unclamp mouse, stop to monitor, recover mouse to original state in the place of display field;
See also Figure 16, for data relationship of the present invention is set up the four condition synoptic diagram in the process, shown in figure 16:
Display field promptly obtains the leaf node data (field) that drag, and sets up data relationship with this field.
See also Figure 17, be the synoptic diagram of the application processes of the 4th embodiment of data dynamically-processing method of the present invention, being applied as in the present embodiment opened news web page, and application processes is the data of display field, and is shown in figure 17:
Through aforesaid operations, be connected to database server, from data of database table or view, extract the data of respective field, then in the corresponding data of position display of the display field of webpage.
Through the description of the foregoing description, the present invention makes more horn of plenty of Data Source through in one or more databases, extracting data; In the mode that presentation layer drags, set up data relationship intuitively, dynamically, and data are handled accordingly at presentation layer, comprise demonstration, modification, deletion or the like, make presentation layer more flexible to the processing of data.
Above disclosedly be merely a kind of preferred embodiment of the present invention; Certainly can not limit the present invention's interest field with this; One of ordinary skill in the art will appreciate that all or part of flow process that realizes the foregoing description; And, still belong to the scope that invention is contained according to the equivalent variations that claim of the present invention is done.
Claims (14)
1. the method for a dynamic data processing is characterized in that:
Load at least one database and load at least one table or the view in the said database;
Inquire about all fields of the table or the view of said loading, said field is loaded on first carrier;
Select any or a plurality of field from said first carrier, the field of said selection is dragged to second carrier, make the field of said second carrier and said selection set up data relationship;
In application, handle the data in the field on said second carrier.
2. the method for claim 1 is characterized in that, saidly selects any or a plurality of field from said first carrier, and the field of said selection is dragged to second carrier, makes the field of said second carrier and said selection set up data relationship, comprising:
Select any or a plurality of field from said first carrier;
Drag field to the second carrier of said selection, and drag in the process, the table or the view at the said field that drags of record, the said field place that drags in internal memory, and the database at the said field place that drags said;
Load the said field that drags to said second carrier, and from said internal memory, obtain the table at the said field place that drags or the database at view and place.
3. method as claimed in claim 2 is characterized in that, the said field that drags of said loading to said second carrier comprises:
Judge on said second carrier whether field is arranged, be, load the said field that drags to said second carrier to replace original field if be judged as;
If be judged as not, directly load the said field that drags to said second carrier.
4. method as claimed in claim 3 is characterized in that, the data in the said field of in application, handling on said second carrier comprise:
According to said said database, table or the view that obtains, be connected to the said database that obtains, and inquire said table that obtains or view;
From said table that inquires or view, find the field on said second carrier, and read the data in the said field;
In application, show the said data that read.
5. method as claimed in claim 3 is characterized in that, the data in the said field of in application, handling on said second carrier comprise:
According to said said database, table or the view that obtains, be connected to the said database that obtains, and inquire said table that obtains or view;
From said table that inquires or view, find the field on said second carrier, and read the data in the said field;
In application, revise the said data that read.
6. method as claimed in claim 3 is characterized in that, the data in the said field of in application, handling on said second carrier comprise:
According to said said database, table or the view that obtains, be connected to the said database that obtains, and inquire said table that obtains or view;
From said table that inquires or view, find the field on said second carrier, and read the data in the said field;
The said data that read of deletion in application.
7. like each described method of claim 4-6, it is characterized in that, after the data in the said field of in application, handling on said second carrier, also comprise:
Data in the field after the said processing are sent to the database at said field place; Or:
Data in the field after the said processing are sent to new application.
8. method as claimed in claim 7 is characterized in that:
Said first carrier and said second carrier comprise: any one or more in tree construction, window and the control.
9. a dynamic data processing system is characterized in that, comprising:
First load-on module is used at least one table or the view that load at least one database and load said database;
Enquiry module is used to inquire about from the said table of said first load-on module loading or all fields of view;
Second load-on module is used for the said field that said enquiry module inquires is loaded into first carrier;
Dynamic relationship is set up module, is used for selecting any or a plurality of field from said first carrier, and the field of said selection is dragged to second carrier, makes the field of said second carrier and said selection set up data relationship;
Processing module is used for handling the data in the field on said second carrier in application.
10. device as claimed in claim 9 is characterized in that, said dynamic relationship is set up module and comprised:
Selected cell is used for selecting any or a plurality of field from said first carrier;
Drag the unit, be used to drag field to the second carrier of said selection;
Storage unit is used for dragging the process that the unit drags said, writes down the table or the view at the said field that drags, the said field place that drags, and the database at the said field place that drags;
Loading unit is used to load the said field that drags to said second carrier;
Acquiring unit is used for obtaining the table at the said field place that drags or the database at view and place from said storage unit.
11. device as claimed in claim 10 is characterized in that, said loading unit comprises:
Judging unit is used to judge on said second carrier whether field is arranged;
First loading unit, be used for when said judgment unit judges when being, load the said field that drags to said second carrier to replace original field;
Second loading unit, be used for when said judgment unit judges for not the time, directly load the said field that drags to said second carrier.
12. device as claimed in claim 11 is characterized in that, said processing module comprises:
The data linkage unit is used for the said database, table or the view that obtain according to said acquiring unit, is connected to the said database that obtains, and inquires said table that obtains or view;
Data-reading unit is used for finding the field on said second carrier from table or view that said data linkage unit inquires, and reads the data in the said field.
13. device as claimed in claim 12 is characterized in that, said processing module also comprises:
Display unit is used for showing the data that said data-reading unit reads in application; And/or:
Revise the unit, be used for revising the data that said data-reading unit reads in application; And/or
Delete cells is used for the data that read in the said data-reading unit of application deletion.
14. device as claimed in claim 13 is characterized in that, also comprises:
Sending module is used for the data of the field after the said processing module processing are sent to the database that said field belongs to; Or:
Be used for the data of the field after the said processing module processing are sent to new application.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101034882A CN101847153B (en) | 2010-01-27 | 2010-01-27 | Dynamic data processing method and device |
| PCT/CN2011/070248 WO2011091727A1 (en) | 2010-01-27 | 2011-01-14 | Method and device for data dynamic processing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101034882A CN101847153B (en) | 2010-01-27 | 2010-01-27 | Dynamic data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101847153A CN101847153A (en) | 2010-09-29 |
| CN101847153B true CN101847153B (en) | 2012-08-22 |
Family
ID=42771775
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010101034882A Expired - Fee Related CN101847153B (en) | 2010-01-27 | 2010-01-27 | Dynamic data processing method and device |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN101847153B (en) |
| WO (1) | WO2011091727A1 (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101847153B (en) * | 2010-01-27 | 2012-08-22 | 深圳市龙视传媒有限公司 | Dynamic data processing method and device |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | Method, server and system for dynamically returning data |
| CN111079192B (en) * | 2018-10-18 | 2022-03-01 | 宏碁股份有限公司 | Webpage content self-protection method and server |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6360249B1 (en) * | 1998-03-06 | 2002-03-19 | I2 Technologies Us, Inc. | Enterprise interaction hub for managing an enterprise web system |
| CN1538324A (en) * | 2003-04-16 | 2004-10-20 | ��Ϊ��������˾ | Method of raising officiency of data processing |
| CN101208692A (en) * | 2005-04-12 | 2008-06-25 | 科格洛斯公司 | Automatically moving multidimensional data between live datacubes of enterprise software systems |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8099446B2 (en) * | 2007-12-12 | 2012-01-17 | International Business Machines Corporation | Digital content searching tool |
| CN101359290A (en) * | 2008-09-11 | 2009-02-04 | 中兴通讯股份有限公司 | Method for customizing service document based on metadata and apparatus |
| CN101847153B (en) * | 2010-01-27 | 2012-08-22 | 深圳市龙视传媒有限公司 | Dynamic data processing method and device |
-
2010
- 2010-01-27 CN CN2010101034882A patent/CN101847153B/en not_active Expired - Fee Related
-
2011
- 2011-01-14 WO PCT/CN2011/070248 patent/WO2011091727A1/en active Application Filing
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6360249B1 (en) * | 1998-03-06 | 2002-03-19 | I2 Technologies Us, Inc. | Enterprise interaction hub for managing an enterprise web system |
| CN1538324A (en) * | 2003-04-16 | 2004-10-20 | ��Ϊ��������˾ | Method of raising officiency of data processing |
| CN101208692A (en) * | 2005-04-12 | 2008-06-25 | 科格洛斯公司 | Automatically moving multidimensional data between live datacubes of enterprise software systems |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101847153A (en) | 2010-09-29 |
| WO2011091727A1 (en) | 2011-08-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8321803B2 (en) | Aggregating service components | |
| CN101960439B (en) | Client environment creates system and client environment creation method | |
| DE112013002542T5 (en) | Cloud-based application resource files | |
| CN101777008A (en) | Method and device for realizing mobile terminal system thread pool | |
| US9442618B2 (en) | Mobile device interface generator | |
| CN102224708B (en) | Unified storage for configuring muliple networking technologies | |
| CN103246549B (en) | A kind of method and system of data conversion storage | |
| CN104781793A (en) | Systems and methods for integrating storage usage information | |
| CN102819500B (en) | A kind of method and device creating peripheral equipment control interface | |
| CN106302640A (en) | Data request processing method and device | |
| CN102098233B (en) | Method and system for controlling communication window in instant messenger | |
| CN105183768A (en) | File management method, apparatus and terminal device | |
| CN104008441A (en) | Task management system and method for automatically submitting files into version library | |
| CN101847153B (en) | Dynamic data processing method and device | |
| CN104484358A (en) | Process template displaying method and system | |
| CN102214090A (en) | Method and device for creating session window | |
| US10439897B1 (en) | Method and apparatus for enabling customized control to applications and users using smart tags | |
| US10169055B2 (en) | Access identifiers for graphical user interface elements | |
| CN103098055A (en) | Recursive navigation in mobile customer relations management | |
| CN109725973B (en) | Data processing method and data processing device | |
| CN116645060A (en) | Automatic work order system operation and maintenance method and device based on SOAR and processing equipment | |
| CN103440300A (en) | Operation system and method for managing files based on events | |
| CN102780780A (en) | Method, equipment and system for data processing in cloud computing mode | |
| CN109145545A (en) | A kind of processing method and processing device of user's operation | |
| CN106445522A (en) | Storage interface display method based on floating window |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1148363 Country of ref document: HK |
|
| ASS | Succession or assignment of patent right |
Owner name: SHENZHEN LONGSHI MEDIA CO., LTD. Free format text: FORMER OWNER: SHENZHEN TONGZHOU ELECTRONIC CO., LTD. Effective date: 20120424 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 518129 SHENZHEN, GUANGDONG PROVINCE TO: 518057 SHENZHEN, GUANGDONG PROVINCE |
|
| TA01 | Transfer of patent application right |
Effective date of registration: 20120424 Address after: 518057 A2-3 District, rainbow tech building, North Fifth Industrial Zone, north high tech Zone, Guangdong, Shenzhen Applicant after: Shenzhen Longguan Media Co., Ltd. Address before: 518129 Rainbow Technology Building, North hi tech Zone, Nanshan District, Guangdong, Shenzhen Applicant before: Shenzhen Tongzhou Electronic Co., Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: SHENZHEN TONGZHOU ELECTRONIC CO., LTD. Free format text: FORMER OWNER: SHENZHEN LONGSHI MEDIA CO., LTD. Effective date: 20140516 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20140516 Address after: 518057 rainbow science and Technology Building (North West Road), Nanshan District hi tech Zone, Shenzhen, Guangdong Patentee after: Shenzhen Tongzhou Electronic Co., Ltd. Address before: 518057 A2-3 District, rainbow tech building, North Fifth Industrial Zone, north high tech Zone, Guangdong, Shenzhen Patentee before: Shenzhen Longguan Media Co., Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120822 Termination date: 20150127 |
|
| EXPY | Termination of patent right or utility model | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: WD Ref document number: 1148363 Country of ref document: HK |