CN104361049A - Method and system for quickly expressing data of database - Google Patents
Method and system for quickly expressing data of database Download PDFInfo
- Publication number
- CN104361049A CN104361049A CN201410594799.1A CN201410594799A CN104361049A CN 104361049 A CN104361049 A CN 104361049A CN 201410594799 A CN201410594799 A CN 201410594799A CN 104361049 A CN104361049 A CN 104361049A
- Authority
- CN
- China
- Prior art keywords
- data
- page
- database
- initialization
- class
- 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
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The embodiment of the invention discloses a method for quickly expressing data of database. The method comprises the following steps: sending a query statement to the database, wherein the query statement is used for inquiring data stored in the database; initializing classes used for data paging; receiving data object list information fed back by the data base and inquired through the query statement; calling the initialized classes and extracting the data in the database in a paged manner to obtained paged data according to the received data object list information; expressing the paged data in pages. After the method is adopted, a user can regulate and obtain the data in the data base, so that the problems of low data transmission efficiency of a database, low expression efficiency, large occupied space and memory and the like of the prior art can be solved, individual needs of users can be met, data can be expressed in a paged manner, and the users can obtain clear data expression conveniently.
Description
Technical field
The present invention relates to technical field of data processing, particularly relate to a kind of method and system of quick demonstrating data database data.
Background technology
Along with the development of science and technology, banking gets more and more, the transaction data amount supervened is also increasing, how the vast resources in GREENPLUM database (hereinafter referred to as GP) and data is shown fast be the problem that current needs solve in front of the user.
For the data warehouse computing environment that GP builds, utilize SAS platform invoke to access GP interface, obtain the data analyzed and show GP.At present, the data between cross-platform GP and SAS platform have following two kinds of data display modes: the result data that GP database generates is downloaded view to client platform by the first, showing interface result data view; The result data that the second will GP database generate, all downloads to client platform, directly shows result data at interface.
Traditional view shows mode, limited in one's ability to the buffer scheduling of bursts of traffic, easily cause the inefficiency under centralized traffic accesses the bursts of traffic situation caused, client is easily stuck, data cannot continue the phenomenon of showing, are difficult to satisfied large data, high efficiency demand; Traditional downloading data storehouse result data then can cause resource repetition and waste to applications client, particularly when mass data, also be a huge challenge to the memory capacity of applications client, user in use simultaneously, if the rally of first time inquiry traversing result expends for a long time when data volume is very large, and the data of buffer memory also can take a large amount of internal memory, and efficiency obviously declines.
Summary of the invention
Embodiment of the present invention technical matters to be solved is, a kind of method and system of quick demonstrating data database data are provided, achieve the adjustable acquisition database data of user, solve in prior art, database data transfer efficiency is slow, displaying efficiency is low, take up room the problems such as internal memory is many, meet user individual needs, realize data page and show, be convenient to user and obtain data exhibiting clearly.
In order to solve the problems of the technologies described above, embodiment of the present invention first aspect discloses a kind of method of quick demonstrating data database data, comprising:
Send query statement to database, described query statement is for inquiring about the data be stored in database;
Initialization is used for the class of data page;
Receive the data result table information inquired through described query statement that database returns;
Call the class after described initialization, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data;
Described paged data is shown by page.
Embodiment of the present invention second aspect discloses a kind of system of quick demonstrating data database data, comprising:
Sending module, for sending query statement to database, described query statement is for inquiring about the data be stored in database;
Initialization module, is used for the class of data page for initialization;
Receiver module, for receiving the data result table information inquired through described query statement that database returns;
Calling module, for calling the described initialization class of described initialization module;
Paging processing module, for the described data result table information received according to receiver module, and the initialization class that described calling module calls, the data in described database are extracted in paging, obtain paged data;
Display module, for showing described paged data by page.
By implementing the embodiment of the present invention, there is following beneficial effect:
1, according to the data cases of database and self needs of user, after judging the result sizes of the data result table obtained, paging displaying is carried out to the data in database, and can Appropriate application SAS client space, prevent space from having a full house;
2, expand in platform interactive display data at SAS client and GP database, control for user provides a kind of, the method for hommization, control with user that line number obtains, paging display data, enable user's repeatedly multipage access result set.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the method flow schematic diagram of the quick demonstrating data database data that the embodiment of the present invention provides;
Fig. 2 is the schematic flow sheet of another embodiment of quick demonstrating data database data method provided by the invention;
Fig. 3 is the schematic flow sheet of the another embodiment of quick demonstrating data database data method provided by the invention;
Fig. 4 is the schematic flow sheet of the paging process of the quick demonstrating data database data method that the embodiment of the present invention provides;
Fig. 5 is the schematic flow sheet of the data interaction of the quick demonstrating data database data method that the embodiment of the present invention provides;
Fig. 6 is the structural representation of the system of the quick demonstrating data database data that the embodiment of the present invention provides;
Fig. 7 is the structural representation of another embodiment of the system of quick demonstrating data database data provided by the invention;
Fig. 8 is the structural representation of the initialization data paging unit that the embodiment of the present invention provides;
Fig. 9 is the structural representation of the paging processing module that the embodiment of the present invention provides;
Figure 10 is the structural representation of the page processing module that the embodiment of the present invention provides;
Figure 11 is the structural representation of the paging processing module that the embodiment of the present invention provides.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
It should be noted that, the term used in embodiments of the present invention is only for the object describing specific embodiment, and not intended to be limiting the present invention." one ", " described " and " being somebody's turn to do " of the singulative used in the embodiment of the present invention and appended claims is also intended to comprise most form, unless context clearly represents other implications.It is also understood that term "and/or" used herein refer to and comprise one or more project of listing be associated any or all may combine.
SAS (Statistical Analysis System) is a kind of open platform, back-up system client and server end, for setting up data warehouse and carrying out the large-scale integrated modular software systems of data analysing and decision support; Be a set of large-scale Integrated predict model software systems of American SAS software study institute development, there is complete data access, data management, data analysis and data exhibiting function.It is as follows that SAS has functional characteristics: have operation interface close friend, has oneself SAS language and multi-window operation function, easy and simple to handle, visual and clear; Data access, management can be integrated, analyze and represent, for different applications provides remarkable data processing function; Support multiple hardwares platform, all can run under various computing machine and several operation systems; Adopt modular designs, user can select different block combiner as required, makes it have feature that is practical, wide application; There is flexible, powerful database interface and functional module interface.
Database in the embodiment of the present invention is including but not limited to GP database, oracle database distributed database.Wherein GP (GREENPLUM) is a relevant database cluster.The feature of GP database is exactly mainly that inquiry velocity is fast, and data loading speed is fast, and batch DML process is fast; And performance along with the interpolation of hardware, linearly can increase, and has very good extensibility.Therefore, GP database is mainly applicable to the application towards analyzing, and such as builds enterprise-level ODS/EDW, or Data Mart etc.
See Fig. 1, be the method flow schematic diagram of the quick demonstrating data database data that the embodiment of the present invention provides, the method comprises:
Step S100: send query statement to database;
Particularly, send query statement to database, described query statement is for inquiring about the data be stored in database.Can by SAS client submit Query statement to database, the data message in Query Database, described database is including but not limited to GP database, oracle database distributed database; Described database is including but not limited to data contents such as transaction data, user profile, accounts information, business information, and described data message comprises but is not limited to size of data, data type, data content etc.Described query statement comprises user preset screening conditions, and according to described user preset screening conditions, database can carry out the screening of extraneous data to the data in database; User's screening conditions are including but not limited to type of transaction, exchange hour, accounts information, teller's information etc.; Inquiry after data in garbled data storehouse, database can production data result table, including but not limited to garbled data, data result table information etc. in data result table; Described data result table information is including but not limited to database data size, database data total number information etc.
Step S102: initialization is used for the class of data page;
Particularly, the process of paged data is extracted to paging and carries out initialization, and initialized content integration can be become initialization class, be convenient to follow-uply transfer use.Initialization data paging class process is as follows: initialization is for obtaining the variable of the data total number of described database; The data number that every page data comprises is preset according to paging demand; According to the data number that data total number and described default every page data of described database comprise, initialization is for calculating the function of the data total page number of database.Such as, the data total number variable of database described in initialization is X, presetting according to the paging demand of client the data number that every page data comprises is 10000, so according to the data number that initialized data total number variable and default every page data comprise, the function of the data total page number that initialization obtains for calculating described database is: database data total page number equals variable X and comprises data 10000 divided by every page, according to the total page number in the database calculated, namely can carry out paging to the data in data storehouse and extract data.
Step S104: the data result table information receiving the database inquired through described query statement that database returns;
Particularly, the information of the described database that receiving step S100 query statement inquires, receives the data result table information of described database.Described data result table information is including but not limited to Database size, database total number, data type etc.
Step S106: call the class after described initialization, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data;
Particularly, the initialization class of invocation step S102, according to the described data result table information that step S104 receives, can obtain the data total number of described database, carry out paging extraction, obtain paged data to the data in database.Such as, receive data result table information, the data total number comprising described database in result table information is the information of 50000, is so 10000 according to the paging of user preset comprises data number in step S102 initialization class, calculates paged data one and have 5 pages.When the data in database are extracted in paging, when SAS client acquiescence represents first page data, acquiescence extracts 1-10000 article of data in database, when SAS client shows second page data, extract 10001-20000 article of data in database, when SAS client shows the 3rd page data, extract 20001-30000 article of data in database, when SAS client shows the 4th page data, extract 30001-40000 article of data in database, when SAS client shows the 5th page data, extract 40001-50000 article of data in database.
Step S108: show described paged data by page;
Particularly, the data in described database are extracted in step S106 paging, after obtaining paged data, SAS client acquiescence is extracted and 1-10000 article of data in display data result table, namely gives tacit consent to and extracts first page paged data to SAS client for described 1-10000 article.
See Fig. 2, be the schematic flow sheet of another embodiment of quick demonstrating data database data method provided by the invention, the method comprises:
Step S200: send query statement to database;
Particularly, when SAS client and GP database carry out data interaction, need advanced row data cube computation.Suppose that user A logs in client, be connected to GP database by the initiation of SAS client is short; In subsequent step, when needing to carry out exchanges data, SAS client is all initiated shortly to be connected to GP database at every turn;
Connection procedure can be as follows:
By SAS client submit Query statement to GP database, the data message in GP database can be inquired about, database is including but not limited to transaction data, user profile, accounts information, business information etc., and data message comprises but is not limited to size of data, data type, data content etc.Such as, packet in GP database contains 500,000,000, reports the loss the data message such as account name, account, Time Created of business, user in the data of 500,000,000 including but not limited to credit transaction data, loan transaction data, password.
The query statement that database root is submitted to according to SAS client, can carry out data query, may include client screening conditions in described query statement.By screening conditions, GP database can screen the data in database, and described screening conditions are including but not limited to type of service, user profile, accounts information, Time Created etc.Such as, the data of number of different types are comprised in GP database, database data total number is 80000, setting screening conditions are: extract the data of data setup time between August 30 30 days to 2014 July in 2014, by screening, filter out irrelevant data, obtain the data between August 30 30 days to 2014 July in 2014, data total number after screening is 50000, the data after screening are claimed to be result data, result data is stored in result data table, including but not limited to the size of data of result data in described result data table, data number, the data messages such as data type.
Step S202: initialization is used for the class of data page and data page turning;
Particularly, arrange initialization paging class to the process of data page process, initialization is for obtaining the variable of the data total number of described database; The data number that every page data comprises can be preset according to paging demand; According to the data number that data total number and described default every page data of described database comprise, can initialization for calculating the function of the data total page number of database.Such as, the data total number variable of database described in initialization is X, presetting according to the paging demand of client the data number that every page data comprises is 10000, so according to the data number that initialized data total number variable and default every page data comprise, the function of the data total page number that initialization obtains for calculating described database is: database data total page number equals variable X and comprises data 10000 divided by every page.
Initialization page turning class is arranged to the process of data page processing, the table parameter that initialization procedure imports into according to the generic attribute defined, class methods, user, generate current presentation result set class, realize turning over taking off a page data.Generic attribute is including but not limited to class object title, class object corresponding control name, class object first page, class object prevpage, class object the next page, class object last page etc.
The process of initialization class can be as follows:
Step S204: receive the data result table information inquired through described query statement that database returns;
Particularly, the query statement that in database receiving step S200, SAS client is submitted to, the data result table information of described database can be obtained after data screening is also inquired about to carrying out in described database, and can by described data result table information pushing to SAS client, including but not limited to data messages such as the size of data of result data, data number, data types in described data result table.SAS client receives the data result table information inquired through described query statement that database returns, and such as, information in the data result table information that SAS client receives is database data total number is 50000.
Step S206: call the class after described initialization, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data;
Particularly, SAS client call step S202 initialized class in advance, according to the described data result table information that step S204 receives, can obtain the data total number of described database, carry out paging extraction, obtain paged data to the data in database.Such as, receive data result table information, the data total number comprising described database in data result table information is the information of 50000, is so 10000 according to the paging of user preset comprises data number in step S202 initialization class, calculates paged data one and have 5 pages.When the data in database are extracted in paging, when SAS client acquiescence represents first page data, acquiescence extracts 1-10000 article of data in database, when SAS client shows second page data, extract 10001-20000 article of data in database, when SAS client shows the 3rd page data, extract 20001-30000 article of data in database, when SAS client shows the 4th page data, extract 30001-40000 article of data in database, when SAS client shows the 5th page data, extract 40001-50000 article of data in database.
Step S208: show first page paged data;
Particularly, the data in described database are extracted in step S206 paging, after obtaining paged data, 1-10000 article of data in acquiescence downloading data result table are to SAS client, and be presented to user, namely described 1-10000 article of data are given tacit consent to and are extracted first page paged data to SAS client, and can the home record of registration and preservation current presentation page data.
Step S210: receive and turn over the request of getting page up or next page data;
Particularly, SAS client reception user A turns over and gets the page up of paged data or the request of next page data, paged data as current display is 1-10000 article of data (i.e. first page data), then SAS client can only be carried out turning over of next page data and got, and namely downloads 10001-20000 article of data to SAS client; If the paged data of current display is 40001-50000 article of data (i.e. last page data), then SAS client can only be carried out turning over of page up data and got, and namely downloads 30001-40000 article of data to SAS client; If the non-first page of the paged data of current display also non-final one page, so SAS client both can have been turned over and got page up paged data, also can turn over and take off one page paged data.
Step S212: transfer the class after described initialization;
Particularly, the initialization class for data page turning in step S202 is transferred, for carrying out data page turning to the paged data in described database.
Step S214: turn over and get and show the page up data of described paged data or next page data of described paged data;
Particularly, according to the initialization class that step S212 transfers, by the home record of the current presentation page of step S208 registration and preservation, can transfer and show the page up paged data of current presentation page or lower one page paged data.
The data set page number process obtaining page up data or next page data can be as follows:
Download and select 10000 data of the page up data of GP database or next page data can be as follows to SAS client process:
See Fig. 3, be the schematic flow sheet of another embodiment of quick demonstrating data database data method provided by the invention, the method comprises:
Step S300: send query statement to database;
Particularly, when SAS client and GP database carry out data interaction, need advanced row data cube computation.Suppose that user A logs in client, be connected to GP database by the initiation of SAS client is short; In subsequent step, when needing to carry out exchanges data, SAS client is all initiated shortly to be connected to GP database at every turn.
Connection procedure can be as follows:
By SAS client submit Query statement to GP database, the data message in GP database can be inquired about, database is including but not limited to transaction data, user profile, accounts information, business information etc., and data message comprises but is not limited to size of data, data type, data content etc.Such as, packet in GP database contains 800,000,000, including but not limited to the data message such as account name, account, Time Created comprising credit transaction data, loan transaction data, password report the loss business, user in the data of 800,000,000.
The query statement that database root is submitted to according to SAS client, can carry out data query, may include client screening conditions in described query statement.By screening conditions, GP database can screen the data in database, and described screening conditions are including but not limited to type of service, user profile, accounts information, Time Created etc.Such as, the data of number of different types are comprised in GP database, database data total number is 80000, setting screening conditions are: extract the data of data setup time between August 30 30 days to 2014 July in 2014, by screening, filter out irrelevant data, obtain the data between August 30 30 days to 2014 July in 2014, data total number after screening is 50000, the data after screening are claimed to be result data, result data is stored in result data table, including but not limited to the size of data of result data in described result data table, data number, the data messages such as data type.
Step S302: initialization is used for the class of data page and data page turning;
Particularly, arrange initialization paging class to the process of data page process, initialization is for obtaining the variable of the data total number of described database; The data number that every page data comprises can be preset according to paging demand; According to the data number that data total number and described default every page data of described database comprise, can initialization for calculating the function of the data total page number of database.Such as, the data total number variable of database described in initialization is X, presetting according to the paging demand of client the data number that every page data comprises is 10000, so according to the data number that initialized data total number variable and default every page data comprise, the function of the data total page number that initialization obtains for calculating described database is: database data total page number equals variable X and comprises data 10000 divided by every page;
Initialization page turning class is arranged to the process of data page processing, the table parameter that initialization procedure imports into according to the generic attribute defined, class methods, user, generate current presentation result set class, realize turning over taking off a page data.Generic attribute is including but not limited to class object title, class object corresponding control name, class object first page, class object prevpage, class object the next page, class object last page etc.
The process of initialization class can be as follows:
Step S304: receive the data result table information inquired through described query statement that database returns;
Particularly, the query statement that in database receiving step S300, SAS client is submitted to, the data result table information of described database can be obtained after data screening is also inquired about to carrying out in described database, and can by described data result table information pushing to SAS client, including but not limited to data messages such as the size of data of result data, data number, data types in described data result table.SAS client receives the data result table information inquired through described query statement that database returns, and such as, information in the data result table information that SAS client receives is database data total number is 50000.
Step S306: call the class after described initialization, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data;
Particularly, SAS client call step S302 initialized class in advance, according to the described data result table information that step S204 receives, can obtain the data total number of described database, carry out paging extraction, obtain paged data to the data in database.Such as, receive data result table information, the data total number comprising described database in data result table information is the information of 50000, is so 10000 according to the paging of user preset comprises data number in step S202 initialization class, calculates paged data one and have 5 pages.When the data in database are extracted in paging, when SAS client acquiescence represents first page data, acquiescence extracts 1-10000 article of data in database, when SAS client shows second page data, extract 10001-20000 article of data in database, when SAS client shows the 3rd page data, extract 20001-30000 article of data in database, when SAS client shows the 4th page data, extract 30001-40000 article of data in database, when SAS client shows the 5th page data, extract 40001-50000 article of data in database.
Step S308: show first page paged data;
Particularly, the data in described database are extracted in step S306 paging, after obtaining paged data, acquiescence downloads 1-10000 article of data of paged data to SAS client, and be presented to user side, namely described 1-10000 article of data are given tacit consent to and are extracted first page paged data to SAS client, and can the home record of registration and preservation current presentation page data.
Step S310: receive and turn over the request of getting N page data;
Particularly, SAS client receives the request that user A turns over the N page data getting paged data, such as, receives user A and turns over the request of getting the 4th page of paged data.
Step S312: transfer the class after described initialization;
Particularly, transfer the initialization class for data page turning in step S302, may be used for carrying out data paging to the paged data in described database.
Step S314: turn over and get and show the N page data of described paged data;
Particularly, according to the initialization class that step S312 transfers, by the home record of the current presentation page of step S308 registration and preservation, can download and show that ((N-1) * 10000+1)-N*10000 article data of paged data are to client.Such as, answer step S310 client to turn over to get the request of the 4th page data, download and show that 30001-40000 article of data of paged data are to SAS client.
The data set page number process obtaining N page data can be as follows:
Download and select 10000 articles of data of the N page data of GP database can be as follows to SAS client process:
See Fig. 4, be the schematic flow sheet of the paging process of quick demonstrating data database data method provided by the invention, intelligible, in the step S200 described in Fig. 2, initialization data paging class after sending query statement to database, the method comprises:
Step S400: initialization is for obtaining the variable of the data total number of described database;
Particularly, the data total number variable of database described in initialization is X, X is natural number.X is that database is inquired about by query statement and screens the rear database data total number obtained.
Step S402: preset the data number that every page data comprises according to paging demand;
Particularly, according to user's paging demand, can to pre-set data number that every page data comprises be Y, Y is natural number, and Y is not more than the data total number X in step S400.Such as, according to user's request, pre-setting the data number that every page data comprises is 10000.
Step S404: the data number comprised according to data total number and described default every page data of described database, initialization is for calculating the function of the data total page number of database;
Particularly, the function of the data total page number that initialization obtains for calculating described database can be: database data total page number comprises data number divided by presetting every page, such as database data paging total page number=database total number variable X/preset number 10000.
See Fig. 5, it is the schematic flow sheet of the data interaction of quick demonstrating data database data method provided by the invention, the present embodiment is the method describing quick demonstrating data database data based on the angle of SAS client and GP database, can comprise the following steps as shown in the figure:
Step S500:SAS client sends query statement to database;
Particularly, when SAS client and GP database carry out data interaction, advanced row data cube computation.Suppose that user A logs in client, be connected to GP database by the initiation of SAS client is short.In subsequent step, when needing to carry out exchanges data, SAS client is all initiated shortly to be connected to GP database at every turn.
Connection procedure can be as follows:
SAS client submit Query statement is to GP database, data message in inquiry GP database, database is including but not limited to transaction data, user profile, accounts information, business information etc., and data message comprises but is not limited to size of data, data type, data content etc.Such as, data in GP database may include 500,000,000, report the loss the information such as account name, account, Time Created of business, user in the data of 500,000,000 including but not limited to credit transaction data, loan transaction data, password.Can comprise screening conditions in query statement, described screening conditions are including but not limited to type of service, user profile, accounts information, Time Created etc.
Step S502:SAS client initialization is used for the class of data page and data page turning;
Particularly, SAS client can arrange initialization paging class to the process that paged data is extracted in paging, and initialization is for obtaining the variable of the data total number of described database; The data number that every page data comprises can be preset according to paging demand; According to the data number that data total number and described default every page data of described database comprise, can initialization for calculating the function of the data total page number of database.Such as, the data total number variable of database described in initialization is X, presetting according to the paging demand of client the data number that every page data comprises is 10000, so according to the data number that initialized data total number variable and default every page data comprise, the function of the data total page number that initialization obtains for calculating described database is: database data total page number equals variable X and comprises data 10000 divided by every page;
Initialization page turning class is arranged to the process of data page processing, the table parameter that initialization procedure imports into according to the generic attribute defined, class methods, user, current presentation result set class can be generated, can realize turning over and take off a page data.Generic attribute is including but not limited to class object title, class object corresponding control name, class object first page, class object prevpage, class object the next page, class object last page.
The process of initialization class can be as follows:
Step S504: database root is according to query statement, and screening data in Query Database, generate data result table information;
Particularly, the query statement that database root is submitted to according to SAS client in step S500, can carry out data query, include client screening conditions in described query statement.By screening conditions, GP database can screen the data in database, and described screening conditions are including but not limited to type of service, user profile, accounts information, Time Created etc.Such as, the data of number of different types may be comprised in GP database, database data total number is 80000, setting screening conditions are: extract the data of data setup time between August 30 30 days to 2014 July in 2014, by screening, filter out irrelevant data, obtain the data between August 30 30 days to 2014 July in 2014, data total number after screening is 50000, the data after screening are claimed to be result data, result data is stored in result data table, including but not limited to the size of data of result data in described result data table, data number, the data messages such as data type.
Step S506:SAS client receives data result table information;
Particularly, in step S504, database root according to described query statement, can inquire about and garbled data storehouse in data, by generate data result table, including but not limited to garbled data, data result table information etc. in described data result table; Described data result table information is including but not limited to database data size, database data total number information etc., and SAS client receives data result table information, and such as, it is that database comprises 50000 data that SAS client receives data result table information.
Class after initialization described in step S508:SAS client call, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data;
Particularly, SAS client call step S502 initialized class in advance, according to the described data result table information that step S506 receives, can obtain the data total number of described database, carry out paging extraction, obtain paged data to the data in database.Such as, receive data result table information, the data total number comprising described database in result table information is the information of 50000, is so 10000 according to the paging of user preset comprises data number in step S502 initialization class, calculates paged data one and have 5 pages.When the data in database are extracted in paging, when SAS client acquiescence represents first page data, acquiescence extracts 1-10000 article of data in database, when SAS client shows second page data, extract 10001-20000 article of data in database, when SAS client shows the 3rd page data, extract 20001-30000 article of data in database, when SAS client shows the 4th page data, extract 30001-40000 article of data in database, when SAS client shows the 5th page data, extract 40001-50000 article of data in database.
Step S510:SAS client downloads also shows the first page data of described database;
Particularly, SAS client extracts the data in described database in step S508 paging, after obtaining paged data, 1-10000 article of data in acquiescence downloading data result table, and be presented to user, namely described 1-10000 article of data give tacit consent to extraction first page paged data to SAS client, and the home record of registration and preservation current presentation page data.
Step S512:SAS client receives and turns over the request of getting page up or next page data;
Particularly, SAS client reception user A turns over and gets the page up of paged data or the request of next page data, paged data as current display is 1-10000 article of data (i.e. first page data), then SAS client can only be carried out turning over of next page data and got, and namely downloads 10001-20000 article of data to SAS client; If the paged data of current display is 40001-50000 article of data (i.e. last page data), then SAS client can only be carried out turning over of page up data and got, and namely downloads 30001-40000 article of data to SAS client; If the non-first page of the paged data of current display also non-final one page, so SAS client both can have been turned over and got page up paged data, also can turn over and take off one page paged data.
Step S514:SAS client transfers the class after described initialization;
Particularly, the initialization class for data page turning in step S502 is transferred, for carrying out data page turning to the paged data in described database.
Step S516:SAS client downloads also shows page up data or next page data of described database;
Particularly, according to the initialization class that step S514 transfers, by the home record of the current presentation page of step S510 registration and preservation, transfer and show the page up paged data of current presentation page or lower one page paged data.
The data set page number process obtaining page up data or next page data can be as follows:
Download and select 10000 data of the page up data of GP database or next page data can be as follows to SAS client process:
Step S518:SAS client receives and turns over the request of getting N page data;
Particularly, SAS client receives the request that user A turns over the N page data getting paged data, such as, receives user A and turns over the request of getting the 4th page of paged data.
Step S520:SAS client transfers the class after described initialization;
Particularly, the initialization class for data page turning in step S502 is transferred, for carrying out data paging to the paged data in described database.
Step S522:SAS client downloads also shows the N page data of described database;
Particularly, according to the initialization class that step S520 transfers, by the home record of the current presentation page of step S510 registration and preservation, download and show that ((N-1) * 10000+1)-N*10000 article data of paged data are to client.Such as, answer step S518 client to turn over to get the request of the 4th page data, download and show that 30001-40000 article of data of paged data are to SAS client.
The data set page number process obtaining N page data can be as follows:
Download and select 10000 articles of data of the N page data of GP database can be as follows to SAS client process:
See Fig. 6, it is the structural representation of the system of quick demonstrating data database data provided by the invention, the system 60 of quick demonstrating data database data can comprise: sending module 600, initialization module 602, receiver module 604, calling module 606, paging processing module 608, display module 610, wherein
Sending module 600 is for sending query statement to database, and described query statement is for inquiring about the data be stored in described database;
Initialization module 602 is used for the class of data page for initialization;
The data result table information inquired through the described query statement of described sending module 600 transmission that receiver module 604 returns for receiving database;
Calling module 606 is for calling the described initialization class in described initialization module 602;
The described data result table information of paging processing module 608 for receiving according to receiver module 604, and the initialization class that described calling module 606 calls, the data in described database are extracted in paging, obtain paged data;
Display module 610 for show by page that the paging of described paging processing module 608 transfers the paged data of described database.
Will be understood that, the system 60 of the quick demonstrating data database data in the embodiment of the present invention can for being provided with the electronic equipment of SAS client, and described electronic equipment is including but not limited to personal computer, communication handset, panel computer etc.
Again particularly, see Fig. 7, it is the structural representation of another embodiment of the system of quick demonstrating data database data provided by the invention, the system 60 of quick demonstrating data database data can comprise outside sending module 600, initialization module 602, receiver module 604, calling module 606, paging processing module 608, display module 610, can also comprise database 601, page processing module 612 and paging processing module 614;
That is, the system 60 of the quick demonstrating data database data in the embodiment of the present invention except can comprise SAS client is installed electronic equipment except, the database in the embodiment of the present invention can also be integrated with; Or this electronic equipment being provided with SAS client is integrated with database;
After database 601 may be used for the described query statement of reception client transmission, according to described default screening conditions, the data in described database are carried out to the screening of extraneous data, inquire about and generate data result table information after screening the data in described database, and described data result table information is sent to SAS client, described data result table information is including but not limited to database data size, database data total number information etc.
Initialization module 602 can comprise initialization data paging unit 60200 and initialization data page turning unit 60202, wherein
Initialization data paging unit 60200 may be used for initialization for obtaining the variable of the data total number of described database; The data number that every page data comprises can be preset according to paging demand; The data number that can comprise according to initialized data total number variable and described default every page data, can initialization for calculating the function of the data total page number of database;
Initialization data page turning unit 60202 is used for the class of data page turning for initialization, and described data page turning class can comprise that turning over of page up data is got, turning over of next page data is got or turning over of N page data is got; Described N is natural number, and described N is not more than data total page number;
The described initialization data page turning unit 60202 initialized class of page processing module 612 for transferring according to calling module 606, turn over get current presentation page page up paged data or lower one page paged data to client;
The described initialization data page turning unit 60202 initialized class of paging processing module 614 for transferring according to calling module 606, transfers and shows that the paged data transferred required by client is to client.
See Fig. 8, be the structural representation of initialization data paging unit provided by the invention, initialization data paging unit 60200 can comprise initializing variable unit 602001, preset unit 602002 and initialization paging function unit 602003, wherein
Initializing variable unit 602001, for initialization for obtaining the variable of the data total number of described database;
Preset unit 602002, for presetting the data number that every page data comprises according to paging demand;
Initialization paging function unit 602003, for the data number that the every page data preset according to described initializing variable unit 602001 initialized data total number variable and described default unit 602002 comprises, initialization is for calculating the function of the data total page number of database.
See Fig. 9, be the structural representation of paging processing module provided by the invention, paging processing module 608 can comprise the first receiving element 60800, assignment unit 60802, paging computing unit 60804, paging processing unit 60806, wherein
First receiving element 60800, for receiving the data result table information of the described database in described data result unit 60102, obtains the data total number of described database;
Assignment unit 60802 is for giving the described initialized variable of initializing variable unit 602001 described in described initialization data pagination module 60200 according to the described data total number assignment of described first receiving element 60800 acquisition;
Paging computing unit 60804 is for calling the function of initialization paging function unit 602003 in described initialization data pagination module 60200, preset according to the variable of described assignment unit 60802 assignment and described default unit 602002 the data number that every page data comprises, calculate the data total page number of database;
Paging extraction unit 60806 carries out paging for the data total page number calculated according to described paging computing unit 60804 and extracts data in described database, obtains paged data.
See Figure 10, be the structural representation of page processing module provided by the invention, page processing module 612 can comprise the second receiving element 61201, first and transfer unit 61202, page turning unit 61203, wherein
Second receiving element 61201 is for receiving the request of turning over and getting page up or next page data;
First transfers unit 61202 for transferring the class after the initialization of described initialization data page turning unit 60202;
The described initialized class for data page turning that page turning unit 61203 is transferred for transferring unit 61202 according to the request and described first of described second receiving element 61201, turns over and gets and show the page up data of described paged data or next page data of described paged data.
See Figure 11, be the structural representation of paging processing module provided by the invention, paging processing module 614 can comprise the 3rd receiving element 61401, second and transfer unit 61402, paging unit 61403, wherein
3rd receiving element 61401 is for receiving the request of turning over and getting N page data, and described N is natural number, and N is not more than described data total page number;
Second transfers unit 61402 for transferring the class after the initialization of described initialization data page turning unit 60202;
The described initialized class for data paging that paging unit 61403 is transferred for transferring unit 61402 according to the instruction and described second of described 3rd receiving element 61401, turns over and gets and show the N page paged data of described database.
It should be noted that, the system of the quick demonstrating data database data in the embodiment of the present invention can for being provided with the electronic equipment of SAS client, and this electronic equipment includes but not limited to personal computer, mobile phone, panel computer etc.; The system of this quick demonstrating data database data can also be integrated with the database in the embodiment of the present invention, and the electronic equipment being provided with SAS client with this carries out data interaction.Or the system of the quick demonstrating data database data in the embodiment of the present invention can be integrated with database for the electronic equipment being provided with SAS client.
In sum, by implementing the embodiment of the present invention, there is following beneficial effect:
1, according to the data cases of database and self needs of user, after judging to obtain the result sizes of data result table information, paging displaying is carried out to the data in database, and can Appropriate application SAS client space, prevent space from having a full house;
2, expand in platform interactive display data at SAS client and GP database, control for user provides a kind of, the method for hommization, control with user that line number obtains, paging display data, enable user's repeatedly multipage access result set;
3, the class after initialization, supports to control the calling of paging method, realizes the demand of user's page turning, and can meet user and turn over the demand of getting any one page paged data.
One of ordinary skill in the art will appreciate that all or part of flow process realized in above-described embodiment method, that the hardware that can carry out instruction relevant by computer program has come, described program can be stored in a computer read/write memory medium, this program, when performing, can comprise the flow process of the embodiment as above-mentioned each side method.Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, ROM) or random store-memory body (Random Access Memory, RAM) etc.
Above disclosedly be only a kind of preferred embodiment of the present invention, certainly the interest field of the present invention can not be limited with this, one of ordinary skill in the art will appreciate that all or part of flow process realizing above-described embodiment, and according to the equivalent variations that the claims in the present invention are done, still belong to the scope that invention is contained.
Claims (16)
1. a method for quick demonstrating data database data, is characterized in that, comprising:
Send query statement to database, described query statement is for inquiring about the data be stored in database;
Initialization is used for the class of data page;
Receive the data result table information inquired through described query statement that database returns;
Call the class after described initialization, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data;
Described paged data is shown by page.
2. the method for quick demonstrating data database data as claimed in claim 1, it is characterized in that, described query statement comprises default screening conditions, after receiving described query statement to make described database, according to described default screening conditions, the data in described database are carried out to the screening of extraneous data, inquire about and generate data result table after screening the data in described database.
3. the method for quick demonstrating data database data as claimed in claim 1, it is characterized in that, described initialization is used for the class of data page, comprising:
Initialization is for obtaining the variable of the data total number of described database;
The data number that every page data comprises is preset according to paging demand;
According to the data number that data total number and described default every page data of described database comprise, initialization is for calculating the function of the data total page number of database.
4. the method for quick demonstrating data database data as claimed in claim 1, it is characterized in that, described initialization is used for the class of data page, comprising:
Initialization is used for the class of data page turning, and described data page turning class comprises that turning over of page up data is got, turning over of next page data is got or turning over of N page data is got; Described N is natural number, and described N is not more than data total page number.
5. the method for quick demonstrating data database data as claimed in claim 3, is characterized in that, described in call the class after described initialization, according to the described data result table information received, the data in described database are extracted in paging, obtain paged data and comprise:
According to the data result table information of the described database received, obtain the data total number of described database, give described initialized variable by the described data total number assignment of acquisition;
Call described initialized function, according to the variable after described assignment and the described data number preset every page data and comprise, calculate the data total page number of database;
Carry out paging according to described data total page number and extract data in described database, obtain paged data.
6. the method for quick demonstrating data database data as claimed in claim 1, is characterized in that, describedly shows that described paged data comprises by page: the first page data in acquiescence display data storehouse.
7. the method for quick demonstrating data database data as claimed in claim 4, is characterized in that, when described data page turning class comprise page up data turn over get with next page data turn over get time, described show described paged data by page after comprise:
Receive and turn over the request of getting page up or next page data;
Transfer the class after described initialization;
According to described request and the described initialized class for data page turning, turn over and get and show the page up data of described paged data or next page data of described paged data.
8. the method for quick demonstrating data database data as claimed in claim 4, is characterized in that, when described data page turning class comprise N page data turn over get time, described show described paged data by page after comprise:
Receive and turn over the request of getting N page data, described N is natural number, and N is not more than described data total page number;
Transfer the class after described initialization;
According to described instruction and the described initialized class for data page turning, turn over and get and show the N page paged data of described database.
9. a system for quick demonstrating data database data, is characterized in that, comprising:
Sending module, for sending query statement to database, described query statement is for inquiring about the data be stored in database;
Initialization module, is used for the class of data page for initialization;
Receiver module, for receiving the data result table information inquired through described query statement that database returns;
Calling module, for calling the described initialization class of described initialization module;
Paging processing module, for the described data result table information received according to receiver module, and the initialization class that described calling module calls, the data in described database are extracted in paging, obtain paged data;
Display module, for showing described paged data by page.
10. the system of quick demonstrating data database data as claimed in claim 9, it is characterized in that, described query statement comprises default screening conditions; Described system also comprises database, after receiving described query statement, according to described default screening conditions, the data in described database is carried out to the screening of extraneous data, inquires about and generates data result table after screening the data in described database.
The system of 11. quick demonstrating data database datas as claimed in claim 9, it is characterized in that, described initialization module comprises initialization data paging unit, and described initialization data paging unit comprises:
Initializing variable unit, for initialization for obtaining the variable of the data total number of described database;
Preset unit, for presetting the data number that every page data comprises according to paging demand;
Initialization paging function unit, the data number that the every page data for presetting according to described initializing variable unit initialized data total number variable and described default unit comprises, initialization is for calculating the function of the data total page number of database.
The system of 12. quick demonstrating data database datas as claimed in claim 9, it is characterized in that, described initialization module comprises initialization data page turning unit, be used for the class of data page turning for initialization, described data page turning class comprises that turning over of page up data is got, turning over of next page data get or turning over of N page data is got; Described N is natural number, and described N is not more than data total page number.
The system of 13. quick demonstrating data database datas as claimed in claim 11, it is characterized in that, described paging processing module comprises:
First receiving element, for receiving the data result table information of the described database in data result unit, obtains the data total number of described database;
Assignment unit, for giving described initialized variable according to the described data total number assignment of described first receiving element acquisition;
Paging computing unit, for call described initialization paging function unit function, preset according to the variable of described assignment unit assignment and described default unit the data number that every page data comprises, calculate the data total page number of database;
Paging extraction unit, the data total page number for calculating according to described paging computing unit carries out paging and extracts data in described database, obtains paged data.
The system of 14. quick demonstrating data database datas as claimed in claim 9, it is characterized in that, described display module is specifically for the first page data in acquiescence display data storehouse.
The system of 15. quick demonstrating data database datas as claimed in claim 12, it is characterized in that, system also comprises page processing module, and described page processing module comprises:
Second receiving element, for comprise when described data page turning class page up data turn over get with next page data turn over get time, described display module shows the paged data of the described database of described paging process by page after, receive and turn over the request of getting page up or next page data;
First transfers unit, for transferring the class after the initialization of described initialization data page turning unit;
Page turning unit, for transferring the described initialized class for data page turning that unit is transferred according to the request and described first of described second receiving element, turns over and gets and show the page up data of described paged data or next page data of described paged data.
The system of 16. quick demonstrating data database datas as claimed in claim 12, it is characterized in that, system also comprises paging processing module, and described paging processing module comprises:
3rd receiving element, for comprise when described data page turning class N page data turn over get time, described display module shows the paged data of the described database of described paging process by page after, receive turn over the request of getting N page data, described N is natural number, and N is not more than described data total page number;
Second transfers unit, for transferring the class after the initialization of described initialization data page turning unit;
Paging unit, for transferring the described initialized class for data paging that unit is transferred according to the instruction and described second of described 3rd receiving element, turns over and gets and show the N page paged data of described database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410594799.1A CN104361049A (en) | 2014-10-29 | 2014-10-29 | Method and system for quickly expressing data of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410594799.1A CN104361049A (en) | 2014-10-29 | 2014-10-29 | Method and system for quickly expressing data of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104361049A true CN104361049A (en) | 2015-02-18 |
Family
ID=52528310
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410594799.1A Pending CN104361049A (en) | 2014-10-29 | 2014-10-29 | Method and system for quickly expressing data of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104361049A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104615726A (en) * | 2015-02-06 | 2015-05-13 | 北京神舟航天软件技术有限公司 | Method for displaying a large number of business objects based on lazy loading technique |
| CN106776597A (en) * | 2015-11-19 | 2017-05-31 | 阿里巴巴集团控股有限公司 | The method for down loading and device of structural data |
| CN107783978A (en) * | 2016-08-24 | 2018-03-09 | 中安消物联传感（深圳）有限公司 | A kind of big data inquiry return method and device |
| CN110321388A (en) * | 2019-02-26 | 2019-10-11 | 南威软件股份有限公司 | A kind of quicksort querying method and system based on Greenplum |
| CN110955680A (en) * | 2019-10-10 | 2020-04-03 | 珠海格力电器股份有限公司 | Data paging query method based on HBase |
| CN111125157A (en) * | 2018-10-31 | 2020-05-08 | 北京国双科技有限公司 | Query data processing method and device, storage medium and processor |
| CN112445833A (en) * | 2019-08-30 | 2021-03-05 | 普天信息技术有限公司 | Data paging query method, device and system for distributed database |
| CN113407605A (en) * | 2021-05-21 | 2021-09-17 | 上汽通用五菱汽车股份有限公司 | Database interaction method and system and readable storage medium |
| CN116302566A (en) * | 2023-05-12 | 2023-06-23 | 深圳市新蕾电子有限公司 | Global variable customizable memory management method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110106841A1 (en) * | 2009-10-30 | 2011-05-05 | International Business Machines Corporation | Method and system of saving and querying context data for online applications |
| CN102289473A (en) * | 2011-07-27 | 2011-12-21 | 迈普通信技术股份有限公司 | Device and method for paging query of a plurality of servers |
| CN102521296A (en) * | 2011-11-30 | 2012-06-27 | 向进轮 | Method for screening data items in separated pages of web page |
| CN103617232A (en) * | 2013-11-26 | 2014-03-05 | 北京京东尚科信息技术有限公司 | Paging inquiring method for HBase table |
| CN103873897A (en) * | 2014-03-21 | 2014-06-18 | 珠海迈科电子科技有限公司 | Android smart television UI pagination display method |
-
2014
- 2014-10-29 CN CN201410594799.1A patent/CN104361049A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110106841A1 (en) * | 2009-10-30 | 2011-05-05 | International Business Machines Corporation | Method and system of saving and querying context data for online applications |
| CN102289473A (en) * | 2011-07-27 | 2011-12-21 | 迈普通信技术股份有限公司 | Device and method for paging query of a plurality of servers |
| CN102521296A (en) * | 2011-11-30 | 2012-06-27 | 向进轮 | Method for screening data items in separated pages of web page |
| CN103617232A (en) * | 2013-11-26 | 2014-03-05 | 北京京东尚科信息技术有限公司 | Paging inquiring method for HBase table |
| CN103873897A (en) * | 2014-03-21 | 2014-06-18 | 珠海迈科电子科技有限公司 | Android smart television UI pagination display method |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104615726A (en) * | 2015-02-06 | 2015-05-13 | 北京神舟航天软件技术有限公司 | Method for displaying a large number of business objects based on lazy loading technique |
| CN104615726B (en) * | 2015-02-06 | 2017-12-22 | 北京神舟航天软件技术有限公司 | A kind of method based on slow loading technique displaying a large number of services object |
| CN106776597A (en) * | 2015-11-19 | 2017-05-31 | 阿里巴巴集团控股有限公司 | The method for down loading and device of structural data |
| CN106776597B (en) * | 2015-11-19 | 2020-07-03 | 阿里巴巴集团控股有限公司 | Structured data downloading method and device |
| CN107783978A (en) * | 2016-08-24 | 2018-03-09 | 中安消物联传感（深圳）有限公司 | A kind of big data inquiry return method and device |
| CN111125157A (en) * | 2018-10-31 | 2020-05-08 | 北京国双科技有限公司 | Query data processing method and device, storage medium and processor |
| CN111125157B (en) * | 2018-10-31 | 2023-07-04 | 北京国双科技有限公司 | Query data processing method and device, storage medium and processor |
| CN110321388A (en) * | 2019-02-26 | 2019-10-11 | 南威软件股份有限公司 | A kind of quicksort querying method and system based on Greenplum |
| CN112445833A (en) * | 2019-08-30 | 2021-03-05 | 普天信息技术有限公司 | Data paging query method, device and system for distributed database |
| CN110955680A (en) * | 2019-10-10 | 2020-04-03 | 珠海格力电器股份有限公司 | Data paging query method based on HBase |
| CN113407605A (en) * | 2021-05-21 | 2021-09-17 | 上汽通用五菱汽车股份有限公司 | Database interaction method and system and readable storage medium |
| CN116302566A (en) * | 2023-05-12 | 2023-06-23 | 深圳市新蕾电子有限公司 | Global variable customizable memory management method |
| CN116302566B (en) * | 2023-05-12 | 2023-08-18 | 深圳市新蕾电子有限公司 | Global variable customizable memory management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104361049A (en) | Method and system for quickly expressing data of database | |
| CN104253741B (en) | A kind of method for sending information, relevant apparatus and system | |
| CN109889426B (en) | Information processing method, device and system based on instant messaging | |
| CN103309998A (en) | Message query method, message query device and terminal equipment | |
| US9578119B2 (en) | Method, server, and client for pushing and displaying splash screen | |
| CN104426985B (en) | Show the method, apparatus and system of webpage | |
| Brown | Supporting user mobility | |
| CN104246748A (en) | A system and a method for determining context | |
| CN105701122A (en) | Log collection method, apparatus and system | |
| CN111654382B (en) | Message processing method, device, computer equipment and computer readable storage medium | |
| CN102622444A (en) | XML (extensible markup language) message processing method and XML message processing device | |
| WO2012102761A1 (en) | Method and system for providing detailed information in an interactive manner in a short message service (sms) environment | |
| CN102790727A (en) | Method and system for dynamically pushing personal labels of users | |
| CN105487640A (en) | Image pre-loading and caching method of Android watch | |
| US9571443B2 (en) | Mobile device message enabled on-line community bulletin board | |
| CN102655538A (en) | Method and system for intelligently creating schedules | |
| WO2013170674A1 (en) | Method and system for seamless webpage browsing | |
| CN101895531A (en) | Client equipment, multimedia data unloading system and unloading method | |
| CN112181678A (en) | Service data processing method, device and system, storage medium and electronic device | |
| CN104035943A (en) | Data storage method and corresponding server | |
| JP6507263B2 (en) | Content filtering based on user mobile network and data plan | |
| CN103685485B (en) | Mobile terminal VoIP (voice over internet protocol) communication audio management system | |
| CN114817419A (en) | Kafka-based media asset data storage method and device, electronic equipment and storage medium | |
| CN102724290A (en) | Method, device and system for getting target customer group | |
| CN103853347B (en) | Information release method based on gravity sensing horizontal screen display of mobile terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150218 |
|
| RJ01 | Rejection of invention patent application after publication |