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

Microsoft Enhances Data Platform with Availability of Fully-Managed NoSQL and Search Services

 Guest post by Tiffany Wissner, Senior Director, Data Platform

As part of our commitment to delivering a world-class data platform for our customers, I am  excited to announce the general availability of Azure Search and Azure DocumentDB to support the search and unstructured data  needs of today’s modern cloud applications.

  • Generally available today, Azure Search is a fully manage search service that enables developers to easily add search capabilities to web and mobile applications. 
  • We are also announcing the April 8 general availability of Azure DocumentDB , our NoSQL document database-as-a-service.

These new data services extend our investments in a broad portfolio of solutions to unlock insights from data. Azure is at the center of our strategy, offering customers scale, simplicity and great economics. And we continue to make it easier for customers to work with data of any type and size – using the tools, languages and frameworks they want – in a trusted cloud environment.

Azure Search now generally available

 Azure Search helps developers build sophisticated search experiences into web and mobile applications. It reduces the friction and complexity of implementing full-text search and helps developers differentiate their applications through powerful features not available with other search packages. As an example, we are adding enhanced multi-language support for more than 50 languages built on our many years of natural language processing experience from products like Microsoft Office and Bing. With general availability, Azure Search now offers customers the ability to more easily load data from Azure DocumentDB, Azure SQL Database, and SQL Server running in Azure VMs in to Azure Search using new indexers. Plus, a .NET software development kit (SDK) is now available to make working with Azure Search a more familiar experience.

JLL, a professional services and investment management company that specializes in commercial real estate, is currently using Azure Search to enable search at scale as it was difficult to do so previously.

“It has always been our plan to have our entire web listings platform in the cloud, but the only component that stopped us from doing that was search. Now, with the Azure Search service, we can realize our goal,” said Sridhar Potineni, director of Innovation at JLL. 

Gjirafa, a full-text web search engine and news aggregator specialized in the Albanian language, is also using Azure Search to take on web search giants. Gjirafa is able to use Azure Search to prioritize results that directly tie to their business model.

“Using Azure Search to pre-process the language, we can determine the exact meaning of a phrase before returning the search results. This, along with our local data, means we can serve the Albanian market better than the big search engines,” said Mergim Cahani, founder and CEO of Gjirafa.

Azure DocumentDB generally availability next month

 Azure DocumentDB offers rich query and transactional processing over a schema-free JavaScript Object Notation (JSON) data model, which helps enable rapid development and high performance for cloud-born data and applications. Offered in units that scale to meet application performance and storage needs, Azure DocumentDB allows customers to quickly build, grow, and scale cloud applications. The global reach of Azure datacenters ensures that data can scale with the global growth of the application.

New at general availability are flexible performance levels within our standard tier which allow fine control over throughput and cost for data depending on application needs. Azure DocumentDB will be available in three standard performance levels: S1, S2, and S3. Collections of data within a DocumentDB database can be assigned to different performance levels allowing you to purchase only the performance you need. In preview, DocumentDB has been used for a wide variety of scenarios including telemetry and logging data, event and workflow data, device and app configuration data, and user-generated content.

Customers such as Telenor and News Republic are currently using Azure DocumentDB to store and query schema-free event and app configuration data. Telenor, based in Fornebu, Norway, is a mobile operator with subscribers in 27 nations. To attract customers to their service, the company used Azure DocumentDB to get a promotion up and running quickly and track user sign ups.

“With Azure DocumentDB, we didn’t have to say ‘no’ to the business, and we weren’t a bottleneck to launching the promotion—in fact, we came in ahead of schedule,” said Andreas Helland, Mobility architect at Telenor.

News Republic, a free mobile app that aggregates news and delivers it to more than 1 million users in 15 countries, uses Azure DocumentDB to make its app more interactive and create more user-focused features.

“Many people read the news passively, but we have built personalization and interactivity into our app with Azure DocumentDB. This is definitely a great way to get more people using the app and keep existing users interested,” said Marc Tonnes, database administrator for News Republic.

Microsoft data services

The value provided by our data services multiplies when customers use them together. For example, Xomni uses both Azure DocumentDB and Azure Search to create omni-channel marketing experiences for top-tier retailers like Gamestop. Likewise, we are committed to making it easy for customers to connect these services to others within the data platform through tools like the Search Indexer (to connect with SQL Database, Azure DocumentDB, and SQL Server in an Azure VM) and the recently announced Azure DocumentDB Hadoop Connector.  By making it simpler to connect data sources across Azure, we want to make it easier to implement big data and Internet-of-Things solutions.

Azure data services provide unparalleled choice for businesses, developers and IT pros with a variety of managed services from Microsoft and our partners that work together seamlessly and connect to our customers’ data platform investments-- from relational data to non-relational data, structured data to unstructured data, constant and evolving data models. I encourage you to try out our new and expanded Azure data services and let us know what you think.

Categories: Database

Introduction to Automating Deployment of SQL Server in Azure IaaS Virtual Machines

Database Journal News - Thu, 03/05/2015 - 09:01

In general, Microsoft Azure provides two types of SQL Server based relational data services, Azure SQL Database Platform-as-a-Service (PaaS) and deploying a SQL Server instance into an Azure Infrastructure-as-a-Service (IaaS) virtual machine. There are obvious implications in regards to the management overhead associated with IaaS-based solutions. Marcin Policht reviews methods that allow you to minimize this overhead, focusing in particular on deployment tasks.

Categories: Database

Meet the PostgresDAC v3.0.0

PostgreSQL News - Wed, 03/04/2015 - 01:00
We've released our new major version of PostgresDAC component suite. It’s been a long way started almost two years ago. The goals were complicated, and not all of them were accomplished. However, in general we may proudly say without a doubt that this release is a significant milestone. Dump and restore functionality

TPSQLDump and TPSQLRestore components is a pair that is one of a kind on the whole market. There are no more such facilities not only in the Delphi or C Builder world, but for any other IDE's or toolchains. That is why our first goal was to keep this classes up to date. A huge amount of work was done and a year ago the brand new v3 TPSQLDump and TPSQLRestore components were published as part of v2.11.0 release.

TPSQLDump and TPSQLRestore are fully compatible with native pg_dump and pg_restore utilities. Each and every native feature is supported out of the box:

  • output formats (binary, text, directory, gzipped),
  • parallel dumping and restoring,
  • comprehensive selection, filtering and reordering of archived items,
  • SQL-92 specific output options, etc.
Asynchronous Fetch-On-Demand mode

