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!
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!
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:
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/ChangeLogLinks & 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.
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
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.
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
Blanc & Otus
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.
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.
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 magazineAbout 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.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Blanc & Otus
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.
â˘ 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.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.
Blanc and Otus
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.
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
Blanc & Otus
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 and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Contact Info
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 and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
# # #Contacts:
Mary Ellen Amodeo
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
Oracle Corporate Communications
Oracle Investor Relations
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.
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 –
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
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 126.96.36.199, 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 188.8.131.52, 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 Blog, Facebook, and TwitterAbout Oracle