Orcmid's Lair |
||||
|
2003-11-07Mathematics of ComputingProbability and StatisticsStatistical Prediction and EstimationStatistical prediction is important in a number of activities, including training of various kinds of acceptors, real-time data compression, and search minimization. Much is being learned about the Good-Turing estimator that was originally devised to reduce search in attacking cryptographic systems.EE Times - New measure of success cited for statistical prediction. Here is more on the Good-Turing estimator. This is getting exciting. It should work for compression algorithms. Systems Architecture and DesignSoftware Development MethodologiesExtreme ProgrammingExtreme Programming. This is a 1999 presentation by Ralph Johnson to a group of Smalltalk users. It is a very nice treatment of XP, starting with the customer's bill of rights. I especially like that part.Object-Oriented FrameworksCritical Success Factors Of Object Oriented Frameworks. I was looking at some other Ralph Johnson links and stumbled into this. The ideas about frameworks are something I need to pay attention to in some exemplars I want to pursue.Design PatternsWords from one of the four gangsters:Ralph Johnson. I just received a forwarded note about XP and RUP methodologies that had a very nice quotation of Ralph Johnson's experience with the two methodologies and how XP works very well with novices. I think it is this Ralph Johnson, from the Design Patterns Gang of Four. I think I want to connect with him, because some of his experience is with group projects, including ones done over the Internet. 2003-11-06Model-Based DevelopmentI wonder how wel this works when the one tool spans abstractions. This seems to be another potential demonstration of how code rules in a large part of the software development world.COMMENTARY - MODEL BASED DEVELOPMENT ROCKS. This is about how Microsoft proposes to include model development and implementation under one family of VS-based tools (in Whidbey, the next release). Important links and more of the unfolding approach of Microsoft to enterprise architecture. There is a break with the UML-centric approach and also separation from the direction that Rational/IBM are taking. Computing MilieuxComputers and SocietyComputers as Instruments of Social ActivismmySociety: a VoxPolitics project. This is a meta-project for creating socially-valuable internet projects that scale at near-zero cost. This is an outlet for proposals and effort in creating social benefits on the internet. 2003-11-05Information SystemsData ManagementDatabase EducationAJET 11(1): Gould (1995) - database education for business students. This is a great paper, found by classmate Roger Cook. The requested full citation is asGould, E. (1995). Database education: Problems for business students. Australian Journal of Educational Technology, 11(1), 36-49. http://www.ascilite.org.au/ajet/ajet11/gould.html. Conformance and Validation for SQLMimer SQL Developers - Mimer SQL-99 Validator. Here is an on-line validator for SQL:1999. I need to look at the samples and backup material linked from this page.Mimer SQL Developers - Mimer SQL-92 Validator. Here's an on-line SQL-92 validator. It raises some interesting questions with regard to entry-level (which requires capitalized identifiers). I bet there are other conditions too. Mimer SQL Developers - Mimer SQL Validator. Here is a suite of validators against the various forms of the SQL specification. I would love to run these against scripts I am developing, because I don't have a reliable way to tell when I have something that reflects a vendor-ism or something that is in 1999 and not that way in 1992, etc. Mimer SQL Developers - Core SQL:1999 feature comparison chart. Here's another great comparison chart that classmate Han Chen has come up with. The presence of an SQL validator is rather interesting too. DATA MANAGEMENT STRATEGIES - Codd's 12 Rules. Here's another (annotated) presentation of Codd's 12 rules, published 2001-05-07. This link was uncovered by classmate John Thomas. It is not clear who the author and annotator of the column are. PostfreSQL 7.5 SQL:1999 Conformance. This goes with the nice depiction of unsupported features and lists the supported features, along with an indication of whether a feature is in core SQL:1999 or not. I like the accountability of this. It would be nice to have something that helps readers know what the import of it all is, not just for PostgreSQL, but for other DBMS implementations of SQL. PostgreSQL 7.5 Unsupported SQL:1999 Features. From classmate Han Chen, a nice accountability of identified features of SQL:1999 that are not supported in a particular release. One of the difficulties I am having is even knowing what is in SQL:1999, how it relates to SQL:1992, and where to find a list of all the feature identifiers. I guess it is a good application for an SQL database to catalog all of this. 2003-11-04NIST Computer Security DRAFT Publications. CSRC, the Computer Security Resource Center at NIST is cranking out a variety of special reports and FIPS drafts on security-related topics. This page is worth bookmarking. 2003-11-03Information SystemsDatabase ManagementProgression and Progress of SQL StandardsTDAN Gulutzan - Standard SQL. This is a great article by Peter Gulutzan on how the big three are doing in terms of SQL:1999 features. Located by classmate Thorsten Kollstede.SQL standard - Whitemarsh is SQL Standards, Metabase Software Products and Services to achieve Enterprise Database, through Data Quality, and sound Database Design.. Another popular site with great material related to SQL standards. DBPD:SQL Update September 1998. This note is referenced by several classmates in our discussion of changes from SQL:1992 to SQL:1999. 2003-11-02DB2 and SQL:1999 ComplianceI am using DB2 in class, so when it comes to exploration for compliance with SQL:1999, this is my guinea pig.DB2 for Linux, OS/2, Windows and UNIX Technical Support. This is downloadable versions of product documentation in PDF and, in some cases, HTML that is not available in the Information Center. DB2 UDB for iSeries. Oh, this is actually a later version than I thought. It compares Linux, Unix, and Windows version 8, z/OS, OS/390 version 7, and iSeries Version 5.2. Another thing I miss is the Constraints language and the ability to announce primary and candidate keys. DB2 UDB Family on Common Ground. This is a little white paper on how release coordination for the different code bases is managed and the commitment to line up on SQL:1999 features. They aren't there yet. I am looking for a place where there is accountability against the SQL:1999 specification -- what's in, what isn't, etc. Is there a commitment to the core first? How about features that let the feature set be determined by examination of the implementation? I have questions like that. DB2 UDB for iSeries - Selected Common SQL Features. This is a table of common features as of DB2 5.1 for iSeries systems, dated 2002-12-19. There is a listing of SQL:1999 features and a summary of what is supported. There is no mention of DOMAIN and there is CREATE DISTINCT TYPE (only). It looks like 8.1 goes farther, but ther is more to check. SQL Standards and EvolutionSQL3 Object Model. This page describes the Object-Oriented aspects of SQL3 (SQL:1999): "The simplest form of user-defined type in SQL3 is the distinct type, which provides a facility for the user to declare that two otherwise equivalent type declarations are to be treated as separate data types. The keyword DISTINCT used in an declaration indicates that the resulting type is to be treated as 'distinct' from any other declaration of the same type. For example, if two new types are declared as:CREATE DISTINCT TYPE us_dollar AS DECIMAL(9,2) CREATE DISTINCT TYPE canadian_dollar AS DECIMAL(9,2) any attempt to treat an instance of one type as an instance of the other would result in an error, even though each type has the same representation. "
|
|||
