Shulou(Shulou.com)06/01 Report--

What this article shares with you is about which data source types the big data reporting tool supports. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Let's take a look at it with the editor.

1. Relational database

Relational database is the basic function that report tools must support. Whether you connect to the database in JDBC or ODBC, the report tool should be able to count it. If a report tool supports only part of the relational database processing, then the report tool can be eliminated when selecting the type.

In addition, if the report tool can improve some of the shortcomings of the database itself and simplify the operation, then the performance-to-price ratio of the report tool is very high, such as simplifying the non-equivalent grouping of sql, optimizing Join performance and so on.

two。 Non-relational database

Common non-relational databases are: Hbase, Redis, Mongodb, Hive, Hadoop and so on. The more types the report tool supports, the better. However, most report tools generally provide a custom data source interface and use high-level languages such as Java to write the calculation program of the data source, which will increase the degree of coupling and later maintenance workload. If the report tool can provide a general processing method, it will be more convenient for data processing and operation.

3. Other

Other data source types include: semi-structured data (json, xml, etc.), http data sources, txt/excel/csv and other single files such as the support of data sources and reporting tools for non-relational databases are the same, there are also java code implementation complexity and coupling problems.

The dry report supports two relational database connection methods: JDBC and ODBC:

The referencing method of the file data source is also very simple, and the data structure in the file can be identified directly through the configuration file path:

For non-relational database and other types of data source processing, it not only provides java custom data source mode, but also provides external library processing mode. This method has built-in various functions for non-relational database, which can link the database, carry out data operation, and return the calculated results to the report data set.

The above are the data source types supported by big data report tool, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.