data scientist

SlashDB and Data Analysis

SlashDB and Data Analysis

An increasingly popular trend in IT and business intelligence is data analysis. At SlashDB, we celebrate this trend as it contributes to the rising awareness of data’s amazing capabilities. Data analysis tools allow for the construction of predictive models that enable businesses to anticipate the needs of their customers – changing customer service into a proactive rather than reactive element.

Recent advances have made data analysis tools both more affordable and more precise in their predictions. To help predictive models reach their full potential, new data analysis tools are adding API technology to help interpret and organize complex un-structured and real-time data, as well as to support in-house development of data analysis apps.

Pairing Data Analysis and APIs

Pairing data analysis tools with APIs enables more efficient and in-depth data collection. APIs not only help extract more specific data than ever before, they also help expose real-time data for more precise and up-to-date predictive models – predicting trends and modifications ahead of the competition.

Combining data analysis tools with APIs helps businesses create more detailed and consumer-specific predictive
models and applications. These predictive models and apps help businesses to fully gauge the desires and needs of their customers – enabling proactive customer support and, in turn, higher customer satisfaction.

Data analysis tools paired with APIs are helping businesses achieve higher revenue than ever before by speeding up and simplifying data collection. This is a trend that businesses simply cannot afford to miss out on. The best way to get the most out of your data analysis tools, and keep up with the competition, is to adopt an API add-on to streamline data extraction.

Case in Point – SlashDB in Real Life

The theories behind adopting API technology in order to increase the effectiveness of data analysis tools are informative – and well-considered – but real life examples are sometimes even better at illustrating a point. For instance, SlashDB powers APIs for Aruba Tourism Authority. Our API helps them collect valuable data and gives them heightened insight into prospective travelers’ specific interests in the island’s activities. Aruba Tourism Authority uses an attractive web application and digital content on arubashortcuts.com as a platform for gathering important data from prospective visitors.

beachfront-dinner

SlashDB captures the data from their website and seamlessly integrates it into Google Spreadsheets where it is analyzed in real time. By pairing an API with data analysis tools, Aruba Tourism Authority is able to capture and analyze data that will help them attract more visitors and increase revenue. This is an excellent example of the effectiveness and efficiency that APIs bring to data extraction and analysis.

aruba-report

SlashDB: Your Data Analysis API Solution

Adding an API add-on like SlashDB to your data analysis set-up can help you extract important data from predictive models, enabling you to meet and exceed customer expectations across multiple channels.aruba_island

At SlashDB, we focus on creating APIs with both high accessibility and heightened searchability. That’s why our API  add-on relies on a “what you see is what you get” set-up. This kind of set-up increases the speed and efficiency of data extraction. Our technology enables you to access your data through multiple platforms and creates a unique hyperlink for each individual piece of data.

Important Reasons Why You Should Pair SlashDB with Your Data Analysis Tools

  • SlashDB makes databases easily accessible from any analysis tool including (but not limited to): R Studio, Jupyter Notebook, Qlikview, Tableau, and Excel.
  • SlashDB makes working with databases as simple as working with plain files – with the added bonus that the data retains its integrity and authorizations while staying up-to-date.
  • SlashDB allows users to access and retrieve data with ease, relying on their intuition to extract the data they need rather than relying on complicated search queries.
  • With SlashDB, the content in your data analysis software or database becomes accessible through authorized web and mobile applications.SlashDB logo

SlashDB is committed to creating APIs that are highly accessible, searchable, and adaptable to other business and software tools. SlashDB’s API add-on can help streamline your business, allowing for increased profit margins and higher customer satisfaction. Contact us at SlashDB and we’ll work with you to find the best API add-on configuration for your business needs.

SlashDB at the API Strategy and Practice Conference

SlashDB at the API Strategy and Practice Conference

SlashDB is proud to announce that founder and CEO, Victor Olex, had the honor of giving a presentation at the most recent API Strategy and Practice Conference. Olex, acting as SlashDB’s representative, presented a talk on API advancements and development, sharing the stage with representatives from Walgreens, CapitalOne, Intuit, and Datafiniti.

Olex, a proponent and innovator of API technology, delivered an intelligent and compelling presentation on the ability of APIs to completely restructure the database ecosystem, as well as SlashDB’s commitment to simplifying database interactionsvo_slashdb through increased accessibility and searchability. Olex was lauded by fellow participants for his presentation, with one participant stating that SlashDB’s achievements in the field of API development were the highlight of the conference.

