• Oracle DBMS_SCHEDULER Part 1–The Basics

    Updated: 2011-01-30 15:47:06
    Log in Database Geek Blog Database Stuff , from a Geek Home About Feeds Subscribe to Feed Oracle DBMS_SCHEDULER Part 1 The Basics Posted in January 30, 2011 11:47 . amh Lewi No Comments DBMS_SCHEDULER is Oracle’s full featured scheduling solution that runs inside the database . Think of it as a complete replacement for DBMS_JOB which I do still use occasionally but am using less and less over time DBMS_SCHEDULER has a lot of benefits over DBMS_JOB ability to stop a job , ability to reuse code , ability to reuse schedules , ability to chain jobs into a job streams , . etc This post is the first of a series of posts that I will be doing on DBMS_SCHEDULER . Actually I am doing a lot of Streams work again and it was kind of a toss up as to which tool I’d blog about first . Scheduler wins

  • Access Database Field Limits

    Updated: 2011-01-30 10:21:47
    In a recent forum message, Nayer_Sh writes: "In Access 97, I have a form which has several text boxes for data entry. What is the maximum size that text box can ...Read Full Post

  • Schooner — flash-based, now software-only, and very fast

    Updated: 2011-01-28 07:56:49
    Last October I wrote about Schooner Information Technology, which made flash-based appliances, for MySQL, memcached, or persistent memcached. Schooner sold those appliances to close to 20 customers, but even so decided software-only was a better way to go. Schooner’s core value proposition is that one Schooner box with flash does the job of a lot [...]

  • SQL Server Change Data Capture

    Updated: 2011-01-27 05:30:49
    With the release of SQL Server 2008, Microsoft included Change Data Capture (CDC) functionality for the first time. This highly anticipated feature provides administrators with the ability to perform ...Read Full Post

  • Kodak Gallery Manages Website Operations with QuickBase

    Updated: 2011-01-26 15:16:20
    Team Leadership QuickBase News Tips Tricks Customer Stories Industry Trends Inside QuickBase Partner Corner New Features Kodak Gallery Manages Website Operations with QuickBase By Liz McCann Posted on January 26th , 2011 Share Tweet How often do you get an opportunity to implement a process that will dramatically improve your company’s business results That is just the opportunity Robert Diroll discovered when he joined Kodak Gallery as Director of Site . Marketing The Challenge Together with Rich Johnston , Sr . Web Developer , Rob observed that the site marketing team responsible for Kodak Gallery’s merchandising Website had no process or visibility into managing the approval , prioritizing and scheduling of projects . As a result , time for approvals and deployments were slow ,

  • ScaleBase, another MPP OLTP quasi-DBMS

    Updated: 2011-01-25 21:35:17
    Liran Zelkha of ScaleBase raised his hand on Twitter. It turns out ScaleBase has a story rather similar to that of CodeFutures/dbShards. That is: Like dbShards, ScaleBase is a proxy that looks to the application like a scale-out DBMS, but routes work to multiple servers running MySQL against different shards of the database. Other DBMS [...]

  • dbShards update

    Updated: 2011-01-25 21:32:42
    I talked yesterday with Cory Isaacson of CodeFutures, and hence can follow up on my previous post about dbShards. dbShards basics include: dbShards gives you, in effect, an MPP DBMS based on MySQL or PostgreSQL, meant for OLTP (OnLine Transaction Processing). dbShards always did distributed queries, and now does distributed transactions as well. dbShards works [...]

  • 4 Tips for Deciding What to Pay Someone

    Updated: 2011-01-25 14:54:48
    Team Leadership QuickBase News Working Teams Decision Making Leadership Productivity 4 Tips for Deciding What to Pay Someone By Alexandra Levit Posted on January 25th , 2011 Share Tweet For many organizations , determining a set compensation package for each job title is a significant and time-intensive role of the HR department . But what if you are bringing a new team member on board and don’t have this set package to work from How might you go about deciding how much to offer a new hire Here are a few tips to keep in . mind Be competitive Use industry and local market comparison studies to make sure your compensation is in line with that of similar organizations with similar . positions Practice equality If you already have people working in the same function as the candidate , you

  • Tough Database Question

    Updated: 2011-01-25 06:28:22
    In ...<pRead Full Post

  • Do we still need EDWs?

    Updated: 2011-01-24 21:10:43
    Colin White reopened the question of whether enterprise data warehouses (EDW) are still needed, lining up and knocking down a number of traditional pro-EDW arguments, in more detail than I ever have. So this feels like a good time to revisit my answer to the question of the EDW’s role, whose money quote was: At [...]

  • QuickBase Admins: Empower Your Users to Build New Solutions

    Updated: 2011-01-24 15:59:30
    : Team Leadership QuickBase News Tips Tricks Customer Stories Industry Trends Inside QuickBase Partner Corner New Features QuickBase Admins : Empower Your Users to Build New Solutions By Alex Hastings Posted on January 24th , 2011 Share Tweet This one goes out to all of our Account Admins . QuickBase is designed to help you build solutions that match the needs of your organization and business proccesses . You’re already succeeding at that , but how many of the users in your account are empowered to do the same As administrators of these solutions , you’re a critical part of the team and can be spread thin between managing users , building new solutions , and adding more complex functionality . When new needs arise in your user base , wouldn’t it be great to give your users the ability to

  • Choices in analytic computing system design

    Updated: 2011-01-24 05:28:08
    When I posted a long list of architectural options for analytic DBMS, I left a couple of IOUs in for missing parts. One was in the area of what is sometimes called advanced-analytics functionality, which roughly speaking means aspects of analytic database management systems that are not directly related to conventional* SQL queries. *Main examples [...]

  • Converting a Microsoft Access Database to SQL Server

    Updated: 2011-01-23 17:27:22
    Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL ...Read Full Post

  • Mega-trends driving data warehousing and business intelligence

    Updated: 2011-01-22 19:07:08
    Philip Russom opines (emphasis mine): What’s driving change in data warehousing (DW) and business intelligence (BI)? There are obvious scalability issues, due to burgeoning data, reports, and user communities. Plus, end-users need more real-time and on-demand BI. For many organizations, integrating existing systems into DW/BI is a higher priority than putting in new ones. And [...]

  • Notes, links, and comments January 20, 2011

    Updated: 2011-01-20 11:35:24
    I haven’t done a pure notes/links/comments post for a while. Let’s fix that now. (A bunch of saved-up links, however, did find their way into my recent privacy threats overview.) First and foremost, the fourth annual New England Database Summit (nee “Day”) is next week, specifically Friday, January 28. As per my posts in previous [...]

  • Microsoft Access Database File Format

    Updated: 2011-01-20 06:01:47
    The release of Access 2007 brought us a new file format. The MDB database files we've known for over a decade are now slated to become historical relics. While Access ...Read Full Post

  • A Sneak Peak – The New RDM Embedded SQL

    Updated: 2011-01-19 21:44:10
    Raima Embedded Database Blog A Sneak Peak The New RDM Embedded SQL Wednesday , January 19, 2011, 01:44 PM Posted by Randy Merilatt By Randy Merilatt , Raima CTO The Road to Raima’s SQL Raima’s first database management system DBMS product was released over 25 years ago under the name db_VISTA . Our first venture into the world of SQL came in the form of db_QUERY which was an SQL-like query and report writing tool for db_VISTA databases . In 1992, we introduced our client server DBMS originally called Raima Database Server , shortly thereafter renamed Velocis and now called RDM Server The client server architecture was designed for resource-rich computers which allowed us to provide a full-featured SQL . implementation Today , except perhaps for the smallest of embedded computing devices ,

  • Sound bites on HP/Microsoft and Neoview

    Updated: 2011-01-19 17:05:57
    HP and Microsoft put out a press release. Three new appliances are being announced, and we’re being reminded of at least one past announcement. I wasn’t briefed, and wouldn’t want to comment on, say, price/performance or feature particulars. That said: HP Neoview seems pretty dead. I haven’t heard a single favorable reference to HP Neoview [...]

  • Architectural options for analytic database management systems

    Updated: 2011-01-18 14:22:09
    Mike Stonebraker recently kicked off some discussion about desirable architectural features of a columnar analytic DBMS. Let’s expand the conversation to cover desirable architectural characteristics of analytic DBMS in general. But first, a few housekeeping notes: This is a very long post. Even so, to keep it somewhat manageable, I’ve cut corners on completeness. Most [...]

  • QuickBase Customers: Check Your Inbox and Let’s Hear Your Voice!

    Updated: 2011-01-18 14:08:52
    : Team Leadership QuickBase News Tips Tricks Customer Stories Industry Trends Inside QuickBase Partner Corner New Features QuickBase Customers : Check Your Inbox and Let’s Hear Your Voice By Kristin Zajac Posted on January 18th , 2011 Share Tweet Here at QuickBase we’re really excited because in just a few short weeks , we are going to have all kinds of amazing new feedback from our most important team members YOU Check your inboxes because this coming Monday 1.24.11 we’re launching an annual customer survey where we ask you about what you care about most , so we can learn how we can do better . We’re gearing up to pour over your feedback and use it to drive decisions throughout our organization from product development to customer support to . communications We do this survey every year

  • Counting Database Records

    Updated: 2011-01-18 06:01:14
    The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique ...Read Full Post

  • Google Contacts Database Schema

    Updated: 2011-01-16 06:59:31
    In a recent forum message, Pytrex asks: "I'm new to DB design and was wondering about how google created their contacts to allow unlimited Phone numbers, addresses, custom fields, etc. Can ...Read Full Post

  • Printing Mailing Labels with Access 2010

    Updated: 2011-01-13 06:36:07
    One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in ...Read Full Post

  • Mike Stonebraker on “real column stores”

    Updated: 2011-01-12 13:43:07
    Mike Stonebraker has a post up on Vertica’s blog trying to differentiate “real” from “pretend” column stores. (Edit: That post seems to have come back down, but as of 1/19 it can be found in Google Cache.) In essence, Mike argues that the One Right Way to design a column store is Vertica’s, a position [...]

  • Grouping SQL Query Results

    Updated: 2011-01-11 06:19:57
    You may use basic SQL queries to retrieve data from a database but this often doesn't provide enough intelligence to meet business requirements. SQL also provides you with the ability ...Read Full Post

  • Persons and Organizations in a Client Database

    Updated: 2011-01-09 06:17:06
    In a recent forum message, DanTee wrote: "I am in the process of designing an MS Access database for a law office that has CLIENTS that may be a PERSON or ...Read Full Post

Current Feed Items | Previous Months Items

Dec 2010 | Nov 2010 | Oct 2010 | Sep 2010 | Aug 2010 | Jul 2010