�ݺ�ߣshows by User: MishaRosenblum

�ݺ�ߣshows by User: MishaRosenblum / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: MishaRosenblum / Tue, 31 May 2022 21:51:17 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: MishaRosenblum Building a Generic Search Screen using Dynamic SQL /slideshow/building-a-generic-search-screen-using-dynamic-sql/251894771 rosenblumsearchppt-220531215117-be7bad74
Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.]]>
Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.]]> Tue, 31 May 2022 21:51:17 GMT /slideshow/building-a-generic-search-screen-using-dynamic-sql/251894771 MishaRosenblum@slideshare.net(MishaRosenblum) Building a Generic Search Screen using Dynamic SQL MishaRosenblum Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumsearchppt-220531215117-be7bad74-thumbnail.jpg?width=120&height=120&fit=bounds" /> Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.

Building a Generic Search Screen using Dynamic SQL from Michael Rosenblum

]]> 92 0 https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumsearchppt-220531215117-be7bad74-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Managing the Earthquake: Surviving Major Database Architecture Changes (rev.2022) /slideshow/managing-the-earthquake-surviving-major-database-architecture-changes-rev2022/251886633 rosenblumeathquakeppt-220530212233-5c3bcced
Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.]]>
Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.]]> Mon, 30 May 2022 21:22:33 GMT /slideshow/managing-the-earthquake-surviving-major-database-architecture-changes-rev2022/251886633 MishaRosenblum@slideshare.net(MishaRosenblum) Managing the Earthquake: Surviving Major Database Architecture Changes (rev.2022) MishaRosenblum Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumeathquakeppt-220530212233-5c3bcced-thumbnail.jpg?width=120&height=120&fit=bounds" /> Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.

Managing the Earthquake: Surviving Major Database Architecture Changes (rev.2022) from Michael Rosenblum

]]> 94 0 https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumeathquakeppt-220530212233-5c3bcced-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Managing Unstructured Data: Lobs in the World of JSON /slideshow/managing-unstructured-data-lobs-in-the-world-of-json/242585576 lobsrosenblumppt-210211172732
One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to CLOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue! This presentation attempt to fill that knowledge gap: - Core conceptual elements of how Oracle works with LOBs (multi-segment storage, IO mechanism, copy semantics/pointer semantics, etc.) - SecureFiles/BasicFiles implementation issues - Best practices of LOB manipulation (both generic and JSON-related) Overall, this presentation gives database developers sufficient knowledge to be able to build efficient modern applications. Real-life examples will be included to pinpoint key ideas and solutions.]]>
One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to CLOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue! This presentation attempt to fill that knowledge gap: - Core conceptual elements of how Oracle works with LOBs (multi-segment storage, IO mechanism, copy semantics/pointer semantics, etc.) - SecureFiles/BasicFiles implementation issues - Best practices of LOB manipulation (both generic and JSON-related) Overall, this presentation gives database developers sufficient knowledge to be able to build efficient modern applications. Real-life examples will be included to pinpoint key ideas and solutions.]]> Thu, 11 Feb 2021 17:27:32 GMT /slideshow/managing-unstructured-data-lobs-in-the-world-of-json/242585576 MishaRosenblum@slideshare.net(MishaRosenblum) Managing Unstructured Data: Lobs in the World of JSON MishaRosenblum One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to CLOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue! This presentation attempt to fill that knowledge gap: - Core conceptual elements of how Oracle works with LOBs (multi-segment storage, IO mechanism, copy semantics/pointer semantics, etc.) - SecureFiles/BasicFiles implementation issues - Best practices of LOB manipulation (both generic and JSON-related) Overall, this presentation gives database developers sufficient knowledge to be able to build efficient modern applications. Real-life examples will be included to pinpoint key ideas and solutions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/lobsrosenblumppt-210211172732-thumbnail.jpg?width=120&height=120&fit=bounds" /> One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to CLOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue! This presentation attempt to fill that knowledge gap: - Core conceptual elements of how Oracle works with LOBs (multi-segment storage, IO mechanism, copy semantics/pointer semantics, etc.) - SecureFiles/BasicFiles implementation issues - Best practices of LOB manipulation (both generic and JSON-related) Overall, this presentation gives database developers sufficient knowledge to be able to build efficient modern applications. Real-life examples will be included to pinpoint key ideas and solutions.

