Oracle Database and Features

-

 History of Oracle

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

•       2nd version in 1979

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

•       4th version in 1984

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

•       6th version in 1988

•       7th 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

  • 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)

Comments

Post a Comment

Popular posts from this blog

How to be an Innovative Speaker?

-
1. Innovation in Effective session conduct   Define your message of the session. •         Make it participatory. In your last line, ask questions and teach by name. The final 5 to 10 minutes will be dedicated to participant comments. •         Maintain start and Ending time. •          Concentrate on the audience's needs. Patience is required. Don't retaliate if the participants engage in unwelcome behavior. •         Boost your self-confidence on topics by reading daily papers, books, articles, senior lectures and self-experience. •         Prepare yourself. Write the last update date in a text box and put red color at the top right corner of your slide. •         Do not attend class until you have updated your slide. You won't show any slides that aren't based on current data. Pl...
Read more

Developing Personal Skills

-
  Developing Personal Skills Engr. Md. Abdur Rashid  PhD, NAPD Dear Officers and Staff, you must establish and ensure the long-term growth of your organization. Maintain the following managerial abilities in order to enhance personal skills on a daily basis while working. 1.                  1)       Self-assessment 2)       Creativity 3)       Innovation 4)       Listening and feedback 5)       Find self-satisfaction 6)       Leadership 7)       Team building 8)       Hunt knowledge 9)       Self-reliance and judgment 10)    Resilience 11)    Time management 12)    Stress management 13)    Control over anything 14)    Find satisfa...
Read more

Role of Critical Success Factors and KPI for Developing SMP

-
  Critical Success Factors and KPI Dr. Engr. Md. Abdur Rashid www.rashid-bd.info   Every organization or industry will have its own objectives. Every task that must be finished successfully and efficiently will adhere to a specific process. Ultimately, every process will have a distinct cycle from start to finish. There will be a lot of repetitive activities. Activities won't all be CSF. CSF is a list of a few crucial actions that will help break the cycle and help accomplish the goals. The key point indicators (KPI) used to describe each CSF will be unique. The CSF and KPI concepts are more useful when creating a Strategic Management Plan (SMP) or carrying out research.   From the above discussion, I may conclude a definition of CSF: CSF are the list of potential activities or variables that have influence to end the process effectively to achieve any vision.   Example- NAPD  is a leading training academy in Bangladesh. Different training courses are off...
Read more