Database Management Articles
To serve the data analytics and applications for business growth and operational needs, data lakes are being widely adopted as the data infrastructure because of their scalability and flexibility. Data lakes are strong at parking petabytes of data and production delivery as a result of their "schema-on-read" structure. But every coin has two sides. Data lakes, as a semantically flexible data store and bypassed governance efforts, have been seen as muddy swamps and inefficient in data management.
Posted June 02, 2022
Data archiving is an important aspect of data governance and data management. Not only does archiving help to reduce hardware and storage costs, but it is also an important aspect of long-term data retention and a key participant in regulatory compliance efforts. When long-term data retention is imposed on your data—anything more than a couple of years—then archiving it can be the most optimal solution.
Posted June 02, 2022
The SQL language served as a universal language for database manipulation from the mid-1980s until NoSQL databases started gaining strength about 12 years ago. However, after a short period in the wilderness, SQL is back and possibly more vital than ever.
Posted June 02, 2022
Data plays a vital role in any successful business. Protecting this data is mission-critical, and it falls to database administrators (DBAs) to organize, maintain, and secure it. The most effective way for DBAs to protect data is through database backups, a process designed to copy the data and schema from an existing database and save it elsewhere for future retrieval. Like any process in IT, however, there are a few factors to consider when devising a database backup strategy to ensure it meets your business needs.
Posted June 02, 2022
Broadcom Inc., a global technology provider that designs, develops, and supplies semiconductor and infrastructure software solutions, announced it is acquiring VMware, Inc., an innovator in enterprise software. Broadcom will acquire all of the outstanding shares of VMware in a cash-and-stock transaction that values VMware at approximately $61 billion, based on the closing price of Broadcom common stock on May 25, 2022. In addition, Broadcom will assume $8 billion of VMware net debt.
Posted June 02, 2022
Entrinsik is offering native support for jBase, enabling users to speak directly to their target database in the appropriate query language. Entrinsik already provides native support for UniData and UniVerse.
Posted June 02, 2022
Companies now collect more data than ever before, but challenges remain for accessing and analyzing them. David Armlin, VP solution architect and customer success, ChaosSearch, discussed "Learn, Unlearn, Relearn: Embracing the Future of Cloud Analytics," during his Data Summit 2022 session.
Posted June 02, 2022
There are so many new buzzwords lately, including the data lakehouse, data mesh, and data fabric, just to name a few. But what do all these terms mean, and how do they compare to a data warehouse? This presentation covers all of them in detail and explains the pros and cons of each, with suggested use cases so attendees can see what approach will really work best for their big data needs.
Posted June 02, 2022
Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Managed Instances. This DMV consolidates and simplifies telemetry from SQL Server ring buffers, applies heuristics, and provides a result set. The DMV stores a record for each out-of-memory (OOM) event that occurs within the database, providing details about the OOM root cause, the memory consumption of database engine components at that point in time, potential sources of memory leaks, and more.
Posted June 02, 2022
PlanetScale, the serverless database provider powered by MySQL and Vitess, is offering a number of new innovations that accelerate delivery of "The Future Database," with new Insights providing granular performance visibility, Portals for multi-region deployment, and Connect enabling expansive analytics platform integrations.
Posted June 02, 2022
Data Intensity recently announced its deepened commitment to accelerate and transform Oracle-powered workloads to Oracle Cloud Infrastructure (OCI), combining a strategic partnership with its own migration and lifecycle management portfolio of expert technical and functional support services.
Posted June 01, 2022
Redgate Software's SQL Data Catalog now provides a simple, policy-driven approach to data protection. Along with automatically scanning columns within databases and using intelligent rules to make recommendations about how they should be classified, the platform now auto-generates static data masking sets from the classification metadata that can be used to protect the databases.
Posted May 31, 2022
Deepnote, an early-stage startup backed by Accel and Index Ventures, is emerging from beta with version 1.0, opening up to the general availability of collaborative data science notebooks to data teams worldwide. Since the company's Series A announcement in Jan 2022, Deepnote has added many features going into the 1.0 launch. Most notably is the addition of Deepnote Workspaces, which empowers data teams to organize and surface data projects, notebooks, and apps in one place.
Posted May 31, 2022
Cloudian's HyperStore object storage platform is now integrated and validated to work with Microsoft SQL Server 2022, a relational database management system that supports a wide variety of transaction processing, business intelligence, and analytics applications.
Posted May 31, 2022
IBM has announced the expansion of its road map for achieving large-scale, practical quantum computing. IBM originally announced its quantum road map in 2020, and, since then, the company said, it has delivered on each of the targets on its timeline. "In just 2 years, our team has made incredible progress on our existing quantum road map. Executing on our vision has given us clear visibility into the future of quantum and what it will take to get us to the practical quantum computing era," said Darío Gil, senior vice president, director of research, IBM.
Posted May 31, 2022
Software licensing has always been tricky but today there are many new risks to guard against. At Data Summit 2022, Dr. Michael Corey, chief operating officer, LicenseFortress, and Don Sullivan, senior product line marketing manager & chief of staff for Business Critical Applications, Cloud Infrastructure Business Group (CIBG), VMware, presented a session on the rise of software license trolls and simple steps to take to ensure your organization is not their next victim.
Posted May 31, 2022
IBM and SAP announced their partnership has reached a new milestone as IBM undertakes one of the world's largest corporate transformation projects based on SAP ERP software, designed to fuel the company's growth and better support its clients.
Posted May 31, 2022
Apollo GraphQL is offering supergraph, a network of a company's data, microservices, and digital capabilities that empowers product and engineering teams to quickly create incredible experiences for their customers. A supergraph acts as a composition layer facilitating collaboration between backend data and services, and frontend apps and devices.
Posted May 26, 2022
Cohesity, a provider of next-gen data management, is partnering with Palo Alto Networks to integrate its Cohesity Helios next-gen data management platform with Palo Alto Networks' Cortex XSOAR security orchestration, automation, and response (SOAR) platform for improved ransomware detection and recovery.
Posted May 26, 2022
Next Pathway Inc., the Automated Cloud Migration company, is extending the capabilities of its cloud migration planning tool, Crawler360. In this latest release, Next Pathway has improved and expanded the visualization capabilities of this tool, giving clients better insights into the dependencies across data pipelines in legacy data warehouses and data lakes.
Posted May 26, 2022
Druva Inc. is signing a multi-year global Strategic Collaboration Agreement (SCA) with Amazon Web Services, Inc. (AWS) to accelerate customer migration and provide an added layer of cyber resiliency to the already secure AWS Cloud. Built on the existing relationship between Druva and AWS, this agreement underscores both companies' commitment to delivering a cloud-native data protection solution on AWS, and supporting enterprises during critical phases of the cloud journey, including support for workload migration and deployments.
Posted May 26, 2022
Dell Technologies revealed it will deliver new cloud experiences, an expanded ecosystem, and offerings to help customers manage and protect applications across data centers and multi-cloud environments. These new offerings are designed to help organizations easily store, protect, and control their data and applications across an increasing number of platforms and locations, according to the vendor.
Posted May 26, 2022
TigerGraph, provider of a leading graph analytics platform, is introducing the TigerGraph ML (Machine Learning) Workbench—a powerful toolkit that enables data scientists to significantly improve ML model accuracy, shorten development cycles, and deliver more value to the business.
Posted May 25, 2022
SAP is introducing new innovations that deliver business value for customers in four critical areas: supply chain resilience, sustainability, business process transformation, and no-code application development. The innovations announced will help SAP customers accelerate their transformation journey with cloud-based solutions that provide the end-to-end business process support customers most need, according to the vendor.
Posted May 25, 2022
Tamr, a cloud-native data mastering solution, is offering Tamr Enrich, a set of enrichment services built natively into the data mastering process using Tamr's patented human-guided machine learning. Tamr Enrich curates and actively manages external datasets and services, enabling customers to seamlessly embed trusted, high-quality external data insights to their data mastering pipelines for richer business.
Posted May 24, 2022
Equalum, a provider of data integration and ingestion solutions, is expanding modern data integration support and introducing a next-gen design solution for optimal data loading to GCP's Big Query, Google Cloud Storage, Cloud SQL, as well as other cloud platforms such as Microsoft Azure and AWS.
Posted May 24, 2022
Matillion, provider of an enterprise cloud data integration platform, is releasing Matillion Data Loader 2.0, empowering enterprises to simplify data ingestion and accelerate insights with a cloud-native, no-code experience. Matillion Data Loader provides a single unified experience across batch loading and real-time, log-based change data capture (CDC) pipelines, and a consumption-based pricing model to help customers better manage data integration costs.
Posted May 24, 2022
ScaleFlux, Inc., a provider deploying SSDs with computational storage at scale, is introducing its ScaleFlux Partner Program, giving customers broad access to the easiest approach to coping with data growth.
Posted May 23, 2022
Push Technology, a provider of real-time data streaming and messaging solutions, is releasing Diffusion 6.8, adding new features that include the Diffusion Gateway Framework, expanded data wrangling calculations and conditionals, and journal logging.
Posted May 20, 2022
Thrive, a leading Managed Security Services Providers (MSSPs), is upgrading its 24x7x365, eyes-on-glass Security Operation Center (SOC) by integrating a Security Orchestration, Automation, and Response (SOAR) engine. The SOAR capabilities will enable the Thrive global security team to better navigate complex, risk-laden environments for clients via tool aggregation and coordinated response, unified operations, reduced alert fatigue, and Artificial Intelligence (AI).
Posted May 19, 2022
A common pattern in data lake and lakehouse design is structuring data into zones, with bronze, silver, and gold being typical labels. Each zone is suitable for different workloads and different consumers. For instance, machine learning algorithms typically process against bronze or silver, while analytic dashboards often query gold. This prompts the question: Which layer is best suited for applying data quality rules and actions? The answer: All of them.
Posted May 18, 2022
Data consumers need data for BI and analytics to make business decisions. But for most organizations, their current data infrastructure isn't keeping up with demand. In a presentation at Data Summit 2022, titled "Building the Open Data Lakehouse," Mark Lyons, senior director, product management, Dremio, explained why more organizations are moving their analytics and BI to an open data lakehouse and how you can build a successful lakehouse strategy.
Posted May 18, 2022
As sensor technology becomes more affordable, companies of all sizes will have the ability to embrace IoT strategies to build innovative products and services and establish new revenue streams. Yet, as with any promising technology, challenges remain. At Data Summit 2022, Paul Scott-Murphy, CTO, WANdisco discussed "Solving the IoT Data Management Puzzle With Gateways to the Cloud."
Posted May 18, 2022
Wednesday's Data Summit 2022 keynotes opened with Laura Sebastian-Coleman, data quality director, Prudential Financial, who discussed "Data Quality Deniers & What We Learn From Them." One of the biggest organizational obstacles to data quality management is basic pessimism about the possibility of managing the quality of data. This is due to lack of clarity—the goals and processes for data quality management have not been defined or have not been understood—and disbelief that the quality of data could be subject to control.
Posted May 18, 2022
Oracle announced it has updated Oracle Service to embed data from Oracle Unity Customer Data Platform (CDP), helping customer service agents gain a complete view of the customer, improve agent efficiency, and enhance service quality. Part of Oracle Fusion Cloud Customer Experience (CX), Oracle Service and Oracle Unity CDP leverage artificial intelligence to help organizations deliver more personalized, informed, and efficient customer service engagements, according to the vendor.
Posted May 18, 2022
AlmaLinux OS Foundation, the nonprofit that stewards the community owned and governed open source CentOS replacement AlmaLinux, announced that AlmaLinux is now available on the Oracle Cloud Infrastructure (OCI) marketplace. It is focused on long-term stability and delivering a robust production-grade platform.
Posted May 18, 2022
No other subject seems to capture the attention of IT leaders right now like database migrations. If there were an IT theme for 2022, it would be: Enterprises migrate from legacy data warehouses to the cloud. And it is no longer just the "early adopters" but the entire customer base that is looking to make the move to cloud-based systems. Let's examine the three most common problems that hamper the execution of migration projects and what can be done to avert migration disasters.
Posted May 18, 2022
To turn data into insights and leverage the wealth of information that they are collecting, organizations need to ensure that their data is up-to-date and trustworthy. There is no magic answer. It's a combination of technology and processes. Kevin Campbell, CEO of Syniti, and Phil Fersht, CEO and chief analyst at HFS Research, discussed data value research conducted with Global 2000 C-level executives during their Data Summit 2022 presentation, "Every Problem Is a Data Problem: How Bad Data Is Killing Your Business."
Posted May 17, 2022
"Every company is a data company," Keith Alsheimer, head of marketing, Unravel Data during his Data Summit 2022 presentation. Alsheimer and Chris Santiago, VP solutions engineering, Unravel Data, discussed DataOps and how it can solve big data problems during the presentation. The annual Data Summit conference returned in-person to Boston, May 17-18, 2022, with pre-conference workshops on May 16.
Posted May 17, 2022
At Data Summit 2022, Chris Bergh, CEO and head chef of DataKitchen, shared how to build an internal business case and ways to collect small wins that illustrate the benefits of DataOps at your organization.
Posted May 17, 2022
Data projects that are completed on time, address changing requirements, and deliver value in the real world require a combination of skills and technologies, as well as the right people, according to Marilyn Moise Rousseau, corporate manager database operations, Baptist Health South Florida, who spoke at Data Summit 2022.
Posted May 17, 2022