Data Modeling Articles
Database administration is a technical discipline, and it almost goes without saying that DBAs should be armed with significant technical knowledge. And this column typically covers the many diverse technology issues facing DBAs. However, there are non-technical qualities and aspects to the DBA role that are not as frequently discussed. So, this month we will proffer some guidance on non-technical areas for DBAs to focus on to make them more valuable to their employers!
Posted October 16, 2024
Predibase, the developer platform for productionizing open source AI, is debuting the Predibase Inference Engine, a comprehensive solution for deploying fine-tuned small language models (SLMs) quickly and efficiently. Designed for rapid, streamlined deployment across both private serverless (SaaS) and virtual private cloud (VPC) environments, the Predibase Inference Engine offers the most resource-efficient serving stack that empowers enterprises to scale specialized models at a fraction of the cost, according to the company.
Posted October 15, 2024
ClearML, the leading solution for unleashing AI in the enterprise, is debuting its new multi-tenant GPU-as-a-Service (GPUaaS) for Enterprise, an offering that delivers greater GPU utilization for enterprises to improve their AI innovation and ROI. GPUaaS for Enterprise empowers organizations to successfully support their AI initiatives with the compute required while offering a centralized location for monitoring and managing AI resources.
Posted October 11, 2024
AI—both generative and machine learning/statistical—is essentially dead in the water without well-vetted, timely, quality data. This is holding back AI efforts more than anticipated, a recent survey finds. Data issues hampering AI were explored in a recent survey released by Precisely and Drexel University, which exposed widespread data trust issues and its impact on data and AI initiatives. Data quality and governance have hampered organizations for decades, and such deeply rooted distrust in the data is now being reflected in their embrace of AI output.
Posted October 10, 2024
Software development has come a long way in the past few decades, but data management hasn't. It's time to change that. Despite automation becoming more ubiquitous, many engineering teams are still managing databases manually—a practice that can be time-consuming and complex, slowing down developers and impeding overall productivity. Additionally, current models force database administrators (DBAs) to work within silos, which creates logjams and communication lapses. It also leaves more room for error.
Posted October 10, 2024
In multidimensional data modeling practice, there is the concept of a bridge dimension. A bridge dimension, being the dimensionalized equivalent of a normalized data design's associative entity, allows for the resolution of a many-to-many relationship. By its very nature, the bridge is saying, "Yes, let's normalize our dimensional designs." The bridge dimension exists to resolve a many-to-many relationship between two other dimensions.
Posted October 10, 2024
In today's digital landscape, delivering exceptional user experiences has become a top objective for businesses across industries. As applications and digital touchpoints increase, understanding user behavior within these platforms is crucial for driving product innovation and business growth. However, collecting, managing, and reporting on user data has traditionally been a complex and resource-intensive endeavor, often requiring significant engineering resources.
Posted October 10, 2024
Picture this: A doctor receives an emergency call late at night. A patient has been brought into the emergency room with severe symptoms, and immediate access to their medical history is crucial. Within seconds, the doctor accesses the patient's electronic health records, seamlessly pulling up a comprehensive view of their health history. Thanks to a secure and reliable database, the doctor can make informed decisions quickly, potentially saving the patient's life.
Posted October 10, 2024
MicroStrategy Incorporated, a pioneer in AI-powered business intelligence, is debuting the latest iteration of MicroStrategy ONE, the fully cloud-native AI/BI platform for solving some of the world's toughest data challenges. The newest version centers on the power of generative AI (GenAI) to make enterprise data and insights more readily available to all employees, including the less-technical frontline.
Posted October 07, 2024
The EY organization is expanding its collaboration with IBM to leverage software from Apptio, an IBM Company. EY strategy and consulting experience, used in concert with Apptio software, can help enable organizations to focus their resources on their strategic priorities at all levels of the organization, according to the vendor.
Posted October 07, 2024
BMC's latest "2024 BMC Mainframe Survey" is now available, revealing the state of the mainframe is strong, with a bright outlook, thanks to emerging technologies and continued digital transformation. The mainframe's speed, processing capacity, and security continue to make the platform a key component of the ever-changing IT landscape.
Posted October 07, 2024
Observe, Inc., the SaaS observability company, is launching "Project Voyager," its most significant product update yet that introduces an AI Investigator along with OpenTelemetry-Native APM and Snowflake Observability, enabling Engineering, DevOps, and SRE teams to troubleshoot incidents faster and improve customer experience.
Posted September 27, 2024
Airbyte, a leading open data movement platform, is launching a plethora of technologies that make virtually any data even more accessible for analytics and GenAI (generative artificial intelligence). Airbyte is introducing Airbyte 1.0, available as Airbyte Open Source and the Airbyte Cloud online service, the Airbyte Marketplace with more than 300 data connectors, an AI Assistant to create data connectors, support for LLMs and Gen AI workflows, and the general availability of Airbyte Self-Managed Enterprise for on-premises deployments.
Posted September 27, 2024
EnterpriseDB (EDB), the leading Postgres data and AI company, is unveiling a series of contributions to PostgreSQL 17 that forward the database as an effective option for large-scale data analytics and AI workloads, according to EDB. This release—which was driven by over 200 developers world-wide—reflects the growing popularity and significance of Postgres, as well as EDB's long-standing commitment to the PostgreSQL community.
Posted September 26, 2024
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 25, 2024
Hitachi Vantara, the data storage, infrastructure, and hybrid cloud management subsidiary of Hitachi, Ltd., is releasing the new generation of the Hitachi EverFlex infrastructure-as-a-service (IaaS) portfolio, reinforcing its commitment to enhancing IT operations.
Posted September 24, 2024
IBM is introducing IBM Rhapsody Systems Engineering (Rhapsody SE), a web-based solution for systems engineering teams that empowers them to deliver smarter, more complex, and more competitive solutions to their end users. IBM Rhapsody Systems Engineering is based on several key technologies that allow customers to use the benefits of complexity while mitigating its associated risks.
Posted September 23, 2024
Oracle is introducing the first zettascale cloud computing clusters accelerated by the NVIDIA Blackwell platform. Oracle Cloud Infrastructure (OCI) is now taking orders for the largest AI supercomputer in the cloud—available with up to 131,072 NVIDIA Blackwell GPUs. According to Oracle, the maximum scale of OCI Supercluster offers more than three times as many GPUs as the Frontier supercomputer and more than six times that of other hyperscalers.
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