CN101964816A - Method and system for browsing data in browser/server (B/S) framework software system - Google Patents
Method and system for browsing data in browser/server (B/S) framework software system Download PDFInfo
- Publication number
- CN101964816A CN101964816A CN2010102920166A CN201010292016A CN101964816A CN 101964816 A CN101964816 A CN 101964816A CN 2010102920166 A CN2010102920166 A CN 2010102920166A CN 201010292016 A CN201010292016 A CN 201010292016A CN 101964816 A CN101964816 A CN 101964816A
- Authority
- CN
- China
- Prior art keywords
- data
- data volume
- file
- threshold value
- browsing
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for browsing data in a browser/server (B/S) framework software system. The method comprises the following steps of: 102, configuring a data volume threshold value; and 104, when a browsed data volume is more than the data volume threshold value, storing the data in the form of file for a user to browse. The invention also provides a system for browsing data in the browser/server (B/S) framework software system. The system comprises a threshold value configuration unit for configuring the data volume threshold value, a judging unit for judging whether the data volume to be browsed is more than the data volume threshold value or not and a storage unit for storing the data in the form of file for the user to browse when the data volume to be browsed is more than the data volume threshold value. According to the technical scheme of the invention, the method and the system have the advantages of meeting the service management requirement of an enterprise, occupying the minimum network resource, effectively utilizing client resources, improving large data volume browsing efficiency, enhancing the subsequent processing convenience of a large data volume inquiry result and the like.
Description
Technical field
The present invention relates to the browsing data technology, relate in particular to the method and system of browsing data in B/S framework software systems.
Background technology
Current corporate client is for requirements such as service set processing, data in real time collection, business datum centralized management, data warehouse, BI, when buying enterprise applied information system, be more prone to purchase B/S (Browser/server, browser/server) framework applications information system.
The current network condition is relatively better, and the B/S system can satisfy fully to the requirement of network.For large-scale conglomerate, current major part all continues buying B/S architecture system and replaces C/S (Client/Server, the client/server) architecture system that uses early stage.
Often relate to the application that historical business datum is browsed in the information system, and also can relate in the inquiry designated period of time whole related service data when enterprises audit and business statistics and carry out the statistics and the processing of off-line type.
For large-scale conglomerate, every day, a concrete professional data volume that produces will reach tens thousand of data-base recordings, for business need (as the audit, business statistics, fuzzy query etc.), the business personnel needs the disposable lot of data (as surpassing 20000 records) that inquires, but the UI that Query Result provides in application system is (User Interface, user interface) end can not be checked well, statistical analysis, off-line data processing etc., therefore the result data that inquires of business personnel usually needs to derive the EXCEL file to local, carries out subsequent treatment again.And business datum Query Result major part represents with table format, and EXCEL is provided by the response function that provides of application system head and shoulders above such as the ease for use, function of list data.And most business personnels compare skilled to the use of EXCEL instrument even are proficient in, so the business personnel is more prone to use the EXCEL instrument to carry out data processing.
So the lot of data inquiry had both expended limited Internet resources in real time, just can check owing to Query Result must be cached to client (usually needing total data is cached in the client internal memory) simultaneously.Because client hardware performance limited (especially memory size is limited), machine, internal memory overflow, Query Result shows needs the long period etc. so cause FTP client FTP to delay easily.
Also there is another problem in the big data quantity inquiry: the application system client situation that network interrupts or the FTP client FTP appearance is unusual can not occur when receiving the Query Result data, because this type of must cause this inquiry all to be interrupted unusually, the Query Result data can not realize current network file transfer functions such as breakpoint transmission commonly used.
Therefore, need a kind of in B/S framework software systems the mode of browsing data, can separate must not be when satisfying the business event managerial demand, reaches minimally and take Internet resources, effectively utilize client resource, improve the big data quantity browse efficiency, improve the problem of the performances such as convenience of big data quantity Query Result subsequent treatment.
Summary of the invention
In view of more than, one of technical scheme of the present invention technical problem to be solved is, realize a kind of in B/S framework software systems the method and system of browsing data, it can be when satisfying the business event managerial demand, reaches minimally and take Internet resources, effectively utilize client resource, improve the big data quantity browse efficiency, improve the performances such as convenience of big data quantity Query Result subsequent treatment.
The invention provides a kind of in B/S framework software systems the method for browsing data, comprising: step S102, amount of configuration data threshold value; And step S104, during greater than described data volume threshold value, be that file is browsed for the user with viewed data volume with described storage.By this technical scheme, realized the method for browsing data in B/S framework software systems, improve the efficient of big data quantity inquiry, reduced to the requirement of client configuration and to the requirement of network performance, efficiently utilize the finite element network resource.
In technique scheme, preferably, in described step S104, described data are converted to EXCEL file and storage.By this technical scheme, needed data are preserved in the mode of EXCEL file, can make the user check data at any time and easily.
In technique scheme, preferably, also comprise: when described storage is file, preserve and described file information corresponding.
In technique scheme, preferably, described information comprises any or its combination in the physical pathway of operation user, querying condition, functional node, data volume, holding time, file and the title.By this technical scheme, can make the user be well understood to the relevant information of data, be convenient to follow-up processed.
In technique scheme, preferably, described data volume threshold value is to determine according to any or its combination in server configuration, network condition, client configuration, application system stability and the efficient.By this technical scheme, the user can come reasonably to determine the data volume that the backstage will be browsed according to the actual conditions of client configuration and network performance.
The present invention also provide a kind of in B/S framework software systems the system of browsing data, comprising: threshold value dispensing unit, amount of configuration data threshold value; And judging unit, whether judge viewed data volume greater than described data volume threshold value; Memory cell during greater than described data volume threshold value, is being that file for user browse with described storage with viewed data volume.By this technical scheme, realized the method for browsing data in B/S framework software systems, improve the efficient of big data quantity inquiry, reduced to the requirement of client configuration and to the requirement of network performance, efficiently utilize the finite element network resource.
In technique scheme, preferably, described file is the EXCEL file.By this technical scheme,, can make the user momentarily and easily check data with needed metadata cache and permanent the preservation.
In technique scheme, preferably, described memory cell also is used for when described storage is file, preserves and described file information corresponding.
In technique scheme, preferably, described information comprises any or its combination in the physical pathway of operation user, querying condition, functional node, data volume, holding time, file and the title.By this technical scheme, can make the user be well understood to the relevant information of data, be convenient to follow-up processed.
In technique scheme, preferably, described data volume threshold value is to determine according to any or its combination in server configuration, network condition, client configuration, application system stability and the efficient.By this technical scheme, the user can come reasonably to determine the data volume that the backstage will be browsed according to the actual conditions of client configuration and network performance.
Pass through technique scheme, can be when satisfying the business event managerial demand, reach minimally and take Internet resources, effectively utilize client resource, improve the big data quantity browse efficiency, improve the performances such as convenience of big data quantity Query Result subsequent treatment.
Description of drawings
Fig. 1 be according to an embodiment of the invention in B/S framework software systems the flow chart of the method for browsing data;
Fig. 2 be according to an embodiment of the invention in B/S framework software systems the block diagram of the system of browsing data; And
Fig. 3 be according to an embodiment of the invention in B/S framework software systems the workflow diagram of the method for browsing data.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with the drawings and specific embodiments.
Set forth a lot of details in the following description so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Fig. 1 be according to an embodiment of the invention in B/S framework software systems the flow chart of the method for browsing data.As shown in Figure 1, the method for browsing data in B/S framework software systems comprises: step S102, amount of configuration data threshold value according to an embodiment of the invention; And step S104, during greater than described data volume threshold value, be that file is browsed for the user with viewed data volume with described storage.By such technical scheme, realized the method for browsing data in B/S framework software systems, improve the efficient of big data quantity inquiry, reduced to the requirement of client configuration and to the requirement of network performance, efficiently utilize the finite element network resource.
In technique scheme, in described step S104, described data are converted to EXCEL file and storage.Like this, needed data are preserved with the EXCEL file, just can make the user check data at any time and easily.
In technique scheme, also comprise: when described storage is file, preserve and described file information corresponding.
In technique scheme, described information comprises any or its combination in the physical pathway of operation user, querying condition, functional node, data volume, holding time, file and the title.Therefore, can make the user be well understood to the relevant information of data, be convenient to follow-up processed.
In technique scheme, described data volume threshold value is to determine according to any or its combination in server configuration, network condition, client configuration, application system stability and the efficient.Like this, the user just can come reasonably to determine the data volume that the backstage will be browsed according to the actual conditions of client configuration and network performance.
Pass through technique scheme, can be when satisfying the business event managerial demand, reach minimally and take Internet resources, effectively utilize client resource, improve the big data quantity browse efficiency, improve the performances such as convenience of big data quantity Query Result subsequent treatment.
Fig. 2 be according to an embodiment of the invention in B/S framework software systems the block diagram of the system of browsing data.As shown in Figure 2, the system 200 of browsing data comprises in B/S framework software systems according to an embodiment of the invention: threshold value dispensing unit 202, amount of configuration data threshold value; And judging unit 204, whether judge viewed data volume greater than described data volume threshold value; Memory cell 206 during greater than described data volume threshold value, is being that file for user browse with described storage with viewed data volume.By such technical scheme, realized the method for browsing data in B/S framework software systems, improve the efficient of big data quantity inquiry, reduced to the requirement of client configuration and to the requirement of network performance, efficiently utilize the finite element network resource.
In technique scheme, described file is the EXCEL file.Therefore, with needed metadata cache and permanent the preservation, can make the user momentarily and easily check data.
In technique scheme, described memory cell 206 also is used for when described storage is file, preserves and described file information corresponding.
In technique scheme, described information comprises any or its combination in the physical pathway of operation user, querying condition, functional node, data volume, holding time, file and the title.Like this, can make the user be well understood to the relevant information of data, be convenient to follow-up processed.
In technique scheme, described data volume threshold value is to determine according to any or its combination in server configuration, network condition, client configuration, application system stability and the efficient.Like this, the user can come reasonably to determine the data volume that the backstage will be browsed according to the actual conditions of client configuration and network performance.
Pass through technique scheme, can be when satisfying the business event managerial demand, reach minimally and take Internet resources, effectively utilize client resource, improve the big data quantity browse efficiency, improve the performances such as convenience of big data quantity Query Result subsequent treatment.
Fig. 3 be according to an embodiment of the invention in B/S framework software systems the workflow diagram of the method for browsing data.Proposed the solution that a kind of B/S framework information system big data quantity is browsed in the embodiments of figure 3, mainly comprised: configuration threshold values, Query Result monitoring, derivation EXCEL file and relevant information data library storage, the setting of Query Result authority, Query Result distribution, Query Result information browse, Query Result are downloaded.Describe work disposal flow process according to an embodiment of the invention in detail below in conjunction with Fig. 3.
Function 1: configured threshold
Amount of configuration data threshold value 302.The threshold value here is meant that the Query Result data volume reaches certain numerical value, reach this numerical value after system automatically Query Result is converted to the EXCEL file.The purpose of amount of configuration data threshold value is to browse the critical value that preserve automatically on the backstage in order to allow the client require to be provided with suitable big data quantity according to current server configuration, network condition, client configuration, application system stability and efficient.Threshold value can be provided with according to concrete function application node, also can be provided with according to the corresponding data master meter of inquiry, and system default provides a unified threshold values (as 5000), and client's application can be revised default value and be applied to the overall situation.
Function 2: data read is monitor service as a result
Carry out service inquiry 304.Because the client of B/S framework applications information system all needs to carry out data interaction by application server and database service, and application server all needs to provide WEB service (as Microsoft IIS, IBM WebSphere, Weblogic etc.) and database manipulation serviced component.B/S framework applications information system all can design unified data manipulation backstage serviced component 306 simultaneously, be used for management database connection, the conversion of SQL script, result set preliminary treatment etc., therefore, client must be by unified database service assembly passage to the all-access of database.
Data query monitor service assembly 306 can integrate with the database service assembly of application server deploy, the data result collection that the server of database 308 returns after the automatic monitor client submission data query condition, when result set during greater than the threshold values set, this serviced component 306 directly calls Query Result and is converted to EXCEL assembly 312 and handles, and returns the client process object information.
Function 3: derive EXCEL file and relevant information data library storage function
Providing of this function avoided each functional module of application system to organize EXCEL form and data to derive again voluntarily, and the form (as document template, report form template, printing template etc.) and the Data transmission query results that only need the delivery applications system data to show get final product.This serviced component does not need application module to call, and the assembly of being described by function 2 calls and gets final product.Can follow according to data display format, data processing formula, the data statistics submitted to require, data transaction company etc., generate satisfactory EXCEL template, and fill result set.EXCEL file after finishing is saved on the server physical hard disk automatically, and the EXCEL fileinfo that generates this result set and correspondence simultaneously is saved in the database, returns information after action is finished and gives client.
Function 4: Query Result information browse, distribution, download
When preserving the EXCEL file, also can be saved in the relevant information of this file correspondence in the Service Database, as the physical pathway of operation user, querying condition, functional node, data bulk, holding time, EXCEL file and title etc.Simultaneously the EXCEL file purpose of preserving comprises: download to client and carry out the processing of statistical analysis and service needed, be distributed to other business personnels and be used to share.This function is promptly: provide inquiry whole EXCEL fileinfos, the EXCEL that distribute own storage give the client that needs, download oneself need the EXCEL file.
Function 5:FTP downloads
The EXCEL file that system preserves can use general FTP instrument to download, but the uncontrollable file of application system is downloaded authority.Therefore, in order to download authority by control documents, application system provides the FTP download tool voluntarily.When the operator browsed the EXCEL file, whether had permission download, if permission download is arranged, can directly download if can directly browse to the current operation of each destination file user.File the FTP instrument that directly provides by application system is provided is carried out, and supports breakpoint transmission.
Pass through technique scheme, can be when satisfying the business event managerial demand, reach minimally and take Internet resources, effectively utilize client resource, improve the big data quantity browse efficiency, improve the performances such as convenience of big data quantity Query Result subsequent treatment.
More than, with reference to the accompanying drawings embodiments of the invention are described in detail.Technical scheme is inquired about the mechanism that a kind of Query Result buffer memory is provided and can have forever preserved for the big quantity of B/S framework information system according to an embodiment of the invention, can effectively improve the efficient of big quantity inquiry, and reduced the requirement of big quantity inquiry to client configuration, and reduced the requirement of big data quantity inquiry, thereby utilize the finite element network resource more efficiently to network performance.
Big quantity Query Result is browsed and subsequent treatment by the EXCEL instrument, has improved convenience and universal.Also promoted the efficient and the stability of B/S framework information system, the guarantee information system can handle real time business more efficiently.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the method for a browsing data in B/S framework software systems is characterized in that, comprising:
Step S102, the amount of configuration data threshold value; And
Step S104 during greater than described data volume threshold value, is being that file for user browse with described storage with viewed data volume.
2. method according to claim 1 is characterized in that, in described step S104, described data is converted to EXCEL file and storage.
3. method according to claim 1 and 2 is characterized in that, also comprises: when described storage is file, preserve and described file information corresponding.
4. method according to claim 3 is characterized in that, described information comprises any or its combination in the physical pathway of operation user, querying condition, functional node, data volume, holding time, file and the title.
5. method according to claim 1 and 2 is characterized in that, described data volume threshold value is to determine according to any or its combination in server configuration, network condition, client configuration, application system stability and the efficient.
6. the system of a browsing data in B/S framework software systems is characterized in that, comprising:
The threshold value dispensing unit, the amount of configuration data threshold value; And
Whether judging unit is judged viewed data volume greater than described data volume threshold value;
Memory cell during greater than described data volume threshold value, is being that file for user browse with described storage with viewed data volume.
7. system according to claim 6 is characterized in that, described file is the EXCEL file.
8. according to claim 6 or 7 described systems, it is characterized in that described memory cell also is used for when described storage is file, preserve and described file information corresponding.
9. system according to claim 8 is characterized in that, described information comprises any or its combination in the physical pathway of operation user, querying condition, functional node, data volume, holding time, file and the title.
10. according to claim 6 or 7 described systems, it is characterized in that described data volume threshold value is to determine according to any or its combination in server configuration, network condition, client configuration, application system stability and the efficient.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102920166A CN101964816A (en) | 2010-09-26 | 2010-09-26 | Method and system for browsing data in browser/server (B/S) framework software system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102920166A CN101964816A (en) | 2010-09-26 | 2010-09-26 | Method and system for browsing data in browser/server (B/S) framework software system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101964816A true CN101964816A (en) | 2011-02-02 |
Family
ID=43517546
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102920166A Pending CN101964816A (en) | 2010-09-26 | 2010-09-26 | Method and system for browsing data in browser/server (B/S) framework software system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101964816A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105827541A (en) * | 2016-04-06 | 2016-08-03 | 中国建设银行股份有限公司 | Data message processing method and system for online trade |
| CN106570030A (en) * | 2015-10-12 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Calculation method and device based on big data |
| CN109343803A (en) * | 2018-09-19 | 2019-02-15 | 益萃网络科技（中国）有限公司 | Print from the definition method, apparatus, computer equipment and storage medium |
| WO2019141134A1 (en) * | 2018-01-19 | 2019-07-25 | 阿里巴巴集团控股有限公司 | Data query method, apparatus and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1194413A (en) * | 1997-03-26 | 1998-09-30 | 国际商业机器公司 | Method and apparatus for pre high speed buffer store data on service device |
| CN1783804A (en) * | 2004-12-01 | 2006-06-07 | 华为技术有限公司 | Realtime updating method for net page data |
| US7319485B2 (en) * | 2003-03-21 | 2008-01-15 | Hewlett-Packard Development Company, L.P. | Apparatus and method for recording data in a circular fashion |
| CN101477558A (en) * | 2009-01-15 | 2009-07-08 | 腾讯科技（深圳）有限公司 | Browser label management method and multi-page browsing system |
| CN101834828A (en) * | 2009-03-13 | 2010-09-15 | 北京启明星辰信息技术股份有限公司 | Management control end system and transmission method for security events therein |
-
2010
- 2010-09-26 CN CN2010102920166A patent/CN101964816A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1194413A (en) * | 1997-03-26 | 1998-09-30 | 国际商业机器公司 | Method and apparatus for pre high speed buffer store data on service device |
| US7319485B2 (en) * | 2003-03-21 | 2008-01-15 | Hewlett-Packard Development Company, L.P. | Apparatus and method for recording data in a circular fashion |
| CN1783804A (en) * | 2004-12-01 | 2006-06-07 | 华为技术有限公司 | Realtime updating method for net page data |
| CN101477558A (en) * | 2009-01-15 | 2009-07-08 | 腾讯科技（深圳）有限公司 | Browser label management method and multi-page browsing system |
| CN101834828A (en) * | 2009-03-13 | 2010-09-15 | 北京启明星辰信息技术股份有限公司 | Management control end system and transmission method for security events therein |
Non-Patent Citations (1)
| Title |
|---|
| 阚洪亮，等: "基于B/S模式的海量数据报表的实现", 《科技广场》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106570030A (en) * | 2015-10-12 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Calculation method and device based on big data |
| CN105827541A (en) * | 2016-04-06 | 2016-08-03 | 中国建设银行股份有限公司 | Data message processing method and system for online trade |
| WO2019141134A1 (en) * | 2018-01-19 | 2019-07-25 | 阿里巴巴集团控股有限公司 | Data query method, apparatus and device |
| US11734271B2 (en) | 2018-01-19 | 2023-08-22 | Alibaba Group Holding Limited | Data query method, apparatus and device |
| CN109343803A (en) * | 2018-09-19 | 2019-02-15 | 益萃网络科技（中国）有限公司 | Print from the definition method, apparatus, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109643312B (en) | Hosted query service | |
| CN101645022B (en) | Work scheduling management system and method for a plurality of colonies | |
| CN101166118B (en) | A method for processing user configuration information and service report system | |
| CN112148679A (en) | Data interaction method, system, device and storage medium based on multiple data platforms | |
| CN101853287A (en) | Data compression quick retrieval file system and method thereof | |
| CN104573065A (en) | Report display engine based on metadata | |
| CN104090901A (en) | Method, device and server for processing data | |
| CN112364223A (en) | Digital archive system | |
| CN101873334A (en) | State-driven executable service flow execution method | |
| CN109241384A (en) | A kind of method for visualizing and device of scientific research information | |
| CN104239543A (en) | Life service searching platform based on mobile internet technology | |
| US9870542B2 (en) | Managing information technology solution centers | |
| CN101964816A (en) | Method and system for browsing data in browser/server (B/S) framework software system | |
| CN100534084C (en) | Long-distance XML data updating method and system | |
| CN103235727B (en) | Local dynamic station list engine apparatus, system and method | |
| Sreemathy et al. | Data integration and ETL: a theoretical perspective | |
| CN101576922A (en) | Access system and access method | |
| US20150310390A1 (en) | Aggregation and workflow engines for managing project information | |
| CN108696559B (en) | Stream processing method and device | |
| CN110019440B (en) | Data processing method and device | |
| CN100395752C (en) | Report data collection system and method | |
| EP1556762A2 (en) | Hierarchical repository for configuration-related and performance-related information related to computerized systems | |
| KR20010060617A (en) | Report generation and access device and method in network management system | |
| JP5351746B2 (en) | Data processing apparatus and method | |
| CN104731785A (en) | Information searching method and device |
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 |
Application publication date: 20110202 |