Know your BI
Know and love your BI tools. Allyson Fryhoff, vice president of Oracles Sensor-Based Services, pointed out to me that once customers get past understanding what readers, tags and printers they can use, the need to understand and analyze the information they have becomes very important. Pre-RFID, DBAs may not have been up on BI, since they havent had that much data from which reports must be generated. RFID will present a whole new world of data that hasnt had reports associated with it before, so make sure you know whos going to deal with it and how. Check out events-based computing. Oracles Jacob Christfort, vice president and chief technology officer of Server Technologies, advises DBAs who are getting up to speed on RFID to take a look at queuing systems, formerly called Oracle Streams. Check out the Oracle Technology Network for some sample code and a primer on this technology, which enables propagation and management of data, transactions and events in a data stream, either from within a database or between databases. Many DBAs probably dont use events-based computing nowadays, but they should expect future RFID-concerned applications to employ the technology, Christfort told me.Also, check out Flashback queries. Flashback queries were introduced in Oracle9i and enable DBAs to perform queries against log data. Instead of having to roll a database back to last week to query the state of the database in that time framea very laborious processDBAs can instead query the log without rolling back. Thats potentially very useful, since it can help you to reduce the amount of data kept in current and archived tables.In a traditional database, youd have to keep all of the data in large tables, which is extraordinarily data-intensive. With Flashback queries, you can push things that you dont query often into an archive. You dont lose the ability to go back and query that data, since you can do so in flashback queries. Next page: Weigh in on the consumer-privacy issues.