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

pgBadger 6.0 is out!

PostgreSQL News - Tue, 08/12/2014 - 01:00

DALIBO is proud to announce the release of pgBadger 6.0.

pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your PostgreSQL log files.

This new major release fixes several issues and adds some new features:

  • Automatic cleanup of binary files in incremental mode.
  • Automatic handling of retention with a maximum number of weeks to keep reports.
  • Incremental mode improvement by allowing the use of multiprocessing with multiple log file.
  • Now reports the query latency percentiles on the general activity table (percentiles are 90, 95, 99).
  • A new output format: JSON. This format is good for sharing data with other tools.
  • Using the --anonymize option pgBadger will anonymize all literal values in the queries.
  • Add a click-to-select button in front of each query that allow to just use Ctrl+C to copy it on clipboard.
  • Several space usage improvement in incremental mode, the -X option allow the use of external CSS and Javascript files.
  • A new pgBadger logo

 

Warning: the behavior of pgBadger in incremental mode has changed. It will now always cleanup the output directory of all the obsolete binary file. If you were using those files to build your own reports, you can prevent pgBadger to remove them by using the --noclean option. Note that if you use the retention feature, all those files in obsolete directories will be removed too.

For the complete list of changes, please checkout the release note on https://github.com/dalibo/pgbadger/blob/master/ChangeLog

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Herve Werner, Julien Rouhaud, Josh Berkus, CZAirwolf, Bruno Almeida, Marc Cousin, Thomas Reiss, Rodolphe Quiedeville, Himanchali, Guilhem Rambal, Shanzhang Lan, Xavier Millies-Lacroix, Kong Man, wmorancfi, flopma and birkosan.

pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly on our mailing list.

Links :

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and create HTML5 reports with dynamics graphs. pgBadger is the perfect tool to understand the behavior of your PostgreSQL servers and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.io/pgbadger/

About DALIBO :

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

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

Categories: Database, Open Source

MySQL Numeric Overflow Gotcha

Database Journal News - Mon, 08/11/2014 - 08:01

Rob Gravelle highlights a gotcha related to MySQL's overflow handling of numeric values that are outside the permissible range of the column data type.

Categories: Database

Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault

Oracle Database News - Thu, 08/07/2014 - 13:00
Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault New solution enables centralized management of Oracle Database encryption master keys, Oracle wallet files, Java KeyStores, and moreRedwood Shores, Calif. – August 7, 2014 News Summary

Encryption is widely recognized as the gold standard for protecting data privacy, but encryption is only as strong as its key management. Critical credential files such as Oracle wallet files, Java KeyStores, Secure Shell (SSH) key files, and Secure Sockets Layer (SSL) certificate files are often widely distributed across servers and server clusters that use error-prone synchronization and backup mechanisms. As organizations increasingly encrypt data at rest and on the network, securely managing all the encryption keys and credential files in the data center has become a major challenge.

At the same time, organizations also need to comply with stringent regulatory requirements for managing keys and certificates. Many global regulations and industry standards call for audits demonstrating that keys are routinely rotated, properly destroyed, and accessed solely by authorized entities.

To address the need for robust key management, Oracle today introduced Oracle Key Vault, a software appliance designed to securely manage encryption keys and credential files in the enterprise data center.

News Facts Oracle Key Vault, the latest addition to the Oracle Database security portfolio, provides secure, centralized management of encryption keys and credential files in the data center, including Oracle wallet files, Java KeyStores, Kerberos keytab files, SSH key files, and SSL certificate files. Optimized for the Oracle technology stack, including Oracle Database and Oracle Fusion Middleware, Oracle Key Vault can be deployed seamlessly in existing environments. Built for x86-64 hardware, the fully integrated software appliance uses Oracle Linux and Oracle Database technology for security, availability, and scalability. Oracle Key Vault is the industry’s most modern solution for managing keys and metadata. Features include the following: Easy archival and recovery. The new solution archives Oracle wallet files, Java KeyStores, and other credential files in a master repository, supporting fast, easy file sharing and recovery. Centralized management. Oracle Key Vault’s browser-based management console offers point-and-click administration, simplified server enrollment, and audit reports. Streamlined sharing. Organizations can securely share Oracle wallet files—standards-based encrypted files that securely store keys and related metadata used by components of the Oracle stack—across database clusters or disaster recovery environments. The product works seamlessly with Oracle Real Application Clusters, Oracle Active Data Guard, and Oracle GoldenGate. Flexibility. In Oracle Database environments using Oracle Advanced Security with Transparent Data Encryption (TDE), Oracle Key Vault manages TDE keys over a direct network connection as an alternative to a local Oracle wallet. Standards Compliance. Based on the OASIS Key Management Interoperability Protocol (KMIP), Oracle Key Vault can manage keys from KMIP-compliant clients.Supporting Quotes “Oracle Advanced Security with Transparent Data Encryption has played an important role in protecting the sensitive data stored in our Oracle databases. However as the need to encrypt data increases, both within the Oracle Database and beyond, encryption key management becomes a challenge,” said Brad Peiffer, director of IT data management services at Educational Testing Service. “We are looking forward to the new Oracle Key Vault solution that will allow us to centrally manage our Oracle wallet files, encryption keys, and certificates. Oracle Key Vault can simplify operations and help us improve our security posture and regulatory compliance.” “Encryption is no longer optional for managing enterprise data. It has become an essential element of end-to-end data protection,” said Carl Olofson, IDC research vice president, Application Development and Deployment. “As enterprises implement encryption in their middleware, database, and operating systems, key management becomes increasingly complex and difficult. Enterprises need a means of sensibly and securely managing those keys. Oracle has developed Oracle Key Vault to give customers the advantage of a standards-based solution, optimized for the Oracle technology stack, for centralized management of their encryption keys.” “As regulations worldwide increasingly call for more data to be encrypted, organizations need a centralized solution to securely manage all the encryption keys and credential files in their data centers,” said Vipin Samar, vice president, database security product development at Oracle. “Oracle Key Vault is a modern, standards-based product that allows organizations to reduce the overhead of regulatory compliance with a solution that protects Oracle Database encryption master keys, Oracle wallet files, Java KeyStores, and other credential files.” Supporting Resources Oracle Key Vault Oracle Database Security Register for the Oracle Key Vault live webcast on Thursday, August 21, at 10 a.m. PT. Join Oracle live events featuring “Introduction to Oracle Key Vault” in a city near you. Connect with Oracle Database via Blog, Facebook, and Twitter About Oracle

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

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

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

Neil Desai
Blanc & Otus
+1.415.856.5150
ndesai@blancandotus.com

Categories: Database, Vendor

Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault

Oracle Database News - Thu, 08/07/2014 - 13:00
Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault -- New solution enables centralized management of Oracle Database encryption master keys, Oracle wallet files, Java KeyStores, /us/corporate/press/2259810 en
Categories: Database, Vendor

Management of Windows Azure SQL Databases via PowerShell with REST APIs

Database Journal News - Thu, 08/07/2014 - 08:01

Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.

Categories: Database

Develop an iOS application with the InfoSphere Business Glossary REST API

IBM - DB2 and Informix Articles - Thu, 08/07/2014 - 05:00
InfoSphere Business Glossary enables you to create, manage, and share an enterprise vocabulary and classification system. InfoSphere Business Glossary includes a REST API that makes glossary content easier to consume by enabling the development of custom applications. In this article, step-by-step instructions show how to develop a dynamic iOS application using the InfoSphere Business Glossary REST API. The application lets users find business glossary assets, examine the asset's details, and contact the steward using the native phone and email applications on the iOS device. After building the sample application, you'll be on your way to using the REST API to create your own custom applications with InfoSphere Business Glossary.
Categories: Database

Gain confidence about data security in the cloud

IBM - DB2 and Informix Articles - Thu, 08/07/2014 - 05:00
This tutorial demystifies cloud security and arms you with the know-how to adopt the cloud with confidence. Learn how cloud security is a shared responsibility between the cloud service provider and the client. The responsibilities of each party are explored. Also walk through a data security use case involving IBM BLU Acceleration for the Cloud. When certain criteria are met, clients can achieve data security equal to or better than what they can achieve onsite.
Categories: Database

Automating SQL Server Agent Notification

Database Journal News - Mon, 08/04/2014 - 08:01

If you are a DBA you probably are responsible for running and monitoring all of the SQL Server Agent jobs on one or more SQL Server instances. Read on to learn some automated approaches of monitoring SQL Server agent jobs.

Categories: Database

Oracle-Sponsored Survey Finds Enterprises Expect to Boost Mobile-Related IT Expenses More than 50 Percent in Two Years, yet Security and Integration Remain Top Challenges

Oracle Database News - Thu, 07/31/2014 - 18:35
Oracle-Sponsored Survey Finds Enterprises Expect to Boost Mobile-Related IT Expenses More than 50 Percent in Two Years, yet Security and Integration Remain Top Challenges Survey Highlights Critical Technology Challenges and Business Opportunities as Enterprises Embrace Both Internal and External Mobile Strategic InitiativesRedwood Shores, Calif. – July 31, 2014News Summary

The rapid rise of mobile devices connected to enterprise systems is unmatched by any other technology in recent memory. Enterprises face dual pressures when it comes to mobility: They must serve internal stakeholders to increase productivity, while also serving external customers to increase engagement. As a result, they struggle to keep pace with the rapid rate of mobile application development, both for the client and server side. But even as mobile development has become entrenched in the enterprise, its goals and challenges continue to quickly evolve. A new global survey from CIO Strategic Marketing Services and Triangle Publishing Services, sponsored by Oracle, reveals that not only are enterprises committed to mobility today, but the rate of development, deployment and spending for support of mobile applications and devices will increase dramatically over the next few years. Additionally, the survey showed that there are increasing concerns from IT executives over mobile security and integration with back-end systems.

News Facts To better understand the challenges of mobile application development and deployment in the enterprise today and in the future, CIO Strategic Marketing Services and Triangle Publishing Services released a global survey, sponsored by Oracle, titled "The Connected Enterprise: Keeping Pace with Mobile Development.” Survey respondents included 414 IT management executives from around the world, including CIOs, CTOs, senior vice presidents or vice presidents; directors or managers of IT; and, senior IT professionals. The survey highlights the technological factors most critical to success and where mobility initiatives can provide the greatest business benefits, both now and in the future. Although the survey results showed a high commitment to mobility, they also showed little consensus about methods of mobile development and deployment, whether across industries or across geographies. The survey also revealed that the preferred method for mobile app development is now internal.Key Findings Security continues to be the top concern for enterprise wide adoption and embracing BYOD adds to this challenge. 93 percent of respondents cited concern over data loss and other security breaches related to mobile devices with BYOD being a key contributor to this concern. Organizations are turning more to centralized management rather than relying on users for security. In the next two years, respondents’ organizations will be focusing more on device data encryption (10 percent more than today), centralized updating and troubleshooting (11 percent more), remote wiping of data (11 percent more) and lockdown of features (18 percent more). The survey revealed that although 29 per cent of IT development time is spent on front-end mobile app development, more than 70 per cent of their time is spent on integration, security, quality assurance testing and design work. Mobile applications change continually. According to the survey, 35 percent of midsize and large enterprise organizations update their application portfolio monthly, while an additional 34 percent update their applications quarterly. More than four-fifths (82 percent) of respondents expect those rates to increase over the next two years. Average IT department spending per device, per employee stands at US $157 today. That is expected to grow to US $242 over the next two years, an increase of 54 percent. Respondents are focused more on external customers versus others by a significant margin: 34 percent, versus 27 percent for employees, 24 percent for executives and 15 percent for suppliers. This focus on external customers is expected to grow in the future. Respondents indicated that 44 percent of their application portfolio is internally developed. 75 percent of respondents said that cloud/hybrid cloud is “somewhat important” or “very important” to mobile application deployment. Cloud technologies include platform as a service and a cloud-based mobile enterprise application platform. 84 percent of respondents reported sales and marketing, as well as customers, as the two stakeholders with the most influence in mobile applications today. IT followed with 82 percent. Supporting Quote “Mobility has been ubiquitous for a while but only 10 percent* of enterprises have an enterprise wide deployment of mobile. Its impact and importance are gaining importance today. This survey is reassuring in that enterprises see potential for great payoff from making a strong mobile commitment. They are recognizing that mobile applications provide a new way to develop and maintain relationships with customers,” said Suhas Uliyar, Vice President, Mobile Strategy & Product Management, Oracle. “Oracle’s mobile solutions allow organizations to develop, connect and secure their own mobile applications. Our comprehensive mobile strategy simplifies enterprise mobility for any organization.”Supporting Resources  Survey: "The Connected Enterprise: Keeping Pace with Mobile Development” Oracle Mobile Register for upcoming Simplify Enterprise Mobility Event series Follow us on Twitter, Facebook, YouTube and Blog

*Source: CIO magazine

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit 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.

Contact Info

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

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

Categories: Database, Vendor

Oracle Solaris 11.2 Now Generally Available

Oracle Database News - Thu, 07/31/2014 - 17:00
Oracle Solaris 11.2 Now Generally AvailableComplete cloud platform allows enterprises to accelerate their move to cloudRedwood Shores, Calif. – July 31, 2014News Summary

Now generally available, Oracle Solaris 11.2 accelerates your ability to deploy enterprise cloud computing with an efficient, secure, compliant, open, and affordable cloud platform. Engineered for cloud and deeply integrated with Oracle Database, Java, and Oracle Applications, Oracle Solaris 11.2 is more than an operating system (OS). It combines a complete OpenStack distribution, application-driven software-defined networking (SDN), zero-overhead virtualization, enterprise-grade disaster recovery, and high availability with an enterprise-class OS to simplify and secure the delivery of mission-critical cloud services. Oracle Solaris is a strategic element in Oracle’s growing systems business.

Download Oracle Solaris 11.2 and Oracle Solaris Cluster 4.2.

News Facts

• Now available, Oracle Solaris 11.2 is engineered to deliver an efficient, secure, compliant, open and affordable path to enterprise cloud computing for organizations seeking to simplify and modernize their data centers.

• Oracle Solaris 11.2 is a complete, integrated and open cloud platform engineered for large-scale enterprise cloud environments. It combines OpenStack, application-driven SDN technology, clustering, and zero-overhead virtualization with a proven enterprise-class OS.

• With its application compatibility guarantee program, Oracle Solaris is designed to make IT’s transformation to enterprise-grade cloud simple, fast, and affordable.

• Customers can get a cloud up and running in as few as 10 minutes using Oracle Solaris 11.2’s Unified Archive template and OpenStack distribution.

• Oracle Solaris 11.2 can significantly reduce compliance overhead with built-in compliance reporting and simple resolution instructions.

• Oracle Solaris incorporates unique features for security and offers built-in virtualization that delivers massive scalability at low cost.

• Oracle Solaris 11.2 further extends virtualization flexibility with support for zones at differing kernel patch levels.

• Also available now, Oracle Solaris Cluster 4.2 is the best availability solution for protecting Oracle Solaris environments in enterprise data centers and mission-critical cloud deployments.

• Built on deep integration with Oracle Solaris 11.2’s extensive cloud, virtualization and enterprise provisioning capabilities, Oracle Solaris Cluster 4.2 enables fast, accurate, fully orchestrated multisite and multitier recovery from outages and disasters to help significantly reduce unplanned downtime and maximize service availability.

• Oracle Solaris Cluster 4.2 includes built-in high availability support for more than 30 common enterprise application suites, including new modules for Oracle’s JD Edwards Enterprise One; Oracle GoldenGate; and Oracle Multitenant, a new Oracle Database 12c option; and updated support for Oracle Business Intelligence Enterprise Edition.

Download Oracle Solaris 11.2 and Oracle Solaris Cluster 4.2.

Supporting Quotes “Today, Oracle delivered a complete solution for cloud with Oracle Solaris 11.2 along with the means to support business continuity for Oracle Solaris-based clouds with Oracle Solaris Cluster 4.2,” said Markus Flierl, vice president, Solaris, Oracle. “Together, these two technologies create a powerful foundation for helping customers accelerate their move to the cloud with confidence. With a full OpenStack distribution already included in Oracle Solaris and with plans to integrate OpenDaylight SDN, we’re continuing to execute on our plan to make Oracle Solaris the best cloud platform available.” “Compliance is a real concern for us. The unique security and compliance features in Oracle Solaris 11.2 allow us to dramatically reduce our time and expense spent on compliance and helps us to easily ensure we remain PCI-DSS compliant. Using Kernel Zones improves our security posture significantly while saving valuable dollars,” said Krishna Tangirala, Director of Infrastructure, B&H Photo. “We are using a wide range of Oracle Solaris capabilities for our cloud storage service, Tera cloud, which we released in January 2014. Oracle Solaris 11.2 ZFS compression allows us to reduce our storage costs by more than 3x. We haven’t found these capabilities in any other product,” said Yasushi Taki, President, JustPlayer, Ltd.Supporting Resources Data Sheet: Oracle Solaris 11.2 – Engineered for Cloud Data Sheet: Oracle Solaris Cluster 4.2 Oracle Solaris Blog Connect with Oracle Solaris via Facebook, Twitter and LinkedInAbout Oracle

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

TrademarksOracle 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 Oracle’s plans to integrate OpenDaylight SDN capabilities into Oracle Solaris and any potential synergies or benefits to customers from this integration, are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and the actual or final integration of OpenDaylight SDN capabilities into Oracle Solaris, and could cause the actual or final integration to differ materially from our intentions stated in this press release. All information in this press release is current as of July 31, 2014. Oracle undertakes no duty to update any statement in light of new information or future events.

Contact Info

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

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

 
Categories: Database, Vendor

PASS Summit 2014: Inside the World’s Largest Gathering of SQL Server and BI Professionals

PASS VP of Marketing Denise McInerney – a SQL Server MVP and Data Engineer at Intuit – began her career as a SQL Server DBA in 1998 and attended her first PASS Summit in 2002. The SQL Server Team caught up with her ahead of this year’s event, returning to Seattle, WA, Nov. 4-7, to see what she’s looking forward to at the world’s largest conference for SQL Server and BI professionals.

For those who’ve never attended or who’ve been away for a while, what is PASS Summit?
PASS Summit is the world’s largest gathering of Microsoft SQL Server and BI professionals. Organized by and for the community, PASS Summit delivers the most technical sessions, the largest number of attendees, the best networking, and the highest-rated sessions and speakers of any SQL Server event.

We like to think of PASS Summit as the annual reunion for the #sqlfamily. With over 200 technical sessions and 70+ hours of networking opportunities with MVPs, experts and peers, it’s 3 focused days of SQL Server. You can take hands-on workshops, attend Chalk Talks with the experts, and get the answers you need right away at the SQL Server Clinic, staffed by the Microsoft CSS and SQLCAT experts who build and support the features you use every day. Plus, you can join us early for 2 days of pre-conference sessions with top industry experts and explore the whole range of SQL Server solutions and services under one roof in the PASS Summit Exhibit Hall.

Nowhere else will you find over 5,000 passionate SQL Server and BI professionals from 50+ countries and 2,000 different companies connecting, sharing, and learning how to take their SQL Server skills to the next level.

What’s on tap this year as far as sessions?
We’ve announced a record 160+ incredible community sessions across 5 topic tracks: Application and Database Development, BI Information Delivery, BI Platform Architecture, Development and Administration; Enterprise Database Administration and Deployment, and Professional Development. And watch for over 60 sessions from Microsoft’s top experts to be added to the lineup in early September.

You can search by speaker, track, session skill level, or session type – from 10-minute Lightning Talks, to 75-minute General Sessions, to 3-hour Half-Day Sessions and our full-day pre-conference workshops.

