Browse Prior Art Database

Iterative and fast loading and optimized searching and filtering of large amount of database data from database to web browser by leveraging on result set pool and customized data grid

IP.com Disclosure Number: IPCOM000245365D
Publication Date: 2016-Mar-04
Document File: 8 page(s) / 166K

Publishing Venue

The IP.com Prior Art Database

Abstract

The purpose of the invention is to provide a lightweight solution loading big data from database to web browser and makes the interactions with data consistency, performance optimization, less resource consumptions and less overheads on database server.The main ideas include: 1.Iterative loading grid loading data within the same transaction with high data consistency; 2.Rich grid controls including max rows/loading time/pause/restart to restrict rows loaded; 3.Back-end search plus dynamic local filter and refresh provides a better solution to find data that we want; 4.Result set pool to keep iterative loading track with less resource consumptions and overheads.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 31% of the total text.

Page 01 of 8

Iterative and fast loading and optimized searching and filtering of large amount of database data from database to web browser by leveraging on result set pool and customized data grid

For a traditional web application, there are three layers: database, application server, web browser. With the business continues to grow, there are more chances to handle big data for a web application. That brings a considerable challenge. Because to handle these big data, the SQL on database needs takes a longer time to execute then the application server also needs a longer time to proceed, so does the web browser. When a large amount of data in database is accessed from a web browser, if loading of all or big part of the data from the database once, assuming the amount of data is too large, it will lead to hang on the front page, and users need a longer time to see the data they want, that brings a bad and sometimes unacceptable user experiences.

So there is the need to have such a method to quickly and easily fetch big data from database to web browser with less overheads and consistent data and without needs of powerful server clusters.

The purpose of the invention is to provide a lightweight solution loading big data from database to web browser and makes the interactions with data consistency, performance optimization, less resource consumptions and less overheads on database server.

The main ideas include:


1. Iterative loading grid loading data within the same transaction with high data consistency;

2. Rich grid controls including max rows/loading time/pause/restart to restrict rows loaded;

3. Back-end search plus dynamic local filter and refresh provides a better solution to find data that we want


4. Result set pool to keep iterative loading track with less resource consumptions and overheads;

Advantage:


1. No matter how large the amount of data, web browser can display data within a few seconds.

2. No matter how frequent changes in data, web browser can display data with data consistency.

3. Normal search on back-end together fuzzy filter on loaded data makes the solution get a great tradeoff among performance and complexity.

4. Normal search on back-end together fuzzy filter on loaded data makes the solution not need strong server clusters to run like a search engine on clusters.


5. Result set pool doesn't need big memory than data cache in memory.

6. One executed SQL has less overhead database servers than multiple SQLs.

7. Load time control and max rows control reduce the overhead on database server.

8. Users can see the latest data just by clicking refreshing button or searching.

Benefits:

All similar web application that need retrieve big data from database server

Novelty & Claims

1



Page 02 of 8


1. Provides a light-weight data loading method with enough data consistency and less overhead together non-powerful servers required;

2. Loading the first chunk of data quickly together with iterative data loading within the same transactio...