CN103150370A - Database system and data sieving method thereof - Google Patents
Database system and data sieving method thereof Download PDFInfo
- Publication number
- CN103150370A CN103150370A CN2013100735520A CN201310073552A CN103150370A CN 103150370 A CN103150370 A CN 103150370A CN 2013100735520 A CN2013100735520 A CN 2013100735520A CN 201310073552 A CN201310073552 A CN 201310073552A CN 103150370 A CN103150370 A CN 103150370A
- Authority
- CN
- China
- Prior art keywords
- row
- data
- module
- client
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000007873 sieving Methods 0.000 title abstract 10
- 238000001914 filtration Methods 0.000 claims abstract description 9
- 238000004891 communication Methods 0.000 claims abstract description 3
- 238000012216 screening Methods 0.000 claims description 35
- 241001269238 Data Species 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000717 retained effect Effects 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- VYZAMTAEIAYCRO-UHFFFAOYSA-N Chromium Chemical compound [Cr] VYZAMTAEIAYCRO-UHFFFAOYSA-N 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000012467 final product Substances 0.000 description 1
Images
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The invention relates to a database system and a data sieving method thereof. The database system comprises a server and a client which can be in communication connection. The client is provided with a receiving module, a display module and a data sieving system, wherein the receiving module is used for receiving data returned from the server, and the display module is used for displaying the data in rows and columns. The data sieving system comprises a column sieving module, a row sieving module and a window drawing module. The column sieving module is used for acquiring column information of the data and filtering corresponding columns according to column information selected by a user. The row sieving column divides rows selecting the columns into a plurality of row sets, and corresponding rows are filtered according to the row set section of the user. The display module displays the data in a row/column way after corresponding columns and/or the rows are filtered out. According to the database system and data sieving method, data sieving can be carried out at the client, and any resource of the server cannot be occupied, so that the load of the server is lowered, and the server has the advantage of high responding speed.
Description
[technical field]
The present invention relates to data screening, more specifically, relate to a kind of Database Systems and data screening method thereof.
[background technology]
List data is the most frequently used data type.List data shows in the mode of row, column, and every row has corresponding line number or row name, and every row have corresponding row number or row name.Usually, the row name is also referred to as field.
A lot of databases adopt the form of server-client.The server stores data, and return to user's Query Result to client.Client and user carry out alternately, and show Query Result to the user.This Query Result presents with the form of list data usually.If hit results is more, the Query Result that returns will be a lot, cause the line number of Query Result, columns all a lot, and the user easily misunderstands or the over sight (OS) data.In this kind situation, the user wishes to filter out undesired data.In prior art, the user can increase querying condition, carries out new inquiry, progressively to filter out undesired data.Yet this scheme has significantly increased the weight of the burden of server, and response speed is slow.
Therefore, need a kind of solution that overcomes defects badly.
[summary of the invention]
One aspect of the present invention provides a kind of Database Systems, but comprises the server and client side that communication connects; Described client has receiver module and display module, and described receiver module is used for receiving the data that described server returns, and described display module is used for showing described data in the mode of ranks.Described client also comprises the data screening system that is connected with described display module, described data screening system comprises: the column filter module, described column filter module is used for obtaining the column information of described data, and the selection of column information is filtered out the row of correspondence according to the user; Described display module shows the described corresponding row data afterwards that filter out in the mode of ranks.
In a preferred version, described data screening module also comprises the row filter module, and described row filter module is used for the row of select column is divided into the several rows set, and the selection of row set is filtered out the row of correspondence according to the user; Described display module shows the described corresponding row data afterwards that filter out in the mode of ranks.
In a preferred version, described client is web browser.
In a preferred version, described data screening module also comprises the forms drafting module, and described forms drafting module is connected with described column filter module, row filter module, is used for creating the first forms in order to show the entrance of described column filter module, row filter module.
In a preferred version, described forms drafting module is also drawn the second forms, the 3rd forms, is respectively used to show described column information, described row set.
A second aspect of the present invention provides a kind of data screening method, is included in data that the client server returns and shows described data with the mode of ranks.Described data screening method also comprises: obtain the column information of described data in described client, and the selection of column information is filtered out the row of correspondence according to the user; Again show described data after filtering out corresponding row in the mode of ranks in described client.
In a preferred version, described data screening method also comprises: in described client, the row of select column is divided into the several rows set, and according to the user, the selection of row set is filtered out corresponding row; Again show described data after filtering out corresponding row in the mode of ranks in described client.
In a preferred version, described client is web browser.
In a preferred version, described data screening method also comprises: draw the first forms in described client, and provide access to guide the user area to filter out the row of corresponding row, correspondence at described the first forms.
In a preferred version, described data screening method also comprises: draw the second forms and the 3rd forms in described client, be respectively used to show described column information and described row set.
Implement the present invention, can carry out data screening in client, and not take any resource of server, alleviate the burden of server, and have advantages of fast response time
[description of drawings]
Fig. 1 is the schematic diagram of the Database Systems that provide of one embodiment of the invention;
Fig. 2 is the process flow diagram of the data screening method of Database Systems shown in Figure 1;
Part of screen sectional drawing when Fig. 3 to Fig. 5 is data screening method operation shown in Figure 2.
[embodiment]
With reference to figure 1 and Fig. 2, the Database Systems that one embodiment of the invention provides comprise client 10 and the server end 20 that can communicate to connect.Should recognize, client 10 can be positioned on different equipment (as computing machine) from server end 20, also can be positioned at same equipment.Client 10 is in the face of the user, also referred to as front end.Server end mainly provides back-office support, also referred to as the rear end.A rear end can provide support for a plurality of front ends simultaneously.Preferably, client 10 is web browser, such as the IE web browser of Microsoft, the Chrome browser of Google, the Firefox browser of seeking intelligence company, the Safari browser of Apple etc.
Server end 20 comprises database 21, enquiry module 23, modified module 25.Database 21 is used for the storage data, and enquiry module 23 is for the treatment of the data query request, and modified module 25 is used for the data in Update Table storehouse 21.
Client 10 has receiver module 11, display module 13 and data screening system 15.Receiver module 11 is used for the data that reception server 20 returns.For example, the user initiates the data query request by client 10 to server, and server 20 is processed this query requests, and Query Result is returned to client 10.The data that display module 13 returns with the mode display server 20 of ranks in client 10.Data screening system 15 comprises column filter module, row filter module and forms drafting module, is used for shown data are screened, and hereinafter can describe in detail.
With reference to figure 3 to Fig. 6, in step S51, the data that the receiver module reception server of client returns.
In step S53, the display module of client shows described data in the mode of ranks.
In step S55, the column filter module of the data screening system of client is obtained the column information of data, according to the user, the selection of column information is filtered out corresponding row, and again shows the described data that filter out after corresponding row in the mode of ranks.Described column information can be the numbering of row, such as A row, B row, C row etc.Described column information can be also row title (also referred to as field name), such as field shown in Figure 4 " date of operation ", " cash register source " etc.In the present embodiment, the row chosen of user are retained to get off to show; Unselected row just are filtered, and do not show, as shown in Figure 5.Should recognize, can adopt opposite configuration, that is, the row that the user chooses are filtered, and do not show; Unchecked row just remain and show.
In step S57, the row filter module of the data screening system of client is divided into the several rows set with the row of select column, according to the user, the selection of row set is filtered out the row of correspondence, and again show the described corresponding row data afterwards that are filtered in the mode of ranks.With reference to figure 6, the user is at " date of operation " row when operating, and the row filter module is divided into " 2012-03-01 " and " 2012-03-02 " these two row sets according to the capable content of these row with the row of this select column.After the user chose certain row set, this row set is corresponding was about to be retained to show; Not selected row set is corresponding is about to be hidden (being filtered).Should recognize, can adopt opposite configuration, that is, row corresponding to the row set of choosing is hidden (being filtered), and row corresponding to unchecked row set is shown.
Should recognize, the order of above-mentioned steps S55 and S57 can be changed.That is, the user can first filter row, then row are filtered.Alternatively, the user can only filter (that is, an execution in step S57 is without execution in step S55) to row, perhaps only row is filtered (that is, an execution in step S55 is without execution in step S57).
It is to be further appreciated that in flow process shown in Figure 3 after step S55, can have the step of recovering to filter row.In the step of recover filtering row, the part rows that the user can recovering step S55 filters out or whole row, and again show data after recovering.
Similarly, after step S57, can have the step of recovering to filter row.In the step of recover filtering row, the partial row that the user can recovering step S57 filters out or whole row, and again show data after recovering.
For user-friendly, the data screening system has the forms drafting module and is connected with column filter module, row filter module.The forms drafting module creates the first forms and screens the entrance of module, row filter module in order to display column.For example, in Fig. 4, " searching row " is the entrance of row filter module, and " selecting row " is the entrance of column filter module.
When the user has selected " select row " entrance, when carrying out the column filter operation, the forms drafting module is also drawn the second forms, is used for display column information, with reference to figure 5.As shown in Figure 5, the second forms are all fields of this form, and acquiescence is all chosen, and expression all shows.Only need cancel when you need to hide a certain row or multiple row and choose corresponding row to get final product, but must guarantee that the rarest one is (can control by the JavaScript code) chosen.
Similarly, the user selects " searching item " entrance, and when carrying out the row filter operation, the forms drafting module is also drawn the 3rd forms, is used for the display line set, with reference to figure 6.When you need to filter out the data of a certain class, only need to click the gauge outfit of corresponding these row, then click " searching item ", the screening module is obtained all visual datas of this permutation, then these data are gone re-treatment, obtain the several rows set, this row set shows at the 3rd forms, as shown in Figure 6.
If the user selects " 2012/3/6 ", not for the data on this date all are filtered, only show the corresponding data of choosing the date during " date of operation " is listed as.Preferably, can select simultaneously two or more row sets.For example, the user selects " 2012/3/3 " and " 2012/3/6 " simultaneously, and in " date of operation ", " 2012/3/3 " and " 2012/3/6 " will continue to show that the data on other dates will be filtered.
Preferably, can select simultaneously the row set of two row or multiple row, to realize multi-filtering.For example, after selecting " date of operation " to be the data of " 2012/3/6 ", click in " cash register source ", select " consumption ", just can obtain in current all visual datas " date of operation " is " 2012/3/6 " and " the cash register source " be the data of " consumption ", pastly gets off to realize multi-filtering with this type of.If need all data are all displayed, only need to click the gauge outfit of any row, select " showing all ", all data all are reduced demonstration.
Data screening method of the present invention just can be carried out in client, does not take any resource of server, alleviates the burden of server, and has advantages of fast response time.In addition, client can web browser, and therefore, JavaScript script, CSS file, html tag that can Application standard realize, any browser can compatibility operation.
For the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. Database Systems, but comprise the server and client side that communication connects; Described client has receiver module and display module, and described receiver module is used for receiving the data that described server returns, and described display module is used for showing described data in the mode of ranks; It is characterized in that, described client also comprises the data screening system that is connected with described display module, and described data screening system comprises:
The column filter module, described column filter module is used for obtaining the column information of described data, and the selection of column information is filtered out the row of correspondence according to the user;
Described display module shows the described corresponding row data afterwards that filter out in the mode of ranks.
2. Database Systems as claimed in claim 1, is characterized in that, described data screening module also comprises the row filter module, and described row filter module is used for the row of select column is divided into the several rows set, and the selection of row set is filtered out the row of correspondence according to the user;
Described display module shows the described corresponding row data afterwards that filter out in the mode of ranks.
3. Database Systems as claimed in claim 2, described client is web browser.
4. Database Systems as claimed in claim 3, it is characterized in that, described data screening module also comprises the forms drafting module, described forms drafting module is connected with described column filter module, row filter module, is used for creating the first forms in order to show the entrance of described column filter module, row filter module.
5. Database Systems as claimed in claim 4, is characterized in that, described forms drafting module is also drawn the second forms, the 3rd forms, is respectively used to show described column information, described row set.
6. data screening method is included in data that the client server returns and shows described data with the mode of ranks, it is characterized in that, described data screening method also comprises:
Obtain the column information of described data in described client, and the selection of column information is filtered out the row of correspondence according to the user;
Again show described data after filtering out corresponding row in the mode of ranks in described client.
7. data screening method as claimed in claim 6, is characterized in that, described data screening method also comprises:
In described client, the row of select column is divided into the several rows set, and according to the user, the selection of row set is filtered out corresponding row;
Again show described data after filtering out corresponding row in the mode of ranks in described client.
8. data screening method as claimed in claim 7, is characterized in that, described client is web browser.
9. data screening method as claimed in claim 8, is characterized in that, described data screening method also comprises: draw the first forms in described client, and provide access to guide the user area to filter out the row of corresponding row, correspondence at described the first forms.
10. require 10 described data screening methods as claim, it is characterized in that, described data screening method also comprises: draw the second forms and the 3rd forms in described client, be respectively used to show described column information and described row set.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310073552.0A CN103150370B (en) | 2013-03-07 | 2013-03-07 | Database system and data sieving method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310073552.0A CN103150370B (en) | 2013-03-07 | 2013-03-07 | Database system and data sieving method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103150370A true CN103150370A (en) | 2013-06-12 |
| CN103150370B CN103150370B (en) | 2014-07-02 |
Family
ID=48548447
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310073552.0A Active CN103150370B (en) | 2013-03-07 | 2013-03-07 | Database system and data sieving method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103150370B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103455556A (en) * | 2013-08-08 | 2013-12-18 | 成都市欧冠信息技术有限责任公司 | Intelligent storage unit data clipping process |
| CN105354698A (en) * | 2015-10-28 | 2016-02-24 | 无锡澳优汇国际贸易有限公司 | Enterprise business data tracking and processing system |
| CN106776513A (en) * | 2016-12-09 | 2017-05-31 | 深圳市小满科技有限公司 | A kind of processing system of web page form, processing method and terminal device |
| CN107423072A (en) * | 2017-08-11 | 2017-12-01 | 郑州云海信息技术有限公司 | The method and apparatus of web page dynamic column filter and search list data |
| CN107766390A (en) * | 2016-08-23 | 2018-03-06 | 平安科技（深圳）有限公司 | The processing method and webpage report server of webpage form |
| CN107797977A (en) * | 2016-09-07 | 2018-03-13 | 平安科技（深圳）有限公司 | The display processing method and webpage report server of form |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093512A (en) * | 2007-08-14 | 2007-12-26 | 金蝶软件（中国）有限公司 | Data filtering method and data filtering system |
| CN101556670A (en) * | 2008-04-09 | 2009-10-14 | 深圳市盈圆软件股份有限公司 | System and method for inquiring real-time objective enterprise information |
| CN102289477A (en) * | 2011-07-29 | 2011-12-21 | 深圳市五巨科技有限公司 | Method and device for screening page data of mobile terminal |
-
2013
- 2013-03-07 CN CN201310073552.0A patent/CN103150370B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093512A (en) * | 2007-08-14 | 2007-12-26 | 金蝶软件（中国）有限公司 | Data filtering method and data filtering system |
| CN101556670A (en) * | 2008-04-09 | 2009-10-14 | 深圳市盈圆软件股份有限公司 | System and method for inquiring real-time objective enterprise information |
| CN102289477A (en) * | 2011-07-29 | 2011-12-21 | 深圳市五巨科技有限公司 | Method and device for screening page data of mobile terminal |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103455556A (en) * | 2013-08-08 | 2013-12-18 | 成都市欧冠信息技术有限责任公司 | Intelligent storage unit data clipping process |
| CN103455556B (en) * | 2013-08-08 | 2017-06-23 | 成都市欧冠信息技术有限责任公司 | Memory cell data method of cutting out |
| CN105354698A (en) * | 2015-10-28 | 2016-02-24 | 无锡澳优汇国际贸易有限公司 | Enterprise business data tracking and processing system |
| CN107766390A (en) * | 2016-08-23 | 2018-03-06 | 平安科技（深圳）有限公司 | The processing method and webpage report server of webpage form |
| CN107797977A (en) * | 2016-09-07 | 2018-03-13 | 平安科技（深圳）有限公司 | The display processing method and webpage report server of form |
| CN106776513A (en) * | 2016-12-09 | 2017-05-31 | 深圳市小满科技有限公司 | A kind of processing system of web page form, processing method and terminal device |
| CN107423072A (en) * | 2017-08-11 | 2017-12-01 | 郑州云海信息技术有限公司 | The method and apparatus of web page dynamic column filter and search list data |
| CN107423072B (en) * | 2017-08-11 | 2020-10-30 | 苏州浪潮智能科技有限公司 | Method and device for screening dynamic columns of web page and searching table data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103150370B (en) | 2014-07-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103150370B (en) | Database system and data sieving method thereof | |
| US10726063B2 (en) | Topic profile query creation | |
| EP2987088B1 (en) | Client side page processing | |
| US20150073866A1 (en) | Data visualization and user interface for monitoring resource allocation to customers | |
| US20100115446A1 (en) | Segmentation model user interface | |
| CN105989082B (en) | Tabular views generation method and device | |
| US20150033184A1 (en) | Method and apparatus for executing application in electronic device | |
| US8458157B2 (en) | System and method of filtering search results | |
| US20100131899A1 (en) | Scannable Cloud | |
| US8688502B2 (en) | Business intelligence dashboards for performance analysis | |
| CN105868096B (en) | For showing the method, device and equipment of web page test result in a browser | |
| DE112017001416T5 (en) | User interface element to display similar results | |
| CN102866785A (en) | Text input method, system and device | |
| CN103123648A (en) | Presentation of rich search results in delineated areas | |
| US10210150B2 (en) | Grid-based user interface system | |
| US20210232273A1 (en) | Personalized graphical user interface displays | |
| CN103164423A (en) | Method and device for confirming browser inner core type rendering web pages | |
| US20110197133A1 (en) | Methods and apparatuses for identifying and monitoring information in electronic documents over a network | |
| US20120144328A1 (en) | Symbolic tree node selector | |
| CN109471974A (en) | Filter method, apparatus, electronic equipment and the storage medium of third party's web advertisement | |
| WO2017018904A1 (en) | Bi cloud services data modeling denormalized table introspection algorithm | |
| CN108304118B (en) | Screenshot method and device | |
| CN105631008B (en) | Webpage display method and system | |
| CN105988699A (en) | Method and device for displaying information on terminal screen | |
| US9229617B2 (en) | Software user interface using H-grid navigation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: SHENZHEN CHUANGYUAN TECHNOLOGY DEVELOPMENT CO., LT Free format text: FORMER OWNER: HUANG XIAOHUI Effective date: 20140922 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 518030 SHENZHEN, GUANGDONG PROVINCE TO: 518000 SHENZHEN, GUANGDONG PROVINCE |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20140922 Address after: 518000 room 3609, Rong Chao economic and Trade Center, 4028 Jintian Road, Shenzhen, Guangdong, Futian District Patentee after: Shenzhen Chuang Yuan Technology Development Co., Ltd. Address before: 518030 Guangdong city of Shenzhen province Futian District Jintian road Rongchao trade center room 3609 Patentee before: Huang Xiaohui |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20190411 Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee after: Shenzhen guide Agel Ecommerce Ltd Address before: Room 3609, Rongchao Economic and Trade Center, 4028 Jintian Road, Futian District, Shenzhen City, Guangdong Province Patentee before: Shenzhen Chuang Yuan Technology Development Co., Ltd. |
|
| TR01 | Transfer of patent right | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee after: Shenzhen daoguimei Information Technology Co.,Ltd. Address before: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee before: SHENZHEN YINDAOMEI E-COMMERCE Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder |