Data Modeling Articles
The lines between entities within an Entity-Relationship Diagram [ERD] represent an interdependency between the involved entities. In a normalized designed, this interdependency is both semantic and functional, as in, "a HOUSE has one-or-more DOORs," "an ORDER has one-or-more ORDER LINEs," or "a STUDENT enrolls in zero-to-many CLASSes." These object pairings would have a line drawn between them in an ERD representation. There also would be markings from whatever notation one is employing, designating the "one" side of the relationship and the "many" side of the relationship.
Posted September 18, 2024
JFrog, the Liquid Software company and creator of the JFrog Software Supply Chain Platform, is announcing a series of updates—from integrations with major providers to new security features—that serve to drive productivity, reduce complexity, and provide robust security across the development cycle.
Posted September 17, 2024
Redpanda, the all-in-one streaming data platform, is unveiling a variety of new AI integrations available within Redpanda Connect, a lightweight yet powerful integration framework written in Golang offering a collection of sources, sinks, and processors that power real-time data and AI pipelines. By expanding AI connectivity with cloud availability—as well as launching a series of other innovations—Redpanda continues to help customers integrate disparate systems in the blink of an eye, according to the company.
Posted September 16, 2024
HCLSoftware, the software business division of HCLTech, is announcing that it has acquired Zeenea, an innovator in data catalog and governance solutions. This acquisition positions Actian—a division of HCLSoftware—to deliver a complete data ecosystem for its customers, driven by seamless discovery and governance of their data assets, according to the company.
Posted September 16, 2024
Crunchy Data, a provider of trusted open source Postgres technology and products, is debuting Crunchy Bridge for Analytics to provide enhanced spatial data analytics capabilities, making it one of the easiest-to-use and most powerful platforms for working with geospatial data.
Posted September 13, 2024
With more and more use cases for AI and all its branches taking shape, big data is surging in relevance as the backbone of these projects—prompting DBAs, IT, data scientists, and more to take a closer look at the information being fed into their forecasts and models. To support organizations in navigating through new challenges and a rapidly evolving big data ecosystem, Big Data Quarterly presents 2024's "Big Data 75," a list of companies driving innovation and expanding what is possible in terms of collecting, storing, and extracting value from data.
Posted September 12, 2024
Vantiq, a leader in real-time intelligent platforms for smart applications, and Blaize, Inc., a provider of purpose-built, artificial intelligence (AI)-enabled edge computing solutions, are collaborating to create an AI-enabled chip loaded with intelligent software and unmatched computing power, all at an accessible price point.
Posted September 12, 2024
In DBTA's webinar, Modern Data Architecture for AI, John O'Brien, principal advisor and industry analyst at Radiant Advisors, led experts through a thorough discussion of how to cultivate the right data infrastructure to support AI initiatives, from leading best practices to key technologies.
Posted September 12, 2024
Rocket Software released Rocket UniVerse 14.1.1, featuring enhanced performance, security, and modernization. Emma Breslin from the Rocket Software MultiValue (MV) team offered an inside look at what makes this version a must-have upgrade for current users.
Posted September 12, 2024
appCD, the generative infrastructure from code company, is announcing the results of its latest seed funding round—having raised $12.3 million—as well as the debut of its new identity, StackGen. The rebranding and latest funding round propels StackGen to continue its journey toward transforming infrastructure from code, focusing on empowering developer workflows while helping them adapt to the latest in AI innovations.
Posted September 11, 2024
IBM is adding a new feature update to watsonx.ai that delivers an open framework, giving users access to a catalogue of built-in models and patterns that can be seamlessly extended through a "build your own model" capability. Users can now do even more with IBM's enterprise AI studio; they can upload and deploy their own custom foundation models across software and SaaS environments.
Posted September 09, 2024
IBM is unveiling new processor innovations designed to accelerate AI initiatives across next-generation IBM Z mainframe systems. The new technologies—IBM Telum II processor, IO acceleration unit, and IBM Spyre accelerator—serve to improve latency, sustainability, and scale processing capacity to better accommodate the demands of AI and large language models (LLMs).
Posted September 09, 2024
Revefi, the company enabling businesses to maximize ROI on their data investments, is announcing the launch of Raden, the world's first AI data engineer designed to complement traditional data engineers and enhance their overall efficacy. As the scope of the data engineer's workload has significantly broadened, Raden offers "distinguished engineer" expertise as a comprehensive, zero-touch, zero-data-access AI solution that delivers automations across the entire data lifecycle.
Posted September 04, 2024
Tabnine, the originators of the AI code assistant category, is announcing several ecosystem updates that forward Tabnine's mission to help developers maintain control over code while future-proofing AI investments. These announcements—which include a new platform partnership with Broadcom Inc., an integration with IBM, and an extension of existing partnerships with Amazon Web Services (AWS), DigitalOcean, Google Cloud, and Oracle Cloud Infrastructure (OCI)—culminate in driving controlled, flexible, AI-powered coding for enterprises' infrastructures of choice.
Posted September 04, 2024
In Douglas Adams' Hitchhiker's Guide to the Galaxy, various alien races were able to communicate with each other thanks to the Babel Fish, which, when placed in one's ear, decoded brainwave emanations from one species to provide instantaneous translation to the other. In Star Trek, a "universal translator" allowed instantaneous translation between any alien species and humans. Until recently, these universal translators have existed only in the domain of science fiction.
Posted September 04, 2024
Couchbase, Inc., the cloud database platform company, is announcing the official launch of Capella Columnar on AWS, bringing real-time operational and analytic workload enablement to AWS. Additionally, Couchbase is also debuting Couchbase Mobile with vector search, as well as Capella Free Tier, expanding the way Couchbase serves developers while reducing costs and simplifying operations.
Posted September 03, 2024
Tigera, the creator of Project Calico, is introducing universal microsegmentation capabilities to Calico designed to support a diverse range of workloads, including virtual machines (VM), containers, and bare metals. Calico provides a robust, dynamic, and high-performance network policy engine to perform segmentation across both on-premises and cloud deployments, according to the company.
Posted September 03, 2024
The consistent throughline of any business looking to stay competitive in an evolving market is extracting value from data—from key trends to relevant insights, prescriptive actions, and more. This is done through data applications, acting as enablers of productivity, efficiency, and innovation across the enterprise. However, due to the dichotomy of legacy systems, data silos, and poor data quality and the demands for real-time, scalable data, building effective data apps is a challenging—yet rewarding—feat.
Posted August 29, 2024
SAP platforms, used by 99 of the Fortune 100 companies and with over 280 million cloud subscribers worldwide, are among the most reliable business applications. As SAP administrators, your role in maintaining the security of these platforms is crucial. However, the platform's popularity makes it a prime target for hackers to exploit Structured Query Language (SQL) injections and directory traversal vulnerabilities, which are only two specific risks in a much larger group.
Posted August 28, 2024
Regular readers of this column are aware that I am a proponent of getting rid of bad database standards. But sometimes it can be difficult to determine if a particular standard is bad, or just a lot of trouble to comply with! Well, what am I getting at here? Have you ever been thwarted by a global fiat from management? Of course you have, we all have. But I'm talking about a particular type of dictum from above. Something like this: "New software installations, including updated versions and releases, must be supported by current tooling before they can be installed."
Posted August 28, 2024
Quest Software, a global leader in systems management, is announcing the latest version of erwin Data Intelligence and erwin Data Modeler, forwarding comprehensive, end-to-end data lifecycle management that prepares enterprises for the challenges of AI and other technological advancements. Offering enhanced data intelligence, quality, and modeling capabilities, enterprises benefit from a consistent view of their data architectures while maintaining high quality, reliable data.
Posted August 27, 2024
Airbyte, a leading open data movement platform, announced that its PyAirbyte open-source Python library, that was introduced in late-February, has helped more than 10,000 AI and data engineers to sync over 6 billion records of data. Users have completed more than 221,000 PyAirbyte sync jobs, or over 10,000 syncs per week. PyAirbyte now boasts an average of 25,000 monthly downloads, according to metrics from the popular PyPi Python package repository.
Posted August 27, 2024
We decided this Sourcebook was timely, given how enterprise AI has caught mainstream attention and triggered the imaginations of those working in IT, knowledge management, and a score of other areas within the enterprise. AI is dominating headlines, and people want to know how they can best apply the various technologies under the AI banner.
Posted August 26, 2024
IBM announced that two IBM-developed algorithms have been officially formalized within the world's first three post-quantum cryptography standards, which were published by the U.S. Department of Commerce's National Institute of Standards and Technology (NIST). The official publication of these algorithms marks a crucial milestone to advancing the protection of the world's encrypted data from cyberattacks that could be attempted through the unique power of quantum computers, which are rapidly progressing to cryptographic relevancy.
Posted August 26, 2024
FICO, the company powering decisions that help people and businesses around the world prosper, is announcing new enhancements for the FICO Platform—the next generation, applied intelligence platform to power customer connections. These updates address the ongoing data complexities of growing enterprises, improving real-time decision-making, productivity, and overall efficiency.
Posted August 23, 2024
Hasura, the data API and GraphQL leader, is debuting a series of enhancements designed to support the process of connecting large language models (LLMs) to highly diverse enterprise data. With new features that expand on the Data Delivery Network (DDN), Hasura forwards a metadata-driven, federated data access layer capable of streamlining governance to effectively support AI initiatives.
Posted August 19, 2024
NETSCOUT SYSTEMS, INC., a leading provider of performance management, cybersecurity, and DDoS attack protection solutions, is debuting a new initiative centered on delivering the high-quality, curated data necessary to support AIOps across the enterprise. By leveraging its existing partner ecosystem—including Cisco, Palo Alto Networks, ServiceNow, Splunk, and more—NETSCOUT's Omnis AI Insights solution will produce AI-ready data that effectively serves business-critical operations, said the company.
Posted August 16, 2024
KDNuggets, a community site for data professionals, ranked "We Don't Need Data Scientists, We Need Data Engineers," by Mihail Eric, a venture capitalist, researcher, and educator, as its top story of 2021. This sentiment holds even more true today, especially with the unending rush to leverage both generative and predictive AI within enterprise operations. Without the right kind of data, AI is dead in the water.
Posted August 15, 2024
In an era marked by rapid urbanization and technological advancement, the concept of smart cities has captured the imagination of urban planners, technologists, and policymakers worldwide for over a decade. As cities grapple with the challenges of accommodating growing populations, managing resources efficiently, and improving quality of life, a new paradigm is emerging that promises to revolutionize urban living: the cognitive city. At the heart of this transformation lies the game-changing potential of generative AI, poised to unlock the true potential of smart cities and usher in a new age of urban intelligence.
Posted August 15, 2024
Fusion Risk Management (Fusion), a provider of cloud-based operational resilience, business continuity, and risk management solutions, is releasing its new Scenario Simulation and Intelligence suite—enabling companies to simulate thousands of possible scenarios against their resilience plans and strategies to identify points of weakness at scale.
Posted August 14, 2024
With the recent AI boom, data is being created and generated at unprecedented rates. Per the latest estimates, 402.74 million terabytes of data are created each day. This increase calls for a paradigm shift in company efficiency—quickly enabling enterprises to uncover quality insights and effective organization of this data. To help organizations progress along their data-driven journeys, each year, DBTA presents the Readers' Choice Awards, which provide the opportunity to recognize companies whose products have been selected by the experts—our readers!
Posted August 13, 2024
deepset, the mission-critical AI company, is unveiling deepset Studio, a free, user-friendly enabler of custom AI development that abstracts the rampant complexities from AI pipeline development. With a visual, drag-and-drop environment, engineering and data teams can create robust, composable AI systems with ease—including agentic and retrieval augmented generation (RAG) apps—which are immediately deployable within cloud and on-prem environments via deepset Cloud and NVIDIA AI Enterprise software.
Posted August 12, 2024
There is a confluence of activity—including generative AI models, digital twins, and shared ledger capabilities—that are having a profound impact on helping enterprises meet their goal of becoming data driven. Capturing data, converting it into the right insights, and integrating those insights quickly and efficiently into business decisions and processes is generating a significant competitive advantage for those who do it right.
Posted August 08, 2024
With today's data-driven practices and AI demands, there has never been more pressure on data managers and professionals to deliver real-time, high-quality information when and where it is needed. Many organizations are struggling to achieve such a level of "data management maturity," in which data is provided on an agile, automated basis.
Posted August 08, 2024
Everyone likes a diagram. Diagrams often help make an issue clear—except when they don't. There are plenty of diagrams that really do not convey information to the viewer, and that is a sad state for any diagram to find itself in. Maybe, just maybe, not everyone has the proper temperament to create a useful diagram? Before composing a diagram, the diagram-builder needs to be clear about what viewers of the created diagram should gain from viewing it.
Posted August 08, 2024
Ampere and Oracle Cloud Infrastructure (OCI) are releasing second-generation Ampere-based compute instances, OCI Ampere A2 Compute, based on the AmpereOne family of processors. The new offering builds upon the success of OCI Ampere A1 Compute instances, which have been adopted by OCI customers and deployed across over 100 OCI services, including Oracle Database services like HeatWave, MySQL, as well as Oracle Cloud Applications.
Posted August 07, 2024
Hazelcast, Inc., a leading software provider powering mission-critical applications that move the economy, is debuting vector search capabilities for its flagship product, the Hazelcast Platform. Now providing the necessary tools for Hazelcast users to modernize for the AI era, Hazelcast Platform 5.5 enables a variety of new use cases—including semantic search, fraud detection, and retrieval augmented generation (RAG)—as well as additional advancements in compute, resilience, and continuity.
Posted August 02, 2024
Data experts joined DBTA's webinar, The Role of Data in Driving Growth, to examine how the speakers' respective companies have driven enterprise growth through the successful taming of their data estates.
Posted August 02, 2024
Weaviate, an AI-native vector database company, is releasing a developer "workbench" of tools and apps along with flexible tiered storage to help organizations put AI into production. Inspired by Weaviate's vibrant open source community, Weaviate's new developer offerings accelerate AI application development and provide end-to-end solutions for some of the most common AI use cases, helping organizations make the leap from AI prototypes to production, according to the company.
Posted July 31, 2024
IBM announced it is a new partner of the Superconducting Quantum Materials and Systems Center, a DOE National Quantum Information Science Research Center, hosted by Fermilab, as approved by the U.S. Department of Energy Office of Science, Science Programs. As a major national and international research center, SQMS is dedicated to advancing critical quantum technologies, with a focus on superconducting quantum systems.
Posted July 29, 2024