Oracle

  • BRMS, BRE и т.д. и т.п.: системы управления бизнес правилами

    BRMS, BRE системы для управления бизнес-правиламиЧто-то подумал и решил написать вообще про BRMS (Business Rule Management Systems). Или, говоря простым языком, про системы управления бизнес правилами.

    Постоянно сталкиваюсь с ситуацией, что аббревиатура BRMS на посконных просторах нашей многострадальной Родины для многих звучит как птичий язык. К ERP вроде уже привыкли, привыкли к CRM, BPM, постепенно привыкаем к MDM. Поэтому будем расширять кругозор. Из последних наблюдений, про существование BRMS знают либо глубоко погрузившиеся в информационные технологии бизнес-консультанты, либо передовые граждане, имеющие статус IT MBA (или находящиеся в процессе его получения).

  • Building Your Essbase Database: from Source to Completed database

    Build Essbase Database in Oracle StudioLet me introduce potential architectures for Essbase implementations, components of the overall solution (both required and optional), and fundamental design methodology. Now we present a hands-on demonstration of how to build an Essbase database.

    To get started, we'll start with an overview of the components and files used in the demonstration. During the demonstration, we walk you through how to build and deploy an Essbase database using Oracle Essbase Studio. Then we talk about how to calculate the database and validate the data in the database using reports. After the demonstration, we discuss some Essbase features you can take advantage of, such as custom load rules and member calculations. 

  • DBaaS deployment Issues in Cloud Computing

    DBaaS deployment Issues with OracleNow that we understand the architecture and components that are used in the different consolidation models, let’s examine some standard deployment issues that need to be addressed. These include security, operational, resource and fault isolation issues as well as scalability and high availability. It is very important to understand that delivery services and the SLAs around those services will drive the actual architecture, design, and implementation. Therefore, architecture, design, and implementation also play directly into the chargeback and metering aspect of the services.

  • Designing an Oracle OLAP Analytic Workspace

    Oracle OLAP Design Process in Analytic Workspace Analytic WorkspaceIn this section, we discuss the features in Oracle OLAP that you should be aware of when designing analytic workspaces. The content here expands on the concepts introduced in our blogs (where those concepts relate to design) and the general design principles discussed in the preceding section. 

     

    Determining Dimensions from user Requirements

    As mentioned, user requirements must drive the design of Oracle OLAP cubes. This fact is often overlooked in Oracle OLAP design, as the data is sourced from relational tables or views. Often, these tables are part of a data warehouse with a well-defined structure. The structure of the source tables will be an important influence, but the ultimate structure of the OLAP cubes should be driven by user requirements, not the convenience of loading data from the data warehouse, because often the data warehouse design is not reflective of user requirements. Oracle OLAP cubes can be used solely for their cube-organized materialized views to accelerate performance of queries on data warehouses, but they offer much more.

  • Developing Analytical Capabilities with Oracle on examples

    The IT industry has seen many evolutions, and it is in the midst of another major paradigm shift. Few technologies have captured more attention than big data, and there is tremendous interest in business use cases featuring big data and analytics. Gartner highlighted the top ten technologies and trends that will be strategic for most organizations in 2018. Strategic big data and actionable analytics were among these ten trends. In 2019, Gartner released its top ten IT trends again. This time, the list included mobile, Internet of Things, and smart machines. Big data and analytics become enablers - a hidden force that’s behind the scenes driving these businesses and IT innovations.

  • Getting Started with Oracle Public Cloud - book


    Book cover Getting Started with Oracle Public CloudAuthor:Hemant Kumar Mehta
    Publisher: Packt Publishing

    Year: 2013
    Pages: 96
    Language: english
    Format: Ebook (PDF)
    ISBN: 978-1-78217-811-8

  • Globalization Development Kit для PL/SQL: UTL_I18N и UTL_LMS

    В Oracle10g впервые появился инструментарий Globalization Development Kit (GDK) для Java и PL/SQL, упрощающий процесс разработки приложений с поддержкой глобализации. Если вы занимаетесь разработкой многоязычного приложения, определение локального контекста каждого пользователя и вывод информации в соответствии с требованиями локального контекста может стать самой сложной задачей программирования, которую вам предстоит решить. Входящие в GDK компоненты PL/SQL разделены на два пакета: UTL_I18N и UTL_LMS.

  • High Availability and Oracle solutions

    High Availability and Oracle database solutionWhen availability is crucial for a business, extremely high levels of disaster tolerance must allow the business to continue in the face of a calamity, without the end users or customers noticing any adverse consequences. The effects of global companies conducting business across time zones spanning “24 × 7 × forever” operations, e-commerce, and the challenges associated with today’s “flat world” all-drive businesses to achieve a level of disaster tolerance capable of ensuring continuous survival and profitability.

    Different businesses require different levels of risk with regard to loss of data and potential downtime. A variety of technical solutions can be used to provide varying levels of protection with respect to these business needs. The ideal solutions would have no downtime and allow no data to be lost. Although such solutions do exist, they are expensive, and hence their costs must be weighed against the potential impact of a disaster and its effects on the business.

  • Introduction to ERP Systems

    ERP Systems what is this?I remember attending my first Oracle Applications Users Group (OAUG) conference in 1999. I believe this was the year that Larry Ellison, CEO of Oracle Corporation, declared that the internet would change everything. The use of the internet in everyday business life was in full swing at that time and the dot.com boom was roaring with start ups in 90% of all garages in the bay area (slight exaggeration...), some of which had turned into enormously successful corporations. Indeed the internet has changed life throughout the world. Most of us arc just as lost without internet access as wc arc without our cell phones.

    The advent and evolution of ERP (Enterprise Resource Planning) systems have had and are still having almost as significant an impact on organizations as the internet has had on the individual. ERP systems such as SAP and Oracle’s suite of products (E-Business Suite (EBS), PeopleSoft, JD Edwards, Siebel, Hyperion, Fusion, etc) continue to cause a dramatic change in business and IT processes.

  • Introduction to PL/SQL

    PLSQL basics LearingStructured Query Language (SQL) is a language that has been widely accepted and adopted for accessing relational databases. This language allows users to perform database operations such as reading, creating, modifying, and deleting the data. Since the summer of 1970, when Dr. E.F. Codd published the paper A Relational Model of Data for Large Shared Data Banks for the ACM journal, the language has matured comprehensively as an industry standard. With its broad range of features and easy adaptation to enterprise environments, the SQL language has been typically regarded as the most reliable language for interacting with relational databases.

  • LPAD и RPAD - дополняем строку пробелами в PL/SQL

    Иногда в PL/SQL требуется, чтобы обрабатываемая строка имела фиксированный размер. Функции LPAD и RPAD дополняют строку пробелами (или другие символы) слева или справа до заданной длины. В следующем примере эти две функции выводят список имен в два столбца, причем левый столбец выравнивается по левому краю, а правый — по правому краю:

  • Oracle 24x7 Tips and Techniques


    Книга Oracle 24x7 Tips and TechniquesАвтор: Венкат С. Отель Devraj
    Издательство: компания osborne/mcgraw-Хилл

    Год:1 ноября 1999
    Страниц: 1005
    Язык: английский
    Формат:PDF (отсканированные страницы)
    ISBN: 0072119993

  • Oracle Dataguard: Standby Database Failover Handbook


    Книга Oracle Dataguard: Standby Database Failover Handbook Автор:Bipul Kumar 
    Издательство: Rampant Techpress

    Год:January 1, 2005
    Страниц: 230
    Язык: английский
    Формат: PDF
    ISBN: 0974599387

  • Oracle e-Business Suite: обзор продукта

    Обзор возможностей и модулей Oracle e-Business SuiteOracle EBusiness Suite представляет собой полнофункциональный набор бизнес приложений, обеспечивающих эффективное управление взаимодействием с клиентами, предоставлением услуг, выпуском продукции, доставкой заказов, приемом платежей и другими аспектами деятельности предприятия в рамках одной системы, созданной на базе единой информационной архитектуры.

  • Oracle Regular Expressions Pocket Reference

    Книга Oracle Regular Expressions Pocket Reference

     

    Автор:Jonathan Gennick, Peter Linsley
    ИздательствоO'Reilly Media

    Год:2009
    Страниц:66
    Языканглийский
    ФорматEbook (отличное), 0.5 Мб
    ISBN978-0-596-10438-2

  • Oracle SOA Patterns: Demystify Service Design and Implementation Patterns in Oracle SOA Suite


    Книга Oracle SOA PatternsАвтор:Kathiravan Udayakumar
    Издательство: Trafford 

    Год:September 11, 2008
    Страниц: 388
    Язык: английский
    Формат: PDF
    ISBN: 1466953209

  • Oracle's Regular Expression in SQL and PL/SQL

    Using Regular Expression in Oracle SQL and PL/SQL Oracle's regular expression support manifests itself in the form of three SQL functions and one predicate that you can use to search and manipulate text in any of Oracle's supported text datatypes: VARCHAR2, CHAR, NVARCHAR2, NCHAR, CLOB, and NCLOB.


     Regular expression support does not extend to LONG, because LONG is supported only for backward compatibility with existing code.


  • Oracle’s Approach to Big Data

    Oracle’s Approach to Big Data solutionsThe amount of data being generated is on the verge of an explosion, and according to an International Data Corporation (IDC) 2012 report, the total amount of data stored by corporations globally would surpass a zettabyte (1 zettabyte = 1 billion terabytes) by the end of 2012. Therefore, it is critical for the data companies to be prepared with an infrastructure that can store and analyze extremely large datasets, and be able to generate actionable intelligence that in turn can drive business decisions. Oracle offers a broad portfolio of products to help enterprises acquire, manage, and integrate big data with existing corporate data, and perform rich and intelligent analytics.

  • PL/SQL: синхронизация со столбцами таблицы базы данных Oracle

    Чтение и запись данных в таблицу базы данных в PL/SQLВ базе данных хранится информация, которая считывается и используется в приложении. Для работы с этой информацией используется как SQL, так и PL/SQL. При этом программы PL/SQL часто считывают информацию из базы данных Oracle, присваивают результат локальным переменным и после соответствующей обработки записывают информацию из переменных обратно в базу данных.

    Предположим, что таблица с данными о компаниях содержит столбец NAME с типом данных VARCHAR2(60). Локальная переменная для хранения значений этого столбца может быть объявлена следующим образом: 

  • Shared pool - разделяемый пул

    Разделяемый пул (shared pool) используется в базе данных Oracle для хранения следующей информации:

Page 1 of 3