Managing Unstructured Data: Lobs in the World of JSON from Michael Rosenblum

]]> 91 0 https://cdn.slidesharecdn.com/ss_thumbnails/lobsrosenblumppt-210211172732-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Hidden Gems of Performance Tuning: Hierarchical Profiler and DML Trigger Optimization /slideshow/hidden-gems-of-performance-tuning-hierarchical-profiler-and-dml-trigger-optimization/242481643 hiddengemsrosenblum-210209183342
In any large ecosystem, there are always areas that stay in the twilight, outside of the public’s attention. This deep dive attempts to change the trend regarding two, at first glance, unrelated PL/SQL topics: hierarchical profiler (HProf) and database triggers. But if you look closer, there’s something in common: they’re significantly underused! HProf because nobody heard about it, database triggers because of decades-old stigma. Let’s put both of them back into our development toolset! Part #1. One of the most critical FREE SQL and PL/SQL performance tuning tools is almost totally unknown! If you ask, how much time is spent on routine A? How often is function B called? Most developers would hand-code something instead of using the Oracle PL/SQL HProf. This isn’t because the provided functionality is disliked, but because developers aren’t aware of its existence! This presentation is an attempt to alter this trend and reintroduce HProf to a wider audience. Part #2. There isn’t anything “evil” about database triggers; they just have to be used where they can actually solve problems. In this presentation, various kinds of triggers will be examined from a global system optimization view, including tradeoffs between multiple goals (e.g., depending upon the available hardware, developers can select either CPU-intensive or I/O-intensive solutions). This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them.]]>
In any large ecosystem, there are always areas that stay in the twilight, outside of the public’s attention. This deep dive attempts to change the trend regarding two, at first glance, unrelated PL/SQL topics: hierarchical profiler (HProf) and database triggers. But if you look closer, there’s something in common: they’re significantly underused! HProf because nobody heard about it, database triggers because of decades-old stigma. Let’s put both of them back into our development toolset! Part #1. One of the most critical FREE SQL and PL/SQL performance tuning tools is almost totally unknown! If you ask, how much time is spent on routine A? How often is function B called? Most developers would hand-code something instead of using the Oracle PL/SQL HProf. This isn’t because the provided functionality is disliked, but because developers aren’t aware of its existence! This presentation is an attempt to alter this trend and reintroduce HProf to a wider audience. Part #2. There isn’t anything “evil” about database triggers; they just have to be used where they can actually solve problems. In this presentation, various kinds of triggers will be examined from a global system optimization view, including tradeoffs between multiple goals (e.g., depending upon the available hardware, developers can select either CPU-intensive or I/O-intensive solutions). This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them.]]> Tue, 09 Feb 2021 18:33:42 GMT /slideshow/hidden-gems-of-performance-tuning-hierarchical-profiler-and-dml-trigger-optimization/242481643 MishaRosenblum@slideshare.net(MishaRosenblum) Hidden Gems of Performance Tuning: Hierarchical Profiler and DML Trigger Optimization MishaRosenblum In any large ecosystem, there are always areas that stay in the twilight, outside of the public’s attention. This deep dive attempts to change the trend regarding two, at first glance, unrelated PL/SQL topics: hierarchical profiler (HProf) and database triggers. But if you look closer, there’s something in common: they’re significantly underused! HProf because nobody heard about it, database triggers because of decades-old stigma. Let’s put both of them back into our development toolset! Part #1. One of the most critical FREE SQL and PL/SQL performance tuning tools is almost totally unknown! If you ask, how much time is spent on routine A? How often is function B called? Most developers would hand-code something instead of using the Oracle PL/SQL HProf. This isn’t because the provided functionality is disliked, but because developers aren’t aware of its existence! This presentation is an attempt to alter this trend and reintroduce HProf to a wider audience. Part #2. There isn’t anything “evil” about database triggers; they just have to be used where they can actually solve problems. In this presentation, various kinds of triggers will be examined from a global system optimization view, including tradeoffs between multiple goals (e.g., depending upon the available hardware, developers can select either CPU-intensive or I/O-intensive solutions). This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/hiddengemsrosenblum-210209183342-thumbnail.jpg?width=120&height=120&fit=bounds" /> In any large ecosystem, there are always areas that stay in the twilight, outside of the public’s attention. This deep dive attempts to change the trend regarding two, at first glance, unrelated PL/SQL topics: hierarchical profiler (HProf) and database triggers. But if you look closer, there’s something in common: they’re significantly underused! HProf because nobody heard about it, database triggers because of decades-old stigma. Let’s put both of them back into our development toolset! Part #1. One of the most critical FREE SQL and PL/SQL performance tuning tools is almost totally unknown! If you ask, how much time is spent on routine A? How often is function B called? Most developers would hand-code something instead of using the Oracle PL/SQL HProf. This isn’t because the provided functionality is disliked, but because developers aren’t aware of its existence! This presentation is an attempt to alter this trend and reintroduce HProf to a wider audience. Part #2. There isn’t anything “evil” about database triggers; they just have to be used where they can actually solve problems. In this presentation, various kinds of triggers will be examined from a global system optimization view, including tradeoffs between multiple goals (e.g., depending upon the available hardware, developers can select either CPU-intensive or I/O-intensive solutions). This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them.

Hidden Gems of Performance Tuning: Hierarchical Profiler and DML Trigger Optimization from Michael Rosenblum

]]> 111 0 https://cdn.slidesharecdn.com/ss_thumbnails/hiddengemsrosenblum-210209183342-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Server-Side Development�for the Cloud /slideshow/serverside-developmentfor-the-cloud/123555107 tip1396rosenblumcloud-181120211331
Bringing Oracle databases to the cloud involves major tectonic shifts: (1) hardware resources are no longer static and (2) expense model is “pay-per-use”. Previously, as long as your current servers were surviving the workload, no one cared whether they were under-utilized. Now, this difference can be immediately monetized because the resource elasticity means that you can give it back. As a result, the total quality of the code base (+performance tuning) has a direct impact on cost. This presentation will share some of the corresponding best practices: code instrumentation, profiling, code management, resource optimization etc. Overall, you can make your system cloud-friendly, but doing so takes explicit effort and serious thinking!]]>
Bringing Oracle databases to the cloud involves major tectonic shifts: (1) hardware resources are no longer static and (2) expense model is “pay-per-use”. Previously, as long as your current servers were surviving the workload, no one cared whether they were under-utilized. Now, this difference can be immediately monetized because the resource elasticity means that you can give it back. As a result, the total quality of the code base (+performance tuning) has a direct impact on cost. This presentation will share some of the corresponding best practices: code instrumentation, profiling, code management, resource optimization etc. Overall, you can make your system cloud-friendly, but doing so takes explicit effort and serious thinking!]]> Tue, 20 Nov 2018 21:13:31 GMT /slideshow/serverside-developmentfor-the-cloud/123555107 MishaRosenblum@slideshare.net(MishaRosenblum) Server-Side Development�for the Cloud MishaRosenblum Bringing Oracle databases to the cloud involves major tectonic shifts: (1) hardware resources are no longer static and (2) expense model is “pay-per-use”. Previously, as long as your current servers were surviving the workload, no one cared whether they were under-utilized. Now, this difference can be immediately monetized because the resource elasticity means that you can give it back. As a result, the total quality of the code base (+performance tuning) has a direct impact on cost. This presentation will share some of the corresponding best practices: code instrumentation, profiling, code management, resource optimization etc. Overall, you can make your system cloud-friendly, but doing so takes explicit effort and serious thinking! <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/tip1396rosenblumcloud-181120211331-thumbnail.jpg?width=120&height=120&fit=bounds" /> Bringing Oracle databases to the cloud involves major tectonic shifts: (1) hardware resources are no longer static and (2) expense model is “pay-per-use”. Previously, as long as your current servers were surviving the workload, no one cared whether they were under-utilized. Now, this difference can be immediately monetized because the resource elasticity means that you can give it back. As a result, the total quality of the code base (+performance tuning) has a direct impact on cost. This presentation will share some of the corresponding best practices: code instrumentation, profiling, code management, resource optimization etc. Overall, you can make your system cloud-friendly, but doing so takes explicit effort and serious thinking!

Server-Side Development for the Cloud from Michael Rosenblum

]]> 74 2 https://cdn.slidesharecdn.com/ss_thumbnails/tip1396rosenblumcloud-181120211331-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Developer's Approach to Code Management /slideshow/developers-approach-to-code-management/74470903 2017415rosenblumpptcode-170405182159
This presentation is the attempt to switch sides and show code management from the developer's point of view. It stays outside of various VCS solutions and focuses on hands-on approaches: activity control via system triggers, conditional compilation, synonym manipulation, utilization of Edition-Based Redefinition (EBR).]]>
This presentation is the attempt to switch sides and show code management from the developer's point of view. It stays outside of various VCS solutions and focuses on hands-on approaches: activity control via system triggers, conditional compilation, synonym manipulation, utilization of Edition-Based Redefinition (EBR).]]> Wed, 05 Apr 2017 18:21:59 GMT /slideshow/developers-approach-to-code-management/74470903 MishaRosenblum@slideshare.net(MishaRosenblum) Developer's Approach to Code Management MishaRosenblum This presentation is the attempt to switch sides and show code management from the developer's point of view. It stays outside of various VCS solutions and focuses on hands-on approaches: activity control via system triggers, conditional compilation, synonym manipulation, utilization of Edition-Based Redefinition (EBR). <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2017415rosenblumpptcode-170405182159-thumbnail.jpg?width=120&height=120&fit=bounds" /> This presentation is the attempt to switch sides and show code management from the developer's point of view. It stays outside of various VCS solutions and focuses on hands-on approaches: activity control via system triggers, conditional compilation, synonym manipulation, utilization of Edition-Based Redefinition (EBR).

Developer's Approach to Code Management from Michael Rosenblum

]]> 482 4 https://cdn.slidesharecdn.com/ss_thumbnails/2017415rosenblumpptcode-170405182159-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 The Hidden Face of Cost-Based Optimizer: PL/SQL Specific Statistics /slideshow/the-hidden-face-of-costbased-optimizer-plsql-specific-statistics/66350120 2016ugf2781rosenblumppt-160923163919
Database statistics are not limited to tables, columns, and indexes. PL/SQL functions also have a number of associated statistics, namely costs (CPU, I/O, network), selectivity, and cardinality (for functions that return collections). These statistics have default values that only somewhat represent reality. However, these values are always used by Oracle's cost-based optimizer to build execution plans. This session uses real-life examples to illustrate how properly managed PL/SQL statistics can significantly improve executions plans. It also demonstrates that Oracle's extensible optimizer is flexible enough to support packaged functions.]]>
Database statistics are not limited to tables, columns, and indexes. PL/SQL functions also have a number of associated statistics, namely costs (CPU, I/O, network), selectivity, and cardinality (for functions that return collections). These statistics have default values that only somewhat represent reality. However, these values are always used by Oracle's cost-based optimizer to build execution plans. This session uses real-life examples to illustrate how properly managed PL/SQL statistics can significantly improve executions plans. It also demonstrates that Oracle's extensible optimizer is flexible enough to support packaged functions.]]> Fri, 23 Sep 2016 16:39:19 GMT /slideshow/the-hidden-face-of-costbased-optimizer-plsql-specific-statistics/66350120 MishaRosenblum@slideshare.net(MishaRosenblum) The Hidden Face of Cost-Based Optimizer: PL/SQL Specific Statistics MishaRosenblum Database statistics are not limited to tables, columns, and indexes. PL/SQL functions also have a number of associated statistics, namely costs (CPU, I/O, network), selectivity, and cardinality (for functions that return collections). These statistics have default values that only somewhat represent reality. However, these values are always used by Oracle's cost-based optimizer to build execution plans. This session uses real-life examples to illustrate how properly managed PL/SQL statistics can significantly improve executions plans. It also demonstrates that Oracle's extensible optimizer is flexible enough to support packaged functions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2016ugf2781rosenblumppt-160923163919-thumbnail.jpg?width=120&height=120&fit=bounds" /> Database statistics are not limited to tables, columns, and indexes. PL/SQL functions also have a number of associated statistics, namely costs (CPU, I/O, network), selectivity, and cardinality (for functions that return collections). These statistics have default values that only somewhat represent reality. However, these values are always used by Oracle's cost-based optimizer to build execution plans. This session uses real-life examples to illustrate how properly managed PL/SQL statistics can significantly improve executions plans. It also demonstrates that Oracle's extensible optimizer is flexible enough to support packaged functions.

