BI Studio 10.4 and Database Master 10.4 Released

/in /by

Nucleon BI Studio 10.4 and Database Master 10.4 Released

We’re happy to announce the release of Database Master 10.4, Nucleon BI Studio 10.4 and BI Web 4.0. The new release comes with powerful features and important improvements for all products.

New Innovation

Nucleon BI allows to add R, C#, F# and Java script files as a data source. This feature  opens a new door to  programming and scripting languages  like C#, Python, F#, Java etc. Nucleon BI render the script before executing it and get the results after script run. The results can be used in different visualizations , reporting, charting, dashboards, views and more.

New : C# Scripts as Data Source

Nucleon BI supports now C# scripts as data source.  You can use the c# script for the visualization modules (Reports, Charts, Web) for data source.

New: R Script Results as Data Source

Nucleon BI supports now R scripts as data source.  It stores the R scipt plot and table results in a data set for further visualization.

Improvements:

  • New Viewer for Power Views
  • New Viewer for Cross Tables
  • New Dashboard Components (R, CrossTable and Url Link)
  • More Descriptive Statistics
  • Better Dashboard View
  • Better Data Binding for R Script
  • Fixed: Initializing Charting Titles
  • Fixed:  Initializing Charting Legens
  • Update to Google.Apis 1.36.1.0
  • Update to MySQL Driver 8.0.13.0
  • Update to MongoDB Driver 2.7.2.0
  • Update to Oracle Driver 4.122.18.3
  • Update to NuoDB Driver 2.3.0.11
  • Update to Amazon Web Services SDK Driver 3.3.0.0
  • Update to Google.Apis.Analytics.v3 1.36.1.1268

Nucleon Atomic 4 Released

/in , /by

Nucleon Atomic 4  has been released

Nucleon Atomic 4 releases includes some bug fixed and performance improvements.  Nucleon Atomic has two Setup Files:

  • Nucleon Atomic  Master: Organize map&reduce tasks, data source connection and data query
  • Nucleon Atomic Worker: Computes the given code tasks.

Nucleon Atomic is a distributed computing Framework which supports the map&reduce programming model for data computing and data processing using WCF streaming. It is build on the top of .Net Framework with WCF and pure C# Language.

For more information:

http://nucleonsoftware.com/products/nucleon-atomic

 

Nucleon BI Studio 10.1 and BI Web 4.0 Released

/in /by

Nucleon BI Studio 10.1 and BI Web 4.0 Released

We are proud to announce that Nucleon BI products are released with new features. Nucleon BI Studio 10.1 releaed with Web Module and Nucleon BI Web 4.0 released also with the support of Web Elements and JavaScript Libraries. You can design a Web page inside BI Studio and bind data to it.

New : Web Module

Web module allows to visualize Web elements   (Html Table, List, JavaScript etc.) using data binding.

Data Binding with Web Elements

The data binding technology allows to bind the data to the Web elements (Html, List, Image) and any JavaScript libraries. It gives you to full power of Web development and Web data visualization  to you.

New: Web Dashboard

Web Dashboards are  Html and JavaSCript based Web pages with data binding.

Planned Features

WE are developing new Modules and Features for Data editing, Apache Spark integration, Jobs and Tasks Scheduling and Business Workflows.

 

 

Visual Representation of SQL Joins

/in , /by

Introduction

This is just a simple article visually explaining SQL JOINs.

Background

I’m a pretty visual person. Things seem to make more sense as a picture. I looked all over the Internet for a good graphical representation of SQL JOINs, but I couldn’t find any to my liking. Some had good diagrams but lacked completeness (they didn’t have all the possible JOINs), and some were just plain terrible. So, I decided to create my own and write an article about it.

 

Read More:  https://www.codeproject.com/Articles/485777/SQL-Joins

Beginners' guide to using MongoDB 4.0.2 and C#

/in , /by

Beginners’ guide to using MongoDB 4.0.2 and C#

Introduction

This article attempts to highlight the latest developments in both the Mongo open-source document database and the open-source official C# driver. This piece has now been updated to reflect version 4.0.2 of the database and version 2.7 of the C# driver.

Overview of Document Databases.

Document databases store information relating to a record in a contiguous blob of data known as a document . A document’s structure usually follows the JSON format and consists of a series of key-value pairs. Unlike the schema of relational databases, the document’s structure does not reference empty fields. This flexible arrangement allows fields to be added and removed with ease. What’s more, there is no need to rummage about in various tables when trying to assemble the data; it’s all there in one solid block. The downside of all this is that Document databases tend to be bulky. But, now that disk drives are in the bargain basement, the trade off between speed of access and storage costs has shifted in favour of speed and that has given rise to the increased use of document databases. The Large Hadron Collider at Cern uses a document database but that’s not why it keeps breaking down.

Read More: https://www.codeproject.com/Articles/524602/Beginners-guide-to-using-MongoDB-4-0-2-and-the-off

BI Studio 10 and Database Master 10 Released

/in /by

Brand New Product Releases

We’re happy to announce the release of Database Master 10 and Nucleon BI Studio 10. We add new database connections, update the GUI with Microsoft WPF Technology and did more updates and changes. Nucleon BI Web 4 is coming soon with modern look and feel and dashboard more features.

Our brand new product “Nucleon Linqer” for linq queries will be release soon. Nucleon Linqer supports linq to Dll’s (Objects), linq to Xml, linq to Json and other custom linq providers. Writing linq queries to the custom objects or data sources will be easyyyyyyyy!

Nucleon Map&Reduce will be “Nucleon Atomic” again and will be released on July. Nucleon Atomic is an Client/Server (Master and Nodes) based Map&Reduce application. Nucleon Atomic supports c# based Map&Reduce scripts. It is under test now!

Database Master 10

Nucleon Database Master 10 is coming with new GUI and features and improvements. It supports more than 40 database systems and data sources.

Nucleon Database Manager is a powerful and modern database query, development and management tool for MongoDB, NuoDB, Oracle, DB2, Informix, Postgre, MySQL, Netezza, Ingres, SQL Server, SQL Azure, SQLCE, SQL Azure, Apache Hive, FireBird, SQLite, dBase, Apache Cassandra, Redis, Esri GeoDB database systems. It supports OData, ODBC, OleDb, WebDbBridge, WebDbProxy, Google Analytics, Google BiqQuery, WordPress CMS and other data source connections.

Important Changes:

  • MongoDB Driver Update: We (must to) also updated the MongoDB Driver.  Old connections are not more valid for new driver and you need to add new connections.

What is new with Database Master 10:

  • New: Main GUI with Microsoft WPF Technology
  • New: Unique Query format (.query) and custom attributes
  • Add: Apache Cassandra Support
  • Add: Redis Db Support
  • Add: Google BIQQuery Support and Google Analytics fixes
  • Update: MongoDB Driver
  • New: More MongoDB Query commands support
  • and more improvements and bug fixes.

Nucleon BI Studio 10

Nucleon BI Studio 10 newly designed and implemented with Microsoft WPF technology for better scaling high resolution screens. Nucleon BI Studio 10 provides rich data analytics and visualization features for your data. It support of more than 40 data source connections and database systems. It provides Reporting, Charting, Dashboarding, Statistics, PowerViews, PivotTable View, Data Search, Datasource Explorer, Data Export/Import, R-Statistics and other important business intelligence features.

Important Changes!

  • Query file as Datasource: BI Studio 10 projects require query file results as data source.  This feature is not supported with the old versions. You need to update your report and chart definition data sources.
  • MongoDB Driver Update: We (must to) also updated the MongoDB Driver.  Old connections are not more valid for new driver and you need to add new connections.

What is new with BI Studio 10

  • New: Main GUI with Microsoft WPF Technology
  • New: Dashbord Components with Microsoft WPF Technology
  • New: Unique Query file format (.query) instead of .sql and .json
  • Add: Apache Cassandra, Redis and Google Biq Query support
  • Update: MongoDB Driver
  • New: Support for MongoDB Query Commands
  • Update: Reporting Components
  • Update: Chart Designer and Viewer
  • Update: PowerView and PivotTable Designer and Viewer
  • Update: Dashboard Designer
  • Some Improvements and bug fixes.

What is Next>>>

  • BigData: Apache Spark Support
  • Business Workflows
  • Web based Maps
  • JavaScript based Charting and Data Visualization
  • Live Charts and Dashboards

Nucleon BI Web 4 (Coming Soon)

Nucleon BI Web 4 is coming soon and support new BI Studio 10 projects. It has now new modern design&look, can visualize the dashboard components (Reports, Charts, Maps, Web contents, Images, Query Results) for the web and mobile.

Nucleon BI Web 4 supports dashboard visualization, project management (upload, edit, and delete projects), user management and Rest API for dashboards, supports export feature for dashboard components.