• Task and Meeting Management Database

    Updated: 2011-03-31 03:42:15
    The Meeting Tracker sample database for Microsoft Access 2007 allows you to track all of the details associated with your meetings. It includes the ability to assign tasks to...

  • Adding a Timestamp On User Click

    Updated: 2011-03-31 03:42:15
    In a recent forum message, Kstarlin asked: "I have a form with numerous fields. I would like the operator to be able to click in one of those fields and the...

  • DMF On-Demand Execution Mode

    Updated: 2011-03-31 03:42:15
    The On Demand Execution Mode of SQL Server's Declarative Management Framework allows you to manually test whether a DMF target complies with a policy. This is a great way...

  • Creating a Database-Driven Web Page

    Updated: 2011-03-31 03:42:15
    In a recent forum message, NWTech75 wrote: "Greetings all. I'm new to this site and was wondering if there is anyone here that may be able to help guide me...

  • Adding Timestamps to Access 2010 Databases

    Updated: 2011-03-31 03:42:15
    There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It's easy...

  • Counting Database Records

    Updated: 2011-03-31 03:42:15
    SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the number...

  • Limited Access Views for Databases

    Updated: 2011-03-31 03:42:15
    Database views allow you to easily reduce the complexity of the end user experience and limit their ability to access data contained in database tables by limiting the data presented...

  • What is a Database Parameter?

    Updated: 2011-03-31 03:42:15
    In a recent forum message, praepipossum wrote: "I have stupidly deleted a record in a table. Now when I open the form to enter data in that table, I am asked...

  • Microsoft Access E-mail Data Collection

    Updated: 2011-03-31 03:42:15
    Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard designed to facilitate this task. In...

  • Time Saving Tips for Access 2010

    Updated: 2011-03-31 03:42:15
    Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the...

  • Short-request and analytic processing

    Updated: 2011-03-30 07:59:47
    A few years ago, I suggested that database workloads could be divided into two kinds — transactional and analytic. The advent of non-transactional NoSQL has suggested that we need a replacement term for “transactional” or “OLTP”, but finding one has been a bit difficult. Numerous tries, including high-volume simple processing, online request processing, internet request [...]

  • Introduction to Citrusleaf

    Updated: 2011-03-30 05:05:34
    Citrusleaf is the vendor of yet another short-request/NoSQL database management system, conveniently named Citrusleaf. Highlights for Citrusleaf the company include: 8 employees. $2 million in recently acquired venture capital. 1 1/2 – 2 1/2 years of total company history, depending on how you count. An undisclosed but nonzero number of paying customers, concentrated in the [...]

  • ★ Did You Know About File Watchers?

    Updated: 2011-03-29 15:00:17
    Starting with Oracle Database 11g Release 2, an event-based Scheduler job can be started based on the arrival of a file in a directory on the server. The file arrival event is raised by a new Scheduler object called a file watcher. As per the docs: A file watcher defines the location, name, and other [...]

  • Software AG and the commie spies

    Updated: 2011-03-25 15:17:44
    Something (I’ll drop in a link when allowed) made me recall the story of Software AG and the USSR. Apparently, the USSR attempted to acquire a lot of Western technology, including ADABAS. Software AG of North America cooperated with the Feds to try to catch the Soviet agent in indictable technological espionage — but then, [...]

  • MySQL, hash joins and Infobright

    Updated: 2011-03-25 01:41:56
    Over a 24 hour or so period, Daniel Abadi, Dmitriy Ryaboy and Randolph Pullen all remarked on MySQL’s lack of hash joins. (It relies on nested loops instead, which were state-of-the-art technology around the time of the Boris Yeltsin administration.) This led me to wonder — why is this not a problem for Infobright? Per [...]

  • Neat Oracle Database 11g Release 2 Feature: Preprocessing External Tables

    Updated: 2011-03-24 17:12:42
    Arup Nanda: External tables enable users to access data in text files, immediately eliminating the need to load input text files to intermediate tables for processing—saving both time and storage space. Now, with Oracle Database 11g Release 2, intermediate processing of any kind—such as decompression of compressed input files—is eliminated, further saving time and storage, [...]★

  • Analytic performance — the persistent need for speed

    Updated: 2011-03-24 14:41:32
    Analytic DBMS and other analytic platform technologies are much faster than they used to be, both in absolute and price/performance terms. So the question naturally arises, “When is the performance enough?” My answer, to a first approximation, is “Never.” Obviously, your budget limits what you can spend on analytics, and anyhow the benefit of incremental [...]

  • A PR choice

    Updated: 2011-03-24 14:33:25
    You can pitch a story that isn’t really news, for example calling attention to the success of a product you’d been shipping for a while. You can pitch a story with an embargo. Choose one. Asking for an embargo on information already in the public domain is really lame.

  • DataStax introduces a Cassandra-based Hadoop distribution called Brisk

    Updated: 2011-03-23 17:38:18
    Cassandra company DataStax is introducing a Hadoop distribution called Brisk, for use cases that combine short-request and analytic processing. Brisk in essence replaces HDFS (Hadoop Distributed File System) with a Cassandra-based file system called CassandraFS. The whole thing is due to be released (Apache open source) within the next 45 days. The core claims for [...]

  • Hadapt (commercialized HadoopDB)

    Updated: 2011-03-23 12:35:52
    The HadoopDB company Hadapt is finally launching, based on the HadoopDB project, albeit with code rewritten from scratch. As you may recall, the core idea of HadoopDB is to put a DBMS on every node, and use MapReduce to talk to the whole database. The idea is to get the same SQL/MapReduce integration as you [...]

  • MySQL soundbites

    Updated: 2011-03-15 14:24:53
    Oracle announced MySQL enhancements, plus intentions to use MySQL to compete against Microsoft SQL Server. My thoughts, lightly edited from an instant message Q&A, include: Given how hard Oracle fought the antitrust authorities to keep MySQL around the time of the acquisition, we always knew they were serious about the business. We’ll know they’re even [...]

  • So how many columns can a single table have anyway?

    Updated: 2011-03-13 08:43:14
    I have a client who is hitting a 1000 column-per-table limit in Oracle Standard Edition. As you might imagine, I’m encouraging them to consider columnar alternatives. Be that as it may, just what ARE the table width limits in various analytic or general-purpose DBMS products? By the way — the answer SHOULD be “effectively unlimited.” [...]

  • Notes for my March 10 Investigative Analytics webinar

    Updated: 2011-03-10 08:23:18
    It turns out that the slide deck I posted a couple of days ago underwent more changes than I expected. Here’s a more current version. A number of the changes arose when I thought more about how to categorize analytic business benefits; hence that blog post a few minutes ago with more detail on the [...]

  • The three principal kinds of analytic business benefit

    Updated: 2011-03-10 07:26:01
    When I tweaked the slide deck for Thursday’s Investigative Analytics webinar — I’ll post an updated version soon — the part that needed the most work was the section on “What business problems do you solve with this stuff anyway?” I’ve posted about that kind of thing at least five times in the past five [...]

  • ★ If you think you disabled Automatic Memory Management in Oracle DB 11.2, think again

    Updated: 2011-03-08 19:36:20
    Kurt Van Meerbeeck points out the fact that SGA re-sizes are occurring after an upgrade to 11.2 despite the fact that automatic memory management (AMM/ASMM) is disabled via the MEMORY_TARGET and SGA_TARGET parameters being set to zero. It turns out that this is an expected behavior in 11.2. From Oracle Support note 1269139.1: Cause: This [...]

  • Conventional (NOAPPEND) parallel inserts available in Oracle DB 11g

    Updated: 2011-03-08 14:30:23
    Randolf Geist: Oracle 11g obviously has added the capability to perform a conventional, non-direct-path insert in parallel. Greg Rahn: Parallel conventional (NOAPPEND) insert was an 11g new feature, though it seems to have escaped the new features list in the docs. It was added to support cases where parallel insert as select was desired, but [...]★

  • ODTUG KScope 11 and Database Content

    Updated: 2011-03-04 22:30:50
    Lewis Cunningham: My plan was to build the conference around the life cycle that a database developer works with. Since we weren’t cherry picking the content we couldn’t force anything on the schedule but the overall goal was to present topics, from beginner to expert, on Design, Coding, Maintenance and Best Practices. You can get [...]★

  • Learn why and how Oracle BerkeleyDB can bring NoSQL benefits to your application

    Updated: 2011-03-03 19:56:38
    Shashank Tiwari: Berkeley DB undoubtedly qualifies as a robust and scalable NoSQL key-value store; the use of Berkeley DB as the underlying storage for Amazon’s Dynamo, Project Voldemort, MemcacheDB, and GenieDB is further evidence supporting this claim. There has been a little bit of FUD around Berkeley DB performance, especially in the wake of couple [...]★

Current Feed Items | Previous Months Items

Feb 2011 | Jan 2011 | Dec 2010 | Nov 2010 | Oct 2010 | Sep 2010