by Robert Buda | May 12, 2020 | Database Architecture, Oracle, SQL Server
What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB? These terms can be confusing, but they are very important when planning a...
by Robert Buda | May 9, 2013 | NoSQL
The relational database has ruled information technology sectors for decades. Ask any analyst, report writer, or database admin about day-to-day issues, and they are likely to recount headache-filled hours spent on joins and query troubleshooting. Although NoSQL...
by Robert Buda | Jul 9, 2010 | Database, MySQL
We are currently working on an application that uses a mysql database. The application produces a large number of csv files that must be kept around for a few weeks, and then removed after being used in various ways by the users of the system. We need to keep track of...