Data Modeling Articles
Last year picked up where 2020 left off. Though pandemic restrictions have eased, 2022 looks to be another uncertain year with the rise of the omicron variant. As we begin 2022, DBTA presents the annual MultiValue Special Report and asks MV executives to address several questions.
Posted February 23, 2022
Micro Focus has announced the results of its new COBOL survey that reveals the latest global developments and 2022 plans for enterprises utilizing COBOL and mainframe technology. The survey found that not only is COBOL continually viewed as strategic by 92% of respondents, but that the amount of COBOL code has significantly increased.
Posted February 22, 2022
Data management has never been so unfettered—and yet so complicated at the same time. An emerging generation of tools and platforms is helping enterprises to get more value from their data than ever. These solutions now support and automate a large swath of structural activities, from data ingestion to storage, and also enhance business-focused operations such as advanced analytics, AI, machine learning, and continuous real-time intelligence.
Posted February 22, 2022
The costs of downtime—even for a minute—are simply too steep for today's digitally evolving enterprises to tolerate. As part of their efforts to keep expensive downtime at bay—and ensure the continued viability and availability of data—data managers are increasingly turning to strategies such as automation and cloud services. Still, they continue to have difficulties and acknowledge that keeping their data environments up-to-date is holding them back from delivering more capabilities to their organizations.
Posted February 16, 2022
Wallaroo Labs, Inc., announced it has closed $25 million in a Series A funding round, enabling the company to expand product, sales, and marketing, and to release a free community edition of its machine learning platform. The funding round was led by Microsoft's venture arm, M12. New investors Ridgeline Partners and NSS Advisors joined existing seed investors Boldstart Ventures, Contour Venture Partners, Eniac Ventures, and Greycroft as part of the round.
Posted February 11, 2022
It's time to submit nominations for the annual Database Trends and Applications Readers' Choice Awards, a competition in which the winning information management solutions, products, and services are selected by you, the users.
Posted February 09, 2022
As an industry, we've been talking about the promise of data lakes for more than a decade. It's a fantastic concept—to put an end to data silos with a single repository for big data analytics. Imagine having a singular place to house all your data for analytics to support product-led growth and business insight.
Posted February 08, 2022
In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability (GA) product, but the specific release date has not yet been disclosed. We can expect to see a variety of the announced features in the next major release deployed to Azure SQL customers. Microsoft has a long history of deploying new features to the Azure cloud far in advance of the on-prem products.
Posted February 08, 2022
Most database administrators know database servers didn't initially come in a cloud or cluster. Once upon a time, DBAs had to reconfigure disk files and handle data manually. Now, with virtualization and the shift toward the cloud, the evolution of database administration yields more opportunities to automate tasks and fewer reasons for DBAs to get their hands dirty.
Posted February 08, 2022
Oracle Autonomous Database is a fully managed cloud service. It is a combination of Exadata infrastructure automation, Oracle Database 19c automation, and automated data center operations and machine learning. During Quest Experience Week 2021, Gerald Venzl, distinguished product manager at Oracle, shared how Oracle Autonomous Database simplifies the management of operational and analytical database workloads and how innovation continues to improve analyst, data scientist, and developer productivity.
Posted February 08, 2022
The old Chinese expression "May you live in interesting times" has never been more applicable in my lifetime than in 2020 and 2021. The global pandemic combined periods of great anxiety with long stretches of mind-numbing lockdown boredom. But it certainly kept our attention!
Posted February 08, 2022
Folks relate to physical tables; even the most non-relational-minded person can picture a fixed structure file and equate that to a table and its columns. The spreadsheet image is ubiquitous. DBMS-defined views are logically similar to tablesand in usage are certainly interchangeable with tables.
Posted February 08, 2022
VAST Data, the storage software company, announced it is broadening its international expansion plans, continuing to disrupt and modernize the legacy storage infrastructure market. VAST has opened up operations in the UK, France, Germany, Israel, Turkey, Czech Republic, Middle East, Australia, New Zealand, Russia, and Korea. These will now be followed by further expansion across EMEA with Benelux, Switzerland, Italy, Spain and the Nordics, and in Asia with Japan.
Posted February 08, 2022
Each year, Data Summit features industry-leading experts covering the topics that matter most for data professionals who want to stay on top of the latest technologies and strategies. The conference program is now available for review, and a variety of pass options are being offered, including special pricing for attendees who register early.
Posted February 08, 2022
NVIDIA announced that its AI Enterprise 1.1 is now generally available, bringing new updates including production support for containerized AI with the NVIDIA software on VMware vSphere with Tanzu, which was previously only available on a trial basis. Now, enterprises can run accelerated AI workloads on vSphere, running in both Kubernetes containers and virtual machines with NVIDIA AI Enterprise to support advanced AI development on mainstream IT infrastructure.
Posted February 07, 2022
Directus, a software company democratizing the future of data management, is releasing Directus 9, an Open Data Platform that can power any data driven app or digital experience. With a new codebase built on Node.js and Vue.js 3, Directus 9 achieves higher performance than previous versions for near-instant SQL query responses, whether browsing vast datasets in the Directus app or performing deeply nested relational API requests, according to the vendor.
Posted February 02, 2022
StorCentric, provider of a comprehensive portfolio of secure data management solutions, is making enhancements to its Global Nexsan Partner Program, introducing the Nexsan Partner Certification Program. The new program enables Nexsan channel partners to further enhance their ability to serve end clients' data management and security needs, fortify their trusted advisor status, and drive additional business opportunities.
Posted January 28, 2022
Domino Data Lab, provider of an Enterprise MLOps platform, is releasing Domino 5.0 with new capabilities that unleash model velocity, a metric of how fast data science teams build and update models. Domino 5.0 is also the validated and integrated with NVIDIA AI Enterprise, an end-to-end software suite optimized to run AI workloads with VMWare vSphere with Tanzu, on mainstream data center servers.
Posted January 26, 2022
Zumasys is acquiring the assets of Efficiency Partners, an Independent Software Vendor (ISV), enabling the company to add the Crescendo platform to its portfolio. Crescendo is an ERP software solution designed for manufacturers, distributors, and service companies.
Posted January 26, 2022
Sync Computing, a deep tech distributed cloud infrastructure company, is emerging from stealth mode, revealing its initial products and $6.1 million funding. Sync Computing is using the new capital to advance its leadership in the modern data infrastructure space and support further development of its accelerated data infrastructure engine and solution lines.
Posted January 25, 2022
Coalesce, the data transformation company, is emerging from stealth with the launch of the Coalesce Data Transformation platform, simplifying the modeling, cleansing, governance, and documentation of data. The Coalesce platform dramatically increases data engineer productivity and insights to tackle today's data-intensive architectures—enabling data transformations at enterprise scale, according to the vendor.
Posted January 21, 2022
Deci, a deep learning development company harnessing Artificial Intelligence (AI) to build AI, is releasing SuperGradients, an "all-in-one" deep learning training library for computer vision models. SuperGradients enables developers to train PyTorch-based models for the most common computer vision tasks, including object detection, image classification, and semantic segmentation with just one training script.
Posted January 21, 2022
IT environments are exploding. There is more data than ever before, in more places than ever before. Unfortunately, managing backup and recovery with legacy tools has proven complex and often lacks the visibility and security needed for IT teams to keep pace with their business. Frank Schwaak, senior solution architect, Oracle/SAP, at Rubrik, and Vigyan Jain, data management solutions architect, Asia Pacific and Japan, at Rubrik, recently discussed the importance of unifying backup and recovery with SaaS and what it means for the business.
Posted January 18, 2022
The noted motivational speaker and author Zig Ziglar was quoted as saying, "When obstacles arise, you change your direction to reach your goal; you do not change your decision to get there." This sentiment rings truer today than ever. In the past 21 months, companies across every industry have had to alter their "go-to-market" strategies to simply survive. For the local diner, this may have initially meant relying on take-out orders, then finding ways to create outdoor seating areas, and later dealing with the weather inconveniently imposing itself on outdoor patrons. For much of corporate America, changing their company's direction to reach their goals has meant converting traditional workforces to remote employees.
Posted January 18, 2022
The ultimate goal of almost all enterprise technology is to automate manual activities into digital processes. BPM (business process management) and workflow systems have been used for decades, and, under the cover of most business applications, sit complex process, task, and workflow management. It is hard to define the sheer scale and breadth of process automation other than to say that it is pervasive. Indeed, although industry analysts love to slice and dice technologies into quadrant and wave silos, doing so with process automation technology is difficult and often, though not deliberately, misleading.
Posted January 17, 2022
From data warehouses to data lakes, there is a growing array of choices when it comes to cloud platforms, deployment models, and features. At the same time, challenges remain, including data integration and governance, performance, and management and monitoring. DBTA held a roundtable webinar featuring Anand Rao, director, product marketing, Qlik; Lewis Carr, senior director, product marketing, Actian; and Thomas Hazel, founder, CTO, and chief scientist, ChaosSearch, who discussed key solutions and best practices for succeeding with modern analytics today.
Posted January 17, 2022
Modernizing applications means delivering an architecture that is flexible and scalable. NoSQL databases, such as document databases, support a flexible schema and scale out architecture. When deployed in a microservices environment, teams are empowered for rapid application development, and can build applications that meet the performance requirements of their customers.
Posted January 07, 2022
As many tools and platforms have evolved to solve niche problem areas, they are fairly disconnected, creating more confusion for data leaders to decide what tools and platforms are needed to support end-to-end business needs. In simple terms, XOps can be broken down to "X" related to data, infrastructure, business intelligence (BI), and machine learning (ML) models, and "Ops" is the automation via code. The individual component has existed for years, but the difference now is they are interconnected to drive agility and innovation by removing silos.
Posted January 05, 2022
Dealing with data warehouses, data marts, and even data lakes, can be awkward in an agile environment. While adding a single metric onto a dashboard can be very natural, no one builds a dimension table a few columns at a time. This awkwardness has caused many variants in how an agile methodology might be applied to one's analytics databases.
Posted January 03, 2022
The design of a schema in MongoDB is just as important as it is in RDBMS. Indeed, schema design can be even more complicated in MongoDB. At least in SQL databases, we have the "first normal form" representing the starting point for a well-designed first cut data model. In MongoDB, we have more choices, but as a consequence, we have more potential pitfalls.
Posted January 03, 2022
Over the past year, enterprise digital transformation efforts have accelerated dramatically with a substantial focus on not only how data is managed and stored, but how data is leveraged to deliver business insights. DataOps continues to gain a foothold at organizations hungry for speed, agility, and innovation. The adoption of machine learning and complementary technologies, such as knowledge graphs, is on the rise.
Posted December 20, 2021
Tellius, the AI-driven decision intelligence platform, is introducing Live Insights, a new capability for users to quickly generate powerful data analysis within their cloud data warehouses. This new feature leverages the compute power of cloud data platforms for automated generation of advanced insights without requiring data to be extracted from these systems, fueling faster, better decision making, according to the vendor.
Posted December 20, 2021
Vivanti—the enterprise technology consultancy delivering impactful cloud experiences and data-driven innovations with a client-first ethical framework—is officially launching in the United States. Headquartered in New York City, with locations in Manhattan and Washington DC, Vivanti offers advisory, consulting, and managed services across all major cloud platforms, including Snowflake, HashiCorp, Google Cloud, Amazon Web Services, Microsoft Azure, IBM Cloud, and more.
Posted December 17, 2021
Redgate Software, a provider of Database DevOps solutions, is joining other business software providers such as Microsoft, Sage, and Adobe, in moving to a subscription-first model. From January 2022, the majority of its product portfolio will be offered on a subscription-first basis, rather than solely under a perpetual license agreement.
Posted December 16, 2021
Sisense, providing an AI-driven platform for infusing analytics everywhere, is offering Sisense Notebooks, a new code-first functionality within Sisense Fusion Analytics that empowers data analysts with the tools they need to conduct advanced analysis using Structured Query Language (SQL) and Python.
Posted December 16, 2021
Enterprises walk a knife edge when it comes to digital transformation. They must scale their operations on the cloud, but somehow minimize complexity and disruptions. The discipline of cloud operations (CloudOps) aims to strike the right balance by intelligently provisioning resources, utilizing capacity, and mitigating issues-all with the help of cloud log analytics.
Posted December 16, 2021
Altair, the global leader converging simulation, HPC, and AI, is acquiring World Programming, a UK-based technology company specializing in data analytics software. World Programming's platform supports development and execution of multi-language software solutions leveraging popular languages used in data science including Python, R, and the SAS language in a single program.
Posted December 15, 2021
The Data Summit conference focuses on the business and technical aspects of Big Data, Data Management, DevOps, Data Management, AI, Machine Learning, and the ramifications of working in a data-driven environment.
Posted December 15, 2021
Sierra Digital, Inc., Houston-based specialists in digital transformation, is launching APPRISE, an Accelerated Productivity Platform designed to speed and automate SAP's signature digital transformation program called RISE. RISE delivers business transformation as a service in a unified package to help change the mindset of business users, redesign business processes, and reduce internal complexity.
Posted December 15, 2021
SAP is rolling out new products and services that empower citizen and professional developers to accelerate digital transformation. SAP's announcements tackle the talent gap with new tools, integrations, embedded AI, and learning programs to help both employees and applicants build new skills for the cloud-first era.
Posted December 15, 2021
Using surrogate keys within a database is often considered a technique to improve performance. The assumption is that using anything other than a numeric data value to join tables provides "bad" performance. Therefore, whatever the natural key may be—one column, multiple columns, alphanumeric, etc.—the surrogate key can be a 100% numeric single value, standing in for that natural key value set. Some DBMSs have key generators that are numeric, others may be more wide-ranging in values. Some organizations may choose to use surrogate keys generated from hashed natural key values. Will surrogate keys improve everyone's query performance? As with the stock market, specific circumstances differ everywhere, so the individual results may vary.
Posted December 08, 2021
Accenture and UiPath, an enterprise automation software company, are expanding their business collaboration to help companies boost the adoption of enterprise-wide automation, accelerate technology transformation efforts, and create new growth opportunities.
Posted December 08, 2021
The importance of leveraging data quickly and effectively is a message that has come through loud and clear in recent years—and with increasing intensity since the onset of the COVID-19 pandemic. Whether it is anticipating supply chain problems, addressing customer concerns with agility, or identifying new opportunities and pouncing quickly, the ability to achieve a comprehensive view of all available information for real-time decision making has become a strong theme. To help make the process of identifying useful products and services easier, here, DBTA presents a list of Trend-Setting Products for 2022.
Posted December 08, 2021