The Hidden Face of Cost-Based Optimizer: PL/SQL Specific Statistics from Michael Rosenblum

]]> 217 3 https://cdn.slidesharecdn.com/ss_thumbnails/2016ugf2781rosenblumppt-160923163919-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Why is the application running so slowly? /slideshow/why-is-the-application-running-so-slowly/66350056 2016ugf2778rosenblumdorseyppt-160923163653
When performance issues arise, developers often blame the database, while DBAs are quick to blame developers. If all else fails, the network is the culprit. Most systems have many parts managed by multiple entities within an organization. This session explores how to improve system quality by proper monitoring of user activity rather than server activity. Without an overall architectural approach to performance tuning, any aggregated statistics (CPU workload, communication speed, network latency, etc.) are meaningless unless you can explain to a user why a button click takes so much time. This session offers a coherent methodology for identifying performance issues, pinpointing common problem sources, and providing solutions.]]>
When performance issues arise, developers often blame the database, while DBAs are quick to blame developers. If all else fails, the network is the culprit. Most systems have many parts managed by multiple entities within an organization. This session explores how to improve system quality by proper monitoring of user activity rather than server activity. Without an overall architectural approach to performance tuning, any aggregated statistics (CPU workload, communication speed, network latency, etc.) are meaningless unless you can explain to a user why a button click takes so much time. This session offers a coherent methodology for identifying performance issues, pinpointing common problem sources, and providing solutions.]]> Fri, 23 Sep 2016 16:36:52 GMT /slideshow/why-is-the-application-running-so-slowly/66350056 MishaRosenblum@slideshare.net(MishaRosenblum) Why is the application running so slowly? MishaRosenblum When performance issues arise, developers often blame the database, while DBAs are quick to blame developers. If all else fails, the network is the culprit. Most systems have many parts managed by multiple entities within an organization. This session explores how to improve system quality by proper monitoring of user activity rather than server activity. Without an overall architectural approach to performance tuning, any aggregated statistics (CPU workload, communication speed, network latency, etc.) are meaningless unless you can explain to a user why a button click takes so much time. This session offers a coherent methodology for identifying performance issues, pinpointing common problem sources, and providing solutions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2016ugf2778rosenblumdorseyppt-160923163653-thumbnail.jpg?width=120&height=120&fit=bounds" /> When performance issues arise, developers often blame the database, while DBAs are quick to blame developers. If all else fails, the network is the culprit. Most systems have many parts managed by multiple entities within an organization. This session explores how to improve system quality by proper monitoring of user activity rather than server activity. Without an overall architectural approach to performance tuning, any aggregated statistics (CPU workload, communication speed, network latency, etc.) are meaningless unless you can explain to a user why a button click takes so much time. This session offers a coherent methodology for identifying performance issues, pinpointing common problem sources, and providing solutions.

Why is the application running so slowly? from Michael Rosenblum

]]> 420 3 https://cdn.slidesharecdn.com/ss_thumbnails/2016ugf2778rosenblumdorseyppt-160923163653-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Printing without printers /MishaRosenblum/printing-without-printers 20161563rosenblumprintingppt-160420152548
Every contemporary organization sooner than later has to solve the problem of document exchange, especially in such tightly regulated areas as health care and government services. Lots and lots of official forms have to be filled and processed exactly as mandated – preserving standards pixel by pixel. Another big issue is reporting, because end-users now want very high flexibility and customization without losing any performance (and without paying too much!). Meeting these requirements in not very trivial, but definitely doable! This presentation is focused on one of the possible approaches – using database not only for data processing, but for creating final documents. A number of examples from real-life projects will show how PDF and Excel files can be efficiently prepared without leaving your server – as long as you have appropriate tools and mechanisms: some of them are home-grown (reporting repositories and XLS generators), some of them are developed by others (PL/PDF, ITEXT, PL/JSON). This presentation will show how strengths and weaknesses of this approach, explain reasons of such technology selection and history of experience.]]>
Every contemporary organization sooner than later has to solve the problem of document exchange, especially in such tightly regulated areas as health care and government services. Lots and lots of official forms have to be filled and processed exactly as mandated – preserving standards pixel by pixel. Another big issue is reporting, because end-users now want very high flexibility and customization without losing any performance (and without paying too much!). Meeting these requirements in not very trivial, but definitely doable! This presentation is focused on one of the possible approaches – using database not only for data processing, but for creating final documents. A number of examples from real-life projects will show how PDF and Excel files can be efficiently prepared without leaving your server – as long as you have appropriate tools and mechanisms: some of them are home-grown (reporting repositories and XLS generators), some of them are developed by others (PL/PDF, ITEXT, PL/JSON). This presentation will show how strengths and weaknesses of this approach, explain reasons of such technology selection and history of experience.]]> Wed, 20 Apr 2016 15:25:48 GMT /MishaRosenblum/printing-without-printers MishaRosenblum@slideshare.net(MishaRosenblum) Printing without printers MishaRosenblum Every contemporary organization sooner than later has to solve the problem of document exchange, especially in such tightly regulated areas as health care and government services. Lots and lots of official forms have to be filled and processed exactly as mandated – preserving standards pixel by pixel. Another big issue is reporting, because end-users now want very high flexibility and customization without losing any performance (and without paying too much!). Meeting these requirements in not very trivial, but definitely doable! This presentation is focused on one of the possible approaches – using database not only for data processing, but for creating final documents. A number of examples from real-life projects will show how PDF and Excel files can be efficiently prepared without leaving your server – as long as you have appropriate tools and mechanisms: some of them are home-grown (reporting repositories and XLS generators), some of them are developed by others (PL/PDF, ITEXT, PL/JSON). This presentation will show how strengths and weaknesses of this approach, explain reasons of such technology selection and history of experience. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/20161563rosenblumprintingppt-160420152548-thumbnail.jpg?width=120&height=120&fit=bounds" /> Every contemporary organization sooner than later has to solve the problem of document exchange, especially in such tightly regulated areas as health care and government services. Lots and lots of official forms have to be filled and processed exactly as mandated – preserving standards pixel by pixel. Another big issue is reporting, because end-users now want very high flexibility and customization without losing any performance (and without paying too much!). Meeting these requirements in not very trivial, but definitely doable! This presentation is focused on one of the possible approaches – using database not only for data processing, but for creating final documents. A number of examples from real-life projects will show how PDF and Excel files can be efficiently prepared without leaving your server – as long as you have appropriate tools and mechanisms: some of them are home-grown (reporting repositories and XLS generators), some of them are developed by others (PL/PDF, ITEXT, PL/JSON). This presentation will show how strengths and weaknesses of this approach, explain reasons of such technology selection and history of experience.

Printing without printers from Michael Rosenblum

]]> 651 1 https://cdn.slidesharecdn.com/ss_thumbnails/20161563rosenblumprintingppt-160420152548-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 PL/SQL User-Defined Functions in the Read World /slideshow/plsql-userdefined-functions-in-the-read-world/61151128 2014589rosenblumppt-160420151901
For most developers, knowledge of PL/SQL starts from writing user-defined functions. As a result, even if this code is functionally correct, the program units are fired significantly more often than needed, impact CBO decisions, and cause execution plan degradation. This section addresses these issues and includes a number of examples of how PL/SQL can extend basic SQL functionality.]]>
For most developers, knowledge of PL/SQL starts from writing user-defined functions. As a result, even if this code is functionally correct, the program units are fired significantly more often than needed, impact CBO decisions, and cause execution plan degradation. This section addresses these issues and includes a number of examples of how PL/SQL can extend basic SQL functionality.]]> Wed, 20 Apr 2016 15:19:01 GMT /slideshow/plsql-userdefined-functions-in-the-read-world/61151128 MishaRosenblum@slideshare.net(MishaRosenblum) PL/SQL User-Defined Functions in the Read World MishaRosenblum For most developers, knowledge of PL/SQL starts from writing user-defined functions. As a result, even if this code is functionally correct, the program units are fired significantly more often than needed, impact CBO decisions, and cause execution plan degradation. This section addresses these issues and includes a number of examples of how PL/SQL can extend basic SQL functionality. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2014589rosenblumppt-160420151901-thumbnail.jpg?width=120&height=120&fit=bounds" /> For most developers, knowledge of PL/SQL starts from writing user-defined functions. As a result, even if this code is functionally correct, the program units are fired significantly more often than needed, impact CBO decisions, and cause execution plan degradation. This section addresses these issues and includes a number of examples of how PL/SQL can extend basic SQL functionality.

