In the field of database design, a multi-model database is a database management system designed to support multiple data models against a single, integrated backend. In contrast, most database management systems are organized around a single data model that determines how data can be organized, stored, and manipulated. Document , graph , relational , and key–value models are examples of data models that may be supported by a multi-model database.
31-462: Oracle Database (commonly referred to as Oracle DBMS , Oracle Autonomous Database , or simply as Oracle ) is a proprietary multi-model database management system produced and marketed by Oracle Corporation . It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-premises , on-cloud , or as
62-404: A Teradata platform that has reached its end of support life. The extended support for a platform requires approval from the local Area Director and will be delivered on a "best effort" basis, as spare parts for older platforms may no longer be available. In October 2018, Teradata started calling the cloud analytics software product line Vantage. Vantage is composed of various analytics engines on
93-560: A different model, to achieve a multi-model capability as described by Martin Fowler . This strategy has two major disadvantages: it leads to a significant increase in operational complexity, and there is no support for maintaining data consistency across the separate data stores, so multi-model databases have begun to fill in this gap. Multi-model databases are intended to offer the data modeling advantages of polyglot persistence, without its disadvantages. Operational complexity, in particular,
124-832: A hardware product line called IntelliFlex was announced. Victor L. Lund became the chief executive on May 5, 2016. In October 2018, Teradata started promoting its cloud analytics software called Vantage (which evolved from the Teradata Database). On May 7, 2020, Teradata announced the appointment of Steve McMillan as president and chief executive officer, effective June 8, 2020 Teradata has acquired several companies since becoming an independent public company in 2008. In March 2008, Teradata acquired professional services company Claraview, which previously had spun out software provider Clarabridge . Teradata acquired column-oriented DBMS vendor Kickfire in August 2010, followed by
155-411: A hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware ( Exadata on-premises, on Oracle Cloud or at Cloud at Customer). Oracle Database uses SQL for database updating and retrieval. Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates , started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed
186-619: A key-key store. With a layered architecture, each data model is provided via its own component . In addition to offering multiple data models in a single data store, some databases allow developers to easily define custom data models. This capability is enabled by ACID transactions with high performance and scalability. In order for a custom data model to support concurrent updates, the database must be able to synchronize updates across multiple keys. ACID transactions, if they are sufficiently performant, allow such synchronization. JSON documents, graphs, and relational tables can all be implemented in
217-488: A manner that inherits the horizontal scalability and fault-tolerance of the underlying data store. Teradata Teradata Corporation is an American software company that provides cloud database and analytics-related software , products, and services. The company was formed in 1979 in Brentwood, California , as a collaboration between researchers at Caltech and Citibank 's advanced technology group. Teradata
248-619: A reported $ 50 million. In September, Teradata acquired Hadoop service firm Think Big Analytics. In December, Teradata acquired RainStor , a company specializing in online data archiving on Hadoop. Teradata acquired Appoxxee, a mobile marketing software as a service provider, for about $ 20 million in January 2015, followed by the Netherlands-based digital marketing company FLXone in September. That same year Teradata acquired
279-479: A secure managed cloud for data and analytic software as a service . IntelliCloud is compatible with Teradata's data warehouse platform, IntelliFlex. The Teradata Analytics Platform was unveiled in 2017. Teradata began to use the term " big data " in 2010. CTO Stephen Brobst attributed the rise of big data to "new media sources, such as social media ." The increase in semi-structured and unstructured data gathered from online interactions prompted Teradata to form
310-522: A small Business Intelligence firm, MiaPearl. In July 2016, the marketing applications division, using the Aprimo brand, was sold to private equity firm Marlin Equity Partners for about $ 90 million with Aprimo under CEO John Stammen moving its headquarters to Chicago. while absorbing Revenew Inc. that Marlin had also bought. Teradata acquired Big Data Partnership , a service company based in
341-485: Is a database that can store, index and query data in more than one model. For some time, databases have primarily supported only one model, such as: relational database , document-oriented database , graph database or triplestore . A database that combines many of these is multi-model. For some time, it was all but forgotten (or considered irrelevant) that there were any other database models besides relational. The relational model and notion of third normal form were
SECTION 10
#1732779541449372-725: Is an enterprise software company that develops and sells database analytics software. The company provides three main services: business analytics, cloud products, and consulting. It operates in North and Latin America, Europe, the Middle East, Africa, and Asia. Teradata is headquartered in San Diego, California and has additional major U.S. locations in Atlanta and San Francisco , where its data center research and development
403-702: Is generally termed a " search engine " rather than a database. The first time the word "multi-model" has been associated to the databases was on May 30, 2012 in Cologne, Germany, during the Luca Garulli 's key note " NoSQL Adoption – What’s the Next Step? ". Luca Garulli envisioned the evolution of the 1st generation NoSQL products into new products with more features able to be used by multiple use cases. The idea of multi-model databases can be traced back to Object–Relational Data Management Systems (ORDBMS) in
434-576: Is housed. It is publicly traded on the New York Stock Exchange (NYSE) under the stock symbol TDC. Steve McMillan has served as the company's president and chief executive officer since 2020. The company reported $ 1.836 billion in revenue, a net income of $ 129 million, and 8,535 employees globally, as of February 9, 2020. The concept of Teradata grew from research at the California Institute of Technology and from
465-425: Is reduced through the use of a single data store. As more and more platforms are proposed to deal with multi-model data, there are a few works on benchmarking multi-model databases. For instance, Pluciennik , Oliveira , and UniBench reviewed existing multi-model databases and made an evaluation effort towards comparing multi-model databases and other SQL and NoSQL databases respectively. They pointed out that
496-437: Is the end of the support date for a particular Teradata hardware platform. Teradata hardware platforms saw support discontinuation start in 2017, with the 2580 generation of their data warehouse appliance, with only their IntelliFlex 2.5 and R740 hardware platforms being listed as "current product". All other platform models/classes have a published support discontinuation date. Teradata customers may request extended support for
527-638: The "Petabyte club" in 2011 for its heaviest big data users. The rise of big data resulted in many traditional data warehousing companies updating their products and technology. For Teradata, big data prompted the acquisition of Aster Data Systems in 2011 for the company's MapReduce capabilities and ability to store and analyze semi-structured data. To focus on its cloud database and analytics software business, Teradata plans to end support for its old hardware platforms; Teradata will provide remedial maintenance services for six (6) years from its Platform Sales Discontinuation Date. Platform Support Discontinuation
558-879: The UK, on July 21, 2016. In July 2017, Teradata acquired StackIQ, maker of the Stacki cluster manager software. Teradata offers three primary services to its customers: cloud and hardware-based data warehousing, business analytics, and consulting services. In September 2016, the company launched Teradata Everywhere, which allows users to submit queries against public and private databases. The service uses massively parallel processing across both its physical data warehouse and cloud storage, including managed environments such as Amazon Web Services , Microsoft Azure , VMware , and Teradata's Managed Cloud and IntelliFlex. Teradata offers customers both hybrid cloud and multi-cloud storage. In March 2017, Teradata introduced Teradata IntelliCloud,
589-860: The acquisition of Teradata for about $ 250 million in December. Teradata built the first system over 1 terabyte for Wal-Mart in 1992. NCR acquired Strategic Technologies & Systems in 1999 and appointed Stephen Brobst as chief technology officer of Teradata Solutions Group. In 2000, NCR acquired Ceres Integrated Solutions and its customer relationship management software for $ 90 million, as well as Stirling Douglas Group and its demand chain management software. Teradata acquired financial management software from DecisionPoint in 2005. In January 2007, NCR announced Teradata would become an independent public company, led by Michael F. Koehler . The new company's shares started trading in October. In April 2016,
620-422: The advantages of multi-model databases over single-model databases are as follows : The main difference between the available multi-model databases is related to their architectures. Multi-model databases can support different models either within the engine or via different layers on top of the engine. Some products may provide an engine which supports documents and graphs while others provide layers on top of
651-674: The cloud, Oracle Database competes against the database services of AWS, Microsoft Azure, and Google Cloud Platform. Increasingly, the Oracle database products compete against open-source software relational and non-relational database systems such as PostgreSQL , MongoDB , Couchbase , Neo4j , ArangoDB and others. Oracle acquired Innobase , supplier of the InnoDB codebase to MySQL , in part to compete better against open source alternatives, and acquired Sun Microsystems , owner of MySQL, in 2010. Database products licensed as open-source are, by
SECTION 20
#1732779541449682-776: The current Oracle Database releases and their patching end dates. Prior to Oracle Database 18c, Oracle Corporation released Critical Patch Updates (CPUs) and Security Patch Updates (SPUs) and Security Alerts to close security vulnerabilities. These releases are issued quarterly; some of these releases have updates issued prior to the next quarterly release. Starting with Oracle Database 18c, Oracle Corporation releases Release Updates (RUs) and Release Update Revisions (RURs). RUs usually contain security, regression (bug), optimizer, and functional fixes which may include feature extensions as well. RURs include all fixes from their corresponding RU but only add new security and regression fixes. However, no new optimizer or functional fixes are included. In
713-441: The default standard for all data storage. However, prior to the dominance of relational data modeling, from about 1980 to 2005, the hierarchical database model was commonly used. Since 2000 or 2010, many NoSQL models that are non-relational, including documents, triples, key–value stores and graphs are popular. Arguably, geospatial data , temporal data , and text data are also separate models, though indexed, queryable text data
744-480: The discussions of Citibank 's advanced technology group in the 1970s. In 1979, the company was incorporated in Brentwood, California by Jack E. Shemer, Philip M. Neches, Walter E. Muir, Jerold R. Modes, William P. Worth, Carroll Reed and David Hartke. Teradata released its DBC/1012 database machine in 1984. In 1990, the company acquired Sharebase , originally named Britton Lee. In September 1991, AT&T Corporation acquired NCR Corporation , which announced
775-504: The early 1990s and in a more broader scope even to federated and integrated DBMSs in the early 1980s. An ORDBMS system manages different types of data such as relational, object, text and spatial by plugging domain specific data types, functions and index implementations into the DBMS kernels. A multi-model database is most directly a response to the " polyglot persistence " approach of knitting together multiple database products, each handing
806-576: The legal terms of the Open Source Definition , free to distribute and free of royalty or other licensing fees. Multi-model database The relational data model became popular after its publication by Edgar F. Codd in 1970. Due to increasing requirements for horizontal scalability and fault tolerance , NoSQL databases became prominent after 2009. NoSQL databases use a variety of data models, with document , graph , and key–value models being popular. A multi-model database
837-851: The market for relational databases, Oracle Database competes against commercial products such as IBM Db2 and Microsoft SQL Server . Oracle and IBM tend to battle for the mid-range database market on Unix and Linux platforms, while Microsoft dominates the mid-range database market on Microsoft Windows platforms. However, since they share many of the same customers, Oracle and IBM tend to support each other's products in many middleware and application categories (for example: WebSphere , PeopleSoft , and Siebel Systems CRM ), and IBM's hardware divisions work closely with Oracle on performance-optimizing server-technologies (for example, Linux on IBM Z ). Niche commercial competitors include Teradata (in data warehousing and business intelligence), Software AG's ADABAS , Sybase , and IBM's Informix , among many others. In
868-450: The marketing software company Aprimo for about $ 550 million in December. In March 2011, the company acquired Aster Data Systems for about $ 263 million. Teradata acquired Software-as-a-service digital marketing company eCircle in May 2012, which was merged into the Aprimo business. In 2014, Teradata acquired the assets of Revelytix, a provider of information management products and for
899-524: The original version of the Oracle software. The name Oracle comes from the code-name of a CIA -funded project Ellison had worked on while formerly employed by Ampex . Oracle products follow a custom release-numbering and -naming convention. The "ai" in the current release, Oracle Database 23ai, stands for "Artificial Intelligence". Previous releases (e.g. Oracle Database 19c, 10g, and Oracle9i Database) have used suffixes of "c", "g", and "i" which stand for "Cloud", "Grid", and "Internet" respectively. Prior to
930-465: The release of Oracle8i Database, no suffixes featured in Oracle Database naming conventions. There was no v1 of Oracle Database, as co-founder Larry Ellison "knew no one would want to buy version 1". For some database releases, Oracle also provides an Express Edition (XE) that is free to use. Oracle Database release numbering has used the following codes: Oracle Database 23c (23.2 and 23.3)
961-506: Was released in 2023: April 2023 (Linux) Oracle Database Free - Developer Release September 2023 Oracle Database on Base Database Service August 2021 (Linux) April 2019 (Linux) June 2019 (cloud) July 2018 (other) March 2017 (on-premises) The Introduction to Oracle Database includes a brief history on some of the key innovations introduced with each major release of Oracle Database. See My Oracle Support (MOS) note Release Schedule of Current Database Releases (Doc ID 742060.1) for