And with this year’s new Learning Paths, we’ve made it even easier to find the sessions you’re most interested in. Just use our 9 Learning Path filters to slice and dice the lineup by everything from Beginner sessions to Big Data, Cloud, Hardware Virtualization, and Power BI sessions to SQL Server 2014, High Availability/Disaster Recovery, Performance, and Security sessions.

Networking is at the heart of PASS Summit – what opportunities do you have for attendees to connect with each other?
PASS Summit is all about meeting and talking with people, sharing issues and solutions, and gaining knowledge that will make you a better SQL Server professional. Breakfasts, lunches, and evening receptions are all included and are designed to offer dedicated networking opportunities. And don't underestimate the value of hallway chats and the ability to talk to speakers after their sessions, during lunches and breaks, and at the networking events.

We have special networking activities for first-time attendees, for people interested in the same technical topics at our Birds of a Feather luncheon, and at our popular annual Women in Technology luncheon, which connects 600+ attendees interested in advancing role of women in STEM fields. Plus, our Community Zone is THE place to hang out with fellow attendees and community leaders and learn how to stay involved year-round.

You mentioned the networking events for first-time attendees. With everything going on at Summit, how can new attendees get the most out of their experience?
Our First-Timers Program takes the hard work out of conference prep and is designed specifically to help new attendees make the most of their time at Summit. We connect first-timers with conference alumni, take them inside the week with community webinars, help them sharpen their networking skills through fun onsite workshops, and share inside advice during our First Timers orientation meeting.

In addition, in our “Get to Know Your Community Sessions,” longtime PASS members share how to get involved with PASS and the worldwide #sqlfamily, including encouraging those new to PASS to connect with their local SQL Server communities through PASS Chapters and continue their learning through Virtual Chapters, SQLSaturdays, and other free channels.

How can you learn more about sessions and the overall PASS Summit experience?
A great way to get a taste of Summit is by watching PASS Summit 2013 sessions, interviews, and more on PASStv. You can also check out the best of last year’s Community blogs.

Plus, stay tuned for 24 Hours of PASS: Summit Preview Edition on September 9 to get a free sneak peek at some of the top sessions and speakers coming to PASS Summit this year. Make sure you follow us on Twitter at @PASS24HOP / #pass24hop for the latest updates on these 24 back-to-back webinars.

Where can you register for PASS Summit?
To register, just go to Register Now – and remember to take advantage of the $150 discount code from your local or Virtual PASS Chapter. We also have a great group discount for companies sending 5 or more employees. And don’t forget to purchase the session recordings for year-round learning on all aspects of SQL Server.

