CN107291951B - Data processing method, device, storage medium and processor - Google Patents

Abstract

The invention discloses a data processing method, device, storage medium and processor. The method includes acquiring a first data record table for indicating a name of a data table and a database where the data table is located and a second data record table for indicating a data item and the data table where the data item is located, from the first data record Select the first data record indicating the name of the target data table from the table; query a plurality of data records with the same name as the target data table from the second data record table, and select from the plurality of data records to indicate the target data item And the data table where the target data item is located is the second data record of the target data table; the target data table is formed according to the target data item, and the name of the target data table is set as the target name. The invention solves the technical problem that the data processing efficiency is low due to the manual method used in the prior art to sort out the data required by the manager according to a plurality of relation tables.

Description

Data processing method, apparatus, storage medium and processor

technical field

The present invention relates to the field of data processing, and in particular, to a data processing method, device, storage medium and processor.

Background technique

Smart city is an important information infrastructure for city management. Different from general applications, smart city is an information integrated system of complex data and applications. The system concentrates massive data and numerous applications from all walks of life involved in city management. .

A smart city is a data integration system, and the data of various industries are stored in different relational tables. A smart city is not a single business system, but a comprehensive information system for city management. Managers need to quickly and accurately select the data they need to understand from different relationship representations.

However, the technical solution provided by the prior art is to search for the required data from different business departments and different relational tables, and then the manager artificially integrates the found data to construct a new relational data table, and then according to the Reconstructed relational data tables that identify the applications in the data synthesis system, and how the applications function and operate.

Aiming at the problem of low data processing efficiency caused by manually sorting out the data required by managers according to multiple relational tables in the prior art, no effective solution has been proposed yet.

SUMMARY OF THE INVENTION

Embodiments of the present invention provide a data processing method, device, storage medium, and processor, so as to at least solve the technical problem that the prior art uses manual methods to sort out the data required by managers according to multiple relationship tables, resulting in low data processing efficiency. question.

According to an aspect of the embodiments of the present invention, a data processing method is provided, comprising: acquiring a first data record table and a second data record table, wherein a data record in the first data record table is used to indicate a The name of the data table and the database where the data table is located, a data record in the second data record table is used to indicate a data item and the data table where the data item is located; from the first data record table Selecting a first data record, wherein the first data record indicates the name of the target data table; querying a plurality of data records with the same name as the target data table from the second data record table, and querying from the second data record table A second data record is selected from the plurality of data records, wherein the second data record is used to indicate that the target data item and the data table where the target data item is located are the target data table; Describe the target data table, and set the name of the target data table as the target name.

Further, after forming the target data table according to the target data item, and setting the name of the target data table as the target name, the method further includes: adding information of the target data table to the first In a data record table, the information of the target data table includes the target name of the target data table; and the information of the target data item is added to the second data record table.

Further, while acquiring the first data record table and the second data record table, the method further includes: acquiring a third data record table, wherein a data record in the third data record table is used to indicate a The name of the application, the program entry uniform resource locator of the application, and the icon of the application; after forming the target data table according to the target data item, and setting the name of the target data table as the target name Afterwards, the method further includes: detecting whether there is a touch operation on the icon of the application; in the case of detecting the touch operation on the icon of the application, running the program entry uniform resource locator the application indicated.

Further, after acquiring the first data record table, the second data record table and the third data record table, the method further includes: receiving a data search request, wherein the data search request contains Carrying a search object and a search keyword; in the case where the search object is the first data record table, query the first data record table for the search keyword in response to the data search request The matching data table is displayed, and the queried data table is displayed; if the search object is the second data record table, in response to the data search request, query the second data record table with the Search for a data item matching the keyword, and display the data table where the queried data item is located; in the case that the search object is the third data record table, in response to the data search request from the third The data record table is queried for an application program matching the search keyword, and the application program is executed.

Further, after acquiring the first data record table, the second data record table and the third data record table, the method further includes: crawling the first data record table, the The text in the second data record table and the third data record table is divided into words; according to the word segmentation, the corresponding parts of the first data record table, the second data record table and the third data record table are established respectively. The index file, wherein the index file is used to query the file matching the search keyword.

Further, after acquiring the first data record table, the second data record table and the third data record table, the method further includes: establishing a user information table, wherein the user information table contains User information and user authority are recorded, and the user authority is used to indicate the operation authority for the first data record table, the second data record table and the third data record table, and the operation authority includes At least one of the following: query data records, modify data records, delete data records, add data records.

According to yet another embodiment of the present invention, a storage medium is also provided, the storage medium includes a stored program, wherein the program executes any of the above methods when running.

According to yet another embodiment of the present invention, a processor is also provided, and the processor is configured to run a program, wherein when the program runs, any one of the methods described above is executed.

According to another aspect of the embodiments of the present invention, a data processing apparatus is further provided, including: a first acquisition unit, configured to acquire a first data record table and a second data record table, wherein the first data record table A data record in is used to indicate the name of a data table and the database where the data table is located, and a data record in the second data record table is used to indicate a data item and the data table where the data item is located; a selection unit for selecting a first data record from the first data record table, wherein the first data record indicates the name of a target data table; a query unit for inquiring from the second data record table A plurality of data records with the same name as the target data table, and a second data record is selected from the plurality of data records, wherein the second data record is used to indicate the target data item and the target data item The data table where it is located is the target data table; the composition unit is used to form the target data table according to the target data item, and set the name of the target data table as the target name.

Further, the device further includes: a second acquisition unit, configured to acquire a third data record table while acquiring the first data record table and the second data record table, wherein the data in the third data record table A data record is used to indicate the name of an application program, the program entry uniform resource locator of the application program, and the icon of the application program; the device further includes: a detection unit, used for composing according to the target data item. the target data table, and after setting the name of the target data table as the target name, detect whether there is a touch operation on the icon of the application; after detecting the touch operation on the icon of the application In this case, the application program indicated by the program entry uniform resource locator is executed.

In this embodiment of the present invention, each data record in the first data record table represents the name of a data table and the database where the data table is located, and each data record in the second data record table represents a data item and includes the The data table of the data item, by acquiring the first data record table and the second data record table, and selecting the first data record including the name of the target data table from the first data record table; query from the second data record table Multiple data records with the same name as the target data table, and from the found multiple data records with the same name as the target data table, including the target data item and the data table where the target data item is located are selected as the first part of the target data table. Two data records, and then according to the second data records, the target data items are formed into the target data table, and the name of the target data table is set as the target name, so that the above steps can be performed automatically from a plurality of first data record tables and a plurality of second data record tables. The target data item is extracted from the data record table, and a target data table is formed according to the extracted target data item, and the name of the target data table is set as the target name, thereby solving the problem that the prior art adopts a manual method according to multiple relationship tables. Sort out the data required by managers, resulting in technical problems of low data processing efficiency.

Description of drawings

The accompanying drawings described herein are used to provide a further understanding of the present invention and constitute a part of the present application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the attached image:

1 is a flowchart of an optional data processing method according to an embodiment of the present invention;

2 is a schematic diagram of an optional data reconstruction method according to an embodiment of the present invention;

3 is a schematic diagram of an optional search method according to an embodiment of the present invention;

4 is a schematic diagram of an optional search engine construction method according to an embodiment of the present invention;

FIG. 5 is a schematic diagram of an optional data processing apparatus according to an embodiment of the present invention.

Detailed ways

In order to make those skilled in the art better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only Embodiments are part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

It should be noted that the terms "first", "second" and the like in the description and claims of the present invention and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used may be interchanged under appropriate circumstances such that the embodiments of the invention described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having" and any variations thereof, are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those expressly listed Rather, those steps or units may include other steps or units not expressly listed or inherent to these processes, methods, products or devices.

According to an embodiment of the present invention, an embodiment of a data processing method is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings may be executed in a computer system such as a set of computer-executable instructions, and, although in A logical order is shown in the flowcharts, but in some cases steps shown or described may be performed in an order different from that herein.

FIG. 1 is a flowchart of an optional data processing method according to an embodiment of the present invention. As shown in FIG. 1 , the method includes the following steps:

Step S102, obtain the first data record table and the second data record table, wherein, a data record in the first data record table is used to indicate the name of a data table and the database where the data table is located, and the data record in the second data record table A data record is used to indicate a data item and the data table in which the data item is located;

Step S104, selecting a first data record from the first data record table, wherein the first data record indicates the name of the target data table;

Step S106, query a plurality of data records with the same name as the target data table from the second data record table, and select a second data record from the plurality of data records, wherein the second data record is used to indicate the target data item and The data table where the target data item is located is the target data table;

In step S108, a target data table is formed according to the target data item, and the name of the target data table is set as the target name.

Through the above steps, each data record in the first data record table represents the name of a data table and the database where the data table is located, and each data record in the second data record table represents a data item and a data item including the data item. Data table, by acquiring the above-mentioned first data record table and second data record table, and selecting the first data record including the name of the target data table from the first data record table; query and target data from the second data record table Multiple data records with the same name of the table are selected from the multiple data records with the same name as the target data table, including the target data item and the data table where the target data item is located as the second data record of the target data table , and then according to the second data record, the target data item is formed into a target data table, and the name of the target data table is set as the target name, so that the above steps can be used to automatically select from a plurality of first data record tables and a plurality of second data record tables. The target data item is extracted from the system, and a target data table is formed according to the extracted target data item, and the name of the target data table is set as the target name, thereby solving the problem that the prior art adopts a manual method to sort out the management according to a plurality of relation tables. The data required by the user causes the technical problem of low data processing efficiency.

As an optional embodiment, after forming the target data table according to the target data item and setting the name of the target data table as the target name, this embodiment may further include: adding information of the target data table to the first data record In the table, the information of the target data table includes the target name of the target data table; and the information of the target data item is added to the second data record table.

Using the above embodiment of the present invention, after forming a target data table according to the target data items, and setting the name of the target data table as the target name, the information including the target name in the target data table is added to the first data record table, and the target data table is added to the first data record table. The information of the data item is added to the second data record, thereby completing the update of the first data record table and the second data record table, maintaining the accuracy of the first data record table and the second data record table, and ensuring that the first data record table and the second data record table are accurate. The results from the data record sheet and the second data record sheet are accurate and reliable.

As an optional embodiment, while acquiring the first data record table and the second data record table, this embodiment may further include: acquiring a third data record table, wherein a piece of data in the third data record table The record is used to indicate the name of an application program, the program entry uniform resource locator of the application program and the icon of the application program; after forming the target data table according to the target data item, and setting the name of the target data table as the target name, the method also includes : Detect whether there is a touch operation on the icon of the application; in the case of detecting the touch operation on the icon of the application, run the application indicated by the uniform resource locator of the program entry.

Using the above embodiment of the present invention, each data record in the third data record table represents the name of an application program, the program entry uniform resource locator of the application program, and the diagram of the application program. By acquiring the third data record table, and Determine the corresponding relationship between each data record in the third data record table and the target data table, after forming the target data table according to the target data items, and setting the name of the target data table as the target name, detect whether there is a touch application program. The operation of the icon, if there is an icon that touches the application program, according to the data record including the icon of the application program in the third record table, run the application program indicated by the corresponding program entry uniform resource locator, thereby according to the third record table. The data record table can directly run the corresponding application program through the target data table, so as to quickly select the corresponding application program according to the target data table.

Optionally, the name of the application recorded in the third data recording table may include a target name, and the user runs the corresponding application after touching the target data table of the target name.

Optionally, each data record in the target data table includes an icon of the corresponding application program, and the user runs the application program corresponding to the icon of the application program after touching the icon of the application program.

As an optional embodiment, after acquiring the first data record table, the second data record table, and the third data record table, the method further includes: receiving a data search request, wherein the data search request carries a search object and search keywords; in the case where the search object is the first data record table, query the data table matching the search keyword from the first data record table in response to the data search request, and display the queried data table; When the search object is the second data record table, in response to the data search request, query the second data record table for data items that match the search keywords, and display the data table where the queried data items are located; In the case of the third data record table, in response to the data search request, the application program matching the search keyword is searched from the third data record table, and the application program is executed.

With the above-mentioned embodiment of the present invention, after the first data record table, the second data record table and the third data record table are acquired, a data search request carrying a search object and a search keyword is received, where the search object is the first data In the case of a record table, in response to a data search request, query the data table matching the search keyword from the first data record table, and display the queried data table; in the case where the search object is the second data record table Next, in response to the data search request, query the data item matching the search keyword from the second data record table, and display the data table where the queried data item is located; in the case where the search object is the third data record table Next, in response to the data search request, query the application program matching the search keyword from the third data record table, and run the application program, so that through the data search request, the first data record table, the second data The data table, data item and application program corresponding to the keyword are retrieved in the record table and the third data record table, so that the speed of obtaining the data table, data item and application program is accelerated.

As an optional embodiment, after acquiring the first data record table, the second data record table, and the third data record table, the embodiment may further include: crawling the first data record table and the second data record table respectively. The text in the record table and the third data record table is divided into words; according to the word segmentation, index files corresponding to the first data record table, the second data record table and the third data record table are respectively established, wherein the index file is used for querying and Search for files matching keywords.

Using the above-mentioned embodiment of the present invention, the text content in the first data record table, the second data record table and the third data record table are respectively crawled, and the crawled text content is segmented, and then according to the word segmentation of the text content Index files matching the search keywords are established for the first data record table, the second data record table and the third data record table, so that the first data record table, the second data record table and the third data record table can be accurately judged Corresponding relationship with the search keywords, and then can quickly obtain the corresponding data record table according to the search keywords.

As an optional embodiment, after acquiring the first data record table, the second data record table, and the third data record table, this embodiment may further include: establishing a user information table, wherein the user information table records There is user information and user authority, the user authority is used to indicate the operation authority for the first data record table, the second data record table and the third data record table, and the operation authority includes at least one of the following: query data records, modify data Record, delete data records, add data records.

With the above embodiments of the present invention, after acquiring the first data record table, the second data record table and the third data record table, a user information table including user information and user authority can be established, and the user authority can indicate the corresponding user's The operation authority enables the user to query data records, modify data records, delete data records, and add data records in the first data record table, the second data record table and the third data record table according to the operation authority, so that Different users set different operation permissions, so that different users can perform corresponding operations on data records according to different usage requirements, ensure that data records can be performed in an orderly manner during the application process, and ensure that the first data record table and the second data record are recorded. the accuracy and reliability of the data in the table and the third data record sheet.

Optionally, in the user information record table, the user authority can be determined according to the user information, for example, the user information position information, the position information is respectively position A, position B, and position C, wherein, the user of position A manages the user and user of position B. If you are a user of position C, the user authority of position A is higher than the user authority of position B and the user authority of position C, and the user authority of position A includes the user authority of position B and the user authority of position C. In addition, if the work content of the user of position B and the user of position C are different, different user rights can be configured for position B and position C according to the work content of the user of position B and the work content of the user of position C respectively.

The present invention also provides a preferred embodiment, which provides a smart city operating system and an implementation method.

The smart city operating system and implementation method proposed by the present invention have the following technical solutions:

Optionally, the smart city operating system includes: "data table metadata information record table", which is used to record the database, table name, purpose, source, affiliated unit and other related information of each data table in the smart city system. Text description.

Optionally, the smart city operating system also includes: a "metadata information record table for data items", which is used to record in the smart city system the table name, purpose, source and other relevant information of the data item in each data table. Text description.

Optionally, the smart city operating system further includes: an "application information table", which is used to record the uniform resource location URL, program name, affiliated unit, purpose, icon ICO and other related information of each application entry in the smart city system text description.

Optionally, the user can use the data in the "Data Table Metadata Information Record Table" and "Data Item Metadata Information Record Table" to rebuild a new data table; create a window program to display the "Application Program Information Table" The icon in the ICO for the user to invoke the application.

Optionally, the data items in the "metadata information record table of data table", "metadata information record table of data item" and "application program information table" can be used as information sources to establish a search engine, and users can use Search engines search data tables, data items, and applications that contain keywords.

Optionally, it is possible to add, delete and modify the records of the "metadata information record table of data table", "metadata information record table of data item" and "application program information table".

Optionally, the text recorded in the "metadata information record table of data table", "metadata information record table of data item" and "application program information table" can be divided into words, and a word index file can be established to form a smart city. "Metadata search engine", when a user enters a keyword in the search box, it searches for data tables, data items and applications that contain the keyword.

Optionally, you can set up a window similar to the "desktop" of WINDOWS, put the icon ICO in the table on the "desktop", click the icon ICO, and call the URL in the table to run the program.

Optionally, an authority management table may be established for the "data table metadata information record table", "data item metadata information record table" and "application program information table" to set different usage rights for different users.

Optionally, the user can select a table as the "search object" from "the metadata information record table of the data table", the "metadata information record table of the data item", and the "application program information table", and the search engine Search for keywords only in Search Objects.

Optionally, after searching for a record of "data table metadata information record table" containing keywords, a list is displayed, and when the user selects a certain record, the database table is opened for display; when a "data item containing keywords" is searched for After the "Metadata Information Record Table" record, a list is displayed. When the user selects a record, the database table where the data item is located is opened for display; when the "Application Information Table" record containing the keyword is searched, the list is displayed, and the user selects When a record is found, the URL in the table is called to run the program.

Table 1 is a record table of metadata information of an optional data table according to an embodiment of the present invention. As shown in Table 1, a "metadata information record table of data table" is established, and the specific content and form are as follows:

Table 1

database table name use source Current unit 1 2 , , ,

As shown in Table 1, it is the structure of "data table metadata information record table", each database table corresponds to a record, and the "data table metadata information record table" can record the location of each data table in the system Text description of the database, table name, purpose, source, affiliation, etc. It should be understood that the data structure shown in Table 1 is not a limitation on the structure of the "metadata information record table of the data table", but is only a typical embodiment, and may also include any other information about the "data table".

Table 2 is a record table of metadata information of an optional data item according to an embodiment of the present invention. As shown in Table 2, a "metadata information record table of data item" is established, and the specific content and form are as follows:

Table 2

As shown in Table 2, it is the structure of the "data item metadata information record table", the "data item" in each database table is a record, and each data item in the system can be recorded through the "data item metadata information record table". A text description of the table name, purpose, source and other related information of the data item. It should be understood that the data structure shown in Table 2 is not a limitation on the structure of the "data item metadata information record table", but is only a typical embodiment, and may also include any other information about the "data item".

Table 3 is an information table of an optional application program according to an embodiment of the present invention. As shown in Table 3, an "application program information table" is established, and the specific content and form are as follows:

table 3

URL program name affiliated unit use ICO file 1 2 , , ,

As shown in Table 3, it is the structure of the "application program information table", each "application program" is a record, and the "application program information table" can record the program entry uniform resource location URL of each "application program" in the system , program name, affiliation, purpose, icon ICO file and other related information. It should be understood that the data structure shown in Table 3 is not a limitation on the structure of the "application program information table", but is only a typical embodiment, and may also include any other information about the "application program".

Optionally, the method for implementing the icon ICO window can put the icon ICO in the "application information table" into a window, and display the "program name" below, when the user selects (mouse click or keyboard selection) the icon ICO of the application, Run the program in the Uniform Resource Locator URL of the program entry in the "Application Information Table".

Fig. 2 is a schematic diagram of an optional data reconstruction method according to an embodiment of the present invention. As shown in Fig. 2, an application window is created to list the records of the "metadata information record table of the data table", allowing the user to Select a record; then according to the "table name" in the record selected by the user, query all records with the same "table name" from the "metadata information record table of data item", and display them in a list on the screen; the user can select a certain A record is determined to determine the data item of a new data table; the above process is repeated to allow the user to select records from multiple "data table metadata information record tables", and select records from multiple "data table metadata information record tables" record, to determine the data item of the new data table. Until the user confirms the end, all the data items of the new data table selected by the user are formed into a new data table, appended to the "metadata information record table of the data table", and the data items of the newly formed table are added to the "data item's Metadata Information Record Table".

Fig. 3 is a schematic diagram of an optional search method according to an embodiment of the present invention. As shown in Fig. 3, a search box is displayed on the screen, and three options are set: "metadata information record table of data table", "data Item metadata information record table" and "application information table", the user selects one table from the three tables as the "search object", then enters the search "keyword" in the search box, and searches after confirmation.

Optionally, if the user selects the "search object" as "the metadata information record table of the data table", the data table containing the keywords is listed on the screen, the user selects a certain record, opens the data table, and makes a list on the screen. show.

Optionally, if the user selects the "search object" as "the metadata information record table of the data item", the data items containing the keywords are listed on the screen, the user selects a certain record, and opens the data table where the data item is located, List display on the screen.

Optionally, if the user selects the "search object" as the "application program information table", the application programs containing the keywords are listed on the screen, the user selects a certain record, and runs the uniform resource location of the program entry in the "application program information table". program in the URL.

FIG. 4 is a schematic diagram of an optional search engine construction method according to an embodiment of the present invention. As shown in FIG. 4 , the crawler program of the "search engine" crawls the "metadata information The text in the metadata information record table of the item and the application program information table is divided into words, and three index files are established with the words corresponding to the record numbers in the above three tables respectively.

Optionally, the file is indexed with the word "metadata information record table of data table", which may be "A index" in FIG. 4 .

Optionally, the file is indexed with the word "metadata information record table of data item", "B index" in FIG. 4 .

Optionally, the file is indexed with the word "application information table", "C index" in FIG. 4 .

The contents of the indexed records are as follows:

word 1, record number 1, record number 2...,

word 2, record number 1, record number 2...,

word 3, record number 1, record number 2...,

...

As shown in Figure 3, during the search process, according to the selection of three tables: "Metadata Information Record Table of Data Table", "Metadata Information Record Table of Data Item" and "Application Program Information Table", in the corresponding The index file looks for "keywords" and returns a set of search results containing the keyword.

Optionally, the user rights management method can set up a user table to record user information; for different users, respectively, give the "metadata information record table of data table", "metadata information record table of data item" and "application". The operation authority recorded in the three tables of "Program Information Table", including: query, modification, deletion, etc.

By adopting the above embodiments of the present invention, a smart city operating system that is convenient for users to use can easily allow users to quickly understand what data and application programs are in the smart city system, and make better use of the smart city system.

In a smart city, there is a lot of data scattered in various database tables. The traditional method is to directly open the database table for viewing, or simply retrieve the metadata, and let people judge the required data. According to the metadata search scheme proposed by the present invention, users can use the familiar Baidu, Google and other modern search engines, just enter keywords in the search box, and can search from the "metadata record table of relational data table" and Relevant data is searched in the "Metadata Record Table of Data Items".

By adopting the above-mentioned embodiments of the present invention, the reorganization and reconstruction technology allows users to use a human-computer interaction interface to recombine data in different database tables to construct a new relational data table, which breaks the data split in different database tables. state, which is conducive to the comprehensive utilization of information in smart cities.

With the above embodiments of the present invention, the application management technology can record the URL and icon ICO of each application entry, and the user can set a window as the "desktop", and can directly click the "desktop" like a WINDOWS application. On the icon ICO, the system calls the URL to run the application.

In the large-scale distributed smart city data and application management system provided by the technical solution of the present invention, the data tables recorded through the "metadata information record table of the data table" can be distributed in different computers and different databases; "application program information table" "The recorded application entry Uniform Resource Location URL, which enables the application to be distributed on any computer in the network, and to invoke and run the application pointed to by the URL through a browser.

An embodiment of the present invention further provides a storage medium, where the storage medium includes a stored program, wherein when the program runs, a device where the storage medium is located is controlled to execute the data processing method described above.

An embodiment of the present invention further provides a processor, which is used for running a program, wherein the data processing method described above is executed when the program is running.

According to an embodiment of the present invention, an embodiment of a data processing apparatus is also provided. It should be noted that the data processing apparatus can be used to execute the data processing method in the embodiment of the present invention, and the data processing method in the embodiment of the present invention can be executed in the data processing device.

FIG. 5 is a schematic diagram of an optional data processing apparatus according to an embodiment of the present invention. As shown in FIG. 5 , the apparatus may include: a first acquiring unit 51 for acquiring a first data record table and a second data record table, wherein a data record in the first data record table is used to indicate the name of a data table and the database where the data table is located, and a data record in the second data record table is used to indicate a data item and the location where the data item is located data table; the selection unit 53 is used to select the first data record from the first data record table, wherein the first data record indicates the name of the target data table; the query unit 55 is used to query and match from the second data record table A plurality of data records with the same name of the target data table, and a second data record is selected from the plurality of data records, wherein the second data record is used to indicate that the target data item and the data table where the target data item is located are the target data table; The composition unit 57 is configured to form a target data table according to the target data item, and set the name of the target data table as the target name.

It should be noted that the first obtaining unit 51 in this embodiment may be used to perform step S102 in this embodiment of the present application, and the selection unit 53 in this embodiment may be used to perform step S104 in this embodiment of the present application. The query unit 55 in this embodiment may be configured to perform step S106 in this embodiment of the present application, and the component unit 57 in this embodiment may be configured to perform step S108 in this embodiment of the present application. Examples and application scenarios implemented by the foregoing modules and corresponding steps are the same, but are not limited to the contents disclosed in the foregoing embodiments.

