web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Archive for category "Relational database systems"
formats

Using the debugger in Oracle 12c SQL Developer

One of the significant features of Oracle’s SQL Developer client is the built-in debugger for PL/SQL stored objects: PL/SQL stored procedures, stored functions, and triggers. In this tutorial we describe how to use the SQL Developer 4.1.0 debugger with an Oracle 12.0.1 server. Setting up the correct permissions and authorizations so that development staff can

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Performance overhead of SQL user-defined functions

Some time ago I wrote an article that described the performance tradeoffs one encounters when using SQL user-defined functions – sometimes called UDFs or PSM (Persistent Stored Module) functions – from within an SQL query. In that article, I wrote: A recent email exchange with software consultant Breck Carter regarding the performance of user-defined functions

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuring Transparent Data Encryption (TDE) with Oracle 12c

I am currently building a Java EE 7 application that will utilize an Oracle 12c database for persistent storage. Because some of the data is sensitive, I decided to enable Oracle’s Transparent Data Encryption (TDE) feature, so that I could encrypt particular columns to guard against disclosure of this sensitive data either through the theft

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuring SonarQube with Oracle 12c

For a while now I’ve wanted to install SonarQube for doing static analysis of my Java EE 7 applications. The current downloadable version of SonarQube is 5.1.1. The SonarQube requirements documentation indicates that SonarQube supports the following RDBMS for its repository: Microsoft SQL Server 2008 and 2012; Oracle 10g and 11g; MySQL 5.1, 5.5, 5.6,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
6 Comments  comments 
formats

Configuration of Oracle 12c – part deux

In this second article regarding the installation and configuration of Oracle 12c, I’ll discuss the server’s memory configuration and the settings chosen for the default installation. Again, I’m working with Oracle 12c Enterprise Edition Release 12.1.0.1.0 – 64-bit on Windows 7. Like many, I accepted all of the default configuration options when installing Oracle 12c

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuration of Oracle 12c – part un

Oracle 12c represents a fairly dramatic departure from Oracle 11g in terms of setup and configuration of the server on personal workstations. The 12c release was released in 2013, but I had delayed its adoption due primarily to a lack of available reference texts. With that issue now rectified, it’s time to “take the plunge”

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Call for Participation: 6th International Workshop on Big Data Benchmarking

The Sixth International Workshop on Big Data Benchmarking will be held in Toronto, Ontario at the Bahen Centre for Information Technology at the University of Toronto on 16-17 June 2015. Keynote speakers at the two day workshop are Tamer Ozsu of the University of Waterloo and Anil Goel, VP and Chief Architect for the HANA

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Why the SQL Standard does not need another way to do GROUP BY

In a recent article, Lukas Eder proposed enhancements to the SQL Standard’s GROUP BY syntax to include support for implicit grouping attributes, such as that provided by the Cypher query language. I applaud Lukas’ efforts to define useful changes to the SQL language, but I am going to try to show in this article that

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

Resource materials for Oracle PL/SQL programming

The Database: Application Programming course (PROG3040) offered to 3rd year CP/A students at Conestoga will be updated this fall semester in two significant ways: Server and client software will be upgraded from Oracle® 10g to Oracle® 11gR2; and Students will be exposed to MongoDB, a popular “NoSQL” system that features a schema-less, JSON data store

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

DBTEST 2013 – Call for participation

The Sixth International Workshop on Testing Database Systems (DBTEST) will be held in New York on Monday, June 24 2013 at the Millenium Broadway Hotel as one of the co-located workshops held in conjunction with the ACM SIGMOD 2013 Conference. This year’s Workshop co-chairs, Vivek Narasayya of Microsoft and Neoklis Polyzotis of the University of

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments