GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → datageartech → Datagear

datageartech / Datagear

Licence: lgpl-3.0
数据可视化分析平台，使用Java语言开发，采用浏览器/服务器架构，支持SQL、CSV、Excel、HTTP接口、JSON等多种数据源

Programming Languages

java
68154 projects - #9 most used programming language

Labels

sqldashboarddata-visualizationdatadatasetdata-analysischart

Projects that are alternatives of or similar to Datagear

Data Science Resources
👨🏽‍🏫You can learn about what data science is and why it's important in today's modern world. Are you interested in data science?🔋
Stars: ✭ 171 (-35.71%)
Mutual labels:  dataset, data-analysis, data, data-visualization
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company 😋
Stars: ✭ 26,803 (+9976.32%)
Mutual labels:  data-analysis, data, data-visualization, dashboard
Just Dashboard
📊 📋 Dashboards using YAML or JSON files
Stars: ✭ 1,511 (+468.05%)
Mutual labels:  data, data-visualization, chart, dashboard
Data Science Hacks
Data Science Hacks consists of tips, tricks to help you become a better data scientist. Data science hacks are for all - beginner to advanced. Data science hacks consist of python, jupyter notebook, pandas hacks and so on.
Stars: ✭ 273 (+2.63%)
Mutual labels:  dataset, data-analysis, data, data-visualization
Volbx
Graphical tool for data manipulation written in C++/Qt
Stars: ✭ 187 (-29.7%)
Mutual labels:  data-analysis, data, data-visualization
Aachartkit Swift
📈📊📱💻🖥️An elegant modern declarative data visualization chart framework for iOS, iPadOS and macOS. Extremely powerful, supports line, spline, area, areaspline, column, bar, pie, scatter, angular gauges, arearange, areasplinerange, columnrange, bubble, box plot, error bars, funnel, waterfall and polar chart types. 极其精美而又强大的跨平台数据可视化图表框架,支持柱状图、条形图、…
Stars: ✭ 1,962 (+637.59%)
Mutual labels:  data-analysis, data-visualization, chart
Poli
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
Stars: ✭ 1,850 (+595.49%)
Mutual labels:  sql, data-visualization, dashboard
Awesome Business Intelligence
Actively curated list of awesome BI tools. PRs welcome!
Stars: ✭ 1,157 (+334.96%)
Mutual labels:  sql, data-analysis, data-visualization
Openrefine
OpenRefine is a free, open source power tool for working with messy data and improving it
Stars: ✭ 8,531 (+3107.14%)
Mutual labels:  data-analysis, data, data-visualization
Helicalinsight
Helical Insight software is world’s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions.
Stars: ✭ 214 (-19.55%)
Mutual labels:  data-analysis, data-visualization, dashboard
Sourced Ce
source{d} Community Edition (CE)
Stars: ✭ 153 (-42.48%)
Mutual labels:  sql, data-analysis, data-visualization
Startr
A template for data journalism in R
Stars: ✭ 69 (-74.06%)
Mutual labels:  data-analysis, data, data-visualization
Tabix
Tabix.io UI
Stars: ✭ 1,152 (+333.08%)
Mutual labels:  data-analysis, data-visualization, dashboard
Cubes
Light-weight Python OLAP framework for multi-dimensional data analysis
Stars: ✭ 1,393 (+423.68%)
Mutual labels:  sql, data-analysis, data
Graphia
A visualisation tool for the creation and analysis of graphs
Stars: ✭ 67 (-74.81%)
Mutual labels:  data-analysis, data, data-visualization
Tablesaw
Java dataframe and visualization library
Stars: ✭ 2,785 (+946.99%)
Mutual labels:  data-analysis, data-visualization, chart
Datascience course
Curso de Data Science em Português
Stars: ✭ 294 (+10.53%)
Mutual labels:  dataset, data-analysis, data
Knowage Server
Knowage is the professional open source suite for modern business analytics over traditional sources and big data systems.
Stars: ✭ 276 (+3.76%)
Mutual labels:  dataset, data-analysis, data-visualization
Football Data
football (soccer) datasets
Stars: ✭ 18 (-93.23%)
Mutual labels:  dataset, data-analysis, data-visualization
Data Forge Ts
The JavaScript data transformation and analysis toolkit inspired by Pandas and LINQ.
Stars: ✭ 967 (+263.53%)
Mutual labels:  data-analysis, data, data-visualization
View All Similar Projects ➔

DataGear

DataGear是一款开源免费的数据可视化分析平台，使用Java语言开发，采用浏览器/服务器架构，支持SQL、CSV、Excel、HTTP接口、JSON等多种数据源， 主要功能包括数据管理、SQL工作台、数据导入/导出、数据集管理、图表管理、看板管理等。

DataGear 2.2.0 已发布，欢迎官网下载使用！

DataGear 大屏看板模板，持续更新中...

系统特点

  • 支持接入多种数据源
    支持接入任意提供JDBC驱动的数据库，包括MySQL、Oracle、PostgreSQL、SQL Server等关系数据库，以及Elasticsearch、ClickHouse、Hive等大数据引擎

  • 支持多种格式的数据集
    支持创建SQL、CSV、Excel、HTTP接口、JSON数据集，可将数据集定义为动态参数化数据集，可添加文本框、下拉框、日期框、时间框等类型的数据集参数，为构建动态可交互图表提供支持

  • 丰富强大的图表功能
    图表可聚合多个不同格式的数据集，内置折线图、柱状图、饼图、地图、雷达图、漏斗图等开箱即用的图表，并且支持自定义图表配置项，支持编写和上传自定义图表插件

  • 可自由编辑的数据可视化页面
    可视化页面采用原生的HTML网页作为模板，可自由编辑页面内容，支持导入任意HTML网页，为元素添加扩展属性即可绑定和配置图表，页面内置丰富的API，可构建图表联动、数据钻取、异步加载、交互表单等个性化的数据可视化页面

架构图

https://gitee.com/datagear/datagear/raw/master/screenshot/architecture.png

官网

http://www.datagear.tech

文档

http://www.datagear.tech/documentation

示例

https://my.oschina.net/u/4035217

源码

Gitee：https://gitee.com/datagear/datagear

Github：https://github.com/datageartech/datagear

交流

QQ群：916083747（已满）、1128360199（已满）、541252568

留言板：http://www.datagear.tech/messageboard

界面

数据管理

https://gitee.com/datagear/datagear/raw/master/screenshot/datamanage.png

SQL工作台

https://gitee.com/datagear/datagear/raw/master/screenshot/sqlpad.png

图表

https://gitee.com/datagear/datagear/raw/master/screenshot/chart.png

图表-数据集参数

https://gitee.com/datagear/datagear/raw/master/screenshot/chart-interaction.png

看板

https://gitee.com/datagear/datagear/raw/master/screenshot/template-002-dg.png

https://gitee.com/datagear/datagear/raw/master/screenshot/template-005-dg.png

https://gitee.com/datagear/datagear/raw/master/screenshot/template-006-dg.png

看板-图表联动

https://gitee.com/datagear/datagear/raw/master/screenshot/dashboard-map-chart-link.gif

看板-时序图表

https://gitee.com/datagear/datagear/raw/master/screenshot/dashboard-time-series-chart.gif

看板-钻取

https://gitee.com/datagear/datagear/raw/master/screenshot/dashboard-map-chart-hierarchy.gif

看板-表单

https://gitee.com/datagear/datagear/raw/master/screenshot/dashboard-form.gif

看板-联动异步加载图表

https://gitee.com/datagear/datagear/raw/master/screenshot/dashboard-link-load-chart.gif

模块介绍

  • datagear-analysis
    数据分析底层模块，定义数据集、图表、看板API

  • datagear-connection
    数据库连接支持模块，定义可从指定目录加载JDBC驱动、新建连接的API

  • datagear-dataexchange
    数据导入/导出底层模块，定义导入/导出指定数据源数据的API

  • datagear-management
    系统业务服务模块，定义数据源、数据分析等功能的服务层API

  • datagear-meta
    数据源元信息底层模块，定义解析指定数据源表结构的API

  • datagear-persistence
    数据源数据管理底层模块，定义读取、编辑、查询数据源表数据的API

  • datagear-util
    系统常用工具集模块

  • datagear-web
    系统web模块，定义web控制器、操作页面

依赖

Java 8+
Servlet 3.1+

编译

（执行单元测试编译，需要预先配置单元测试环境）
mvn clean package


（不执行单元测试编译，无需预先配置单元测试环境）
mvn clean package -DskipTests

编译完成后，将在datagear-web/target/datagear-[version]-packages/内生成程序包。

调试

1. 将datagear以maven工程导入至IDE工具；
2. 以调试模式运行datagear-web模块的：org.datagear.web.DataGearApplication
3. 打开浏览器，输入：http://localhost:50401

调试注意

在调试开发分支前（dev-*），建议先备份DataGear工作目录（[用户主目录]/.datagear）， 因为开发分支程序启动时会修改DataGear工作目录，可能会导致先前使用的正式版程序、以及后续发布的正式版程序无法正常启动。

系统启动时会根据当前版本号自动升级内置数据库（Derby数据库，位于[用户主目录]/.datagear/derby目录下），且成功后下次启动时不再自动执行，如果调试时遇到数据库异常，需要查看

datagear-management/src/main/resources/org/datagear/management/ddl/datagear.sql

文件，从中查找需要更新的SQL语句，手动执行。

然后，手动执行下面更新系统版本号的SQL语句：

UPDATE DATAGEAR_VERSION SET VERSION_VALUE='当前版本号'

例如，对于2.2.0版本，应执行：

UPDATE DATAGEAR_VERSION SET VERSION_VALUE='2.2.0'

系统自带了一个可用于为内置数据库执行SQL语句的简单工具类org.datagear.web.util.DerbySqlClient，可以在IDE中直接运行。注意：运行前需要先停止DataGear程序。

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].