According to the above embodiment of the present invention, each data record in the first data record table represents the name of a data table and the database where the data table is located, and each data record in the second data record table represents a data item and includes the The data table of the data item, the first acquisition unit acquires the first data record table and the second data record table, and the selection unit selects the first data record including the name of the target data table from the first data record table ; Through the query unit, from the second data record table, inquire a plurality of data records with the same name as the target data table, and select from the found multiple data records with the same name as the target data table to include the target data item and The data table where the target data item is located is the second data record of the target data table, and then the target data item is formed into the target data table according to the second data record through the composition unit, and the name of the target data table is set as the target name, so that it can be The above unit automatically extracts target data items from a plurality of first data record tables and a plurality of second data record tables, forms a target data table according to the extracted target data items, and sets the name of the target data table as the target Name, thereby solving the technical problem of low data processing efficiency caused by the prior art using manual methods to sort out the data required by managers according to multiple relational tables.

As an optional embodiment, this embodiment may further include: a first adding unit, configured to compose a target data table according to the target data item and set the name of the target data table as the target name, add the target data table The information is added to the first data record table, wherein the information of the target data table includes the target name of the target data table; the second adding unit is used for adding the information of the target data item to the second data record table.

As an optional embodiment, this embodiment may further include: a second acquisition unit, configured to acquire a third data record table while acquiring the first data record table and the second data record table, wherein the third data record table is A data record in the data record table is used to indicate the name of an application program, the program entry uniform resource locator of the application program and the icon of the application program; the device further includes: a detection unit, used for composing a target data table according to the target data item , and set the name of the target data table as the target name, detect whether there is a touch operation on the icon of the application; in the case of detecting the touch operation on the icon of the application, run the program entry uniform resource locator indicated application.

As an optional embodiment, this embodiment may further include: a receiving unit configured to receive a data search request after acquiring the first data recording table, the second data recording table and the third data recording table, wherein, The data search request carries a search object and a search keyword; a first response unit is used to query and search for keywords from the first data record table in response to the data search request when the search object is the first data record table The matching data table, and display the queried data table; the second response unit is used to query and search the key from the second data record table in response to the data search request when the search object is the second data record table The data item that matches the word, and displays the data table where the queried data item is located; when the search object is the third data record table, the third response unit queries the third data record table in response to the data search request. Search for an application that matches the keyword, and run the application.

As an optional embodiment, this embodiment may further include: a crawling unit, configured to crawl the first data respectively after acquiring the first data record table, the second data record table and the third data record table The text in the record table, the second data record table and the third data record table is divided into words; the first creation unit is used to respectively establish the corresponding parts of the first data record table, the second data record table and the third data record table according to the word segmentation The index file, wherein the index file is used to query the files matching the search keywords.

As an optional embodiment, this embodiment may further include: a second creation unit, configured to create a user information table after acquiring the first data record table, the second data record table and the third data record table, Wherein, the user information table records user information and user authority, the user authority is used to indicate the operation authority for the first data record table, the second data record table and the third data record table, and the operation authority includes at least one of the following : Query data records, modify data records, delete data records, add data records.

The above-mentioned serial numbers of the embodiments of the present invention are only for description, and do not represent the advantages or disadvantages of the embodiments.

In the above-mentioned embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. The device embodiments described above are only illustrative, for example, the division of the units may be a logical function division, and there may be other division methods in actual implementation, for example, multiple units or components may be combined or Integration into another system, or some features can be ignored, or not implemented. On the other hand, the shown or discussed mutual coupling or direct coupling or communication connection may be through some interfaces, indirect coupling or communication connection of units or modules, and may be in electrical or other forms.

The units described as separate components may or may not be physically separated, and components shown as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution in this embodiment.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit. The above-mentioned integrated units may be implemented in the form of hardware, or may be implemented in the form of software functional units.

The integrated unit, if implemented in the form of a software functional unit and sold or used as an independent product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium , including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes .

The above are only the preferred embodiments of the present invention. It should be pointed out that for those skilled in the art, without departing from the principles of the present invention, several improvements and modifications can be made. It should be regarded as the protection scope of the present invention.

