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

Tracer study as research method

-
Tracer Study  Dr. Rashid A tracer study is a type of research method used to track and collect data on the outcomes and experiences of individuals after they have completed a specific program or activity. This is commonly used in educational, vocational, and training contexts to evaluate the effectiveness of programs and to understand the long-term impacts on participants. For example, universities might conduct tracer studies to track the employment status, career progression, and further education of graduates. The goal is to understand how well the program prepared them for the real world, and whether it met their needs and expectations. Key components of a tracer study often include: Survey or Interview : Gathering data directly from individuals (graduates, trainees, etc.). Follow-Up : Checking in with participants after a certain time has passed (often a few months or years). Analysis : Evaluating trends, outcomes, and correlations based on the data. The findings from ...
Read more

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

Political Economy in Procurement Perspective

-
Political Economy in Procurement Perspective   Dr. Engr. Md. Abdur Rashid In the context of procurement, political economy refers to the intersection of political and economic factors that influence decision-making, policies, and practices in the procurement process. This perspective looks at how government regulations, policies, power dynamics, stakeholder interests, and societal influences shape procurement activities, such as sourcing, contract management, and purchasing decisions. Key elements of political economy in procurement include: Government Policies and Regulations : The rules and laws set by governments impact procurement processes, such as rules for public tenders, transparency, anti-corruption measures, trade policies, and environmental standards. Political Influence : Political agendas can affect procurement decisions, such as favoring certain industries, companies, or geographical regions. This can lead to cronyism, corruption, or biased bidding processes. ...
Read more