Classifications

• • G—PHYSICS
  • G06—COMPUTING; CALCULATING OR COUNTING
  • G06F—ELECTRIC DIGITAL DATA PROCESSING
  • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
  • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
  • G06F16/22—Indexing; Data structures therefor; Storage structures
  • G06F16/2282—Tablespace storage structures; Management thereof
• • G—PHYSICS
  • G06—COMPUTING; CALCULATING OR COUNTING
  • G06F—ELECTRIC DIGITAL DATA PROCESSING
  • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
  • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
  • G06F16/22—Indexing; Data structures therefor; Storage structures
  • G06F16/2219—Large Object storage; Management thereof
• • G—PHYSICS
  • G06—COMPUTING; CALCULATING OR COUNTING
  • G06F—ELECTRIC DIGITAL DATA PROCESSING
  • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
  • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
  • G06F16/28—Databases characterised by their database models, e.g. relational or object models
  • G06F16/284—Relational databases

Definitions

• the present invention relates to the field of computer data processing technologies, and in particular, to a method and apparatus for implementing large data volume processing based on a table. Background technique
• a telecommunication network management system usually needs to implement processing of a large amount of data.
• the so-called large amount of data that is, the amount of data displayed far exceeds the capacity that can be supported by the memory
• the report management in the network management system is taken as an example to illustrate that the report management is
• the system administrator provides a unified report output function for important information of the network management system.
• the report management function the system administrator can customize the report task and output the report data, which is convenient for monitoring the operation of the network management system.
• the report management system is generally used to output the corresponding form. Process such data.
• the functions provided by the prior art are relatively simple. If complex typographic functions are to be implemented on the basis of such a form, complex secondary development is required, but the secondary development of the form can realize complex typographic functions.
• the so-called complex typesetting refers to the typesetting functions such as global real-time sorting, line number display, column freezing, column heading automatic line-feeding display, blank column filtering, and the like.
• it is difficult to meet the requirements of complex typographic functions such as real-time sorting.
• the problem of the present invention is to provide a method and apparatus for implementing large data volume processing based on a table.
• a method for implementing large data volume processing based on a table comprising:
• At least one large data volume operation command to the table is identified, and a large amount of data is obtained from the in-memory database and presented through the table in accordance with the large data volume operation command.
• the method further includes: indexing the data in the in-memory database according to the row number of the table, and when the data needs to be displayed, according to the row number of the table to the memory The corresponding data is read in the database.
• the redeveloped table has a column header sorting function; the column header sorting function is configured to bind the redeveloped table to an in-memory database for sorting a result set .
• the method further includes: first buffering the large data volume to an intermediate file, and then presenting the file according to the intermediate file. Large amount of data.
• the method further comprises: identifying at least one function customization command, and performing corresponding adding or deleting operations on the complex typesetting function supported by the table according to the function customization command.
• An apparatus for implementing large data volume processing based on a table comprising:
• a deployment module configured to deploy a secondary developed form that implements complex typographic functions
• an association module configured to establish an association relationship between the form and the in-memory database
• An identification module configured to identify at least one large data volume operation command for the form
• the obtaining module is configured to obtain a large amount of data from the in-memory database according to the large data volume operation command;
• a rendering module configured to present a large amount of data retrieved from the in-memory database through the table.
• the association module is configured to index data in the in-memory database according to the row number of the table, so that when the data needs to be displayed, the obtaining module reads the corresponding data into the in-memory database according to the row number of the table.
• the redeveloped table has a column header sorting function; the column header sorting function is configured to bind the redeveloped table to an in-memory database for sorting the result set.
• the obtaining module is configured to cache the large amount of data to an intermediate file after acquiring a large amount of data from the in-memory database according to a large data operation command, and the rendering module is configured on the form according to the intermediate file. Present a large amount of data.
• the device for implementing large data volume processing based on a table further includes:
• the customization module is configured to identify at least one function customization command, and according to the function customization command, perform corresponding addition or deletion operations on the complex layout function supported by the table.
• the method and device for realizing large data volume processing based on a table provided by the present invention can realize secondary development of a complex typesetting function by using a table, and the secondary developed form It is bound to the in-memory database.
• the table can support complex layout, global real-time sorting, and large data volume presentation.
• FIG. 1 is a schematic flowchart of a method for implementing large data volume processing based on a table according to an embodiment of the present invention
• FIG. 2 is a flow chart of a method for implementing large data volume processing based on a table according to another embodiment of the present invention
• FIG. 3 is a schematic structural diagram of an apparatus for implementing large data volume processing based on a table according to an embodiment of the present invention
• FIG. 4 is a schematic structural diagram of an apparatus for implementing large data volume processing based on a table according to another embodiment of the present invention.
• a method for implementing large data volume processing based on a table includes the following steps:
• the complex typesetting function includes, but is not limited to, a global real-time sorting, a line number display, a column freeze, a column header automatic line feed display, and a blank column filter.
• the pre-developed secondary development of the table may be performed according to the prior art that is known to those skilled in the art, and will not be described in detail herein.
• the redeveloped table has a column head sorting function, and the column head sorting function is used to bind the redeveloped table and the in-memory database for sorting the result set.
• the ordering operation instruction may be an Order by operation. This allows you to click on the header to perform global sorting.
• the association relationship between the establishment table and the in-memory database may be an association relationship between the display logic of the table and the in-memory database.
• the method may further include: indexing the data in the in-memory database according to the row number of the table, and reading the corresponding data according to the row number of the table to the in-memory database when the data needs to be displayed. .
• the large data volume operation command is a variety of complex typesetting operation commands for the table input by the user.
• the large The amount of data is cached to the intermediate file, and then the large amount of data is presented on the form according to the intermediate file, so that when the large amount of data is presented through the table and the complex typesetting function is performed on the large amount of data, the memory usage can be reduced, and the large size can be realized.
• Data volume presentation and operation After obtaining a large amount of data from the in-memory database according to a large data operation command, the large The amount of data is cached to the intermediate file, and then the large amount of data is presented on the form according to the intermediate file, so that when the large amount of data is presented through the table and the complex typesetting function is performed on the large amount of data, the memory usage can be reduced, and the large size can be realized.
• the method for implementing large data volume processing based on a table further includes:
• the function customization command can add or delete column freeze, column width, header order, column hiding, etc. by the user clicking the right mouse button and selecting the corresponding custom menu input.
• Typesetting function In other embodiments, the typesetting of the functions such as column freeze, column width, and header order can also be performed by the user directly dragging the header of the table, which is not described in detail herein.
• the method for realizing large data volume processing based on the table provided by the embodiment of the present invention realizes column freezing by secondary development of the table; secondary development of the header, supporting column headings and sorting arrow display; and displaying the logic of the table
• the in-memory database is bound, and when the specific data needs to be displayed, the records are read according to the line number to the in-memory database; the function of sorting the table column header is bound with the Order by operation of the in-memory database, so as to implement the click header globally. Sorting function; Cache in-memory database data into files, reduce memory usage, and realize large data volume rendering and operation. Therefore, the table provided by the embodiment of the present invention can simultaneously support functions of complex typesetting, global real-time sorting, and large data volume presentation.
• an apparatus for implementing large data volume processing based on a table includes:
• the deployment module 10 is configured to deploy a re-developed table that implements complex typographic functions; the association module 20 is configured to establish an association relationship between the display logic of the table and the in-memory database 40; and the identification module 30 is configured to identify the pair of tables At least one large data volume operation command 300;
• the obtaining module 50 is configured to obtain a large amount of data from the in-memory database 40 according to the large data volume operation command 300;
• a presentation module 60 configured to use the table to obtain a large amount of data obtained from the in-memory database 40 Presented.
• the complex typesetting function includes, but is not limited to, a global real-time sorting, a line number display, a column freeze, a column header automatic line feed display, and a blank column filter.
• the pre-developed secondary development of the form can be performed in accordance with the prior art already known to those skilled in the art.
• the association module 20 is further configured to index the data in the in-memory database 40 according to the row number of the table, so that when the data needs to be displayed, the obtaining module 50 goes to the in-memory database according to the row number of the table. The corresponding data is read in 40.
• the large data volume operation command 300 recognized by the identification module 30 is a user-entered various complex typesetting operation commands for the table.
• the column header sorting function of the redeveloped table is configured to be bound to the Order by operation of the in-memory database 40 for sorting the result set, thereby implementing the click header For global sorting.
• the obtaining module 50 caches the large data amount to an intermediate file (not shown),
• the presentation module 60 presents a large amount of data on the form in accordance with the intermediate file. In this way, when a large amount of data is presented through a table and a complex typesetting function is performed on a large amount of data, the memory usage can be reduced, and a large amount of data can be presented and operated.
• the apparatus for implementing large data volume processing based on a table further includes:
• the customization module 70 is configured to identify at least one function customization command 700, and according to the function customization command 700, perform corresponding addition or deletion operations on the complex typesetting function supported by the table.
• the customization module 70 can add or delete a column freeze, a column width, and a table by identifying at least one user-entered function customization command 700, for example, the function customization command 700 can be added or deleted by the user clicking the right mouse button and selecting a corresponding custom menu input.
• Complex typographic features such as head order, column hiding, etc.
• the typesetting of the column freeze, the column width, the header order, and the like may also be performed by the user directly dragging the header of the table, which is not described in detail herein.

Landscapes

• Engineering & Computer Science (AREA)
• Theoretical Computer Science (AREA)
• Databases & Information Systems (AREA)
• Data Mining & Analysis (AREA)
• Physics & Mathematics (AREA)
• General Engineering & Computer Science (AREA)
• General Physics & Mathematics (AREA)
• Software Systems (AREA)
• Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
• User Interface Of Digital Computer (AREA)

Priority Applications (2)

Applications Claiming Priority (2)

Publications (1)

Family

ID=51897782

Family Applications (1)

Country Status (4)

Cited By (1)

Families Citing this family (1)

Citations (4)

Family Cites Families (13)

• 2013
  • 2013-11-11 CN CN201310557992.3A patent/CN104636372B/zh active Active
• 2014
  • 2014-06-12 JP JP2016528157A patent/JP6530390B2/ja active Active
  • 2014-06-12 WO PCT/CN2014/079793 patent/WO2014183723A1/zh active Application Filing
  • 2014-06-12 KR KR1020167010536A patent/KR101777073B1/ko active IP Right Grant

Patent Citations (4)

Also Published As

Similar Documents

Legal Events