Claims (10)

1. A data processing method, comprising:

acquiring a first data record table and a second data record table, wherein one data record in the first data record table is used for indicating the name of one data table and a database where the data table is located, and one data record in the second data record table is used for indicating one data item and the data table where the data item is located;

selecting a first data record from the first data record table, wherein the first data record indicates a name of a target data table;

inquiring a plurality of data records with the same name as the target data table from the second data record table according to a search engine, and selecting a second data record from the plurality of data records, wherein the second data record is used for indicating a target data item and the data table in which the target data item is located is the target data table;

and repeating the selection process of the first data record and the second data record, forming the target data items into the target data table according to the second data record, and setting the name of the target data table as a target name.

2. The method of claim 1, wherein after composing the target data table from the target data items and setting a name of the target data table as a target name, the method further comprises:

adding the information of the target data table into the first data record table, wherein the information of the target data table comprises the target name of the target data table;

adding information of the target data item to the second data record table.

3. The method of claim 1,

while obtaining the first data record table and the second data record table, the method further comprises: acquiring a third data record table, wherein one data record in the third data record table is used for indicating the name of an application program, a program entry uniform resource locator of the application program and an icon of the application program;

after composing the target data table according to the target data items and setting the name of the target data table as a target name, the method further includes: detecting whether touch operation on an icon of the application program exists or not; and running the application program indicated by the program entry uniform resource locator under the condition that the touch operation on the icon of the application program is detected.

4. The method of claim 3, wherein after obtaining the first data record table, the second data record table, and the third data record table, the method further comprises:

receiving a data search request, wherein the data search request carries a search object and a search keyword;

under the condition that the search object is the first data record table, inquiring a data table matched with the search keyword from the first data record table in response to the data search request, and displaying the inquired data table;

under the condition that the search object is the second data record table, inquiring data items matched with the search keyword from the second data record table in response to the data search request, and displaying the data table where the inquired data items are located;

and under the condition that the search object is the third data record table, inquiring an application program matched with the search keyword from the third data record table in response to the data search request, and running the application program.

5. The method of claim 4, wherein after obtaining the first data record table, the second data record table, and the third data record table, the method further comprises:

respectively crawling texts in the first data record table, the second data record table and the third data record table for word segmentation;

and respectively establishing index files corresponding to the first data record table, the second data record table and the third data record table according to the word segmentation, wherein the index files are files used for inquiring and matching with the search keyword.

6. The method of claim 3, wherein after obtaining the first data record table, the second data record table, and the third data record table, the method further comprises:

establishing a user information table, wherein user information and user authority are recorded in the user information table, the user authority is used for indicating operation authority for the first data record table, the second data record table and the third data record table, and the operation authority includes at least one of the following: querying data records, modifying data records, deleting data records, and adding data records.

7. A data processing apparatus, comprising:

the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein one data record in the first data record is used for indicating the name of one data table and a database where the data table is located, and one data record in the second data record is used for indicating one data item and the data table where the data item is located;

a selecting unit, configured to select a first data record from the first data record table, where the first data record indicates a name of a target data table;

the query unit is used for querying a plurality of data records with the same name as the target data table from the second data record table according to a search engine and selecting the second data record from the plurality of data records, wherein the second data record is used for indicating a target data item and the data table in which the target data item is located is the target data table;

and the composition unit is used for repeating the selection process of the first data record and the second data record, composing the target data item into the target data table according to the second data record, and setting the name of the target data table as a target name.

8. The apparatus of claim 7,

the device further comprises: a second obtaining unit, configured to obtain a third data record table while obtaining a first data record table and a second data record table, where one data record in the third data record table is used to indicate a name of an application program, a program entry uniform resource locator of the application program, and an icon of the application program;

the device further comprises: the detection unit is used for detecting whether touch operation on the icon of the application program exists or not after the target data table is formed according to the target data items and the name of the target data table is set as a target name; and running the application program indicated by the program entry uniform resource locator under the condition that the touch operation on the icon of the application program is detected.

9. A storage medium, comprising a stored program, wherein the program, when executed, controls an apparatus in which the storage medium is located to perform the method of any one of claims 1 to 6.

10. A processor, characterized in that the processor is configured to run a program, wherein the program when running performs the method of any of claims 1 to 6.

Images