A set of SQL statements accompanying an assigned name and stored in the database data dictionary is known as a stored procedure. Alternatively, a stored procedure can be understood as a subroutine available for applications that access an RDBMS. Typically, complex or extensive processing requiring execution of several SQL statements can be saved into stored […]
Successful digital transformations are not possible without successful data transformation. After all, it’s data—and the ability to analyze that data—about an organization’s customers, employees, infrastructure, market dynamics, supply chain, business-technology systems and more that make digital transformation possible. However, last year Gartner said that “information as an asset” is still in its infancy. “Data and analytics are […]
Step by step guide to becoming a modern PostgreSQL DBA The intent of this guide is to give you an idea about the DBA landscape and to help guide your learning if you are confused. The roadmap is highly opinionated — neither, knowing everything listed in the roadmap, nor the order of items given in […]
At the beginning of the decade, case was being made out for organizations to adopt a data driven business model to retain the competitive edge. This was because big data and analytics promised to transform business performance. As we stand at threshold of the next decade, data has become even more important, as evident in a survey […]
In today’s world, the ability to quickly create value from different types of data increasingly provides businesses with a competitive edge. An excellent example of this is how responsive, personalized and portable a food delivery app might be. But how does a business become data-driven? The easiest way for businesses to generate this type of value […]
Oracle Sharding is now available in Oracle Cloud with Oracle Database Cloud Service as well as Kubernetes and Docker containers (OKE). Oracle Sharding enables hyperscale, globally distributed, converged databases. It supports applications that require linear scalability, elasticity, fault isolation and geographic distribution of data for data sovereignty. It does so by distributing chunks of a data set across independent […]
The process of data entry involves entering business-specific data into an electronic form, often carried out by data entry operators who have special skills in processing all the business data efficiently. This conversion of data into a rather relevant, accurate and precise form is the need of the hour. Many industries deal in large volumes […]
Page faults are a prevalent error that mostly occurs in a large application involving large data. It takes place when MongoDB database reads data from physical memory rather than from virtual memory. Page fault errors occur at the moment MongoDB wants to get data that is not available in active memory of the database hence forced to read from […]
“Do what you do best and outsource the rest.” Coming from the “Father of outsourcing” Peter Drucker, this quote is a perfect fit in the context of modern businesses. Outsourcing is, after all, one of the biggest global trends of this millennium. Outsourcing has expanded into many domains in the last three decades. It’s registered […]
What is an Array? An array is a datatype or data structure or in layman terms a special variable that allows storing one or more values in a single variable e.g. — group of names, group of emails, group of products etc. When building any kind of application, the chances that you would not manipulate […]