Once you get a taste for the learning and networking waiting for you at PASS Summit, we invite you to join the conversation by following us on Twitter (watch the #sqlpass #summit 14 hashtags) and joining our Facebook and LinkedIn groups. We’re looking forward to an amazing, record-breaking event, and can’t wait to see everyone there!

Please stay tuned for regular updates and highlights on Microsoft and PASS activities planned for this year’s conference. 

Categories: Database

Oracle Identity Management Achieves Significant Customer and Partner Adoption

Oracle Database News - Thu, 07/31/2014 - 16:00
Oracle Identity Management Achieves Significant Customer and Partner AdoptionComplete and integrated, next-generation identity management suite helps customers and partners efficiently secure the extended enterpriseRedwood Shores, Calif. – July 31, 2014 News Summary

As organizations build a strategy for digital transformation, they are seeking a unified approach to enterprisewide identity management that provides consistent access controls and an optimized user experience across the extended enterprise. To help organizations offer more digital services, Oracle Identity Management provides the foundation to connect to the internet value chain and economies of scale to manage users across all channels of interaction including cloud, mobile, and social. The Oracle stack allows companies to homogenize and defragment identity information and services, which can result in faster deployment times, faster upgrades, and lower cost of ownership. Today, many companies are already reaping economic benefits with the simplified user experience and greater end user participation.

News Facts Customers and partners around the world spanning nearly every industry continue to choose Oracle Identity Management to provide seamless and secure access to nearly any application from any device, identify and automate who has access to what, and provide a common view of the user across multiple channels. Recent customers to adopt Oracle Identity Management include Teach for America and Toyota. These customers join more than 30 thousand who have deployed Oracle Identity Management including Avea, Educational Testing Service, Lawrence Livermore National Laboratory, Seneca College, and UL. Oracle Identity Management is a set of scalable, open, best-of-breed solutions that deliver distinct value and support a unified approach to enterprise wide identity management across the extended enterprise, including cloud, mobile, and social channels. Currently, more than 145 alliance partners have achieved OPN Specialized status for Oracle Identity Management products including Oracle Access Management Suite Plus, Oracle Identity Governance Suite, and others. Continuing the momentum, Oracle has enabled alliance partners across the globe, including Accenture, APTEC, Aurionpro Sena, Deloitte, Hub City Media, ICSynergy, Persistent Systems, PwC, Simeio Solutions, and TechDemocracy, to provide delivery services and help enable their customers to secure the extended enterprise. Oracle’s unified approach to enterprise wide identity management is setting a new equilibrium for economies of scale, and today more than a billion identities across the globe are managed by Oracle. Oracle continues to add innovative solutions to Oracle Identity Management including Oracle Mobile Security Suite, which enables organizations to safely provide access to sensitive enterprise applications and data on users’ preferred mobile devices, and Oracle Mobile Authenticator, a token-based authentication application that enables organizations to cost-effectively provide strong authentication and prevent unauthorized access to vital company and customer data. Oracle OpenWorld in San Francisco, September 28–October 2, 2014, is scheduled to feature more than 20 Oracle Identity Management sessions and hands-on labs presented by Oracle product experts in conjunction with customers and partners. Additionally, Oracle DEMOgrounds will highlight Oracle Identity Management solutions including the latest cloud and mobile solutions. Oracle Identity Management is part of Oracle Fusion Middleware, the leading business innovation platform for the enterprise and the cloud. Supporting Quotes "Oracle Identity Management allows us to provide seamless access to our software systems,” said Jim Moran, chief information security officer, Educational Testing Service. “Through our centralized identity services, we are able to manage access to applications whether they are cloud-based, hosted at a third party, or on-premises, without the need to provision and deprovision identities in each target application. This greatly improves the user experience and provides tighter security, all at reduced implementation cost compared to alternatives.” “By teaming with Oracle, we’ve been able to help our clients achieve a more secure business environment through delivering scalable identity management solutions for the extended enterprise,” said Gerard Verweij, global Oracle alliance leader, PwC, an Oracle Diamond Partner of Oracle PartnerNetwork. “Combining Oracle’s offerings with PwC’s industry experience and ability to help our clients with technology-enabled business transformation—from strategy through execution—has resulted in numerous success stories from our clients around the world.” “With Oracle Identity Management, we are now able to grant users single-sign-on access to enterprise and cloud applications from anywhere,” said Thomas Licciardello, vice president, Technology Operations, Teach for America. “By connecting applications to our cloud-based systems with Oracle Identity Management, we can immediately provision and deprovision user rights, thus creating a great user experience while also effectively managing risk for the organization—everyone wins.” “Toyota’s global vision is to lead with mobility by enabling the passenger’s digital experience. Oracle Identity Management enables Toyota’s digital transformation by providing an access solution that supports Toyota and our journey into the future,” said Karen Nocket, vice president, Enterprise Services, Toyota. “At UL our goal is to be a source of knowledge and the go-to resource for tough problems and innovative technologies. Oracle Identity Management is enabling our business goals by streamlining and standardizing our security and audit process to safeguard our systems and our clients’ information while allowing UL to help its customers win in the global market place,” said Bob Jamieson, information security director at UL. “Safety, like security, means trusting and verifying—Oracle provides an efficient way to put controls in place and verify they are working.” Supporting Resources Oracle Identity Management Oracle Mobile Security Suite Oracle Fusion Middleware Follow Oracle Identity Management via Twitter, Facebook, and BlogAbout Oracle

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

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

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

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

Categories: Database, Vendor

National Instruments Transforms Global HR with Oracle HCM Cloud

Oracle Database News - Thu, 07/31/2014 - 13:00
National Instruments Transforms Global HR with Oracle HCM CloudGlobal Technology Manufacturer Adopts Oracle’s Cloud-Based HR to Streamline Processes and Manage Complex Workforce DataRedwood Shores, Calif. – July 31, 2014
News Summary

National Instruments (NI) equips engineers and scientists with tools that accelerate productivity, innovation, and discovery to meet not only grand but also daily engineering challenges in an increasingly complex world, and continues to experience growing demand for its technology. To help meet that demand and scale its business, NI selected Oracle Human Capital Management (HCM) Cloud to better identify and leverage top talent from across its global organization. By standardizing on Oracle HCM Cloud for core HR functions, NI is better equipped to unify HR information, manage employees and candidates, and maximize the efficiency of critical HR processes.

News Facts To better identify and leverage the global talent needed to supports its growth, NI has implemented Oracle Global Human Resources (HR) Cloud, a component of Oracle Human Capital Management (HCM) Cloud. With 7,100 employees in 50 countries worldwide, NI needed to replace multiple legacy HR systems with a modern, cloud-enabled system that could efficiently maintain consistent and accurate employee information on a global scale. After evaluating different options, NI selected Oracle HCM Cloud, as it provides the scalability and flexibility required to optimize critical tasks such as managing headcount, recruitment, onboarding, and learning. Oracle Global HR Cloud will also help managers and executives better understand their workforce and develop their talent by delivering a single, real-time system for all employee records that is fully integrated with NI’s existing Oracle E-Business Suite footprint. In addition, by streamlining administrative processes, Oracle HCM Cloud will enable NI’s HR team to spend more time nurturing existing talent, competitively recruiting top candidates and ensuring each employee is efficiently onboarded. Utilizing a phased approach that started with global HR, self-service, and employee benefits management in the U.S., NI went live on Oracle HCM Cloud in March 2014. As part of its implementation NI established a global HR shared service center to ensure the consistency and accountability of employee data around the world. This will provide a solid foundation for its adoption of Oracle Talent Management Cloud for compensation, performance management, goal management, talent review, and recruiting.Supporting Quote “One of our goals at NI is to create a great place to work for our employees. As an HR Team we want to be able to focus on developing our talent. Since we have talent located in approximately 50 countries it is very important that our HR system is industry standard and consistent across borders, so that HR, managers and employees can spend less time gathering data and more time using that data for effective decision making,” said Wendy Cottrell, senior HRIS manager, NI. “Being a technology company, we place tremendous value on the software we use, that’s why we consider our HCM software not just an HR solution but a business solution. We took our decision to choose Oracle HCM Cloud very seriously. We expect that it will have a huge impact on the way we operate and are excited to see the results unfold.”Supporting Resources Oracle Human Capital Management Oracle HCM Cloud Oracle Global Human Resources Cloud Oracle Talent Management Cloud Oracle HCM Blog Oracle HCM on Twitter Oracle HCM on Facebook Video: National Instruments Selects Oracle Fusion HCM to help their Business Better Manager HR FunctionsAbout NI

Since 1976, NI has made it possible for engineers and scientists to solve the world’s greatest engineering challenges with powerful, flexible technology solutions that accelerate productivity and drive rapid innovation. Customers from a wide variety of industries—from healthcare to automotive and from consumer electronics to particle physics—use NI’s integrated hardware and software platform to improve the world we live in.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit 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.

Contact Info

Danielle Cormier-Smith
Oracle
+1.610.766.3463
danielle.cormier@oracle.com




  
Categories: Database, Vendor

PureFormulas Boosts Personalization with Oracle Commerce

Oracle Database News - Thu, 07/31/2014 - 13:00
PureFormulas Boosts Personalization with Oracle CommerceOracle Commerce helps PureFormulas customize offerings, enter new markets, and add auto-ship capabilities Redwood Shores, Calif. – July 31, 2014News Summary

As a leader in consumer health supplements, PureFormulas was challenged to provide customers with the individualized transactions and product recommendations they required. A recent migration to Oracle Commerce allows PureFormulas to personalize the customer experience and open up new market segments without sacrificing ease of use. The breadth of the items and the filters available are a “huge improvement,” PureFormulas leaders say—and the new system doesn’t bombard existing customers with irrelevant content.

News Facts PureFormulas, a leader in the online health supplement space, implemented Oracle Commerce to help grow its business by creating different commerce experiences for different customer segments. With the migration to Oracle Commerce, PureFormulas is launching four new verticals: sports and fitness nutrition, pet health, beauty, and food. The implementation of Oracle Commerce allows for a much more customizable experience, with opportunities for personalized promotions, cross-selling, up-selling, and auto-ship—all with revenue-increasing capabilities. With the new Oracle Commerce system, PureFormulas will be better able to mine customer data, allowing for faster, more intelligent decision making. The Oracle Commerce implementation was completed with minimal impact on business teams, other than customer service representatives who will now process returns and order inquiries with the new tool. PureFormulas had considered a gold-standard platform like Oracle Commerce out of reach, but the retailer found the platform affordable, and it allowed the company to move beyond its current rent-share model. PureFormulas worked with Vachio Solutions Group (VSG), a Gold-level member in Oracle PartnerNetwork (OPN), for the implementation. Supporting Quotes “One of the things the Oracle implementation brings to us is good strength in overall business value because we now have a platform we can build upon that caters to our needs,” said William Perez, chief information officer, PureFormulas. “We can build extreme competencies and solutions that one-up our competitors.” “PureFormulas promises 100 percent satisfaction guaranteed. We differentiate through the customer experience, and we look to technology as a differentiator,” said Jose Prendes, chief executive officer, PureFormulas. “We believe that Oracle will support our growth and allow us to respond as the market changes and the opportunity arises.” “Maintaining and improving its customer-centric approach is a central strategy for PureFormulas,” said Mike Webster, senior vice president and general manager, Oracle Retail. “Oracle Commerce provides the tools PureFormulas requires to redefine exceptional customer experiences, while establishing a platform that supports rapid growth now and well into the future.” Supporting Resources About Oracle Commerce Oracle Retail on Facebook, Twitter, and YouTube Oracle Retail Blog  Oracle Commerce Anywhere Blog Oracle Retail in the News Oracle Retail Asset and Centralized Knowledge PortalAbout Oracle

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

Trademark

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

# # #

Contacts:

Greg Lunsford
Oracle
+1.650.506.6523
greg.lunsford@oracle.com

Mary Ellen Amodeo
Amodeo Associates
+1.612.963.5797
meamodeo@gmail.com

Categories: Database, Vendor

Oracle Buys TOA Technologies

Oracle Database News - Thu, 07/31/2014 - 13:00
Oracle Buys TOA TechnologiesAdds Leading Field Service SaaS to Oracle Service Cloud and Oracle ERP Cloud Solutions to Deliver Effective and Timely Home- and Facility-based Customer ServiceRedwood Shores, Calif. – July 31, 2014
News Facts Oracle today announced that it has signed an agreement to acquire TOA Technologies (TOA), a leading provider of cloud-based field service solutions that manage and optimize the last mile of customer service for enterprises by coordinating activities between dispatchers, mobile employees and their customers. TOA’s Field Service SaaS enables modern enterprises to continuously monitor real-time field service requests coming in from contact centers, to schedule the right field service representative to dispatch, and to use sophisticated business analytics to monitor and view current inventories, accurately predict service windows, and optimize field service operations. TOA’s customers have more efficient field service operations, lower costs of delivering field service, and deliver a superior customer experience. TOA’s solutions manage over 120 million service events annually in more than 20 countries and include global brands across many industries including DISH Network, E.ON, Home Depot, Ricoh, Telefonica, Virgin Media and Vodafone. Oracle Service Cloud, part of Oracle Customer Experience Cloud, is an industry-leading platform for online customer service, cross-channel contact center, knowledge management, and policy automation. Oracle ERP cloud solutions help accelerate productivity, allocate resources, and provide on-demand information access. Oracle Service Cloud and Oracle ERP cloud solutions combined with TOA will empower innovative customer service organizations to drive operational efficiencies while bolstering customer satisfaction and exceeding service expectations through personalized service. More information on this announcement can be found at http://www.oracle.com/toatechnologies.Supporting Quotes “Companies want to offer customers a unified and highly engaging experience each time they interact with them,” said David Vap, Group Vice President, Oracle Product Development. “Field Service is a critical aspect of customer service and by integrating TOA with Oracle Service Cloud, Oracle will uniquely offer enterprises the ability to coordinate face-to-face service interactions from the contact center to service scheduling and delivery. Further, by integrating TOA with Oracle’s ERP Cloud and ERP Applications, enterprises’ field service teams will have better information and can be operated more efficiently and at lower cost.” “Delivering quality field service during the last mile of issue resolution is critical to achieving the highest levels of customer satisfaction. TOA’s solutions help companies streamline operations, gaining real-time scheduling capability that transforms how service is delivered,” said Yuval Brisker CEO, TOA Technologies. “Adding TOA’s solutions to Oracle Service Cloud will enable companies to accelerate their ability to deliver exceptional customer service.”Supporting Resources About Oracle and TOA Technologies General Presentation Customer and Partner Letter FAQAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit 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.

This document is for informational purposes only and may not be incorporated into a contract or agreement.

Contact Info

Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com

Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com

  

Oracle is currently reviewing the existing TOA Technologies product roadmap and will be providing guidance to customers in accordance with Oracle's standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle's review of TOA Technologies’ product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by TOA Technologies or by Oracle, does not represent a commitment to deliver any material, code, or technology, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and TOA Technologies, including statements that involve risks and uncertainties concerning Oracle's proposed acquisition of TOA Technologies, anticipated customer benefits and general business outlook. When used in this document, the words "anticipates", "can”, "will", "look forward to", "expected" and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or TOA Technologies, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or TOA Technologies may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or TOA Technologies. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor TOA Technologies is under any duty to update any of the information in this document.

Categories: Database, Vendor

Desarrolle una herramienta personalizada de migración de datos para Reference Data Management

IBM - DB2 and Informix Articles - Thu, 07/31/2014 - 05:00
La migracion de datos desde una instalación de IBM InfoSphere Master Data Management (MDM) Reference Data Management a otra puede ser una tarea desafiante. Mediante el uso de una herramienta interna de IBM como un ejemplo, este artículo explora la forma de desarrollar una solución a la medida para problemas complejos de migración usando servicios Reference Data Management REST o MDM SOAP. La solución es para todos los sistemas operativos, servidores de aplicación y bases de datos. La herramienta a la medida puede migrar los datos desde la versión más baja de Reference Data Management a una versión más elevada, específicamente desde V10 hasta V11. Su herramienta a la medida puede diseñarse para operar bien en las versiones futuras de Reference Data Management (asumiendo que las interfaces de servicio sigan siendo las mismas).
Categories: Database

Develop a custom data migration tool for Reference Data Management

IBM - DB2 and Informix Articles - Thu, 07/31/2014 - 05:00
Migrating data from one IBM InfoSphere Master Data Management (MDM) Reference Data Management installation to another can be a challenging task. Using an IBM internal tool as an example, this article explores how to develop a custom solution for complex migration problems using Reference Data Management REST or MDM SOAP services. The solution is for all operating systems, application servers, and databases. The custom tool can migrate data from a lower version of Reference Data Management to a higher version, specifically from V10 to V11. Your custom tool can be designed to work well for future versions of Reference Data Management (assuming the service interfaces remain the same).
Categories: Database

Increase scalability and failure resilience of applications with IBM Data Server Driver for JDBC and SQLJ

IBM - DB2 and Informix Articles - Thu, 07/31/2014 - 05:00
IBM DB2 pureScale on DB2 for Linux, UNIX, and Windows and Sysplex on DB2 for z/OS are IBM's premium database cluster options that offer unmatched database availability and scalability. This article explores the fundamentals and algorithms that govern the pureScale and Sysplex functions of the IBM Data Server Driver for JDBC and SQLJ. Applications can easily exploit these data-sharing technologies with minimal application or driver-related configuration effort. With increasing adoption of data-sharing technologies and the widespread use of JDBC by client applications, it is beneficial for application developers, users, and system administrators to understand, exploit, and manage the behavior of JDBC applications connecting to pureScale or Sysplex systems. This article discusses these technologies from a client standpoint.
Categories: Database

Transitioning from SMP to MPP, the why and the how

This blog post was authored by: Sahaj Saini, PM on the Microsoft Analytics Platform System (APS) team.

In this blog post, we’ll provide a quick overview of Symmetric Multi-Processing (SMP) vs. Massively Parallel Processing (MPP) systems, how to identify triggers for migrating from SMP to MPP, key considerations when moving to Microsoft Analytics Platform System (APS), and a discussion about how to take advantage of the power of an MPP solution such as APS.

Let us begin with a scenario. Emma is the Database Administrator at Adventure Works Cycles, a bicycle manufacturing company. At Adventure Works, Emma and her team are using traditional SQL Server SMP as their data warehousing solution. The company has been growing rapidly and with growing competition in the bicycle industry, the business analysts at Adventure Works Cycles would like quicker insight into their data. Emma is now facing the following challenges with the SMP deployment –

  • High Data Volume and Data Growth: With increasing sales and a growing customer base, the data volume has grown rapidly to cross 10 TB.
  • Longer Data Loading/ETL times: With the need to produce daily reports to management, Emma finds the current ETL speed inadequate to intake and process the increasing quantity of data flowing from other OLTP and non-relational systems.
  • Slow Query Execution: Query execution times are slowing down due to the increase of data and it is becoming increasingly difficult to generate insights for daily reporting in a timely manner.
  • Long Cube Processing Time: With the current cube processing time, it is difficult to meet the real-time reporting needs of the company.

In order to overcome these challenges, Emma and her team evaluate the purchase of a larger, expensive and more powerful set of server and storage hardware to their datacenter. This approach would solve their problem but only for the short-term as the data growth is expected to explode in the next 12 months. With data growth that Adventure Works is expecting to see, even the bigger and more powerful SMP solutions would hit a wall very quickly. Emma would like to see a solution that scales as their data needs grow.

What’s the difference between SMP and MPP?

Before we jump into solving Emma’s problems, let’s quickly define what SMP and MPP are. Symmetric Multi-Processing (SMP) is a tightly coupled multiprocessor system where processors share resources – single instances of the Operating System (OS), memory, I/O devices and connected using a common bus. SMP is the primary parallel architecture employed in servers and is depicted in the following image.

Massively Parallel Processing (MPP) is the coordinated processing of a single task by multiple processors, each processor using its own OS and memory and communicating with each other using some form of messaging interface. MPP can be setup with a shared nothing or shared disk architecture.

In a shared nothing architecture, there is no single point of contention across the system and nodes do not share memory or disk storage. Data is horizontally partitioned across nodes, such that each node has a subset of rows from each table in the database. Each node then processes only the rows on its own disks. Systems based on this architecture can achieve massive scale as there is no single bottleneck to slow down the system. This is what Emma is looking for.

MPP with shared-nothing architecture is depicted in the following image.

Microsoft Parallel Data Warehouse (PDW) running on a Microsoft Analytics Platform System appliance is implemented as an MPP shared-nothing architecture. It consists of one control node and storage attached compute nodes inter-connected by Ethernet and Infiniband. The control node hosts the PDW engine – the brains of the MPP system – that creates parallel query plans, co-ordinates query execution on compute nodes, and data aggregation across the entire appliance. All nodes, including control and compute, host a Data Movement Service (DMS) to transfer data between nodes.

For more details on PDW architecture, you can read the Architecture of the Microsoft Analytics Platform System post.

Transitioning to MPP

To realize the value offered by MPP, Emma and her team purchase a Microsoft APS appliance and begin transitioning to MPP. Let’s take a look at how they adapt their solution to take full advantage of APS’s shared nothing MPP architecture.

Table Design

As previously mentioned, APS is based on a shared nothing MPP architecture which means that nodes are self-sufficient and do not share memory or disks. The architecture, therefore, requires you to distribute your large tables across nodes to get the benefits of the massively parallel processing. APS allows the definition of a table as either distributed or replicated. The decision to choose one versus the other depends on the volume of data and the need for access to all of the data on a single node.

Distributed Tables

A distributed table is one where row data within the table is distributed across the nodes within the appliance to allow for massive scale. Each row ends up in a one distribution in one compute node as depicted by the image below.

To take advantage of the distributed nature of APS, Emma modifies the large tables, typically Fact and large dimension tables, to be distributed in APS as follows:

CREATE TABLE [dbo].[FactInternetSales]
(
  [ProductKey] [int] NOT NULL,
  [OrderDateKey] [int] NOT NULL,
  .
  .
  [ShipDate] [datetime] NULL
) 
WITH
(
  DISTRIBUTION = HASH(ProductKey),
CLUSTERED COLUMNSTORE INDEX
);

As you can see, this is a typical DDL statement for table creation with a minor addition for distributed tables. Tables are distributed by a deterministic hash function applied to the Distribution Column chosen for that table. Emma chooses Product Key as the distribution column in the FactInternetSales table because of the high cardinality and absence of skew, therefore distributing the table evenly across nodes.

Replicated Tables

If all tables were distributed, however, it would require a great deal of data movement between nodes before performing join operations for all operations. Therefore, for smaller dimension tables such as language, countries etc. it makes sense to replicate the entire table on each compute node. That is to say, the benefits of enabling local join operations with these tables outweigh the cost of extra storage consumed. A replicated table is one that is replicated across all compute nodes as depicted below.

Emma designs the small tables, typically dimension tables, to be replicated as follows:

 CREATE TABLE [dbo].[DimDate](
  [DateKey] [int] NOT NULL,
  .
  .
  [SpanishDayNameOfWeek] [nvarchar](10) NOT NULL,
)
WITH
(
CLUSTERED COLUMNSTORE INDEX
);

By appropriately designing distributed and replicated tables, Emma aligns her solution with common MPP design best practices and enables efficient processing of high volumes of data. For example, a query against 100 billion rows in a SQL Server SMP environment would require the processing of all of the data in a single execution space. With MPP, the work is spread across many nodes to break the problem into more manageable and easier ways to execute tasks. In a four node appliance (see the picture above), each node is only asked to process roughly 25 billion rows – a much quicker task. As a result, Emma observes significant improvements to the query execution time and her business can now make better decisions, faster. Additionally, Emma can grow the data warehouse to anywhere from a few terabytes to over 6 petabytes of data in by adding “scale units” to APS.

Data Loading

With SQL Server SMP, Emma and her team were using ETL processes via a set of SSIS packages to load data into the data warehouse – (1) Extracting data from the OLTP and other systems; (2) Transforming the data into dimensional format; and (3) Loading the data to target dimension or fact tables in the Data Warehouse. With increasing volumes of data, the SSIS sever in the middle becomes a bottleneck while performing transformations, resulting in slow data loading.

With APS, Emma and her team can use ELT instead, to Extract the data from the OLTP and other systems and Load it to a staging location on APS. Then, the data can be Transformed into dimensional format not with SSIS but with the APS Engine utilizing the distributed nature of the appliance and the power of parallel processing. In a 4-node appliance, four servers would be doing the transformations on subsets of data versus the single node SSIS server.

This parallel processing results in a significant boost in data loading performance. Emma can then use the Create Table As Select (CTAS) statement to create the table from the staging table as follows.

CREATE TABLE [dbo].[DimCustomer] 
WITH
(
  CLUSTERED COLUMN INDEX,
  DISTRIBUTION = HASH (CustomerKey)
)
AS
SELECT * FROM [staging].[DimCustomer];

By switching to an ELT process, Emma utilizes the parallel processing power of APS to see performance gains in data loading.

In conclusion, Emma and her team have found answers to their SMP woes with MPP. They can now feel confident handling the data volume and growth at Adventure Works with the ability to scale the data warehouse as needed. With ELT and the power of parallel processing in APS, they can load data into APS faster and within the expected time-window. And by aligning with APS’s MPP design, they can achieve breakthrough query performance, allowing for real-time reporting and insight into their data.

Visit the Analytics Platform System page to access more resources including:  datasheet, video, solution brief, and more..

To learn more about migration from SQL Server to the Analytics Platform System

Categories: Database

Oracle Customers Plug into the Cloud with Oracle Database 12c

Oracle Database News - Wed, 07/30/2014 - 13:00
Oracle Customers Plug into the Cloud with Oracle Database 12cLatest version of world’s #1 database is available now, and includes new Oracle Database In-Memory technology to power the real-time enterprise Redwood Shores, Calif. – July 30, 2014 News Summary

In today's fast-paced, technology-driven business environment, organizations face an ever-growing volume of enterprise data to manage and analyze. To effectively deliver enhanced customer experiences, analytical insights, and efficient operations, companies around the world are adopting Oracle Database 12c, including key options such as Oracle Multitenant and Oracle Database In-Memory. Oracle Multitenant is helping customers to more easily consolidate and manage multiple databases as one, resulting in improved efficiency and simplified management with maximum availability. Additionally, the newly available Oracle Database In-Memory option transparently extends the power of Oracle Database 12c to enable organizations to discover business insights in real-time while simultaneously increasing transactional performance.

News Facts Customers and partners worldwide are using Oracle Database 12c to manage their critical and complex data workloads. The latest release, Oracle Database 12c Release 12.1.0.2, is generally available and includes Oracle Database In-Memory, an option designed to power the real-time enterprise, enabling better and faster business decisions by accelerating the performance of Oracle Database applications. By leveraging the Oracle Multitenant architecture that simplifies database consolidation in the cloud, organizations around the world have deployed database as a service (DBaaS), allowing them to manage multiple databases on a shared, scalable, and agile database platform. With DBaaS facilitated through Oracle Database 12c, customers have improved server utilization and streamlined database management, all while retaining database isolation and with no application changes. Many Oracle PartnerNetwork partners have deployed their applications on Oracle Database 12c to gain a competitive advantage for themselves and their end users, making it one of the most rapidly adopted technologies in the Oracle partner ecosystem. By hosting clients’ databases in the cloud with Oracle Multitenant, partners are passing along cost savings to their customers through streamlined management, shared resources, and trusted security. This latest release of Oracle Database 12c also enables customers and partners to: Easily develop applications with new types of data. With JSON support in Oracle Database 12c Release 12.1.0.2, organizations can store JSON document data in their Oracle Database and query it through traditional SQL and RESTful interfaces. Accelerate database and data warehousing performance. Attribute clustering is designed to ensure that related columns in a database are physically stored together for faster access. Simplify delivery of mission-critical DBaaS environments. A new Rapid Home Provisioning feature in Oracle Database 12c simplifies provisioning, upgrade, patching, and maintenance of multitenant database cloud environments.Supporting Quotes “As the cloud, mobile devices, and the web send larger volumes of data into the enterprise, organizations are challenged to manage this data efficiently and cost-effectively,” said Andrew Mendelsohn, executive vice president, Oracle Database Server Technologies. “Customers around the world are harnessing Oracle Database 12c along with options including Oracle Multitenant to consolidate their databases and deliver database as a service on premises and in the cloud. With the added firepower of Oracle Database In-Memory now available, customers can instantly gain the competitive advantage of the real-time enterprise with the flip of a switch.” “The Oracle Taleo Business Edition Cloud Service platform leverages Oracle Database 12c with Oracle Multitenant to provide a proven, scalable, multitenant platform to further grow our customer base,” said Obaidur Rashid, senior director, development, Oracle Taleo. “By migrating Oracle Taleo Business Edition to a SaaS platform using Oracle Multitenant, we now have a fast, reliable, and scalable database powering our applications to better meet customers’ service-level expectations and help grow our business.” “Deploying Oracle Database 12c with Oracle Multitenant on Oracle Exadata has saved us $1.7 million in capital expense alone, had we decided to maintain our current AIX P-Series environment,” said Brian Pawlik, information services manager, Pulte Group Inc. “The value of Oracle Multitenant ‘manage many-as-one’ for patching and database management has allowed us to save in increasing database staff, and the database clone capability, we project, will save us approximately four man-months in our first year. This was an exceptionally smooth migration for us from Oracle Database 11g to Oracle Database 12c and Oracle Multitenant on Oracle Exadata.” “With Oracle Database In-Memory, we saw our query performance go from minutes and hours to seconds, while dropping indexes reduced our database size by 80 percent,” said Francois Bermond, Data & Analytics, Schneider Electric. Supporting Resources Oracle Database 12c Oracle Database In-Memory Oracle Multitenant Connect with Oracle Database via the Oracle BlogFacebook, and TwitterAbout Oracle

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

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

Letty Ledbetter
Oracle
+1.650.506.8071
letty.ledbetter@oracle.com

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

Categories: Database, Vendor