CATEGORY: DATABASE TECHNOLOGY TRENDS

Behind the Scenes of Database Evolution

What Can AI Do for You?

By | Blog
Artificial Intelligence and Machine learning algorithms are continually increasing in their sophistication and application. These programs are designed to utilize input to learn and evolve, rewriting themselves and building in their capabilities. When used for a specific task, AI and machine learning programs get better and faster as they go, learning and growing more familiar with the data set, trends, and patterns of their workload. This has exciting applications for businesses looking to speed up processing, analyze big data, and reduce on human resources. From improved automation to customer outreach and security, here are 10 ways AI can help any business. 1. Automation – AI is great at taking over routine tasks and automating time-consuming . From virtual automation, like Robotic Process Automation (RPA) to machining and manufacturing, AI can take over many tasks once relegated to the grunt work pile. Programs and machines run by AI don’t get tired, don’t get bored, and don’t make human errors. This makes them particularly valuable for handling dangerous or hazardous tasks in industry and manufacturing. 2. Forecasting – Knowing how much to produce comes down to accurate forecasting. That is, analyzing sales trends to see how much product you anticipate moving (more…)

The Rise of Edge Computing

By | Blog
In today’s age of big data and instant gratification, issues of speed and are at the forefront of technology solutions. The development of cloud computing environments represented a major breakthrough in this effort, but these cloud servers are still a centralized solution, subject to the challenges therein. As the cloud becomes more and more saturated with data and processing needs, issues of latency and bottlenecking grow. The drive to mimic instantaneous transfer means even instances of latency can create big problems. Edge computing is the next step in ensuring the most powerful and scalable processing capabilities and provides vital support to traditional cloud server banks. Edge Evolution Edge computing came about as an organic evolution of technological advancements and the benefits and drawbacks of cloud computing. The amount of data being used, stored, processed, and accessed at any given time is extraordinary. Many personal and company computing needs are now being accomplished on the cloud. But don’t think of the cloud as a decentralized nebulous network. Cloud processing still takes place in a centralized location. In this case, it is one of several server banks owned by the various cloud providers. When a cloud customer wants to perform (more…)

Why OCI is the Perfect Platform for Oracle EBS

By | Blog, Oracle
E-Business Suite (EBS) is a fantastic compilation of tools for consolidating your enterprise functionality, management, and analytics. But what platform should you use to make the most out of your EBS? On-prem or third-party cloud infrastructure may not be making the most out of your applications. With Cloud Infrastructure (OCI) you will enjoy the fastest, most efficient, most optimized platform to get the maximum benefit from EBS. What is EBS? This suite of applications handles everything you need to run your enterprise level business functionality, including customer relationship management (CRM), human resources management (HRM), enterprise resource planning (ERP), and supply-chain management (SCM). The EBS collection is one of ’s major product offerings with robust capabilities to consolidate your business management under one roof. With tools covering logistics, financials, order management, marketing, HR, and many more, EBS is an industry leading, comprehensive solution. Is On-Prem a Problem? If you are a current or future owner of EBS you may be wondering what infrastructure will best compliment this powerhouse of tools. More and more companies are moving away from in-house data centers because of the high cost of implementation and maintenance. These data centers (more…)

Tampa Bay CEO Council Helps Pack 11,665 Meals for 3,000 Families

By | Blog, Community, General Announcements
A little over 3,000,000 people live in the greater Tampa Bay region; roughly 700,000 residents experience hunger on a regular basis. This is an unacceptably high and unfortunately all too common statistic. The solutions to the long-term problem of hunger both globally and locally are complex. The solution to the immediate problem of hunger is often more straightforward – collect, package and distribute food donations and surpluses to people in need. To better understand the long-term problem of hunger in the region, the CEO Council of Tampa Bay participated in the short-term solution by organizing over 20 of their volunteers along with 60 others to organize, bag and box groceries for distribution of 11,665 meals to almost 3,000 families. “This does not solve the underlying problems of a lifetime of hunger but it does solve the immediate problem of hunger for a week.” According to Peter Dobler, CEO of Dobler Consulting “What we learned after spending the afternoon at Feeding Tampa Bay is that chronic hunger is more than just a lost paycheck, medical emergency or a housing crisis away. Once it begins, hunger can become a downward spinning cycle of poor health, lost hopes and missed opportunities.” The CEO (more…)

Expanding the Market: MS SQL Server 2017 and Linux

By | Blog, Database Technology Trends, SQL Server
Microsoft’s exciting cross-platform product, SQL Server 2017, is poised to reach a whole new audience. Recently this industry has joined the growing trend of support for open source solutions.  Our team is continually investigating new innovations for our clients, and we wanted to share what we have discovered about new features and performance. Why Now? Linux is becoming increasingly popular thanks to its security, stability, and efficiency.  Its design protects against virus and malware attacks with a complex architecture and secure user account structure.  With more and more businesses choosing Linux, Microsoft realized they were forcing clients to manage multiple environments by keeping SQL Server only on Windows.  Rohan Kumar, then General Manager of Microsoft Database Systems, discussed the decision with Frederic Lardinois for Tech Crunch.  “We had a couple of discussions in the past where it wasn’t approved,” he told Lardinois, but four years ago his team recognized the value of expanding, so they pitched the idea once again. “The biggest surprising part was that we were expecting a whole lot of back and forth. It was really surprising to see how quickly the decisions got made,” recalls Kumar. How? With the company’s support in place, Kumar’s team needed (more…)
Server Data Migration

Multitenant database in Oracle 12c

By | Blog, Oracle Tips, Technology Tips & Tricks
One of the new features of Oracle 12c is multitenant databases. Multiple databases can be plugged in a big container database. Container database (CDB) is the primary database that comprises 0, 1 or many pluggable databases (PDB). This holds the controlfiles, datafiles, undo, tempfiles, redo logs and also the data dictionary for those objects that are owned by the root container. It is also called CDB$ROOT Pluggable Database (PDB) – these are the databases stored within the primary container database. Each PDB is a set of schemas, objects and non-schema objects. PDB is made up of only datafiles and tempfiles to handle its own objects which includes its own data dictionary containing information about only those objects specific to the PDB. PDBs appear to the end users as a non-CDB database. Seed PDB – A default PDB that the system uses as a template to provision other user-created PDBs. It is called PDB$SEED   Advantages of Multitenant database architecture Multitenant architecture reduces the requirement to create multiple instances. It offers the ability to have 252 PDBS per multitenant CDB. This increases hardware utilization and so reduce capital expenses. Upgrade and patching is made very simple. All underlying databases inside it (more…)
Sybase

Sybase ASE SBE Upgrade Path

By | Blog, Database Technology Trends, SAP ASE, SAP Sybase, Sybase
Sybase ASE SBE is the entry level ASE server from comparable to the standard editions of Oracle or Microsoft SQL Server. For limited use or internal applications, its limitation of 256 concurrent connections and hard limit to physical CPU chips are not a problem. But the limitations to 2 CPU CPU sockets makes it nearly impossible to find hardware these days or migrating a physical server to a virtual environment. replaced the ASE SBE server a few years ago with its new ASE Edge Edition server. This is actually a fully functional ASE Enterprise server only limited to a max of 8 cores and it runs on virtual servers. You could just go ahead and purchase a license to the new ASE Edge Edition to overcome the limitations, but what does this mean if you already invested into the ASE SBE server? Good News will now allow legacy Sybase SBE customers to get conversion credit for existing licenses. That credit can then be used to acquire ASE Edge licenses and execute the new license transaction on paper. You will also get a prorated rebate for any maintenance paid that will be applied to any new maintenance (more…)
sybase recovery services

In-Memory Databases vs Intel NVMe NUMA

By | Blog, Database Technology Trends, SAP HANA, Sybase | No Comments
For the past few years, the hot topic for database vendors was the in-memory database. The general belief was and maybe still is, that server memory is getting cheaper and density will continuously improve. For the most part, this has been the case, maybe not as extreme as predicted. However, the data storage needs for databases increased at a much faster pace during the same time, which created another problem. Going beyond 1TB of memory in a single server will quickly become very expensive. A 1TB database used to be called very large. This attribute is now applied to the 5-10 TB databases servers. In-memory databases are needed where read and write performance are equally important. Traditional databases improve read performance by caching data in memory, but there is no way to improve write performance. To be ACID (Atomic, Consistent, Isolated and Durable) compliant, data must be written to persistent storage. An in-memory database achieves this by writing every transaction in parallel to a high-performance storage. In many cases this is a flash drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory (RAM) to be ACID compliant. There are many (more…)
Case Study: Creating a high-performance Sybase environment rivaling SAP HANA

Case Study – Get SAP HANA Performance Out of Your SYBASE Database for 1/10th the Cost

By | Blog, Case Studies | No Comments
As Sybase continues to get more difficult to justify, many organizations are feeling the pressure to upgrade to SAP HANA, rewrite their applications and/or migrate to a different database platform like SQL Server or Oracle. What if you could get a few extra years out of your current Sybase installation? What if you could have a high-performance Sybase environment that can match the speed of HANA? Would you be interested in learning how? A Sybase Environment that Rivals SAP HANA is Born Click to read our Case Study Overview Element Fleet Management is the world’s largest fleet management services company. After acquiring GE Fleet, they anticipated an exponential increase in data and needed to update Sybase to handle significant increases in demand and usage. They challenged Dobler Consulting to architect and validate a solution so their Sybase could handle what they were expecting with the addition of GE Fleet. We were up to the challenge!   “Modernizing the existing traditional server/storage configuration was not an option. The solution was to build it on Intel’s NVMe™ based NUMA platform.” Download our our Case Study Overview where we share the story about migrating Elements existing servers to Intel’s NVMe based NUMA platform. When it was all said and done, Dobler (more…)

Protecting Your Database from Ransomware like WannaCry

By | Blog | No Comments
You may have heard about the recent WannaCry cyberattack that infected hundreds of thousands of computers worldwide. The ransomware holds a computer hostage until the user pays some amount of (ransom) to the hacker or until a patch is made and installed. Why did it spread so quickly and how can you prepare for the next one, especially if you are a DBA? It’s not a matter of if, it’s a matter of when. Why were the attacks so effective? When this particular ransomware emerged on May 12th 2017, it had used an exploit on Windows systems that had been addressed by a critical patch two months earlier in March 2017. So, if end users kept up to date with receiving the latest critical security patches as they became available, they would have avoided being infected. Unfortunately, many businesses were not adequately prepared for an attack like this because maintain updates and they did not have the right security processes in place. It’s critical that companies are proactive in the measures they take to mitigate the risks involved with today’s cyber threats or they will become vulnerable. Lack of preparedness is one of the biggest factors why this cyber (more…)

CALL US TODAY!

(813) 322-3240

%d bloggers like this: