CN107291951B - Data processing method, device, storage medium and processor - Google Patents
Data processing method, device, storage medium and processor Download PDFInfo
- Publication number
- CN107291951B CN107291951B CN201710606878.3A CN201710606878A CN107291951B CN 107291951 B CN107291951 B CN 107291951B CN 201710606878 A CN201710606878 A CN 201710606878A CN 107291951 B CN107291951 B CN 107291951B
- Authority
- CN
- China
- Prior art keywords
- data
- data record
- target
- name
- record table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/279—Recognition of textual entities
Abstract
The invention discloses a data processing method, a data processing device, a storage medium and a processor. The method comprises the steps of obtaining a first data record table used for indicating the name of a data table and a database where the data table is located and a second data record table used for indicating a data item and a data table where the data item is located, and selecting a first data record indicating the name of a target data table from the first data record table; inquiring a plurality of data records with the same name as the target data table from the second data record table, and selecting the second data record which is used for indicating the target data item and the data table where the target data item is located as the target data table from the plurality of data records; and forming a target data table according to the target data items, and setting the name of the target data table as a target name. The invention solves the technical problem of low data processing efficiency caused by the fact that data needed by a manager are arranged according to a plurality of relation tables in a manual mode in the prior art.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a data processing method, apparatus, storage medium, and processor.
Background
The smart city is an important information infrastructure of city management, is different from a general application program, is an information comprehensive system of complex data and the application program, and integrates mass data and numerous application programs of various industries related to city management.
The smart city is a data integrated system, and data of all walks of life are respectively stored in different relational tables. The smart city is not a single business system but a comprehensive information system for city management, and a manager needs to quickly and accurately select data to be known from different relation expressions.
However, in the technical solution provided by the prior art, required data are searched from different business departments and different relationship tables respectively, then a manager manually integrates the searched data to construct a new relationship data table, and then an application program in the data integration system, and a function and an operation mode of the application program are determined according to the reconstructed relationship data table.
Aiming at the problem that data processing efficiency is low due to the fact that data needed by managers are arranged in a manual mode according to a plurality of relation tables in the prior art, an effective solution is not provided at present.
Disclosure of Invention
Embodiments of the present invention provide a data processing method, an apparatus, a storage medium, and a processor, so as to at least solve the technical problem of low data processing efficiency in the prior art caused by manually sorting out data required by a manager according to a plurality of relationship tables.
According to an aspect of an embodiment of the present invention, there is provided a data processing method including: 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, 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 as the target data table; and forming the target data table according to the target data items, and setting the name of the target data table as a target name.
Further, after the target data table is composed according to the target data items and the name of the target data table is set as a target name, the method further includes: 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.
Further, while obtaining the first data record table and the second data record table, the method further includes: 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.
Further, after the first data record table, the second data record table, and the third data record table are obtained, the method further includes: 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.
Further, after the first data record table, the second data record table, and the third data record table are obtained, the method further includes: 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.
Further, after the first data record table, the second data record table, and the third data record table are obtained, the method further includes: 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.
According to yet another embodiment of the present invention, there is also provided a storage medium including a stored program, wherein the program performs any one of the above methods when executed.
According to yet another embodiment of the present invention, there is also provided a processor for executing a program, wherein the program executes to perform the method of any one of the above.
According to another aspect of the embodiments of the present invention, there is also provided a data processing apparatus, including: 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 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 a data table in which the target data item is located as the target data table; and the composition unit is used for composing the target data table according to the target data items and setting the name of the target data table as a target name.
Further, the apparatus 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.
In the embodiment of the invention, each data record in a first data record table represents a name of a data table and a database where the data table is located, each data record in a second data record table represents a data item and a data table comprising the data item, and a first data record comprising the name of a target data table is selected from the first data record table by acquiring the first data record table and the second data record table; inquiring a plurality of data records with the same name as the target data table from the second data record table, selecting a data table comprising the target data item and the target data item from the plurality of searched data records with the same name as the target data table as the second data record of the target data table, then, according to the second data record, the target data items are combined into a target data table, the name of the target data table is set as the target name, so that the target data item can be automatically extracted from the plurality of first data record tables and the plurality of second data record tables through the above steps, and composing a target data table based on the extracted target data items, and setting a name of the target data table as a target name, and then the technical problem that data processing efficiency is low due to the fact that data needed by a manager are arranged according to the relation tables in a manual mode in the prior art is solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow diagram of an alternative data processing method according to an embodiment of the invention;
FIG. 2 is a schematic diagram of an alternative data reconstruction method according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an alternative search method according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an alternative search engine construction method according to an embodiment of the present invention;
fig. 5 is a schematic diagram of an alternative data processing apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, 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 in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In accordance with an embodiment of the present invention, there is provided a data processing method embodiment, it should be noted that the steps illustrated in the flowchart of the figure may be performed in a computer system such as a set of computer executable instructions, and that while a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than here.
Fig. 1 is a flow chart of an alternative data processing method according to an embodiment of the present invention, as shown in fig. 1, the method including the steps of:
step S102, a first data record table and a second data record table are obtained, 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;
step S104, selecting a first data record from a first data record table, wherein the first data record indicates the name of a target data table;
step S106, a plurality of data records with the same name as the target data table are inquired from a second data record table, and the second data record is selected from the plurality of data records, wherein the second data record is used for indicating the target data item and the data table where the target data item is located is the target data table;
and step S108, forming a target data table according to the target data items, and setting the name of the target data table as a target name.
Through the steps, each data record in the first data record table represents the name of one data table and the database where the data table is located, each data record in the second data record table represents one data item and the data table comprising the data item, and the first data record comprising the name of the target data table is selected from the first data record table by acquiring the first data record table and the second data record table; inquiring a plurality of data records with the same name as the target data table from the second data record table, selecting a data table comprising the target data item and the target data item from the plurality of searched data records with the same name as the target data table as the second data record of the target data table, then, according to the second data record, the target data items are combined into a target data table, the name of the target data table is set as the target name, so that the target data item can be automatically extracted from the plurality of first data record tables and the plurality of second data record tables through the above steps, and composing a target data table based on the extracted target data items, and setting a name of the target data table as a target name, and then the technical problem that data processing efficiency is low due to the fact that data needed by a manager are arranged according to the relation tables in a manual mode in the prior art is solved.
As an alternative embodiment, after composing the target data table according to the target data items and setting the name of the target data table as the target name, the embodiment may further include: adding information of a target data table into a first data record table, wherein the information of the target data table comprises a target name of the target data table; and adding the information of the target data item to the second data record table.
By adopting the above embodiment of the present invention, after the target data table is composed according to the target data items and the name of the target data table is set 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 information of the target data item is added to the second data record, so that the updating of the first data record table and the second data record table is completed, the accuracy of the first data record table and the second data record table is maintained, and the accurate and reliable results obtained according to the first data record table and the second data record table can be ensured.
As an alternative embodiment, while obtaining the first data record table and the second data record table, the embodiment may further include: acquiring a third data record table, wherein one data record in the third data record table is used for indicating the name of one 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 the target name, the method further comprises: detecting whether touch operation on an icon of an application program exists or not; and under the condition that the touch operation on the icon of the application program is detected, the application program indicated by the program entry uniform resource locator is operated.
By adopting the above embodiment of the present invention, each data record in the third data record table represents a name of an application program, a uniform resource locator of a program entry of the application program, and a graph of the application program, by obtaining the third data record table, determining a 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 item and setting the name of the target data table as the target name, detecting whether an operation of touching an icon of the application program exists, if the icon of the application program exists, operating the application program indicated by the uniform resource locator of the corresponding program entry according to the data record including the icon of the application program in the third record table, so that the corresponding application program can be directly operated through the target data table according to the third data record table, and the corresponding application program can be quickly selected according to the target data table.
Optionally, the name of the application program recorded in the third data record table may include a target name, and the user runs the corresponding application program after touching the target data table of the target name.
Optionally, each data record in the target data table includes an icon of a corresponding application program, and after the user touches the icon of the application program, the application program corresponding to the icon of the application program is run.
As an optional embodiment, after the first data record table, the second data record table, and the third data record table are obtained, the method further includes: 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 a 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 a 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; in the case where the search object is the third data record table, an application program matching the search keyword is searched from the third data record table in response to the data search request, and the application program is executed.
By adopting the embodiment of the invention, after the first data record table, the second data record table and the third data record table are obtained, the data search request carrying the search object and the search keyword is received, and under the condition that the search object is the first data record table, the data table matched with the search keyword is inquired from the first data record table in response to the data search request, and the inquired data table is displayed; under the condition that the search object is a second data record table, responding to a data search request, inquiring data items matched with the search keyword from the second data record table, and displaying the data table where the inquired data items are located; in the case that the search object is the third data record table, in response to the data search request, the application program matched with the search keyword is searched from the third data record table, and the application program is operated, so that the data table, the data item and the application program corresponding to the keyword can be searched from the first data record table, the second data record table and the third data record table respectively through the data search request, and the speed of acquiring the data table, the data item and the application program is increased.
As an optional embodiment, after the first data record table, the second data record table, and the third data record table are obtained, the embodiment may further include: respectively crawling texts in a first data record table, a second data record table and a 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 key words.
By adopting the embodiment of the invention, the text contents in the first data record table, the second data record table and the third data record table are respectively crawled, the crawled text contents are segmented, and then index files matched with the search keywords are respectively established for the first data record table, the second data record table and the third data record table according to the segmentation of the text contents, so that the corresponding relations between the first data record table, the second data record table and the third data record table and the search keywords can be accurately judged, and further the corresponding data record tables can be quickly obtained according to the search keywords.
As an optional embodiment, after the first data record table, the second data record table, and the third data record table are obtained, the embodiment may further include: 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 comprises at least one of the following: querying data records, modifying data records, deleting data records, and adding data records.
By adopting the above embodiment of the invention, the user information table including the user information and the user authority can be established after the first data record table, the second data record table and the third data record table are obtained, the operation authority of the corresponding user is indicated through the user authority, so that the user can inquire data records, modify the data records, delete the data records, add the data records and the like in the first data record table, the second data record table and the third data record table according to the operation authority, therefore, different operation authorities can be set for different users, so that the different users can perform corresponding operations on the data records according to different use requirements, the data records can be orderly performed in the application process, and the accuracy and reliability of the data in the first data record table, the second data record table and the third data record table are ensured.
Optionally, in the user information record table, the user permission may be determined according to user information, for example, the user information job information is job a, job B, and job C, where the user of job a manages the user of job B and the user of job C, and then the user permission of job a is higher than the user permission of job B and the user permission of job C, and the user permission of job a includes the user permission of job B and the user permission of job C. In addition, the work content of the user of the job position B is different from that of the user of the job position C, and different user permissions can be configured for the job position B and the job position C according to the work content of the user of the job position B and the work content of the user of the job position C.
The invention also provides a preferred embodiment, which provides a smart city operating system and an implementation method.
The invention provides an intelligent city operating system and an implementation method, and the technical scheme is as follows:
optionally, the smart city operating system includes: the 'metadata information recording table of data tables' is used for recording text descriptions of relevant information such as a database of the data tables, table names, purposes, sources, affiliated units and the like in the smart city system.
Optionally, the smart city operating system further includes: the 'metadata information recording table of data items' is used for recording the text description of the related information of the table name, the purpose, the source and the like of the data item in each data table in the smart city system.
Optionally, the smart city operating system further includes: the application information table is used for recording the text description of the uniform resource locator URL, the program name, the affiliated unit, the application, the icon ICO and other related information of each application entry in the smart city system.
Alternatively, the user may reconstruct a new data table using the data in the "metadata information record table of data table" or the "metadata information record table of data item"; and creating a window program, and displaying an icon ICO in an application program information table for a user to call the application program.
Optionally, a search engine may be established by using the data items in the "metadata information record table of data table", "metadata information record table of data item", and "application information table" as information sources, and the user may search the data table, data item, and application containing the keyword by using the search engine.
Alternatively, the records of the "metadata information record table of data table", "metadata information record table of data item", and "application information table" may be added, deleted, or changed.
Alternatively, the text recorded in the "metadata information record table of data table", "metadata information record table of data item" and "application information table" may be segmented and word index files may be created to form a "metadata search engine" of the smart city, and when a user inputs a keyword in a search box, the data table, data item and application containing the keyword may be searched.
Alternatively, a window similar to WINDOWS 'desktop' may be provided, the icon ICO in the table is placed on the 'desktop', the icon ICO is clicked, and the URL in the table is called to run the program.
Alternatively, a permission management table may be created for the "metadata information recording table of data table", the "metadata information recording table of data item", and the "application information table", and respective usage permissions may be set for different users.
Alternatively, the user may select one table as a "search object" from among the "metadata information record table of data table", "metadata information record table of data item", and "application information table", and the search engine searches only the "search object" for the keyword.
Optionally, after a record of a "metadata information record table of a data table" containing a keyword is searched out, a list is displayed, and when a user selects a certain record, the database table is opened for display; when the records of the 'metadata information record table of data items' containing the keywords are searched, the list is displayed, and when a user selects a certain record, the database table where the data item is located is opened for displaying; when the records of the 'application program information table' containing the key words are searched out, the list is displayed, and when a user selects a certain record, the URL in the list 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, and as shown in table 1, a "record table of metadata information of a data table" is established, and specific contents and forms are as follows:
TABLE 1
| Location database | Table name | Use of | Origin of origin | In the unit of |
| 1 | ||||
| 2 | ||||
| , | ||||
| , | ||||
| , |
As shown in table 1, the structure of the "metadata information record table of data table" is that each table of the database corresponds to one record, and the "metadata information record table of data table" can record the text description of the relevant information such as the database, table name, usage, source, affiliated unit, etc. of each data table in the system. It should be understood that the data structure shown in table 1 is not a limitation to the structure of the "table of metadata information records" but is only an exemplary embodiment and may include any other information about the "data table".
Table 2 is a record table of metadata information of optional data items according to an embodiment of the present invention, and as shown in table 2, a "record table of metadata information of data items" is established, and specific contents and forms are as follows:
TABLE 2
As shown in table 2, the "metadata information record table of data items" has a structure, where "data item" in each database table is a record, and a text description of related information such as a table name, a purpose, and a source of each data item in the system can be recorded through the "metadata information record table of data item". It should be understood that the data structure shown in table 2 is not a limitation to the structure of the "metadata information record table for data item", but is only an exemplary embodiment, and may include any other information about the "data item".
Table 3 is an information table of an optional application according to the embodiment of the present invention, and as shown in table 3, an "application information table" is created, and specific contents and forms are as follows:
TABLE 3
| URL | Name of program | The unit of belonged to | Use of | ICO file |
| 1 | ||||
| 2 | ||||
| , | ||||
| , | ||||
| , |
As shown in table 3, each "application" has a record, and a text description of relevant information such as a program entry URL, a program name, a belonging unit, a use, an icon ICO file, and the like of each "application" in the system can be recorded through the "application information table". It should be understood that the data structure shown in table 3 is not a limitation on the structure of the "application information table," but is merely an exemplary embodiment and may include any other information about the "application".
Alternatively, the icon ICO window implementation method may place the icon ICO in the "application information table" in one window, display the "program name" below, and run the program in the program entry uniform resource location URL in the "application information table" when the user selects (mouse click or keyboard selection) the icon ICO of the application.
FIG. 2 is a diagram illustrating an alternative data reconstruction method according to an embodiment of the present invention, such as creating an application window listing records in the "metadata information record table of data table" to allow a user to select a record, as shown in FIG. 2; then according to the 'table name' in the record selected by the user, inquiring all records with the same 'table name' from the 'metadata information record table of the data item' and displaying the records in a list on a screen; the user can select a record from the records and determine a data item of a new data table; the above process is repeated, and the user selects a record from the plurality of metadata information record tables of the data table, and determines the data item of the new data table. And forming a new data table by using the data items of all the new data tables selected by the user until the user determines to end, adding the data items to the 'metadata information record table of the data table', and adding the data items of the new formed table to the 'metadata information record table of the data items'.
Fig. 3 is a schematic diagram of an alternative search method according to an embodiment of the present invention, as shown in fig. 3, a search box is displayed on a screen, and 3 options are set: "metadata information record table of data table", "metadata information record table of data item", and "application information table", the user selects 1 table from the 3 tables as "search target", then enters search "keyword" in the search box, and searches after confirmation.
Alternatively, if the user selects "search target" as "metadata information record table of data table", the data table containing the keyword is listed on the screen, the user selects a certain record, opens the data table, and the list display is performed on the screen.
Alternatively, if the user selects "search target" as "metadata information record table of data item", the data item containing the keyword is listed on the screen, the user selects a certain record, opens the data table where the data item is located, and performs list display on the screen.
Alternatively, if the user selects "search object" as "application information table", the applications containing the keywords are listed on the screen, the user selects a certain record, and the program in the program entry uniform resource locator URL in the "application information table" is run.
Fig. 4 is a schematic diagram of an alternative search engine construction method according to an embodiment of the present invention, and as shown in fig. 4, a crawler program of a "search engine" crawls texts in a "metadata information record table of a data table", a "metadata information record table of a data item", and an "application information table" respectively, performs word segmentation, and establishes 3 index files by respectively using words corresponding to record numbers in the 3 tables.
Alternatively, the index file may be the "a index" of fig. 4 by the word "metadata information recording table of data table".
Alternatively, the file is indexed with the word "metadata information recording table of data items", B index of fig. 4.
Alternatively, the file is indexed with the word "application info table", the "C index" of fig. 4.
The indexed records are as follows:
word 1, record number 2 … …,
word 2, record number 1, record number 2 … …,
word 3, record number 1, record number 2 … …,
……
as shown in fig. 3, in the search process, according to the selection of 3 tables, namely "metadata information record table of data table", "metadata information record table of data item" and "application information table", the "keyword" is searched in the corresponding index file, and the search result set containing the keyword is returned.
Optionally, the user authority management method may set a user table to record user information; the method is characterized in that operation authorities which are recorded in 3 tables of a 'metadata information recording table of a data table', 'metadata information recording table of a data item' and 'application information table' are respectively given to different users, and the method comprises the following steps: query, modify, delete, etc.
By adopting the embodiment of the invention, the smart city operating system can be conveniently used by the user, the user can conveniently and quickly know which data and application programs exist in the smart city system, and the smart city system can be better used.
In a smart city, a lot of data are distributed in each database table, and the traditional method is to directly open the database table for viewing, or to simply search metadata, so that people can judge the needed data. According to the metadata searching scheme provided by the invention, a user can search relevant data from the metadata record table of the relational data table and the metadata record table of the data item just by inputting keywords in the search box like the familiar modern search engines such as hundredths, Google and the like.
By adopting the embodiment of the invention, the technology of recombination and reconstruction can lead a user to adopt a human-computer interaction interface to recombine the data in different database tables and construct a new relational database table, break the data splitting state of the data split in different database tables and be beneficial to the comprehensive utilization of information in smart cities.
By adopting the embodiment of the invention, the technology of application program management can record the uniform resource location URL and the icon ICO of each application program entrance, a user can set a window as a desktop, and can directly click the icon ICO on the desktop like WINDOWS application, and the system calls the URL to run the application program.
According to the large-scale distributed intelligent city data and application program management system provided by the technical scheme, the data tables recorded by the 'metadata information recording table of the data table' can be distributed in different computers and different databases; the URL is uniformly resource-located in the application entry recorded in the "application information table", so that the application can be distributed on any 1 computer in the network, and the application pointed by the URL is called and executed through the browser.
The embodiment of the present invention further provides a storage medium, where the storage medium includes a stored program, and when the program runs, the device on which the storage medium is located is controlled to execute the data processing method.
The embodiment of the invention also provides a processor, wherein the processor is used for running the program, and the data processing method is executed when the program runs.
According to an embodiment of the present invention, there is also provided an embodiment of a data processing apparatus, and it should be noted that the data processing apparatus may be configured 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 may be executed in the data processing apparatus.
Fig. 5 is a schematic diagram of an alternative data processing apparatus according to an embodiment of the present invention, which may include, as shown in fig. 5: a first obtaining unit 51, configured to obtain a first data record table and a second data record table, where one data record in the first data record table is used to indicate a 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 to indicate one data item and a database where the data item is located; a selecting unit 53, configured to select a first data record from a first data record table, where the first data record indicates a name of a target data table; a querying unit 55, configured to query multiple data records with the same name as the target data table from a second data record table, and select a second data record from the multiple data records, where the second data record is used to indicate that the target data item and the data table in which the target data item is located are the target data table; a composing unit 57, configured to compose a target data table according to the target data item, and set a name of the target data table as a target name.
It should be noted that the first obtaining unit 51 in this embodiment may be configured to execute step S102 in this embodiment, the selecting unit 53 in this embodiment may be configured to execute step S104 in this embodiment, the querying unit 55 in this embodiment may be configured to execute step S106 in this embodiment, and the composing unit 57 in this embodiment may be configured to execute step S108 in this embodiment. The modules are the same as the corresponding steps in the realized examples and application scenarios, but are not limited to the disclosure of the above embodiments.
According to the embodiment of the present invention, each data record in the first data record table represents a name of a data table and a database in which the data table is located, each data record in the second data record table represents a data item and a data table including the data item, the first data record table and the second data record table are obtained by the first obtaining unit, and the first data record including the name of the target data table is selected from the first data record table by the selecting unit; through the query unit, a plurality of data records with the same name as the target data table are queried from the second data record table, the data table comprising the target data item and the target data item is selected from the plurality of searched data records with the same name as the target data table as the second data record of the target data table, then the target data item is composed into the target data table according to the second data record through the composition unit, the name of the target data table is set as the target name, so that the target data item can be automatically extracted from the plurality of first data record tables and the plurality of second data record tables through the unit, the target data table is composed according to the extracted target data item, the name of the target data table is set as the target name, and the problem that the prior art adopts a manual mode to arrange the data required by a manager according to the plurality of relation tables is solved, the technical problem of low data processing efficiency is caused.
As an alternative embodiment, the embodiment may further include: the first adding unit is used for adding the information of the target data table into the first data recording table after the target data table is formed according to the target data items and the name of the target data table is set as the target name, wherein the information of the target data table comprises the target name of the target data table; and a second adding unit for adding the information of the target data item to the second data record table.
As an alternative embodiment, the embodiment may further include: the second acquisition unit is used for acquiring a third data record table while acquiring the first data record table and the second data record table, wherein one data record in the third data record table is used for indicating the name of one application program, the program entry uniform resource locator of the application program and the icon of the application program; the device still includes: the detection unit is used for detecting whether touch operation on an icon of the application program exists or not after a 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 under the condition that the touch operation on the icon of the application program is detected, the application program indicated by the program entry uniform resource locator is operated.
As an alternative embodiment, the embodiment may further include: the receiving unit is used for receiving a data search request after the first data record table, the second data record table and the third data record table are obtained, wherein the data search request carries a search object and a search keyword; a first response unit, configured to, in a case where a search target is a first data record table, query a data table matching the search keyword from the first data record table in response to a data search request, and display the queried data table; a second response unit, configured to, in a case where the search object is a second data record table, query, in response to the data search request, a data item that matches the search keyword from the second data record table, and display a data table in which the queried data item is located; the third response unit, in the case where the search object is the third data record table, queries an application program matching the search keyword from the third data record table in response to the data search request, and runs the application program.
As an alternative embodiment, the embodiment may further include: the crawling unit is used for respectively crawling texts in the first data record table, the second data record table and the third data record table for word segmentation after the first data record table, the second data record table and the third data record table are obtained; and the first creating unit is used for respectively creating 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.
As an alternative embodiment, the embodiment may further include: the second creating unit is configured to create a user information table after the first data record table, the second data record table, and the third data record table are acquired, where the user information and a user right are recorded in the user information table, the user right is used to indicate an operation right for the first data record table, the second data record table, and the third data record table, and the operation right includes at least one of: querying data records, modifying data records, deleting data records, and adding data records.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also 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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710606878.3A CN107291951B (en) | 2017-07-24 | 2017-07-24 | Data processing method, device, storage medium and processor |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710606878.3A CN107291951B (en) | 2017-07-24 | 2017-07-24 | Data processing method, device, storage medium and processor |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107291951A CN107291951A (en) | 2017-10-24 |
| CN107291951B true CN107291951B (en) | 2020-09-29 |
Family
ID=60102964
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710606878.3A Active CN107291951B (en) | 2017-07-24 | 2017-07-24 | Data processing method, device, storage medium and processor |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107291951B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109101634B (en) * | 2018-08-15 | 2021-06-11 | 北京三快在线科技有限公司 | Data recording processing method, device, electronic equipment and storage medium |
| CN111121683A (en) * | 2019-12-05 | 2020-05-08 | 山西裕鼎精密科技有限公司 | Data processing apparatus, method and computer storage medium |
| CN112000841B (en) * | 2020-07-29 | 2023-09-26 | 北京达佳互联信息技术有限公司 | Electronic tag data processing method and device, electronic equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0336586A2 (en) * | 1988-04-08 | 1989-10-11 | International Business Machines Corporation | Data storage, retrieval and transmission in computer systems |
| CN1760863A (en) * | 2005-09-30 | 2006-04-19 | 南京大学 | Lookup method of protecting consistency of contour based on information technology products of relational database |
| CN1877573A (en) * | 2005-06-10 | 2006-12-13 | 华夏科技股份有限公司 | Multilayer database system structure |
| CN101639854A (en) * | 2009-09-02 | 2010-02-03 | 北京星网锐捷网络技术有限公司 | Method for acquiring tablename, device and server thereof |
| CN103092980A (en) * | 2013-01-31 | 2013-05-08 | 中国科学院自动化研究所 | Method and system of data automatic conversion and storage |
| CN103617182A (en) * | 2013-11-07 | 2014-03-05 | 宁波保税区攀峒信息科技有限公司 | Basic genetic relationship database construction method and device |
| CN105447200A (en) * | 2015-12-30 | 2016-03-30 | 金蝶软件（中国）有限公司 | Data processing method and data processing apparatus |
| CN105956015A (en) * | 2016-04-22 | 2016-09-21 | 四川中软科技有限公司 | Service platform integration method based on big data |
-
2017
- 2017-07-24 CN CN201710606878.3A patent/CN107291951B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0336586A2 (en) * | 1988-04-08 | 1989-10-11 | International Business Machines Corporation | Data storage, retrieval and transmission in computer systems |
| CN1877573A (en) * | 2005-06-10 | 2006-12-13 | 华夏科技股份有限公司 | Multilayer database system structure |
| CN1760863A (en) * | 2005-09-30 | 2006-04-19 | 南京大学 | Lookup method of protecting consistency of contour based on information technology products of relational database |
| CN101639854A (en) * | 2009-09-02 | 2010-02-03 | 北京星网锐捷网络技术有限公司 | Method for acquiring tablename, device and server thereof |
| CN103092980A (en) * | 2013-01-31 | 2013-05-08 | 中国科学院自动化研究所 | Method and system of data automatic conversion and storage |
| CN103617182A (en) * | 2013-11-07 | 2014-03-05 | 宁波保税区攀峒信息科技有限公司 | Basic genetic relationship database construction method and device |
| CN105447200A (en) * | 2015-12-30 | 2016-03-30 | 金蝶软件（中国）有限公司 | Data processing method and data processing apparatus |
| CN105956015A (en) * | 2016-04-22 | 2016-09-21 | 四川中软科技有限公司 | Service platform integration method based on big data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107291951A (en) | 2017-10-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9569506B2 (en) | Uniform search, navigation and combination of heterogeneous data | |
| CN103177075B (en) | The detection of Knowledge based engineering entity and disambiguation | |
| US8473473B2 (en) | Object oriented data and metadata based search | |
| US9870392B2 (en) | Retrieval method and system | |
| US7788259B2 (en) | Locating, viewing and interacting with information sources | |
| US20140280287A1 (en) | Assisted query formation, validation, and result previewing in a database having a complex schema | |
| US20080040326A1 (en) | Method and apparatus for organizing data sources | |
| JP2013531289A (en) | Use of model information group in search | |
| KR101505858B1 (en) | A templet-based online composing system for analyzing reports or views of big data by providing past templets of database tables and reference fields | |
| CN107015987B (en) | Method and equipment for updating and searching database | |
| CN104699841A (en) | Method and device for providing list summary information of search results | |
| CN107291951B (en) | Data processing method, device, storage medium and processor | |
| CN112269816B (en) | Government affair appointment correlation retrieval method | |
| US11308177B2 (en) | System and method for accessing and managing cognitive knowledge | |
| CA2461871A1 (en) | An efficient index structure to access hierarchical data in a relational database system | |
| US9208150B2 (en) | Automatic association of informational entities | |
| CN111400323A (en) | Data retrieval method, system, device and storage medium | |
| CN110543477A (en) | label construction system and method | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| CN101836209A (en) | System and method for managing information map | |
| CN111190965A (en) | Text data-based ad hoc relationship analysis system and method | |
| CN104240107B (en) | Community data screening system and method thereof | |
| Ajoudanian et al. | Deep web content mining | |
| CN116414854A (en) | Data asset query method, device, computer equipment and storage medium | |
| CN108694213A (en) | Generation method, search method and the device of journal file |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |