Data Integration Articles
Anyone who has ever attended Oracle OpenWorld knows that you must plan ahead. The conference held in San Francisco each fall is vast, and the upcoming conference, scheduled for September 18-22, 2016, promises to be equally expansive. Just as in years before, tens of thousands of attendees from well over 100 countries can be expected converge to learn more about Oracle's ever-expanding ecosystem of technologies, products and services during thousands of sessions held at the Moscone Center and multiple additional venues in downtown San Francisco. Here, Database Trends and Applications presents the annual Who to See @ Oracle OpenWorld special section.
Posted August 04, 2016
As one works through the normal forms, be it a journey to the placid shores of third normal, or the more arid climes of Boyce-Codd normal form, or even the cloudy peaks of fourth normal and beyond—and before one starts thinking about normalizing the design—the database designer has covered a lot of ground work already. Before thinking of normalizing, one needs to have conceptualized the relations that might be within the solution's scope.
Posted August 04, 2016
I had the pleasure to spend some time with my old friend Mark Souza, a general manager in the Data Platform team at Microsoft, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other since the 1990s when SQL Server was just being ported to a brand new operating system called Windows NT. Mark and I were having a laugh and more than a twinge of nostalgia about how much SQL Server has improved over the decades and now sits atop the heap on most analysts' "best database" reports. This isn't just two old-timers sharing a few war stories though. This is a living, breathing transformation that is still in process.
Posted August 04, 2016
As IT decision making moves out of the IT department and into the functional areas of organizations, partnerships and collaboration become even more critical. According to an article in strategy+business on why CEOs must become more technology savvy, "the majority of technology spending (68%) is now coming from budgets outside of IT, a significant increase from 47% in 2014." What this means is that many critical technology decisions are being made without the consultation of IT professionals.
Posted August 04, 2016
Regulatory compliance is a critical aspect of the IT landscape these days, and the ability to audit database activities showing who did what to which data when is a specific requirement of many industry and governmental regulations. There are six primary methods that can be used to accomplish database auditing.
Posted August 04, 2016
With 20 million downloads to date, MongoDB is arguably today's fastest-growing database technology. MongoDB's rapid growth has been driven primarily by its attractiveness to developers. By using JavaScript Object Notation (JSON) documents as the native database format, MongoDB reduces the impedance mismatch between program code and database, allowing more agile and rapid application development.
Posted August 04, 2016
Can Oracle and its partners keep up with the increasing demands of customers for real-time digital capabilities? Is the Oracle constellation of solutions—from data analytics to enterprise applications—ready for the burgeoning requirements of the Internet of Things (IoT) and data-driven businesses? For Oracle—along with its far-flung network of software vendors, integrators, and partners—times have never been so challenging.
Posted August 04, 2016
The month of June heralded the long-awaited release of Microsoft's SQL Server 2016. The 2016 edition includes unique security functionality with Always Encrypted that protects data both at rest and in motion, ground-breaking performance and scale as evidenced by the number-one performance benchmarks, and accelerated hybrid cloud scenarios and Stretch Database functionality that supports historical data on the cloud.
Posted August 04, 2016
Kore Technologies has unveiled the latest release of its signature platform, Kourier Integrator, improving several key areas of the hailed solution. A year and a half in the making, Kourier Integrator Release 4.3 makes it easier to create, deploy, and use RESTful Web Services for real-time enterprise application integration.
Posted August 04, 2016
Datavail, a provider of data and DBA services, offering 24×7 managed database services, database design, architecture, and staffing, has acquired Art of BI, an Oracle analytics consulting company focused on OBIEE and Hyperion.
Posted August 03, 2016
Oracle announced today that it is acquiring NetSuite in a transaction valued at approximately $9.3 billion. The transaction is expected to close in 2016. In a statement, Zach Nelson, CEO of NetSuite, said that NetSuite will benefit from Oracle's global scale and reach to accelerate the availability of its cloud solutions.
Posted August 03, 2016
Datical, a provider of agile database automation solutions, is releasing an updated version of its namesake platform, improving the solution with change management enhancements to boost workflows. Datical DB 4.0 includes a new Automated Deployment Packager that allows database changes to be continually validated, packaged, and integrated via more pervasive, hands-off automation.
Posted August 03, 2016
Organizations have directed a lot of attention recently to consolidation, automation, and cloud efforts in their data management environments. This will purportedly result in decreased demand for data managers and the need for fewer DBAs per groups of databases. However, the opposite seems to be occurring. In actuality, there is a growing need for more talent, as well as expertise to manage through growing complexity. A new survey, sponsored by Idera and conducted by Unisphere Research among more than 300 data executives, managers, and professionals finds that a more challenging data environment is arising due to a confluence of factors.
Posted August 03, 2016
To manage growing data volumes and pressing SLAs, many companies are leveraging Apache™ Kafka and award-winning Attunity Replicate with next-generation change data capture (CDC) for streaming data ingest and processing.
Posted August 03, 2016
The potential of your business intelligence or data processing application is limited without a comprehensive data connectivity solution. Staying competitive and relevant requires a breadth of data connectivity options.
Posted August 03, 2016
Our goal at Amazon Web Services (AWS) is to enable our customers to do things that were previously not possible, and make things that our customers can already do simpler and better at a much lower cost.
Posted August 03, 2016
It is both exciting and validating to be selected as the number 1 data modeling solution by DBTA's discerning readers for the third consecutive year in a row!
Posted August 03, 2016
Data replication advances a number of enterprise goals, supporting scenarios such as distribution of information as part of business intelligence and reporting initiatives, facilitating high availability and disaster recovery, and as part of a no-downtime migration initiative.
Posted August 03, 2016
Everyone knows the three Vs, volume, velocity, and variety, of big data but what's required is a solution that can extract valuable insights from new sources such as social networks email, sensors, connected devices as sensors, the web, and smartphones.
Posted August 03, 2016
Query and reporting solutions are part of a comprehensive business intelligence approach in every organization. As long as enterprises need to gather data, BI groups look to utilize query and report programs as primary applications that produce output from information systems
Posted August 03, 2016
As data grows, organizations are looking for ways to dig up insights from underneath layers of information. Data mining solutions provide the tools that enable them to view those hidden gems and facilitate better understanding of new business opportunities, competitive situations, and complex challenges.
Posted August 03, 2016
Business intelligence encompasses a variety of tools that enable organizations to collect data from internal systems and external sources, prepare it for analysis, develop, and run queries against the data, and create reports, dashboards and data visualizations.
Posted August 03, 2016
Data virtualization provides organizations with the ability to allow the business and IT sides of organizations to work closer together in a much more agile fashion, and helps to reduce the complexity.
Posted August 03, 2016
Data integration is critical to many organizational initiatives such as business intelligence, sales and marketing, customer service, R&D, and engineering. For many enterprises, however, the road to data-driven nirvana is stymied by the inflexible, calcified systems and processes that were laid out decades earlier and still control the data flow within many enterprises, according to Joe McKendrick, lead research analyst at Unisphere Research.
Posted August 03, 2016
The last thing companies want is tainted data merging with incorrect information. The process of maintaining data integrity enhances the reliability of information for use by a business. This is where tools to ensure data quality come in.
Posted August 03, 2016
Data is increasingly appreciated by companies as their most valuable asset. But the problem is that this view is not just held by organizations themselves, there are others - including hackers and - who see it that way as well. IT and data managers can play a pivotal role in enterprise security because they are the insiders with trusted status and they are aware of where the data is stored and how best to reduce or eliminate threats. Newer security technology can also relieve many of the manual burdens associated with database monitoring.
Posted August 03, 2016
For fast-paced, turn-on-a-dime digital enterprises, with demands for 24-by-7 uptime, no activity is more vital than keeping database systems up and running. Today, database availability is no longer just a critical IT issue; it is a critical business issue. To be prepared in the event of system failures, infrastructure owners and DBAs have developed strategies to increase resiliency and assure availability of data.
Posted August 03, 2016
Database development is growing more challenging all the time. Releases are expected to come out faster than ever, and teams are more spread out across, global geographies, time zones, and skill levels. Software deployment, meanwhile needs to be spread across cloud and onsite, and accessible through more devices than ever. What's needed is an integrated end-to-end environment with multi-platform support that helps simplify development and provides automation to achieve repeatable processes and avoid potential risks that can translate into unanticipated delays.
Posted August 03, 2016
If information is the lifeblood of organizations today, then delivering information where it is needed faster can be considered a matter of business health, and in some cases, even business survival.
Posted August 03, 2016
There is more data available to organizations than ever before, but the goal remains the same - to unlock nuggets of gold, the useful information that will result in competitive advantage for the organization, allowing it to react to customer's needs with lightning speed, uncover new opportunities, and act fast to counter competitive threats.
Posted August 03, 2016
Over the years, MultiValue technology has maintained its base of committed advocates despite the decades-long trend toward relational database management systems. And, now with an expanding appreciation for polyglot persistence, or put more simply, the selection of the best tool for the job, there is a growing recognition that different data management systems offer different benefits with some simply better suited for certain requirements than others.
Posted August 03, 2016
Today, data is being recognized and appreciated as an asset, and even, some have suggested, a kind of currency. But beyond the obvious businesses built on data - such as Airbnb's rental business, Uber's car service app, and Alibaba's online marketplace - every business today is striving to become a data-driven organization, with turn-on-a-dime agility and rapid insights into customer behaviors and desires.
Posted August 03, 2016
Splice Machine is teaming up with Incedo, a technology solutions provider specializing in data and analytics, product engineering, and emerging technologies, to generate solutions that will help enterprises manage data and accelerate data processing.
Posted August 03, 2016
Velostrata, which provides software for moving cloud workloads, has introduced a new release of its namesake platform, adding capabilities to simplify, speed, and decrease the risk associated with cloud migration in support of enterprise hybrid cloud initiatives.
Posted August 03, 2016
SolarWinds, a provider of IT management software, has announced significant updates to the SolarWinds Database Performance Analyzer (DPA). Version 10.2 supports MySQL as a back-end database in addition to SQL Server and Oracle Database, includes visualization and analysis tools to help DBAs optimize for and resolve blocking, locking, and deadlock issues, and adds support for Microsoft SQL Server 2016.
Posted August 02, 2016
Reltio, an applications and data management PaaS company, is receiving $22 million in Series B funding, with the investement being used to expand and accelerate the company's hiring practices and further innovation.
Posted August 01, 2016
Talend S.A., a provider of big data and cloud integration solutions, successfully launched its IPO. The offering included 5,250,000 American Depositary Shares (ADSs), each representing one of its ordinary shares, at a price to the public of $18 per ADS, which was higher than anticipated - and then rose sharply.
Posted July 29, 2016
Riverbed Technology, which provides solutions for application performance, has signed a definitive agreement to acquire Aternity, a provider of end user experience and application performance monitoring solutions that monitors more than 1.7 million mobile, virtual and desktop workforce endpoints.
Posted July 28, 2016
Helping to address complex analysis problems, IBM has announced the general availability of IBM Graph, a Bluemix service that allows users to set up graph databases in the cloud. Previously offered in beta earlier this year, the availability was made public in an IBM developerWorks blog by Adrian Warman, documentation lead for IBM UK Application Platform Services, on behalf of the IBM graph team.
Posted July 28, 2016
There's a new buzzword on the loose, the data lake. At first glance, a data lake could be easily mistaken for a data warehouse. The two big data concepts have a common focus on analytics and they may, in certain situations, produce roughly equivalent output. But that's about where their similarities end.
Posted July 27, 2016
TIBCO Software Inc. is unveiling a new platform designed for companies investing in digital business strategies. The platform, called TIBCO Mashery Enterprise API, covers the entire API lifecycle, allowing users to create, integrate, and manage APIs with a single offering.
Posted July 27, 2016
Paxata is partnering with PwC US to deliver a new self-service data preparation solution to PwC's existing governance, risk, and compliance tools. This alliance allows Paxata to work with PwC to develop customized data preparation solutions that will help clients structure various types of data in an intuitive and visual way.
Posted July 27, 2016
Accellion, Inc., a provider of private cloud solutions for secure file sharing and collaboration, has added new security features in the kiteworks content platform to help enterprises keep their critical enterprise data secure while extending compliance with rigorous industry requirements.
Posted July 27, 2016
SAP SE is unveiling a new platform that will help organizations enrich business applications with geographic data from geographic information systems. "We have an entire portfolio of spatial solutions to our customers across a variety of industries," said said Marie Goodell, head of marketing of the SAP HANA Platform at SAP.
Posted July 27, 2016
By the mid-2000s, a huge number of web apps were built upon the so-called LAMP stack. LAMP applications utilize the Linux operating system, Apache web server and MySQL database server, and implement application logic in PHP or another language starting with the letter "P," such as Python or Perl. But the LAMP stack is now essentially obsolete technology, and the MEAN stack provides a lot of productivity advantages, especially for modern highly-interactive web sites. But the MEAN stack is not without compromise. Here's why.
Posted July 27, 2016
SAP SE is making big changes and introducing product innovations in its enterprise information management (EIM) portfolio to offer improved support for cloud and Big Data environments, enhancements for more self-service capabilities, and comprehensive support for governing enterprise information.
Posted July 27, 2016
According to Gartner's 2016 CIO Agenda Survey, CIOs are moving from a systems-focused view to a platform-focused view in 2016, with digital revenue expected to more than double over the next year. Digitization will bring many benefits to the business, including increased revenue from better operations (expected by 66% of CIOs) and more business through digital channels (expected by 48% of CIOs). With the growing volume of digital data and its strategic value to the business, DBAs can also play an essential role in this digital transformation
Posted July 27, 2016