Transcript CorporateDatabases

Corporate Databases
Oracle 10g
&
Alpha 5
About ORACLE






Founded in 1977
CEO – Lawrence Ellison

Decided to commercialize Relational Database Modeling

Now. . . ORACLE is present in 98 of the FORTUNE 100 companies.
1st software company to develop and implement 100% internetenabled enterprise software across its entire product line!
World’s leading supplier of software for information management.
Second largest independent software company.
One of first companies to make its business applications available
through the internet today.
ORACLE 10g Database Line

Four basic editions of 10g database:

Standard One

Standard Edition

Enterprise Edition

Personal Edition
10g – Standard One





Delivers ease-of-use, power, and price/performance for
workgroup, department-level, and internet/intranet applications.
Standard Edition One can only be licensed on servers with a
maximum capacity of two processors.
Customers can now get the world's most popular database for
US$745 in license fees.
Standard Edition One is offered at US$4,995 per processor or
with Named User Plus licensing US$149 per user (minimum five
users).
One CD. 17 minute install.
10g – Standard Edition



Support for larger machines and clustering of services with Real Application
Clusters
It can be licensed on single servers with a maximum capacity of four processors,
or on a cluster of servers supporting up to a maximum of four processors.
Automated Storage Management (ASM), for efficient, less complex data and
disk management



ASM virtualizes the database storage into disk groups. The DBA is able to manage a
small set of disk groups and ASM automates the placement of the database files within
those disk groups.
ASM enables the DBA to change the storage configuration without having to take the
database offline.
ASM automatically rebalances files across the disk group after disks have been added
or dropped.
10g – Enterprise Edition


Provides efficient, reliable, secure data management for mission-critical
applications such as high volume on-line transaction processing (OLTP)
environments, query-intensive data warehouses, and demanding Internet
applications.
Easily upgradeable from SE as well as upgradeable with add-on packages such as:




Oracle Change Management Pack

Enables database administrators to make complex changes to schema objects
safely, track changes to schemas and databases over time, make copies of schemas
or objects, and compare and synchronize schemas and databases.
Oracle Diagnostic Pack

Provides automatic performance diagnostic and advanced system monitoring
functionality.
Oracle Tuning Pack

Provides database administrators with expert performance management for the
Oracle environment, including SQL tuning and storage optimizations.
Oracle Configuration Management Pack

Enables database administrators to track hardware and software configuration
information for hosts and databases managed by Enterprise Manager.

That information can then be browsed, searched, compared, exported, and tracked
historically.
10g – Personal Edition


Supports single user development and deployment that require full compatibility
with Oracle Database Standard Edition One, Oracle Database Standard Edition,
and Oracle Database Enterprise Edition.
Oracle Database 10g Standard Edition and Oracle Database 10g Personal Edition
are both 100 percent compatible with Oracle Database 10g Enterprise Edition on
many different platforms.


Can easily upgrade from Standard / Personal to Enterprise Edition without hassle.
Versatile.
Alpha 5 Database Development


History of Alpha Software

Building Database Software since 1982 Database Manager II, Alpha Three,
Alpha Four (DOS) Alpha Five (Windows)

Currently Shipping version 4.5

Version 5 in beta test

Field tested and experienced -- Approximately 1 million copies sold!
Features:


Goal is to allow small businesses to solve database problems in less time and with less
hassle than with MS Access / FileMaker
Ease of Use.

Easy to use, however; still powerful enough to:





Customer tracking
Invoicing and billing
Membership information
Project Management
Human Resource Information Management
Target audience. . .


Alpha Five is designed for small businesses to manage their
data and for customized applications
Alpha Five is also used in departmental settings in large
corporations
Version 4.5 Features




Automated "Field Rules" that speed up data entry and prevents data
entry errors (over 20 Field Rules includes lookups, pop-ups, cross file
validation, posting etc). --This would require a huge amount of
programming in MS Access.
Visual Report Writer (includes mailing labels, form letters and
envelopes)
Flexible Form Designer allows you to create stunning looking forms
along with custom menus, toolbars and buttons to automate any task
Full ODBC Support and extensive data import and export
New Features to be added in Version 5




(beta)
A Script Genie has been added that automates over 150 different
actions!

Allows you to create highly customized, automated applications in
an entirely menu, and prompt-driven fashion.
Tight Integration with Word and Excel
Version 5 includes a robust security framework including passwords for
individual users and groups along with permissions and table
encryption.
Integrated backup and restore capability has been added which also
allows user to take “snapshots” of the database at various points in
time.
ALPHA 5 vs. MS ACCESS
(Benefits of Alpha Five over MS Access according to users on the Alpha Software Message Board)




















More Data Manipulation Wizards/Genies
(Alpha Five has nearly 200 action scripts – which allows non programmers to develop
complete custom applications without having to program. The equivalent Macros in Access
are much more limited and you have to write VB code to do most custom projects)
Easier Form/Report Designer
More flexible Validation / Field Rules (Alpha Five has an extensive collection of data
validation, posting, data transformation and lookups known as “field rules” which do not
require programming unlike in Access where most of the same tasks require programming)
More Flexible Look-ups (cascading, conditional lookups etc)
Real-time Posting without programming
Field Statistics with one click
Smart Fields (Calendar/Calculator Controls, etc.)
Mark/Unmark, Delete/Undelete Records
Much more robust Expression Evaluator with auto-complete logic
Better Tools for Building Dialogs easily and quickly (Xdialog)
Built-In Print/Save to .PDF
Easier to Perform Complex Multiple Updates
More Flexible Query By Form
Easier to Update Applications
(No Single file like the Access .MDB file – which is could get corrupted because everything is
stored in just one file)
Full Text Indexing
End Users Can Go A lot Further Before Having to write Code
Easier To Build A Networkable Application since Network Optimization is automatic
More comprehensive built in operations for appending, subtracting, deleting duplicate records
etc