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 PDF

Info

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
file
system
data volume
threshold
Prior art date
Application number
CN2010102920166A
Other languages
Chinese (zh)
Inventor
刘东成
Original Assignee
用友软件股份有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 用友软件股份有限公司 filed Critical 用友软件股份有限公司
Priority to CN2010102920166A priority Critical patent/CN101964816A/en
Publication of CN101964816A publication Critical patent/CN101964816A/en

Links

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

在B/S架构软件系统中浏览数据的方法和系统 The method of browsing data in the B / S system architecture and software system

技术领域 FIELD

[0001] 本发明涉及数据浏览技术,尤其涉及在B/S架构软件系统中浏览数据的方法和系统。 [0001] The present invention relates to data browsing technology, particularly to a method and system for browsing data in the B / S architecture software system.

背景技术 Background technique

[0002] 当前企业客户出于业务集中处理、数据实时收集、业务数据集中管理、数据仓库、 BI等要求,在采购企业应用信息系统时更倾向于采购B/S (Browser/server,浏览器/服务器)架构应用信息系统。 [0002] For the current business focus on corporate customers, real-time data collection, centralized business data management, data warehousing, BI, etc., are more inclined to purchase B / S (Browser / server, the browser in the procurement of enterprise information systems application / server) application of information systems architecture.

[0003] 当前网络条件已经比较良好,B/S系统对网络的要求完全可以满足。 [0003] The current network conditions are relatively good, B / S system can meet the requirements of the network. 对于大型集团企业,当前大部分都持续采购B/S架构系统替换掉前期使用的C/S (Client/Server,客户机/服务器)架构系统。 For large conglomerates, most of them continue to purchase the current B / S-based systems to replace the C / S pre-used (Client / Server, Client / Server) architecture system.

[0004] 信息系统中经常涉及到历史业务数据浏览的应用,而且企业内部审计和业务统计时也会涉及到查询指定时期内全部相关业务数据进行离线式的统计和处理。 [0004] Information systems often involve historical business data browsing application, and will involve all relevant business data queries within a specified period to be off-line processing of statistics and internal audit and business statistics.

[0005] 对于大型集团企业,每天一个具体业务产生的数据量就会达到数万条数据库记录,出于业务要求(如审计、业务统计、模糊查询等),业务人员需要一次性查询出大量的数据(如超过20000条记录),但是查询结果在应用系统提供的UI (User Interface,用户界面)端并不能很好地进行审阅、统计分析、数据离线加工等,因此业务人员查询到的结果数据常常需要导出EXCEL文件到本地,再进行后续处理。 [0005] For large conglomerates, the amount of data generated each day a specific business will reach tens of thousands of database records, for business requirements (such as auditing, business statistics, fuzzy queries, etc.), business people need a large number of one-time query data (e.g., more than 20,000 records), but the query results are not well performed in the review provided by UI application system (user interface, UI) side, statistical analysis, off-line data processing, so the service staff query result data EXCEL often need to export the file to a local, before subsequent handling. 而且,业务数据查询结果大部分以表格格式展现,EXCEL处理表格数据的易用性、功能等远远超出应用系统提供的响应功能。 Moreover, the majority of business data query results are presented in a table format, EXCEL spreadsheet data processing ease of use, functionality and other functional applications far beyond the response provided by the system. 并且,绝大部分业务人员对EXCEL工具的使用都比较熟练甚至精通,所以业务人员更倾向于使用EXCEL工具来进行数据处理。 Moreover, the vast majority of business people to use EXCEL tools are more skilled or even proficient, so business people prefer to use EXCEL tool for data processing.

[0006] 如此大量的数据查询既实时耗费有限的网络资源,同时由于查询结果必须要缓存到客户端(常常需要把全部数据缓存到客户端内存内)才能进行审阅。 [0006] such a large amount of data query both real-time cost limited network resources, and because the results must be cached to the client (often required to cache all the data into the client memory) can be reviewed. 由于客户端硬件性能有限(尤其内存容量有限),所以容易造成客户端系统宕机、内存溢出、查询结果显示需要较长时间等。 Due to limited client hardware performance (especially the limited memory capacity), it is likely to cause the client system downtime, memory overflow, the query results show takes a long time.