PL/SQL User-Defined Functions in the Read World from Michael Rosenblum

]]> 1157 1 https://cdn.slidesharecdn.com/ss_thumbnails/2014589rosenblumppt-160420151901-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 A New View of Database Views /slideshow/2015-458-rosenblumpptfinal/46956333 2015458rosenblumpptfinal-150413175607-conversion-gate01
Too many of us have been taught that views are nothing more than stored SQL statements. The goal of this presentation is to challenge this notion. Or, to be precise, to take you one step further, from technicalities to the huge role that well-designed views can play in contemporary database solutions. Current views are very advanced. They can be built on top of user-defined functions; they can utilize extremely complex INSTEAD-OF triggers (including composite ones), and they can even have indexes! As a result, with all of this added functionality views can serve as an isolation level between UI-driven data representation (heavily denormalized and customized) and DBA-driven data representation (normalized with referential integrity constraints and foreign keys). Contemporary IT solutions often take this transformation completely out of the database, usually moving it to the middle-tier. This presentation will show that keeping business logic IN the database provides you with much greater flexibility, manageability, and performance. Of course, there are some traps and pitfalls, but these are also avoidable. Real-world examples will be provided to show that the role of views is seriously underestimated.]]>
Too many of us have been taught that views are nothing more than stored SQL statements. The goal of this presentation is to challenge this notion. Or, to be precise, to take you one step further, from technicalities to the huge role that well-designed views can play in contemporary database solutions. Current views are very advanced. They can be built on top of user-defined functions; they can utilize extremely complex INSTEAD-OF triggers (including composite ones), and they can even have indexes! As a result, with all of this added functionality views can serve as an isolation level between UI-driven data representation (heavily denormalized and customized) and DBA-driven data representation (normalized with referential integrity constraints and foreign keys). Contemporary IT solutions often take this transformation completely out of the database, usually moving it to the middle-tier. This presentation will show that keeping business logic IN the database provides you with much greater flexibility, manageability, and performance. Of course, there are some traps and pitfalls, but these are also avoidable. Real-world examples will be provided to show that the role of views is seriously underestimated.]]> Mon, 13 Apr 2015 17:56:07 GMT /slideshow/2015-458-rosenblumpptfinal/46956333 MishaRosenblum@slideshare.net(MishaRosenblum) A New View of Database Views MishaRosenblum Too many of us have been taught that views are nothing more than stored SQL statements. The goal of this presentation is to challenge this notion. Or, to be precise, to take you one step further, from technicalities to the huge role that well-designed views can play in contemporary database solutions. Current views are very advanced. They can be built on top of user-defined functions; they can utilize extremely complex INSTEAD-OF triggers (including composite ones), and they can even have indexes! As a result, with all of this added functionality views can serve as an isolation level between UI-driven data representation (heavily denormalized and customized) and DBA-driven data representation (normalized with referential integrity constraints and foreign keys). Contemporary IT solutions often take this transformation completely out of the database, usually moving it to the middle-tier. This presentation will show that keeping business logic IN the database provides you with much greater flexibility, manageability, and performance. Of course, there are some traps and pitfalls, but these are also avoidable. Real-world examples will be provided to show that the role of views is seriously underestimated. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/2015458rosenblumpptfinal-150413175607-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds" /> Too many of us have been taught that views are nothing more than stored SQL statements. The goal of this presentation is to challenge this notion. Or, to be precise, to take you one step further, from technicalities to the huge role that well-designed views can play in contemporary database solutions. Current views are very advanced. They can be built on top of user-defined functions; they can utilize extremely complex INSTEAD-OF triggers (including composite ones), and they can even have indexes! As a result, with all of this added functionality views can serve as an isolation level between UI-driven data representation (heavily denormalized and customized) and DBA-driven data representation (normalized with referential integrity constraints and foreign keys). Contemporary IT solutions often take this transformation completely out of the database, usually moving it to the middle-tier. This presentation will show that keeping business logic IN the database provides you with much greater flexibility, manageability, and performance. Of course, there are some traps and pitfalls, but these are also avoidable. Real-world examples will be provided to show that the role of views is seriously underestimated.

A New View of Database Views from Michael Rosenblum

]]> 1114 0 https://cdn.slidesharecdn.com/ss_thumbnails/2015458rosenblumpptfinal-150413175607-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Data Tracking: On the Hunt for Information about Your Database /slideshow/data-tracking-on-the-hunt-for-information-about-your-database/20497696 rosenblumdatatracking-130503143614-phpapp01
Behind the scenes, Oracle databases hide a myriad of processes to ensure that your data can be safely stored and retrieved. These processes also leave “tracks” (or they COULD leave tracks if you set them up properly). These tracks, together with application-specific data, create a complete representation of the system’s day-to-day activity. Too often this representation is lost at the DBA/Developer borderline, mostly because one side is not aware of the needs of the other. This presentation strives to bridge this gap. It focuses on key sources of database information and techniques that are useful for both DBAs and developers: - Data Dictionary - Oracle Logging - Oracle Tracing - Advanced code instrumentation]]>
Behind the scenes, Oracle databases hide a myriad of processes to ensure that your data can be safely stored and retrieved. These processes also leave “tracks” (or they COULD leave tracks if you set them up properly). These tracks, together with application-specific data, create a complete representation of the system’s day-to-day activity. Too often this representation is lost at the DBA/Developer borderline, mostly because one side is not aware of the needs of the other. This presentation strives to bridge this gap. It focuses on key sources of database information and techniques that are useful for both DBAs and developers: - Data Dictionary - Oracle Logging - Oracle Tracing - Advanced code instrumentation]]> Fri, 03 May 2013 14:36:14 GMT /slideshow/data-tracking-on-the-hunt-for-information-about-your-database/20497696 MishaRosenblum@slideshare.net(MishaRosenblum) Data Tracking: On the Hunt for Information about Your Database MishaRosenblum Behind the scenes, Oracle databases hide a myriad of processes to ensure that your data can be safely stored and retrieved. These processes also leave “tracks” (or they COULD leave tracks if you set them up properly). These tracks, together with application-specific data, create a complete representation of the system’s day-to-day activity. Too often this representation is lost at the DBA/Developer borderline, mostly because one side is not aware of the needs of the other. This presentation strives to bridge this gap. It focuses on key sources of database information and techniques that are useful for both DBAs and developers: - Data Dictionary - Oracle Logging - Oracle Tracing - Advanced code instrumentation <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumdatatracking-130503143614-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds" /> Behind the scenes, Oracle databases hide a myriad of processes to ensure that your data can be safely stored and retrieved. These processes also leave “tracks” (or they COULD leave tracks if you set them up properly). These tracks, together with application-specific data, create a complete representation of the system’s day-to-day activity. Too often this representation is lost at the DBA/Developer borderline, mostly because one side is not aware of the needs of the other. This presentation strives to bridge this gap. It focuses on key sources of database information and techniques that are useful for both DBAs and developers: - Data Dictionary - Oracle Logging - Oracle Tracing - Advanced code instrumentation

Data Tracking: On the Hunt for Information about Your Database from Michael Rosenblum

]]> 730 1 https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumdatatracking-130503143614-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://cdn.slidesharecdn.com/profile-photo-MishaRosenblum-48x48.jpg?cb=1661968219 * Oracle ACE * Software Architect / Senior DBA at Dulcian, Inc. responsible for system tuning and application architecture. * Technical Project Manager of the BRIM(c) set of products by Dulcian Inc. * Co-author of PL/SQL for Dummies (Wiley Press, 2006), PL/SQL Performance Tuning Tips & Techniques (Oracle Press, 2014) * Contributing author of Expert PL/SQL Practices (APress, 2011) * Frequent presenter at various regional and national Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG etc) wonderingmisha.blogspot.com/ https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumsearchppt-220531215117-be7bad74-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/building-a-generic-search-screen-using-dynamic-sql/251894771 Building a Generic Sea... https://cdn.slidesharecdn.com/ss_thumbnails/rosenblumeathquakeppt-220530212233-5c3bcced-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/managing-the-earthquake-surviving-major-database-architecture-changes-rev2022/251886633 Managing the Earthquak... https://cdn.slidesharecdn.com/ss_thumbnails/lobsrosenblumppt-210211172732-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/managing-unstructured-data-lobs-in-the-world-of-json/242585576 Managing Unstructured ...