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 Unleashes New Innovations in Data Analytics with Free and Open Interfaces to On-chip Accelerators

Oracle Database News - Tue, 03/08/2016 - 23:37
Press Release Oracle Unleashes New Innovations in Data Analytics with Free and Open Interfaces to On-chip Accelerators Analytics Added to Open Platform for Security to Enable Breakthroughs in Data Analytics Using Oracle’s Software in Silicon Technology

Redwood Shores, Calif.—Mar 8, 2016

Empowering developers to build the next generation of big data analytics platforms, Oracle released a free and open API and developer kit for its Data Analytics Accelerator (DAX) in SPARC processors through its Software in Silicon Developer Program. The program also lets developers view sample use cases and program code, and to test and validate how DAX can speed up analytics applications while test driving Software in Silicon Technology.   “High performance data analytics are critical to a range of key use cases like click stream data, social media sentiment, buying behavior, and more,” said John Fowler, Executive Vice President of Systems, Oracle. “Through our Software in Silicon Developer Program, developers can now apply our DAX technology to a broad spectrum of previously unsolvable challenges in the analytics space because we have integrated data analytics acceleration into processors, enabling unprecedented data scan rates of up to 170 billion rows per second.”   With the release of the 32-core, 256 thread SPARC M7 processor, Oracle created a number of Software in Silicon features by building in higher-level software functions into processor design. One of the most exciting new capabilities introduced in the SPARC M7 processor as part of the Software in Silicon innovations in SPARC M7 is DAX, which delivers unprecedented analytics efficiency.   Data Analytics Accelerator on SPARC M7 DAX adds processing capability that can run selective functionality – Scan, Extract, Select and Translate – at incredibly fast speeds. The SPARC M7 DAX accelerates these analytics primitives on a dedicated physical unit separate from the standard compute cores.   Initial software development enabled DAX for Oracle Database 12c, and all the applications above it. This extends analytics acceleration to all Oracle, ISV, and customer applications.   Large scale scan and filter operations are made trivial by transparent use of 32 dedicated DAX co-processors in the SPARC microprocessor which operate at memory bus speeds of up to 160 GB/s between cache and DRAM. These accelerators, implemented for the first time on-chip for the highest level of performance and efficiency, can now be used by developers through APIs in Oracle Solaris 11, and applied to a variety of use cases.   As one notable example of Data Analytics Accelerator integration into machine learning and Big Data use cases, Oracle engineers have shown that the DAX can significantly accelerate Apache Spark, which has become one of the most popular methods for processing large data sets. Through this project, engineers used the DAX with Apache Spark to take one billion rows of data in memory and filter it into a 3D cube so fast that interactive data analytics are now possible.   SPARC M7 and DAX design advantages include:
 
  • Industry-leading delivered memory bandwidth: at an industry-leading 160GB/s memory bandwidth, the SPARC M7 processor provides enough capacity to feed both the DAX units as well as processor cores.
     
  • DAX offload: frees the processor cores for other processing.
     
  • Efficient decompressing combined with in-memory processing: putting decompression in the DAX unit is much faster than software implementations. Designing decompression with scanning means needless back and forth memory transfers are avoided. Results from the DAX are entered into the CPU cache for better CPU efficiency.
     
  • DAX range comparisons: many real-world database analytics queries are written to find data transacted between certain dates, or product cost ranges, etc. The DAX processes range comparisons at the same rate as individual comparisons. Other processors require additional computational time for each comparison.
     
  • Avoiding cache pollution: the DAX does much of its computation without needing to store intermediate data in a cache, freeing the CPU’s cache for other processing.
    Partnerships with Developer Community and Leading Higher Education Institutions Oracle continues to deliver traditional processor enhancements to improve performance of traditional workloads with more than 20 world record results over the competition. Software in Silicon can deliver previously unattainable step function improvements required in areas such as security and data analytics by embedding the functionalities to handle particular algorithms on the processor with greater performance and efficiency.   Oracle has also published several use cases with code samples to maximize developer productivity and expedite projects as well as a detailed example of DAX integration with Apache Spark. Resources can be accessed now via the Oracle Software in Silicon Cloud, a freely available cloud service for developers and researchers that provides direct access to this technology. Additionally, Oracle is partnering with leading higher education institutions such as Brown University, on innovative research projects with Software in Silicon.   “We are currently working on characterizing the performance of DAX across a suite of modern in-memory data layout schemes. After completing this study, we will work on the optimal use of DAX in accelerating interactive data exploration and visualization with the Tupleware main-memory database system and S-Store real-time stream processing system,” stated Ugur Centimenel, Chairman of the Computer Science Department, Brown University. “Through these studies, we will quantify the performance and scalability of M7 and DAX on real workloads involving sophisticated search and machine learning over large data sets.”   Open APIs for Oracle’s Data Analytics Accelerator are now available for free via the Software in Silicon Cloud. Developers can join the community now to get started on developing the next generation of big data and analytics applications.   Additional Information:   Contact Info Diana Wong
Oracle
+1.650.506.2757
diana.wong@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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. 

Talk to a Press Contact

Diana Wong

  • +1.650.506.2757

Follow Oracle Corporate

Categories: Database, Vendor

Announcing SQL Server on Linux

Today, we announced our plans to bring SQL Server to Linux. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017.  Read Scott Guthrie’s blog post to learn more.

Categories: Database

First release candidate of SQL Server 2016 now available

We are excited to announce that our first SQL Server 2016 release candidate, SQL Server 2016 Release Candidate (RC) 0, is now available for download. This is an important milestone in the release of SQL Server 2016, as this marks feature completion for most dimensions of the product. It also means a very rich set of capabilities is now available, including real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technologies, and new hybrid scenarios allowing you to securely stretch data to the cloud.

As part of our new rapid release model, we will be publishing multiple release candidates on a more frequent cadence. SQL Server 2016 RC 0, which you can try in your development and test environments, is available for download or in an Azure VM today.

In SQL Server 2016 RC 0, we made enhancements to several features, including:

  • Stretch Database service: With this preview, SQL Server 2016 users can dynamically stretch their on-premises warm and cold data to an Azure service that is engineered from the ground up for compute capacity and virtually infinite storage.
  • Enhancements to In-Memory OLTP: In-Memory OLTP, which dramatically improves transaction processing performance, now has reduced downtime during upgrades.
  • Enhancements to SQL Server Analysis Services: A new Tabular Object model is released to allow easier development and maintenance through code against tabular models.
  • Enhancements to SQL Server Reporting Services: You can do much more in this next preview of the new Reporting Services web portal, including subscribe to reports, manage shared datasets, manage data caching and refresh, and more.

For additional detail, please visit the detailed RC 0 technical overview blog post and the RC 0 Analysis Services blog post.

To learn more, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business. To learn more about the SQL Server Stretch Database service preview, visit the product page in Azure.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know with the Connect tool. We look forward to hearing from you!

Categories: Database

Technical Overview: SQL Server 2016 Release Candidate 0

The SQL Server engineering team is pleased to announce the availability of SQL Server 2016 Release Candidate 0. This is an important milestone in the release of SQL Server 2016, as it marks feature completion for most dimensions of the product and means a very rich set of capabilities are now available. These include: real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technologies, and new hybrid scenarios allowing you to securely stretch data to the cloud.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know using Microsoft’s Connect tool. We look forward to hearing from you.

For more information on this release, see SQL Server 2016 Release Notes and What’s New in SQL Server 2016.

Database scoped configuration

This release now supports a new database level object that holds optional configuration values that affect the behavior of the application code at the database level. This support is available in both SQL Server 2016 Release Candidate (RC0) and SQL Database V12 using the new ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL) statement. This statement modifies the default SQL Server 2016 Database Engine behavior for a particular database. A generic mechanism for creating database configuration(s) at creation time is not provided.

These options are:

  • Clear procedure cache.
  • Set the MAXDOP parameter to an arbitrary value (1,2, …) for the primary database based on what works best for that particular database and set a different value (e.g. 0) for all secondary database used (e.g. for reporting queries).
  • Set the query optimizer cardinality estimation model independent of the database to compatibility level.
  • Enable or disable parameter sniffing at the database level.
  • Enable or disable query optimization hotfixes at the database level.

The following T-SQL Syntax is supported:

ALTER DATABASE SCOPED CONFIGURATION

{
{ [ FOR SECONDARY] SET }
}
| CLEAR PROCEDURE_CACHE
[;]

< set_options > ::=
{
MAXDOP = { | PRIMARY}
| LEGACY_CARDINALITY_ESTIMATION = { ON | OFF | PRIMARY}
| PARAMETER_SNIFFING = { ON | OFF | PRIMARY}
| QUERY_OPTIMIZER_HOTFIXES = { ON | OFF | PRIMARY}
}

The new functionality is supported for both Azure SQL Database and SQL Server.

PolyBase enhancements in RC0 include:

  • Support for the latest Cloudera distribution CDH5.5 on Linux
  • Support for public containers and blobs in Azure blob storage

SQL Server Management Studio improvements in this release include:

In-Memory OLTP new features in RC0:

  • Parallel scan of non-clustered indexes. All indexes on memory-optimized tables now support parallel scan, leading to increased performance of analytics-style queries that scan large sets of data.
  • Reduced downtime during upgrade: upgrade from earlier builds of SQL Server 2016 no longer runs database recovery; the time it takes to run upgrade is no longer a factor of the data size. For upgrade and attach/restore from SQL Server 2014 the number of database restarts is reduced to one: during upgrade, the database is restarted once, thus the time it takes to upgrade is a factor of the data size.
  • Built-in function @@SPID is now supported natively compiled T-SQL modules and in constraints on memory-optimized tables
  • Log-optimized and parallel ALTER: most ALTER TABLE operations now run in parallel and result in only the metadata change to be written to the transaction log, reducing the time required to run the ALTER operation.
Improved support for large number of foreign key references

With CTP3.3, we added support for efficient DELETE operations for tables with up to 10,000 incoming foreign key references. With RC0, we are adding support for the following:

  • Efficient UPDATE operations on tables with up to 10,000 incoming foreign key references.
  • Efficient DELETE and UPDATE operations for partitioned tables with large numbers of foreign key references.

The following limitations still apply:

  • MERGE operations are not supported for tables with large numbers of foreign key references
  • Large numbers of foreign key references are not currently supported for memory-optimized tables, or stretch database.
New Built-in Table-Valued Function STRING_SPLIT

STRING_SPLIT is a T-SQL function that splits input character expression by specified separator and outputs result as a table.

Syntax:

STRING_SPLIT ( string, separator )
returns: table with a column named value

Examples:

Split comma separated value literal string
SELECT * FROM STRING_SPLIT(‘Lorem ipsum dolor sit amet.’, ”)

The result is:

value
—–
Lorem
ipsum
dolor
sit
amet.

Split comma separated value string in a column
SELECT id, title, value
FROM Article
CROSS APPLY STRING_SPLIT(tags, ‘,’)

Support for import and export of UTF-8 data

Data stored in a UTF-8 encoded file can now be imported into SQL Server and exported from SQL Server into a UTF-8 encoded file, using BULK INSERT T-SQL command and bcp command line utility. As a part of the import process, the UTF-8 encoded strings are read from the file, and converted and stored as native data types that correspond to the target columns in SQL Server tables. As a part of the export process, data are converted from native data types into UTF-8 encoded strings and written into the file. All native data types are supported except Xml, SqlVariant, Text, NText, and Image. The UTF-8 code page is specified by providing the following arguments:

  • CODEPAGE = ‘65001’, DATAFILETYPE = ‘Char’, in case of BULK INSERT command,
  • -c -C 65001, in case of bcp utility.

Examples:

Importing with BULK INSERT into SQL Server from a file
BULK INSERT MyTable
FROM ‘path\file.csv’
WITH ( FIELDTERMINATOR = ‘,’, CODEPAGE = ‘65001’, DATAFILETYPE = ‘Char’)

Importing with bcp utility into SQL Server from a file
bcp MyTable in   “path\file.csv” -T -t , -c -C 65001

Exporting with bcp utility from SQL Server to a file
bcp MyTable out “path\file.csv” -T -t , -c -C 65001

AlwaysOn Availability Groups add support for:

  • Distributed Availability Groups: It is now possible to configure replication between availability groups. Note: these different availability groups can live on different Windows Clusters.
  • Streaming seeding of replicas: New secondary replicas in an Availability Group can now be seeded directly from the primary replica without the need for database backup/restore.
SQL Server Analysis Services (SSAS)

This month’s update to Analysis Services delivers support for display folders for Tabular models, any models created with new SQL Server 2016 compatibility level can now be used with PowerShell and SSIS. Finally, the new Tabular Object model is released to allow easier development and maintenance through code against tabular models. See the Analysis Services blog for more details.

SQL Server Reporting Services (SSRS)

Much more functionality is now available in this next preview of the new Reporting Services web portal. You can now:

  • Subscribe to reports to receive them in your email inbox, download, rename, move, and delete reports and other catalog items
  • Manage shared datasets
  • Manage data caching and refresh
  • Create “linked” reports with different default parameter values
  • Pin to a dashboard in a group when pinning a report chart, gauge, map, or image to a Power BI dashboard
  • Choose the currency for monetary values when creating a KPI or mobile report
SQL Server Integration Services (SSIS)

SSIS Projects in Visual Studio SQL Server Data Tools (SSDT) can now target 2012, 2014 and 2016 versions of SQL Server by switching a project level property between 2012, 2014 and 2016 SQL server. SSIS now supports setting a server wide customized logging level. Finally, the SSIS HDFS connector now supports the ORC file format, in addition to CSV and Avro. See the Integration Services blog for more details.

Master Data Services (MDS) adds a New Derived Hierarchy Management web page. See the Master Data Services blog for more details.

For more information on this release, see SQL Server 2016 Release Notes and What’s New in SQL Server 2016.

Categories: Database

Announcing SQL Server Stretch Database service preview

Microsoft is pleased to announce a preview of the new SQL Server Stretch Database service. With this preview, SQL Server 2016 users can dynamically stretch their on-premises warm and cold data to an Azure service that is engineered from the ground up for compute capacity and virtually infinite storage. Unlike typical cold data management solutions, your data is always at hand and secure by design. You can now keep as much data as you need indefinitely without long maintenance windows or the high costs of traditional enterprise storage.

The Stretch Database service makes remote query processing possible by providing compute and storage in a way that’s completely transparent to the application; using Stretch Database typically doesn’t require any application changes. If added security is required you can use Stretch Database with new Always Encrypted technology, where sensitive data is encrypted before sending to Azure and the encryption key always remains on-premises—extending data in a more secured manner for greater peace of mind.

How to use Stretch Database with SQL Server 2016

Right now, with SQL Server 2016 RCO, when you enable stretching to Azure from SQL Server Management Studio, the default behavior is to stretch to Azure SQL Database. If you would like to preview the new Stretch Database service, you can enroll in the preview and we’ll provide instructions for configuring your SQL Server 2016 database for this new service. For future builds of SQL Server 2016, Stretch Database service will be the default target location for stretching.

Getting started with Stretch Database

If you’re ready to learn more about Stretch Database, read our getting started articles about Stretch Database in SQL Server books online.

If you’re ready to sign up for the Stretch Database preview, register for preview access. To trial SQL Server 2016, you can download an evaluation copy here or try the preview by using a virtual machine in Microsoft Azure.

Questions?

Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know on Connect. We look forward to hearing from you!

Categories: Database

Introduction to Protecting SQL Server with Azure Site Recovery

Database Journal News - Mon, 03/07/2016 - 09:01

Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.

Categories: Database

Build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect, Part 2: Consume a DB2 Adapter service

IBM - DB2 and Informix Articles - Sat, 03/05/2016 - 06:00
To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM DB2 Adapter for z/OS expose DB2 for z/OS functionality to applications. In Part 2 of the series, learn how to build a mobile application using IBM MobileFirst Developer Edition by consuming a DB2 Adapter service.
Categories: Database

10 New Features Worth Exploring in SQL Server 2016

Database Journal News - Thu, 03/03/2016 - 09:01

There is a lot of buzz around SQL Server 2016. It will not be too long until SQL Server 2016 will be fully baked and ready for shipping. As always there are a ton of new features and in this article Greg Larsen explores 10 of those new features.

Categories: Database

Oracle Unveils First Data Protection Solution with Seamless Cloud Tiering

Oracle Database News - Wed, 03/02/2016 - 00:34
Press Release Oracle Unveils First Data Protection Solution with Seamless Cloud Tiering Oracle’s StorageTek Virtual Storage Manager 7 System Provides Mainframe and Heterogeneous Storage with a Fully Integrated Cloud Strategy

Redwood Shores, Calif.—Mar 1, 2016

Oracle announces the all new StorageTek Virtual Storage Manager (VSM) 7 System, the most secure and scalable data protection solution for mainframe and heterogeneous systems with the additional capability to provide fully automated tiering directly to the public cloud. Furthermore, Oracle’s StorageTek VSM 7 System has been architected to seamlessly integrate with Oracle Storage Cloud Service—Object Storage and Oracle Storage Cloud Service – Archive Service and provides storage administrators with a built-in cloud strategy. With Oracle, cloud storage is now as accessible as on-premise storage.

“In the past, data protection solutions were designed to deal with exponential data growth on-premises, but an entirely different dynamic drove the design of the VSM 7,” said James Cates, senior vice president, Archive Product Development, Oracle. “The core is still there—elevated performance, twice the capacity, a higher degree of scalability, but we saw a gap in the market, so we developed Engineered Cloud Tiering to enable mainframe users to take advantage of cloud economics.”

“With its VSM 7, Oracle is bringing mainframe-caliber data protection to heterogeneous systems users, and its native tiering to the Oracle Cloud’s storage and archive services will no doubt extend the market potential,” said Mark Peters, practice director and senior analyst, ESG. "Furthermore, the enterprise-caliber Oracle Cloud adds a compelling and affordable storage alternative for mainframe customers.”

Organizations can experience these benefits:  

  • Performance & Scalability: Oracle’s StorageTek VSM 7 System is a superior data protection solution for IBM z Systems mainframes with full data interchange across previous generation VSM systems and key features that IBM’s TS7700 virtual tape system lacks. Oracle’s StorageTek VSM 7 System delivers, 34x more capacity, significantly higher scalability to 256 StorageTek VSM 7 Systems, data deduplication and native cloud tiering that provides mainframe and heterogeneous storage users the ability to access additional capacity on demand.
  • Enhanced Security: Powered by Oracle’s breakthrough SPARC M7 processor, Oracle’s StorageTek VSM 7 System delivers wide-key encryption for data at rest and on removable tape media without performance compromise and also uses Silicon Secured Memory for data protection.
  • Availability: Oracle’s StorageTek VSM 7 System provides data protection solutions from on-premises to Oracle Cloud, with a single point of contact for all mainframe storage and heterogeneous storage requirements. Policies can be set to automatically copy or migrate files from external disk storage to low cost, off-site cloud storage. With native cloud tiering, customers benefit from end-to-end visibility and diagnostics from on-premise StorageTek VSM 7 System deployments to the Oracle Storage Cloud Service or Oracle Storage Cloud Archive Service.
  • Disaster Recovery: Oracle’s StorageTek VSM 7 System enables a “lights out” disaster recovery strategy, as a mainframe is no longer required at remote sites, dramatically reducing costs and simplifying deployments. Electronic data sharing across separate complexes, clustering, replication, and DR to the Oracle Cloud provides a breadth of simple, flexible disaster recovery options.

Oracle is also addressing the needs of mission critical heterogeneous environments underserved by other solutions. Extending its enterprise-proven architecture to a broader customer base, Oracle is providing robust mainframe data protection capabilities with flexible disaster recovery options.

Availability

  • Q1 CY2016

Additional Resources

Contact Info Diana Wong
Oracle
+1.650.506.2757
diana.wong@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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. 

Talk to a Press Contact

Diana Wong

  • +1.650.506.2757

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Introduces Software Solution to Help Healthcare Organizations Optimize Performance and Enhance Innovation through Population Health Management and Precision Medicine

Oracle Database News - Tue, 03/01/2016 - 20:04
Press Release Oracle Introduces Software Solution to Help Healthcare Organizations Optimize Performance and Enhance Innovation through Population Health Management and Precision Medicine

HIMSS Annual Conference & Exhibition – Las Vegas, NV—Mar 1, 2016

Healthcare organizations are navigating a shifting and complex environment. This requires everyone across the organization to synchronize efforts toward the common goal of delivering the right care, at the right time, with the right resources.

Focused on this goal, Oracle has introduced Oracle Healthcare Foundation (OHF), a next-generation version of Oracle Enterprise Healthcare Analytics, which provides healthcare organizations with a consistent, reliable, and complete, patient-centric view of their data across the enterprise, including clinical, financial, and genomics. Purpose-built for the healthcare industry, the modular data integration and analytics solution enables healthcare providers to leverage a single source of truth to measure and evaluate care outcomes, while sharpening operational efforts for the populations they serve—maximizing wellness and minimizing cost. 

Regardless of the operational function within an organization—be it supporting clinical care, performing financial analyses, streamlining administrative services, or supporting research—OHF provides a holistic, patient-centric, information platform that enables the entire organization to treat each patient with a personal touch, while achieving high-quality, value-based care in an operationally efficient environment. With just a single installation, the flexible, modular offering can scale up or down to meet the analytics needs of an organization.

“Innovation moves from possible to real when patients can benefit from scientific advances in genomics and value-based care,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences. “Utilizing Oracle Healthcare Foundation as a common data integration and analytics platform, each member of the organization can focus on solving his or her unique problems through actionable insight. Patients and providers win when the entire organization leverages its collective knowledge to affect outcomes and costs.”

The solution brings together data from a variety of source systems and includes pre-built functions that allow for ease of data mapping from these systems.  This approach shortens client implementation time and provides more value from the client’s current system investments. Health care providers can focus their efforts on optimizing quality and caring for patients.

A high level of data governance and accuracy helps ensure rapid generation of meaningful, actionable insight with reduced delays in integrating disparate information systems.

The platform provides a common information foundation with data captured once and made available to every team member across the enterprise for analysis and utilization.

Every member of the organization can perform his or her unique role on behalf of each and every patient served by the system to support population health analytics, care coordination, shared-risk models. A common clinical and financial view of the patient can be used for any clinical applications that need reliable patient-specific data.

  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 Additional Information

To learn more about Oracle Health Sciences, please follow @OracleHealthSci and Oracle Health Sciences.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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. 

Talk to a Press Contact

Samantha Thai

  • +1.510.917.5564

Mary Tobin

  • +1.503.658.7396

Follow Oracle Corporate

Categories: Database, Vendor

Are you running SQL Server 2005 Express? (Are you sure?)

Only a few weeks remain before extended support for SQL Server 2005 ends. Although we’ve been talking about this for months, there’s a chance the April 12 end of support date will sneak up on you — if you’re one of thousands who are running SQL Server 2005 Express.

SQL Server 2005 Express is a free download that can function both as the client database and a basic server database. This edition was ideal for independent software vendors, server users, application developers, web developers and website hosts building client applications. Because it’s so easy to install Express with an application, or to build a custom application, IT may not be aware it is running. The best way to be sure is to complete an assessment.

You should care, and you should act, because end of support spells the end of important security updates and hotfixes that you’ve relied on for years. Continuing to operate SQL Server 2005 Express without these updates from Microsoft may put your organization at risk for business disruptions, security and compliance issues, and increased maintenance costs. It’s time to upgrade to SQL Server 2014 Express now.

There are many benefits of moving to a modern version of SQL Server Express. Running a fully supported, newer version of SQL Server Express offers major enhancements in scale, manageability, programmability and security for your application:

  • Scale increase. The size limit for databases has increased from 4 GB in SQL Server 2005 to 10 GB in SQL Server 2014 Express.
  • Manageability. SQL Server 2014 Express supports scripting with Windows PowerShell 3.0. It also provides policy-based management from SQL Server Management Studio.
  • Programmability. New versions of SQL Server drivers support a variety of programming languages and platforms, including .NET, C and C++, Java, Linux and PHP. The latest version of SQL Server supports SQL Server Data Tools.
  • Security. Modern SQL Server versions give additional security features, including user-defined server roles, enhanced separation of duty, and backup encryption support to fully safeguard important data.

Software running on SQL Server 2005 Express can be upgraded using simple techniques like in-place upgrade or database detach and attach. Read the SQL Server 2014 Express Technical Upgrade Guide or watch a short video to find out how and why to upgrade.

Why upgrade? Watch a video to find out.

Download the SQL 2005 Express upgrade data sheet.

Download the SQL Server 2014 Express Technical Upgrade Guide.

Get resources.

Sign in and upgrade to SQL Server 2014 Express.

Categories: Database

Accelerating SAP CO-PA with DB2 for Linux, UNIX, and Windows

IBM - DB2 and Informix Articles - Tue, 03/01/2016 - 06:00
SAP Profitability Analysis (CO-PA) reports, which are primarily used for drill-down analysis, fetch a significant number of records and aggregate them to a small result set. Using intrapartition parallelism, a feature available in DB2, can speed up the query processing by eight times or more, depending on hardware resources and data distribution. In this tutorial, we’ll demonstrate the benefits of intrapartition parallelism and discuss how to use it effectively for reporting queries.
Categories: Database

The One 'Security' Feature in Oracle You Probably Shouldn't Use

Database Journal News - Mon, 02/29/2016 - 09:01

Oracle offers a number of security-related settings, but one could definitely create more harm than good.  Read on to see which parameter that is, and why.

Categories: Database

Barman 1.6.0 released

PostgreSQL News - Mon, 02/29/2016 - 01:00

29 February 2016: 2ndQuadrant is proud to announce the release of version 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL.

Major release

This major release introduces WAL streaming support, improving disaster recovery capabilities of PostgreSQL backup solutions based on Barman, by reducing Recovery Point Objective consistently to nearly 0. Currently, Barman still requires standard WAL archiving based on PostgreSQL's 'archive_command'. This limitation will be removed once Barman supports replication slots (available from PostgreSQL 9.4).

Barman 1.6.0 introduces also support to pigz compression, as well as Python-native gzip and bzip2 compression algorithms.

Bug fixes

Minor bugs have also been fixed.

For a complete list of changes, see the "Release Notes" section below.

