Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

Database

Oracle Announces New, Highly Optimized x86 Servers

Oracle Database News - Wed, 06/11/2014 - 13:00
First and Only x86 Servers to Offer Elastic Computing are Ideal Platforms for Oracle Database, Large-Memory Applications and Virtualization /us/corporate/press/2216429 en
Categories: Database, Vendor

Oracle Launches In-Memory Option for 12C Database

Database Journal News - Wed, 06/11/2014 - 01:02

The 12C In-Memory Option is aimed at enabling ISV applications to accelerate performance by orders of magnitude for several use cases.

Categories: Database

Oracle Database In-Memory Powers the Real-Time Enterprise

Oracle Database News - Tue, 06/10/2014 - 19:59
Larry Ellison Unveils Breakthrough Technology, which Turns the Promise of Real-Time Business into a Reality /us/corporate/pressrelease/database-in-memory-061014 en
Categories: Database, Vendor

Oracle Database In-Memory Powers the Real-Time Enterprise

Oracle Database News - Tue, 06/10/2014 - 18:15
Oracle Database In-Memory Powers the Real-Time Enterprise -- Larry Ellison Unveils Breakthrough Technology, which Turns the Promise of Real-Time into a Reality /us/corporate/press/2215795 en
Categories: Database, Vendor

Oracle Database In-Memory Lets ISVs Easily Deliver Applications for the Real-Time Enterprise

Oracle Database News - Tue, 06/10/2014 - 18:12
Oracle Database In-Memory Offers Partner Applications Real-Time Analytics and Increased Transactional Performance; Oracle Database Ready Certification Includes Oracle Database In-Memory /us/corporate/press/2215799 en
Categories: Database, Vendor

Introduction to SQL Server in Microsoft Azure

Database Journal News - Mon, 06/09/2014 - 08:01

The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features available in full-fledged editions of the SQL Server. Fortunately, these limitations can be eliminated by taking advantage of the Microsoft Azure Infrastructure as a Service (IaaS) capabilities and installing a SQL Server instance in an Azure-hosted virtual machine (VM).

Categories: Database

Announcing the preview of Apache HBase clusters inside Microsoft Azure HDInsight

On June 3, Microsoft announced an update to HDInsight to support Hadoop 2.4 for 100x faster queries.  Today, we are announcing the preview of Apache HBase clusters inside Microsoft Azure HDInsight.

HBase is a NoSQL (“not only Structured Query Language”) database component of the Apache Hadoop ecosystem. While relational database management systems (RDBMS) typically use rigid tabular schemas, NoSQL databases uses fluid techniques such as key-value, column, graph, or document. They are usually designed for elasticity over large datasets and are less rigorous when it comes to schema.

HBase is a columnar NoSQL database that was built to run on top of the Hadoop Distributed File System (HDFS). As a low-latency database, it can do OLTP capabilities like updates, inserts, and deletes of data in Hadoop. HBase will have a set of tables that contain rows and column families that you must predefine. However, it provides flexibility in that new columns can be added to the column families at any time.  This makes HBase have flexibility in the schema to adapt to changing requirements quickly.

