Tag: Database

This is a beginner level presentation on partitioning. It includes tips for beginners on the four main ways to partition a table. I will show an example of each type of partitioning as well as benefits of each. I will also show how to merge and split partitions.

MDM sits at the center of the ideal information architecture. It supports application integration and service oriented architectures. It uses its accumulation of quality governed dimensions, cross-references, and hierarchies to support data warehousing and business intelligence applications. It acts as the glue between operations and analytics that has been missing for over two decades. This…

MDM sits at the center of the ideal information architecture. It supports application integration and service oriented architectures. It uses its accumulation of quality governed dimensions, cross-references, and hierarchies to support data warehousing and business intelligence applications. It acts as the glue between operations and analytics that has been missing for over two decades. This…

An overview of the MySQL centric architecture currently being used and expanded to collect, analyze, and report on alternative energy (Solar/Wind/etc) usage and deployments accross the country. This application monitors thousands of "green" deployments and collects data ranging from power output to weather conditions. We will talk about the challenges in dealing with extremely large…

An overview of the MySQL centric architecture currently being used and expanded to collect, analyze, and report on alternative energy (Solar/Wind/etc) usage and deployments accross the country. This application monitors thousands of "green" deployments and collects data ranging from power output to weather conditions. We will talk about the challenges in dealing with extremely large…

What's the right solution for your content management needs - Oracle Content Management or SharePoint or both. This presentation will try to provide an understanding of the strengths and weaknesses of these two competing but compatable content management solutions while presenting a business strategy to use both of them at the same time. See how…

Attendees areintroduced to the new and improved features of Oracle 11g (both Oracle 11g R1and Oracle 11g R2) that directly impact application development. Specialemphasis is placed on features that reduce development time, make developmentsimpler, improve performance, or speed deployment. Specific topics include: NewSQL functions, new analytic functions, virtual columns, result caching, XML improvements,pivot statements, JDBC…

Attendees areintroduced to the new and improved features of Oracle 11g (both Oracle 11g R1and Oracle 11g R2) that directly impact application development. Specialemphasis is placed on features that reduce development time, make developmentsimpler, improve performance, or speed deployment. Specific topics include: NewSQL functions, new analytic functions, virtual columns, result caching, XML improvements,pivot statements, JDBC…