The default TPSQLQuery's mode is suitable for submitting commands and getting result sets in normal, synchronous applications. However, there are few drawbacks, that may be of importance to developers:

  • TPSQLQuery.Open waits for the command to be completed. The application might have other work to do (such as maintaining a user interface), in which case it won’t be a good decision to block while waiting for a response.
  • Since the execution of the client application is suspended while it waits for the result, it is hard for the application to decide that it would like to try to cancel the ongoing command.
  • TPSQLQuery in default mode always collects a command's entire result, buffering it in a single place. While this behavior simplifies some internal logic, it can be impractical for results containing many rows.

To avoid such limitations developers now can use the brand new Fetch-On-Demand mode, which is turned on by dsoFetchOnDemand option in the TPSQLQuery.Options set. There are limitations of course:

  • To get advantages of the Fetch-On-Demand mode one should use read-only TPSQLQuery objects. This restriction will be removed with time probably.
  • Each read-only TPSQLQuery component must have its separate TPSQLDatabase component since Fetch-On-Demand command flow will block a connection until getting the last row of the result set.
Support for built-in range and geometric field types

Previously these specific types were mapped to TStringField class. Now PostgresDAC provides new TField descendants for this:

  • TPSQLRangeField
  • TPSQLPointField
  • TPSQLCircleField
  • TPSQLBoxField
  • TPSQLLSegField

All of them will be created automatically if needed, or may be added manually in design time.

TPSQLRangeField encapsulates all built-in PostgreSQL range types: int4range, int8range, numrange, tsrange, tstzrange and daterange. Information about range value is stored in the TPSQLRange record by storing values for each bound using TPSQLRangeBound record. Depending on the underlying table field type developer may access bound values using appropriate methods AsInteger, AsFloat, etc.

Enhanced Manual

We've finished the new help system. It's rewritten it from scratch. Support for such formats provided:

  • chm,
  • pdf.
  • epub (in progress).
Full changelog:
  • [!] Fetch-On-Demand mode introduced for readonly TPSQLQuery objects
  • [!] Support for geometric types added
  • [!] TPSQLRangeField added
  • [!] Support for pre-8.0 PostgreSQL servers is discontinued
  • [!] v9.4.0 client libraries added
  • [!] v9.4.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [*] Components TPSQLUser and TBDE2PSQLDAC marked as deprecated and will be removed shortly
  • [*] EPSQLDatabaseError is raised if TPSQLDatabase is used in non-exclusive mode for TPSQLQuery with dsoFetchOnDemand
  • [*] TPSQLDatabase.CancelBackend checks for connection now to prevent AV
  • [-] "AV may occur if SQL parameter name consists from incorrect characters chain" bug fixed
  • [-] "EPSQLDatabaseError detail error properties are empty after error in TPSQLDirectQuery.Open" bug fixed
Download

You're welcome to download the PostgresDAC v3.0.0 right now at: http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Categories: Database, Open Source

Explore In-Memory Technologies at Ignite

You've probably already heard why you should use the in-memory tech built into Microsoft SQL Server: 30 times faster transaction speed, 100 times the query speed, and millions of rows of data analyzed every second. If you want to learn more about the how, check out the Microsoft Ignite session with the no-nonsense title, In-Memory Technologies Overview.

Microsoft SQL Program Manager Kevin Farlee will walk you through all three in-memory technologies contained within SQL Server:

  • In-memory online transaction processing (OLTP)
  • In-memory data warehousing
  • Buffer pool extension (BPE)

He'll cover the thinking behind their inclusion in SQL Server, take a look at the tech behind the scenes, and explore real-world customer benefits. You'll come away with a deeper understanding of these powerful technologies, knowing exactly how to put them to work for your team.

There’s plenty more happening at Ignite. Get email updates by subscribing here. And if you haven’t already, register for Ignite here.

Categories: Database

Oracle Announces Release of Java Development Kit 8, Update 40

Oracle Database News - Tue, 03/03/2015 - 15:02
Oracle Announces Release of Java Development Kit 8, Update 40Continues to Invest in World’s Leading Programming Language to Deliver Foundation for Today’s Modern Technologies

Redwood Shores, Calif. – March 3, 2015 – Demonstrating its continued investment in the world’s #1 programming language, Oracle today announced the release of the Java Development Kit (JDK) 8, Update 40 (JDK 8u40). From small devices to smart cities, Java powers solutions like no other technology. As such, Oracle is committed to working closely with key partners in the Java ecosystem to continually modernize and deliver new innovations to the Java Platform. This latest release of Oracle’s implementation of Java SE, JDK 8u40, brings improvements to performance, scalability and administration, making it easier for Java developers, partners and IT decision makers to innovate faster in a simple, easy manner and improve application services. The release also includes new updates to JavaFX. Full release notes can be found here.

“The proliferation of mobile devices and the Internet of Things has led to an increasingly connected world, but none of this would be possible without underlying foundational technology like Java,” said Georges Saab, vice president of development, Java Platform at Oracle. “With these updates to JDK 8, we continue to usher in the next era of Java to enable developers and enterprises alike to cement Java’s role as the backbone of today’s and tomorrow’s revolutionary business solutions.”

Rapid Adoption, Continued Java SE Innovation

Since its launch last year, Java SE 8 has achieved record adoption rates. Overall, adoption is up significantly compared to the same post-launch time period for Java SE 7. Continuing to deliver significant enhancements to the platform, the latest release introduces the following features and benefits:

G1 enhancements (JEP156): Limits the likelihood of long pauses while the system frees resources. G1 reliance on full Garbage Collections to perform class unloading or any other critical operations has been reduced. This is achieved by enabling class unloading to occur at the end of concurrent marking cycles. Dynamic Enablement of Java Flight Recorder (JFR): Simplifying usability for Oracle Java SE Advanced users, JFR can now be dynamically enabled from the command line or Java Mission Control (JMC), regardless of the original start-up parameters. Previously this could only be done with a stop and restart with the proper instructions from the command line. Dynamic enablement of JFR enables users to resolve production problems without requiring a stop, which may impact SLAs and cause disruptions to the end-user experience. Improvements to the native packager: Enables developers to create native-feel applications that do not require clients to have an existing Java Runtime installed. These self-contained applications can then be deployed into areas like the Mac app store. The application developer has full control over the runtime and application entry points. New Time Zone Date Updater Tool: This tool can consume the ‘raw’ time zone data (tzdata) rules from the IANA time zone registry database and convert those to the necessary format required by the JRE. This provides users with the ability to immediately update the JDK/JRE time zone rules with the latest updates from IANA. Nashorn Support: Numerous Nashorn optimizations including support for dynamic languages are incorporated into this release. Also added is a Nashorn Class Filter, which provides fine-grained control over access to Java classes from JavaScript code via a new filtering interface. JVM Reaction to Memory Pressure: “Memory pressure” is a property that represents the total memory usage (RAM) on the system. This new feature can be leveraged to reduce the amount of memory used on a system where multiple JVMs are deployed and control the amount of memory designated to be consumed by each JVM, avoiding Out of Memory Errors (OOMEs) from occurring. Java Mission Control 5.5 (JMC): This tool is now bundled with JDK 8u40. Based on Eclipse 4.4, JMC 5.5 also includes plug-ins that are now signed and will by default hide Lambda Form hidden methods. Lambda Form Reduction and Caching (JEP 210): This enhancement reduces the required memory footprint for applications and improves performance of dynamic languages. Native Memory Tracking Scalability (JEP 195): This feature has been improved to allow it to run without causing a significant performance impact. At the same time, this feature provides users the ability to diagnose Java Virtual Machine (JVM) memory leaks. Enhanced cryptographic performance of SHA algorithms: Performance has been improved on SPARC class systems which are used heavily by signing certificates in the Web of Trust. SHA performance is critical to Internet security as browsers have begun requiring more computationally expensive versions of SHA-256 or higher, and deprecating SHA-1.Continued Innovations in Java FX

New JavaFX features and enhancements include:

Ability to modernize the JavaFX stack on Mac OS X (JEP 206): The JavaFX media stack has been ported on Mac OS X from QTKit and Quicktime, which have been deprecated, to the newer AVFoundation framework. With this, developers using the JavaFX media stack can now gain Mac App Store acceptance and have the opportunity to have their applications released on the Mac App Store. JavaFX Accessibility (JEP 204): Existing JavaFX controls to support assistive technologies have been enhanced and a public API is provided for developers to write their own accessible controls.

Current versions of Java SE are available for general computing use for no charge on the Oracle website. To access, end users can visit here and developers can visit here.

Java Facts and Figures 9 million developers worldwide More than 3 billion devices are powered by Java technology More than 125 million Java-based media devices have been deployed Over 10 billion Java Cards have been shipped since its introduction With a global distribution of 212,000 copies, Java Magazine is a free subscription, published on a bi-monthly basis in digital and mobile formats, which highlights news, new products, innovative Java applications and includes hands-on, how-to technical content. The March/April 2014 issue includes extensive technical content on Java 8, including articles on Lambda expressions, Nashorn, Compact Profiles, date and time API, the Internet of Things, streams, Java type annotations, and more. Subscribe today at oracle.com/javamagazine.Additional Information Join Oracle on LinkedIn and follow on Twitter. To learn more about Java, please follow the conversation on TwitterI Love Java on Facebook, or the JavaOne blog. For more, watch video and visit Oracle Java SE products, Oracle Java SE Advanced data sheet, Java Mission Control and Java Advanced Management Console.About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Diana Wong
Oracle
+1.650.506.2757
diana.wong@oracle.com

Seema Kalra
Oracle
+1.650.506.2925
seema.kalra@oracle.com

 
Categories: Database, Vendor

Fujitsu Develops Column-Oriented Data-Processing Engine that accelerates analytic processing more than fifty-fold on a single server with PostgreSQL open-source database

PostgreSQL News - Tue, 03/03/2015 - 01:00

Fujitsu Laboratories Ltd. today announced that it has developed a column-oriented data-storage and processing engine that enables fast analysis of large volumes of data in a database system.

In recent years, column-oriented databases have emerged as a system that allows for better speed when reading and analyzing large volumes of data, as a counterpart to existing row-oriented databases, which are suited to handling data updates. But problems have been either that the changes to row-oriented data cannot be automatically reflected in column-oriented data, or that the size of the column-oriented data is constrained by installed memory.

Fujitsu has developed an engine that, running on a PostgreSQL open-source database, without being dependent on memory capacity, instantly updates column-oriented data in response to changes in row-oriented data, and processes column-oriented data quickly. The engine quickly analyzes indexes(1), which are provided by most database systems, and can be used by developers without special consideration to whether the storage method is row-oriented or column-oriented. With a parallel-processing engine especially suited for processing column-oriented data, analyses run on a single CPU core are conducted 4 times faster than before, and one server equipped with 15 CPU cores can run analyses at least 50 times faster.

For more information please visit http://www.fujitsu.com/global/about/resources/news/press-releases/2015/0226-01.html

Categories: Database, Open Source

Using the ROLLUP, CUBE, and GROUPING SETS Operators

Database Journal News - Mon, 03/02/2015 - 09:01

Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.

Categories: Database

Oracle’s New Ethernet Switches and Virtual Network Services Target Software-Defined Data Centers and Cloud

Oracle Database News - Mon, 03/02/2015 - 09:00
Oracle’s New Ethernet Switches and Virtual Network Services Target Software-Defined Data Centers and Cloud High performance, low cost networking fabric engineered for the Oracle stack enables customers to deploy network services on-demand

Barcelona, Spain – Mobile World Congress (Hall 3, Stand 3B20) – March 2, 2015 – Oracle addressed two major networking requirements for cloud-enabled data centers today with new high performance, low cost 10Gb/40Gb Ethernet switches and the addition of virtual network services to Oracle SDN. Engineered and integrated to enhance the Oracle stack, the new networking technologies provide the flexibility and scalability for both enterprise data centers and network function virtualization infrastructure.

“Cloud-enabled data centers are only as fast or as agile as their networking allows, which makes the convergence of software-defined networking and network services a next logical step in the evolution of the software-defined data center,” said Raju Penumatcha, senior vice president, Netra Systems and Networking, Oracle. “Oracle’s new Ethernet switches and virtual network services in Oracle SDN help clear the way for enterprises to deploy key network services faster and gain high performance at the lowest cost.”

Oracle Ethernet Switch ES2-72 and Oracle Ethernet Switch ES2-64 are designed to harness the full capabilities of Oracle engineered systems, servers and storage with extremely low-latency and massive scalability for all Oracle applications including Oracle Real Application Clusters (RAC), as well as financial and high-performance computing (HPC) applications.

These high density, low cost Ethernet switches help collapse existing multi-tiered network topologies, simplifying IT infrastructure and reducing costs with fewer cables and simplified management. When deployed with Oracle systems, the new switches can further reduce cost through reuse of existing cabling infrastructure and unified management. The switches are used in Oracle’s Netra Modular System and are also available independently.

“The transition to software-defined data centers has created new networking requirements where high speed and low latency are must-haves for most applications,” said David Krozier, principal analyst at Ovum. “Oracle’s new ES2-64 and ES2-72 Ethernet switches ably address these requirements with impressive performance at what Oracle claims is a very competitive price. Combine these switches with the new virtual network services in Oracle SDN, and unified management across the entire Oracle systems portfolio, and customers now have a compelling new fabric option for building flexible, scalable and agile infrastructure for cloud deployments.”

Oracle SDN Unifies InfiniBand and Ethernet Fabrics with New Virtual Network Services

Oracle also added new virtual network services to Oracle SDN, virtually eliminating the need for purpose-built network appliances which lack the scalability and flexibility needed in today’s data centers. The new services allow customers to deploy security, load balancing and routing on-demand in a single virtual instance with the ability to configure and manage them in a single pane using Oracle Fabric Manager.

Oracle SDN dynamically connects any virtual machine to any resource and allows for quick deployment of multi-tenant environments via a private virtual interconnect, which delivers up to 80 Gb/sec server-to-server bandwidth to radically accelerate application performance. A single fabric connects up to 1,000 servers and 16,000 private virtual interconnects. With its new virtual network services capabilities, Oracle SDN now extends across the data center and is uniquely able to unify InfiniBand and Ethernet fabrics, allowing end-to-end provisioning of network infrastructure from a single management interface.

Oracle SDN supports both SPARC and x86 servers as well as the new Netra Modular System. Oracle SDN also powers engineered systems like Oracle’s Virtual Compute Appliance.

“Oracle SDN has simplified and accelerated our data center infrastructure and allowed us the flexibility to support our customers and our growing business needs,” said Shlome Seidenfeld, CIO and senior vice president, E-Commerce, B&H Photo Video. “Oracle’s high speed, low-latency fabric has given us the performance and agility we needed to accommodate a multi-fold jump in customer traffic to our e-commerce business. We are very excited to see the unveiling of virtual network services as part of the Oracle SDN portfolio.”

Oracle Executive Vice President John Fowler will host a webcast at 9 a.m. Pacific today to discuss Oracle networking and today’s news in more detail. The networking technologies announced today are also on display at Mobile World Congress in Hall 3, Stand 3B20.

Additional Information

Join Oracle on LinkedIn and follow @Oracle on Twitter. To learn more about Oracle’s Netra servers and networking please follow @OracleHardware.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://oracle.com/.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle Corporation.

 

Contact Info

Michelle Jenkins
Oracle
+1.425.945.8306
michelle.jenkins@oracle.com

Drew Smith
Blanc & Otus
+1.415.856.5127
dsmith@blancandotus.com

  
Categories: Database, Vendor

PoWA 2: Finding the Missing Index !

PostgreSQL News - Mon, 03/02/2015 - 01:00

Paris, March 2 2015

DALIBO is proud to present the second release of PoWA, the PostgreSQL Workload Analyzer.

Complete rewrite of the User Interface

The first major change is the new graphic design : we've rebuilt the web interface from scratch and placed it on a separate module called powa-web. It is now easier to move the PoWA interface out of the database server.

The new interface is based on the previous version and it adds many improvements, including:

  • More graphs
  • New types of graph : Bar / Pie Charts
  • New configuration view
  • New index suggestion widget
  • New physical resource consumption graphs
  • Better Global Query Chart
  • Breadcrumbs
  • Python 2.6, 2.7 and 3.4 compatibility
  • Better browser compatibility

 

Screenshot:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_stat_statements.html#where-is-it-used-in-powa-web

Advanced Filesystem Stats

Second, the core-engine of PoWA is now a separate module too: it's called powa-archivist and we've extended it to archive any kind of internal stats. The main source of stats remains the pg_stat_statements extension but we've integrated 2 other extensions: pg_qualstats and pg_stat_kcache.

With pg_stat_kcache, PoWA is now able to gather statistics about the physical disk access and the CPU consumption of each PostgreSQL backend. This allows the DBA to get a glimpse of the OS-level cache hit ratio.

Screenshot:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_stat_kcache.html#where-is-it-used-in-powa-web

Missing Index Finder + Advanced WHERE Clause Analyzer

Third major improvement, with pg_qualstats PoWA is now collecting metrics about the operations in the WHERE clause of each query. With this data, you can know what are the most common values in your SQL statements and evaluate their "selectivity". And for columns with a very high selectivity and no index, PoWA will suggest index creation to speed up you queries.

Screenshot:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_qualstats.html#where-is-it-used-in-powa-web

Disruptive changes

It was a hard choice but if we want to implement ground-breaking features like the Missing Index Finder, we need to use the latest capacities of PostgreSQL and thus we decided to drop the compatibility with PostgreSQL 9.3.

Of course, we will continue to maintain PoWA v1.2 and you can continue to use it on your PostgreSQL 9.3 servers. In a nutshell, If you already use PoWA here's what you need to know:

  • If you're running PostgreSQL 9.4, we recommend that you switch to PoWA 2.0
  • If you're running PostgreSQL 9.3, you can either keep PoWA 1.2 or upgrade your PostgreSQL instance and switch to PoWA 2.0

 

Here's a detailed explanation on why we are Moving Fast and Breaking Things

Credits & Licence

DALIBO would like to thank all the developers who contributed to this release: Rodolphe Quiedeville, Hyunjun Kim, Grégoire Pineau, Ahmed Bessifi, exordium-frozen, Christopher Liu, menardorama and especially Ronan Dunklau and Julien Rouhaud for the hard work on the GUI.

POWA is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to powa@dalibo.com

Links :

For PoWA 2.0:

 

For the new stats extensions:

 

For the complete list of changes, please checkout the release note on http://powa.readthedocs.org/en/latest/releases/v2.0.html

About POWA :

PoWA is a PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

Code & Demo at http://dalibo.github.io/powa/

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io

Categories: Database, Open Source

Manage spatial data with IBM DB2 Spatial Extender, Part 2: Implementing typical spatial use cases

IBM - DB2 and Informix Articles - Sun, 03/01/2015 - 06:00
This series of tutorials takes you through common tasks that work with spatial data in the DB2/reg> Spatial Extender. These tasks include importing and creating spatial data, constructing and executing spatial queries, working with IBM spatial tools, working with third-party and open source software, improving application performance, and taking special considerations in a data warehouse environment.
Categories: Database

