Oracle Database and Features

 History of Oracle

•       Larry Ellison, Bob Miner and E.D.Oates 3 persons made company RSI in 1977.

•       2^nd version in 1979

•       3^rd Version in 1983 and fully written by c language and RSI becomes Oracle Corporation

•       4^th version in 1984

•       5^th version in 1985 and come as client-server technology

•       6^th version in 1988

•       7^th version in 1992

•       8i version in 1997 i= internet version

•       ….. Oracle 10g, 11g (g=grid)

•       12c (C=Cloud Computing)

•       18c

•       19c ( Automatic Index Creation, Real-Time Statistics Maintenance, SQL Queries on Object Stores, In-Memory for IoT Data Streams, and many more.

•       20c

•       21c in Dec 2020 (Holds Block chain, Machine learning)

More details on oracle version release information can be obtained in the following link-

1. https://en.wikipedia.org/wiki/Oracle_Database

2. https://ittutorial.org/oracle-version-history-oracle-database-release-versions/

Commercial Database Market Size Update Database Engine Ranking The following link will be useful to get updated information about database ranking in world. https://db-engines.com/en/ranking Size of Commercial Database Market from 2013 to 2021 https://www.statista.com/statistics/810188/worldwide-commercial-database-market-size/ Why fall from the year 2015? The market declined is linked to the growth of cloud software as a service and the rise of non-relational and open source database solutions software. https://db-engines.com/en/ranking Why Oracle •           Oracle support RDBMS •           Handle Big database •           User access is heavily controlled •           Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation. •           Data warehouse support •           Database Vault defends against unauthorized access to application data and harmful database changes by any users, including those with permission to access the data •           Database Firewall (Oracle 11g) •           Data Dictionary   Why do database users prefer oracle? Satisfaction with the following: 1.            Performance 2.            Security features 3.            Scalability 4.            Consistency 5.            Isolation of transactions 6.            Durability of transactions 7.            Quality of data modelling tools 8.            Support for XML 9.            Multi-platform support 10. Quality of management tools included in the database 11. Quality of available 3rd party management tools 12. Programming language support   Data Dictionaries •       In database management systems, a file that defines the  basic organization of a database.   A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field.        Most database management systems keep the data dictionary hidden from users to prevent them from accidentally destroying its contents. •       Data dictionaries do not contain any actual data from the database.   Oracle Installation • Standalone ( PC based) • Center Server (Client-Server technology) • Server-side OS is –    Unix –    Linux –    Windows • Client side OS is –    Linux –    Windows Major New in Oracle Database 21c https://blogs.oracle.com/database/post/introducing-oracle-database-21c Blockchain in table  Here row is hashed and no chance to delete the row later.

 

  •       In-Database Machine Learning: (ML) algorithms built into Oracle Database enable data scientists to leverage the power of Oracle Database to build predictive models (using over 30 ML algorithms) running directly on data held in database tables 

•        AutoML: Oracle Database 21c makes it even simpler for data scientists and analysts to take advantage of in-database machine learning by providing a Python machine learning interface to the database.

Database vs DBMS

A database is an organized collection of data

•        Database management systems are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data

  Writing SQL Commands

•       Write commands at Note pad, save and exit

•       Run Note pad at SQL prompts for output

•       Toad for Oracle is the #1 commercial Oracle development/management tool for over twenty years! Toad for Oracle enables you to maximize your investment in Oracle technology by empowering database professionals to automate processes, minimize risks and cut project delivery timelines by nearly half.

 

  

Oracle E-Business Suite Applications

•Oracle Human Capital Management,

•Oracle Financial Management,

•       Oracle Supply Chain Management

•       and Oracle Customer Relationship Management (CRM).

•Datawarehouse

•       Link

Oracle Enterprise Resource Planning (ERP)

Oracle Application Developer

•        Learn more about Oracle Database using free Express Edition (XE).

•        Connect Oracle Database to your favorite programming languages and dev environments including Java, .NET, Python, Node.js, Go, PHP, C/C++ and more.

•        Use free dev tools and Integrated Development Environment (IDEs) from Oracle including SQL Developer, SQLcl, and SQL Developer Data Modeler.

– The IDE simplifies the development of web, enterprise, desktop, and mobile applications that use the Java and HTML5 platforms. The IDE also offers support for the development of PHP and C/C++ applications.

•        Install free Oracle REST Data Services (ORDS) to REST-enable your database.

•        For low-code app development, run Oracle APEX on top of ORDS and XE at no extra cost to rapidly build data-centric web apps that look beautiful in mobile and desktop browsers.

•        Ref: https://www.oracle.com/database/technologies/appdev/xe.html

Oracle Enterprise Resource Planning (ERP)