Newsletters




Data Modeling

Data Modeling and Database Design and Development – including popular approaches such as Agile and Waterfall design - provide the basis for the Visualization, and Management of, Business Data in support of initiatives such a Big Data Analytics, Business Intelligence, Data Governance, Data Security, and other enterprise-wide data-driven objectives.



Data Modeling Articles

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 nat­ural 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

AI and machine learning are continuing their upward trajectory at companies already pushed to the limit from COVID-19 transformation and disruption. However, experts say that as businesses look to leverage AI for a growing number of increasingly sophisticated applications, they need to take a more data-centric approach to development.

Posted December 06, 2021

The open source enterprise-class database with data immutability at scale, immudb, can now be deployed in cluster configurations for demanding applications that require high scalabilityand high availability. Codenotary's immudb 1.1 update also enables databases to use Amazon's S3 storage cloud so they will never run out of disk space.

Posted December 01, 2021

MathWorks is the developer of mathematical computing software for engineers and scientists, whose flagship product is MATLAB. Recently, Heather Gorr, Ph.D., senior MATLAB product manager, MathWorks, discussed the importance of streaming high-frequency data, data preparation for machine learning, and best practices for putting it all together to implement a successful AI model. 

Posted November 30, 2021

At AWS re:Invent, Amazon Web Services, Inc., an Amazon.com, Inc. company, unveiled the new Amazon CodeGuru Reviewer Secrets Detector, an automated tool that helps developers detect secrets in source code or configuration files, such as passwords, API keys, SSH keys, and access tokens. The new Secrets Detector tool uses ML to identify hard-coded secrets as part of the code review process, ultimately helping to avoid problems before being merged and deployed. 

Posted November 30, 2021

Cloudreach, an independent multi-cloud services company, is releasing SMART Management, a next-generation managed service fit for the age of true business transformation built on the cloud. SMART Management brings together all of Cloudreach's expertise in cloud professional and managed services, and delivers them as a simple and flexible service designed to help organizations accelerate their cloud transformation projects.

Posted November 30, 2021

PingCAP, a distributed SQL provider, is offering a new Developer Tier for TiDB Cloud, enabling developers to easily launch a small TiDB cluster for free for up to one year.  Through this offering, PingCAP is breaking down the adoption barrier for TiDB, providing the crucial time developers need to experiment first-hand how TiDB and TiDB Cloud can support their mission-critical applications and workloads, while providing decision makers a time frame to properly evaluate and determine where TiDB delivers the highest ROI for their needs, according to the vendor.

Posted November 30, 2021

LogicMonitor, a SaaS-based multi-tenant infrastructure monitoring and observability platform for enterprises and managed service providers (MSPs), is offering unlimited log data retention, now available for LM Logs, the company's SaaS-based log management solution.

Posted November 22, 2021

With heightened pressure to compete on analytics, the purpose and role of data architecture is coming into clearer focus to meet business operating necessities. Recently, John O'Brien, CEO and principal advisor of Radiant Advisors, talked with BDQ about the principles of a resilient enterprise data architecture and the enabling methodologies and technologies.

Posted November 11, 2021

MemVerge is introducing its Big Memory Cloud technology, bringing Big Memory Computing to multi-cloud environments. With Big Memory Cloud technology stateful, non-fault-tolerant, and long-running apps can now realize the promise of cloud agility and flexibility, according to the vendor.

Posted November 08, 2021

Talend, a global leader in data integration and data integrity, is introducing its Fall '21 release, offering new service, product, and packaging innovations. With this release, Talend applies data health concepts across its platform to help everyone from business leaders to data professionals realize value from their data quickly.

Posted November 04, 2021

NS1, a provider in application traffic intelligence and automation, is releasing its cloud-managed solution for DNS, DHCP, and IP address management (DDI), delivered through the NS1 Connect platform. NS1 Cloud-Managed DDI enables organizations to deliver core network services across their distributed network footprint with the agility of software-based deployment, the scale of cloud-native operations, and the operating efficiency of SaaS management, according to the company.

Posted November 03, 2021

When normalizing data structures, attributes congregate around the business keys that identify the grain at which those attributes derive their values. Attributes directly related to a person, deriving their value from that individual, will appear on an Employee entity, or a Customer entity, and so forth. However, in the process of normalizing, the data modeler must identify the objects that are meaningful and useful to the organization

Posted November 01, 2021

Tata Consultancy Services (TCS), a global IT services, consulting, and business solutions organization, has released a major new version of TCS MasterCraft TransformPlus, which leverages machine learning algorithms to more effectively analyze applications during modernization. This enriches user annotation in both program flow and technical specification documentation during the analysis of COBOL applications.

Posted November 01, 2021

Amazon Web Services, Inc. (AWS), an Amazon.com, Inc. company, is releasing Amazon Elastic Compute Cloud (Amazon EC2) DL1 instances, a new instance type designed for training machine learning models. DL1 instances are powered by Gaudi accelerators from Habana Labs (an Intel company) to provide up to 40% better price performance for training machine learning models than the latest GPU-powered Amazon EC2 instances, according to AWS.

Posted October 28, 2021

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Sponsors