1 / 12

Corporate Databases

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.

elmo-perry
Download Presentation

Corporate Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Corporate Databases Oracle 10g & Alpha 5

  2. 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% internet-enabled 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.

  3. ORACLE 10g Database Line • Four basic editions of 10g database: • Standard One • Standard Edition • Enterprise Edition • Personal Edition

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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

  9. 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

  10. 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

  11. 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.

  12. 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

More Related