Manage spatial data with IBM DB2 Spatial Extender, Part 1: Acquiring spatial data and developing applications

IBM - DB2 and Informix Articles - Sun, 03/01/2015 - 06:00
This tutorial series describes common tasks to manage spatial data with IBM DB2(R) Spatial Extender, including importing and creating spatial data, constructing and executing spatial queries, working with IBM, third-party, and open source spatial tools, tuning performance, and considering special circumstances in a data warehouse environment. Here in Part 1 of the series, learn how to acquire spatial data and build applications. Learn how to use shapefiles, spatial data tables, and spatial indices.
Categories: Database

Webinar: SQL Server for Mission Critical Applications

If you are running older versions of SQL Server or use another database management system as your primary data platform, you may be wondering what the latest version of SQL Server has to offer. Upgrading to the latest version of SQL Server enables breakthrough performance, availability and manageability for your mission critical applications – an investment that could pay you back in as little as 9.5 months.1 Learn more about how SQL Server 2012 and 2014 can help run your tier-1, OLTP applications while maintaining lower costs, strong management and high security.

Join our guest speakers, Forrester Research Principal Analyst Noel Yuhanna, Senior TEI Consultant Anish Shah and Principal TEI Consultant Sean Owens for a webinar on SQL Server economics based on research findings from a recent Microsoft-commissioned study*.

Register to view this complimentary webinar to learn about:

  • The SQL Server tier one application market growth and outlook
  • The importance of security and management when considering a database platform
  • Forrester Consulting’s Total Economic Impact commissioned research on SQL Server for data applications
  • Key costs and benefits organizations should consider when evaluating SQL Server for data-intensive applications
  • Customer experience benefits, opportunities and cost savings enabled by SQL Server

Join us on Wednesday, March 4 at 10:00am Pacific. Register now for this webinar on the economic impact of SQL Server 2012 and 2014 to your business.

*Forrester Consulting, The Total Economic Impact(TM) of Microsoft SQL Server, a commissioned study conducted on behalf of Microsoft, July 2014

Categories: Database

Oracle’s Netra Modular System Brings Converged Infrastructure to the Communications Industry

Oracle Database News - Fri, 02/27/2015 - 17:00
Oracle’s Netra Modular System Brings Converged Infrastructure to the Communications IndustryNew integrated platform helps customers bring services to market faster, lower operational risks, and improve business agility

Redwood Shores, Calif. – February 27, 2015 – Oracle brought its converged infrastructure strategy to the communications industry today with the Netra Modular System, the first integrated platform to merge traditional blade and rackmount architectures, networking and storage to support network function virtualization (NFV).

NFV uses traditional IT and server virtualization techniques to implement network functions as software that can run on industry-standard servers. With the Netra Modular System, NFV can help reduce capital and operational expenditures and accelerate product and service introduction.

“Reducing costs, maximizing constrained resources, getting services to market faster— the business and IT challenges facing service providers, network equipment providers, and others in the communications industry remain ever-present,” said Raju Penumatcha, senior vice president, Netra Systems and Networking, Oracle. “Netra Modular System capitalizes on Oracle’s ability to engineer hardware and software together to deliver NFV infrastructure with Oracle’s latest servers, software and networking all managed, supported, and upgradable as an integrated platform.”

Netra Modular System is a quick-to-deploy, pre-integrated platform that can help customers accelerate application and service development, reduce risk and lower maintenance costs. It supports Oracle Server X5-2 and Oracle’s new Netra Server X5-2, allowing customers to choose either industry-standard or carrier-grade rackmount servers designed for high-performance communication workloads and cloud infrastructure deployments. Netra Server X5-2 offers 2x the number of cores, 1.5x more memory and 2x the storage capacity compared to the previous generation. SPARC platform support is also planned for 2016, which is slated to make the Netra Modular System a multi-instruction set architecture and multi-operating system platform.

“Dialogic has used Oracle’s Netra systems for many years in successfully delivering Dialogic’s ControlSwitch™ System – an unmatched Class 4 softswitch and IMS MGCF - to top service providers worldwide,” said Jim Machi, senior vice president of product management and marketing at Dialogic. “Whether they are deploying NGN or VoLTE networks, today’s service providers demand an ever-increasing level of performance, expandability, reliability and serviceability in telecoms infrastructure platforms. We look forward to delivering even higher performing solutions to our customers with Oracle’s new Netra systems. Dialogic and its customers value Oracle’s high quality and highly reliable Netra products.”

“As communications service providers seek infrastructure to support NFV, Oracle’s Netra Modular System offers a new architecture that incorporates the best of bladed systems and independent rackmount servers in a single platform,” said David Krozier, principal analyst at Ovum. “This new infrastructure platform should be particularly attractive to communications customers who want to virtualize their compute, network and storage infrastructure based on high volume general market products, but still need to support five 9's or greater availability. The Netra Modular System’s ability to interface with OpenStack and utilize Oracle SDN and virtual network services makes it a compelling solution for NFV.”

While ideal for NFV infrastructure, Netra Modular System can also be used in virtually any industry where customers want an integrated, virtualized platform with the benefits of a blade architecture. Netra Modular System supports Oracle Linux, Oracle Solaris and Oracle VM, as well as OpenStack and the Hardware Platform Interface (HPI), giving customers a choice of operating systems as well as the ability to create cloud-based services and provide nearly continuous service availability. For added flexibility, other Linux distributions and hypervisors can be used.

Oracle’s Netra systems will be on display next week at Mobile World Congress in Hall 3, Stand 3B20.

Additional Information

Join Oracle on LinkedIn and follow @Oracle on Twitter; to learn more about Oracle’s Netra servers and networking please follow @OracleHardware.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://oracle.com/.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

 

Contact Info

Michelle Jenkins
Oracle
+1.425.945.8306
michelle.jenkins@oracle.com

Drew Smith
Blanc & Otus
+1.415.856.5127
dsmith@blancandotus.com

  
Categories: Database, Vendor

MySQL Cluster 7.4 Now Generally Available

Oracle Database News - Thu, 02/26/2015 - 17:00
MySQL Cluster 7.4 Now Generally AvailableNew release demonstrates up to 200 million reads per second and enhanced high availability for online transaction processing

Redwood Shores, Calif. – February 26, 2015 – Oracle today announced the general availability of MySQL Cluster 7.4. The new release delivers greater performance, high availability, and advanced management capabilities to power highly demanding telecommunications, web, mobile, and cloud services.