[0007] 大数据量查询还存在另一问题:应用系统客户端接收查询结果数据时不能出现网络中断或客户端系统出现异常的情况,因为此类异常必然导致本次查询全部中断,查询结果数据不能实现当前常用的断点续传等网络文件传输功能。 The network interruption or abnormal client system can not occur when the application system client receives the query results data, because such exceptions inevitably lead to all the disruption this query, the query results data: [0007] a large amount of data query there is another problem We can not achieve the current common HTTP and other network file transfer capabilities.

[0008] 因此,需要一种在B/S架构软件系统中浏览数据的方式,能够解决不能在满足企业业务管理需要的同时,达到最低限度地占用网络资源、有效地利用客户端资源、提高大数据量浏览效率、提高大数据量查询结果后续处理的方便性等性能的问题。 [0008] Therefore, a way to browse the data in the B / S structure software systems, can not be solved at the same time meet the needs of enterprise business management to achieve minimally network resources, effective use of client resources, improve large the amount of data browsing efficiency, improve performance issues such as the convenience of a large amount of data query results for subsequent processing.

发明内容 SUMMARY

[0009] 鉴于以上,本发明的技术方案所要解决的技术问题之一在于,实现一种在B/S架构软件系统中浏览数据的方法和系统,其能够在满足企业业务管理需要的同时,达到最低限度地占用网络资源、有效地利用客户端资源、提高大数据量浏览效率、提高大数据量查询结果后续处理的方便性等性能。 [0009] In view of the foregoing, one aspect of the present invention to solve the technical problem is to realize a method and a system for browsing the data in the B / S architecture software system, which is capable to meet the business needs of the business management, to reach minimally network resources, effective use of client resources and improve the efficiency of large amounts of data browsing, and other properties to improve the ease of a large amount of data query results for subsequent processing.

[0010] 本发明提供了一种在B/S架构软件系统中浏览数据的方法,包括:步骤S102,配置数据量阈值;以及步骤S104,在将被浏览的数据量大于所述数据量阈值时,将所述数据存储为文件供用户浏览。 When and step S104, to be browsed data is larger than the data amount threshold; step S102, the configuration data amount threshold: [0010] The present invention provides a method of browsing data in the B / S architecture software system, comprising , the data stored as a file for users to browse. 通过该技术方案,实现了在B/S架构软件系统中浏览数据的方法,提高大数据量查询的效率,降低了对客户端配置的要求及对网络性能的要求,高效利用有限网络资源。 By this solution, to achieve a method of browsing data in the B / S architecture software system, large amounts of data query efficiency, reducing the requirements of the client and the configuration of the network performance requirements, efficient use of limited network resources.

[0011 ] 在上述技术方案中,优选地,在所述步骤S104中,将所述数据转换为EXCEL文件并存储。 [0011] In the above aspect, preferably, in the step S104, the data is converted into EXCEL file and store. 通过该技术方案,将所需要的数据以EXCEL文件的方式保存起来,可以使用户随时且方便地查看数据。 With this technical solution, the required data in a manner EXCEL file saved, at any time and allows the user to easily view the data.

[0012] 在上述技术方案中,优选地,还包括:在将所述数据存储为文件的同时,保存与所述文件相对应的信息。 [0012] In the above aspect, preferably, further comprising: storing the data in a file at the same time, saving the information corresponding to the file.

[0013] 在上述技术方案中,优选地,所述信息包括操作用户、查询条件、功能节点、数据量、保存时间、文件的物理路径以及名称中的任一种或其组合。 [0013] In the above aspect, preferably, the information includes a user operation, query, function nodes, data volume, storage time, the physical path, and any one or combination of the name of the file. 通过该技术方案,可以使用户清楚地了解数据的相关信息,便于后续的加工处理。 By this solution, the user can clearly understand that the information data to facilitate subsequent processing.

[0014] 在上述技术方案中,优选地,所述数据量阈值是根据服务器配置、网络条件、客户端配置、应用系统稳定性以及效率中的任一种或其组合来确定的。 [0014] In the above aspect, preferably, the amount of data threshold is based on the server configuration, network conditions, client configuration application system stability and any one or combination of efficiency determined. 通过该技术方案,用户可以根据客户端配置及网络性能的实际情况来合理地确定后台所要浏览的数据量。 By this solution, the user can reasonably determine the amount of background data to be browsed according to the actual client configuration and network performance.

[0015] 本发明还提供了一种在B/S架构软件系统中浏览数据的系统,包括:阈值配置单元,配置数据量阈值;以及判断单元,判断将被浏览的数据量是否大于所述数据量阈值;存储单元,在将被浏览的数据量大于所述数据量阈值时,将所述数据存储为文件供用户浏览。 [0015] The present invention also provides a system for browsing the data in the B / S architecture software system, comprising: a threshold configuration unit, the configuration data amount threshold; and determining means for determining the amount of data to be viewed is larger than the data threshold value; storing unit, to be viewed when the data is larger than the threshold data, the data is stored as a file for users to browse. 通过该技术方案,实现了在B/S架构软件系统中浏览数据的方法,提高大数据量查询的效率,降低了对客户端配置的要求及对网络性能的要求,高效利用有限网络资源。 By this solution, to achieve a method of browsing data in the B / S architecture software system, large amounts of data query efficiency, reducing the requirements of the client and the configuration of the network performance requirements, efficient use of limited network resources.

[0016] 在上述技术方案中,优选地,所述文件为EXCEL文件。 [0016] In the above aspect, preferably, the EXCEL document file. 通过该技术方案,将所需要的数据缓存并永久保存,可以使用户随时地且方便地查看数据。 With this technical solution, the required data is cached and stored permanently, and allows users to easily view data at any time.

[0017] 在上述技术方案中,优选地,所述存储单元还用于在将所述数据存储为文件的同时,保存与所述文件相对应的信息。 [0017] In the above aspect, preferably, the storage unit is further configured to store the data in a file at the same time, saving the information corresponding to the file.

[0018] 在上述技术方案中,优选地,所述信息包括操作用户、查询条件、功能节点、数据量、保存时间、文件的物理路径以及名称中的任一种或其组合。 [0018] In the above aspect, preferably, the information includes a user operation, query, function nodes, data volume, storage time, the physical path, and any one or combination of the name of the file. 通过该技术方案,可以使用户清楚地了解数据的相关信息,便于后续的加工处理。 By this solution, the user can clearly understand that the information data to facilitate subsequent processing.

[0019] 在上述技术方案中,优选地,所述数据量阈值是根据服务器配置、网络条件、客户端配置、应用系统稳定性以及效率中的任一种或其组合来确定的。 [0019] In the above aspect, preferably, the amount of data threshold is based on the server configuration, network conditions, client configuration application system stability and any one or combination of efficiency determined. 通过该技术方案,用户可以根据客户端配置及网络性能的实际情况来合理地确定后台所要浏览的数据量。 By this solution, the user can reasonably determine the amount of background data to be browsed according to the actual client configuration and network performance.

[0020] 通过上述技术方案,能够在满足企业业务管理需要的同时,达到最低限度地占用网络资源、有效地利用客户端资源、提高大数据量浏览效率、提高大数据量查询结果后续处理的方便性等性能。 [0020] Through the above technical solution that can meet the enterprise business management needs, while achieving minimally network resources, effective use of client resources, improve the large amount of data browsing efficiency and facilitate large amount of data query results post-processing and other properties.

附图说明 BRIEF DESCRIPTION

[0021] 图1是根据本发明的一个实施例的在B/S架构软件系统中浏览数据的方法的流程图;[0022] 图2是根据本发明的一个实施例的在B/S架构软件系统中浏览数据的系统的框图;以及 [0021] FIG. 1 is a flowchart of a method of browsing the data in the B / S software system architecture of one embodiment of the present invention; [0022] FIG 2 is an embodiment of the present invention in a B / S architecture software system block diagram of a system of browsing data; and

[0023] 图3是根据本发明的一个实施例的在B/S架构软件系统中浏览数据的方法的工作流程图。 [0023] FIG. 3 is a flow chart of a method according to browse the data in the B / S software system architecture of one embodiment of the present invention. 具体实施方式 Detailed ways

[0024] 为了能够更清楚地理解本发明的上述目的、特征和优点,下面结合附图和具体实施方式对本发明进行进一步的详细描述。 [0024] In order to more clearly understand the present invention the above object, features and advantages, the following specific embodiments and accompanying drawings further detailed description of the invention.

[0025] 在下面的描述中阐述了很多具体细节以便于充分理解本发明,但是,本发明还可以采用其他不同于在此描述的其他方式来实施,因此,本发明并不限于下面公开的具体实施例的限制。 [0025] numerous specific details are set forth in the following description in order to provide a thorough understanding of the present invention, however, the present invention may also be in other ways other than as described herein employed to implement, therefore, the present invention is not limited to the specific disclosed below limited to the examples.

[0026] 图1是根据本发明的一个实施例的在B/S架构软件系统中浏览数据的方法的流程图。 [0026] FIG. 1 is a flowchart of a method of browsing the data in the B / S software system architecture of one embodiment of the present invention. 如图1所示,根据本发明的实施例的在B/S架构软件系统中浏览数据的方法,包括:步骤S102,配置数据量阈值;以及步骤S104,在将被浏览的数据量大于所述数据量阈值时,将所述数据存储为文件供用户浏览。 As shown, the method of browsing data in the B / S software system architecture of the present embodiment of the invention, comprising 1: step S102, the configuration data amount threshold; step S104, the data to be viewed is larger than the when the data amount threshold, the data is stored as a file for users to browse. 通过这样的技术方案,实现了在B/S架构软件系统中浏览数据的方法,提高大数据量查询的效率,降低了对客户端配置的要求及对网络性能的要求,高效利用有限网络资源。 By such a technical solution to realize a method of browsing data in the B / S architecture software system, improve the efficiency of large amounts of data query, it reduces the requirement of client configuration and requirements of network performance, efficient use of limited network resources.

[0027] 在上述技术方案中,在所述步骤S104中,将所述数据转换为EXCEL文件并存储。 [0027] In the above aspect, in the step S104, the data is converted into EXCEL file and store. 这样,将所需要的数据以EXCEL文件保存起来,就可以使用户随时且方便地查看数据。 In this way, the data needed to EXCEL file saved, you can make the user at any time and easily view the data.

[0028] 在上述技术方案中,还包括:在将所述数据存储为文件的同时,保存与所述文件相对应的信息。 [0028] In the above aspect, further comprising: storing the data in a file at the same time, saving the information corresponding to the file.

[0029] 在上述技术方案中,所述信息包括操作用户、查询条件、功能节点、数据量、保存时间、文件的物理路径以及名称中的任一种或其组合。 [0029] In the above aspect, the operation information includes a user query, the function node data volume, storage time, the physical path of the file and the name of any one or combination. 因此,可以使用户清楚地了解数据的相关信息,便于后续的加工处理。 Thus, the user can clearly understand the information data to facilitate subsequent processing.

[0030] 在上述技术方案中,所述数据量阈值是根据服务器配置、网络条件、客户端配置、 应用系统稳定性以及效率中的任一种或其组合来确定的。 [0030] In the above aspect, the amount of data threshold is based on the server configuration, network conditions, client configuration application system stability and any one or combination of efficiency determined. 这样,用户就可以根据客户端配置及网络性能的实际情况来合理地确定后台所要浏览的数据量。 In this way, users will be able to reasonably determine the amount of data you want to browse the background of the actual situation of the client configuration and network performance.

[0031 ] 通过上述技术方案,能够在满足企业业务管理需要的同时,达到最低限度地占用网络资源、有效地利用客户端资源、提高大数据量浏览效率、提高大数据量查询结果后续处理的方便性等性能。 [0031] Through the above technical solution that can meet the enterprise business management needs, while achieving minimally network resources, effective use of client resources, improve the large amount of data browsing efficiency and facilitate large amount of data query results post-processing and other properties.

[0032] 图2是根据本发明的一个实施例的在B/S架构软件系统中浏览数据的系统的框图。 [0032] FIG. 2 is a block diagram browsing data in B / S architecture software system of the system according to one embodiment of the present invention. 如图2所示,根据本发明的实施例的在B/S架构软件系统中浏览数据的系统200包括: 阈值配置单元202,配置数据量阈值;以及判断单元204,判断将被浏览的数据量是否大于所述数据量阈值;存储单元206,在将被浏览的数据量大于所述数据量阈值时,将所述数据存储为文件供用户浏览。 , According to browse the data in the B / S architecture software system system according to an embodiment of the present invention 200 includes a 2: threshold configuration unit 202, the configuration data amount threshold; and data amount determination unit 204 determines to be browsed the amount of data is larger than the threshold value; when the storage unit 206, the data to be viewed is larger than the threshold data, the data is stored as a file for users to browse. 通过这样的技术方案,实现了在B/S架构软件系统中浏览数据的方法,提高大数据量查询的效率,降低了对客户端配置的要求及对网络性能的要求,高效利用有限网络资源。 By such a technical solution to realize a method of browsing data in the B / S architecture software system, improve the efficiency of large amounts of data query, it reduces the requirement of client configuration and requirements of network performance, efficient use of limited network resources.

[0033] 在上述技术方案中,所述文件为EXCEL文件。 [0033] In the above aspect, the EXCEL document file. 因此,将所需要的数据缓存并永久保存,可以使用户随时地且方便地查看数据。 Therefore, the required data is cached and stored permanently, and allows users to easily view data at any time. [0034] 在上述技术方案中,所述存储单元206还用于在将所述数据存储为文件的同时, 保存与所述文件相对应的信息。 [0034] In the above aspect, the storage unit 206 is further configured to store the data in a file at the same time, saving the information corresponding to the file. [0035] 在上述技术方案中,所述信息包括操作用户、查询条件、功能节点、数据量、保存时间、文件的物理路径以及名称中的任一种或其组合。 [0035] In the above aspect, the operation information includes a user query, the function node data volume, storage time, the physical path of the file and the name of any one or combination. 这样,可以使用户清楚地了解数据的相关信息,便于后续的加工处理。 Thus, the user can clearly understand that the information data to facilitate subsequent processing.

[0036] 在上述技术方案中,所述数据量阈值是根据服务器配置、网络条件、客户端配置、 应用系统稳定性以及效率中的任一种或其组合来确定的。 [0036] In the above aspect, the amount of data threshold is based on the server configuration, network conditions, client configuration application system stability and any one or combination of efficiency determined. 这样,用户可以根据客户端配置及网络性能的实际情况来合理地确定后台所要浏览的数据量。 In this way, the user can be reasonably certain amount of background data to be browsed according to the actual situation of the client configuration and network performance.

[0037] 通过上述技术方案,能够在满足企业业务管理需要的同时,达到最低限度地占用网络资源、有效地利用客户端资源、提高大数据量浏览效率、提高大数据量查询结果后续处理的方便性等性能。 [0037] Through the above technical solution that can meet the enterprise business management needs, while achieving minimally network resources, effective use of client resources, improve the large amount of data browsing efficiency and facilitate large amount of data query results post-processing and other properties.

[0038] 图3是根据本发明的一个实施例的在B/S架构软件系统中浏览数据的方法的工作流程图。 [0038] FIG. 3 is a flow chart of a method according to browse the data in the B / S software system architecture of one embodiment of the present invention. 在图3的实施例中提出了一种B/S架构信息系统大数据量浏览的解决方法,主要包括:配置阀值、查询结果监控、导出EXCEL文件和相关信息数据库存储、查询结果权限设置、 查询结果分发、查询结果信息浏览、查询结果下载。 Proposed a method for solving a large amount of data B / S schema information browsing system in the embodiment of FIG. 3, including: Configuring a threshold, the query result of the monitoring, EXCEL file export and storage related information database, query results permissions, distributed query results, query results information browsing, downloading the query results. 下面结合图3详细说明根据本发明的实施例的工作处理流程。 Described in detail below in connection with FIG. 3 according to the work flow process embodiment of the present invention.

[0039] 功能1 :配置阈值 [0039] 1: a configurable threshold

[0040] 配置数据量阈值302。 [0040] 302 configuration data amount threshold. 这里的阈值是指查询结果数据量达到一定的数值,达到这个数值后系统自动将查询结果转换为EXCEL文件。 Herein refers to a threshold value query result data reaches a certain value, after the value reaches the system will automatically query results into EXCEL file. 配置数据量阈值的目的是为了让客户可以依据当前的服务器配置、网络条件、客户端配置、应用系统稳定性和效率要求来设置合适的大数据量浏览后台自动保存的临界值。 The purpose configuration data volume threshold is to allow customers to configure based on the current server, network conditions, client configuration, application system stability and efficiency required to set the appropriate large amount of data saved automatically in the background view of the critical value. 阈值可以依据具体的功能应用节点设置,也可以依据查询对应的数据主表进行设置,系统默认提供一个统一的阀值(如5000),客户应用可以修改默认值应用到全局。 Threshold may be a function depending on the particular application node settings, can also be provided, to provide a unified system default threshold (e.g., 5000), the client application can modify the default values ​​to the data corresponding to the query based on the global master table.

[0041] 功能2 :数据读取结果监控服务 [0041] Function 2: reading the results of monitoring service

[0042] 进行业务查询304。 [0042] for business inquiries 304. 由于B/S架构应用信息系统的客户端均需要通过应用服务器和数据库服务进行数据交互,而且应用服务器均需要提供TOB服务(如Microsoft IIS、IBM WebSphere, Weblogic等)和数据库操作服务组件。 Since the client B / S architecture information system applications require exchanges data through the application server and database services, application servers and services are required to provide TOB (such as Microsoft IIS, IBM WebSphere, Weblogic, etc.) and database operations service components. 同时B/S架构应用信息系统均会设计统一的数据操作后台服务组件306,用于管理数据库连接、SQL脚本转换、结果集预处理等, 因此,客户端对数据库的所有访问必须通过统一的数据库服务组件通道。 While B / S architecture design application information system will operate uniform background service data component 306, a connection management database, SQL scripts, conversion, and other preprocessing result set, therefore, the client must all access to the database through a unified database service component channel.

[0043] 数据查询监控服务组件306可以和应用服务器上部署的数据库服务组件集成在一起,自动监控客户端提交查询数据条件后数据库308的服务器返回的数据结果集,当结果集大于设定的阀值时,此服务组件306直接调用查询结果转换为EXCEL组件312进行处理,并返回客户端处理结果信息。 After the [0043] monitoring service data query component 306, and database services component can be deployed on an application server integrated with the automatic monitoring client submits condition database query data server 308 returns the result set of data, when the result set is larger than the set valve value, the service component 306 direct call to process the query result converted EXCEL assembly 312, and the processing result information returned to the client.

[0044] 功能3 :导出EXCEL文件和相关信息数据库存储功能 [0044] 3: Export EXCEL files and related information database storage capabilities

[0045] 这个功能的提供避免了应用系统每个功能模块再自行组织EXCEL格式和数据导出,仅仅需要传递应用系统数据展示的格式(如单据模板、报表模板、打印模板等)和传递数据查询结果集即可。 [0045] This application provides functionality to avoid the re-organization system each function module EXCEL format and data export their own, only need to pass the format of data presentation applications (such as document templates, report templates, print templates, etc.) and to transfer data query results It can be set. 此服务组件不需要应用模块调用,由功能2描述的组件进行调用即可。 This service does not require the application component module calls, the call to the functional components described 2. 可以跟据提交的数据显示格式、数据处理公式、数据统计要求、数据转换公司等,生成符合要求的EXCEL模板,并填充结果集。 According to the submitted data can now display format, data processing formulas, statistical data requirements, data conversion companies, generated to meet the requirements of EXCEL template and populates the result set. 完成后的EXCEL文件自动保存到服务器物理硬盘上,同时生成此结果集和对应的EXCEL文件信息保存到数据库内,系列动作完成后返回提示信息给客户端。 EXCEL file is automatically saved to the completion of the physical hard disk on the server, while generating this result set and the corresponding EXCEL file information saved in the database, presentation information series operation returns to the client after completion.

[0046] 功能4 :查询结果信息浏览、分发、下载 [0046] 4 Function: query results information browsing, distribute, download

[0047] 在保存EXCEL文件的同时,也可以把此文件对应的相关信息保存到业务数据库内,如操作用户、查询条件、功能节点、数据数量、保存时间、EXCEL文件的物理路径和名称等。 Save the information [0047] while preserving EXCEL file can also file corresponding to the service database, such as the operation of the user, query, function nodes, the amount of data, storage time, the physical path and name EXCEL file. 同时EXCEL文件保存的目的包含:下载到客户端进行统计分析和业务需要的加工、分发给其他业务员用于共享。 While preserving the EXCEL file contains the purpose: to download the client for statistical analysis and processing business needs and distributed to others for sharing salesmen. 此功能即:提供查询全部EXCEL文件信息,分发自己存储的EXCEL 给需要的客户、下载自己需要的EXCEL文件。 This feature namely: provide access to all of the EXCEL file information stored in the customer's own distribution EXCEL need to download EXCEL file they need.

[0048] 功能5 =FTP下载[0049] 系统保存的EXCEL文件可以使用通用的FTP工具进行下载,但是应用系统无法控制文件下载权限。 [0048] 5 = FTP download function [0049] saved EXCEL file system can use a common FTP tool to download, but can not control the application downloaded file permissions. 因此,为了可以控制文件下载权限,应用系统自行提供FTP下载工具。 Therefore, in order to control file permissions download, FTP download applications to provide their own tools. 操作员浏览EXCEL文件时,可以直接浏览到每个结果文件当前操作用户是否有权限下载,如果有权限下载,可以直接进行下载。 The operator EXCEL file browser, you can browse directly to each file in the current operating results if the user has permission to download, if you have permission to download, can be downloaded directly. 文件下载直接通过应用系统提供的FTP工具进行,并且支持断点续传。 FTP tool to download files directly through the application system, and support for HTTP.

[0050] 通过上述技术方案,能够在满足企业业务管理需要的同时,达到最低限度地占用网络资源、有效地利用客户端资源、提高大数据量浏览效率、提高大数据量查询结果后续处理的方便性等性能。 [0050] Through the above technical solution that can meet the enterprise business management needs, while achieving minimally network resources, effective use of client resources, improve the large amount of data browsing efficiency and facilitate large amount of data query results post-processing and other properties.

[0051] 以上,参考附图对本发明的实施例进行了详细描述。 [0051] The above embodiments with reference to the accompanying drawings of embodiments of the present invention will be described in detail. 根据本发明的实施例的技术方案为B/S架构信息系统大数量查询提供了一种查询结果缓存并可永久保存的机制,可以有效提高大数量查询的效率,并且降低了大数量查询对客户端配置的要求,而且降低了大数据量查询对网络性能的要求,从而更高效地利用有限网络资源。 According to the embodiment of embodiment B of the present invention / S frame information system provides a large number of queries and query results cache mechanism for permanent storage, can improve the efficiency of a large number of queries, and reduces the large number of queries to the client side configuration requirements, and reduces the large amount of data query requirements for network performance, so that more efficient use of limited network resources.

[0052] 大数量查询结果通过EXCEL工具进行浏览和后续处理,提高了便利性和通用型。 [0052] a large number of query results to browse and subsequent processing by EXCEL tool to improve the convenience and universal. 也提升了B/S架构信息系统的效率和稳定性,保证信息系统能够更高效的处理实时业务。 Also improves the efficiency and stability of the B / S architecture information system, to ensure that real-time traffic information system capable of processing more efficient.

[0053] 以上所述仅为本发明的优选实施例而已,并不用于限制本发明,对于本领域的技术人员来说,本发明可以有各种更改和变化。 [0053] The above description is only preferred embodiments of the present invention, it is not intended to limit the invention to those skilled in the art, the present invention may have various changes and variations. 凡在本发明的精神和原则之内,所作的任何修改、等同替换、改进等,均应包含在本发明的保护范围之内。 Any modification within the spirit and principle of the present invention, made, equivalent substitutions, improvements, etc., should be included within the scope of the present invention.

