Data Warehousing Articles
A relational database is a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The standard user and application programming interface (API) of a relational database is the Structured Query Language (SQL). SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports.
Posted August 08, 2018
Database downtime can inflict a fatal wound on the life of a business and having a trusted backup solution that can ensure that databases can be back up and running quickly in the event of an outage is critical. With long downtimes simply unacceptable, organizations seek solutions with capabilities such as the ability to manage backups seamlessly, manage and monitor backups, ensure data integrity, scale efficiently restore quickly to any point in time, and provide security features to stay in compliance with local geographic and industry mandates.
Posted August 08, 2018
Companies are increasingly looking for the right database for the data storage need at hand. That might mean NoSQL, NewSQL, in-memory databases, and cloud databases—also known as database as a service—approaches.
Posted August 08, 2018
Today's data visualization tools go beyond the standard charts and graphs used in Excel spreadsheets, displaying data in more sophisticated ways such as infographics, dials and gauges, geographic maps, sparklines, heat maps, and detailed bar, pie and fever charts. The images may include interactive capabilities, enabling users to manipulate them or drill into the data for querying and analysis.
Posted August 08, 2018
Redgate Software is adding Nexus Technology to its worldwide partner roster to help organizations successfully introduce DevOps to their database development. Redgate's software is already used by 91% of companies in the Fortune 100, and the new partnership with Nexus now means companies in the Channel Islands are in the ideal position to explore how too they can take advantage of database DevOps.
Posted August 07, 2018
Yellowbrick Data is today emerging from stealth and announcing the debut of its analytic solution for hybrid cloud, the cornerstone of which is the Yellowbrick Data Warehouse. According to Yellowbrick, the data warehousing segment has been in need of a refresh. The company contends that a fragmented ecosystem of solutions based on legacy architectures has hindered efficiency and forced businesses to compromise on how quickly and easily they can derive insights from data.
Posted July 31, 2018
Splice Machine is releasing its intelligent application platform on the Microsoft Azure cloud service, giving customers another way to use the data platform while have the choice to deploy on-prem, AWS, or Azure. Splice Machine is a scale-out SQL data platform that can run fast OLTP and in-memory OLAP on the same platform, along with machine learning and streaming.
Posted July 26, 2018
There's a new generation of technologies reshaping data management as we know it. To explore some of the game-changing technologies or approaches that are having the most profound impact on today's enterprises, DBTA asked industry experts and leaders to cite what they see as having the most positive impact. The following are eight areas effecting the most change.
Posted July 25, 2018
MemSQL is updating its flagship platform, advancing its performance along with adding capabilities to accelerate time to insight. MemSQL 6.5 delivers an integrated database for data capture, management, and operations that integrates seamlessly with existing systems, infrastructure, and employee skills. This allows customers to get faster time to value and reduces cost and complexity.
Posted July 25, 2018
SolarWinds, a provider of IT management software, is launching SolarWinds Log Manager for Orion, a new, powerful log management tool for on-premises IT environments. Fully integrated with the SolarWinds Orion Platform, Log Manager is designed to provide the essential components an IT operations team needs for improved log monitoring, troubleshooting, and performance management.
Posted July 19, 2018
BlueData, provider container-based software for AI and Big Data workloads, will undertake a new open source Kubernetes initiative: BlueK8s. The company also introduced the first open source project in the BlueK8s initiative, Kubernetes Director (aka KubeDirector), for deploying and managing distributed stateful applications with Kubernetes.
Posted July 17, 2018
Periscope Data is launching a new machine learning (ML) solution that leverages Amazon SageMaker as part of a comprehensive offering for data teams looking to solve complex problems. Periscope Data's new functionality with Amazon SageMaker will allow data analysts to tackle ML problems in one seamless workflow, from data prep to model training to reporting.
Posted July 16, 2018
Immuta revealed it has raised $20 million in Series B funding, which will be used to accelerate global customer growth and extend product leadership. The funding round was led by DFJ Growth, with participation from new investors, Dell Technologies Capital and Citi Ventures, and existing investors, Drive Capital and Greycroft.
Posted June 20, 2018
Hewlett Packard Enterprise is planning to invest $4 billion in Intelligent Edge technologies and services over the next four years. Specifically, HPE will invest in research and development to advance and innovate new products, services and consumption models across a number of technology domains such as security, AI and machine learning, automation, and edge computing.
Posted June 20, 2018
AtScale has announced AtScale Cloud, a "one-click" solution for running complex big data workloads in the cloud. "In our work with some of the largest global brands, we saw firsthand the need to accelerate and simplify cloud migration across complex multi-faceted environments. It was important to us to enable our customers to make the most of their data, be it on premises, in the cloud, or both," said Dave Mariani, CEO and co-founder of AtScale.
Posted June 14, 2018
Dataguise and Snowflake have announced that Dataguise's DgSecure software has been integrated into Snowflake's cloud-based data warehousing platform to provide an end-to-end solution for compliance-ready data analytics to joint enterprise customers impacted by high levels of governmental oversight.
Posted June 12, 2018
Cloudera, Inc. is introducing new innovations to help businesses operationalize data insights faster by making data scientists and data engineers more productive. New machine learning capabilities make it easier for data scientists to quickly train and deploy models with higher confidence and lower risk.
Posted June 05, 2018
SolarWinds is making a series of updates to its network management product portfolio, allowing the platform to support networks up to four times larger. This improvement makes it easy to consolidate monitoring solutions to a single provider enterprise-wise, and gives IT professionals' far greater flexibility to scale up and support larger data center networks as workloads increase, or scale out to address complex distributed networks.
Posted June 04, 2018
With all of the data breaches and accusations of improper data usage in the news these days, the question of who owns data looms large. Understanding who owns which data is a complex question that can't be answered quickly or easily.
Posted June 01, 2018
It's spring-cleaning season, meaning many diligent homeowners are busy trying to organize their closets and homes in preparation for the spring and summer. Organizations, both small and large, also must keep up with cleaning their virtual dust bunnies on a regular basis, just as one would do within their own home.
Posted June 01, 2018
Kore Technologies, a provider of enterprise integration and eCommerce solutions, is releasing version 4.5 of Kourier Integrator Data Management, further enhancing cloud capabilities. Users will see new benefits for Amazon Web Services and Microsoft Azure. The update provides enhanced functionality and higher performance when doing integration and data warehousing with Microsoft SQL Server in the cloud.
Posted June 01, 2018
Looker, a data platform provider, is releasing new tools and integrations to optimize data science workflows. Looker is improving its governed data workflow with an SDK for R and connections for Python, as well as streamed and merged results, Google TensorFlow integrations, and clean, visual recommendations for users.
Posted May 30, 2018
Chris Reuter, North America data warehousing sales leader, IBM, presented a keynote at Data Summit 2018 on the key trends in IT today and what organizations must do to advance their organizations.
Posted May 24, 2018
Extending autonomous capabilities across its Cloud Platform, Oracle has announced the availability of Oracle Autonomous Analytics Cloud, Oracle Autonomous Integration Cloud, and Oracle Autonomous Visual Builder Cloud.
Posted May 16, 2018
We're all familiar with the IT "war room" scenario. When there's an issue, members of the IT team come together to troubleshoot and find a solution. For organizations with important applications, such as SQL Server running in virtual infrastructures, these IT teams are no strangers to the IT war room environment. In this case, input from the SQL Server system administrators and DBAs isn't considered (or even requested) when the infrastructure team implements it virtualization plan.
Posted May 07, 2018
HCL Technologies (HCL), along with Sumeru Equity Partners (SEP), a technology and growth-focused private equity firm, have signed a definitive agreement to acquire Actian Corporation. The all-cash deal is valued at $330 million.
Posted April 26, 2018
An astounding array of new technologies and approaches have emerged on the database scene over the past few years that promise to turn the next 12 months into a time of unprecedented transformation for the database landscape. There are new developments, along with reinforcement of tried-and-true technologies, some of which may help make the jobs of data managers just a bit easier.
Posted April 25, 2018
DBAs can recover a database, tune SQL, and may even know how to write some PL/SQL when push comes to shove. And, yes, those are all great skills to have. But in 2018, DBAs need more, writes Matt Malcheski in a new IOUG SELECT article. Malcheski goes over the "hot topics," including blockchain, AI, and Internet of Things, and notes that DBAs of the future will need to understand not only the technical aspects of these and the other technologies but also must be able understand and add value to the functional data requirements necessary for all-encompassing solutions. "This is characterized in a data point from Gartner: By 2021, 40% of IT staff will be 'versatilists' holding multiple roles, most of which will be business rather than technology related."
Posted April 18, 2018
Hitachi Consulting, a subsidiary of Hitachi, Ltd., a Platinum level member of Oracle PartnerNetwork (OPN), and provider of consulting-led solutions and services, has been named an OPN Cloud Elite partner. Joining a small number of Oracle partners who have attained this designation, Hitachi Consulting earned the status by achieving a set of criteria that demonstrate its full investment in Oracle Cloud solutions.
Posted April 18, 2018
As the volume and complexity around data grows, it has become more critical than ever for organizations to develop a deep knowledge of their business context and to understand and quantify the value of that data.
Posted April 18, 2018
Priority Software Ltd., a provider of ERP solutions, is releasing Priority v18.2, enhancing system openness and mobile capabilities, introducing a new document generator, and boosting support for regulations compliance.
Posted April 12, 2018
For data architects, it is not unusual to use a data modeling tool to reverse-engineer existing solutions' databases. The reverse-engineering could occur for a functional reason, such as gathering information to evaluate a replacement option, or to comprehend a solution, seeking to work out what data should be extracted for a downstream business intelligence need.
Posted April 12, 2018
Data lake is a newer IT term created for a new category of data store. But just what is a data lake? According to IBM, "a data lake is a storage repository that holds an enormous amount of raw or refined data in native format until it is accessed." That makes sense. I think the most important aspect of this definition is that data is stored in its "native format." The data is not manipulated or transformed in any meaningful way; it is simply stored and cataloged for future use.
Posted April 12, 2018
MicroStrategy, a provider of enterprise analytics and mobility software, is releasing an enhanced version of its flagship software, boosting mapping capabilities and more. Version 10.11 introduces new out-of-the-box visualizations, intelligent recommendations for content, prompts for dossiers, a native MicroStrategy Library app for smartphones, and more.
Posted April 10, 2018
SentryOne has launched new professional services offerings aimed at helping companies save time and resources in resolving SQL Server performance issues. While SentryOne has always offered service to customers who needed to supplement their internal structure with a deeper level of expertise in deploying monitoring tools, Pro Services formalizes the different levels of engagement options and provides access to the company's database administration experts, said Scott Brooks, SentryOne vice president of customer success.
Posted April 10, 2018
Redgate Software, a Microsoft SQL Server tools vendor, is updating its SQL Monitor solution, adding capabilities that allow it to integrate with the deployment tools in Redgate's portfolio. The new deployment capability is important because the increased frequency of releases that DevOps enables means companies and organizations are shifting from big deployments to smaller ones.
Posted March 27, 2018
We live in a new world today, with unique challenges heretofore unseen in information technology. To remain at the expected technological apex, organizations should ask themselves these questions.
Posted March 26, 2018
CloudJumper, a Workspace as a Service (WaaS) platform provider for agile business IT, is adding new features and capabilities to its Cloud Workspace WaaS and App Services platform. The newest generation of Cloud Workspace WaaS by CloudJumper reduces the costs and complexity associated with deploying WaaS in businesses ranging from SMBs to the enterprise.
Posted March 22, 2018
Syncsort, a provider of "Big Iron to Big Data" software, is releasing new innovations in its Ironstream data integration software. The new updates include the ability to deliver mainframe log and application data in real-time directly to Elastic Logstash.
Posted March 21, 2018
Every organization is unique. So is every Oracle user. Enter COLLABORATE 18: Technology and Applications Forum for the Oracle Community (April 22-26 in Las Vegas). Designed to serve the evolving educational needs of today's users, COLLABORATE offers 12,00 informative sessions and events carefully selected by volunteers, Oracle pros themselves, from a global call for content. While there's no "one-size-fits-all," there is something for everyone.
Posted March 14, 2018
BMC, a provider of IT solutions for the digital enterprise, is expanding its Control-M Managed File Transfer offering to include support for all file transfers from a single automation platform. With BMC's Control-M solution, companies have instant visibility into the status of file transfers and business application workloads.
Posted March 09, 2018