“With digital proliferation generating more data than ever before, businesses need online transaction processing to be as efficient and performant as possible,” said Tomas Ulin, vice president, MySQL engineering, Oracle. “With no single point of failure, MySQL Cluster 7.4 provides high performance to a wide range of application requirements for a user base that spans administrators of major telecommunications subscriber databases to providers of next-generation web, cloud, social, and mobile applications. The new release is a significant update that not only improves overall performance but eases the management efforts for database administrators and DevOps teams.”

MySQL Cluster is an open source, ACID-compliant transactional database designed to deliver real-time in-memory performance and 99.999 percent availability. It powers the subscriber databases of major communications service providers and is used in global fraud detection for financial transactions. The latest 7.4 release builds upon a series of development milestone releases that have enabled users to preview, test, and provide feedback during the development process. Enhancements include:

Greater in-memory performance and scalability: According to the SysBench benchmark, MySQL Cluster 7.4 can deliver a nearly 50 percent performance improvement over MySQL Cluster 7.3 for read-only workloads and nearly 40 percent improvement for read/write operations. Performance improvements are available through SQL or any of the native NoSQL APIs supported by MySQL Cluster, including Java, C++, HTTP, Memcached, and JavaScript/Node.js. Additionally, MySQL Cluster 7.4 established new records of 200 million NoSQL reads per second with 32 data nodes and nearly 2.5 million SQL statements per second with 16 data nodes. Improved workload efficiency for analytics: Users can now efficiently run application workloads involving complex analytics and ad hoc searches on MySQL Cluster using the same memory-optimized tables that provide sub-millisecond low latency and extreme levels of concurrency for OLTP workloads. These durable in-memory tables can be used in combination with disk-based tables. New geographic redundancy features for high availability across data centers: The latest release provides rollback of any conflicting transactions, enabling full active-active, update-anywhere replication between geographically distant clusters, with applications able to send reads and writes to any site without compromising on consistency. Advanced management capabilities: MySQL Cluster for both on-premises and cloud-based deployments features the following improvements: New reports on distributed memory use and database operations, enabling more effective management; Additional performance tuning options; Faster online maintenance operations, including the ability to roll out software upgrades as much as 5x faster. MySQL Cluster 7.4 is available for download here. Terms, conditions, and restrictions apply. Additional Information

Join Oracle on LinkedIn and follow @Oracle on Twitter. To learn more about MySQL Cluster please follow @clusterdb and @MySQL.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center.  For more information about Oracle (NYSE:ORCL), visit oracle.com.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Contact Info

Teri Whitaker
Oracle
+1.650.506.9914
teri.whitaker@oracle.com

Danielle Tarp
Blanc & Otus
+1.415.856.5182
dtarp@blancandotus.com

Categories: Database, Vendor

MySQL Cluster 7.4 Now Generally Available

MySQL AB - Thu, 02/26/2015 - 01:59
New release demonstrates up to 200 million reads per second and enhanced high availability for online transaction processing.
Categories: Database, Vendor

PT Telekomunikasi Indonesia Deploys Innovative New Services Using Oracle Communications Service Delivery Platform

Oracle Database News - Wed, 02/25/2015 - 14:11
PT Telekomunikasi Indonesia Deploys Innovative New Services Using Oracle Communications Service Delivery PlatformModernized platform will enable the communications service provider to more quickly and cost-effectively develop and deploy new mobile and network services for its customersREDWOOD SHORES, Calif. – Feb. 25, 2015News Summary

To help increase telecommunications service innovation while growing revenue and reducing costs, PT Telekomunikasi Indonesia (Telkom) has upgraded its service delivery platform (SDP) by implementing new releases of the Oracle Communications Service Delivery Platform product family. The improved platform will help the communications service provider (CSP) dramatically reduce the cost and time it takes to develop new mobile, broadband, and network applications and take its innovations to market.

News Facts Today, Oracle announced that Telkom—the largest telecommunications and network service provider in Indonesia—deployed new releases of Oracle Communications Services Gatekeeper and Oracle Communications Converged Application Server, which are part of the Oracle Communications Service Delivery Platform product family. The company originally purchased these products during Oracle’s fiscal 2013 Q4. The solutions will enable Telkom to develop and deploy new next-generation telco and life-style services more quickly, enhancing the customer experience. Telkom will leverage the Oracle solutions to implement a new range of products and services such as SMS push alerts, content downloads via the cloud, and mobile payments. Telkom can launch these new features and extensions to its existing internet protocol (IP)-based communication services quickly and cost-effectively by utilizing the capabilities of the Oracle Communications Converged Application Server. With Oracle Communications Services Gatekeeper, Telkom can also more easily create unique content and user experiences; the solution helps manage and control third-party network access and usage, enabling Telkom to more easily work with external developers. Oracle Communications Consulting worked in conjunction with a Telkom subsidiary to implement the Oracle solutions. The CSP selected Oracle Communications Consulting based on its successful past implementations of the Oracle Communications Service Delivery Platform.
Supporting Quotes “The telecommunications industry in Indonesia is rapidly maturing and evolving—an opportunity for us, but one that also puts us under pressure to keep up with increasing customer volume as well as demand for new products and services. With the solutions from the Oracle Communications Service Delivery Platform in place, we know we are ready to take on the growing traffic and transactions—and at the same time respond to customers with the new services they want,” said Tanto Suratno, head of SOA and SDP, PT Telekomunikasi Indonesia. “With the explosion of new emerging technologies, such as over-the-top content, CSPs face the challenge of delivering innovative IP-based communications services while also ensuring maximum profitability. The Oracle Communications Service Delivery Platform products will enable Telkom to improve time to market for new applications, thereby improving operational costs and maintaining its ongoing commitment to innovation,” said Steve Aulds, vice president of product development, Oracle Communications.
Supporting Resources About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademark

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contacts:

Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com

Janice Clayton
O’Keeffe
+1.443.759.8151
jclayton@okco.com

Categories: Database, Vendor

PT Telekomunikasi Indonesia Deploys Innovative New Services Using Oracle Communications Service Delivery Platform

Oracle Database News - Wed, 02/25/2015 - 14:00
PT Telekomunikasi Indonesia Deploys Innovative New Services Using Oracle Communications Service Delivery PlatformModernized platform will enable the communications service provider to more quickly and cost-effectively develop and deploy new mobile and network services for its customersREDWOOD SHORES, Calif. – Feb. 25, 2015News Summary

To help increase telecommunications service innovation while growing revenue and reducing costs, PT Telekomunikasi Indonesia (Telkom) has upgraded its service delivery platform (SDP) by implementing new releases of the Oracle Communications Service Delivery Platform product family. The improved platform will help the communications service provider (CSP) dramatically reduce the cost and time it takes to develop new mobile, broadband, and network applications and take its innovations to market.

News Facts Today, Oracle announced that Telkom—the largest telecommunications and network service provider in Indonesia—deployed new releases of Oracle Communications Services Gatekeeper and Oracle Communications Converged Application Server, which are part of the Oracle Communications Service Delivery Platform product family. The company originally purchased these products during Oracle’s fiscal 2013 Q4. The solutions will enable Telkom to develop and deploy new next-generation telco and life-style services more quickly, enhancing the customer experience. Telkom will leverage the Oracle solutions to implement a new range of products and services such as SMS push alerts, content downloads via the cloud, and mobile payments. Telkom can launch these new features and extensions to its existing internet protocol (IP)-based communication services quickly and cost-effectively by utilizing the capabilities of the Oracle Communications Converged Application Server. With Oracle Communications Services Gatekeeper, Telkom can also more easily create unique content and user experiences; the solution helps manage and control third-party network access and usage, enabling Telkom to more easily work with external developers. Oracle Communications Consulting worked in conjunction with a Telkom subsidiary to implement the Oracle solutions. The CSP selected Oracle Communications Consulting based on its successful past implementations of the Oracle Communications Service Delivery Platform.
Supporting Quotes “The telecommunications industry in Indonesia is rapidly maturing and evolving—an opportunity for us, but one that also puts us under pressure to keep up with increasing customer volume as well as demand for new products and services. With the solutions from the Oracle Communications Service Delivery Platform in place, we know we are ready to take on the growing traffic and transactions—and at the same time respond to customers with the new services they want,” said Tanto Suratno, head of SOA and SDP, PT Telekomunikasi Indonesia. “With the explosion of new emerging technologies, such as over-the-top content, CSPs face the challenge of delivering innovative IP-based communications services while also ensuring maximum profitability. The Oracle Communications Service Delivery Platform products will enable Telkom to improve time to market for new applications, thereby improving operational costs and maintaining its ongoing commitment to innovation,” said Steve Aulds, vice president of product development, Oracle Communications.
Supporting Resources About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademark

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contacts:

Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com

Janice Clayton
O’Keeffe
+1.443.759.8151
jclayton@okco.com

Categories: Database, Vendor

Oracle Validated Integration Partners Offer Healthcare Organizations Fast Time to Value

Oracle Database News - Wed, 02/25/2015 - 13:00
Oracle Validated Integration Partners Offer Healthcare Organizations Fast Time to ValueInnovative, prebuilt offerings available for Oracle enterprise healthcare analytics solutions

Redwood Shores, Calif. – February 25, 2015 - Healthcare organizations are increasingly focused on streamlining data to meet a multitude of challenges, from regulatory compliance and reimbursement management to delivering quality care to their patients across the care continuum. Oracle today announced it has expanded its Oracle Validated Integration program to include the Oracle Healthcare platform, starting with Oracle Enterprise Healthcare Analytics. This expansion of the Oracle Validated Integration program will help healthcare organizations identify innovative healthcare analytic applications more quickly and subsequently deploy these partner solutions with less risk so they can focus on their core objective—improving patient care.

Oracle Validated Integration, available through Oracle PartnerNetwork (OPN), provides partners with a path for building and promoting repeatable integrations with solutions that complement and extend Oracle Applications. Healthcare organizations will be able to use preintegrated partner solutions with Oracle Health Sciences Enterprise Healthcare Analytics to help reduce deployment risk, accelerate time to value for critical decision making, and drive operational and financial improvements with exceptional patient outcomes and experience. Using Oracle Enterprise Healthcare Analytics, a leading healthcare enterprise-class data management platform, healthcare providers can enhance data transparency and obtain insights that allow them to improve patient safety, care quality, cost efficiency, and overall enterprise performance.

“Partners achieving Oracle Validated Integration with Oracle Healthcare can help healthcare organizations deploy critical healthcare analytics solutions more quickly and with less risk—ultimately accelerating programs that improve organizational efficiency and enhance patient care,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences.

Oracle PartnerNetwork members Edgewater Ranzal, Grant Thornton, MedeAnalytics, and Perficient are among the initial partners participating in Oracle Validated Integration with Oracle Enterprise Healthcare Analytics. Perficient, Grant Thornton, and Edgewater Ranzal are delivering advanced healthcare cost accounting solutions preintegrated with Oracle Enterprise Healthcare Analytics. MedeAnalytics is delivering its Revenue Cycle solution with Oracle Enterprise Healthcare Analytics.

“Perficient is excited to be a plank owner in the Oracle Hyperion and Oracle Enterprise Healthcare Analytics integration effort. Our High-Performance Costing Expressway is the intersection of cost and quality of patient care,” said Emil Fernandez, vice president, Oracle National Business Unit, Perficient.

“Faced with new payment models and increased competition in the marketplace, large and small healthcare providers benefit from detailed insight into the costs associated with the care they deliver,” said Carl Yost, principal, Grant Thornton. “Grant Thornton’s Healthcare Costing Informatics (RxCI) solution, preintegrated with Oracle Enterprise Healthcare Analytics, allows healthcare providers to achieve actionable analytics quickly and in alignment with industry best practices. That insight allows them to make informed decisions that can increase their quality of care and positively impact operating results.”

“Edgewater Ranzal has chosen to preintegrate our Ranzal Healthcare Analytics (RHA) Costing solution with Oracle Enterprise Healthcare Analytics to provide healthcare providers advanced patient analytics,” said Mark Hite, healthcare practice director, Edgewater Ranzal. “The solution delivers the information necessary to support advanced costing down to the encounter level, including detailed attribution.”

“The combined solution of with Mede/Revenue Cycle provides customers with a single, integrated view of their organization’s financial data—enabling increased cash collections, reduction in bad debt, enhanced productivity, and actionable insight on enterprise business strategy,” said Melissa Ross, vice president of business development, MedeAnalytics.

With these preintegrated offerings, healthcare organizations can quickly deploy and derive value from a broad set of analytics applications that can help extend the Oracle Healthcare platform.

Additional Information

Join the Oracle Health Sciences community on Facebook and follow @OracleHealthSci on Twitter.

About Oracle Validated Integration

