The Shape of Data I can picture data, typically for me a table is cuboidal. On the left side of the face are columns and columns of keys. The first column is the primary key. The second column is the most important foreign key. We have document storage tables that have 30 foreign keys – …
During my career, I have witnessed so many changes and happily rode the wave of innovation. I bought my first IBM PC in the year they were released. First mobile phone: late 1980s. I worked as a field engineer at Cisco Systems during the massive expansion of the internet in the early 2000s. I have …
We are migrating from AWS to Oracle Cloud Infrastructure (OCI) during the fall/winter of 2023. Our checklist for success involves the following: The objective during this stage of our migration involves migrating the database pump file from AWS to OCI. What Did Work This process is awkward, slow, and rather manual. As a positive, it …
Abstract In the 1960s and 1970s, Dr Edgar Codd, a British computer scientist, developed a means of reducing data duplication with in relational databases. While six “forms” of the process exist, 1-4 ought to be at every database application developer’s finger tips. Fifty, nearly sixty, years have elapsed. Not only do these guidelines still apply …
Quick means of grabbing font apex from CSS text file For those of us that work databases applications from the server-side and feel less sophisticated with client-side activities, I wanted to keep an inventory of the icon available in Oracle APEX to users within standard database tables. Why would a software developer include fonts in a column? Imagine scoring with a star-based rating system, or the simplicity of thumbs up/thumbs down.
SQL Development must work on a global platform but only if we get the settings correct to display languages correctly in our code code. When an accent grave goes bad, it looks like an acute error (that’s a bad pun).