Subscribe to DSC Newsletter

All Blog Posts Tagged 'SQL' (10)

Free book on SQL

As you would know, SQL is essential for many tasks involving working with large quantities of data.

Members of Analytic Bridge might like to download my guide to SQL titled 'SQL Essentials' available for free download from my personal website www.markmcilroy.com

Also on my personal website is a practice SQL environment where you can query a sample database and try out the examples from the book.

This book and my…

Continue

Added by Mark McIlroy on November 4, 2016 at 6:00pm — No Comments

Executable English for Self-Service BI

Here's a new tool that can help to bridge the business-IT divide -- Executable English.



It's a platform on the Web that can support people socially writing their own apps, by typing  Executable English knowledge into browsers.



For example, here's the "source code" of an app written in executable English:



    www.reengineeringllc.com/demo_agents/GrowthAndDebt1.agent



Anyone on the…

Continue

Added by Adrian Walker on November 6, 2014 at 1:48pm — No Comments

Code Examples of cross database relational computing in Java

Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these operations. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat…

Continue

Added by Jessica May on September 9, 2014 at 1:03am — No Comments

Some Cases illustrating drawbacks of SQL in data computing and analytics

The computing power of SQL for mass structured data is complete, that is to say, it is impossible to find anything that SQL cannot compute. But its support layer is too low, which can lead to over-elaborate operation in practical application.…

Continue

Added by Jessica May on July 27, 2014 at 9:30pm — No Comments

What difficulties SQL have in OLAP

1. What OLAP We Need Indeed?

Category: Model

OLAP is an important constituent part of BI(business intelligence).

Understood literally, OLAP is online analytical processing, that is, users conduct analytical operation on real-time business data.

But, currently the concept of OLAP is seriously narrowed, and only it refers to operations such as conducting drilling,…

Continue

Added by Jessica May on May 27, 2014 at 8:00pm — No Comments

Help Needed! Getting a user-friendly tool (or system) to prepare large data sets for analysis...

I have a 5-20K USD budget to get a tool (w/wo dedicated hardware), including training for 2 people, to prepare (clean, merge, etc...) and summarize (samples, grouping/aggregations, etc) large data sets (over 5GBs, over 4 million rows).

I need an efficient solution (fast data processing and fast to learn), and definitely easy to use. I would have done it with excel if excel could handle such large data files.

After preparing and summarizing the data, I'll use excel pivot tables…

Continue

Added by Ahmed on October 22, 2013 at 2:16pm — 13 Comments

DropQuery - A project from AngelHack Sydney, love to hear some feedback.

I attendedAngelHack Sydney recently during the month of May.

AngelHack is a hackathon where developers and entrepreneurs come together to prototype a viable business idea within 24 hours.

The project that I worked on was called "DropQuery". The basic concept is this.

* You have some data files - CSV, XLS, XML

* You want to quickly query it.

I talked to a few people at the…

Continue

Added by Eric Bae on June 6, 2013 at 6:28pm — No Comments

Row vs Columnar vs NoSQL Databases

 

See: http://bit.ly/RWBoCk…

Continue

Added by Michael Walker on October 24, 2012 at 5:43pm — No Comments

Improve the Computation and Analysis Ability in Java

Java is the most widely used programming language with an outstanding architecture. It is the top preferred language to develop the enterprise application. However, Java is not fit for the mass data computation. If encountering the computation that is too complex to be represented in a single SQL statement or it is not allowed to add stored procedures to database, then drawbacks of Java would be highlighted.

Hereby is a case on how to deal with above questions with…

Continue

Added by Daisy Ding on July 24, 2012 at 1:23am — No Comments

in-database data mining

I have been building data mining solutions within relational databases. Almost every process is done within the database environment. We enjoy the functions provided by databases: security, scalability, analytic functions, manageability, easy model deployment, SQL, etc. Since data mining is done on the server side, the crash of my laptop hard drive has minimum impact on my work (it happened twice in the last two years).

Added by Jiang (Jay) Zhou on August 23, 2009 at 10:49am — 3 Comments

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service