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

New Cloud-based Banking Solution Targets Default Debtors, Improves Customer Experiences

Oracle Database News - 15 hours 5 min ago
Press Release New Cloud-based Banking Solution Targets Default Debtors, Improves Customer Experiences

Redwood Shores, Calif.—Jun 28, 2016

Financial institutions looking to recoup delinquent accounts while maintaining a positive association with their brands have a powerful new tool: Oracle Banking Collections. The cloud-enabled solution announced today provides lenders a more comprehensive look at debtors’ total financial pictures and features so they can more easily repay their loans.

While credit card and mortgage delinquencies are currently stable, there is a significant rise in student and auto loan defaults. In fact, Fitch Ratings stated that the 60-plus day delinquency rate for subprime car loans climbed to 5.16% in February of this year, the highest level in nearly two decades. The collections process is complex, inefficient riddled with fraudulent activity.

"With today’s choices and technology available, consumers demand solutions that put them at the center and in control of their options. It is a unique situation to apply a customer first mindset when it comes to handling delinquent accounts, but if done correctly, the benefits of such an offering should help to lead to improved contract rates and be a real help to delinquent borrowers,” said Marc DeCastro, Research Director, Consumer Banking at IDC.

“The Federal Reserve reported that as of March 31, 2016, total household debt in North America alone was $12.25 trillion. Oracle Banking Collections provides financial institutions a single system for comprehensive collection activity across all products related to a delinquent account. The collections process is designed for the digital world with efficient workflows, improved decision making and intuitive customer centric capabilities that empower the consumer with self-service remediation,” said Chet Kamat, senior vice president Banking Products for Oracle Financial Services. “Financial Institutions can choose to deploy the solution on the Oracle Cloud or on premise.”

Each year financial institutions waste millions of dollars attempting to solve their debt collection problem with the age-old tactic of throwing 3rd party debt collection agents who may use decades-old technology riddled with inaccurate borrower data, at the problem. The actions by collection agents, who know nothing about the customer or customer's relation with the financial institution, can border on harassment with phone calls at all hours, dunning letters and the threat of lawsuits. The new Oracle Banking Collections offering is helping financial institutions and their collections agencies improve collections on delinquent accounts by offering three unique and powerful capabilities:

1. Detailed insights into a borrower’s entire relationship with the financial institution, enabling collections agents to know more about who they are communicating with and how best to have a meaningful conversation about remediating the account.

2. A single system of record for all collections activity, helping to support compliance with strict collections regulations including those set forth by the Consumer Financial Protection Bureau.

3. Unique self-help features that enable the consumer to proactively determine a remediation plan for their account and avoid the collections process altogether.

  • The unique features of the Oracle Banking Collections can be found here.

Contact Info Valerie Beaudett
Oracle Corporate Communications
+1.650.400.7833
valerie.beaudett@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

Valerie Beaudett

  • +1.650.400.7833

Follow Oracle Corporate

Categories: Database, Vendor

BT and Oracle Collaborate to Make It Easier for Global Organizations to Move to the Cloud

Oracle Database News - 18 hours 4 min ago
Press Release BT and Oracle Collaborate to Make It Easier for Global Organizations to Move to the Cloud BT becomes the first global network services provider to offer direct access to the Oracle Cloud

Redwood Shores, Calif.—Jun 28, 2016

BT and Oracle today announced that they are working together to help organizations across the world take advantage of performance, cost and innovation benefits of the cloud. Oracle customers will be able to leverage the high performance, reliability, and security features of the BT Cloud Connect environment to gain direct connectivity to the Oracle Cloud.

While organizations understand the promise and many benefits of the cloud, many are concerned about security and performance issues associated with cloud technologies. This is especially true for business-critical enterprise workloads that frequently demand high levels of availability, security and performance. Together, BT and Oracle are aiming to remove those barriers to cloud adoption by providing options for connectivity from hybrid enterprise data centers to the Oracle Cloud. 

“Cloud is the fastest growing part of Oracle’s business,” said Thomas Kurian, president of Product Development, Oracle. “This partnership will help our customers leveraging the Oracle Cloud execute on their business strategies by taking advantage of the breadth and depth of BT’s global network and its Cloud Connect offering for their high bandwidth connectivity needs.”

With BT Cloud Connect for Oracle FastConnect, customers can use a private connection based on BT’s IP Connect VPN service, which is designed to predictably, securely and consistently exchange large volumes of data between the Oracle Cloud and their own on-premises environment. BT will connect directly to Oracle’s Cloud locations in Amsterdam and London, giving customers access from anywhere in the world to services provided in European data centers. Through pre-provisioning via BT Cloud Connect, BT can cut the typical dedicated connection deployment time from months to days.

Luis Alvarez, CEO Global Services, BT, said: “Direct and reliable access to data and applications hosted in cloud environments has become critical to organizations as they embark on their digital transformation journeys. We are accelerating our drive to be the world’s leading cloud services integrator and I am proud that BT is becoming the first global network services provider to offer direct access to the Oracle Cloud.”

The Oracle Cloud is used by many of the world’s largest organizations. It supports 70 million users and more than 34 billion transactions each day and runs in 19 data centers around the world. With the Oracle Cloud, customers can take advantage of the broadest and most integrated public cloud portfolio across all layers of the IT stack, while also having the choice to bring the Oracle Cloud into their own data centers via the recently announced “Oracle Cloud at Customer” offering. Oracle FastConnect is part of Oracle IaaS, and intended to enable organizations to quickly meet IT and business goals by leveraging a set of core capabilities such as elastic computing, networking and storage.

This news builds on BT’s Cloud of Clouds portfolio strategy by allowing its multinational customers to connect to the cloud through a centrally managed high-speed network with highly predictable performance, reliability and embedded security features.

BT and Oracle aim to offer the service in the final quarter of calendar year 2016.

Contact Info Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com About BT

BT’s purpose is to use the power of communications to make a better world. It is one of the world’s leading providers of communications services and solutions, serving customers in 180 countries. Its principal activities include the provision of networked IT services globally; local, national and international telecommunications services to its customers for use at home, at work and on the move; broadband, TV and internet products and services; and converged fixed-mobile products and services. BT consists of six customer-facing lines of business: Global Services, Business and Public Sector, Consumer, EE, Wholesale and Ventures, and Openreach.

For the year ended 31 March 2016, BT Group’s reported revenue was £19,042m with reported profit before taxation of £3,029m.

British Telecommunications plc (BT) is a wholly-owned subsidiary of BT Group plc and encompasses virtually all businesses and assets of the BT Group. BT Group plc is listed on stock exchanges in London and New York.

For more information, visit www.btplc.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

Nicole Maloney

  • +1.650.506.0806

Follow Oracle Corporate

Categories: Database, Vendor

Microsoft SQL Server Tooling team hosts Ask Me Anything session

This post was authored by Vin Yu, Program Manager, Data Platform.

The Microsoft SQL Server Tooling team will host a special Ask Me Anything session on /r/SQLServer, Thursday, June 30th, 2016 from 10:00 am to 3:00 pm PDT.

What’s an AMA session?

We’ll have folks from across the Microsoft SQL Server Tooling engineering team available to answer any questions you have. You can ask us anything about SQL Server tooling or even our team!

Why are you doing an AMA?

We like reaching out and learning from our customers and the community. We want to know how you use SQL Server tools and how your experience has been. Your questions provide insights into how we can make developing and managing SQL Server better. If this AMA session turns out to be useful, we may start doing this on a regular schedule.

Who will be there?

You, of course! We’ll also have PMs and Developers from the SQL Server Tooling engineering team participating throughout the day. Have any questions about the following topics? Bring them to the AMA.

  • Database Tools for Microsoft SQL Server, Azure SQL Database, Azure Virtual Machines with SQL Server
  • SQL Server Management Studio (SSMS)
  • SQL Server Data Tools / Visual Studio (SSDT)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Migration Assistant (SSMA)
  • PowerShell with SQLPS/Command Line Tools
  • Azure Portal for Azure SQL DB, Azure Elastic Database Pools or Azure Virtual Machines with SQL Server
Why should I ask questions here instead of StackOverflow, MSDN or Twitter? Can I really ask anything?

An AMA is a great place to ask us anything. StackOverflow and MSDN have restrictions on which questions can be asked while Twitter only allows 140 characters. With an AMA, you’ll get answers directly from the team and have a conversation with the people who build these products and services.

Here are some question ideas:

  • What’s new in SQL Server Reporting Services?
  • How do I provide feedback for SSMS and SSDT?
  • What tools would I use to migrate my database to SQL Server?
  • What’s a cool trick you don’t think most customers know about?

Go ahead, ask us anything about our public products or the team. Please note, we cannot comment on unreleased features and future plans.

Join us! We’re looking forward to having a conversation with you!
Categories: Database

Oracle’s REMAINDER Function: The Result Isn’t Always Correct

Database Journal News - Mon, 06/27/2016 - 08:01

Oracle’s REMAINDER function can return negative results; read on to see why and what can be done to work around the issue.

Categories: Database

Powering mission-critical performance with SQL Server 2016

Data has become the lifeblood of the enterprise. It’s the foundation for keen insight and effective decisions that lead to business growth. One of our primary design goals for SQL Server 2016 was to provide the performance, security, availability and business intelligence that are critical to helping companies manage their data and identify new opportunities.

Over the next three weeks, we’ll give you a few snapshots of some key features in SQL Server 2016 and how you can use them to drive sustained mission critical performance, get deeper insights from your data and benefit from hyperscale cloud capabilities.

Run queries up to 100 times faster

With SQL Server 2016 we enhanced the In-Memory columnstore capabilities, which accelerate highly concurrent workloads by transferring data to memory-optimized tables. With these enhancements in place, you can run queries up to 100 times faster than previously possible.

In addition, we made memory-optimized tables more scalable—able to store up to 2 TB of data each, and support bigger workloads.

To get started, evaluate your workloads using a new feature in SQL Server Management Studio (SSMS), the ability to generate migration checklists

To do this, right-click a database in Object Explorer, point to Tasks, and then select Generate In-Memory OLTP Migration Checklists. This step launches a wizard that displays a welcome page. On the second page of the wizard, specify a location in which to save the checklist and whether to generate a checklist for all tables and stored procedures in the database or for a specific list that you define. After you make this selection, the next page of the wizard includes a Script PowerShell Commands button and a Finish button. If you select the Script PowerShell Commands button, a text file opens to display the following command:


Save-SqlMigrationReport -Server ‘<Server Instance Name>’ -Database ‘AdventureWorks’ -FolderPath ‘C:\Users\<User>\Documents\<Path>’

When you click the Finish button, the wizard begins to generate a separate checklist for each table and stored procedure specified in the wizard. The status of each checklist is displayed in the table so that you can easily see whether any failed. After the wizard completes the checklists, you can find them as HTML files in the Stored Procedures, Tables, or User Defined Functions folders in the output path that you configured in the wizard.

Real-time, operational analytics

SQL Server 2016 also includes options for real-time analysis of datasets that are more dynamic in nature. With added support for columnstore indexes in memory-optimized transactional tables, you can avoid issues around latency and benefit from real-time analytics capabilities that live up to the name.

Batch execution mode has also been improved so results can be processed up to 1,000 rows at a time, greatly reducing execution time and the utilization of CPU resources. Use SSMS to get started, or add a clustered columnstore index to a disk-based table using a T-SQL statement such as the sample below.

T-SQL script sample

Better security built in

SQL Server 2016 comes with a number of new security features built-in, helping lock down your data at all levels and states:

  • Always Encrypted protects data at rest and in motion by requiring the use of an Always Encrypted driver when client applications to communicate with the database and transfer data in an encrypted state. Without the encryption key, which is kept at the client side rather than in SQL Server, the data is useless.
  • Row-Level Security enables you to protect the data in a table row-by-row, so a particular user can only see the rows to which they are granted access.
  • Dynamic data masking obfuscates a portion of the data to anyone unauthorized to view it. Use one of four functions to protect the data returned by a query:
    • Default: Fully masks string data, numeric and binary values, date and time
    • Email: Partially masks email addresses and the length of an email
    • Partial: Partially masks values using a custom definition
    • Random: Fully masks numeric values with a random value, specified by you

Configuring a table for Always Encrypted can be done using SSMS or with T-SQL, which involves a two-step process:

  1. Create the column master key definition.
  2. Create the column encryption key.

A bit like the outer defenses of a castle, the column master key protects the various column encryption keys that actually encrypt the data within a table. You can create a master key with SSMS, though T-SQL offers a more repeatable process, which starts with a CREATE COLUMN MASTER KEY statement, such as the example shown below.

Example 2.1

Database engine upgrades

