CN111382204B

CN111382204B - Hbase database processing method and device based on webpage interface

Info

Publication number: CN111382204B
Application number: CN202010159697.2A
Authority: CN
Inventors: 张世瑛; 赵吉昆; 梁晔华; 杨嘉欣
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2020-03-09
Filing date: 2020-03-09
Publication date: 2024-01-05
Anticipated expiration: 2040-03-09
Also published as: CN111382204A

Abstract

The present disclosure provides a method for processing Hbase database based on a web interface, comprising: in response to a user request, displaying a web page interface, wherein the web page interface comprises an information input box, at least one execution button and a result display box, in response to one of the at least one execution buttons triggered by a user, acquiring input information in the information input box, generating an Hbase database sentence based on the input information and the triggered execution button, executing the Hbase database sentence in an Hbase database to obtain an execution result, and displaying the execution result in the result display box.

Description

Hbase database processing method and device based on webpage interface

Technical Field

The present disclosure relates to the field of computer technology, and more particularly, to a method, an apparatus, a computer system, and a computer readable medium for processing an Hbase database based on a web interface.

Background

With the rapid development of the network age, big data are increasingly applied to various scenes such as work and life, and various databases are generated for better storing the big data. The Hbase database is a highly reliable, high performance, column-oriented, scalable distributed column-type storage system. The Hbase technology can be used for constructing a large-scale structured storage cluster on a server, and as the Hbase technology has a great advantage in processing big data, more and more enterprises and institutions select Hbase database clusters to store and process data.

In the process of implementing the inventive concept, the inventor finds that at least the following problems exist in the related art: when using Hbase database, business personnel need to know the using statement of Hbase shell, the technical background of business personnel is required too high, and the operation is not convenient enough.

Disclosure of Invention

In view of this, the present disclosure provides a method, an apparatus, a computer system, and a computer readable medium for processing an Hbase database based on a web interface.

One aspect of the present disclosure provides a method for processing an Hbase database based on a web interface, including: in response to a user request, displaying a web page interface, wherein the web page interface comprises an information input box, at least one execution button and a result display box, in response to one of the at least one execution button triggered by a user, obtaining input information in the information input box, generating an Hbase database sentence based on the input information and the triggered execution button, executing the Hbase database sentence in the Hbase database to obtain an execution result, and displaying the execution result in the result display box.

According to an embodiment of the present disclosure, the information input box includes: hbase table name input box, the at least one execution button includes: a table data amount query button, and said generating Hbase database statement based on said input information and said triggered execution button, comprising: and generating a data amount inquiry command of the Hbase database based on the table name information in the Hbase table name input frame and the table data amount inquiry button.

According to an embodiment of the present disclosure, the information input box includes: hbase table name input box and main key input box, at least one execution button includes: pressing a primary key query button, wherein the generating Hbase database statement based on the input information and the triggered execution button comprises the following steps: and generating a query data content command of the Hbase database based on the table name information in the Hbase table name input box, the main key information in the main key input box and the main key query button.

According to an embodiment of the present disclosure, the primary key input box includes: a first primary key input box and a second primary key input box, the pressing of the primary key query button comprising: pressing a first primary key query button and pressing the first primary key plus a second primary key query button.

According to an embodiment of the present disclosure, the information input box includes: hbase table name input box and upload data button, the method further includes: and responding to the user triggering the uploading data button to acquire a data file, wherein the at least one execution button comprises: a data writing button, which generates Hbase database sentences based on the input information and the triggered execution buttons, comprising: and generating a data writing command of the Hbase database based on the table name information, the data file and the data writing button in the Hbase table name input box.

According to an embodiment of the present disclosure, the generating a data writing command of an Hbase database based on the table name information in the Hbase table name input box, the data file, and the data writing button includes: analyzing the data file, obtaining column name information and a field value corresponding to the column name information in the data file, instantiating a data writing object based on the table name information, the column name information, column family name information corresponding to the column name information and the field value to obtain an instantiated object, and generating a data writing command of an Hbase database based on the instantiated object.

According to an embodiment of the disclosure, the displaying the execution result in the result display box includes: printing the execution result obtained in the Hbase database into a log, obtaining the execution result from the log, and uploading the execution result to the webpage interface so that the webpage interface displays the execution result through the result display frame.

Another aspect of the present disclosure provides an Hbase database processing apparatus based on a web interface, where the apparatus includes a first display module, a first acquisition module, a generation module, an execution module, and a second display module. The first display module is used for responding to a user request and displaying a webpage interface, and the webpage interface comprises an information input frame, at least one execution button and a result display frame. The first acquisition module is used for responding to the triggering of one of the at least one execution buttons by a user and acquiring input information in the information input box. The generation module is used for generating Hbase database statement based on the input information and the triggered execution button. The execution module is used for executing the Hbase database statement in the Hbase database to obtain an execution result. And the second display module is used for displaying the execution result in the result display frame.

According to an embodiment of the present disclosure, the information input box includes: hbase table name input box and upload data button. The apparatus further comprises: and the second acquisition module is used for responding to the triggering of the uploading data button by the user and acquiring the data file. The at least one execution button includes: a data write button. The generating Hbase database statement based on the input information and the triggered execution button includes: and generating a data writing command of the Hbase database based on the table name information, the data file and the data writing button in the Hbase table name input box.

Another aspect of the present disclosure provides a computer system comprising: one or more processors, storage means for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method as described above.

Another aspect of the present disclosure provides a computer-readable medium storing computer-executable instructions that, when executed, are configured to implement a method as described above.

Another aspect of the present disclosure provides a computer program comprising computer executable instructions which when executed are for implementing a method as described above.

According to the embodiment of the disclosure, the problems that the Hbase database operation in the related technology has too high requirements on technical background of service personnel and is not convenient to operate can be at least partially solved, and therefore the convenience of Hbase database operation can be improved, and the service personnel without the technical background can independently complete flexible operation on the Hbase database, so that the technical effect of using the Hbase database is greatly reduced.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments thereof with reference to the accompanying drawings in which:

FIG. 1 schematically illustrates an application scenario of a method and apparatus for processing Hbase database based on a web page interface according to an embodiment of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a Hbase database processing method based on a web page interface according to an embodiment of the present disclosure;

FIG. 3A schematically illustrates a flow chart of a method for querying table data amount of a Hbase database based on a web page interface according to an embodiment of the present disclosure;

FIG. 3B schematically illustrates a flow chart of a method of querying data content of a Hbase database based on a web page interface according to an embodiment of the present disclosure;

FIG. 3C schematically illustrates a flow chart of a method of writing data to a Hbase database based on a web page interface according to an embodiment of the present disclosure;

FIG. 4 schematically shows a block diagram of a Hbase database processing apparatus based on a web page interface according to an embodiment of the present disclosure; and

fig. 5 schematically illustrates a block diagram of a computer system according to an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The words "a", "an", and "the" as used herein are also intended to include the meaning of "a plurality", etc., unless the context clearly indicates otherwise. Furthermore, the terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.

Where expressions like at least one of "A, B and C, etc. are used, the expressions should generally be interpreted in accordance with the meaning as commonly understood by those skilled in the art (e.g.," a system having at least one of A, B and C "shall include, but not be limited to, a system having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). Where a formulation similar to at least one of "A, B or C, etc." is used, in general such a formulation should be interpreted in accordance with the ordinary understanding of one skilled in the art (e.g. "a system with at least one of A, B or C" would include but not be limited to systems with a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). It should also be appreciated by those skilled in the art that virtually any disjunctive word and/or phrase presenting two or more alternative items, whether in the description, claims, or drawings, should be understood to contemplate the possibilities of including one of the items, either of the items, or both. For example, the phrase "a or B" should be understood to include the possibility of "a" or "B", or "a and B".

The embodiment of the disclosure provides a method and a device for processing an Hbase database based on a webpage interface. The method comprises the following steps: in response to a user request, a web page interface is displayed, wherein the web page interface comprises an information input box, at least one execution button and a result display box, in response to one of the at least one execution button being triggered by a user, input information in the information input box is acquired, hbase database sentences are generated based on the input information and the triggered execution buttons, the Hbase database sentences are executed in an Hbase database, an execution result is obtained, and the execution result is displayed in the result display box.

Fig. 1 schematically illustrates an application scenario 100 of a web interface-based Hbase database processing method and apparatus according to an embodiment of the present disclosure.

As shown in fig. 1, an application scenario 100 according to this embodiment may include terminal devices 101, 102, 103, a network 104, a server 105, and an Hbase database 106. The network 104 may be a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 101, 102, 103.

The terminal devices 101, 102, 103 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by users using the terminal devices 101, 102, 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

Hbase database 106 can be a database or a database cluster that stores business data. According to an embodiment of the present disclosure, the server 105 may interact with the Hbase database 106.

It should be noted that, the Hbase database processing method based on the web page interface provided in the embodiments of the present disclosure may be generally executed by the server 105. Accordingly, the Hbase database processing apparatus based on the web interface provided in the embodiments of the present disclosure may be generally disposed in the server 105. The Hbase database processing method based on the web page interface provided by the embodiments of the present disclosure may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105. Accordingly, the Hbase database processing apparatus based on a web interface provided in the embodiments of the present disclosure may also be provided in a server or a server cluster, which is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105.

For example, a user may initiate a request to the server 105 through any one of the terminal devices 101, 102, 103 (e.g., but not limited to, the terminal device 101), and the server 105 may send a web page interface to the terminal device 101 in response to the user request for the terminal device 101 to present the web page interface. The server 105 may also obtain input information in an information input box of the web page interface in response to the user triggering an execution button in the web page interface through the terminal device 101, and generate an Hbase database statement based on the input information and the triggered execution button. Then, the Hbase database statement is executed in the Hbase database 106 to obtain an execution result, and the server 105 sends the execution result to the terminal device 101, so that the terminal device 101 displays the execution result in a result display frame of the web page interface. Therefore, the user can obtain the execution result in the Hbase database in the webpage interface only by inputting information and triggering the execution button in the corresponding webpage interface through the terminal equipment, the operation is convenient, the user does not need to know Hbase sentences, the threshold is reduced, and the working efficiency is improved.

It should be understood that the number of terminal devices, networks, servers and Hbase databases in fig. 1 is only illustrative. There may be any number of terminal devices, networks, servers and Hbase databases, as desired for implementation.

FIG. 2 schematically shows a flowchart of a Hbase database processing method based on a web page interface according to an embodiment of the present disclosure.

As shown in fig. 2, the method includes operations S201 to S205.

In operation S201, a web interface including an information input box, at least one execution button, and a result presentation box is presented in response to a user request.

According to the embodiment of the disclosure, the webpage interface can be displayed in response to the user request, the webpage interface can be convenient for the user to operate, and the complicated program for installing the software is reduced.

In embodiments of the present disclosure, the web page interface may include an information input box that may be used to receive input information from a user. For example, hbase data cluster information, hbase table name information, primary key information, and the like. The information input box in the embodiment of the present disclosure may be a selection drop-down box or may also be a text input box. The user can input or select in the corresponding information input box according to actual needs.

In embodiments of the present disclosure, the web page interface may also include at least one execution button. For example, a table data amount query button may be included for querying data amount information in the corresponding data table. Alternatively, a data content query button may be included for querying the relevant content in the corresponding data table based on the primary key information or other information. Alternatively, a data write button may be included for writing data into the corresponding data table. It will be appreciated that the present disclosure is not limited to the number and type of execution buttons in a web interface, and those skilled in the art may set the execution buttons in a page according to actual needs.

In embodiments of the present disclosure, the web page interface may also include a results presentation box. The result display frame can display the execution result obtained in the Hbase database, so that a user can operate the Hbase database under the condition of opening a webpage interface, and meanwhile, the execution result is obtained, the direct Hbase data of the user is avoided, the use threshold of the Hbase database is reduced, and the operation of the user is facilitated. Meanwhile, the risk of misoperation possibly brought by direct operation of Hbase database by non-professional staff is avoided.

In operation S202, input information in an information input box is acquired in response to a user triggering one of at least one execution button.

According to the embodiment of the disclosure, input information in all information input boxes can be acquired in response to a user triggering a certain execution button. It is also possible to acquire only input information in the information input box related to a certain execution button in response to the user triggering the execution button.

For example, the information input boxes include an Hbase cluster selection drop-down box, an Hbase table name selection drop-down box, a primary key input box, and the like. In response to user actuation of the table data volume query button, only input information in the cluster selection drop-down box and the Hbase table name selection drop-down box may be obtained.

In operation S203, an Hbase database statement is generated based on the input information and the activated execution button.

According to the embodiment of the disclosure, a statement which can be identified by the Hbase database can be generated based on the triggered execution button and the input information related to the button. For example, a count statement of the Hbase shell may be generated based on the table data amount query button.

According to the embodiment of the disclosure, the cost of learning the database statement by the user can be avoided by automatically generating the statement supported by the Hbase database, and the bridge for connecting the user and the Hbase database is provided, so that the operation of the user is convenient.

In operation S204, an Hbase database statement is executed in the Hbase database, resulting in an execution result.

According to the embodiment of the disclosure, the generated statement which can be supported by the Hbase database can be input into the Hbase database, so that the Hbase database can execute the statement, and the corresponding execution result is printed into a log.

In operation S205, the execution result is displayed in the result display frame.

According to the embodiment of the disclosure, the execution result obtained in the Hbase database is printed into the log, and then the execution result is obtained from the log and uploaded to the webpage interface, so that the webpage interface displays the execution result through the result display frame.

According to the webpage interface provided by the embodiment of the disclosure, a user can realize the operation of the Hbase database by visually and intuitively inputting simple information under the condition of opening one webpage interface, and an execution result can be obtained at the same time on the webpage interface, so that the Hbase database is prevented from being directly faced by the user, the user does not need to master the operation language of the Hbase database, the use threshold of the Hbase database is reduced, and the operation of the user is facilitated.

The embodiment of the disclosure fills the technical blank of real-time operation of the Hbase non-web interface of the column-type storage database, realizes that business personnel without technical background can independently and independently complete flexible operation of the distributed column-type storage database data, and greatly reduces the use threshold of the technology. Meanwhile, the risk of misoperation possibly brought by direct operation of Hbase database by non-professional staff is avoided. The method illustrated in fig. 2 is further described below with reference to fig. 3A-3C in conjunction with the exemplary embodiment.

FIG. 3A schematically shows a flow chart of a method for querying the table data amount of a Hbase database based on a web page interface according to an embodiment of the present disclosure.

As shown in FIG. 3A, the method includes operations S301A-S305A

In operation S301A, a web interface including an information input box, at least one execution button, and a result presentation box is presented in response to a user request. Wherein the information input box comprises an Hbase table name input box, and the at least one execution button comprises a table data amount query button.

According to the embodiment of the disclosure, in the case that the corresponding service only includes one Hbase database cluster, the information input box may only include a table name selection drop-down box of each Hbase table in the cluster. In case the corresponding service comprises a plurality of Hbase database clusters, the information input box may comprise an environment selection drop-down box and an Hbase table name selection drop-down box.

It is appreciated that embodiments of the present disclosure may include a plurality of Hbase database clusters, each cluster may correspond to an environment. Therefore, the embodiment of the disclosure may select a drop-down box according to the Hbase database cluster setting environments included, and set an Hbase table name according to the Hbase tables included in each environment, so that a user may select a certain Hbase table in a certain Hbase database cluster that is desired to be processed.

In the embodiment of the disclosure, a user can select a data table to be processed in the environment selection drop-down frame and the Hbase table name selection drop-down frame and then click a table data amount query button to query the data amount in the selected data table.

In operation S302A, input information in an information input box is acquired in response to user actuation of a table data volume query button.

According to the embodiment of the disclosure, the input information selected by the user in the environment selection drop-down box and the Hbase table name selection drop-down box can be acquired in response to the user triggering the table data amount query button.

In operation S303A, a data amount inquiry command of the Hbase database is generated based on the table name information in the Hbase table name input box and the table data amount inquiry button.

According to the embodiment of the disclosure, the operation object can be determined based on the information in the environment selection drop-down box and the Hbase table name selection drop-down box. Then, a data amount inquiry command (for example, a count command of the Hbase shell) that can be supported by the Hbase database is generated based on the operation object.

In operation S304A, a data amount inquiry command is executed in the Hbase database, resulting in an execution result.

According to the embodiment of the disclosure, the generated data amount inquiry command which can be supported by the Hbase database can be input into the Hbase database, so that the Hbase database can execute the command and print the corresponding execution result into a log.

In operation S305A, the execution result is displayed in the result display frame. According to the embodiment of the present disclosure, operation S305A is the same as or similar to operation S205 described above with reference to fig. 2, and will not be described again here.

According to the webpage interface provided by the embodiment of the disclosure, a user can realize the table data volume query operation of the Hbase database by visually and intuitively inputting simple information under the condition of opening one webpage interface, and the data volume query result can be obtained at the same time on the webpage interface, so that the Hbase database is prevented from being directly faced by the user, the user does not need to master the operation language of the Hbase database, the use threshold of the Hbase database is reduced, and the operation of the user is facilitated.

The embodiment of the disclosure fills the technical blank of real-time operation of the Hbase non-web interface of the column-type storage database, realizes that business personnel without technical background can independently and independently complete flexible operation of the distributed column-type storage database data, and greatly reduces the use threshold of the technology.

FIG. 3B schematically shows a flow chart of a data content querying method of a Hbase database based on a web page interface according to an embodiment of the present disclosure.

As shown in FIG. 3B, the method includes operations S301B-S305B

In operation S301B, a web interface including an information input box, at least one execution button, and a result presentation box is presented in response to a user request. The information input box comprises an Hbase table name input box and a main key input box, and the at least one execution button comprises a main key pressing inquiry button.

According to the embodiment of the disclosure, in the case that the corresponding service only includes one Hbase database cluster, the information input box may include only a table name selection drop-down box and a primary key input box of each Hbase table in the cluster. In case the corresponding service comprises a plurality of Hbase database clusters, the information input box may comprise an environment selection drop-down box, an Hbase table name selection drop-down box and a primary key input box.

In the embodiment of the disclosure, a user can select a data table to be processed in an environment selection drop-down box and an Hbase table name selection drop-down box, input main key information in a main key input box, and then click a main key query button to search data content related to the main key information in the selected data table.

In some embodiments of the present disclosure, to further facilitate user operation, the primary key input box may include a first primary key input box and a second primary key input box. Pressing the primary key query button may include pressing a first primary key query button and pressing a first primary key plus a second primary key query button. Therefore, the query granularity can be improved, and the data content can be queried more accurately. For example, the first primary key may be a field such as a user information number, and the second primary key may be a field such as a time or place. In the embodiment of the disclosure, the first primary key and the second primary key query button may be used to query a data table for a record result set that includes both the first primary key and the second primary key. In operation S302B, input information in the information input box is acquired in response to a user trigger pressing a primary key query button.

According to the embodiment of the disclosure, input information in the environment selection drop-down box, the Hbase table name selection drop-down box and the main key input box can be acquired in response to the user triggering to press the main key query button.

In operation S303B, a query data content command of the Hbase database is generated based on the table name information in the Hbase table name input box, the primary key information in the primary key input box, and the pressing of the primary key query button.

According to the embodiment of the disclosure, the data table to be queried can be determined based on information in the environment selection drop-down box and the Hbase table name selection drop-down box. Then, a command for inquiring the data content which can be supported by the Hbase database is generated based on the primary key information and the data table to be inquired. For example, get commands of Hbase shell, such as get 'table name', 'rowkey value'.

In operation S304B, a query data content command is executed in the Hbase database, resulting in an execution result.

According to the embodiment of the disclosure, a command for inquiring data content which can be supported by the generated Hbase database can be input into the Hbase database, so that the Hbase database can execute the command and print a corresponding execution result into a log.

In operation S305B, the execution result is displayed in the result display frame. According to the embodiment of the present disclosure, operation S305B is the same as or similar to operation S205 described above with reference to fig. 2, and will not be described again here.

According to the webpage interface provided by the embodiment of the disclosure, a user can realize the query operation of the data content of the Hbase database by visually and intuitively inputting simple information under the condition of opening one webpage interface, and the data content meeting the query condition can be obtained at the same time on the webpage interface, so that the direct-sided Hbase database of the user is avoided, the user does not need to master the operation language of the Hbase database, the use threshold of the Hbase database is reduced, and the operation of the user is facilitated.

FIG. 3C schematically shows a flow chart of a method of writing data to a Hbase database based on a web page interface according to an embodiment of the present disclosure.

As shown in FIG. 3C, the method includes operations S301C-S306C

In operation S301C, a web interface including an information input box, at least one execution button, and a result presentation box is presented in response to a user request. The information input box comprises an Hbase table name input box and an uploading data button, and the at least one execution button comprises a data writing button.

According to an embodiment of the present disclosure, in a case where the corresponding service includes only one Hbase database cluster, the information input box may include a table name selection drop-down box of each Hbase table in the cluster. In case the corresponding service comprises a plurality of Hbase database clusters, the information input box may comprise an environment selection drop-down box and an Hbase table name selection drop-down box.

In operation S302C, a data file is acquired in response to a user triggering the upload data button.

In the embodiment of the disclosure, the web page interface may further include a template download button, and the user may obtain a data template through the template download button and add data to be written into the Hbase database to the data template according to a prompt in the data template. After the addition is completed, the user can click on an upload data button in the webpage interface, and upload the added data template to the webpage interface so that the background server can obtain the data file.

In operation S303C, input information in the information input box is acquired in response to the user triggering the data write button.

According to the embodiment of the disclosure, a user can select a data table to be written with data in an environment selection drop-down frame and an Hbase table name selection drop-down frame, upload a data file through an upload data button, and then click a data writing button to write the data in the data file into the data table to be written.

In the embodiment of the disclosure, the input information of the environment selection drop-down box, the Hbase table name selection drop-down box and the data file uploaded by the user through the uploading button can be obtained in response to the user triggering the data writing button.

In operation S304C, a data write command of the Hbase database is generated based on the table name information, the data file, and the data write button in the Hbase table name input box.

According to the embodiment of the disclosure, the data table in which data is to be written can be determined based on information in the environment selection drop-down box and the Hbase table name selection drop-down box. Then, a data write command supportable by the Hbase database is generated based on the data file and the data table to be written.

In the embodiment of the disclosure, a data file may be parsed to obtain column name information and a field value corresponding to the column name information in the data file, a data writing object is instantiated based on the table name information, the column name information, column family name information corresponding to the column name information and the field value to obtain an instantiated object, and a data writing command of an Hbase database is generated based on the instantiated object.

For example, a data file is read, a field value of each column is obtained as a List < DataObject >, an Htable object is instantiated, a put object is instantiated according to the obtained table name information, column family name information, column name information and field value, a put request "put (String tableName, list < DataObject > put)" is submitted, and the Htable object is closed.

In operation S305C, a data write command is executed in the Hbase database, resulting in an execution result.

According to the embodiment of the disclosure, the generated data writing command which can be supported by the Hbase database can be input into the Hbase database, so that the Hbase database can execute the command and print the corresponding execution result into a log.

In operation S306C, the execution result is displayed in the result display frame. According to the embodiment of the present disclosure, operation S306C is the same as or similar to operation S205 described above with reference to fig. 2, and will not be described again here.

According to the webpage interface provided by the embodiment of the disclosure, a user can visually input simple information through the visual interface under the condition of opening one webpage interface, so that data writing operation on the Hbase database can be realized, the user is prevented from directly reading the Hbase database, the user does not need to master the operation language of the Hbase database, the use threshold of the Hbase database is reduced, and the user operation is facilitated.

FIG. 4 schematically shows a block diagram of a web interface based Hbase database processing apparatus 400 according to an embodiment of the present disclosure.

As shown in fig. 4, the apparatus 400 includes a first presentation module 410, a first acquisition module 420, a generation module 430, an execution module 440, and a second presentation module 450.

The first display module 410 is configured to display a web interface in response to a user request, where the web interface includes an information input box, at least one execution button, and a result display box. According to an embodiment of the present disclosure, the first display module 410 may perform, for example, operation S201 described above with reference to fig. 2, which is not described herein.

The first obtaining module 420 is configured to obtain input information in the information input box in response to a user triggering one of the at least one execution buttons. According to an embodiment of the present disclosure, the first obtaining module 420 may perform, for example, operation S202 described above with reference to fig. 2, which is not described herein.

The generation module 430 is configured to generate an Hbase database statement based on the input information and the triggered execution button. The generating module 430 may, for example, perform operation S203 described above with reference to fig. 2 according to an embodiment of the present disclosure, which is not described herein.

The execution module 440 is configured to execute the Hbase database statement in the Hbase database, to obtain an execution result. The execution module 440 may, for example, execute operation S204 described above with reference to fig. 2 according to an embodiment of the present disclosure, which is not described herein.

The second display module 450 is configured to display the execution result in a result display frame. According to an embodiment of the present disclosure, the second display module 450 may perform, for example, operation S205 described above with reference to fig. 2, which is not described herein.

According to an embodiment of the present disclosure, the information input box may include an Hbase table name input box. The at least one execution button may include a table data amount query button. The generating Hbase database statement based on the input information and the triggered execution button may include: and generating a data amount inquiry command of the Hbase database based on the table name information in the Hbase table name input frame and the table data amount inquiry button.

According to an embodiment of the present disclosure, the information input box may include: hbase table name input box and main key input box. The at least one execution button may include: the primary key query button is pressed. The generating Hbase database statement based on the input information and the triggered execution button may include: and generating a query data content command of the Hbase database based on the table name information in the Hbase table name input box, the main key information in the main key input box and the main key query button.

According to an embodiment of the present disclosure, the primary key input box may include: a first primary key input box and a second primary key input box. The pressing of the primary key query button may include: pressing a first primary key query button and pressing the first primary key plus a second primary key query button.

According to an embodiment of the present disclosure, the information input box may include: hbase table name input box and upload data button. The apparatus 400 may further include: and the second acquisition module is used for responding to the triggering of the uploading data button by the user and acquiring the data file. The at least one execution button may include: a data write button. The generating Hbase database statement based on the input information and the triggered execution button may include: and generating a data writing command of the Hbase database based on the table name information, the data file and the data writing button in the Hbase table name input box.

According to an embodiment of the present disclosure, the generating the data writing command of the Hbase database based on the table name information in the Hbase table name input box, the data file, and the data writing button may include: analyzing the data file, obtaining column name information and a field value corresponding to the column name information in the data file, instantiating a data writing object based on the table name information, the column name information, column family name information corresponding to the column name information and the field value to obtain an instantiated object, and generating a data writing command of an Hbase database based on the instantiated object.

According to an embodiment of the present disclosure, the displaying the execution result in the result display box may include: printing the execution result obtained in the Hbase database into a log, obtaining the execution result from the log, and uploading the execution result to the webpage interface so that the webpage interface displays the execution result through the result display frame.

Any number of modules, sub-modules, units, sub-units, or at least some of the functionality of any number of the sub-units according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented as split into multiple modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system-on-chip, a system-on-substrate, a system-on-package, an Application Specific Integrated Circuit (ASIC), or in any other reasonable manner of hardware or firmware that integrates or encapsulates the circuit, or in any one of or a suitable combination of three of software, hardware, and firmware. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be at least partially implemented as computer program modules, which when executed, may perform the corresponding functions.

For example, any of the first presentation module 410, the first acquisition module 420, the generation module 430, the execution module 440, and the second presentation module 450 may be combined in one module to be implemented, or any of the modules may be split into a plurality of modules. Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module. According to embodiments of the present disclosure, at least one of the first presentation module 410, the first acquisition module 420, the generation module 430, the execution module 440, and the second presentation module 450 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in hardware or firmware in any other reasonable way of integrating or packaging the circuitry, or in any one of or a suitable combination of any of the three implementations of software, hardware, and firmware. Alternatively, at least one of the first presentation module 410, the first acquisition module 420, the generation module 430, the execution module 440, and the second presentation module 450 may be at least partially implemented as computer program modules that, when executed, may perform the corresponding functions.

Fig. 5 schematically illustrates a block diagram of a computer system according to an embodiment of the disclosure. The computer system illustrated in fig. 5 is merely an example, and should not be construed as limiting the functionality and scope of use of embodiments of the present disclosure.

As shown in fig. 5, a computer system 500 according to an embodiment of the present disclosure includes a processor 501, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 502 or a program loaded from a storage section 508 into a Random Access Memory (RAM) 503. The processor 501 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. The processor 501 may also include on-board memory for caching purposes. The processor 501 may comprise a single processing unit or a plurality of processing units for performing different actions of the method flows according to embodiments of the present disclosure described with reference to fig. 2 and 3A-3C.

In the RAM 503, various programs and data required for the operation of the system 500 are stored. The processor 501, ROM 502, and RAM 503 are connected to each other by a bus 504. The processor 501 performs various operations described above with reference to fig. 2 and fig. 3A to 3C by executing programs in the ROM 502 and/or the RAM 503. Note that the program may be stored in one or more memories other than the ROM 502 and the RAM 503. The processor 501 may also perform the methods described above by executing programs stored in the one or more memories.

According to an embodiment of the present disclosure, the system 500 may further include an input/output (I/O) interface 505, the input/output (I/O) interface 505 also being connected to the bus 504. The system 500 may also include one or more of the following components connected to the I/O interface 505: an input section 506 including a keyboard, a mouse, and the like; an output portion 507 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker, and the like; a storage portion 508 including a hard disk and the like; and a communication section 509 including a network interface card such as a LAN card, a modem, or the like. The communication section 509 performs communication processing via a network such as the internet. The drive 510 is also connected to the I/O interface 505 as needed. A removable medium 511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 510 as needed so that a computer program read therefrom is mounted into the storage section 508 as needed.

According to embodiments of the present disclosure, the method described above with reference to the flowcharts may be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network via the communication portion 509, and/or installed from the removable media 511. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 501. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

It should be noted that the computer readable medium shown in the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present disclosure, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing. According to embodiments of the present disclosure, the computer-readable medium may include ROM 502 and/or RAM 503 described above and/or one or more memories other than ROM 502 and RAM 503.

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