You can view Olex’s full presentation here or read below for a run-down of the highlights of his talk.

Statistically Speaking

Olex’s talk focused in part on offering concrete statistical data on the financial benefits of adopting APIs. For instance, in 2015 companies globally spent $2.3 T (that’s right, trillion) on IT systems. Of that$350 B (billion!) was spent on technicaldata_integration_pull_quote consulting and software integration services, while still another $140 B was spent on middleware. In total, half a trillion dollars is spent annually on data and data integration software. Saying that this is a lot of money to spend on data-related software is an understatement.

So where exactly is all of this money going? A quick breakdown reveals that most of it is used to cover expenses for integration ETL (Extract, Transform and Load) and Data Warehousing. Fortunately, the extreme financial upkeep for these types of databases can be greatly reduced by adopting an API database add-on like SlashDB’s, which favors accessibility and searchability over a single access point.

Multiply Investments with Amazonian-Sized Results

Olex reviewed the successes of APIs in businesses, notably using Amazon as an example of how investing in an API can lead to (hugely) increased returns. Amazonamazon_logo adopted an API in 2002 and, flashing forward to 2016, Amazon is now reaping the benefits of that decision. Since adopting an API, Amazon’s returns have increased by 4,000%. Needless to say, this is a huge, almost fantastical, return for investing in an API.

API Accessibility

In his presentation, Olex aptly pointed out that the underlying theme of the conference was accessibility, a theme that he took up with great enthusiasm and insight, offering excellent justifications for adopting APIs to meet accessibility needs in databases. Olex passionately advocated for a “what you see is what you get” interface which allows users to access and retrieve data with ease, relying on their intuition to guide them through the database rather than relying on complicated queries. Olex was quick to point out that SlashDB implements this exact setup, providing an API add-on that creates hyperlinks for each piece of data, which is literally like having your data at your fingertips.

SlashDB as a Solution

The intelligent and compelling presentations at the conference definitely highlight the fact that APIs have made serious inroads into the logos of businesses within theslashdb-logo-stacked-75 past year. Their popularity will only continue to grow and progress into mainstream business practices.

At SlashDB we’re committed to creating APIs with accessibility, searchability, and speed. Join us in our mission to rehabilitate the database ecosystem into a thing of streamlined beauty (and save yourself time and money in the process).

Full Session Video

Without further ado we present the entire video of the “APIs in Enterprise” session (you can jump straight to minute 32 when our part begins here). Enjoy.

SlashDB API for Data Science vs. Tools Like Oracle BI

SlashDB API for Data Science vs. Tools Like Oracle BI

We are often asked how SlashDB compares to Oracle BI or other business intelligence software.

Well, the main difference is that SlashDB provides unobstructed access to data for reading and writing, while those tools can only display data already nicely formatted for end users.

In addition to that SlashDB works both internally and does not require you to send data to a third party storage to make it available on the Internet. Oracle BI generally only works on the inside, and cloud-based SaaS products generally require you to upload your data to their storage in a format that fits their systems.

SlashDB is an instant web API shell over traditional databases. Unlike data warehouses and ETL, it does not copy the data form their source systems so the data is always up to date. Oracle BI requires setting up complicated ETL processes, which only run periodically and create copies of data.

Transparency of Research Matters

SlashDB is an excellent gateway to data for downstream analytics systems and self-service reporting in Excel, R, Python and more.

Fragment of the Research DocumentOur friends at PyStreet have recently conducted a survey on Python developers salary. The response data resides in an MS SQL Server database, but they wanted to publish the results online. They also wanted to demonstrate Python’s capability in data analysis.

Using SlashDB they made the database publicly accessible for reading via HTTP.

Then using IPhython Notebook and pandas data analysis library they produced a fully transparent research document, which was later shared online.

The notebook can not only be viewed, but also downloaded and modified.

Both the raw data and their transformations can be scrutinized and/or modified. For example, certain data points were removed from the study, but one can change those criteria or skip that step entirely. BI tools typically do not offer that degree of transparency.

SlashDB is industry independent. At last, your data scientists and business analysts will be empowered to leverage investments made in database systems. Use it with sales records, marketing campaign data, financial data or any other key performance indicator data to derive insights that matter.