Oracle Validated Integration, available through the Oracle PartnerNetwork (OPN), gives customers confidence that the integration of complementary partner software products with Oracle Applications and specific Oracle Fusion Middleware solutions have been validated, and the products work together as designed. This can help customers reduce risk, improve system implementation cycles, and provide for smoother upgrades and simpler maintenance. Oracle Validated Integration applies a rigorous technical process to review partner integrations. Partners who have successfully completed the program are authorized to use the Oracle Validated Integration logo. For more information, please visit Oracle.com at oracle.com/us/partnerships/solutions/index.html.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.com

Categories: Database, Vendor

My Oracle Cup Overflows

Database Journal News - Mon, 02/23/2015 - 09:01

Overflow data in an index-organized table is usually put in its own tablespace.  Sometimes it isn't; read on to see what overflow data is and how to change where it's located.

Categories: Database

Oracle Advances Vision for Enterprise Big Data

Oracle Database News - Thu, 02/19/2015 - 17:00
Press Release Oracle Advances Vision for Enterprise Big Data New technologies help integrate big data with enterprise computing, making big data insights a reality

Strata + Hadoop World, San Jose, Calif.—Feb 19, 2015

Oracle Big Data Discovery

Oracle Big Data Discovery offers tremendous speed at massive scale, streamlining Big Data analytics to unlock new value for everyone.

Oracle today unveiled new big data solutions that simplify information access and discovery, enabling customers to quickly turn data into business value. New offerings include Oracle Big Data Discovery, Oracle GoldenGate for Big Data, Oracle Big Data SQL 1.1 and Oracle NoSQL Database 3.2.5. These additions further Oracle's vision to enable Hadoop, NoSQL, and SQL technologies to work together and be deployed securely in any model—whether public cloud, private cloud or an on-premises infrastructure.

Generating value from big data requires the right tools to move and store data to effectively discover new insights. In order to operationalize those insights, new data must integrate securely with existing data, infrastructure, applications and processes. These Oracle solutions work seamlessly together to help companies exploit enterprise big data faster, at lower cost, and with less risk. They allow customers to securely reach across Hadoop, NoSQL and relational databases to easily and cost-effectively analyze massive and diverse data sets.

"One type of technology will no longer suffice in supporting all the analytics use cases. At the same time, data management and analysis as a series of unrelated projects results in an unmanageable IT quagmire and unnecessary risks," said Dan Vesset, vice president of Business Analytics Research, IDC. "IDC predicts that by 2017 unified data platform architecture will become the foundation of enterprise-wide big data and analytics strategy. The unification will occur across information management, analysis and search technology."

Oracle GoldenGate

Oracle GoldenGate for Big Data offers an extensible solution to support all major big data systems.

"Data is a new kind of capital and enterprises must invest their data capital strategically to create the best return," said Neil Mendelson, vice president of big data at Oracle. "Oracle gives customers an integrated platform that helps simplify access to all their data, discover new insights, predict outcomes in real time, and keep all their data governed and secure."

Oracle's new big data offerings are also designed to run seamlessly on the recently announced Oracle Big Data Appliance X5 and Oracle Exadata Database Machine X5. Together, these solutions deliver a complete, cost-effective platform to accessing, discovering, governing and securing big data.

Today's new big data innovations include:

  • Oracle Big Data Discovery, the "visual face of Hadoop" and an end-to-end product for finding, exploring, transforming, discovering and sharing big data insights. Big data assets become more accessible to a greater number of business analysts across the organization and help reduce risks and improve time to value for big data projects.
  • Oracle GoldenGate for Big Data, a Hadoop-based technology that allows customers to stream real-time data from heterogeneous transactional systems into big data systems, including targets such as Apache Hadoop, Apache Hive, Apache HBase and Apache Flume. It allows customers to enhance big data analytics initiatives by incorporating existing real-time architectures into big data solutions, while ensuring their big data reservoirs are up to date with production systems.
  • Oracle Big Data SQL 1.1, a technology that extends Oracle SQL to Hadoop and NoSQL, with all the security of the Oracle Database. It enables a single fast query, written in Oracle SQL, to transparently access data in Hadoop, NoSQL and Oracle Database. Oracle Big Data SQL 1.1 provides tighter integration between Hadoop and Oracle Database, while increasing query performance by up to 40 percent from previous versions.
  • Oracle NoSQL Database 3.2.5, an adaptable solution that allows developers to build high performance, next generation applications. The latest release provides predictable low latency, a RESTful API, and a Thrift-based C API, and is integrated with the Oracle Big Data platform. Building on Oracle Big Data SQL, Oracle NoSQL Database 3.2.5 also supports data definition language (DDL), making it even easier to use SQL to query NoSQL data.
Oracle Big Data Discovery Now Generally Available

Oracle Big Data Discovery leverages the power of Hadoop so that users can quickly and easily turn raw data into actionable business insight with a single product.

  • Find and explore big data as easily as shopping online: Oracle Big Data Discovery provides a compelling visual interface for finding and exploring raw data in Hadoop. It acts as a scratch pad for uncovering statistical correlations between data attributes and combinations to evaluate whether a data set has potential and is worthy of further investigation and resources. Users browse an interactive visual data catalog through familiar guided navigation and powerful search capabilities.
  • Transform and enrich data at scale: Raw data in Hadoop needs preparation before it's ready for analytics. Oracle Big Data Discovery reduces lengthy prep cycles and streamlines data wrangling through an intuitive and spreadsheet-like experience. Users can enhance data visually, without switching tools or writing code so that more time can be spent on analytics.
  • Discover and share to find new value: Discovery and analysis require different tools than those used for data preparation. Oracle Big Data Discovery enables users to seamlessly move from preparation to analysis, and share insights with a click. Users can collaborate on results, publish original data sets back to Hadoop, and leverage results in other tools such as Pig, Hive, and Python.
  • Unlock big data access for a wider group: Big data is usually in the hands of a few data scientists who are highly skilled, expensive and hard to find. Oracle Big Data Discovery makes big data simpler to manage and more accessible to a larger group, including analytics teams and business users. It also integrates with existing big data tools, making it easy for organizations to expand their big data teams to get the most from their human capital and data assets.
Contact Info Marcie Bradley
Oracle
+1.530.214.8068
marcie.bradley@oracle.com Seema Kalra
Oracle
+1.650.506.2925
seema.kalra@oracle.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Learn More Oracle Big Data Talk to a Press Contact

Marcie Bradley

  • +1.530.214.8068

Seema Kalra

  • +1.650.506.2925

Follow

Follow Oracle Corporate

Categories: Database, Vendor