GetWiki
Oracle Rdb
ARTICLE SUBJECTS
being →
database →
ethics →
fiction →
history →
internet →
language →
linux →
logic →
method →
news →
policy →
purpose →
religion →
science →
software →
truth →
unix →
wiki →
ARTICLE TYPES
essay →
feed →
help →
system →
wiki →
ARTICLE ORIGINS
critical →
forked →
imported →
original →
Oracle Rdb
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
{{Short description|Relational database management system}}- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
factoids | |
---|---|
Product history
Rdb was a component of the VAX Information Architecture, and was designed to interoperate with other Digital database tools and application frameworks such as the Application Control Management System, Datatrieve and the Common Data Dictionary.WEB,weblink VAX/VMS Software Information Management Handbook, 1985, 2021-01-24, Digital, It originally provided a proprietary query interface known as the Relational Data Operator (RDO), but later gained support for ANSI SQL.In 1994 DEC sold the Rdb division to Oracle Corporation where it was rebranded Oracle Rdb. As of 2020, Oracle is still actively developing Rdb, with over half of the codebase developed under Oracle's ownership.Oracle Rdb Statement of Direction Oracle Version 7.0 ran on OpenVMS for VAX and Alpha, version 7.1 on Alpha only, and versions 7.2 to 7.4 on Alpha and IA-64 (Itanium).WEB, https:www.oracle.com/technetwork/database/database-technologies/rdb/documentation/rdb-rn709-133387.pdf, Oracle Rdb for OpenVMS, Oracle.com, 2022-07-29, WEB,weblink Oracle Rdb for OpenVMS, Oracle.com, 2022-07-29, WEB,weblink Oracle Rdb for OpenVMS, Download.oracle.com, 2022-07-29, WEB,weblink Oracle Rdb for OpenVMS, Download.oracle.com, 2022-07-29, WEB,weblink Oracle Rdb for OpenVMS : Release Notes, Oracle.com, 2022-07-29, Rdb featured one of the first cost-based optimizers, and after acquisition Oracle introduced a cost-based optimizer in its regular Oracle RDBMS product.On March 22, 2011, Oracle announced it had decided to end all software development on the Itanium, and that Oracle Rdb 7.3 would be the last major version released by Oracle. Due to a lawsuit filed by HP against Oracle, Oracle was ordered to continue porting its software to Itanium computers for as long as HP (now Hewlett Packard Enterprise) sells Itanium computers.WEB,weblink Archived copy, 2011-03-27, 2013-03-08,weblink" title="web.archive.org/web/20130308091127weblink">weblink dead, Despite the announcement that 7.3 would be the last major release, Oracle released version 7.4.1.0 of Rdb in August 2020 for OpenVMS on both Alpha and Itanium. In November 2020, Oracle announced that they are in the process of porting Rdb 7.4 to the x86-64 port of OpenVMS.WEB,weblink Rdb/x86, 2020-11-12, 2020-11-12, Groups.google.com,Data access
Interactive access to the Oracle Rdb can be by SQL (Structured Query Language), RDO (Relational Database Operator), or both.High level languages usually access Oracle-Rdb by:- embedding RDO statements in the source file then running it through a precompiler
- :(example: "file.RCO" is pre-compiled into "file.COB")
- embedding SQL statements in the source file then running it through a precompiler
- :(example: "file.SCO" is pre-compiled into "file.COB")
- placing the SQL statements in a file external to the source code; this separate file is converted to object code by the "SQL Module Language" compiler, and the source code then references these SQL statements and, after compilation, the two are joined by the OpenVMS linker.
example: $ SQL$MOD file_bas.sqlmod â file_bas.obj
$ BASIC file.bas â file.obj
$ LINK file.obj,file_bas.obj â file.exe
A variation of example 3 allows "Dynamic SQL" to be created in the source code, and then used to communicate with Rdb via a structure known as SQLDA (SQL Descriptor Area).On OpenVMS systems, Oracle Rdb is a popular (although expensive) upgrade path for applications written using Record Management Services (RMS) files.$ BASIC file.bas â file.obj
$ LINK file.obj,file_bas.obj â file.exe
Architecture
Rdb is built on top of a low-level database kernel named KODA, which handles functionality such as locking, journaling, and buffering of data.WEB,weblink Guide to Database Performance and Tuning: Predicate Estimation, Mark Bradley, Oracle Corporation, August 2003, 2021-01-29, The KODA kernel is shared with Oracle's CODASYL DBMS (originally known as VAX DBMS) which is a network model database.CONFERENCE, KODA - The Architecture And Interface Of A Data Model Independent Kernel, Gopalan Arun, Ashok Josh, August 1998, VLDB '98: Proceedings of the 24rd International Conference on Very Large Data Bases, Morgan Kaufmann Publishers Inc., 10.1.1.106.8846,Rdb on other platforms
VAX Rdb/ELN was the name of Digital's relational database for the VAXELN operating system. Despite sharing the Rdb name, and being announced at the same time, Rdb/ELN was not based on Rdb/VMS, or vice versa.JOURNAL,weblink April 1984, 2020-11-12, DEC launches new top-end VAX, 10.1049/ep.1984.0129, Rdb/ELN was created by Jim Starkey, and was the first commercially available database to use Multiversion concurrency control.WEB,weblink Firebirdsql.org, 2020-11-12, A not-so-very technical discussion of Multi Version Concurrency Control, Ports of Rdb previously existed or were planned for Tru64 and Microsoft Windows NT. Demand for the Tru64 version was so low that support was dropped. The Windows NT port was never released as Oracle could not obtain support on the BLISS compiler necessary for this platform. In order to port Rdb to these platforms, an abstraction layer named the Common Operating System Interface (COSI) was implemented to isolate the database from the underlying operating system.WEB,weblink 2002, 2020-11-15, Porting Rdb to Itanium, Oracle.com, Digital provided a relational database for their Ultrix operating system named ULTRIX/SQL, but it was based on Ingres instead of Rdb.WEB,weblink ULTRIX/SQL Database Administrator's Guide, June 1990, 2020-11-12, Bitsavers.org,References
{{Reflist}}External links
{{Oracle}}- content above as imported from Wikipedia
- "Oracle Rdb" does not exist on GetWiki (yet)
- time: 1:30am EDT - Sun, May 05 2024
- "Oracle Rdb" does not exist on GetWiki (yet)
- time: 1:30am EDT - Sun, May 05 2024
[ this remote article is provided by Wikipedia ]
LATEST EDITS [ see all ]
GETWIKI 23 MAY 2022
The Illusion of Choice
Culture
Culture
GETWIKI 09 JUL 2019
Eastern Philosophy
History of Philosophy
History of Philosophy
GETWIKI 09 MAY 2016
GetMeta:About
GetWiki
GetWiki
GETWIKI 18 OCT 2015
M.R.M. Parrott
Biographies
Biographies
GETWIKI 20 AUG 2014
GetMeta:News
GetWiki
GetWiki
© 2024 M.R.M. PARROTT | ALL RIGHTS RESERVED