Data Modeling Articles
Progress is unveiling Progress Data Cloud, a centralized Data Platform as a service designed to improve data and AI operations in the cloud without the complexity of infrastructure management.
Posted January 23, 2025
OpenAI is partnering with Arm, Microsoft, NVIDIA, and Oracle to form the Stargate Project—a new company which intends to invest $500 billion over the next four years building new AI infrastructure for OpenAI in the United States. According to an announcement by OpenAI, the project will begin deploying $100 billion immediately.
Posted January 22, 2025
A day in the life of a DBA (database administrator) can be quite hectic. The DBA is required to maintain production and test environments while at the same time keeping an eye on active application development projects, attending strategy and design meetings, helping to select and evaluate new products, and keeping legacy systems robust and stable, while ensuring access from new systems.
Posted January 22, 2025
Oracle announced it has been recognized as a Leader in the 2024 Gartner Magic Quadrant for Cloud Database Management Systems. Oracle's converged database architecture enables customers to leverage multiple data and application development models to support enterprise data and AI workloads.
Posted January 22, 2025
A surrogate is, "One appointed to act in place of another." A surrogate key is appointed to act in place of a natural key. Why? Well, one could argue that surrogate keys existed since the beginning of the computer. As the computer uses internal addresses for finding everything, and in the early days that usage had to be explicitly managed by those programming. It wasn't until relational theory came along that the concept of using data values as identifiers arose and were functionally implemented.
Posted January 22, 2025
ThoughtSpot is debuting Analyst Studio, a creator space designed to help data teams accelerate their data readiness for AI and analytics.
Posted January 20, 2025
President Joe Biden issued an executive order to provide federal support to address massive energy needs for fast-growing advanced artificial intelligence data centers, calling for leasing federal sites owned by Defense and Energy departments to host gigawatt-scale AI data centers and new clean power facilities. The move aims to address enormous power needs in a short time frame.
Posted January 20, 2025
New approaches to data architecture and data management are key toward enabling AI across the enterprise. In DBTA's latest webinar, Modernizing Your Data Management Strategy for the AI Era, experts discuss emerging technologies and best practices for supporting AI with a robust, end-to-end data strategy.
Posted January 17, 2025
The interest surrounding artificial intelligence (AI) has never been higher, but AI agents are the next wave of innovation enterprises need to prepare for. An AI agent is a fully automated program with complex reasoning capabilities and memory that uses an LLM to solve problems, creates its own plan to do so, and executes that plan.
Posted January 15, 2025
dbt Labs, a pioneer in analytics engineering, is acquiring SDF Labs, the team of former Meta and Microsoft engineering leaders behind SDF, a next-generation data transformation technology—enabling dbt Labs to integrate SDF's powerful multi-dialect, dbt-native SQL comprehension capabilities into dbt.
Posted January 14, 2025
The months and years ahead promise to be an interesting time in the data analytics space.AI and machine learning are already making their mark, elevating analytics—and its front-end sibling, business intelligence. End users are seeing their capabilities expand in new directions, with an ability to ask questions they did not even consider with earlier technology iterations. Industry leaders are tracking a range of developments that are defining analytics and BI in the year ahead.
Posted January 13, 2025
A lot of SAP customers and consultants look at SAP BW/4HANA as a "lower-class" SAP system. Something for "someone else" to worry about. They forget about all the work that went into setting up their company's data warehouse in SAP BW/4HANA, or further back, like some of my early SAP consulting projects on BW7 and BW3.5.
Posted January 09, 2025
While the generative AI (GenAI) revolution is rolling forward at full steam, it's not without its share of fear, uncertainty, and doubt. The great promises that can be delivered through large language models (LLMs) are tainted by concerns over hallucinations, bias, data security, "black-box" decisioning, and outdated information.
Posted January 09, 2025
Even after 50 years, Structured Query Language, or SQL, remains the native tongue for those who speak data. It's had impressive staying power since it was first coined the Structured Query English Language in the mid-1970s. It's survived and thrived through the dot-com era and the proliferation of cloud technology. In essence, SQL is a technology that evolves.
Posted January 09, 2025
In 2025, preventing risks from both cybercriminals and AI use will be top mandates for most CIOs. Ransomware, in particular, continues to vex enterprises, and unstructured data is a vast, largely unprotected asset. AI solutions have moved from experimental to mainstream, with all the major tech companies and cloud providers making significant investments in building turnkey generative (GenAI) and AI solutions for enterprise customers.
Posted January 09, 2025
Throughout 2024, data managers and professionals were at the locus of the new waves of innovation driven by AI and analytics—and the activity was frenetic and intense. As the year 2025 progresses, this intense and frenetic activity will only continue. Cloud services, AI, AI agents, and cybersecurity are top areas of interest that industry leaders are watching. The following are several prominent trends mentioned that are shaping data management.
Posted January 09, 2025
Oracle Database 23ai is the next long-term support release and offers over 300 new features. Originally named Oracle Database 23i, it was rebranded to Oracle Database 23ai with a heavy focus on artificial intelligence (AI). To optimize many of the database's key functions, Oracle Database 23ai uses AI for improved timing estimates and resource costings. There are also new features such as AI Vector Search to allow data queries on semantics and not keywords.
Posted January 08, 2025
Cybersecurity continues to be top of mind for organizations everywhere as 2025 begins. In 2024 alone, hackers attacked hospitals and other health care organizations, telecom giants, supply chains, and more. Even government entities haven't been spared in these attacks. Here, security experts share their predictions for incoming threats in 2025.
Posted January 07, 2025
Blitzy, the emerging leader in System 2 AI, is announcing the launch of the Blitzy Platform, the company's agentic solution that promises to revolutionize the way enterprises build software applications.
Posted January 06, 2025
NTT DOCOMO Ventures, Inc. announced it has invested in Ayar Labs, Inc. through its managed fund with the aim of driving advancements in optical I/O technologies, accelerating practical applications of innovative solutions, and fostering the creation of new value in the field.
Posted January 03, 2025
AI innovation in the big data space shows no signs of slowing down, with companies rushing to adopt or create their own solutions based on AI, automating redundant tasks, and spinning up all kinds of use cases to justify spending big bucks in the area. Here, tech experts share their predictions for AI in 2025.
Posted December 20, 2024
Linkerd, created by Buoyant, is releasing Linkerd 2.17, a new version of Linkerd that introduces several major new features to the project: egress traffic visibility and control; rate limiting; and federated services, a powerful new multicluster primitive that combines services running in multiple clusters into a single logical service. This release also updates Linkerd to support OpenTelemetry for distributed tracing.
Posted December 18, 2024
RapidCanvas, democratizing AI-driven business transformation, announced it has secured $16 million in a funding round for its AI agents, empowering the company to further support the automation of complex tasks traditionally performed by data scientists and engineers.
Posted December 17, 2024
Experts joined DBTA's special roundtable webinar, The Future of Analytics: Cloud Data Warehouses, Data Lakehouses, and More, to discuss how better, faster insights can be achieved through an assortment of modern systems that emphasize flexibility, scalability, and agility.
Posted December 13, 2024
The beauty and joy of a relational database is the concept of relational closure—everything is a table. Beyond the eponymous table, query results are also "tables." Any query serves as a table to be queried by any other query, which is why queries may be nested almost infinitely within queries.
Posted December 12, 2024
As AI technologies and services have accelerated their own proliferation throughout the market, the data that trains these machines is more important than ever. The global big data and analytics industry is expected to experience significant growth in the next few years. It is predicted to grow at a CAGR of 14.9% between 2024 and 2032 and reach $1.088 trillion by 2032. Here, data professionals share their big data and database/infrastructure predictions for 2025.
Posted December 06, 2024
Big data is continuing to proliferate at organizations, this time spurred by AI and machine learning within enterprise software tools, followed by advancements in software for managing unstructured data, and the substantial increase in data volume. To help make the process of identifying useful products and services easier, each year, DBTA presents a list of Trend-Setting Products, highlighting a commitment to innovation and to provide organizations with tools to address changing market requirements.
Posted December 05, 2024
Weaviate is launching its latest SaaS service, Weaviate Embeddings, to bring freedom and flexibility to a crucial area of AI development: data vectorization. According to the company, Weaviate Embeddings combines the flexibility of open source with the convenience and scalability of a managed service and pay-as-you-go pricing.
Posted December 05, 2024
Progress, the trusted provider of AI-powered infrastructure software, is unveiling the Q4 2024 release of Progress Telerik and Progress Kendo UI component libraries. With this latest iteration focusing on improved integration, ease-of-use, and various other enhancements, Progress aims to provide the most comprehensive toolset for developing modern user experiences, according to the company.
Posted December 04, 2024
Vaultree, a leader in advanced data encryption, is debuting Vaultree Encrypted Numbers (VENum), as well as announcing its open source availability. The VENum stack—which includes Vaultree Encrypted Numpy (VENumpy) and VENum Machine Learning (VENumML)—enables developers to build and deploy ML models on encrypted data without compromising data privacy.
Posted December 04, 2024
Domino Data Lab, provider of the leading Enterprise AI Platform trusted by the largest AI-driven companies, is announcing an array of platform capabilities and integrations with leading AI innovators—AWS, NetApp, and NVIDIA—that focus on accelerating AI time-to-value while reducing costs and risk. Accompanied by Domino's ongoing momentum in the SaaS market—having experienced a 750% increase in annual recurring revenue (ARR) over the last year—the company continues its rapid innovation in the AI enablement space.
Posted November 27, 2024
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