CN110674163A - Heterogeneous data query system and method based on BS framework - Google Patents
Heterogeneous data query system and method based on BS framework Download PDFInfo
- Publication number
- CN110674163A CN110674163A CN201910790935.7A CN201910790935A CN110674163A CN 110674163 A CN110674163 A CN 110674163A CN 201910790935 A CN201910790935 A CN 201910790935A CN 110674163 A CN110674163 A CN 110674163A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- module
- model
- source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a heterogeneous data query system based on a BS framework and a method thereof, wherein the system comprises a server end and a browser end, the server end comprises an account management module, a data source management module, a data model management module and a data storage module, and the browser end comprises a data query module and a data display module. The method comprises the following steps: s1, creating an account, a data source and a data model, acquiring a data table in a relational database by using the data source, associating the data table by using the data model, and processing data in the data table; s2, inquiring a data source or a data table in the data model according to the inquiry conditions to obtain inquiry data; s3, establishing a data list by using an HTML5 technology to display query data; and S4, storing the data generated in the inquiry process in the data storage module in real time. The system and the method can provide a safe, stable and efficient mass data query function and have good cross-platform performance.
Description
Technical Field
The invention relates to an efficient heterogeneous data query system and a method thereof, belonging to the technical field of heterogeneous data query.
Background
At present, informatization is deeply carried out in governments, enterprises and all corners of daily life of people, operators and decision makers gradually realize that data in an information system has huge value, a Business Intelligence (BI) becomes a focus of social attention, and the BI can centralize data scattered in various places for analysis and query so as to help the decision makers to make scientific operation decisions.
The analysis and query of massive heterogeneous data need many links, each link needs a lot of rigorous work, in order to accurately query data and obtain results, technicians with high professional knowledge often need to spend a long time to arrange and analyze the massive heterogeneous data, the corresponding labor, material and time costs are high, the requirements of most enterprises on data query cannot be met, and the actual popularization and use are not facilitated.
Disclosure of Invention
In order to solve the problems of high difficulty and high cost of query operation of massive heterogeneous data, the invention provides a heterogeneous data query system based on a BS framework and a method thereof, the system integrally adopts a B/S framework, a server end adopts a J2EE framework, various common operating systems can be supported, a browser end adopts an HTML5 technology, and the heterogeneous data query system can be widely applied to most of the existing devices and platforms, and realizes cross-platform operation. The system adopts a modular design, directly obtains the data table from the database, analyzes and processes the data, further queries and displays the data according to query conditions, realizes high cohesion and low coupling among modules, is simple and visual in system operation, and is safe, stable and efficient in data query process.
In order to solve the technical problems, the invention adopts the following technical means:
a heterogeneous data query system based on a BS framework comprises a server side and a browser side, wherein the server side comprises an account management module, a data source management module, a data model management module and a data storage module, and the browser side comprises a data query module and a data display module.
The account management module is used for creating, modifying, deleting and inquiring accounts on one hand, and is used for granting, modifying and identifying account authority on the other hand, and provides a function of logging in a system for the accounts; the data source management module is used for creating, modifying, deleting and inquiring a data source, the data source is connected with a relational database to be inquired through a database connection pool, and a data table is obtained from the relational database; the data model management module is used for creating, modifying, deleting and inquiring a data model, wherein the data model comprises data tables acquired by at least two data sources, is used for associating data fields in the data tables, and calculates the data fields through functions in a function library to obtain a calculation result; the data storage module is used for storing the working logs generated by the account management module, the data source management module, the data model management module, the data query module and the data display module; the data query module is used for calling a data model and a data source and querying data from a data table according to a user-defined query condition; and the data display module is used for displaying the data inquired by the data inquiry module in a list form.
Further, the server side adopts a J2EE framework.
Further, the relational database comprises Oracle, SQL Server, MySQL and PostgreSQL.
Further, the function library includes an aggregation function, a mathematical function, a string function, and a date-time function.
Further, the data presentation module employs HTML5 technology.
Further, the system further comprises a data sharing module, and the data sharing module shares the list data displayed by the data display module to other users or a third-party platform in a URL mode.
A heterogeneous data query method based on a BS framework comprises the following steps:
s1, respectively creating an account, a data source and a data model at the server, and acquiring a data table in the relational database by using the data source;
s2, associating the data table obtained by the data source by using the data model, and processing the data fields in the data table according to the custom function to obtain the calculation result corresponding to the data fields;
s3, inquiring a data table in a data source or a data table in a data model according to the inquiry condition, and obtaining the inquiry data by calculating the result;
s4, establishing a data list by using an HTML5 technology to display query data, establishing a data sharing link in a URL mode, and sharing the data list to a specified user or a third-party platform;
and S5, storing the account, the data source, the data model, the data query record, the data display record and the data sharing record in the data storage module in real time.
Further, the step S2 is to associate the data model with the data table obtained by the data source, and the specific operations are as follows:
according to the data query requirement, at least two data tables are selected from the data tables acquired from the data source, one or more data fields are selected from each data table, and the selected data fields are associated according to a self-defined association mode.
Further, the specific operation of step S3 is:
when the data source is directly called, a data table to be inquired is obtained through the data source, an inquiry condition is set in a data inquiry module, and data in the data table is inquired according to the inquiry condition to obtain inquiry data;
when the data model is directly called, obtaining a data table associated in the data model and a calculation result of the data model, setting a screening condition and an inquiry condition, screening the calculation result of the data model according to the screening condition, obtaining screened data according to the screened calculation result, and inquiring the screened data according to the inquiry condition to obtain the inquiry data.
Further, the query condition includes a query field, a comparison operator and an external condition parameter, the query field is a data field in a data table, and the external condition parameter refers to a specific value or a value range limiting the query field; the screening conditions include a screening rule or a screening group.
The following advantages can be obtained by adopting the technical means:
the invention provides a heterogeneous data query system based on a BS framework and a method thereof, wherein the system adopts a B/S framework, a service end adopts a J2EE technology, a browser end adopts an HTML technology, the system compatibility is strong, and the system can be well adapted to various operating systems and clients. The system and the method of the invention utilize the database connection pool to connect and manage the data tables in the database, can quickly acquire the data in database platforms such as a mainstream relational database, a data warehouse and the like, and realize the quick acquisition of the total data. The system module is constructed facing business personnel by utilizing a visual semantic mapping design and an interactive designer, the business personnel can realize model creation and data processing only by selecting a data table to be processed and an operation to be carried out in a data model management module, and the query conditions are set in a data query module according to business requirements, so that the division query of mass data can be carried out, the operation difficulty of the system is reduced, and the data query speed is improved. The system and the method can share the inquired data to other users or a third-party platform in a URL mode, the processing of the inquiry result is more flexible, and the third-party application integration is facilitated. The system and the method can provide a safe, stable and efficient mass data query function, realize high cohesion and low coupling among modules, have simple system operation and visualized query results, and have good cross-platform performance.
Drawings
Fig. 1 is a schematic structural diagram of a BS-based heterogeneous data query system according to the present invention.
FIG. 2 is a schematic diagram of a page for creating a data source according to an embodiment of the present invention.
FIG. 3 is a schematic diagram of a page of a data presentation module according to an embodiment of the present invention.
Fig. 4 is a schematic page diagram of an SQL statement that displays a generated list in the embodiment of the present invention.
Fig. 5 is a flowchart illustrating steps of a BS-based heterogeneous data query method according to the present invention.
Fig. 6 is a schematic page diagram of creating a data model according to an embodiment of the present invention, where (a) is a schematic page diagram of associating a data table for the data model, and (b) is a schematic page diagram of calculating data fields for the data model.
Fig. 7 is a schematic page diagram illustrating setting of a filtering condition in the embodiment of the present invention.
In the figure, 1 is a server, 2 is a browser, 101 is an account management module, 102 is a data source management module, 103 is a data model management module, 104 is a data storage module, 201 is a data query module, 202 is a data presentation module, and 203 is a data sharing module.
Detailed Description
The technical scheme of the invention is further explained by combining the accompanying drawings as follows:
a heterogeneous data query system based on a BS framework is shown in FIG. 1 and comprises a server end 1 and a browser end 2, in order to improve system compatibility and facilitate integration with a third-party platform, the server end adopts a J2EE framework, and the browser end adopts an HTML5 technology. The server side comprises an account management module 101, a data source management module 102, a data model management module 103 and a data storage module 104, and the browser side comprises a data query module 201, a data display module 202 and a data sharing module 203.
The account management module is a service core of the system, and is used for creating, modifying, deleting and inquiring accounts on one hand, and granting, modifying and authenticating account authority on the other hand, and the JWT-based single sign-on system provides the functions of a sign-on system for the accounts. The account in the system comprises a unique account ID, an account name and account authority, a user can inquire the account in the account management module through the account ID or the account name, the account authority is used for limiting the operation of the account in the system, for example, the account A is only granted with the right of inquiring data, so the account A only can access the data inquiry module and the data display module, the inquiry operation is carried out on the basis of the existing data of the system, and the data source management module, the data model management module and other modules cannot be accessed and used.
The data source management module is mainly used for creating, modifying, deleting and querying a data source, as shown in fig. 2, when a new data source is created, the following parameters need to be input: the method comprises the following steps of data source name (file name), connection pool drive, database dialect, database drive, database link, database user name, database password and the like, wherein the database dialect is the language of a database to be connected with the data source, such as mysql, oracle and the like, the database link is a jdbc string used for connecting the database, a data source generally establishes a connection relation with a fixed database, and in order to establish safe connection, the database user name and the database password need to be set in the data source. The data source in the system supports the relational databases such as Oracle, SQL Server, MySQL, PostgreSQL and the like, and the data table comprises data fields and records.
In order to facilitate the non-professional service personnel to carry out data processing and analysis operations, the system of the invention introduces a data model, the complex data processing and analysis process is modularized through a visual language mapping design and an interactive designer, a data model management module is mainly used for creating, modifying, deleting and inquiring the data model, the corresponding data model can be inquired through the conditions of file names, authors, start time, end time and the like, and the existing data module can also be edited, deleted, renamed and the like. The data model is a model for processing data in data tables acquired by data sources, and the data model comprises at least two data tables acquired by the data sources, and can be two data tables acquired by the same data source or two data tables acquired by different data sources. The user can associate data fields in different data tables in the data model to obtain the associated data tables, the association mode comprises an inner connection and an outer connection, the outer connection can be divided into a left connection, a right connection and a full connection, the inner connection refers to selecting a common record meeting the conditions in each data table, namely returning to the intersection part of the two data tables; the left connection means finds out the records meeting the conditions in the connected right table according to all the records in the left table, matches the records, returns all the records in the left table and the records matched in the right table, and fills with null if the records matched with the left table are not in the right table; the right connection is opposite to the left connection, all records in the right table and the matching records meeting the conditions in the left table are returned, and null is used for filling when no matching record exists; full join refers to selecting all records in the two data tables that meet the condition, and when there is no record matching the condition, filling with null, and returning the union of the two data tables. The data model calculates the data fields through functions in a function library after associating the data fields to obtain a calculation result, the function library in the system mainly comprises an aggregation function, a mathematical function, a character string function and a date-time function, the calculation result is generally one or more groups of data according to different adopted functions, and the calculation result is composed of the data fields and data items corresponding to the data fields. In the system, the data model management module is not necessary, the data model only provides more analysis and processing operations for the data table, and the data can be directly inquired by using a data source without the data module according to the inquiry requirement of the system.
The data storage module is mainly used for storing the working logs generated by the account management module, the data source management module, the data model management module, the data query module and the data display module. The data stored in the data storage module can record the running state of the system, and provide a data basis for functions such as system problem tracing, system tuning and the like.
The data query module is a core module of the system, can call a data model and a data source in the system, and queries data from a data table according to a query condition defined by a user. When a data query module directly calls one or more data tables in a data source, generally, query conditions are directly defined on a query page, and query data are directly extracted from the data tables according to the query conditions; when the data query module calls the data model, generally, a screening condition is defined first, the calculation result of the data model is screened for the first time, the screened data table is obtained according to the screening result, then the query condition is defined, and the query data is extracted from the screened data table according to the query condition.
In order to enable a user to visually see a data query result, the system is provided with the data display module, the data display module adopts the HTML5 technology, after the data query module performs query operation, the data display module acquires data queried by the data query module, and the data queried by the data query module is displayed on a page in a list form. Fig. 3 is a schematic diagram of a page of a data presentation module in an embodiment of the present invention, where a "query" button in the upper right corner of a page is clicked, a list containing query data may be displayed on the page, and the data presentation module may also be configured to preview an SQL statement for generating the list, and click on the "display SQL" in the upper right corner, so that a new window may be popped up on the page, and the SQL statement for generating the list is displayed, as shown in fig. 4.
The system is mainly used for quickly and conveniently inquiring data, in the field of mass data inquiry, the inquired data often has certain specificity and can be used as reference to help a user make scientific decisions, in order to be more convenient for the user to spread, use and store the inquired data, the system is provided with the data sharing module, the data sharing module shares a data list displayed by the data display module to other users or a third-party platform in a URL (uniform resource locator) mode, in addition, the data sharing module also provides a function of downloading the data list, and the user can select the storage position and the storage name of the downloaded data list.
The invention also provides a heterogeneous data query method based on the BS framework, as shown in FIG. 5, comprising the following steps:
and S1, respectively creating an account, a data source and a data model at the server according to the query requirement, if the user who performs the query operation has the account authority, directly logging in the account to perform the query, and similarly, if the data which needs to be queried and the data source and the data model which are created, directly calling the existing data source and the existing data model. And acquiring a required data table from a relational database connected with the data source by using the connection relation provided by the data source.
S2, associating the data model with the data table acquired by the data source, specifically operating as follows:
according to the data query requirement, at least two data tables are selected from the data tables acquired from the data source, wherein the data tables can be the data tables in the same database acquired from the same data source or the data tables in different databases acquired from different data sources, the selected data tables are dragged to a blank page of the data model management module by using a mouse, one table is dragged to another table on the blank page to carry out table connection, further, one or more data fields are selected from each data table, and the selected data fields are associated according to a self-defined association mode. The association of the method of the present invention generally includes inner connections, left connections, right connections and full connections. In a specific embodiment of the present invention, the page of the associated data table is as shown in (a) in fig. 6, in which the data table "gong _ zuo _ ji _ lu" and "gong _ zuo _ ji _ lu _ detail" are associated, a creation time field in the "gong _ zuo _ ji _ lu" table and a work record id, a work type id, a work proportion, a work content, and an item name id field in the "gong _ zuo _ ji _ lu _ detail" table are respectively selected as associated fields, and a right connection is selected as an associated mode.
Selecting data fields needing further calculation and processing in the data model according to the service requirements, processing the data fields in the data table according to the custom function to obtain calculation results corresponding to the data fields, and processing the data fields in the data table according to the custom function to obtain calculation results corresponding to the data fields. Fig. 6 (b) is a schematic page diagram illustrating data field calculation performed in the embodiment of the present invention, in which a user selects an aggregation function to perform aggregation calculation on a primary key field in a "gong _ zuo _ ji _ lu" table, and after the user clicks and determines that the primary key field is calculated, a calculation result is obtained by automatically calculating a data model, where the calculation result generally includes a data field and a data item corresponding to the data field.
S3, inquiring a data table in a data source or a data table in a data model according to the inquiry condition, and obtaining the inquiry data by calculating the result; the specific operation is as follows:
when the data source is directly called, the data table to be inquired is obtained through the data source, the inquiry condition is set in the data inquiry module, and the data in the data table is inquired according to the inquiry condition to obtain the inquiry data. The query condition has the action object of data in the data table, the query condition comprises a query field, a comparison operator and an external condition parameter, the query field is selected from the data field in the data table to be queried, the comparison operator comprises a value greater than, less than, equal to, greater than or equal to and less than or equal to, and the external condition parameter is a specific value or a value range which is manually set and is used for limiting the data item corresponding to the query field.
When the data model is directly called, obtaining a data table associated in the data model and a calculation result of the data model, setting a screening condition and an inquiry condition, screening the calculation result of the data model according to the screening condition, obtaining screened data according to the screened calculation result, and inquiring the screened data according to the inquiry condition to obtain the inquiry data. When the data model is called, because the data model contains more data, in order to avoid that too much useless data occurs during query to influence the query efficiency, the first filtering is carried out by utilizing the screening condition, the action object of the screening condition is the calculation result of the data model, the second filtering is carried out by utilizing the query condition, and the action object of the query condition is the data in the data table after the first filtering. The screening conditions comprise screening rules or screening groups, the screening rules are used for comparing data in the calculation results with a user-defined value range and screening the calculation results meeting the value range, and the screening groups are used for grouping the data in the calculation results according to user-defined logic. Fig. 7 is a schematic diagram of a page for setting a filtering condition in an embodiment of the present invention, where the filtering rule is data with a workload proportion equal to 50 in the filtering table.
S4, establishing data list display query data by using an HTML5 technology, creating a data sharing link in a URL mode, sharing the data list to a specified user or a third-party platform, and simultaneously downloading and storing the data list.
And S5, storing the account for data query, the data source for data query call, the data model, the data query record, the data display record, the data sharing record and the like in the data storage module in real time in the whole data query process, so that the subsequent call of the related information is facilitated. The data query records comprise query start time, query end time, queried data and the like, the data display records comprise generated data lists, display platforms, display time and the like, and the data sharing records comprise data sharing links, sharing time, shared users or third-party platforms and the like.
The embodiments of the present invention have been described in detail with reference to the drawings, but the present invention is not limited to the above embodiments, and various changes can be made within the knowledge of those skilled in the art without departing from the gist of the present invention.
Claims (10)
1. The heterogeneous data query system based on the BS framework is characterized by comprising a server side and a browser side, wherein the server side comprises an account management module, a data source management module, a data model management module and a data storage module, and the browser side comprises a data query module and a data display module;
the account management module is used for creating, modifying, deleting and inquiring accounts on one hand, and is used for granting, modifying and identifying account authority on the other hand, and provides a function of logging in a system for the accounts;
the data source management module is used for creating, modifying, deleting and inquiring a data source, the data source is connected with a relational database to be inquired through a database connection pool, and a data table is obtained from the relational database;
the data model management module is used for creating, modifying, deleting and inquiring a data model, wherein the data model comprises data tables acquired by at least two data sources, is used for associating data fields in the data tables, and calculates the data fields through functions in a function library to obtain a calculation result;
the data storage module is used for storing the working logs generated by the account management module, the data source management module, the data model management module, the data query module and the data display module;
the data query module is used for calling a data model and a data source and querying data from a data table according to a user-defined query condition;
and the data display module is used for displaying the data inquired by the data inquiry module in a list form.
2. The BS architecture-based heterogeneous data query system of claim 1, wherein the server side employs a J2EE architecture.
3. The BS framework-based heterogeneous data query system of claim 1, wherein the relational database comprises Oracle, SQL Server, MySQL, PostgreSQL.
4. The BS framework-based heterogeneous data query system of claim 1, wherein the function library comprises an aggregation function, a mathematical function, a string function, and a time-of-day function.
5. The BS framework-based heterogeneous data query system of claim 1, wherein the data presentation module employs HTML5 technology.
6. The BS framework-based heterogeneous data query system according to claim 1, further comprising a data sharing module, wherein the data sharing module shares list data displayed by the data display module to other users or a third-party platform in a URL manner.
7. A heterogeneous data query method based on a BS framework is characterized by comprising the following steps:
s1, respectively creating an account, a data source and a data model at the server, and acquiring a data table in the relational database by using the data source;
s2, associating the data table obtained by the data source by using the data model, and processing the data fields in the data table according to the custom function to obtain the calculation result corresponding to the data fields;
s3, inquiring a data table in a data source or a data table in a data model according to the inquiry condition, and obtaining the inquiry data by calculating the result;
s4, establishing a data list by using an HTML5 technology to display query data, establishing a data sharing link in a URL mode, and sharing the data list to a specified user or a third-party platform;
and S5, storing the account, the data source, the data model, the data query record, the data display record and the data sharing record in the data storage module in real time.
8. The BS framework-based heterogeneous data query method as claimed in claim 7, wherein the step S2 of associating the data model with the data table obtained by the data source specifically comprises:
according to the data query requirement, at least two data tables are selected from the data tables acquired from the data source, one or more data fields are selected from each data table, and the selected data fields are associated according to a self-defined association mode.
9. The BS framework-based heterogeneous data query method according to claim 7, wherein the specific operation of step S3 is:
when the data source is directly called, a data table to be inquired is obtained through the data source, an inquiry condition is set in a data inquiry module, and data in the data table is inquired according to the inquiry condition to obtain inquiry data;
when the data model is directly called, obtaining a data table associated in the data model and a calculation result of the data model, setting a screening condition and an inquiry condition, screening the calculation result of the data model according to the screening condition, obtaining screened data according to the screened calculation result, and inquiring the screened data according to the inquiry condition to obtain the inquiry data.
10. The BS-based heterogeneous data query method of claim 9, wherein the query condition comprises a query field, a comparison operator, and an external condition parameter, the query field is a data field in a data table, and the external condition parameter refers to a specific value or a value range that limits the query field; the screening conditions include a screening rule or a screening group.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910790935.7A CN110674163A (en) | 2019-08-26 | 2019-08-26 | Heterogeneous data query system and method based on BS framework |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910790935.7A CN110674163A (en) | 2019-08-26 | 2019-08-26 | Heterogeneous data query system and method based on BS framework |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110674163A true CN110674163A (en) | 2020-01-10 |
Family
ID=69075576
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910790935.7A Pending CN110674163A (en) | 2019-08-26 | 2019-08-26 | Heterogeneous data query system and method based on BS framework |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110674163A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111639910A (en) * | 2020-05-27 | 2020-09-08 | 中国建设银行股份有限公司 | Standing book generation method, device, equipment and storage medium |
| CN111858566A (en) * | 2020-06-15 | 2020-10-30 | 邯郸钢铁集团有限责任公司 | Real-time data extraction application method |
| CN111949721A (en) * | 2020-08-25 | 2020-11-17 | 深圳市广通软件有限公司 | Method, system and storage medium for realizing quick access of Web database |
| CN116431646A (en) * | 2023-04-20 | 2023-07-14 | 北京瑞风协同科技股份有限公司 | Modeling and hierarchical control device and method for data model |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101799826A (en) * | 2010-03-04 | 2010-08-11 | 中国电子科技集团公司第二十八研究所 | Networking data sharing system and method based on virtual view |
| CN101958883A (en) * | 2010-03-26 | 2011-01-26 | 湘潭大学 | Bloom Filter and open-source kernel-based method for defensing SYN Flood attack |
| CN104008135A (en) * | 2014-05-07 | 2014-08-27 | 南京邮电大学 | Multi-source heterogeneous database fusion system and data query method thereof |
| CN104765883A (en) * | 2015-04-30 | 2015-07-08 | 中电运行(北京)信息技术有限公司 | Detection method used for Webshell |
| CN105912624A (en) * | 2016-04-07 | 2016-08-31 | 北京中安智达科技有限公司 | Query method for distributed deployed heterogeneous database |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN106933904A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The filter method and device of data |
| CN107066499A (en) * | 2016-12-30 | 2017-08-18 | 江苏瑞中数据股份有限公司 | The data query method of multi-source data management and visualization system is stored towards isomery |
| CN108255955A (en) * | 2017-12-20 | 2018-07-06 | 新华三大数据技术有限公司 | A kind of data processing method and device |
| CN108446289A (en) * | 2017-09-26 | 2018-08-24 | 北京中安智达科技有限公司 | A kind of data retrieval method for supporting heterogeneous database |
| CN109344186A (en) * | 2018-08-23 | 2019-02-15 | 成都四方伟业软件股份有限公司 | A kind of BI system Various database is across the inter-library emerging system in source and fusion method |
| CN109815283A (en) * | 2018-12-18 | 2019-05-28 | 中科曙光南京研究院有限公司 | A kind of heterogeneous data source visual inquiry method |
| CN109920541A (en) * | 2019-03-21 | 2019-06-21 | 武汉千屏影像技术有限责任公司 | A kind of pathological diagnosis method based on data analysis |
-
2019
- 2019-08-26 CN CN201910790935.7A patent/CN110674163A/en active Pending
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101799826A (en) * | 2010-03-04 | 2010-08-11 | 中国电子科技集团公司第二十八研究所 | Networking data sharing system and method based on virtual view |
| CN101958883A (en) * | 2010-03-26 | 2011-01-26 | 湘潭大学 | Bloom Filter and open-source kernel-based method for defensing SYN Flood attack |
| CN104008135A (en) * | 2014-05-07 | 2014-08-27 | 南京邮电大学 | Multi-source heterogeneous database fusion system and data query method thereof |
| CN104765883A (en) * | 2015-04-30 | 2015-07-08 | 中电运行(北京)信息技术有限公司 | Detection method used for Webshell |
| CN106933904A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The filter method and device of data |
| CN105912624A (en) * | 2016-04-07 | 2016-08-31 | 北京中安智达科技有限公司 | Query method for distributed deployed heterogeneous database |
| CN107066499A (en) * | 2016-12-30 | 2017-08-18 | 江苏瑞中数据股份有限公司 | The data query method of multi-source data management and visualization system is stored towards isomery |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN108446289A (en) * | 2017-09-26 | 2018-08-24 | 北京中安智达科技有限公司 | A kind of data retrieval method for supporting heterogeneous database |
| CN108255955A (en) * | 2017-12-20 | 2018-07-06 | 新华三大数据技术有限公司 | A kind of data processing method and device |
| CN109344186A (en) * | 2018-08-23 | 2019-02-15 | 成都四方伟业软件股份有限公司 | A kind of BI system Various database is across the inter-library emerging system in source and fusion method |
| CN109815283A (en) * | 2018-12-18 | 2019-05-28 | 中科曙光南京研究院有限公司 | A kind of heterogeneous data source visual inquiry method |
| CN109920541A (en) * | 2019-03-21 | 2019-06-21 | 武汉千屏影像技术有限责任公司 | A kind of pathological diagnosis method based on data analysis |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111639910A (en) * | 2020-05-27 | 2020-09-08 | 中国建设银行股份有限公司 | Standing book generation method, device, equipment and storage medium |
| CN111858566A (en) * | 2020-06-15 | 2020-10-30 | 邯郸钢铁集团有限责任公司 | Real-time data extraction application method |
| CN111949721A (en) * | 2020-08-25 | 2020-11-17 | 深圳市广通软件有限公司 | Method, system and storage medium for realizing quick access of Web database |
| CN116431646A (en) * | 2023-04-20 | 2023-07-14 | 北京瑞风协同科技股份有限公司 | Modeling and hierarchical control device and method for data model |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110674163A (en) | Heterogeneous data query system and method based on BS framework | |
| US20180246886A1 (en) | Data migration for platform integration | |
| US7421442B2 (en) | System and method for data capture and reporting | |
| KR20210141640A (en) | Natural language-based processing methods for data stored in heterogeneous data sources | |
| US9626453B2 (en) | Analytic solution with a self-learning and context-sensitive semantic layer | |
| US11288319B1 (en) | Generating trending natural language request recommendations | |
| US9569511B2 (en) | Dynamic data management | |
| US10296505B2 (en) | Framework for joining datasets | |
| KR101201019B1 (en) | Declarative sequenced report parameterization | |
| US9798813B2 (en) | Extensible person container | |
| US11494395B2 (en) | Creating dashboards for viewing data in a data storage system based on natural language requests | |
| US20140250040A1 (en) | Correlating data from multiple business processes to a business process scenario | |
| CN112000773A (en) | Data association relation mining method based on search engine technology and application | |
| US20190034247A1 (en) | Creating alerts associated with a data storage system based on natural language requests | |
| US20040083422A1 (en) | System and method for automatically generating patent analysis reports | |
| TW202004526A (en) | Index creating method and apparatus based on NoSQL database of mobile terminal | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| CN117056308A (en) | Method for generating financial big data blood-edge relation based on OpenLinear database | |
| CN111382256A (en) | Information recommendation method and device | |
| CN107291951B (en) | Data processing method, device, storage medium and processor | |
| CN111125045B (en) | Lightweight ETL processing platform | |
| KR101757849B1 (en) | Rule-group management apparatus and method | |
| CN114490698A (en) | Product record query method, device, equipment and medium | |
| CN110389944B (en) | Metadata management system and method based on model | |
| US11914612B2 (en) | Selective synchronization of linked records |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200110 |
|
| RJ01 | Rejection of invention patent application after publication |