database Articles - Perficient Blogs

Posts Tagged ‘database’

  • Topics
  • Industries
  • Partners





The Increasing Need for Database Clustering

The database is a significant piece of any application, ready to store and retrieve information for manipulation. The database server itself might be the back-end of a database application (the occurrence), or it might be the equipment PC that has the example. Now and again, it might even allude to the mix of both equipment […]

Read more

Oracle ERP Cloud: Clutter Free Supplier Database

Improving the Quality & Accuracy of Your Supplier Database In the information era data ages rapidly.  Organizations deal with data changes as trading partners relocate, mergers take place, or employees move from one organization to another. In addition, the database is loaded with duplicate, inaccurate and incomplete data. Organizations incur huge costs allocating resources towards […]

Read more

Working With Multiple LOCAL_XE Databases In Siebel IP2016

In Siebel IP2016, the Sybase database was replaced with Oracle’s own XE database. The switch has presented some advantages and some drawbacks. One of the advantages is that you can have multiple instances. In my case, I have one instance for each IP2016 project that I am working on. This is the blog that I […]

Read more

Basic usage about Hibernate

What is Hibernate? Hibernate, as an ORM (Object rational Mapping) solution, effectively “sits between” the Java application data access layer and the Relational Database, as can be seen in the diagram above. The Java application makes use of the Hibernate APIs to load, store, query, etc its domain data. Why use Hibernate? High Cross-database portability […]

Read more

3 Reasons to Use Amazon DynamoDB for Data Management

Data management is at the heart of every enterprise, especially with online operations. Though many have used MySQL relational databases to manage their data, the rise of NoSQL (Not Only SQL) and its faster data operations has come into use with the amount of data being created. One of the leading NoSQL platforms on the […]

Read more

Processing Flat Files in Oracle Database

These days most of the companies are using Oracle as their database to maintain their data. SQL*Plus is the major tool to access the Oracle DB because it is more secure than other tools. Handling flat files in the Oracle DB by using SQL*Plus is difficult one. SQL Loader is the one which is very use […]

Read more

Most Common NoSQL Databases

Key-value pair NoSQL databases Most basic type of NoSQL database Two main concepts are Keys and Values Keys are nothing but identifiers through which you can refer values Values are values corresponding to a key Values can be like string, blob, image etc. Some database support buckets to provide separate placeholder to logically separate data. […]

Read more

Azure ARM Template: Define Web App Application Settings

The previous article in this series covered how to define database Connection Strings for an App Service Web App within an ARM Template. This article will continue to build on the foundation of deploying a Web App using an ARM Template by exploring how to define Application Settings (aka appSettings) for an App Service Web […]

Read more

Azure ARM Template: Define Web App Connection Strings

Previous articles covered what Azure Resource Manager is, along with how to setup an Azure Resource Group project within Visual Studio 2015 to deploy an ASP.NET Web Application to Azure as an App Service Web App. Being able to deploy an application to Azure is just the first step. In order to really use ARM […]

Read more

NoSQL NoSecurity – Security issues with NoSQL Database

As More companies’ debate on adopting a Big Data Solution. Some of the discussion that comes across is whether to use Hadoop or Spark, NoSQL database or continue using their current RDBMS. The ultimate question is “is this technology for us?”  NoSQL database are highly scalable, provide better performance, designed to store and process a […]

Read more

Making The Oracle Pivot Function Work For You

  Ah, the never-ending task of transposing rows into columns and columns into rows in an Oracle table! There was always a fairly standard max-decode solution for this until Oracle came up with their elegant pivot and unpivot standard functions in 11g. Recently, I had a close encounter with these pivot functions and learned a […]

Read more

Declarative data caching in .NET business layer

One of the most effective ways to improve application performance is to implement data caching. Most of the applications are relatively retrieving the same data from external sources like database of web service and if that source data is never or seldom changes then application is just wasting CPU time and I/O querying the source […]

Read more

Why WebSphere MQ as opposed to RDBMS for WMB

One of the most asked questions in a project from the client was how feasible is it to use Database as the intermediary transport layer for Websphere Message Broker. No doubt there is a long term benefit in using WMQ but the question is more short sighted as per the immediate benefits of leveraging the […]

Read more

Databases & hardware: Hot topics at OpenWorld – #OOW13

60,000 people will convene to watch 3,600 partners and customers speak in sessions at Oracle OpenWorld this week. Oracle’s rockstar, chief executive Larry Ellison, kicked off Oracle OpenWorld on Sunday evening, highlighting a shift to “in-memory technology to speed up by as much as 100 times the databases that are the foundation of the company’s business.” Ellison presented: […]

Read more

Amazon Web Services Gives Customer Free Database Access

I found the CRN article describing Amazon’s adding their Relational Database Services to its Free Usage Tier.    What I find interesting is that when AWS became a household name (OK, industry wide name)  about two years ago, my first thought was that vendors like IBM, Oracle, JBoss, and Liferay ought to just add the db […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up