This preview announcement will enable customers to run HBase as a managed cluster in the cloud (as an integrated feature of Azure HDInsight). The HBase clusters are configured to store data directly in Azure Blob storage. This will enable use cases like:

  • Building interactive websites that work with large datasets stored in Azure Blobs
  • Building services that store sensor and telemetry data from millions of end points in Azure Blobs (which can then be analyzed using HDInsight (Hadoop)

To learn more about HBase, we invite you to read the following resources:

To learn more about Azure HDInsight and Hadoop, we invite you to the following resources:

Categories: Database

How Safe is Cloud Storage?

Database Journal News - Thu, 06/05/2014 - 15:24

As more and more companies look to the cloud for their data storage needs, the same questions are being asked over and over again: if a security breech were to occur, who would be responsible and how much of a guarantee could the provider give us that our data would be safe from prying eyes.

Categories: Database

DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security

IBM - DB2 and Informix Articles - Thu, 06/05/2014 - 05:00
This tutorial introduces authentication, authorization, privileges, and roles as they relate to IBM DB2 10.1. It also introduces granular access control and trusted contexts. This is the second in a series of six tutorials designed to help you prepare for the DB2 10.1 Fundamentals certification exam (610). It is assumed that you already have basic knowledge of database concepts and operating system security.
Categories: Database

Admin4 V2.1.4 featuring PostgreSQL module released

PostgreSQL News - Thu, 06/05/2014 - 01:00

The new Admin4 release is the first to contain a greatly enhanced PostgreSQL module. It includes:

  • Object browser with Favourites
  • Query tool with Snippets, sql text fragments stored for frequent usage
  • Data tool for table data modification, with Presets to remember frequently used data retrieval filters.

Favourites, Snippets and Presets are stored centrally in the database, making them available for roaming usage. Your day-to-day code snippets, standard filters and frequently used objects are right there no matter which workstation you're using to maintain the database.

Download it here from sourceforge, it's free (Apache2 licensed). Contributors/testers for this fresh project are welcome!

Categories: Database, Open Source

Postgres Open 2014 Early Bird Tickets and Tutorials on Sale!

PostgreSQL News - Thu, 06/05/2014 - 01:00

The 2014 Postgres Open Program Committee is pleased to announce the opening of Early Bird Tickets and Tutorial Registration sales.

Early Bird Tickets: Book early through July 6, 2014 to save $200 on your registration! Postgres Open has received such strong support from our community sponsors that we’re retaining our ticket prices from 2013 - no increase this year.

Conference Tutorials: We’ve brought in some new presenters and topics this year for our tutorial sessions held Wednesday, September 17th.

  • Adv. SQL + Functions - Joe Conway, Stephen Frost
  • Intro to PostGIS Core and Popular Add-ons - Regina Obe, Leo Hsu (a 2 part/full day session)
  • Writing and Using Extensions - Dimitri Fontaine

In addition, Heroku is offering a free platform tutorial covering dynos and their environment, buildpacks, deployment, releases, HTTP routing, add-ons, and of course Postgres.

Early Bird Tickets and All Tutorials can be purchased here: https://postgresopen.org/2014/tickets/

The CfP has been extended through Sunday June 8th: We’ve received some impressive submissions thus far, however a few of you have asked for some extra time, as such we’re giving you until this Sunday June 8. https://postgresopen.org/2014/callforpapers/

We look forward updating you in the coming weeks and with more speaker info and the presentations schedule for Postgres Open 2014!

Categories: Database, Open Source

Microsoft releases HDInsight for Hadoop 2.4 And Gains 100x Performance Increase

Yesterday, at the Hadoop Summit, Microsoft announced that Azure HDInsight now supports Hadoop 2.4.  This is the next release of our 100 percent Apache Hadoop-based distribution for Microsoft Azure. In conjunction with Hortonworks recent release of HDP 2.1 as a Hadoop on Windows offering and Analytics Platform System as a Hadoop and data warehousing appliance, this release of Azure continues our strategy of making Hadoop accessible to everybody with Hadoop in the cloud.

This release of HDInsight is important because it has the latest benefits of Apache Hadoop 2.4 which provides order magnitude (up to 100x) performance improvements to query response times and continues to leverage the benefits of YARN (upgrading to the future “Data Operating System For Hadoop 2.0”). Finally, we are also providing an easy-to-use web interface that gives users of HDInsight a friendly experience. You can create queries with a graphical user interface to issue Hive queries.

The 100x improvements to query response times is due to the Stinger initiative where Microsoft in collaboration with Hortonworks and the open source software community (OSS) have brought some of the technological breakthroughs of SQL Server to Hadoop. We are excited to see Microsoft-led contributions bring generational improvements to Hadoop.

Since the Azure HDInsight’s release on October, 2013, we have seen tremendous momentum of customers deploying Hadoop in the cloud. Beth Israel Deaconess Medical Center, a teaching hospital for Harvard Medical School is using HDInsight to process large amounts of unstructured log data and to maintain their stringent requirements of data retention (that can be as long as 30 years). Virginia Polytechnic Institute is using the power of HDInsight to analyze massive amounts of DNA sequencing data.  More of these examples can be read on CIO magazine  who recently highlighted several HDInsight customer stories.

With Hortonworks HDP 2.1 For Windows, Microsoft Analytics Platform System, Microsoft Azure, Microsoft customers have an unprecedented number of options to deploy Hadoop on-premise, in the cloud or hybrid.  We invite you to learn more through the following resources:

Categories: Database

Microsoft updates its Hadoop cloud solution

Hadoop Summit kicked of today in San Jose, and T. K. Rengarajan, Microsoft Corporate Vice President of Data Platform, delivered a keynote presentation where he shared Microsoft’s approach to big data and the work we are doing to make Hadoop accessible in the cloud. At the event, we also announced that Azure HDInsight, our Hadoop-based service in the cloud, now supports Hadoop 2.4.

Investing in Hadoop
Hadoop is a cornerstone to our approach of making data work for everyone. As part of this bet we have fully embraced the Hadoop ecosystem and have prioritized contributing back to the community and Apache Hadoop-related projects e.g. Tez, Stinger and Hive. All told, we’ve contributed 30,000 lines of code and put in 10,000+ engineering hours to support these projects, including the porting of Hadoop to Windows. We’ve done this in partnership with Hortonworks, a relationship that ensures our Hadoop solutions are based on compatible implementations of Hadoop. One of the results of that partnership is the engineering work that has led to the Hortonworks Data Platform for Windows and Azure HDInsight.

Azure HDInsight
The massive scale, power, elasticity and low cost of storage, makes the cloud the best place to deploy Hadoop. That’s one of the reasons we have invested heavily in our cloud-based Hadoop solution, Azure HDInsight, which combines the best of open source with the flexibility of cloud deployment. It’s also integrated with our business intelligence tools, enabling easy access and transformation of data from HDInsight to Excel and Power BI for Office 365.

Today we are providing an update to Azure HDInsight with support for Hadoop 2.4, the latest version of Hadoop. This update includes interactive querying with Hive using advancements based on SQL Server technology, which we are also contributing back to the Hadoop ecosystem through project Stinger. With this update to HDInsight, customers can use the speed and scale of the cloud to gain a 100x response time improvement.

HDInsight is just one part of our comprehensive data platform, which includes the building blocks customers need to process data anywhere it lives and in the format where it is born, whether they use Microsoft Intelligent Systems Service to capture machine-generated data within the Internet of Things, SQL Server or Azure SQL Database to store and retrieve data, Azure HDInsight to deploy and provision Hadoop clusters in the cloud, or Excel and Power BI for Office 365 to analyze and visualize data.

Go read how to get started and then try HDInsight today – it is the fastest and easiest way to get your Hadoop clusters up and running in the cloud. 

Categories: Database

PolyBase in APS - Yet another SQL over Hadoop solution?

This blog post will highlight PolyBase’s truly unique approach focusing on:

  • Query capabilities across various heterogeneous data sources – on-premises and cloud (Microsoft Azure) bringing Microsoft data services together forming one complete data platform solution
  • Total freedom for users with no lockdown, agnostic to the actual Hadoop distribution and/or underlying operating system
  • Faster insights from all your data in a simple and performing fashion allowing users to leverage their existing tools and SQL scripts
1.    Bringing the relational world together with Hadoop & Cloud (Azure)

In the very recent past, various SQL over Hadoop/HDFS solutions have been developed, such as Impala, HAWQ, Stinger, SQL-H, Hadapt to name just a few. While there are clear technical differences between the various solutions, at a high level, they are similar in offering a SQL-like front end over data stored in HDFS.

So, is PolyBase yet another similar solution competing with these approaches? The answer is yes and no. On first glance, PolyBase is a T-SQL front end that allows customers to query data stored in HDFS. However, with the recently announced Analytics Platform System (APS), we have updated PolyBase with new syntax to highlight our extensible approach. With PolyBase, we bring various Microsoft data management services together and allow appliance users to leverage a variety of Azure services. This enables a new class of hybrid scenarios and reflects the evolution of PolyBase to a true multi-data source query engine. It allows users to query their big data – regardless of whether it is stored in an on-premises Hadoop/HDFS cluster, Azure storage, Parallel Data Warehouse, and other relational DBMS systems (offered in a future PolyBase release).

Complete Data Platform with PolyBase as key integrative component

2.    Freedom of Choice

Openness

One important key differentiator of PolyBase compared to all of the existing competitive approaches is ‘openness’. We do not force users to decide on a single solution, like some Hadoop providers are pursuing. With PolyBase, you have the freedom to use an HDInsight region as a part of your APS appliance, to query an external Hadoop cluster connected to APS, or to leverage Azure services from your APS appliance (such as HDInsight on Azure).

To achieve this openness, PolyBase offers these three building blocks.

Building blocks for PolyBase

The syntax for using PolyBase is simple and follows familiar T-SQL language constructs.

T-SQL for creating external data sources (Azure, external Hadoop cluster, HDI region)

  • CREATE EXTERNAL DATA SOURCE Azure_DS WITH (TYPE=Hadoop, LOCATION= 'wasbs://<youraccount>.blob.core.windows.net');
  • CREATE EXTERNAL DATA SOURCE External_HDP_DS WITH (TYPE=Hadoop, LOCATION='hdfs://…’, JOB_TRACKER_LOCATION='…');
  • CREATE EXTERNAL DATA SOURCE HDI_DS WITH (TYPE=Hadoop, LOCATION = 'hdfs://…’, JOB_TRACKER_LOCATION = '…’);

T-SQL for creating external file formats (delimited text files and Hive RCFiles)

  • CREATE EXTERNAL FILE FORMAT DelimText1 WITH ( FORMAT_TYPE = DELIMITEDTEXT, FORMAT_OPTIONS (FIELD_TERMINATOR =','));
  • CREATE EXTERNAL FILE FORMAT DelimText2 (FORMAT_TYPE = DELIMITEDTEXT, FORMAT_OPTIONS (FIELD_TERMINATOR ='|', USE_TYPE_DEFAULT = TRUE));
  • CREATE EXTERNAL FILE FORMAT HiveRC WITH (FORMAT_TYPE = RCFILE, SERDE_METHOD = 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe')

T-SQL for creating external tables (for Azure, external Hadoop cluster, HDI region)

  • CREATE EXTERNAL TABLE [dbo].[Old_SensorData_Azure] (…)
    WITH (LOCATION='//Sensor_Data/May2009/sensordata.tbl', DATA_SOURCE   Azure_DS, FILE_FORMAT = DelimText2, REJECT_TYPE = VALUE, REJECT_VALUE = 100)
  • CREATE EXTERNAL TABLE [dbo].[SensorData_ExternalHDP] (…)
    WITH (LOCATION='//Sensor_Data/May2014/sensordata.tbl', DATA_SOURCE = External_HDP_DS, FILE_FORMAT = DelimText1, REJECT_TYPE = VALUE, REJECT_VALUE = 0)
  • CREATE EXTERNAL TABLE [dbo].[SensorData_HDI] (…)
    WITH (LOCATION='//Sensor_Data/Year2013', DATA_SOURCE = HDI_DS, FILE_FORMAT = HiveRC)

A user can now create statistics for each of the external tables shown above to improve the query performance. We extended SQL Server’s mature stats framework to work against external tables in the same way it works against regular tables. Statistics are crucial for the PolyBase query engine in order to generate optimal execution plans and to decide when pushing computation into the external data source is beneficial.

Performance

While other SQL over Hadoop solutions (e.g. Impala, Stinger, and HAWQ) have improved, it remains true that they still cannot match the query performance of a mature relational MPP system. With PolyBase, the user can import data in a very simple fashion into PDW (through a CTAS statement, see below), use the fast SQL Server column store technology along with the MPP architecture, or let the PDW/PolyBase query optimizer decide which parts of the query get executed in Hadoop and which parts in PDW. This optimized querying, called split-based query processing, allows parts of the query to be executed as Hadoop MR jobs that are generated on-the-fly completely transparent for the end user. Thereby, the PolyBase query optimizer takes into account parameters such as the spin-up time for MR jobs and the generated statistics to determine the optimal query plan.

In general, if it comes to performance the answer usually is ‘it depends on the actual use case/query’. With PolyBase, the user has total freedom and can leverage capabilities of PDW and/or Hadoop based on their actual needs and application requirements.

PolyBase in APS bridging the gap between the relational world, Hadoop (external or internal) and Azure

The T-SQL statement below will run across all data sources combining structured appliance data with un/semi-structured data in external Hadoop, internal HDInsight region, and Azure (e.g. historical data) –

T-SQL SELECT querying external Hadoop, HDInsight & PDW regions, and Azure

SELECT machine_name, machine.location 
FROM Machine_Information_PDW, Old_SensorData_Azure, SensorData_HDI, SensorData_ExternalHDP WHERE Machine_Information_PDW.MachineKey = Old_SensorData_Azure.MachineKey and Machine_Information_PDW.MachineKey = SensorData_HDI.MachineKey and Machine_Information_PDW.MachineKey = SensorData_ExternalHDP.MachineKey and SensorData_HDI.Temperature> 80 and Old_SensorData_Azure.Temperature > 80 and SensorData_ExternalHDP.Temperature > 80

This query example shows how simplicity and performance are combined at the same time. It shows three external tables referring to three different locations plus one regular (distributed) PDW table. While executing the query, the PolyBase/PDW query engine will decide, based on the statistics, whether or not to push computation to the external data source (i.e. Hadoop).

Rewriting & Migrating existing applications

Finally, you may have heard that Hadoop is ‘cheaper’ than more mature MPP DBMS systems. However, what you might not have heard about is the cost associated with rewriting existing applications and ensuring continued tool support. This goes beyond simple demos showing that tool ‘xyz’ works on top of Hadoop/HDFS.

PolyBase does not require you to download and install different drivers. The beauty of our approach is that external tables appear like regular tables in your tool of choice. The information about the external data sources and file formats is abstracted away. Many Hadoop-only solutions are not fully SQL-ANSI compliant and do not support various SQL constructs. With PolyBase, however, you don’t need to rewrite your apps because it uses T-SQL and preserves its semantics. This is specifically relevant when users are coming from a ‘non-Java/non-Hadoop world’. You can explore and visualize your data sets either by using the Microsoft BI solutions (initiated on-premises or through corresponding Azure services) or by using the visualization tool of your choice. PolyBase keeps the user experience the same. 

3.    Simplified ETL & Fast Insights

It’s already a painful reality that many enterprises store and maintain data in different systems that are optimized for different workloads and applications, respectively. Admins are spending much time moving, organizing, and keeping data in sync. This reality imposes another key challenge which we are address with PolyBase – in addition to querying data in external data sources, a user can achieve a simpler and more performant ETL (extraction, transformation, loading). Different than existing connector technologies, such as SQOOP, a PolyBase user can use T-SQL statements to either import data from external data sources (CTAS) or export data to external data sources (CETAS).

T-SQL CETAS statement to age out Hadoop & PDW data to Azure

CREATE EXTERNAL TABLE Old_Data_2008_Azure
WITH (LOCATION='//Sensor_Data/2008/sensordata.tbl', DATA_SOURCE=Azure_DS, FILE_FORMAT=DelimText2)
AS SELECT T1.* FROM Machine_Information_PDW T1 JOIN SensorData_ExternalHDP T2
ON (T1.MachineKey = T2.MachineKey) WHERE T2.YearMeasured = 2008 

Combines data from external Hadoop and PDW sources and stores the results in Azure

Under-the-covers, the PolyBase query engine is not only leveraging the parallelism of an MPP system, it also pushes computation to the external data source to reduce the data volume that needs to be moved. The entire procedure remains totally transparent for the user while ensuring a very fast import & export of data that greatly outperforms any connector technology offered today. With the CTAS statement, a user can import data into the relational PDW region where it stores the data as column store. This way, users can immediately leverage the column store technology in APS without any further action.

T-SQL CTAS statement for importing Hadoop data into PDW

CREATE TABLE Hot_Machines_2011 WITH (Distribution = hash(MachineKey),
CLUSTERED COLUMNSTORE INDEX)
AS SELECT * FROM SensorData_HDI where SensorData_HDI.YearMeasured = 2011 and SensorData_HDI.Temperature > 150

Combines PolyBase with column store – Imports data from Hadoop into PDW CCI tables

In summary, PolyBase is more than just another T-SQL front end over Hadoop. It has evolved into a key integrative component that allows users to query, in a simple fashion, data stored in heterogeneous data stores. There is no need to maintain separate import/export utilities. PolyBase ensures great performance by leveraging the computation power available in external data sources. Finally, the user has freedom in almost every dimension whether it’s about tuning the system and getting the best performance, choosing their tools of choice to derive valuable insights, and to leverage data assets stored both on-premises and within the Azure data platform.    

Watch how APS seamlessly integrates data of all sizes and types here

Learn more about APS here

Categories: Database

Traits of a DBA - Part One – The Technical Side

Database Journal News - Mon, 06/02/2014 - 08:01

What does it take to become a database administrator, or what kinds of traits should I be looking for when I am hiring a DBA. Those traits can be summarized it two categories: Technical and Personal. In this article, Greg Larsen discusses the technical traits a DBA should have.

Categories: Database

Actian and Attivio OEM Agreement Accelerates Big Data Business Value by Integrating Big Content

Actian Corporation (Ingres) Press Releases - Wed, 11/13/2013 - 14:03
Attivio AIE® integration into the Actian ParAccel Big Data Analytics Platform delivers unmatched performance and insights at fraction of big stack vendor cost

Newton, MA and Redwood City, CA – November 13, 2013 Attivio, creator of the award-winning Active Intelligence Engine (AIE®) and Actian, a leader in next-generation big data analytics, today announced a strategic OEM agreement. The agreement gives Actian customers the power to integrate and correlate human-generated, unstructured content sources with their structured data analytics to dramatically increase the return on their information assets.

Actian’s ParAccel Big Data Analytics Platform accelerates analytic performance and enables rapid deployment of highly targeted analytics for critical initiatives including customer segmentation, fraud prevention, risk avoidance and digital marketing optimization. The addition of Attivio AIE’s ability to include Big Content sources – social media, blog posts, email, research documents, SEC filings, insurance reports, legal depositions, open-ended survey responses and more – completes the Big Data analytics picture to greatly improve its impact and value.

With its patented query-time JOIN technology, Attivio AIE delivers unrivaled access to information from internal and external human-created information, so customers can integrate, correlate, access and analyze all of their assets, regardless of format. As a result, business users gain new, real-time business insights that help build revenue, cut costs, increase competitiveness and manage risk — insights that might otherwise go undiscovered.

“Big Content has become a vital piece in the Big Data puzzle,” said David Schubmehl, Research Director, IDC. “The majority of enterprise information created today is human-generated, but legacy systems have traditionally required processing structured data and unstructured content separately. The addition of Attivio AIE to Actian ParAccel provides an extremely cost-effective option that delivers impressive performance and value.”

“Through this alliance with Attivio, our customers now have access to all internal and external sources of unstructured content, solidifying our leadership position in the Big Data space,” said Fred Gallagher, VP Strategic Business for Actian. “With Attivio, we are giving customers more options and making this technology accessible to companies who recognize the value of innovation that is simply not available from legacy big stack vendors who typically impose expensive, long-term contracts, inflexible technology and long deployment times.” “Actian ParAccel delivers high-performance analytics on massive amounts of data,” said Sid Probstein, CTO at Attivio. “Being able to access and analyze outside sources from social media to any and all types of human-created content provides a complete and detailed view of customers and their requirements. It advances the entire field of BI and analytics.”

For more information about the Actian alliance and the Attivio Partner Network, please contact partners@attivio.com.

About Attivio

Attivio’s unified information access platform, the Active Intelligence Engine® (AIE®), redefines the business impact of our customers’ information assets, so they can quickly seize opportunities, solve critical challenges and fulfill their strategic vision.

Attivio integrates and correlates disparate silos of structured data and unstructured content in ways never before possible. Offering both intuitive search capabilities and the power of SQL, AIE seamlessly integrates with existing BI and big data tools to reveal insight that matters, through the access method that best suits each user’s technical skills and priorities. Please visit us at www.attivio.com.

Attivio and Active Intelligence Engine are trademarks of Attivio, Inc. All other names are trademarks of their respective companies.

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor

Actian to Present at the NASSCOM Product Conclave 2013

Actian Corporation (Ingres) Press Releases - Mon, 10/28/2013 - 19:00

Redwood City, Calif. – October 28, 2013 — – Steve Shine, CEO and President of Actian Corporation (“Actian”), a next-generation leader in big data analytics, will present during the NASSCOM® Product Conclave 2013 – The Community Meet-up of Doers Who Share! event, held Oct. 28-30 at Vivanta by Taj – Yeshwantpur in Bangalore, India.

During the Opportunities in Big Data session, which takes place Oct. 30 at 2:00-2:30 p.m. IST in the Aura room, Shine will discuss the various opportunities presented by big data, as well as new areas of innovation for startups trying to effect meaningful competitive differentiation through analytics on big data.

Actian has a strong presence in India, helping companies like Future Group, Mahindra Comviva and ManageEngine, a division of Zoho Corporation, harness the power of big data analytics to predict business trends, increase customer retention and gain a competitive advantage.

For more information on the NASSCOM Product Conclave 2013, please visit http://productconclave.nasscom.in/.

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor

Actian Teams with Hortonworks to Deliver Reference Architecture that Addresses Most Vexing Hadoop Challenges for Enterprises

Actian Corporation (Ingres) Press Releases - Fri, 10/25/2013 - 03:51

Sand Hill research pinpoints Hadoop adoption hurdles at each phase of maturity cycle

Redwood City, Calif. – October 24, 2013 Actian Corporation (“Actian”), a next-generation leader in big data analytics, has further integrated its ParAccel Big Data Analytics Platform on the Hortonworks Data Platform to address top Hadoop adoption hurdles of data extraction challenges, design-time friction and poor run-time performance.

The deep integration of Actian’s ParAccel Big Data Analytics Platform on the Hortonworks Data Platform enables high-performance analytics without constraints, simplifies the delivery of data services for entire ecosystems of users, and significantly lowers the total cost of ownership for the modern data platform. By utilizing the new Hortonworks/Actian reference architecture, users can experience quicker time to analytic value by:

  • Easily moving data to and from Hadoop: Users can easily extract data from Hadoop and enrich it seamlessly from within the ParAccel Platform.
  • Eliminating design-time friction: ParAccel Dataflow’s easy-to-use drag-and-drop development capabilities negate the need for complex MapReduce coding or parallel programming.
  • Improving performance: Actian is Hortonworks Data Platform 2.0 and YARN certified, giving users the ability to leverage ParAccel Dataflow for the enhanced performance of pipeline parallelism alongside their existing MapReduce jobs.

Sand Hill Group recently surveyed Hadoop users, primarily data architects and CIOs, to assess their level of maturity in Hadoop adoption and the top challenges they face. For 46.7 percent of respondents, the top challenge was knowledge and experience with the Hadoop platform, while 20.7 percent cited availability of Hadoop and Big Data skills and 6.7 percent struggled with the amount of technology development and engineering required to implement a Hadoop-based solution. Actian’s and Hortonworks’ joint reference architecture tackles these key challenges head-on.

“Hadoop is the clear winner for enterprises that seek to drive transformational, actionable business insights from their big data,” said Mike Hoskins, chief technology officer of Actian Corporation. “For all its power, Hadoop still presents significant barriers to enterprise-scale adoption. The combined Actian-Hortonworks solution overcomes challenges around MapReduce skills shortages, design-time friction and run-time performance to elevate Hadoop to true enterprise readiness. Actian has many global clients delivering groundbreaking big data projects. For nearly all of these, Hadoop is a central building block. The collaboration between Hortonworks and Actian provides a huge boost for performance, productivity and access to rich big data functionality, which helps increase adoption of Hadoop. For our mutual customers it boils down to faster time to value – in the end, that’s what really counts.”

“We have collaborated closely with Actian on the reference architecture for the ParAccel Big Data Analytics Platform and the Hortonworks Data Platform,” said Ari Zilka, chief technology officer of Hortonworks. “When used together, these products allow users to rapidly and effectively deploy high-performance Hadoop applications for scenarios ranging from archiving, ETL and operational applications to advanced analytics, including predictive analytics. By working together we are excited to help forward-thinking architects and CIOs successfully design and implement incredibly high-performing, hard-hitting big data applications with proven best practices, robust and secure architecture, and unmatched technology capabilities.”

“Design and implementation of next-generation big data integration processes can be a daunting leap for BI professionals who are used to classic ETL technology,” said Steve Miller, president and co-founder of OpenBI. “Actian’s approach – providing a visual data programming technology that executes natively in cluster – will increase productivity while opening up big data analytics programming to a much broader set of professionals.”

“Our research findings offer compelling insights into friction points on the march to harnessing Hadoop to unlock big data analytics value for the enterprise,” says M.R. Rangaswami, co-founder and managing director of Sand Hill Group. "With more than 35 percent of respondents indicating that the results of their Hadoop/Big Data initiatives were less than they expected, the market is ripe for more easy-to-use, easy-to-implement solutions on Hadoop such as Actian's analytics and ETL offerings.”

Hoskins and Zilka will jointly present at Strata + Hadoop World 2013 on Tuesday, October 29, 2013 at 1:45 p.m. EDT. In addition, both Actian and Hortonworks will provide hands-on demonstrations of the reference architecture at their Strata booths, #108 and #306, respectively.

About Actian: Take Action on Big Data
Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, Calif. with offices in Austin, New York, London, Paris, Frankfurt, Amsterdam, New Delhi and Melbourne. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, Actian DataCloud, ParAccel, Action Apps, Ingres, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

# # #

Categories: Database, Vendor

Actian Appoints New CMO and SVP of Business Development to Accelerate the Transformation of the Big Data Marketplace

Actian Corporation (Ingres) Press Releases - Thu, 10/24/2013 - 19:00

Ashish Gupta, Former Microsoft and Vidyo executive, is poised to redefine the data analytics marketplace by creating new opportunities not addressed by aging stack players

Redwood City, Calif. – October 24, 2013 — – Actian Corporation (“Actian”), a next-generation leader in big data analytics and cloud integration, has appointed Ashish Gupta as chief marketing officer and senior vice president of business development.

“We have very systematically evolved our business so that we have a very powerful engine for the market’s transition to the Age of Data,” said Steve Shine, chief executive officer of Actian Corporation. “Ashish Gupta brings the go-to-market experience to ensure that we build our base in big data analytics and cloud integration. More importantly, he has the strategic vision to work with the team to entirely redefine these markets as we leapfrog legacy stack players.”

Gupta brings a passion and track record for challenging established companies saddled with legacy approaches, often caught in the Innovator’s Dilemma, by exploiting disruptive technologies and creative marketing strategies to rapidly scale the new entrant’s business and open new markets not addressed by incumbents. He joins Actian from Vidyo, a video conferencing provider, where he served as chief marketing officer and senior vice president of corporate development. Under his leadership, Vidyo experienced significant growth, formed key strategic partnerships and built a leading brand in the industry – challenging the leaders of a 30-year-old industry. Prior to Vidyo, Gupta held various executive roles within the Microsoft Office Division where he led marketing, sales and business development teams for Microsoft’s Unified Communications Group, competing with established PBX vendors to create a leadership position for Microsoft Lync in the communications and collaboration market. Gupta has also served in executive roles at Alcatel/Genesys Telecommunications, Deloitte Consulting, Covad and Hewlett-Packard.

“Severe market disruption happens when innovative technologies materially shift an industry’s fulcrum to create new business approaches and markets,” said Gupta. “Actian’s portfolio has proven to be such a force in the industry by enabling next-generation analytical solutions and invisible integration for thousands of customers that use data to create sustainable competitive advantage. I welcome the opportunity to contribute to the company’s fast growth and market leadership.”

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor

Actian to Present at the 10th Annual East Coast Technology Growth Conference

Actian Corporation (Ingres) Press Releases - Tue, 10/15/2013 - 02:41

Redwood City, Calif. – October 14, 2013 — – John Santaferraro, vice president of solutions and product marketing at Actian Corporation(“Actian”), a next-generation leader in big data analytics, will present during the AGC Partners 10th Annual East Coast Technology Growth Conference at the Westin Copley Place in Boston on Tuesday, October 15, 2013.

During the event, Santaferraro will participate in a panel focused on Big Data Analytics moderated by Jeff Kelly, Principal Research Coordinator of the Wikibon Project. Santaferraro and fellow panelists Kathy McGroddy, VP of Business Development of IBM; Louis Brun, Senior VP of Product Strategy of Guavus; Jit Saxena, Chairman of Netezza and Anthony Deighton, CTO of QlikView will discuss why traditional data management and business analytics tools and technologies are straining under the weight of big data. They will shed light on challenges organizations face when deriving value from their data and share new approaches in helping enterprises gain actionable insights through next-generation big data analytics.

Visit actian.com to learn more about Actian’s next-generation approach of enabling organizations to predict the future, prescribe the next best action, prevent damage to their business and discover hidden risks and opportunities through use of the ParAccel Big Data Analytics Platform.

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor