Data Modeling Articles
SQL Server databases often contain precious data such as customer information, financial records, and account passwords—assets that are often both essential to the business and subject to compliance regulations. Today, that data is more at risk than ever because readily available AI tools can help less-technical cybercriminals plan and execute attacks. Indeed, the latest version of ChatGPT can be misused to get recommendations about effective tools and technologies to employ in cyberattacks and even examples of how to use them.
Posted November 21, 2024
In DBTA's recent webinar, The Future of Open: What's Next in Lakehouse Architecture, experts offered their perspectives on why open lakehouse architectures continue to be a popular vehicle for enabling modernization and innovation across the enterprise, examining the latest trends, tools, and emerging best practices.
Posted November 21, 2024
Oracle announced that Pennsylvania's State System of Higher Education (PASSHE) will offer Oracle Academy technology education curriculum and teaching and learning resources across its 14 campuses, which serve 82,000 students. This initiative will help the system equip students with vital skills in cloud, software development, and business applications, according to Oracle.
Posted November 20, 2024
Red Hat, Inc., a leading provider of open source solutions, announced the general availability of Red Hat Enterprise Linux 9.5, the latest version of the world's leading enterprise Linux platform. Red Hat Enterprise Linux helps organizations deploy applications and workloads more quickly and with greater reliability, enabling them to lower costs and more effectively manage workloads across hybrid cloud deployments while mitigating IT risks, from the data center to public clouds to the edge.
Posted November 18, 2024
Danny Sandwell, technology strategist, erwin by Quest, and Helen Kinsella, community of practice leader for data governance and privacy at Informatica, joined DBTA's webinar, Achieving AI-Ready Data: Active Metadata, Data Catalogs, and Data Observability, to discuss the latest advancements, technologies, and best practices in the area of data management that can make AI-ready data a tangible reality.
Posted November 14, 2024
At a time when every enterprise looks to leverage generative artificial intelligence, data sites are turning their attention to graph databases and knowledge graphs. The global graph database market size was $2.12 billion in 2022 and is expected to grow to $10.3 billion in 2032, according to estimates from Adroit Research. These databases enable data managers and analysts to model, store, and query complex and increasingly interconnected relationships between datapoints. They also are employed to construct knowledge graphs that can cut through data silos, enable semantic searches, and support chatbots and recommendation engines.
Posted November 14, 2024
Far too often information engineers and others take a dismissive stance about managing data structures. This indifferent attitude is largely because whatever tool the engineers use provides fast performance in resolving queries. They believe that quick performance means all is well, so nothing else matters, right?
Posted November 14, 2024
Hitachi Vantara, the data storage, infrastructure, and hybrid cloud management subsidiary of Hitachi, Ltd., is announcing new solutions for its Virtual Storage Platform One data platform designed around enhancing storage and data management for AI and analytics workloads. Now offering a quad-level cell (QLC) flash storage array with public cloud replication and an object storage appliance, Hitachi Vantara brings improved simplicity, security, and sustainable scalability to the enterprise, according to the company.
Posted November 12, 2024
Informatica, a leader in enterprise AI-powered cloud data management, is releasing Generative AI (GenAI) Blueprints to make it faster and easier for customers to build enterprise-grade GenAI applications on several industry-leading technology platforms. The blueprints—for AWS, Databricks, Google Cloud, Microsoft Azure, Oracle Cloud, and Snowflake—include standard reference architectures, prebuilt, ecosystem-specific "recipes," and GenAI Model-as-a-Service and vector database connectors to minimize GenAI development complexity and accelerate implementation, according to Informatica.
Posted November 06, 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 November 06, 2024
WSO2, the largest independent software provider of open source API management, integration, and identity and access management (IAM) products, is announcing its latest releases of WSO2 API Manager and WSO2 API Platform for Kubernetes, which emphasize the crossroads between AI innovation, Kubernetes, and cyberattack protection.
Posted November 05, 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 November 04, 2024
At its latest developer conference, GitHub unveiled a series of new innovations that emphasize developer choice, control, and ease of use for the AI era. Culminating in three key announcements—the now multi-model GitHub Copilot, the introduction of GitHub Spark, and additional updates across Copilot and GitHub Models—GitHub continues to innovate, motivated by its ambition to reach 1 billion developers.
Posted October 31, 2024
SAP is expanding its partnership with Mistral AI by hosting some of Mistral's commercially available models, including Mistral Large 2, on SAP's operated infrastructure. This extended collaboration provides customers with a trusted and secure environment to use Mistral AI in conjunction with SAP, according to the vendors.
Posted October 23, 2024
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 23, 2024
MineOS, the all-in-one data governance and privacy platform, is upgrading Data Subject Request Management (DSR), including a new capability that completely "changes the game" on how organizations approach DSR implementation.
Posted October 22, 2024
To drive the development of open, efficient, and scalable data center technologies, NVIDIA announced that it has contributed foundational elements of its NVIDIA Blackwell accelerated computing platform design to the Open Compute Project (OCP) and broadened NVIDIA Spectrum-X support for OCP standards.
Posted October 21, 2024
Enabling the collection and utilization of data is crucial to successfully supporting AI projects at enterprise scale. From data integration to data pipelines, AI performance, data governance, compliance, and more, adhering to data engineering best practices has never been more prudent for enabling an AI-powered future.
Posted October 17, 2024
It has been a whirlwind time for data managers and their enterprises, and the innovations that are reshaping data operations aren't showing any signs of slowing down soon. AI and advanced analytics are changing the game, of course, as are a myriad of technologies now available to help manage and extract business value from the data flowing through organizations. Here is what industry experts tell BDQ they now see emerging and what we can expect in the months and years to come.
Posted October 17, 2024
Cube, the company bringing consistency, context, and trust to the next generation of data experiences, is debuting a series of innovations for Cube Cloud—Cube's universal semantic layer—geared around enhancing data management and consumption. The new capabilities—from a next-gen data modeling engine to new data access policies, Cube Copilot, and more—address the present modeling, governance, productivity, and collaboration needs of enterprises.
Posted October 16, 2024
ScaleFlux, a leader in data storage and memory technology, is expanding its product portfolio to meet the demands for global data production. The company is introducing cutting-edge controllers for both NVMe SSDs and Compute Express Lin (CXL) modules, reinforcing its leadership in innovative technology for the data pipeline, according to the vendor.
Posted October 16, 2024
The career paths of IT professionals—whether they start out as administrators, creatives, or executives—are as varied as snowflakes in a blizzard. Along the way, many of us are fortunate enough to meet mentors who guide us and help us grow into better professionals.
Posted October 16, 2024
Generative AI (GenAI) is having an Agile moment or two, but this is not a positive development. One aspect of this moment in time is the continued hyping of GenAI's unlimited agility—wherein GenAI is trumpeted as something akin to an analytic Swiss Army knife. The analogy is not only problematic, but it is actively harmful.
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 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
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