Links Release notes
  • Support for streaming replication connection through the 'streaming_conninfo' server option

  • Support for the 'streaming_archiver' option that allows Barman to receive WAL files through PostgreSQL's native streaming protocol. When set to 'on', it relies on 'pg_receivexlog' to receive WAL data, reducing Recovery Point Objective. Currently, WAL streaming is an additional feature (standard log archiving is still required)

  • Implement the 'receive-wal' command that, when 'streaming_archiver' is on, wraps 'pg_receivexlog' for WAL streaming. Add '--stop' option to stop receiving WAL files via streaming protocol. Add '--reset' option to reset the streaming status and restart from the current xlog in Postgres.

  • Automatic management (startup and stop) of 'receive-wal' command via 'cron' command

  • Support for the 'path_prefix' configuration option

  • Introduction of the 'archiver' option (currently fixed to 'on') which enables continuous WAL archiving for a specific server, through log shipping via PostgreSQL's 'archive_command'

  • Support for 'streaming_wals_directory' and 'errors_directory' options

  • Management of WAL duplicates in 'archive-wal' command and integration with 'check' command

  • Verify if 'pg_receivexlog' is running in 'check' command when 'streaming_archiver' is enabled

  • Verify if failed backups are present in 'check' command

  • Accept compressed WAL files in incoming directory

  • Add support for the pigz compressor (thanks to Stefano Zacchiroli)

  • Implement pygzip and pybzip2 compressors (based on an initial idea of Christoph Moench-Tegeder)

  • Creation of an implicit restore point at the end of a backup

  • Current size of the PostgreSQL data files in 'barman status'

  • Permit 'archive_mode=always' for PostgreSQL 9.5 servers (thanks to Christoph Moench-Tegeder)

  • Complete refactoring of the code responsible for connecting to PostgreSQL

  • Improve messaging of cron command regarding sub-processes

  • Native support for Python >= 3.3

  • Changes of behaviour:

    • Stop trashing WAL files during 'archive-wal' (commit:e3a1d16)
  • Bug fixes:
    • Atomic WAL file archiving (#9 and #12)
    • Propagate "-c" option to any Barman subprocess (#19)
    • Fix management of backup ID during backup deletion (#22)
    • Improve 'archive-wal' robustness and log messages (#24)
    • Improve error handling in case of missing parameters
Download About

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Categories: Database, Open Source

SQL indexes and native I/O – no contradiction

IBM - DB2 and Informix Articles - Wed, 02/24/2016 - 06:00
Native I/O is widely used in RPG and COBOL programs for getting access to the data stored in the database. Data access is mostly performed with the help of data description specifications (DDS) keyed physical and logical files. Unfortunately DDS is an outdated technology, while all future development regarding the database and data access is only integrated into SQL. For profiting from the new indexing technologies in release 6.1, native I/O does not need to be replaced with embedded SQL. SQL indexes can be used with native I/O like any keyed logical file. Moreover, the enhanced indexing technologies could first be used with native I/O while the SQL query optimizer could only partially profit from these enhancements.This article explains how SQL indexes can be used in conjunction with native I/O and how native I/O can profit from the enhanced indexing technologies.
Categories: Database

Your invitation to be among the first to hear from SQL Server 2016 engineers

If there’s one phrase that characterizes the SQL Server technical community, it’s passion for learning and sharing data platform knowledge. Here’s your invitation to do just that by attending Data Driven, a live virtual event introducing SQL Server 2016. You’ll hear directly from Microsoft executives and engineering stars about SQL Server 2016 – the biggest leap forward in Microsoft’s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.

The event will feature keynotes by Microsoft Chief Executive Officer Satya Nadella, Corporate Vice Presidents Scott Guthrie and Joseph Sirosh, and President of Microsoft North America Judson Althoff. These executives will set the business context, discussing how data insights are driving business transformation, how customers are embracing data to drive innovation and how companies that transform data into intelligent action are outperforming their competitors and will be the businesses of the future.

There’s more! Exclusive engineering videos before the virtual event

On March 10, we will be posting more than 30 videos, that will help you learn about all the new technical capabilities in SQL Server 2016 that you can try out today.

Not only are you invited to the live event, but if you’re excited to learn about the SQL Server 2016, here’s your opportunity to sign up for early access to exclusive video content from engineering experts before the live, virtual event.

The videos that you will have early access to, include:

  • Speeding up transactions with In-Memory OLTP in SQL Server 2016 with Jos de Bruijn
  • Stretch Database: Securely and transparently leverage infinite storage and compute capacity in Azure with SQL Server 2016 with Joe Yong
  • R Services in SQL Server 2016 with Dotan Elharrar and Umachandar Jayachandran
  • Hybrid BI with Dimah Zaidalkilani
  • Upgrade and Migration to SQL Server 2016 with Lonny Bastien

Take advantage of this great, exclusive content. Sign up and share this opportunity with your community today. You’ll get a deep dive experience unlike any other, directly from the engineers responsible for the technology.

Categories: Database

IBM Datacap 9.0.1 FlexID Panel

IBM - DB2 and Informix Articles - Tue, 02/23/2016 - 06:00
The FlexID panel is included with IBM Datacap and allows manual identification of documents. While the panel provided with the install is generic and allows use with any application, the panel source is provided here to allow user-specific customization of the panel.
Categories: Database

Oracle Enables Communications Service Providers to Transform Business with Cloud-based Network Services

Oracle Database News - Mon, 02/22/2016 - 10:00
Press Release Oracle Enables Communications Service Providers to Transform Business with Cloud-based Network Services Oracle unifies network and IT service delivery to accelerate cloud deployment of core network functions

Redwood Shores, Calif.—Feb 22, 2016

As communication service providers (CSPs) continue to evolve their networks to take advantage of new technologies to deploy innovative services such as voice over LTE (VoLTE) and voice over wi-fi (VoWiFi), they require agile, cost-effective solutions to address their customers’ digital lifestyle expectations. To achieve these goals, CSPs are shifting more of their core network functions to the cloud. The latest version of Oracle Communications Network Service Orchestration Solution, accelerates this transition by providing key service orchestration capabilities that enable CSPs to rapidly design and automatically deploy, scale, heal and terminate services in the network core.  

The solution is part of the Oracle Communications intelligent orchestration framework, which helps guide CSPs in their adoption of Network Function Virtualization technology and helps them maximize its benefits. The framework gathers and analyzes network performance information, evaluates the network’s operation against predefined policies and business rules, and can trigger the appropriate action to automatically modify the behavior of services, network functions, and virtualized infrastructure – in a closed loop manner.

“CSPs are looking to NFV as a means to both transform their networks and to generate new revenues from the increased agility enabled by network virtualization,” said Dana Cooperson, Research Director at Analysys Mason. “For them to be successful, they must take a holistic orchestration approach, based on a modular set of orchestration functions, that facilitates an increasingly dynamic, virtualized network and integrates with end-to-end business and operations processes. Such an approach, of which Oracle Network Service Orchestration Solution is one example, will best position CSPs to realize the full business benefits of their NFV investment.”

CSPs may use new capabilities within Oracle Communications Network Service Orchestration Solution to:

  • Simplify the deployment of virtualized IMS networks that cost-effectively support a new generation of services, such as VoLTE and VoWiFi.
  • Automatically configure customer and network traffic flows, through integration with the OpenDaylight SDN Controller, to scale services up and down while balancing the network load for improved service quality.

  • Optimally configure network services on the underlying hardware – specifically the organization and deployment of virtual CPUs, memory distribution and disk usage – through integration with industry-leading virtual infrastructure managers.
  • Support a broad range of third party virtual network functions by providing native VNF management capabilities to orchestrate VNFs that may or may not have their own VNF Manager – allowing CSPs choice and flexibility in VNF selection for network deployment.

“As CSPs evolve their networks to take advantage of cloud technologies, they must consider how to rapidly introduce virtual network functions while ensuring services are delivered with consistent, prescribed levels of quality,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “This new release of Oracle Communications Network Service Orchestration Solution enables CSPs to deploy and manage network functions optimally to ensure, for example, that premium customer services are guaranteed to be configured on appropriate resources from end to end.”

Oracle Communications Network Service Orchestration Solution is designed to work with upstream operational systems to help CSPs quickly transition to the delivery of real-time, cloud-based services over virtual and hybrid networks. Oracle’s solution for the end-to-end delivery of contemporary cloud-based services includes common, standards-based modeling of products, services and resources across Oracle’s integrated architecture for lifecycle service orchestration and network service orchestration. This productized, end to end capability provides CSPs the service agility and automated operations to begin to truly transform their business, not just their network.

Oracle will showcase this solution as part of the “Offer and Orchestrate NaaS over the Elastic Network” demonstration in Hall 3, Stand 3B20 at Mobile World Congress in Barcelona, February 22 – 25, 2016.

Contact Info Greg Lunsford
Oracle
+1.650.506.6523
greg.lunsford@oracle.com Lisa Fisher
O’Keeffe & Company
+1.703.883.9000x156
lfisher@okco.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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. 

Get Started Oracle Communications Data Sheet Talk to a Press Contact

Greg Lunsford

  • +1.650.506.6523

Lisa Fisher

  • +1.703.883.9000x156

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Enables Mobile Operators to Securely Increase Network Coverage and Capacity Using Wi-Fi and the Internet

Oracle Database News - Mon, 02/22/2016 - 09:03
Press Release Oracle Enables Mobile Operators to Securely Increase Network Coverage and Capacity Using Wi-Fi and the Internet New functionality enables operators to use Wi-Fi to improve indoor voice coverage and offer Wi-Fi-based voice, video, and rich messaging services

Redwood Shores, Calif.—Feb 22, 2016

Consumer use of mobile devices continues to expand at a breakneck pace, which makes it challenging for mobile network operators to deliver the coverage and capacity required for a high quality customer experience. To address this challenge, Oracle today announced that Oracle Communications Mobile Security Gateway provides new ways to help communications service providers (CSPs) cost effectively expand network coverage and increase capacity by safely and securely incorporating Wi-Fi and the internet into the mobile core. In addition, the newly introduced support for Wi-Fi calling allows CSPs to leverage Wi-Fi to address problematic indoor voice coverage problems to provide customers with a consistent mobile network experience even in areas that were previously dead zones in the network.

Oracle Communications Mobile Security Gateway enables CSPs to:

  • Improve indoor voice coverage: With Wi-Fi calling, CSPs can use Wi-Fi as an access network for the mobile core to enable voice and video calling, as well as rich messaging
  • Relieve congestion in the macro network: CSPs can use Wi-Fi offload to unburden data traffic from the macro network and securely move it to the internet
  • Improve coverage and capacity in difficult to reach and high density areas: Small, strategically placed base stations, called small cells, enable CSPs to expand coverage and increase capacity of the mobile network

“The reality is that the macro networks alone cannot solve the seemingly neverending growth in network demand, and it is critical that CSPs find a solution. Increases in customer churn are directly correlated with poor service quality, and unfortunately for the CSPs, customers have other options from over-the-top and competitive service providers,” said Stéphane Téral, Senior Research Director, IHS Inc. “With its Mobile Security Gateway, Oracle Communications addresses CSPs’ thorny issue of providing a cost-effective way to use ubiquitous Wi-Fi and internet to create a more scalable network to better serve their customers with Wi-Fi calling, Wi-Fi offload and small cells capabilities.”

Oracle Communications Mobile Security Gateway provides the high-performance and secure gateway that interconnects the untrusted Wi-Fi and internet with the mobile core. The resulting new heterogeneous networks enable CSPs to increase capacity, expand coverage, and ultimately deliver voice and data services to consumers with higher quality and with no other apparent change to the consumer. The product is built using the same proven security and scalability that is offered by Oracle Communications Session Border Controller.

“Wi-Fi is a standard capability in mobile operating systems. And so the opportunity for CSPs to use it in their mobile networks is clear—both to make the network more reliable and to deliver the kinds of Wi-Fi-enabled services customers are asking for,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “The Oracle Communications Mobile Security Gateway makes sure they can leverage this opportunity, and do so securely.”

To learn more about this solution, visit Oracle in Hall 3, Stand 3B20 at Mobile World Congress in Barcelona, February 22 – 25, 2016.

Contact Info Greg Lunsford
Oracle
+1.650.506.6523
greg.lunsford@oracle.com Lisa Fisher
O’Keeffe & Company
+1.703.883.9000 x156
lfisher@okco.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 CommunicationsData Sheet Talk to a Press Contact

Greg Lunsford

  • +1.650.506.6523

Lisa Fisher

  • +1.703.883.9000 x156

Follow Oracle Corporate

Categories: Database, Vendor

Getting Started with JSON Support in SQL Server 2016 – Part 2

Database Journal News - Mon, 02/22/2016 - 09:01

Arshad Ali discusses the native support of JSON in SQL server 2016 and provides a step-by-step guide to start parsing and using JSON content in SQL Server 2016.

Categories: Database