Xem 1-8 trên 8 kết quả Oltp system
  • Oracle Corporation is one of the world’s largest vendors of software for managing information. Oracle has over 12,000 employees with offices in 93 countries around the world. One of the reasons Oracle software is so popular is the diversity of platforms it supports. In fact, Oracle software runs on almost every popular computer in the world and is used everywhere from home applications to giant corpora- tions.

    pdf710p nghianguyenluong 30-06-2009 357 174   Download

  • Oracle Server Technologies and the Relational Paradigm The relational paradigm is highly efficient in many respects for many types of data, but it is not appropriate for all applications. As a general rule, a relational analysis should be the first approach taken when modeling a system. Only if it proves inappropriate should one resort to nonrelational structures. Applications where the relational model has proven highly effective include virtually all Online Transaction Processing (OLTP) systems and Decision Support Systems (DSS).

    pdf10p vongsuiphat 04-01-2010 161 62   Download

  • Traditionally relational data has been stored in rows—i.e., as a sequence of tuples in which all the columns of each tuple are stored together on disk. This method has a long heritage back to early OLTP systems that introduced the “slotted page” layout still in common use today. However, analytical databases tend to have different access patterns than OLTP systems. Instead of seeing many single-row reads and writes, analytical databases must process larger, more complex queries that touch much larger volumes of data—i.e.

    pdf13p yasuyidol 02-04-2013 25 3   Download

  • SAS functions, SAS formats, the SAS DATA step language, and many SAS procedures (which are software modules that encapsulate a related set of functions—similar to the concept of an SQL stored procedure) are used in data preparation processes. These processes filter, aggregate, denormalize, and sample large tables in a variety of business processes.

    pdf12p yasuyidol 02-04-2013 21 3   Download

  • Oracle Exadata Database Machine provides extreme performance for both data warehousing and OLTP applications, making it the ideal platform for consolidating on private clouds. It is a complete package of servers, storage, networking, and software that is massively scalable, secure, and redundant. With Oracle Exadata, customers can reduce IT costs through consolidation, store up to ten times more data, improve performance of all applications, deliver a faster time-to- market by eliminating systems integration trial and error, and make better business decisions in real time.

    pdf6p yasuyidol 02-04-2013 26 5   Download

  • Greenplum Database utilizes a shared-nothing, massively parallel processing (MPP) architecture that has been designed for business intelligence and analytical processing. Most of today’s general-purpose relational database management systems are designed for Online Transaction Processing (OLTP) applications. Since these systems are marketed as supporting data warehousing and business intelligence (BI) applications, their customers have inevitably inherited this less-than-optimal architecture.

    pdf13p yasuyidol 02-04-2013 20 4   Download

  • After completing this lesson, you should be able to do the following: Explain the role of the DBA in tuning applications Move tables using the ALTER TABLE command Redefine a table online Create different types of indexes Build and manage index-organized tables Explain and plan OLTP, DSS, and hybrid systems

    ppt38p trinh02 28-01-2013 27 3   Download

  • Real Application Clusters (RAC) comprises several Oracle instances running on multiple clustered computers, which communicate with each other by means of a so-called interconnect. RAC uses cluster software to access a shared database that resides on shared disk. RAC combines the processing power of these multiple interconnected computers to provide system redundancy, near linear scalability, and high availability. RAC also offers significant advantages for both OLTP and data warehouse systems and all systems and applications can efficiently exploit clustered environments. ...

    pdf140p nhacsihuytuan 13-04-2013 15 3   Download

Đồng bộ tài khoản