Claims (10)

  1. 一种在B/S架构软件系统中浏览数据的方法,其特征在于,包括:步骤S102,配置数据量阈值;以及步骤S104,在将被浏览的数据量大于所述数据量阈值时,将所述数据存储为文件供用户浏览。 For browsing the data in the B / S architecture software system, characterized in that, comprising: step S102, the configuration data amount threshold; step S104, to be browsed data is larger than the data amount threshold, The said data stored as a file for users to browse.
  2. 2.根据权利要求1所述的方法,其特征在于,在所述步骤S104中,将所述数据转换为EXCEL文件并存储。 2. The method according to claim 1, wherein, in the step S104, the converted file and store data to EXCEL.
  3. 3.根据权利要求1或2所述的方法,其特征在于,还包括:在将所述数据存储为文件的同时,保存与所述文件相对应的信息。 3. The method of claim 1 or claim 2, characterized in that, further comprising: storing the data in a file at the same time, saving the information corresponding to the file.
  4. 4.根据权利要求3所述的方法,其特征在于,所述信息包括操作用户、查询条件、功能节点、数据量、保存时间、文件的物理路径以及名称中的任一种或其组合。 4. The method according to claim 3, wherein said operation information includes a user query, the function node data volume, storage time, the physical path and the name of any file or combination.
  5. 5.根据权利要求1或2所述的方法,其特征在于,所述数据量阈值是根据服务器配置、 网络条件、客户端配置、应用系统稳定性以及效率中的任一种或其组合来确定的。 5. The method of claim 1 or claim 2, wherein said amount of data threshold is based on the server configuration, network conditions, client configuration application system stability and any one or combination of efficiency determined of.
  6. 6. 一种在B/S架构软件系统中浏览数据的系统,其特征在于,包括:阈值配置单元,配置数据量阈值;以及判断单元,判断将被浏览的数据量是否大于所述数据量阈值;存储单元,在将被浏览的数据量大于所述数据量阈值时,将所述数据存储为文件供用户浏览。 A browsing system data in the B / S architecture software system, characterized by comprising: threshold configuration unit, the configuration data amount threshold; and determining means for determining the amount of data to be viewed is larger than the data amount threshold value ; storage unit, when data is to be viewed is larger than the threshold data, the data is stored as a file for users to browse.
  7. 7.根据权利要求6所述的系统,其特征在于,所述文件为EXCEL文件。 7. The system according to claim 6, wherein said file is a file EXCEL.
  8. 8.根据权利要求6或7所述的系统,其特征在于,所述存储单元还用于在将所述数据存储为文件的同时,保存与所述文件相对应的信息。 The system according to claim 6 or claim 7, wherein said further storage unit for storing the data in a file at the same time, saving the information corresponding to the file.
  9. 9.根据权利要求8所述的系统,其特征在于,所述信息包括操作用户、查询条件、功能节点、数据量、保存时间、文件的物理路径以及名称中的任一种或其组合。 9. The system of claim 8, wherein said operation information includes a user query, the function node data volume, storage time, the physical path and file name in any one or combination.
  10. 10.根据权利要求6或7所述的系统,其特征在于,所述数据量阈值是根据服务器配置、 网络条件、客户端配置、应用系统稳定性以及效率中的任一种或其组合来确定的。 10. The system of claim 6 or claim 7, wherein said amount of data threshold is based on the server configuration, network conditions, client configuration application system stability and any one or combination of efficiency determined of.
CN2010102920166A 2010-09-26 2010-09-26 Method and system for browsing data in browser/server (B/S) framework software system CN101964816A (en)

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 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 (3)

* Cited by examiner, † Cited by third party
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
WO2019141134A1 (en) * 2018-01-19 2019-07-25 阿里巴巴集团控股有限公司 Data query method, apparatus and device

Citations (5)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
阚洪亮,等: "基于B/S模式的海量数据报表的实现", 《科技广场》 *

Cited By (3)

* Cited by examiner, † Cited by third party
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

Similar Documents

Publication Publication Date Title
US8234296B1 (en) Method for distributed RDSMS
JP4132441B2 (en) Data management device for managed objects
US9110976B2 (en) Supporting compliance in a cloud environment
US8775232B2 (en) Transforming a legacy IT infrastructure into an on-demand operating environment
Hacigumus et al. Providing database as a service
US8177121B2 (en) Automated aggregation and comparison of business spending relative to similar businesses
US9219775B2 (en) System, method and computer program product for publicly providing web content of a tenant using a multi-tenant on-demand database service
US7340446B2 (en) Method and system for query-based management of multiple network resources
US9251183B2 (en) Managing tenant-specific data sets in a multi-tenant environment
US8271655B2 (en) Cloud computing roaming services
US8925041B2 (en) System, method and computer program product for performing one or more actions based on a determined access permissions for a plurality of users
US7313575B2 (en) Data services handler
US8965902B2 (en) Intelligent event query publish and subscribe system
US20030220901A1 (en) Interaction manager
US8156161B2 (en) System and method for displaying data on a thin client
US8543642B2 (en) Method of optimizing data flow between a software application and a database server
Casati et al. Business-oriented management of Web services
US8108338B2 (en) Method and system for model-based replication of data
US6606627B1 (en) Techniques for managing resources for multiple exclusive groups
US8874600B2 (en) System and method for building a cloud aware massive data analytics solution background
US20070282869A1 (en) Automatically generating web forms from database schema
US20060230025A1 (en) Enterprise software system having multidimensional XBRL engine
US6859798B1 (en) Intelligence server system
US8219521B2 (en) Methods and apparatus for improving data warehouse performance
US20040230578A1 (en) Aggregation of resource requests from multiple individual requestors

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
C12 Rejection of a patent application after its publication