As another aspect, the present disclosure also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be present alone without being fitted into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to perform: responding to a user request, displaying a webpage interface, wherein the webpage interface comprises an information input frame, at least one execution button and a result display frame; acquiring input information in the information input box in response to a user triggering one of the at least one execution button; generating Hbase database statement based on the input information and the triggered execution button; executing the Hbase database statement in the Hbase database to obtain an execution result; and displaying the execution result in the result display frame.

The embodiments of the present disclosure are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the disclosure, and such alternatives and modifications are intended to fall within the scope of the disclosure.

Claims

1. A Hbase database processing method based on a web interface comprises the following steps:

responding to a user request, displaying a webpage interface, wherein the webpage interface comprises an information input frame, at least one execution button and a result display frame;

acquiring input information in the information input box in response to a user triggering one of the at least one execution button;

based on the input information and the activated execution button, generating an Hbase database statement,

executing the Hbase database statement in the Hbase database to obtain an execution result; and

displaying the execution result in the result display frame;

The information input box includes: hbase table name input box and upload data button;

the method further comprises the steps of: responding to the user triggering the uploading data button to acquire a data file;

the at least one execution button includes: a data write button;

the generating Hbase database statement based on the input information and the triggered execution button includes:

generating a data writing command of the Hbase database based on the table name information, the data file and the data writing button in the Hbase table name input box, wherein generating the data writing command of the Hbase database based on the table name information, the data file and the data writing button in the Hbase table name input box comprises:

analyzing the data file to obtain column name information and a field value corresponding to the column name information in the data file;

instantiating a data writing object based on the table name information, the column name information, column family name information corresponding to the column name information and the field value to obtain an instantiated object; and

generating a data writing command of an Hbase database based on the instantiation object;

the Hbase database query command also comprises a get command and a count statement of the Hbase shell; the Hbase database is a column-oriented, scalable, distributed column-type storage system.

2. The method of claim 1, wherein,

the information input box includes: hbase table name input box;

the at least one execution button includes: a table data amount query button; and

and generating a data amount inquiry command of the Hbase database based on the table name information in the Hbase table name input frame and the table data amount inquiry button.

3. The method of claim 1, wherein,

the information input box includes: hbase table name input box and main key input box;

the at least one execution button includes: pressing a primary key inquiry button;

and generating a query data content command of the Hbase database based on the table name information in the Hbase table name input box, the main key information in the main key input box and the main key query button.

4. The method of claim 3, wherein,

the primary key input box includes: a first primary key input frame and a second primary key input frame;

the pressing of the primary key query button includes: pressing a first primary key query button and pressing the first primary key plus a second primary key query button.

5. The method of claim 1, wherein the presenting the execution result in the result presentation box comprises:

printing an execution result obtained in the Hbase database into a log;

and obtaining the execution result from the log and uploading the execution result to the webpage interface so that the webpage interface displays the execution result through the result display frame.

6. An Hbase database processing device based on a web interface, comprising:

the first display module is used for responding to a user request and displaying a webpage interface, wherein the webpage interface comprises an information input frame, at least one execution button and a result display frame;

the first acquisition module is used for responding to the triggering of one of the at least one execution buttons by a user and acquiring input information in the information input box;

the generation module is used for generating Hbase database sentences based on the input information and the triggered execution buttons;

the execution module is used for executing the Hbase database statement in the Hbase database to obtain an execution result; and

the second display module is used for displaying the execution result in the result display frame;

the Hbase database is a column-oriented and telescopic distributed column storage system, and Hbase database inquiry is carried out through get commands and count sentences of Hbase shells;

the apparatus further comprises: the second acquisition module is used for responding to the triggering of the uploading data button by a user to acquire a data file;

the at least one execution button includes: a data write button;

generating a data writing command of an Hbase database based on the table name information, the data file and the data writing button in the Hbase table name input box;

the generating a data writing command of the Hbase database based on the table name information in the Hbase table name input box, the data file, and the data writing button includes:

and generating a data writing command of the Hbase database based on the instantiation object.

7. The apparatus of claim 6, wherein,

the information input box includes: hbase table name input box;

8. The apparatus of claim 6, wherein,

9. The apparatus of claim 8, wherein,

10. The apparatus of claim 6, wherein the presenting the execution result in the result presentation box comprises:

printing an execution result obtained in the Hbase database into a log;

11. A computer system, comprising:

one or more processors;

storage means for storing one or more programs,

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-5.

12. A computer readable medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the method according to any of claims 1-5.