甲骨文宣布推出Oracle內(nèi)存數(shù)據(jù)庫(kù)11g
Jun 07, 2016 pm 04:54 PM2009年7月29日,甲骨文宣布推出Oracle內(nèi)存數(shù)據(jù)庫(kù)TimesTen 11g和Oracle內(nèi)存數(shù)據(jù)庫(kù)高速緩存11g(Oracle In-Memory Database Cac
2009年7月29日,甲骨文宣布推出Oracle內(nèi)存數(shù)據(jù)庫(kù)TimesTen 11g和Oracle內(nèi)存數(shù)據(jù)庫(kù)高速緩存11g(Oracle In-Memory Database Cache)。
這一最新版本的主要功能提升包括性能和通過(guò)數(shù)據(jù)庫(kù)緩存網(wǎng)格帶來(lái)的可擴(kuò)展性,支持PL / SQL,甲骨文調(diào)用接口(OCI) ,以及Pro * 嵌入式SQL編程語(yǔ)言;依靠將Oracle集群和Oracle Data Guard集成,通過(guò)自動(dòng)故障轉(zhuǎn)移來(lái)打造穩(wěn)定的可靠性和高可用性。
詳情見(jiàn):
資料:Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen介紹
TimesTen 源于1992年HP試驗(yàn)室,當(dāng)時(shí)主要目的是針對(duì)電信網(wǎng)絡(luò)應(yīng)用,使用內(nèi)存數(shù)據(jù)庫(kù)技術(shù)進(jìn)行一些深入研究,于1996年,由該團(tuán)隊(duì)核心人員成立獨(dú)立運(yùn)作公司,并在1996年發(fā)布TimesTen第一個(gè)商用版本(TimesTen2.0),,2001年,產(chǎn)品中增加Cache Connect組件,以至產(chǎn)品可以和Oracle無(wú)縫集成,2005年由Oracle收購(gòu),到今天為止,該產(chǎn)品已經(jīng)有15年歷史,有多達(dá)11個(gè)主要的發(fā)布版本產(chǎn)生。
Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 是一個(gè)針對(duì)內(nèi)存進(jìn)行了優(yōu)化的關(guān)系數(shù)據(jù)庫(kù),它為應(yīng)用程序提供了當(dāng)今實(shí)時(shí)企業(yè)和行業(yè)(如電信、資本市場(chǎng)和國(guó)防)所需的即時(shí)響應(yīng)性和非常高的吞吐量。
Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 通過(guò)改變數(shù)據(jù)在運(yùn)行時(shí)駐留位置的假設(shè)來(lái)提供實(shí)時(shí)性能。通過(guò)在內(nèi)存中管理數(shù)據(jù),并相應(yīng)地優(yōu)化數(shù)據(jù)結(jié)構(gòu)和訪(fǎng)問(wèn)算法,數(shù)據(jù)庫(kù)操作能夠以最大效率執(zhí)行,從而大大提高響應(yīng)速度和吞吐量,甚至能夠與完全使用高速緩存磁盤(pán)的 RDBMS 相媲美。Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 可嵌入到應(yīng)用程序中,從而消除了進(jìn)程間通信和不必要的網(wǎng)絡(luò)操作,以進(jìn)一步提高數(shù)據(jù)庫(kù)操作的性能。
內(nèi)存數(shù)據(jù)庫(kù)通常被誤認(rèn)為僅限于單用戶(hù)應(yīng)用程序,并且容易在服務(wù)器發(fā)生故障時(shí)丟失數(shù)據(jù)。對(duì)于 Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 而言,事實(shí)并非如此。使用帶有提交后讀取 (committed-read) 隔離的行級(jí)鎖定機(jī)制,多用戶(hù)和多線(xiàn)程應(yīng)用程序變得很普通。通過(guò)內(nèi)部記錄版本消除了讀程序和寫(xiě)程序之間的鎖爭(zhēng)用,從而提供了一致的響應(yīng)時(shí)間和高級(jí)別的并發(fā)。 Oracle TimesTen 數(shù)據(jù)庫(kù)是持久的且可恢復(fù)。 應(yīng)用程序可以根據(jù)其性能要求選擇事務(wù) ACID 屬性的設(shè)置。 根據(jù)標(biāo)準(zhǔn)關(guān)系數(shù)據(jù)模型,可以使用 SQL、JDBC 和 ODBC 訪(fǎng)問(wèn) Oracle TimesTen 數(shù)據(jù)庫(kù)。 任何熟悉 RDBMS 和 SQL 接口的開(kāi)發(fā)人員使用 Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 可以立即提高開(kāi)發(fā)實(shí)時(shí)應(yīng)用程序的效率。
Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 支持各種部署配置以適應(yīng)各種情況,從臨時(shí)查找緩存到操作數(shù)據(jù)存儲(chǔ)、再到任務(wù)關(guān)鍵的事務(wù)處理系統(tǒng)。
由于應(yīng)用程序的任務(wù)關(guān)鍵特性,大多數(shù)部署都添加了 Replication - TimesTen to TimesTen 選件以實(shí)現(xiàn)高可用性和負(fù)載平衡。對(duì)于應(yīng)用程序?qū)泳彺?如對(duì)面向服務(wù)的體系結(jié)構(gòu)的支持),Cache Connect to Oracle 選件可將內(nèi)存數(shù)據(jù)庫(kù)擴(kuò)展成一個(gè)可更新的緩存,從而管理 Oracle 數(shù)據(jù)庫(kù)與 Oracle 內(nèi)存數(shù)據(jù)庫(kù) TimesTen 之間的數(shù)據(jù)加載和同步。
Oracle In-Memory Database Cache資料:
Oracle In-Memory Database Cache 是一個(gè)數(shù)據(jù)庫(kù)選件,它為 Oracle 數(shù)據(jù)庫(kù)提供了實(shí)時(shí)、可更新的緩存。Oracle In-Memory Database Cache 將來(lái)自數(shù)據(jù)庫(kù)的對(duì)性能極其關(guān)鍵的一系列表和表碎片緩存到應(yīng)用層,從而縮短應(yīng)用程序事務(wù)響應(yīng)時(shí)間。在內(nèi)存數(shù)據(jù)庫(kù) TimesTen 中管理緩存表的方式與管理普通的 SQL 關(guān)系型數(shù)據(jù)庫(kù)表類(lèi)似。因此,Oracle In-Memory Database Cache 為應(yīng)用程序提供了關(guān)系型數(shù)據(jù)庫(kù)的所有共性和功能、緩存和 Oracle 數(shù)據(jù)庫(kù)的一致性透明維護(hù)以及內(nèi)存數(shù)據(jù)庫(kù)的實(shí)時(shí)性能。

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

The main difference between MySQL and Oracle is licenses, features, and advantages. 1. License: MySQL provides a GPL license for free use, and Oracle adopts a proprietary license, which is expensive. 2. Function: MySQL has simple functions and is suitable for web applications and small and medium-sized enterprises. Oracle has powerful functions and is suitable for large-scale data and complex businesses. 3. Advantages: MySQL is open source free, suitable for startups, and Oracle is reliable in performance, suitable for large enterprises.

MySQL uses GPL and commercial licenses for small and open source projects; Oracle uses commercial licenses for enterprises that require high performance. MySQL's GPL license is free, and commercial licenses require payment; Oracle license fees are calculated based on processors or users, and the cost is relatively high.

The key to learning Java without taking detours is: 1. Understand core concepts and grammar; 2. Practice more; 3. Understand memory management and garbage collection; 4. Join online communities; 5. Read other people’s code; 6. Understand common libraries and frameworks; 7. Learn to deal with common mistakes; 8. Make a learning plan and proceed step by step. These methods can help you master Java programming efficiently.

In different application scenarios, choosing MongoDB or Oracle depends on specific needs: 1) If you need to process a large amount of unstructured data and do not have high requirements for data consistency, choose MongoDB; 2) If you need strict data consistency and complex queries, choose Oracle.

Learning Java requires learning basic syntax, object-oriented programming, collection frameworks, exception handling, multithreading, I/O streaming, JDBC, network programming, and advanced features such as reflection and annotation. 1. The basic syntax includes variables, data types, operators and control flow statements. 2. Object-oriented programming covers classes, objects, inheritance, polymorphism, encapsulation and abstraction. 3. The collection framework involves ArrayList, LinkedList, HashSet, and HashMap. 4. Exception handling ensures program robustness through try-catch block. 5. Multithreaded programming requires understanding of thread life cycle and synchronization. 6. I/O streams are used for data reading, writing and file operations. 7. JDBC is used to interact with databases. 8. Network programming passes S

Oracle software can improve performance in a variety of ways. 1) Optimize SQL queries and reduce data transmission; 2) Appropriately manage indexes to balance query speed and maintenance costs; 3) Reasonably configure memory, optimize SGA and PGA; 4) Reduce I/O operations and use appropriate storage devices.

To connect Oracle database to Tableau for data visualization, you need to follow the following steps: 1. Configure Oracle database connection in Tableau, use ODBC or JDBC drivers; 2. Explore data and create visualizations, such as bar charts, etc.; 3. Optimize SQL queries and indexes to improve performance; 4. Use Oracle's complex data types and functions to implement through custom SQL queries; 5. Create materialized views to improve query speed; 6. Use Tableau's interactive functions such as dashboard for in-depth analysis.