Under the hood of SQL Server 2016 are a number of improvements to the data engine that are designed to help companies optimize day-to-day performance, while providing a scalable, efficient solution to manage data growth.

For example, rather than only creating one data file to support TempDB, where the essential, secondary work takes place to maintain peak performance of the data engine, the SQL Server 2016 setup wizard adapts to your server environment. It automatically assigns the number of data files (with a maximum of eight), based on how many processors it detects on your server, thus minimizing the likelihood of any lag in performance.

TempDB dialog box

Driving down costs with hybrid

The cost and logistical challenges of storing and managing data has many companies looking to the cloud as a viable option. With SQL Server 2016 we introduced Stretch Database, a hybrid cloud feature that combines the power of Azure SQL Database with the feasibility and familiarity of an on premises version of SQL Server. You get all of the enterprise-grade security and data management features, along with a virtually inexhaustible amount of storage on the back end for cost-effective historic data availability, and it works with both Always Encrypted and Row Level Security.

Stretch DB diagram

When you enable Stretch Database, a new Stretch Database is created in Azure, as well as an external data source in your instance of SQL Server and a remote endpoint for the database. You can rest assured that user queries cannot be issued against the remote database, and the Stretch Database is protected by several security measures, including encryption and certificate validation.

You can also monitor Stretch Database from a dashboard in SSMS, making it easier to manage the entirety of your data, ensuring that is secure and accessible.

Summary

The ability to harness and analyze data has become essential to the success of today’s enterprise. SQL Server 2016 gives you all of the tools you need to manage your company’s data and offers a secure, scalable platform to help power the next generation of business apps. Download the SQL Server 2016 e-book to learn more, or visit the SQL Server 2016 product page.

Categories: Database

PostgreSQL 9.6 Beta 2 Released

PostgreSQL News - Thu, 06/23/2016 - 01:00

The PostgreSQL Global Development Group announces today that the second beta release of PostgreSQL 9.6 is available for download. This release contains previews of all of the features which will be available in the final release of version 9.6, including fixes to many of the issues found in the first beta. Users are encouraged to begin testing their applications against 9.6 beta 2.

Changes Since Beta1

Our users and contributors reported bugs against 9.6 beta 1, and some of them have been fixed in this release. This includes multiple fixes for failure and performance issues in parallel query. We urge our community to re-test to ensure that these bugs are actually fixed, including:

  • update most contrib extensions for parallel query
  • two fixes for pg_trgm (trigram) bugs
  • rewrite code to estimate join sizes for better performance
  • correct handling of argument and result datatypes for partial aggregation
  • fix lazy_scan_heap so that it won't mark pages all-frozen too soon
  • mark additional functions as parallel-unsafe
  • check PlaceHolderVars before pushing down a join in postgres_fdw
  • improve the situation for parallel query versus temp relations
  • don't generate parallel paths for rels with parallel-restricted outputs
  • make psql_crosstab plans more stable
  • finish loose ends for SQL ACCESS METHOD objects, including pg_dump
  • stop the executor if no more tuples can be sent from worker to leader
  • several pg_upgrade fixes to support new features
  • fix regression tests for phrase search
  • add new snapshot fields to serialize/deserialize functions
  • measure Bloom index signature-length reloption in bits, not words
  • many improvements to parallel regression tests
  • many documentation updates and clarifications
  • multiple translation updates for the docs

Additionally, we've made some user-visible changes to parameters and functions. These may cause dump/restore between beta 1 and beta 2 to generate errors. This includes:

  • rename max_parallel_degree to max_parallel_workers_per_gather
  • add integrity-checking functions to pg_visibility
  • add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies
  • add pg_truncate_visibility_map function
  • add min_parallel_relation_size GUC
  • change default of backend_flush_after GUC to 0 (disabled)

Note that some known issues remain unfixed. Before reporting a bug in the beta, please check the Open Items page.

Beta Schedule

This is the second beta release of version 9.6. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2016. For further information please see the Beta Testing page.

Links
Categories: Database, Open Source

Oracle Delivers the Power of Engineered Systems to Organizations of All Sizes

Oracle Database News - Tue, 06/21/2016 - 12:41
Press Release Oracle Delivers the Power of Engineered Systems to Organizations of All Sizes Oracle’s expanded portfolio of database appliances are now available for enterprise and midmarket organizations, and provide customers with a pathway to the cloud

Redwood Shores, Calif.—Jun 21, 2016

Today, Oracle announced two new models of its Oracle Database Appliance (ODA) bringing all of the performance and reliability of Oracle's Engineered Systems to small and mid-sized businesses for the first time.

In addition, as organizations seek opportunities to transition to the cloud, Oracle’s new database appliances provide a bridge between on-premise systems and the cloud. In the future, organizations that plan to connect their ODAs to the Oracle Cloud can seamlessly back up their data automatically.

"Bringing in Oracle Database Appliances definitely reduced the complexity of our environment and allowed us to support our 25X data growth over the past few years," said Jacqueline Hufford-Jenson, Senior Manager, Database Administration, LifeLock, a fast-growing, mid-market company.  "Today, using the Oracle Database Appliance straight out of the box, we get significantly reduced latency, which has played a role in helping us grow as a company.”

Oracle’s portfolio of database appliances, like all Oracle Engineered Systems, enables organizations to simplify their journey to the cloud. Customers can backup or archive their critical data, and easily move their workloads to the Oracle Cloud whenever needed. Central to these new versions of the ODA is support for the Oracle Database Standard Edition 2 and Oracle Database Enterprise Edition.

“We’re excited to bring the power, simplicity and capabilities of Oracle’s Engineered Systems in at a price point that allows every organization to save time and money,” said Jim Gargan, senior vice president of Oracle Converged Infrastructure. “With the family of database appliances, Oracle offers built-in expertise for single-instance database and high-availability deployments, while providing a bridge between on-premise systems and the cloud, enabling all of our customers to capitalize on their investment.”

The Oracle Database Appliance is designed to run single-instance databases, database consolidation of multiple databases, and high-availability designs.

Added features include:

  • Starting price of $18,000 for new, entry-level database appliance for single or small database instances;
  • Reducing time to value, customers can deploy in as little as 30 minutes;
  • NVMe Flash drives for ultimate performance and reliability;
  • Integration to Oracle Cloud, allowing businesses to backup and archive their critical data as well as migrate workloads to the cloud when ready.

“Since Oracle owns the entire stack, its systems are fully hardware-software integrated, pre-tested, and optimized from silicon to applications. They are quickly deployed, extend smoothly to Oracle’s cloud, and the various systems seem to work well together. The latest family members, Oracle Database Appliance X6-2S and X6-2M, should help small and medium-sized businesses put a fully operational entry-level Oracle database in place—apparently no screwdrivers required,” said Peter Rutten, Analyst, IDC Computing Platforms Group.

Contact Info Katie Barron
Oracle
+1 202-904-1138
katie.barron@oracle.com Brian Lake
Burson-Marsteller
+1 415.591.4084
Brian.lake@bm.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

Katie Barron

  • +1 202-904-1138

Brian Lake

  • +1 415.591.4084

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Announces Pfizer’s Selection of Oracle Cloud for Clinical Data Management and Trial Management across its Clinical Trial Portfolio

Oracle Database News - Mon, 06/20/2016 - 13:00
Press Release Oracle Announces Pfizer’s Selection of Oracle Cloud for Clinical Data Management and Trial Management across its Clinical Trial Portfolio

Redwood Shores, Calif.—Jun 20, 2016

Oracle today announced that after a detailed review and selection process, Pfizer has selected Oracle Health Sciences InForm Cloud Service and the Oracle Siebel Clinical Trial Management and Monitoring Cloud Service to help manage and monitor its more than 300 clinical trials a year and continue to provide best-in-class solutions.   “Oracle Health Sciences InForm Cloud Service and Oracle Siebel Clinical Trial Management and Monitoring Cloud Service can simplify how we manage both operational and study data for in-house as well as outsourced studies,” said Rob Goodwin, vice president of Pfizer Global Product Development, Center of Excellence. “Clinical teams will be able to access study data through Oracle’s single platform cloud service, eliminating the need to send data back and forth to CROs, saving us time and reducing the cost of our clinical studies.”   By using Oracle Health Sciences InForm Cloud Service, Pfizer will be able to take advantage of over 100,000 investigator sites already trained in InForm, while increasing site data satisfaction.   The Oracle Health Sciences InForm Cloud Service will enable Pfizer to have greater control over its data and provide measurable efficiency and productivity gains in data management and remote monitoring. In addition, study templates and library management capabilities within Oracle Health Sciences InForm will enable Pfizer to accelerate the study-build process and result in faster trial implementation.   “Today, pharma companies are challenged by increasingly complex global clinical trials,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences. “With more than 15 years of electronic data capture experience in the clinical industry, Oracle Health Sciences helps leading pharmas — such as Pfizer — not only to standardize and optimize their clinical study processes, but also to be prepared with value-based clinical innovation solutions that enable them for the future of data collection.”   Oracle Health Sciences InForm Cloud Service includes both Oracle Health Sciences InForm and Oracle Health Sciences Data Management Workbench (DMW) to advance standardized end-to-end clinical data collection and management processes that help drive greater efficiencies for both internal and outsourced trials. Utilizing the platform, efficiencies can be gained through the seamless integration of Oracle Health Sciences InForm, Oracle Health Sciences Central Designer, and Oracle Health Sciences Data Management Workbench, enabling data standardization, streamlining collection, consolidation, cleaning, and transformation.   Pfizer will also use Oracle Siebel Clinical Trial Management and Monitoring Cloud Service, including Oracle Siebel Clinical Trial Management System, Oracle Health Sciences Clinical Development Analytics, and risk-based monitoring (RBM) functionality to provide new insights into trial management and help increase efficiency of the monitoring workforce. A single set of tools for internal and outsourced trials can simplify data exchange and the interface between investigator sites, CRO partners, and Pfizer. With the selection of Oracle’s platform and RBM solution, Pfizer will be able to execute risk-based monitoring through an integrated approach.   The Oracle Siebel Clinical Trial Management and Monitoring Cloud Service, which utilizes Oracle Siebel Clinical Trial Management System and Oracle Health Sciences Clinical Development Analytics, is a solution that combines standardized comprehensive clinical trial capabilities, integrated analytic tools, and data security with a cloud service that enables organizations to manage clinical trials effectively and economically, as well as improve CRO and sponsor relationships from early to late stage clinical trials. Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@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

Samantha Thai

  • +1.510.917.5564

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Gives Partners a Fast Path to Cloud

Oracle Database News - Mon, 06/20/2016 - 13:00
Press Release Oracle Gives Partners a Fast Path to Cloud Independent Software Vendors Gain New Revenue Opportunities through Oracle Cloud Marketplace

Redwood Shores, Calif.—Jun 20, 2016

The conversion to the cloud is one of the most significant IT transformations in history. IDC predicts that by 2018, at least half of IT spending will be cloud based. To help customers transition to the cloud with proven enterprise applications, while accelerating time-to-market for partners, Oracle PartnerNetwork (OPN) today unveiled Oracle Cloud Platform Ready for Independent Software Vendors (ISVs).

The new offering enables ISV partners to quickly register and publish their Oracle Cloud-compatible applications on the Oracle Cloud Marketplace, allowing them to fast-track new business opportunities in the cloud.  Partners can register here.

“Any new product we develop will go to the Oracle Cloud Marketplace first. We envision in the future that most of our customers will research, validate and request our solutions directly from the Oracle Cloud Marketplace,” said Charles Farnell, CEO, Ventureforth.

Oracle Cloud Platform Ready provides OPN members at Silver level or higher, a simple way to create an initial application listing on Oracle Cloud Marketplace in the Platform and Infrastructure sections in mere minutes. Any partner application that supports an Oracle Cloud compatible operating system or technology product can run on Oracle Cloud without the need for rewrite, and at no additional cost. To speed time-to-market, partners can quickly request access to Oracle Cloud Specialists and other technical resources directly from the Oracle Cloud Platform Ready registration. Additionally, ISVs with an Oracle Cloud Marketplace listing are eligible for the Oracle Cloud ISV Partner of the Year award and may apply for OPN Cloud Standard program benefits, including easy access to Oracle Cloud development and test environments.

“Oracle's Cloud Specialist team provided in-depth technical support during our proof of concept testing that allowed us to create automated deployment scenarios quickly and efficiently,” said Brent Rhymes, Executive Vice President Enterprise Sales & Marketing, Synacor/Zimbra. “Managed Service Providers can create new business opportunities by becoming a Zimbra Hosting Provider in the Oracle Cloud, while customers can deploy and manage their own collaboration solution within minutes. In each case, the flexibility of Zimbra plus the Oracle Cloud means users can start small and grow, or start big and get bigger.” 

In addition to quick access to Oracle Cloud Marketplace and development resources, partners engaging in the new offering will have the benefit of being able to reach Oracle’s expansive customer base, field sales, 25,000 global partners and 15 million developers through enhanced marketing and promotion efforts.

“The cloud represents a huge opportunity for our ISV partner community,” said Dan Miller, Senior Vice President of ISV, OEM and Java Sales, Oracle. “Through the Oracle Cloud Marketplace, and joint initiatives like Oracle Cloud Platform Ready, we are enabling ISV partners to focus more on their unique innovation, while leveraging the Oracle Cloud to get their solutions in front of a broad market of potential users quickly and at scale.”

Contact Info Candice van der Laan
Oracle
+1.650.506.0814
candice.van.der.laan@oracle.com About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) Specialized is the latest version of Oracle's partner program that provides partners with tools to better develop, sell and implement Oracle solutions. OPN Specialized offers resources to train and support specialized knowledge of Oracle’s products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to differentiate through Specializations. Specializations are achieved through competency development, business results, expertise and proven success. To find out more visit: http://www.oracle.com/partners.

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

Candice van der Laan

  • +1.650.506.0814

Follow Oracle Corporate

Categories: Database, Vendor

Oracle and Mellanox to Collaborate on High Speed Cloud Networking Standards

Oracle Database News - Mon, 06/20/2016 - 12:00
Press Release Oracle and Mellanox to Collaborate on High Speed Cloud Networking Standards Companies to Work on Open Standards, Interoperability, and Backward Compatibility for InfiniBand products

Frankfurt – ISC—Jun 20, 2016

Oracle and Mellanox today announced a partnership to drive interoperability between their products and to jointly develop further industry standards for InfiniBand—a high speed Cloud networking technology.

Products supporting the InfiniBand standard not only provide extreme bandwidth and ultra-low latency for fast, agile, and secure cloud infrastructure, but they are also based upon industry standards and available from multiple vendors. Oracle and Mellanox Enhanced Data Rate (EDR) 100G InfiniBand products are engineered to the InfiniBandTM Architecture Specification Release 1.3 and allow customers to deploy a 100Gb/s fabric that is backwards compatible with the previous generations of InfiniBand-based systems (FDR, QDR, DDR, and SDR), enabling customers to protect their investments in InfiniBand-enabled applications.

Oracle’s core strategy is to enable its cloud solutions and Engineered Systems with open technologies that deliver the highest performance, efficiency, and security. Due to its superior performance, efficiency, and scalability, InfiniBand is a dominant fabric for building Super Computers, which rapidly process massive amounts of data. Oracle has chosen InfiniBand as the foundational technology for Engineered Systems to provide unparalleled performance and scale to Oracle’s suite of business critical applications.

“Customers using InfiniBand as the interconnect for clouds and high performance computing can be certain that as new speeds and features are incorporated into the InfiniBand architecture that they will be able to continue to work with the supplier of their choice and that new products will seamlessly integrate with their existing InfiniBand infrastructures,” said Raju Penumatcha, senior vice president, Netra and Networking, Oracle. “This continued partnership represents an enduring commitment to provide customers with the technologies and standards needed for true enterprise-class cloud infrastructures that enable them to accelerate application performance and quickly respond to changing business needs.”

“With a standards-based architecture, and the most advanced roadmap that is guided by the InfiniBand Trade Association, and a mature, open source software stack, InfiniBand offers customers the best of performance and interoperability with the support of a large community of suppliers, developers, and users,” said Gilad Shainer, vice president, marketing at Mellanox Technologies. “This partnership enables us to continue to optimize and expand InfiniBand’s role as a key technology for any cloud environment.”

Oracle EDR InfiniBand Fabric is on display this week at: ISC High Performance (Booth 910). For more information, please visit: www.oracle.com/goto/InfiniBand.

Mellanox EDR InfiniBand solutions are on display this week at the International Supercomputing Conference (booth 905). For more information, please visit: www.mellanox.com.

Contact Info Sarah Fraser
Oracle
+1.650.743.0660
sarah.fraser@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.

About Mellanox

Mellanox Technologies is a leading supplier of end-to-end InfiniBand and Ethernet interconnect solutions and services for servers and storage. Mellanox interconnect solutions increase data center efficiency by providing the highest throughput and lowest latency, delivering data faster to applications and unlocking system performance capability. Mellanox offers a choice of fast interconnect products: adapters, switches, software, cables and silicon that accelerate application runtime and maximize business results for a wide range of markets including high-performance computing, enterprise data centers, Web 2.0, cloud, storage, telecom and financial services. More information is available at: http://www.mellanox.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

Sarah Fraser

  • +1.650.743.0660

Follow Oracle Corporate

Categories: Database, Vendor

Getting started with Query Store feature in SQL Server 2016 – Part 2

Database Journal News - Mon, 06/20/2016 - 08:01

Query Store is a new feature in SQL Server 2016 which, once enabled, automatically captures a history of queries, execution plans, and runtime statistics, retaining them for your troubleshooting performance problems caused by query plan changes. This new feature greatly simplifies performance troubleshooting by helping you quickly find performance differences, even after server restart or upgrade. Read on to learn more.

Categories: Database

Announcement: Amazon RDS for PostgreSQL now supports cross-region read replicas

PostgreSQL News - Fri, 06/17/2016 - 01:00

You can now quickly create cross-region read replicas for your unencrypted Amazon RDS for PostgreSQL database instances with just a few clicks on the AWS Management Console. You can use this feature to reduce read latency for your customers in different geographic locations, to create a backup of your primary database for disaster recovery purposes, or quickly migrate your database to a different AWS Region.

Disaster Recovery: You can create cross-region read replicas of your primary database instance to have a disaster recovery solution. If your primary region faces a disruption, you can promote the replica to a master and keep your business operational.

Scaling: You can use cross-region read replicas to support read queries from your workloads across various geographic locations. This will reduce latency by serving your customers from a database that is close to them.

Cross-region Migration: If you would like to migrate your database instance quickly to another AWS region, you may do so by using cross-region replication. Simply create a replica in your target region, and once it is ready, promote it to master and point your application to it.

This feature is available for all RDS PostgreSQL databases that are version 9.5.2 or 9.4.7 and higher. To create a cross-region replica of a database instance operating on an older version, you can upgrade to a supported version by performing a database version upgrade. To learn more about cross-region replication for RDS PostgreSQL, please refer to the RDS documentation.

Categories: Database, Open Source

Q4 FY16 SAAS AND PAAS REVENUES WERE UP 66%, AND UP 68% IN CONSTANT CURRENCY

Oracle Database News - Thu, 06/16/2016 - 21:00
Press Release Q4 FY16 SAAS AND PAAS REVENUES WERE UP 66%, AND UP 68% IN CONSTANT CURRENCY Q1 FY17 SaaS and PaaS Revenues Expected to be Up 75% to 80%

Redwood Shores, Calif.—Jun 16, 2016

Oracle Corporation (NYSE: ORCL) today announced fiscal 2016 Q4 results. Total Q4 Revenues were $10.6 billion, down 1% in U.S. dollars and flat in constant currency. Cloud plus On-Premise Software Revenues were $8.4 billion, flat in U.S. dollars and up 2% in constant currency. Cloud software as a service (SaaS) and platform as a service (PaaS) revenues were $690 million, up 66% in U.S. dollars and up 68% in constant currency. Total Cloud revenues, including infrastructure as a service (IaaS), were $859 million, up 49% in U.S dollars and up 51% in constant currency. Operating Income was $4.0 billion, and Operating Margin was 37%. Non-GAAP Operating Income was $4.8 billion, and the non-GAAP Operating Margin was 45%. Net Income was $2.8 billion while non-GAAP Net Income was $3.4 billion. Earnings Per Share was $0.66, while non-GAAP Earnings Per Share was $0.81. Without the impact of the U.S. dollar strengthening compared to foreign currencies, Oracle’s reported GAAP Earnings Per Share would have been 2 cents higher and non-GAAP Earnings Per Share would have been 1 cent higher.

Short-term deferred revenues were $7.7 billion, up 6% in U.S. dollars and up 7% in constant currency compared with a year ago. Operating cash flow on a trailing twelve-month basis was $13.6 billion.

For fiscal 2016, Total Revenues were $37.0 billion, down 3% in U.S. dollars and up 2% in constant currency. Cloud plus On-Premise Software Revenues were $29.0 billion, down 2% in U.S. dollars and up 3% in constant currency. Cloud SaaS and PaaS revenues were $2.2 billion, up 49% in U.S. dollars and up 52% in constant currency. Total Cloud revenues, including IaaS, were $2.9 billion, up 36% in U.S dollars and up 40% in constant currency. Operating Income was $12.6 billion, and Operating Margin was 34%. Non-GAAP Operating Income was $15.8 billion and non-GAAP Operating Margin was 43%. Net Income was $8.9 billion while non-GAAP Net Income was $11.2 billion. Earnings Per Share was $2.07, while Non-GAAP Earnings Per Share was $2.61. Without the impact of the U.S. dollar strengthening compared to foreign currencies, Oracle’s reported GAAP and non-GAAP Earnings Per Share would have been 17 cents higher.

“Fourth quarter SaaS and PaaS revenue growth accelerated to 68% in constant currency, significantly higher than my guidance,” said Oracle CEO, Safra Catz. “SaaS and PaaS gross margins continued to improve throughout the year, exiting FY16 at 56%. Bookings in Q4 were also very strong enabling us to raise our guidance for Q1 SaaS and PaaS revenue growth, which we now expect to be between 75% and 80%.”

“We added more than 1,600 new SaaS customers and more than 2,000 new PaaS customers in Q4,” said Oracle CEO, Mark Hurd. “In Fusion ERP alone, we added more than 800 new cloud customers. Today, Oracle has nearly 2,600 Fusion ERP customers in the Oracle Public Cloud – that’s ten-times more cloud ERP customers than Workday.”

“We expect that the SaaS and PaaS hyper-growth we experienced in FY16 will continue on for the next few years,” said Oracle Executive Chairman and CTO, Larry Ellison. “That gives us a fighting chance to be the first cloud company to reach $10 billion in SaaS and PaaS revenue. We’re also very excited about the availability of version 2 of Oracle’s Infrastructure as a Service (IaaS)—which will enable us to speed up the growth of our IaaS business, which customers want to buy in conjunction with our SaaS and PaaS.”

The Board of Directors also declared a quarterly cash dividend of $0.15 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on July 6, 2016, with a payment date of July 27, 2016.

Q4 Fiscal 2016 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast of this event, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q4 results and fiscal 2016 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Pass Code: 28515799.

Contact Info Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com Deborah Hellinger
Oracle Corporate Communciations
+1.212.508.7935
deborah.hellinger@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 or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.

Trademarks

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

"Safe Harbor" Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding our future guidance, and expectations of future SaaS, PaaS and IaaS growth, are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (3) If the security measures for our software, hardware, services or Oracle Cloud offerings are compromised or if such offerings contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and financial exposure. (4) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) Economic, geopolitical and market conditions, including the continued slow economic recovery in the U.S. and other parts of the world, can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our SEC filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of June 16, 2016. Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Ken Bond

  • +1.650.607.0349

Deborah Hellinger

  • +1.212.508.7935

Follow Oracle Corporate

Categories: Database, Vendor

Is Your Database Healthy?

Database Journal News - Thu, 06/16/2016 - 08:01

Despite the sophistication of the latest DB2 software versions and the power of current IBM z/server technology, it is still possible for performance and data availability to deteriorate due to a variety of things, including increased dataset extents, loss of clustering, index page splits, and other factors. This article presents simple SQL statements that the database administrator (DBA) can execute against the DB2 catalog to determine if one or more application databases suffer from common maladies, and what the DBA can do to fix or mitigate potential problems.

Categories: Database

ORACLE AND SNAPCHAT MEASURE IMPACT OF SNAP ADS ON SALES IN STORES

Oracle Database News - Thu, 06/16/2016 - 00:38
Press Release ORACLE AND SNAPCHAT MEASURE IMPACT OF SNAP ADS ON SALES IN STORES New Measurement Research for Snapchat Advertisers Finds 92% of Ad Campaigns Saw Positive Offline Sales Increases

Redwood Shores Calif—Jun 15, 2016

Oracle and Snapchat today announced a partnership to measure the impact of digital advertising in the physical world. By teaming together, Oracle Data Cloud and Snapchat measure incremental store sales resulting from marketing campaigns run on Snapchat. By analyzing the impact of campaigns on in-store sales, Oracle Data Cloud will help consumer packaged goods (CPG) advertisers quantify and improve their ongoing marketing efforts on Snapchat.   Oracle Data Cloud also released new research analyzing the in-store sales lift from 12 CPG campaigns run on Snapchat for leading cosmetic, personal care, cleaning, packaged food, and beverage brands. Among the findings:   92 percent of the Snapchat ad campaigns drove a positive lift in in-store sales   Snapchat ad campaigns exceeded Oracle Data Cloud norms on all key metrics with sales lift being the primary driver.   “We are delighted to be working with one of the fastest-growing platforms in history to help Snapchat advertisers understand and improve the effectiveness of their campaigns,” said Eric Roza, Senior Vice President of the Oracle Data Cloud. “By combining offline sales data with cutting-edge analytics, we can help Snapchat advertisers maximize their return on investment and drive higher profits.”   “We’ve been listening closely to advertisers and delivering the data they need,” said Clement Xue, Global Head of Revenue Operations at Snapchat. “This research shows that Snapchat is more effective at driving sales for advertisers, and we’re delighted to offer this measurement solution going forward.”   Oracle Data Cloud is the largest global data-as-a-service solution, with access to more than $3 trillion dollars in consumer transaction data, 2 billion global consumer profiles, and 1,500+ data partners. Oracle Data Cloud integrates that data with more than 200 major media companies, including publisher exchanges, ad networks, DSPs, DMPs, and agency trading desks.   Contact Info Erik Kingham
Oracle
650-506-8298
erik.kingham@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. 

Get Started Oracle Data Cloud Talk to a Press Contact

Erik Kingham

  • 650-506-8298

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Joins the White House in Global Campaign to Empower Girls and Women

Oracle Database News - Tue, 06/14/2016 - 12:00
Press Release Oracle Joins the White House in Global Campaign to Empower Girls and Women Pledges $3 Million to Educate Girls in Science, Technology, Engineering and Math

Redwood Shores, Calif.—Jun 14, 2016

embedBrightcove('responsive', false, 'single', '4939491263001');

President Obama endorses Oracle’s work in advancing computer science and STEM education globally.

On the heels of Oracle’s $200 million commitment to support Computer Science (CS) Education for All, today the White House announced Oracle’s additional $3 million investment to immerse girls worldwide in science, technology, engineering and math (STEM). The company’s commitment of direct and in-kind funding supports “Let Girls Learn,” a U.S. government initiative aimed at helping adolescent girls around the world go to school and stay in school.

“It takes 25 years to build a computer engineer, not 25 hours, so we need to get started,” said Safra Catz, Oracle CEO. “The computer sciences lose too many girls too early and once lost, it’s nearly impossible to get them back. We want more girls focused on building upon science and math fundamentals and we want more women choosing the technical disciplines because they are both prepared to do so and because they believe it will advance their career opportunities.”

Oracle will offer more than 65 educational events and reach over 55,000 young girls globally through a powerful nexus of its corporate social responsibility programs spanning Oracle Academy, Oracle Education Foundation, Oracle Giving and Volunteers, Oracle Women’s Leadership (OWL), and Oracle Diversity and Inclusion. Events will include summer computing camps, codefests, workshops and conferences designed to encourage and inspire adolescent girls to become original thinkers, creative designers and enterprising trailblazers.

Additionally, Oracle plans to expand its CS efforts in Egypt with an additional investment of nearly $1 million in educational resources and services over the next four years. The commitment is part of a new collaboration between the Ministry of Education in Egypt, the United States Agency for International Development (USAID) and Oracle Academy, Oracle’s philanthropic educational program that impacts more than 2.6 million students in 106 countries. The partnership will support computing education in nine newly-created STEM schools throughout the country, including one boarding school exclusively for girls which will accept up the top 10 percent of girls across the governorates, reaching 150 girls each year and providing three years of paid education for each girl.

As part of the company’s global campaign to support girls and women in technology, Oracle will drive several notable projects:

  • Oracle Academy will team with Arizona State University and others under the USAID Build-IT project to help women in Vietnam develop into IT leaders. President Obama recently endorsed Oracle’s contribution in furthering this effort.
  • Oracle Education Foundation and Oracle Volunteers will team to teach girls coding, electrical engineering and project management through girls-only workshops for Design Tech High School (d.tech), an innovative, free California public high school. Oracle is building d.tech’s new facility at its headquarters in Redwood Shores, Calif., making d.tech the world’s first public high school on a technology campus.
  • Oracle Giving and Oracle Academy will award grants and sponsorships globally to nonprofit organizations striving to increase girls’ access to educational opportunities and encourage them to pursue degrees in computer science and STEM fields.
  • Oracle Giving will continue its support for MentorNet, which engages STEM professionals in the virtual mentoring of undergraduates, 66% of whom are women.
  Contact Info Julie Sugishita
Oracle Corporate Communications
1.650.506.0076
julie.sugishita@oracle.com About Oracle Academy

As Oracle’s flagship philanthropic educational program, Oracle Academy advances computer science education globally to drive knowledge, innovation, skills development, and diversity in technology fields. To this end, Oracle Academy offers students and educational institutions a free and complete portfolio of software, curriculum, hosted technology, faculty trainings, support, and certification resources. The program works with public and private partners to provide the tools educators need to engage, inspire and prepare students to become innovators and leaders of the future. Through Oracle Academy, students receive hands-on experience with the latest technologies, helping make them college and career ready in the era of big data, cloud computing, the Internet of Things, and beyond.

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

Julie Sugishita

  • 1.650.506.0076

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Cloud Helps Utilities Make Better, Faster Business Decisions

Oracle Database News - Tue, 06/14/2016 - 08:05
Press Release Oracle Cloud Helps Utilities Make Better, Faster Business Decisions New analytics capabilities enable better data collection and analysis to improve business insights

EEI Annual Convention - Chicago, IL—Jun 14, 2016

