Big Data. Big Decisions
InformationWeek
Special Coverage Series


Oracle's Hurd Touts San Diego Schools' BI Success

School district used in-depth analysis and rapid response times to make its data more useful, improve student attendance record, OpenWorld crowd hears.

Oracle vs. Salesforce: Social Acquisition Face-off
Oracle vs. Salesforce: Social Acquisition Face-off
(click image for larger view and for slideshow)

The rate that accumulated data is consuming storage means either some data will get discarded, or the average IT budget will expand by 4% a year, up from 1-2% today, Oracle president Mark Hurd told an audience at Oracle Open World Thursday.

"Data is coming at you from all directions" from both inside and outside the company, Hurd said in his keynote address. It's being collected from comments about the company in social media, as well as from the internal general ledger system and customer visits to the company website.

IT currently devotes 10% of its budget to buying and running storage. With the pace of unstructured data creation accelerating, storage managers will find new data accumulating faster than they can store it, given storage's cost of $7,500-$9,000 per TB, Hurd said. Trying to capture the newly available data will prompt a further expansion of the IT budget at the rate 4% a year, Hurd predicted. IT can put some brakes on the expansion through rigorous use of data deduplication and compression, available in Oracle products, but they can't escape it entirely.

Even as Hurd warned of the rising tide of data, he highlighted customers who coped with one big data problem or another via an Oracle product. One of the more unlikely big data users Oracle showcased was Darryl Lagace, CIO of the San Diego Unified School District, the second largest in California and one of the 20 largest in the nation.

In an interview prior to Hurd's keynote, Lagace said the school district had a big data problem because it collects lots of data on 130,000 students, but little of that data could be put to use in direct ways to affect outcomes in the district. The district has area superintendents, each tracking performance at 30-40 schools, but the district's IT staff was hard pressed to come up with the reports they needed to tell whether each building was on track to perform as expected.

[ Learn what else happened at Oracle's 2012 conference. See Oracle Open World: 6 Rants and Raves. ]

The district has experienced five consecutive years of budget cuts, said Lagace, putting more pressure on IT to provide resources that make up for the diminishing ranks of teachers and other district staff. One response was to generate scorecards on each student as they enter the ninth grade so that both students and parents know whether a child is on track to meet college admission requirements. In conversations with parents, a district official could query the district's student database, but the answer might take "two to three minutes to come back." During the wait, the focus of the conversation might change and the point of using information to enlist parental support for a precollege course load could be lost. The wait times were long enough that "we saw a steep decline in the use of the system by school staff," said Lagace.

District IT managers looked at alternatives and decided to buy an Exalytics in-memory database machine, a four CPU server (each with 10 Xeon cores) in a box with a terabyte of high-speed memory. It ran the Oracle TimesTen in-memory database system. With the ability to place all of the district's student data in memory, the database could deliver answers to queries on college-bound students in seconds, said Lagace. The system uses its built-in scorecard program to visually present the data on each student.

The school district also uses Oracle Business Intelligence Enterprise Edition to track student attendance and address issues behind chronic low attendance. The information is needed because school attendance is closely correlated with grades. Failure to attend is often a symptom of a hidden problem with language or math skills. Being able to identify suspect areas allows interventions by teachers, counselors, and principals to help keep a child in school, and good attendance greatly improves the likelihood of graduation, said Lagace.

He acknowledged there is a strong secondary reason for keeping an eye on attendance. The state reimburses school districts based on average daily attendance, and each individual absence drives down the average. For a student with perfect attendance, the district receives $5,786 per year in school aid from the state, according to information on the district's website. Put just six days of absence into the equation and the reimbursement from the state drops $232 to $5,554 for the same student. Add chronic poor attendance for hundreds of students, and valuable aid goes down the drain.

By spotting and addressing poor attendance early in the school year, school officials were able to turn around many chronic cases and improve the district's overall record. In the first six months using the business intelligence system, it gained 0.5% in attendance, a feat duplicated in the second six-month period of use. That led to 1% better attendance going into state calculations on aid, and an added $6 million for the district.

"The $6 million goes to keeping teachers in the classroom, keeping classes smaller," said Lagace. By zeroing in on absences occurring within the same family, school officials could frequently spot a high school student absent on the same day as a sibling in elementary school, with the auxiliary evidence suggesting the high school student was standing in for a working single parent unable to stay home with a sick child. Keeping the high school student in school, despite a sick sibling, quietly became one of the district's goals, and the finding went into the business intelligence system as a set of circumstances to watch out for, said Lagace.

The result has been a lowering of San Diego's drop-out rate from above 8% to 5.8% at the end of the school year last spring. "We have the lowest drop-out rate for an urban district in the state," said Lagace. State superintendent of education Tom Torlakson is expected to cite San Diego Unified for that accomplishment soon, he added.

Some of the information used by Exalytics and Oracle Business Intelligence Enterprise Edition comes from outside the school district, such as the requirements of California's state university system that must be met for a student to be accepted. Getting that information into the district's system and showing it as a set of charts on each child, as the scorecard system does, "gives ownership of that issue to the students and parents." Without that presentation, both are sometimes "not tuned in to the issue" until it's too late.

A system that was pilot tested on 500 students last April and May was rolled out to all high school students in the district this fall. As Hurd suggested, data in growing quantities is now available. "Getting information to the right people in the right place at the right time" is still the issue.

Web-facing databases have a huge target on their backs. The easy way to secure these databases would be to take them off the Web, but a system that does not serve a business function is worthless to the company. Security pros must figure out ways to secure databases with limited resources while keeping business systems operational. In the Strategies For Protecting Web-Facing Databases report, we recommend several cost-efficient methods. (Free registration required.)



Related Reading


More Insights




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.