SlashDB Airzooka Raffle at PyData

SlashDB Airzooka Raffle at PyData

Welcome back, here’s a short blast from the past, a video featuring SlashDB that we just discovered on the web.

In November last year we were proud sponsors of the PyData conference. In this lightning talk we are outlining SlashDB’s main benefits. After the presentation we are using random number generator in Google Spreadsheet to raffle-off an Airzooka gun.

http://vimeo.com/79936618

How Bloomberg Uses REST APIs

How Bloomberg Uses REST APIs

Bloomberg Industry Leaderboard Uses REST API for Financial Data Visualization; Imagine What You Could be Doing with Your Data Assets

If you have visited Bloomberg’s website lately you may have noticed a new tool called Bloomberg Industry Leaderboard, which is a part of their Visual Data site. The Leaderboard presents fundamental data about 600 leading global corporations in a visually attractive manner. Visualization techniques such as tree map, colored grid and rankings are all dynamically configurable, and results are sorted on the fly.

bloomberg-leaderboard

 

While the concept of presenting fundamental metrics in similar ways is not new, and there are many websites with similar data and visualization, the technical details behind the site are worth examining a bit closer.

Traditionally, data-driven  web pages respond to users input (clicks) by requesting from the web server a fully prepared page, coded in HTML for the browser to render. This typically results with reloading of the entire page upon each interaction or (more recently) with replacing fragments of existing HTML with new ones. In contrast, Bloomberg’s site uses REST/HTTP API to get raw data, which the browser then combines with a shell HTML page using Javascript and Cascading Style Sheets.

For us what is even more interesting is that Bloomberg seems to follow a very similar approach to that of SlashDB. Here’s an example of companies broken down industry and ranked by operating margin and estimated net income growth:

http://www.bloomberg.com/visual-data/industries/rank/margin:est-net (HTML representation)
http://www.bloomberg.com/visual-data/industries/db/rank/margin:est-net.json (underlying data)

By comparison, SlashDB links (to an unrelated data set) look as follows:

http://demo.slashdb.com/db/Chinook/Customer/Country/Brazil.html (HTML representation)
http://demo.slashdb.com/db/Chinook/Customer/Country/Brazil.json (underlying data)

Imagine what you could do by layering SlashDB on top of your data. Use it internally for data federation, database search and self-service reporting, or deliver data to the web and mobile apps, or even offer your data assets for sale. Either way, the time to market is about an order of magnitude shorter than custom developed solutions, as our customers have attested. SlashDB is also more versatile as it allows for reading and writing of data and provides alternative data formats. It just as easily integrates with Excel, R, Matlab and enterprise systems as it does with the web.

As you may know, the idea for SlashDB was conceived out of the issues with access to market data in large investment banks. Had Bloomberg used SlashDB, they could have saved a ton of time and money.

Try /db Risk Free

If you would like to learn more about SlashDB or to discuss REST APIs in finance or in general, please contact us. You can also register here to try our product risk free.

Data Scientists Descend on New York to Attend PyData 2013

Data Scientists Descend on New York to Attend PyData 2013

PyData Conference beings Nov. 8th and runs through Sunday, Nov 10th at JPMorgan’s offices downtown Manhattan. Hundreds of data scientists, engineers and analysts are expected to attend this unique and highly technical event.

SlashDB a Proud Sponsor

Banner: SlashDB instantly adds a web API to your databaseData science and quantitative analysis are huge use cases for SlashDB, and we are very pleased to be able to provide sponsorship for PyData.

Instead of wrangling with access to data, scientists turn to SlashDB to access unobstructed data from disparate sources under standard data formats for reading and writing via REST/HTTP API, directly from their tool of choice. This translates to time savings and avoidance of repetitive coding, especially when the same data must be used in several tools and applications.

Special Offer, Do Not Miss Out – Extended FREE Trial

For those who stop by our booth at PyData and/or fully fill out this web form we are offering an extended 3 month FREE trial of SlashDB!

Why Python?

Python just “fits your brain”. Many data scientists and quantitative analysts select Python as the programming language of choice, and we fully understand why. This multi-paradigm language helps avoid code cruft, runs fast and comes with rich data structures and libraries.

Not only is SlashDB straight-forward to use from Python but it is also the language used for customizing its behavior. By default, SlashDB automatically generates a RESTful web service out of existing databases, which results in a web API, which closely follows database structures. This is often desired because it promotes data transparency and provides building blocks for business solutions but in some cases databases can have less then perfect design. Using Python, that auto-generated data model can be overridden to hide those imperfections or add functionality.

Register for PyData

There may be still tickets available, but they have been selling fast so don’t delay and head over to the registration page.

(UPDATE) Sorry the conference is completely SOLD OUT. Even if you cannot make it to the conference, just completely fill out this web form and we will honor your registration and reward you with a 3 month free license.

SlashDB Adds Support for 3Scale API Management Service

SlashDB Adds Support for 3Scale API Management Service

powered-by-3scale-croppedWe are pleased to officially announce that we have added support for 3Scale API Management service in SlashDB.

Powerful Technology Combination

With /db‘s capability to generate API on the Fly™ directly from databases this level integration creates the most powerful combo to quickly and reliably launch, manage and safeguard REST/HTTP APIs. API metering, billing and developer portal management are only some of the features that 3Scale’s platform provides. But an API management service cannot build an API for you – that is what SlashDB does.

In the past this kind of integration required manual modifications to proxy configuration files, which although powerful can be cumbersome to do. Now, all that is required is to use 3Scale web-based GUI for proxy configuration to generate required files, which then can be simply uploaded to SlashDB. Of course, manual tweaking of the files is still possible so SlashDB clients get the best of both worlds so to speak.

API Keys

Related to 3Scale integration, added is the support for authentication with API keys. SlashDB has always allowed for stateless authentication using HTTP Basic Authentication but many developers are accustomed to the convention of an API key. SlashDB now supports both a singular API Key (user key) or a pair of Application ID and Application Key. The keys can be associated with SlashDB accounts (users), which in turn govern access to data resources and system features. For making API calls authentication keys can be provided as HTTP headers or in a URL query string.

Immediate Benefits

There is no faster way to an API than from one’s database and SlashDB excels at making the connection, thanks to these key features and benefits:

  • API on the Fly™ with multiple resource representations to suit every purpose
  • Data Discovery and search readiness to visually orient developer or analyst in data resources available
  • SQL Pass-thru to leverage the full power of database querying capabilities in API
  • Authentication, resource authorization and encryption to control who gets to see what
  • Leverages investments already made in databases for seamless integration with HTML5, mobile, NoSQL and Big Data analytics

Enterprises, web businesses, data vendors, data scientists, quantitative analysts, DBAs, mobile enterprise applications developers and other user groups all derive unique benefits from SlashDB.

How can /db upgrade your data infrastructure? Learn about solutions and try it risk-free on your databases.

SlashDB ver. 0.7 Released, Improved UX and Admin Functions

SlashDB version 0.7 has just come out. This time, improvements focus on three things: user experience,  robust system administrator functionality and enhanced authorization mechanisms. Try the new SlashDB and you will appreciate the benefits of data accessibility from anywhere.

Here’s what’s new in 0.7:

For data scientists, business analysts

SlashDB has this dual personality. It is the API developer’s best tool to incorporate databases into his/her web or mobile apps but the equally important aspect of the system addresses the needs of data scientists, business analysts and rapid application developers.  Using SlashDB they get straightforward access to relevant data in its unobstructed form. Thanks to our latest GUI enhancements the web interface is now even more user friendly. New, responsive design allows for comfortable browsing through data on mobile devices while automatically generated, drill-down, filtering and sorting links help casual user discover the data and system’s functionality on the fly. As before you can use your favorite data analysis tools such as Excel, Matlab, SAS, R etc. to work with live data referenced by /db URLs.

For system administrators

Previously most settings would require editing configuration files on the server. We still have that option but since version 0.7 nearly all settings can be made in the web GUI or via a REST API. New authorization schemes now allow even greater flexibility in creating user segments with distinct permissions to data and system functions. Special users “admin” and “public” have been added. The former has full permissions to all system functions. The latter can be configured to offer limited access without requiring a login.

For CTO/CIO and software architects

Using SlashDB as a mobile enterprise application backend or to build an API is a sensible choice. Not only can you instantly leverage prior investments in databases but also remain in full control of your solution. That is because unlike SaaS offerings SlashDB can work in your data center or in your private cloud. See also this blog post.

User Experience in ver. 0.7

User Experience in ver. 0.7