The utility industry is in the midst of a significant transformation, and the increasing prevalence of digital technologies is driving organizations to embrace innovation. Capturing and analyzing data across infrastructures now play a crucial role in addressing changes and challenges. Today, Oracle Utilities announced new releases of two of its cutting edge analytics solutions, which enable utilities to better access, organize and analyze the massive amount of data they collect while saving time and reducing IT and maintenance costs.   Oracle Utilities Analytics Cloud Service helps utilities easily integrate their on-premise customer, meter, device, and workforce data into a single platform in the cloud. The cloud solution’s flexibility and scalability enables utilities of all sizes to leverage powerful data analytics without the need for in-house analytics experts. The cloud “future-proofs” smart grid and analytics strategies—enabling utilities to leverage the latest analytics capabilities to remain at the forefront of industry innovation. This new cloud service further enhances Oracle Utilities’ cloud analytics suite, which includes Oracle DataRaker, an advanced analytics solution providing actionable insight and predictive analytics services for big data.   “As a leading systems integrator and Oracle PartnerNetwork member, we worked closely with the Oracle Utilities team on co-development activities for Oracle Utilities Analytics,” said John Gustafson, Vice President, Energy and Utilities at Cognizant.   “This solution can enable utilities around the world to leverage robust analytics capabilities and gain immediate access to valuable insight. Drawing on Cognizant’s extensive global experience and expertise in implementing Oracle Business Intelligence and working with Oracle Cloud, we are continuing to develop new implementation resources for Oracle Utilities Analytics Cloud Service for utilities worldwide.”   The new version of Oracle Utilities Work and Asset Management Analytics provides users with an extensive platform featuring pre-built analytics based on industry best practices to provide the most value to utilities for asset maintenance strategies. The upgraded solution offers:
  • • Four new dashboards with 26 pages of analytics to support 74 metrics related to work and asset management questions—enabling users to drill down even further into the data associated with these analytics.
  • • Hundreds of different report outputs based on organization hierarchy. Each report has the ability to provide answers to any level of the organization.
  “Utilities today collect massive amounts of data and they do not always have the means to analyze it and turn it into actionable business intelligence,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “Oracle Utilities Analytics Cloud Service and Oracle Utilities Work and Asset Management Analytics provide utilities with the ability to analyze their data more quickly, and in a more meaningful way.” Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@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

Samantha Thai

  • +1.510.917.5564

Follow Oracle Corporate

Categories: Database, Vendor

Oracle's Calibrate_io Procedure: Why You Should Use It

Database Journal News - Mon, 06/13/2016 - 08:01

Oracle's calibrate_io procedure populates the data dictionary with disk 'performance' data to give the optimizer a fighting chance at a decent plan.  Read on to see why the data it generates may not be the most accurate with respect to performance.

Categories: Database

Check out the SQL Server sessions we’ve planned for Microsoft Ignite

What do you want to learn at Microsoft Ignite 2016?

  • Do you want to learn how to accelerate SQL Server 2016 to the max?
  • Get practical techniques for database management?
  • Strengthen your defenses against hackers?
  • Discuss real-world questions with product experts, in person?
  • Challenge your strategic thinking?

Perfect. All of that—and more—is waiting for you in Atlanta. The full session catalog is now live, so all you have to do is start exploring which sessions you want to attend.

Here’s a sample of SQL Server topics you’ll find…

Accelerate SQL Server 2016 to the max: lessons learned from customer engagements

The SQLCAT team worked with several customers as part of the Microsoft SQL Server 2016 Preview Program. Hear about how those customers were able to target specific bottlenecks and overcome them to far exceed their performance and scalability targets with SQL Server 2016. Deriving from actual customer engagements, we detail the most common scenarios, “tools of the trade,” and most importantly the “secret sauce” used in those situations.

Make it real with Always Encrypted, Stretch Database and Temporal Tables

So you’ve heard you can keep as much data as you want indefinitely with minimal effort and cost. You’ve also discovered you can secure you data with strong cryptography at all times. You even learned about how to time travel with your data. So how exactly do you design, deploy and manage a database application that can do all that without an army of experts? Find out from the crew that built Always Encrypted, Stretch Database and Temporal Table so you can be that expert. We also share recommended practices, known limitations and workarounds. This session is not about flashy demos; it focuses on practical implementation details you can use when you get back.

Enable operational analytics in SQL Server 2016 and Azure SQL Database

See how Microsoft SQL Server 2016 enables you to run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Operational Analytics.

And that’s just a start…

With more than 440 sessions to choose from, which sessions will you attend?

> Explore SQL Server sessions <

Remember: September 26-30 is approaching fast. We’re excited to see everyone soon—and if you haven’t yet registered, don’t delay! Register for Microsoft Ignite.

Categories: Database

WideWorldImporters: The new SQL Server sample database

This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server.

A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade.

Wide World Importers is the new sample for SQL Server. It illustrates how the rich SQL Server feature set can be used in a realistic database. It does not attempt to use every single SQL Server feature, as that would not be realistic. It also showcases the key SQL Server 2016 capabilities and performance enhancements.

Latest release of the sample: wide-world-importers-release

Documentation for the sample: wide-world-importers-documentation

The sample is structured as follows:

  • WideWorldImporters is the main database for transaction processing (OLTP – OnLine Transaction Processing) and operational analytics (HTAP – Hybrid Transactional/Analytics Processing). Here are some examples of the use of SQL Server capabilities with this database:
  • WideWorldImportersDW is the main database for data warehousing and analytics (OLAP – OnLine Analytics Processing). The data in this database is derived from the transactional database WideWorldImporters, but it uses a schema that is specifically optimized for analytics. Here are some examples of the use of SQL Server capabilities with this database:
  • A SQL Server Integration Services (SSIS) package, Daily ETL.ispac, is used to move data from the OLTP database WideWorldImporters to the OLAP database WideWorldImportersDW. The package is designed to use bulk T-SQL statements wherever possible to enhance performance. For details about the ETL workflow, see the WideWorldImportersDW ETL workflow.

The sample also includes a number of scripts that can be used to explore some of the features used in the sample database. In addition, the sample includes two workload drivers, which are small applications that simulate a workload running against the database.

The databases contain sample sales and purchases data starting January 1st, 2013, until May 31st, 2016. The sample includes procedures to generate more sample data, so you can always bring the sample up to the current date. For details, see WideWorldImporters data generation.

The data size is limited to keep the download size reasonable. If you desire a sample database with a larger data size, use the source scripts to create a new sample database, and tweak the parameters in step 6 to increase the data size.

Get started

  1. Download and install a free trial of SQL Server 2016 or configure a test environment using an Azure SQL VM.
    • The Developer Edition is free if you sign up for the free Visual Studio Dev Essentials program.
  2. Download the sample and review the sample documentation.

Send any feedback on the sample to: sqlserversamples@microsoft.com.

Categories: Database