Database Blog

  • Schemas, Databases and Instances—Defined and Discussed

    May 12, 2020

    Reading Time: 5 minutes 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 are very important when planning a database architecture, so let’s explore them.

    Read more Add new comment
  • Fast and Simple: Use Cases for noSQL Database Technology

    May 9, 2013

    Reading Time: 2 minutes 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 technology is not about to replace the reigning data champion, NoSQL is being leveraged across multiple applications and enterprises with good results. Here are a few use cases for NoSQL databases. Varied Data Models for Varied Problems: The Netflix Solution…..

    Read more Add new comment
  • Storing documents in a MongoDB database instead of the file system

    Jul 9, 2010

    Reading Time: < 1 minute 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 all of these files and present a list of the files to the user so they can download them to their local machine, or send…..

    Read more Add new comment