text:
|Publication number
|Publication type
|Application number
|Publication date
|Feb 24, 2004
|Filing date
|Jun 14, 2001
|Priority date
|Jun 14, 2001
|Fee status
|Also published as
|Publication number
|Chung-Sheng Li, John R. Smith, Yuan-Chi Chang, Anant D. Jhingran, Sriram K. Padmanabhan, Hui-I Hsiao, David Mun-Hien Choy, Jy-Jine James Lin, Gene Y. C. Fuh, Robin Williams, Lawrence D. Bergman
|Original Assignee
|International Business Machines Corporation
|Export Citation
|BiBTeX, EndNote, RefMan
|Patent Citations (4), Non-Patent Citations (3), Referenced by (93), Classifications (13), Legal Events (5)
|External Links: USPTO, USPTO Assignment, Espacenet
This invention was made with U.S. Government support under contract no. NCC5-305 awarded by the National Aeronautic and Space Administration (NASA). The U.S. Government may have certain rights in this invention.
The present invention relates to database management systems and, more particularly, to methods and apparatus for extending relational and object-relational database management systems.
A database system usually comprises database clients connecting through a network (e.g., Internet, Intranet, etc.) to one or more database servers managed by database management systems (DBMSs). Such an arrangement is shown in FIG. 1. As shown, a database client (computer system) 102 is connected to one or more DBMSs (computer systems) 101-1 through 101-N (each DBMS including one or more database servers) via a communications network 103. It is known that virtually all of the business data handled by database systems, such as data generated by retail sales, falls into the category of structured data. Structured data is data that is present in a structured format, such as data tables in a relational database or spreadsheet. As non-structured data (such as text, time series, images, audio, and video) and semi-structured data (such as HyperText Markup Language (HTML), Extensible Markup Language (XML), and other tagged documents) begin to become prevalent, a database management system has to substantially change its access and search capabilities in order to efficiently manage these types of data.
A taxonomy of different data types and examples is illustrated in FIG. 2. As shown in FIG. 2, data 200 can be categorized as structured 202, non-structured 204 and semi-structured 206. As mentioned, an example of structured data is data in a relational table spreadsheet, while examples of semi-structured data include XML data and HTML data. Non-structured data can be further categorized as vectors 208, lattice 210 and text 212. Vectors may include lines 214 and polygons 216 used in various Geographic Information Systems (GIS). Lattice data may include 1-dimensional data 218 (such as audio and time-series data), 2-dimensional data 220 (such as images, photos), 2-dimensional plus time data 222 (such as video), 3-dimensional data 224 (such as magnetic resonance image (MRI) data, CT (computer tomography) data, seismic data) and 3-dimensional plus time data 226 (such as climate model simulation output data).
To facilitate accessing and managing both non-structured and semi-structured data, database vendors have begun to use an object-relational approach to enhance and enrich the data types that can be handled and managed. An object-relational data model allows the attributes of a relational table to be an abstract data type, which can include both complex data structures and access methods to these structures. This methodology allows the application builder to store data based on new data types and access methods into a relational table. Modules comprising predefined data types and methods have also been developed to facilitate the access of those data types taxonomized in FIG. 2. Currently, all of the commercially-available major object-relational databases have provided a two-tier architecture: (1) a relational database engine; and (2) extension modules. Examples of extension modules include extenders used in IBM Corporation's DB2 database, data cartridges used by the Oracle database, and datablades used by the Informix database. These extension modules take advantage of both user-defined data types (and abstract data types in some of the newer versions of the databases) and user-defined functions (UDFs) enabled by the database engine to extend the capability of the relational database engine. Most of the extension modules (extenders, datablades, and data cartridges) are in the area of non-structured and semi-structured data management such as images, video, spatial data, text, and the recently emerging XML data.
This approach, however, has the following drawbacks:
(1) Query optimization involving UDFs: Query optimization involving UDFs from extenders/datablades/data cartridges is difficult and sometimes impossible due to the wide varying possibilities for estimating the cost function. In general, sub-queries with high selectivity and low computation cost are prioritized over sub-queries with low selectivity and high computation cost during query optimization. This methodology is applicable to precise constraints (including precise range queries). However, this optimization methodology has difficulties in dealing with fuzzy constraints and, in general, can not deal with similarity queries where all the objects in the database are candidates. In particular, query optimizers within any of the existing object-relational databases can not handle queries involving fuzzy Cartesian operators.
(2) Developing new extenders from existing search engines: Currently, each of the object-relational databases has relatively rigid APIs (application programming interfaces), and it is a tremendous effort to develop necessary "glues" for transforming an existing search engine into an extender/datablade/data cartridge. It is to be understood that the term glue, as well as the term "wrappers," refer to the software code necessary to transform a set of APIs to another set of APIs. A standard search engine has its own APIs which might not observe the programming models used in a database. As a result, software wrappers or glue are needed to transform the API from the search engine to the software environment needed by a database.
In the following discussion, we further elaborate on the first problem (query optimization). FIG. 3 illustrates an example of querying non-structured data such as images. The coarsest level of retrieval (coarse grain access) is the entire non-structured document, such as the whole image as shown in block 301. It is also possible to retrieve a sub-region of an image (e.g., facial region) as shown in block 302. Many emerging applications require retrieving at the object (e.g., tree, car, person) level (fine grain access) as shown in block 303. As the size of the document becomes increasingly large, object-level retrieval will also become increasingly important. Retrieval of the document, sub-document, or object based on meta-data other than a conventional data type requires the use of user-defined data types and user-defined functions. Both IBM and Informix have extenders and datablades, respectively, for performing this kind of access. However, the access of non-structured data is usually based on similarity measures such as Euclidean distance. This implies that all the entries within a database can be considered as candidates, and a very different set of criteria (as opposed to those used in a relational database) need to be adopted to prune search results. Currently, all existing object-relational databases have to go through the following process to combine query results from SQL (Standard Query Language) and from extension modules:
(1) request a pre-determined number of results (say the top 1000) from those extension modules (extenders, data cartridges, or datablades) which access non-structured data;
(2) rank the returned results based on a similarity measure (such as the Euclidean distance between the query and the retrieved result); and
(3) combine the returned results with other sub-queries that are processed through SQL.
However, this strategy may not yield the correct results when results from multiple extenders need to be combined (because of premature pruning by each extension module). Furthermore, the process of joining results from relational operations with those from extension modules encounters similar difficulties in producing the correct results.
FIG. 4 provides a taxonomy of different queries which challenge existing relational query paradigms. Four types of queries are listed here: "Join (denoted as 402)," "Logical Composition (denoted as 404)," "Spatial Composition (denoted as 406)" and "Temporal Composition (denoted as 408)." Existing relational mechanisms based on standard SQL queries can already handle the precise queries 410 in the tables. The fuzzy queries 412 in the table, however, require extensions which are mostly absent from existing relational engines.
An example of a spatial composition query is further illustrated in FIGS. 5 and 6. This query is searching for "objects" that are similar to "delta lobe" which comprises three "sub-objects": shale 501; sandstone 502; and siltstone 503. Each of these sub-objects in this query is defined by the image texture. Additional constraints specify that shale has to be adjacent to sandstone, and sandstone has to be within 10 feet from siltstone. This query is actually a sub-query in a much larger context, as shown in FIG. 6, where information existing in multiple modalities needs to be combined. In this case, the data relating to the borehole of an oil/gas well 601 includes:
(1) well log 602, which is a single-dimensional series capturing parameters such as Gamma ray, proton density, neutron density, etc.;
(2) core photos 603, which are digitized images of the cores extracted from the well (these core photos are taken both under visible light as well as ultraviolet);
(3) FMI 604, which is the 2-dimensional sensor reading of the resistivity/conductivity of the well; and
(4) reservoir model 605, which provides a global view of the wells in an area, and how strata goes from one well to another.
Previously, IBM Corporation's Garlic project proposed to use wrappers to integrate heterogeneous data sources. This approach is illustrated in FIG. 7. The wrapper provides the necessary schema translation from heterogeneous data sources such as:
(1) image wrapper 705, to access image archive 711 through image store 708;
(2) relational wrapper 706, to access relational tables 712 through relational DBMS 709; and
(3) document wrapper 707, to access document archives 713 through document store 710.
The global Garlic schema is integrated by the object-oriented middleware 703, which has the responsibility of optimizing the query from either the query/browse tool 701 or C++ API 702 against the global schema stored in a meta-data store 704. "OO" SQL refers to Object-Oriented SQL. This paradigm is fairly limited by its capability to be extended to accommodate hybrid fuzzy and precise queries. Each new query capability involves the revision of an optimization module for the global schema.
As opposed to extending query capability through Garlic-like structures, which integrates individual database management systems with an integrating database management system, the current object-relational approach extends the query capability through extension modules such as IBM DB2 extenders, Oracle data cartridges, or Informix datablades.
The present invention is directed toward techniques for providing a multi-tier object-relational database architecture. In one illustrative embodiment of the present invention, a multi-tier database architecture comprises an object-relational database engine as a top tier, one or more domain-specific extension modules as a bottom tier, and one or more universal extension modules as a middle tier. The individual extension modules of the bottom tier operationally connect with the one or more universal extension modules which, themselves, operationally connect with the database engine. The domain-specific extension modules may preferably provide such functions as search, index, and retrieval services of images, video, audio, time series, web pages, text, XML, spatial data, etc. The domain-specific extension modules may include one or more IBM DB2 extenders, Oracle data cartridges and/or Informix datablades, although other domain-specific extension modules may be used.
The one or more universal extension modules of the present invention may each perform the following functions:
(1) Query parsing: Those sub-queries that need to be handled by a universal extension module are embedded within user-defined functions and passed to a universal extension module. These sub-queries are then parsed by a query parser of a universal extension module. The result is then passed onto a query optimizer of a universal extension module.
(2) Query optimization: A query optimizer within a universal extension module performs a query optimization. As will be explained herein, the query optimizer of the invention is better able to perform query optimization than is otherwise possible with conventional extenders due to a better understanding on the part of the universal extension module of a data model of underlying data types. In particular, an object-oriented approach is applied to processing multimedia objects. In addition, the cost of processing sub-queries at the extension module can be sent back to a universal database optimizer, through a feedback mechanism, for further enhancing global query optimization, if necessary.
(3) Dispatch sub-queries to domain-specific extension modules. The sub-queries that are optimized by the query optimizer are dispatched to those domain-specific extension modules which have been registered with a universal extension module.
(4) Combine query results from those domain-specific extension modules connecting to a universal extension module, and return the query results to the database engine or another universal extension module that invoked the current extension module.
The hierarchical decomposition of the query optimization functions allows universal extension modules to perform more comprehensive query optimization regarding queries related to multimedia objects, without having to revise the object-relational query engine.
In one embodiment, an application programming interface (API) of a universal extension module according to the present invention may be a "plug-and-play" interface and may be implemented through a "self-describing" mechanism based on XML. The software code (e.g., glue) between a universal extension module and domain-specific extension modules which handles specific data types is synthesized automatically, thus greatly simplifying the task of adapting an existing search engine to a given object-relational database.
Plug-and-play capability for the universal extension module of the invention is similar to the concept of plug-and-play in the context of a personal computer. In the case of a personal computer, plug-and-play involves: (1) identifying the device that is connected (e.g., printer, CDROM, modem, etc.) and the port or slot it is connected to; (2) based on the information, determining and allocating the necessary resource (e.g., interrupt, I/O, memory, etc.); and (3) if this is a first use, then locating appropriate drivers from the driver library, then installing the required drivers. Plug-and-play for the universal extension module of the invention is similar. Whenever there is a new search engine that needs to be plugged in to the database as an extender, the search engine is identified, necessary resources (e.g., memory) are allocated, and then the interface is registered so that the search engine is known and can be invoked within the database.
It is to be appreciated that in order for an extension module to be plug-and-play, the extension module should describe the query language or API that the module accepts, the location of the index, if any, and the structure of the return results.
The term "self-describing," as used above, refers to the concept that there exists meta-data which describes the nature of the data. The meta-data may include the schema and semantics of the database.
Thus, as will be explained in detail herein, the present invention provides an extensible structure for software modules that can be used to construct an object-oriented extension of a relational database. Further, the invention provides a method for automatic synthesis of extender wrappers from existing software modules. Still further, the inventive hierarchical architecture for constructing extension modules provides advanced non-relational query processing capabilities.
These and other objects, features and advantages of the present invention will become apparent from the following detailed description of illustrative embodiments thereof, which is to be read in connection with the accompanying drawings.
FIG. 1 is a block diagram illustrating a database client connecting to one or more database management systems through a network;
FIG. 2 is a taxonomy of different data types that may need to be managed (search and retrieval) by a database management system;
FIG. 3 illustrates access granularity for different scenarios;
FIG. 4 illustrates both precise and fuzzy queries for join, logical composition, spatial composition, and temporal composition;
FIG. 5 illustrates a scenario which requires spatial composition of multiple regions, each of which is defined in terms of image features;
FIG. 6 illustrates a case where multiple modalities of data (core images, FMI data, well log data) need to be searched and fused to construct a reservoir model;
FIG. 7 illustrates the IBM Corporation Garlic approach for accessing heterogeneous data sources through wrappers;
FIG. 8 illustrates the client server structure for the IBM Corporation DB2/UDB;
FIGS. 9A and 9B show the DB2 text extender commands for server and clients, respectively;
FIGS. 10A and 10B show the DB2 text extender user-defined datatypes and user-defined functions, respectively;
FIG. 11 shows the DB2 text extender programming API;
FIG. 12 shows the tables before and after a column has been enabled for a text extender;
FIG. 13 shows the text column enabling process;
FIG. 14 shows the code example for using a text extender;
FIG. 15 shows the administrative tables for enabling a user table with an image extender;
FIGS. 16A and 16B show user-defined datatypes and user-defined functions for an image extender;
FIG. 17 shows the code examples of using image extenders;
FIG. 18 illustrates a framework for a universal extension module according to one embodiment of the present invention;
FIG. 19 shows the class hierarchy for subclassing a base extender class into various extenders;
FIG. 20 shows the process of extending the base feature extraction class with the MPEG-7 description scheme into an audio-visual feature extraction class;
FIG. 21 shows the MPEG-7 audio-visual description scheme;
FIG. 22 shows the MPEG-7 syntactic structure description scheme;
FIG. 23 shows the MPEG-7 region description scheme;
FIG. 24 shows the MPEG-7 segment/region relation graph description scheme;
FIG. 25 shows the MPEG-7 semantic structure description scheme;
FIG. 26 shows the MPEG-7 syntactic-semantic link description scheme;
FIG. 27 shows the MPEG-7 media information description scheme;
FIG. 28 shows the MPEG-7 meta-information description scheme;
FIG. 29 shows a process of subclassing an index creation and retrieval base class into various indexing classes;
FIG. 30 shows a process of subclassing a scoring and distance metric base class into various distance functions;
FIG. 31 shows a process of synthesizing wrappers for search engines to be plugged into the DB2 as an extension module;
FIG. 32 shows a structure of a search engine as an extension module with an automatically synthesized wrapper;
FIG. 33A shows a hierarchical decomposition of universal extension modules to handle new operators and search capabilities according to the present invention;
FIG. 33B illustrates a block diagram of functional components associated with a universal extension module according to an embodiment of the present invention;
FIG. 34 shows a code sample of invoking a universal extension module as a table function;
FIG. 35 shows a structure of an SPROC universal extension module which invokes additional extenders; and
FIG. 36 is a block diagram illustrating a generalized hardware architecture of a computer system suitable for implementing various aspects of the present invention.
As will be explained in detail below, the present invention provides the following: (1) an extensible structure for software modules that can be used to construct an object-oriented extension of a relational database; (2) a method for automatic synthesis of extender wrappers from existing software modules; and (3) a hierarchical architecture for constructing extension modules to provide advanced non-relational query processing capabilities.
It is to be appreciated that in the following detailed description, a preferred embodiment will be presented using the IBM Corporation database DB2 as an example. Although the DB2 extender structure, which is illustrated in FIG. 8, is used in this invention, it is to be understood that the principles of the present invention can be applied to any other object-relational databases such as those from Oracle and Informix, to name a few.
FIGS. 8-17 illustrate architecture and coding examples associated with using DB2 extenders. As illustrated in FIG. 8, the server side comprises a Universal Database (UDB) server computer system 801 connecting through an API to one or more extender servers 803. The client side comprises a UDB client computer system 802, which can interface with a human being or application programs through the following three approaches:
(1) Command line interpreter 804, which accepts administration commands;
(2) UDFs 805, which accept SQL queries with UDF extensions; and
(3) Application Programming Interfaces—APIs 806, which can be invoked by customer applications.
Using the DB2 extender as an example, DB2 V7.1 is currently providing text, multimedia, spatial, and XML extenders.
For the text extender case, all of the available commands for both the DB2 text extender server and the text extender client that can be interpreted by the command line interpreter (804 in FIG. 8) are listed in FIGS. 9A (server) and 9B (client). The client side commands include functions such as "connect to extender server" (connect), "enable text table" (enable text table), and "enable text column" (enable text column). The server side commands include functions such as "create a text extender instance" (TXICRT), "add text extender server" (TXNADD), and "start the text extender services" (TXSTART). The user-defined data types (UDTs) and user-defined functions (UDFs) (described in 805 in FIG. 8) are shown in FIGS. 10A (UDTs) and 10B (UDFs). UDTs defined for the text extender include DB2TEXTH, DB2TEXTFH, DB2TEXTHLISTP, and DB2TEXTFHLISTP. UDFs include CONTAINS, FILE, FORMAT, NO_OF_DOCUMENTS, etc. These UDTs and UDFs can be used in a SQL query (an example is shown and explained in FIG. 14). The programming API that can be directly embedded in a C or C++ program as subroutine calls is shown in FIG. 11.
An example of extending a pure relational table with the use of the text extender UDT is shown in FIG. 12. The original table 1201 contains attributes such as document identifier (DOCID) and Comment. The enhanced table 1202 with the use of a DB2 text extender adds one more attribute, Comment Handle, which contains: (1) a document ID; (2) the name and location of the associated index; and (3) the document information: coded character set ID (CCSID), format, and language.
This enhanced table is created using the command "ENABLE TEXT COLUMN." In addition to the additional comment handle column, two additional tables are created (as shown in FIG. 13): (1) Index 1301: an index for the text column is created when ENABLE TEXT COLUMN is invoked; and (2) Log table 1302: the log table is used to record changes to the text column, that is, inserts, updates and deletions. Insert, update, and delete triggers are defined for the text column to keep the log table up to date automatically.
Two code samples using text extenders are shown in FIG. 14. The first part 1401 prints out a list of dates and subjects of documents containing the comment "compress." Note that DB2TX.CONTAINS is a UDF call. The second part 1402 generates an intermediate result, TEMPTABLE, which comprises three attributes, DATE, SUBJECT, and MATCHES. The first sub-query builds the temporary table so that each row contains the following attributes from a document: date, subject, and number of times that "compress" appears in the document. The second sub-query selects those rows where MATCHES are greater than zero. The UDF used in the second query is DB2X.NO_OF_MATCHES. These two queries will generate identical results.
FIG. 15 illustrates the process of extending a regular table with an image extender. In this case, the user table 1501 originally contains ID and NAME as attributes. When a column is created for storing images based on the image extender UDT, the image is not stored in the user table. Instead, a handle (which is actually a character string) is created and stored in the user table (Handle 1, Handle 2). The extender stores the object in administrative support tables 1502, or stores a file identifier in the administrative support tables 1502, if the content of the object is in a file. The extender also stores the object's attributes and handle in the administrative support tables 1502. In this way, the extender can link the handle stored in a user table with the object information stored in the administrative support tables. Within the administrative tables, common attributes (independent of media type) such as importer and updater are stored in a first administrative support table 1503, while the other media-specific attributes such as width, height, number of bands are stored in a second administrative support table 1504.
A list of UDTs and UDFs for multimedia extenders (image, video, and audio) are shown in FIGS. 16A and 16B, respectively. Code samples of using these user-defined functions are illustrated in FIG. 17. The first example 1701 illustrates the process of specifying the data source ("/tmp/img.gif" in this case) for a color histogram feature. The second example 1702 illustrates the process of a search through a source defined by an "employee," and on the images defined by "qHandle."
FIG. 18 illustrates a framework for a universal extension module according to one embodiment of the present invention. In general, the universal extension module framework 1800 comprises four components:
(1) Data type 1801: This can be, for example, text, image, video, XML, geo-spatial data, etc.;
(2) Data model 1802: This is the description of the aggregation of, for example, text tokens, features, regions, segments, scenes, shots, etc.;
(3) Transformation methods 1803: These methods are used to perform feature extraction from data, transforming from one format to the other, such as, for example, from JPEG (Joint Photographic Expert Group) to GIF (Graphic Interchange Format), or from AVI (Audio Video Interleave) to MPEG (Moving Picture Expert Group—MPEG-1, MPEG-2 and MPEG-4); and
(4) Access methods 1804: Access methods are used for accessing the data, such as, for example, "top K results that are similar to . . . ", etc.
In a first aspect, the present invention comprises a framework and method comprising a class hierarchy so that maximal infrastructure and modules can be shared among different extension modules. The class hierarchy 1900 (in the object-oriented programming sense) of the universal extension module framework is illustrated in FIG. 19. Many extenders for providing accessing capabilities of various data modalities (as shown in FIG. 2) could potentially share many infrastructures such as feature extraction, index generation and measure of similarity (distance metric for results evaluation). However, all of the existing extenders, data cartridges or datablades are constructed independently of each other, and thus have very little sharing of infrastructure. Consequently, establishing a class hierarchy common to all extenders and search engines allows the components in the domain-specific extenders to be more sharable. In other words, the universal extension module framework, based on the class hierarchy, provides the foundation for building other extenders.
Identifying key components for building this class hierarchy, however, is not straightforward. The challenges include a deeper understanding regarding the decomposition of the functionality of the extenders. From the basic extender class 1901, key components of the extender class that involve search and retrieval of one data modality (as defined in FIG. 2) include: (1) feature extraction class 1904; (2) index creation/retrieval class 1905; (3) scoring/distance metric class 1906; and (4) learning/iterative refinement class 1907; etc.
These classes are also interrelated, and will be further explained in the context of the next few figures. Additional information such as the data types 1902 and the data models 1903 (such as those defined by MPEG-7 AV (audio-visual) description scheme) can then be used in conjunction with these basic classes to construct a text extender class 1908, an image extender class 1909, a video extender class 1910, etc.
FIGS. 20-28 give a detailed illustration of the process of constructing a audio-visual feature extraction module according to an embodiment of the present invention. Starting from the feature extraction base class 2001, as shown in FIG. 20, feature extraction classes for text data 2002, audio-visual data 2003, time-series data 2004, and multi-dimensional data 2005 can be included in the feature extraction module of the universal extension module.
The following description goes through the process of defining the audio-visual feature extraction module from the feature extraction base class using data models (such as those defined by the MPEG-7 Audiovisual description scheme 2006). Assuming that S represents the data, and M represents the data model of the features that are being extracted, the base class for the feature extraction can be defined as: F=Extract(S,M): this class extracts the features F based on the data model M from the data set S. Note that this class can be defined recursively, so that features can be extracted from features.
The data (as defined in FIG. 2) can be one-dimensional (such as time-series or audio), two-dimensional (images), two-dimensional plus time (video, image sequence), or three-dimensional (seismic, MRI, CT). The features can include low level features (such as texture, color histogram, or shape for images; slope for one-dimensional signals) or high level features (such as the semantic description of the data).
Based on the data modality, data-specific feature extractions can then be defined, such as time-series feature extraction, audio feature extraction, image feature extraction, video feature extraction, medical image feature extraction, and seismic data feature extraction. For audio-visual feature extraction, the MPEG-7 specification can be used for defining the data models.
The MPEG-7 Audio-Visual Description scheme is described in FIG. 21, which is the data model for defining the meta-data that describes the syntax, semantics, and features inside audio, images and video. Basic components of the MPEG-7 Audio-Visual Description scheme 2101 include syntactic description scheme 2102 (FIG. 22), semantic description scheme 2103 (FIG. 25), syntactic-semantic link description scheme 2104 (FIG. 26), model description scheme 2105, summary description scheme 2106, meta-information description scheme 2107 (FIG. 27), and media information description scheme 2108 (FIG. 28). It is to be appreciated that the 0, 1 and * in FIGS. 21-28 reflect the fact that some of the entities can be related to zero or one of the other entities. Using FIG. 21 as an example, syntactic DS (description scheme) is optional. When it is present, there is no more than one instance. So, it is expressed as 0, 1. The same scenario is applied to the rest of the DS. FIG. 22 indicates a slightly different scenario, in which segment DS is optional, and can have as many instances as needed. In FIG. 24, Entity relation is not optional, and can have one or more instances. On the other hand, relation is required and only one instance is allowed.
FIG. 22 shows the syntactic structure description scheme 2201, which contains a segment description scheme 2202, a region description scheme 2203 (FIG. 23), and a segment/region relation graph description scheme 2204 (FIG. 24) within an image or video sequence. Note that the term "segment" in MPEG-7 is an "abstract" class, which may be used to denote any arbitrary spatial or temporal regions or intervals.
The region description scheme, as shown in FIG. 23 as block 2301, includes a time description scheme 2302, a two-dimensional geometry description scheme 2303, a color/texture description scheme 2304, a motion description scheme 2305 (for video), a deformation description scheme 2306, meta-information description scheme 2307 (further detailed in FIG. 28), and media information description scheme 2308 (further detailed in FIG. 27).
FIG. 24 shows the segment/region relation graph description scheme 2401, which includes an entity relation block 2402. The entity relation block includes a relation block 2403, a reference to segment block 2406, and a reference to region block 2407. As shown, each relation 2403 is defined by a type 2404 and a name 2405.
FIG. 25 describes the semantic description scheme 2501, which comprises an event description scheme 2502, an object description scheme 2503, and an event/object relationship graph description scheme 2504.
The structure for linking the semantics and the syntax of audio-visual data is defined in FIG. 26. As shown, the syntactic-semantic link description scheme 2601 includes links 2602 which include link sources 2603 and link targets 2604.
The media information description scheme 2701, as shown in FIG. 27, includes one or more media profile description schemes 2702, which each include a media hardware description scheme 2703 and an identification/location description scheme 2704.
The meta-information description scheme 2801, as shown in FIG. 28, includes parametric data that is commonly associated with each image or video, including a content description scheme 2802, a credits description scheme 2803, a creation purpose description scheme 2804, a rights description scheme 2805, a publication description scheme 2806, and a financial information description scheme 2807. The content description scheme 2802 includes an event description scheme 2808 and a character description scheme 2809 which includes a physical attributes description scheme 2810. The credits description scheme 2803 includes a creation description scheme 2811 which includes a 6-W description scheme 2812, a technical staff description scheme 2813, and an artistic staff description scheme 2814 which includes a physical attributes description scheme 2815. The creation purpose description scheme 2804 includes a target description scheme 2817 and a classification description scheme 2818. The publication description scheme 2806 includes an emission description scheme 2819, a users/audience description scheme 2820 and an edition description scheme 2821. The financial description scheme 2807 includes a costs description scheme 2822 and an income description scheme 2823.
Based on the MPEG-7 description schemes described from FIGS. 21-28, it is then possible to synthesize the feature extraction module which will extract features from the media data (audio or visual) based on the feature data model described in FIGS. 21-28.
Referring now to FIG. 29, the index creation and retrieval class 2901 (shown as 1905 in FIG. 19) can be subclassed into text index 2902, B-tree 2903, R-tree 2904, grid file 2905, and other indexing schemes 2906. Some examples of other indexing schemes may include, but are not limited to, indexing structures which facilitate linear optimization queries as disclosed in the U.S. patent application identified by Ser. No. 09/360,366 (attorney docket no. YOR919990226US1) filed on Jul. 23, 1999 and entitled "Multidimensional Indexing Structure for Use with Linear Optimization Queries," the disclosure of which is incorporated by reference herein; and/or a hybrid clustering and R-tree indexing scheme as disclosed in the U.S. Pat. No. 6,122,628 (attorney docket no. YOR919970170US1) issued on Sep. 19, 2000 and entitled "Multidimensional Data Clustering and Dimension Reduction for Indexing and Searching," the disclosure of which is incorporated by reference herein.
In this case, the attributes in the base class include:
(1) Query q: the query q is used as the key to the search index;
(2) Constraint predicate C: which can be a range predicate for precise queries, such as a1≦q1≦a2, b1≦q2≦b2 if q=(q1,q2), or the top K candidates for similarity queries; and
(3) Distance metric D: which allows the same set of keys to be evaluated differently (the distance metric will be described in more detail below).
As an example of a similarity-based query, Q(q, K, L2) will retrieve the top K candidates from the database which are similar to the query q using the L2 distance metric. Alternatively, a constraint-based query Q(q, C) will retrieve those results that satisfy the constraint predicate C. The methods that are required for the base class, in general, include:
(1) Query: Q(q, C, D) retrieves the candidates that satisfy the constraint predicate C;
(2) Insert(q): insert the node which contains the key q into the index, and may involve splitting and balancing the tree; and
(3) Delete(q): deleting the node which contains the key q from the index, and may involve merging and balancing the tree.
Using these base classes, including the data structure and methods, various indexing classes can then be implemented.
Most of the extension modules for accessing various modalities require the use of some form of distance metric for computing the similarity between the candidates in the database and the target. The distance metric D(x,y) between two feature vectors x=[x1, . . . , xn]T, y=[y1, . . . , yn]T includes the following possibilities:
(5) Generalized quadratic distance (x−y)TM(x−y) where the matrix M allows weights to be assigned to different components of the vector.
Consequently, it is possible to define a base class distance metric between x and y, which includes the definitions of vectors x and y. As shown in FIG. 30, the scoring and distance metric base class 3001 (1906 as shown in FIG. 19) can then be subclassed into L1 distance 3002, L2 distance 3003, chi-square 3004, hamming 3005, etc. The L2 distance 3003 can be further subclassed into basic Euclidean 3006 and weighted Euclidean 3007. This structure allows maximum sharing of distance metrics when search engines for text, image, and video are constructed.
The base class for learning and iterative refinement (1907 as shown in FIG. 19), Dnew Learn(E, Doriginal, Q), involves the following:
(1) Category example E: which can simply be examples of relevant and irrelevant answers, or examples for each categories when the total number of categories are more than two. In most cases, the example set E is usually constrained to draw from the query results from Q;
(2) Dnew: which is the data set that has been transformed based on the examples and counter examples;
(3) Dorginal: which is the data set that is to be transformed through learning; and
(4) Q: is the query class for retrieving the top K candidates for a given query template, as defined above in the index base class.
Note that this class can be invoked recursively, i.e., each learning and iterative refinement will generate a new data set. The same query can then be applied and the classification of the query results can then be used for learning again. The iterative refinement process may take any suitable number of iterations, as the examples for each of the categories are only drawn from the query results, which are usually limited to a small number as compared to the overall dataset. Based on this class, various learning algorithms can then be subclassed including those adjusting the weights of the distance metric, as well as the algorithm disclosed in the U.S. patent application identified by Ser. No. 09/237,646 (attorney docket no. YOR919980220US1) filed on Jan. 26, 1999 and entitled "Method and Apparatus for Similarity Retrieval from Iterative Refinement," the disclosure of which is incorporated by reference herein, which applies nonlinear multi-dimensional scaling to "warp" the feature space based on the examples and counter examples provided through the learning process.
In a second aspect, the present invention provides a methodology for automatically synthesizing extension modules. By recognizing the fact that the data models and the methods associated with a search engine can be specified using interoperable meta-data such as XML schema, which is being standardized by World Wide Web Consortium, the methodology of the invention automatically generates the database-specific administrative tables, administrative commands, APIs and UDFs through the processing of such meta-data.
FIG. 31 illustrates such an automatic extension module synthesis procedure according to an embodiment of the present invention. In step 3102, administrative tables are created, such as shown in FIG. 15, based on the XML schema data model 3101. This is accomplished in accordance with the following steps. The database management system defines the required administrative tables, such as one for recording general information (e.g., the location of files), and one for recording specific information (e.g., the features extracted from the data). The search engine defines the exact data model that describes the features and indexing scheme for the search engine. Examples of such data models include those audio-visual description schemes defined in FIGS. 22-28. Based on the specifications from the database management systems and the search engine, commands such as CREATE TABLE TABLE_NAME (Attribute1, Attribute2, Attribute3, . . . , AttributeN) are generated. The definitions of the attributes are derived from the data model specification.
Then, in step 3103, administrative wrappers are created, such as those defined in FIG. 9, based on the method descriptions 3104 defined in the XML schema.
The database management system specifies the types of functions that will be needed, including extender server start, server stop, server status, server trace, server verify on the server side, and enable/change/disable extender client, inquire extender client status, etc. The search engine specifies the available functions for extracting features, creating index, performing search, etc. As an example, program modules such as ENABLE TEXT COLUMN, as shown in FIG. 9, are created, which invoke a number of classes such as (1) extract text features; (2) create text index; and (3) create log file.
Next, in step 3105, UDF wrappers are created, such as those defined in FIG. 10 and FIG. 16, also based on the method descriptions. From the specifications of the search engine functions, the UDF module is created which allows the proper search functions (defined in FIGS. 10 and 16) to be created.
FIG. 32 illustrates the structure of a search engine which is transformed into an extension module 3210 through the automatic synthesis process of the invention described above. The wrappers synthesized in FIG. 31 are shown as automatic synthesized glue/wrapper 3201. In order to synthesize these wrappers, the search engine 3204 needs to specify its schema 3202 and services (UDFs) 3203 explicitly.
In a third aspect, the present invention provides for a hierarchical decomposition of extension module functions so that universal extension modules can be invoked hierarchically, as shown in FIG. 33A. In this case, a first universal extension module (referred to as a universal extender in FIG. 33A) 3302-1 is operatively connected to a DB2 UDB engine 3301. Additional universal extenders 3302-2 through 3302-N can be attached hierarchically to the first extension module, as shown. The leaf nodes of the universal extension modules are the domain-specific extension modules (e.g., extenders, data cartridges, datablades, etc.) and are denoted as 3304-1 through 3304-P. The domain-specific extenders that connect directly to the UDB engine 3301 are denoted as 3303-1 through 3303-M. The UDB client 3305, coupled to the UDB engine 3301 via a network (not shown), may be configured similar to that shown in FIG. 8, with a command line interpreter 3306, UDFs 3307 and APIs 3308. The various universal extenders and domain-specific extenders in FIG. 33A may be implemented on one or more extender server computer systems and/or on the server computer system implementing the UDB engine.
One main difference between a universal extension module and a domain-specific extension module is that the universal extension module has the capability of parsing the query from its parents in the hierarchy (e.g., the UDB or other universal extenders higher in the hierarchy), and decomposing the query into one or more sub-queries in order to pass the sub-queries to other universal extenders or domain-specific extenders. Consequently, as illustrated in FIG. 33B, each universal extension module 3320 may have some or all of the following capabilities:
(1) Query parsing: parsing the queries passed from other universal extenders or UDB. These queries may not observe the SQL query syntax that is used for relational queries. The query parsing function may be implemented in accordance with query parser 3322;
(2) Query plan generation: generate an execution plan from the queries. The query plan generation function may be implemented in accordance with query plan generator 3324;
(3) Query optimization: re-arrange the query plan so that the execution time can be minimized. The query optimization function may be implemented in accordance with query optimizer 3326;
(4) Sub-query invocation: passing the sub-queries to other universal extenders or domain-specific extenders downstream. The sub-query invocation function may be implemented in accordance with sub-query invocator 3328; and
(5) Query results combining: combine (join) the results from those universal extenders or extenders attached to a particular universal extender. The query results combining function may be implemented in accordance with query results combiner 3330.
Note that it is also possible that some of the query plan execution may involve backtracking of the query plan. Consequently, steps (4) and (5) above may be invoked multiple times. In some cases, UDB callback is also necessary as it is possible that some of the SQL queries may have to be embedded in the universal extender query.
Since a universal extension module has to be able to return a table, the module can be implemented as a user-defined table function. Furthermore, since the universal extension module has its own query parsing mechanism, there is no restriction on the query language that can be used.
FIG. 34 shows an example of a universal extension module-invoking sequence using SQL. The user table 3401 includes obj_id (primary key), attr1, attr2, etc. The universal extension module, which is implemented as a user-defined table function 3402, has the form:
which retrieves the top 100 objects which include two sub-objects, one to the left of the other. Object 1 (obj_1) is specified in terms of its color, while object 2 (obj_2) is specified in terms of its texture. Additional parametric constraints are also specified, i.e., obj_1.attr1 =a, obj_2.attr2=b.
FIG. 35 illustrates an example in which a universal extension module 3503 based on the SPROC algorithm is attached to the UDB 3504. The SPROC algorithm is disclosed in the U.S. patent application identified by Ser. No. 09/237,734 (attorney docket no. YO919980274US1) filed on Jan. 26, 1999 and entitled "System and Method for Sequential Processing for Content-Based Retrieval of Composite Objects," the disclosure of which is incorporated by reference herein. The universal extension module in turn invokes either an image extender 3501 or a time series extender 3502.
The above-mentioned SPROC algorithm is designed for generating query results for bundled search problems. The bundle search is to simultaneously search multiple items with possible inter-item relationships. It is one of the most important enabling mechanisms in multi-modal signal detection and information fusion. For example, a fuzzy Cartesian (bundle search) query can be locating a rock strata structure across borehole images in an image database storing oil/gas exploration data. In this example, the strata template consists of three layers of rocks labeled as A, B, and C. A good match shall preserve the layering order but not necessarily the amount of separation between adjacent layers. For example, a strata structure A, B, D, and C may still be acceptable if the separation between B and C is not too large. In a borehole image, there can be tens or hundreds of rock layers with each layer showing different texture or color. Matching of rock images often involves assigning a fuzzy score in the range of zero to one to signify the confidence of the similarity of a region. By fuzzy characterization, a region can have multiple scores to multiple templates, such as 0.8 to A and 0.2 to B.
The fuzzy Cartesian problem in strata matching is to select the top-K structures that have the highest scores as compared to the template. For any three distinct image regions, one can calculate the fuzzy score to A of the top region, the score to B of the middle region, and the score to C of the bottom region. These scores are combined with the fuzzy scores weighting the distance between the top and the middle, as well as that between the middle and the bottom.
Referring now to FIG. 36, a block diagram is shown illustrating a generalized hardware architecture of a computer system suitable for implementing one or more universal extension modules according to the invention as described in detail herein. The computer system may also implement one or more domain-specific extension modules and a database engine. Further, the computer system may implement the entire server side of the database system and be connected to one or more similar computer systems used to implement the database clients. Such computer systems may be coupled via a network (e.g., Internet, Intranet, etc.)
As shown in FIG. 36, the computer system may comprise a processor 3602, a memory 3604 and I/O devices 3606. It is to be appreciated that the term "processor" as used herein is intended to include any processing device, such as, for example, one that includes a CPU (central processing unit) and/or other processing circuitry. The processor may also include a digital signal processor, as is well known in the art. The term "memory" as used herein is intended to include memory associated with a processor or CPU, such as, for example, RAM, ROM, a fixed memory device (e.g., hard drive), a removable memory device (e.g., diskette), flash memory, etc. In addition, the term "input/output devices" or "I/O devices" as used herein is intended to include, for example, one or more input devices (e.g., keyboard, mouse, etc.) for entering data to the processing unit, and/or one or more output devices (e.g., CRT display, printer, etc.) for presenting results associated with the processing unit. It is also to be understood that the term "processor" may refer to more than one processing device and that various elements associated with a processing device may be shared by other processing devices.
Accordingly, software components including instructions or code for performing the methodologies of the invention, as described herein, may be stored (e.g., as an article of manufacture) in one or more of the associated memory devices (e.g., ROM, fixed or removable memory) and, when ready to be utilized, loaded in part or in whole (e.g., into RAM) and executed by a CPU.
Although illustrative embodiments of the present invention have been described herein with reference to the accompanying drawings, it is to be understood that the invention is not limited to those precise embodiments, and that various other changes and modifications may be affected therein by one skilled in the art without departing from the scope or spirit of the invention.
|Cited Patent
|Filing date
|Publication date
|Oct 31, 1997
|Sep 19, 2000
|International Business Machines Corporation
|Multidimensional data clustering and dimension reduction for indexing and searching
|Dec 30, 1998
|Apr 23, 2002
|Oracle Corporation
|Database having an integrated transformation engine using pickling and unpickling of data
|Dec 6, 1999
|Jul 9, 2002
|Shyam Sundar Sarkar
|Method and apparatus for processing markup language specifications for data and metadata used inside multiple related internet documents to navigate, query and manipulate information from a plurality of object relational databases over the web
|Jun 30, 1999
|Sep 3, 2002
|Microsoft Corporation
|Extension of parsable structures
|U.S. patent application Ser. No. 09/237,646, V. Castelli et al., filed Jan. 26, 1999, "Method and Apparatus for Similarity Retrieval from Iterative Refinement."
|U.S. patent application Ser. No. 09/237,734, L.D. Bergman et al., filed Jan. 26, 1999, "System and Method for Sequential Processing for Content-Based Retrieval of Composite Objects."
|U.S. patent application Ser. No. 09/360,366, Bergman et al., filed Jul. 23, 1999, "Multidimensional Indexing Structure for Use with Linear Optimization Queries."
|Citing Patent
|Filing date
|Publication date
|Mar 7, 2002
|Aug 9, 2005
|Hitachi, Ltd.
|Storage system having means for acquiring execution information of database management system
|Jul 11, 2001
|Oct 10, 2006
|Sony Corporation
|Formal verification of semantic DS
|Aug 1, 2001
|Oct 17, 2006
|Actuate Corporation
|Method and apparatus for storing semi-structured data in a structured manner
|Aug 23, 2001
|Nov 7, 2006
|Syngenta Participations Ag
|System and method for accessing biological data
|Nov 21, 2000
|Dec 19, 2006
|Actuate Corporation
|Technique for encapsulating a query definition
|Apr 1, 2002
|May 29, 2007
|Ncr Corp.
|Extensible data type
|Jun 17, 2004
|May 6, 2008
|International Business Machines Corporation
|Method to provide management of query output
|Aug 21, 2003
|Jun 30, 2009
|Microsoft Corporation
|Systems and methods for separating units of information manageable by a hardware/software interface system from their physical organization
|Oct 24, 2003
|Sep 15, 2009
|Microsoft Corporation
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|Jun 30, 2003
|Oct 27, 2009
|International Business Machines Corporation
|Multi-modal fusion in content-based retrieval
|Jun 24, 2007
|Jan 5, 2010
|Nahava Inc.
|Method and apparatus for fast similarity-based query, self-join, and join for massive, high-dimension datasets
|Dec 11, 2006
|Apr 6, 2010
|Microsoft Corporation
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|Jul 25, 2006
|Apr 27, 2010
|Actuate Corporation
|Method and apparatus for storing semi-structured data in a structured manner
|Jul 14, 2005
|Jun 8, 2010
|Hitachi, Ltd.
|Storage system having means for acquiring execution information of database management system
|Aug 1, 2001
|Jul 13, 2010
|Actuate Corporation
|Nested conditional relations (NCR) model and algebra
|Dec 12, 2006
|Jul 20, 2010
|Eyetools, Inc.
|Evaluation of visual stimuli using existing viewing data
|Dec 2, 2005
|Aug 3, 2010
|Microsoft Cororation
|Missing index analysis and index useage statistics
|Apr 20, 2005
|Aug 17, 2010
|Microsoft Corporation
|Client store synchronization through intermediary store change packets
|Feb 28, 2005
|Sep 28, 2010
|Microsoft Corporation
|Change notification query multiplexing
|Jan 22, 2008
|Nov 30, 2010
|International Business Machines Corporation
|Method to provide management of query output
|Apr 9, 2004
|Feb 1, 2011
|Eyetools, Inc.
|Methods and apparatuses for use of eye interpretation information
|Apr 19, 2007
|Mar 29, 2011
|Retrevo Inc.
|Indexing and searching product identifiers
|Dec 11, 2006
|Mar 29, 2011
|Microsoft Corporation
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|Feb 18, 2011
|Aug 23, 2011
|Retrevo, Inc.
|Indexing and searching product identifiers
|Jul 1, 2008
|Sep 13, 2011
|International Business Machines Corporation
|Managing external routines in a database management system
|Jul 1, 2008
|Sep 20, 2011
|International Business Machines Corporation
|Medium and system for managing external routines in a database management system
|Jan 27, 2009
|Oct 25, 2011
|Microsoft Corporation
|Structural editing with schema awareness
|Aug 27, 2008
|Nov 22, 2011
|Satyam Computer Services Limited
|System and method for annotation aggregation
|Jan 8, 2009
|Nov 29, 2011
|Intelleflex Corporation
|RFID device and system for setting a level on an electronic device
|Oct 30, 2009
|Feb 14, 2012
|Nahava Inc.
|Method and apparatus for fast similarity-based query, self-join, and join for massive, high-dimension datasets
|Aug 21, 2003
|Mar 6, 2012
|Microsoft Corporation
|Systems and methods for interfacing application programs with an item-based storage platform
|Oct 24, 2003
|Apr 24, 2012
|Microsoft Corporation
|Systems and methods for the implementation of a synchronization schemas for units of information manageable by a hardware/software interface system
|Jul 19, 2011
|May 1, 2012
|Retrevo Inc.
|Indexing and searching product identifiers
|Oct 7, 2009
|Jul 10, 2012
|International Business Machines Corporation
|Information theory based result merging for searching hierarchical entities across heterogeneous data sources
|Oct 24, 2003
|Aug 7, 2012
|Microsoft Corporation
|Systems and methods for the implementation of a digital images schema for organizing units of information manageable by a hardware/software interface system
|Apr 19, 2007
|Oct 16, 2012
|Barnesandnoble.Com Llc
|Indexing and search query processing
|Mar 2, 2012
|Dec 4, 2012
|Barnesandnoble.Com Llc
|Indexing and searching product identifiers
|Apr 19, 2007
|Aug 6, 2013
|Barnesandnoble.Com Llc
|Unstructured and semistructured document processing and searching
|Jan 26, 2011
|Feb 18, 2014
|Salesforce.Com, Inc.
|Method and system for optimizing queries in a multi-tenant database environment
|Sep 7, 2012
|Mar 18, 2014
|Barnesandnoble.Com Llc
|Indexing and search query processing
|Oct 30, 2013
|Mar 3, 2015
|Steven Hoffberg
|Agent training sensitive call routing system
|Sep 30, 2011
|Apr 28, 2015
|Comprehend Systems, Inc.
|Systems and methods for generating schemas that represent multiple data sources
|Sep 23, 2008
|Jul 28, 2015
|Microsoft Technology Licensing, Llc
|Generating synonyms based on query log data
|Mar 6, 2012
|Oct 27, 2015
|Microsoft Technology Licensing, Llc
|Entity augmentation service from latent relational data
|Jan 22, 2014
|Dec 8, 2015
|Nook Digital, Llc
|Indexing and search query processing
|Aug 24, 2012
|Jan 5, 2016
|Microsoft Technology Licensing, Llc
|Word detection and domain dictionary recommendation
|May 3, 2012
|Feb 2, 2016
|International Business Machines Corporation
|Information theory based result merging for searching hierarchical entities across heterogeneous data sources
|Dec 2, 2008
|Dec 13, 2016
|Business Objects S.A.
|Deduction of analytic context based on text and semantic layer
|Jun 22, 2012
|Mar 14, 2017
|Microsoft Technology Licensing, Llc
|Targeted disambiguation of named entities
|May 14, 2010
|Mar 21, 2017
|Microsoft Technology Licensing, Llc
|Identifying entity synonyms
|Nov 20, 2014
|Mar 28, 2017
|Comprehend Systems, Inc.
|Pluggable domain-specific typing systems and methods of use
|Mar 2, 2015
|Apr 25, 2017
|Steven M. Hoffberg
|Agent training sensitive call routing system
|Jul 11, 2001
|May 16, 2002
|Rising Hawley K.
|Formal verification of semantic DS
|Aug 1, 2001
|Aug 29, 2002
|Christianson David B.
|Method and apparatus for storing semi-structured data in a structured manner
|Aug 23, 2001
|Feb 27, 2003
|Chantal Roth
|System and method for accessing biological data
|Aug 23, 2001
|Mar 20, 2003
|Chantal Roth
|System and method for transferring biological data to and from a database
|Jul 22, 2002
|May 1, 2003
|Emerick Charles L.
|Integrated search and information discovery system
|Mar 7, 2002
|May 15, 2003
|Hitachi, Ltd.
|Storage system having means for acquiring execution information of database management system
|Jun 30, 2003
|Dec 30, 2004
|Ibm Corporation
|Multi-modal fusion in content-based retrieval
|Aug 21, 2003
|Feb 24, 2005
|Microsoft Corporation
|Systems and methods for interfacing application programs with an item-based storage platform
|Oct 24, 2003
|Mar 3, 2005
|Bekim Demiroski
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|Aug 21, 2003
|Mar 10, 2005
|Microsoft Corporation
|Systems and methods for separating units of information manageable by a hardware/software interface system from their physical organization
|Oct 24, 2003
|Mar 24, 2005
|Dart Scott E.
|Systems and methods for the implementation of a digital images schema for organizing units of information manageable by a hardware/software interface system
|Oct 24, 2003
|Jun 9, 2005
|Ashish Shah
|Systems and methods for the implementation of a synchronization schemas for units of information manageable by a hardware/software interface system
|Apr 20, 2005
|Nov 3, 2005
|Microsoft Corporation
|Client store synchronization through intermediary store change packets
|Jun 17, 2004
|Dec 22, 2005
|International Business Machines Corporation
|Method to provide management of query output
|Mar 1, 2005
|Jan 12, 2006
|Microsoft Corporation
|Systems and methods to facilitate utilization of database modeling
|Jul 25, 2006
|Nov 23, 2006
|Christianson David B
|Method and apparatus for storing semi-structured data in a structured manner
|Aug 4, 2005
|Feb 15, 2007
|Peter Bendel
|Method and system for managing external routines in a database management system
|Oct 19, 2006
|Apr 19, 2007
|Edwards Gregory T
|Methods and apparatuses for collection, processing, and utilization of viewing data
|Dec 11, 2006
|Apr 19, 2007
|Microsoft Corporation
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|Dec 2, 2005
|Jun 7, 2007
|Microsoft Corporation
|Missing index analysis and index useage statistics
|Dec 12, 2006
|Jun 28, 2007
|Colin Johnson
|Evaluation of visual stimuli using existing viewing data
|Jun 24, 2007
|Dec 27, 2007
|Nahava Inc.
|Method and Apparatus for fast similarity-based query, self-join, and join for massive, high-dimension datasets
|Jul 18, 2006
|Jan 24, 2008
|Dawkins William P
|System and Method for Storage Area Network Search Appliance
|Jun 25, 2007
|Jan 31, 2008
|Siemens Corporate Research, Inc.
|Scalable Semantic Image Search
|Jan 22, 2008
|Jun 12, 2008
|Dettinger Richard D
|Method to provide management of query output
|Apr 19, 2007
|Oct 23, 2008
|Aditya Vailaya
|Indexing and search query processing
|Apr 19, 2007
|Oct 23, 2008
|Aditya Vailaya
|Unstructured and semistructured document processing and searching
|Apr 19, 2007
|Oct 23, 2008
|Aditya Vailaya
|Indexing and searching product identifiers
|Jul 1, 2008
|Oct 30, 2008
|International Business Machines Corporation
|Method for managing external routines in a database management system
|Jul 1, 2008
|Nov 20, 2008
|International Business Machines Corporation
|Medium and system for managing external routines in a database management system
|Jan 27, 2009
|May 28, 2009
|Microsoft Corporation
|Structural editing with schema awareness
|Jul 27, 2009
|Nov 19, 2009
|Shoma Inc.
|Systems and Methods for Bio-Refinery Application Management and Process Improvement
|Aug 27, 2008
|Mar 4, 2010
|Satyam Computer Services Limited Of Mayfair Centre
|System and method for annotation aggregation
|Dec 2, 2008
|Apr 15, 2010
|Jean-Yves Cras
|Deduction of analytic context based on text and semantic layer
|Jan 8, 2009
|Jul 8, 2010
|Peter Arnold Mehring
|Rfid device and system for setting a level on an electronic device
|Oct 7, 2009
|Apr 7, 2011
|International Business Machines Corporation
|Information theory based result merging for searching hierarchical entities across heterogeneous data sources
|Feb 18, 2011
|Jun 16, 2011
|Retrevo Inc.
|Indexing and searching product identifiers
|Jan 26, 2011
|Nov 17, 2011
|Salesforce.Com Inc.
|Method and System for Optimizing Queries in a Multi-Tenant Database Environment
|Sep 30, 2011
|Apr 4, 2013
|Rick Morrison
|Systems and methods for generating schemas that represent multiple data sources
|Jul 29, 2004
|Mar 17, 2005
|Microsoft Corporation
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|Jul 29, 2004
|Oct 20, 2005
|Microsoft Corp
|Systems and methods for extensions and inheritance for units of information manageable by a hardware/software interface system
|U.S. Classification
|1/1, 707/999.103, 707/999.102
|International Classification
|Cooperative Classification
|European Classification
|Dec 3, 2001
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:LI, CHUNG-SHENG;SMITH, JOHN R.;CHANG, YUAN-CHI;AND OTHERS;REEL/FRAME:012330/0584;SIGNING DATES FROM 20010822 TO 20011010
|Jun 8, 2004
|Certificate of correction
|Jul 13, 2007
|Fee payment
Year of fee payment: 4
|Jul 15, 2011
|Fee payment
Year of fee payment: 8
|Aug 6, 2015
|Fee payment
Year of fee payment: 12


text:
Oh, what fun Joshua had making his very first Valentines!!!
Project 365 (40-47)–Baby Joshua's First Valentines February 20, 2011
3 Responses to "Project 365 (40-47)–Baby Joshua's First Valentines"
What a wonderful idea and tradition to start. I am sure your mom (Like myself) has many holiday priceless hand made hand print ornaments/cards but these with the feet are awesome. What a wonderful way to make a heart and send love. Enjoy- before you know it, Joshua will be doing these with HIS children (don't laugh, time goes fast) love to all, Charlene
Awwww!!!! I love it!

subset: commoncrawl


text:
List Entry Summary
This building is listed under the Planning (Listed Buildings and Conservation Areas) Act 1990 as amended for its special architectural or historic interest.
Name: THE SHRIEVE'S HOUSE
List entry Number: 1298586
The building may lie within the boundary of more than one authority.
County: Warwickshire
District: Stratford-on-Avon
District Type: District Authority
Parish: Stratford-upon-Avon
National Park: Not applicable to this List entry.
Grade: II*
Date first listed: 25-Oct-1951
Date of most recent amendment: 04-Apr-1994
Legacy System Information
The contents of this record have been generated from a legacy data system.
Legacy System: LBS
Asset Groupings
This list entry does not comprise part of an Asset Grouping. Asset Groupings are not part of the official record but are added later for information.
List entry Description
Summary of Building
Legacy Record - This information may be included in the List Entry Details.
Reasons for Designation
Legacy Record - This information may be included in the List Entry Details.
Legacy Record - This information may be included in the List Entry Details.
SP2054NW SHEEP STREET 604-1/10/222 (North side) 25/10/51 No.40 The Shrieve's House (Formerly Listed as: SHEEP STREET (North side) No.40)
Yeoman's house, with rear outbuildings now shop. Front range probably rebuilt on old plan after 1614 fire, outbuildings rebuilt after 1595 fire; restored 1908, 1947 by F Yorke and 1979 by SA Wright. Timber-frame with plaster infill on coursed rubble plinth; tile roof with brick rear stack. 2 storeys with attic; 3 irregular bays; 1st floor jettied on carved brackets.Entrance to left end is a later feature, triangular head with leaded lights above and studded door with strap hinges and enriched iron handle; 1st floor raised over large carriage entrance to right end which has paired battened plank doors. Ground floor has 1:3:1-light canted oriel, originally bay window; similar oriel above has hipped roof, 3-light window to right and inserted 1908 two-light window to left; attic has 1947 large and small gabled dormers with windows of 4 and 3 lights. Close-studded framing. Rear has short gabled wing with stack to left of ridge and entrance with battened door. Lower 2-storey outbuilding range has brick and plaster infill; mostly 3-light windows, some with wooden diamond mullions originally unglazed, and varied entrances. Square framing. INTERIOR: well preserved with C17 staircase with splat balusters and square newels with finials; stud partitions and ex-situ panelling and doors brought from another house c1947. HISTORICAL NOTE: the house belonged to the Guild of Holy Cross, later to the Corporation; it became known in the C20 as the Shrieve's House from its 1st recorded tenent, William Sheryve, 1542; also inhabited by William Rogers, a Sergeant at the Mace, for whom the house was rebuilt and enlarged after the fire of 1595, and John Woolmer, the 1st Mayor of Stratford, 1664. A good example of a late C16 or early C17 yeoman's house retaining its range of outbuildings. (Bearman R: Stratford-upon-Avon: A History of its Streets and Buildings: Nelson: 1988-: 51; Stratford-upon-Avon Papers: Ree P: The Shrieve's House, Stratford-upon-Avon: Stratford-upon-Avon: 1987-).
Listing NGR: SP2023354876
Selected Sources
Books and journals
Bearman, R, Stratford Upon Avon A History of its streets and buildings, (1988), 51
Ree, P, 'Stratford upon Avon Papers' in The Shrieves House, (1987), 1987
National Grid Reference: SP 20233 54876
The above map is for quick reference purposes only and may not be to scale. For a copy of the full scale map, please see the attached PDF - 1298586 .pdf
The PDF will be generated from our live systems and may take a few minutes to download depending on how busy our servers are. We apologise for this delay.
This copy shows the entry on 19-Sep-2017 at 02:19:04.
End of official listing


text:
Enjoy a game of croquet and explore the owners' lovely garden and land, which includes bluebell woods and flower meadows.This studio cottage is near Golden Grove, 4 miles from Llandeilo, with delightful views to the Brecon Beacons. An ideal location for discovering country parks, castles and gardens, and well-placed for golfers and cyclists too.
Size: Sleeps 3, 1 bedroom
Nearest beach: 20 miles
Nearest amenities: 4 miles
Pets: Pet welcome
Short breaks: Available at this property
Smoking: No smoking inside
Rooms: Single bedroom, bed-sitting room, bath/shower room, kitchen
Beds: 1 double, 1 single
General: Central heating, TV, DVD player and WiFi.
Utilities: Electric cooker, microwave, fridge/freezer, washing machine
Standard: Kettle, toaster, iron
Other: Linen and towels provided
Outdoors: Use of 2 acre garden with barbecue and croquet lawn, access to 52 acres
Parking: Private parking


text:
The government is in the process of creating 42 new metropolitan, municipal and district assemblies (MMDAs), the Minister of Local Government and Rural Development, Mr Samuel Ofosu-Ampofo, has announced.
The minister gave the hint at a durbar of the chiefs and people of Dodowa at the beginning of a three-day tour of the Greater Accra Region by President John Evans Atta Mills Tuesaday.
He said the ministry had also proposed the disbursement of GH¢40 million as seed money to support the creation of the new districts.
Out of the proposed districts, the Greater Accra Region would have five. They are Ningo Prampram, Sege and Kpone Katamanso. The Madina District would be elevated to a municipality, while Okaiman will be created out of the Weija municipality.
The creation of the 42 proposed districts will bring to 212 the districts in the country.
Mr Ofosu-Ampofo said the creation of the new districts was a reflection of the commitment of the government to enhance democracy, particularly at the grass-root level.
The Dangme West District Chief Executive, Mr Emmanuel Anyimi Oddoi Lartey, said the assembly was committed to the government's better Ghana agenda which the President had tirelessly pursued with much dedication.
He said the area had large tracts of arable land, adding that with the right interventions, the district could easily become the food basket of the region.
Earlier, the President had inspected a new road construction at the Polo Grounds and the Spintex Road, reconstruction of the Tetteh-Ouarshie Pantang Road, inaugurated a clinic at Amanfro and inspected a three-storey boys' dormitory block at the Ghanatta Senior High School at Dodowa.


text:
The Book Report Network
Sign up for our newsletters!
The funeral of Charles Henry Topping would have been a minor affair but for the presence of one particular mourner: author A. N. Dyer, whose novel Ampersand stands as a classic of American teenage angst. But as Andrew Newbold Dyer delivers the eulogy for his oldest friend, he suffers a breakdown over the life he's led and the people he's hurt and the novel that will endure as his legacy. He must gather his three sons for the first time in many years --- before it's too late.
Read more »
Releases for the week of May 26th include DEEPLY ODD, the latest Odd Thomas thriller from the prolific Dean Koontz; WHITE FIRE by Douglas Preston and Lincoln Child, the 13th novel featuring FBI agent Aloysius Pendergast; Luanne Rice's THE LEMON ORCHARD, a heartrending love story of two people from seemingly different worlds; and THE WIDOW WALTZ by Sally Koslow, which explores the bonds between mothers and daughters, belligerent siblings, skittish lovers and bitter rivals as they discover the power of forgiveness and healing.
View all » | By Author » | By Genre » | By Date »
Copyright © 2017 The Book Report, Inc. All Rights Reserved.


text:
Hardik Mehta wrote:
Joe: I installed hibernate, but with the same result. May be you can suggest me the configs you made for making it work for you.
Looking at my configs, I changed /etc/hibernate/ram.conf like so: uncomment or add: EnableVbetool yes VbetoolPost yes UseDummyXServer no and, in /etc/hibernate/common.conf, I have # SwitchToTextMode yes COMMENTED OUT. With those options, suspend-to-ram works for me. - Joe
Description: S/MIME Cryptographic Signature


text:
T8 LED Lamp Recalled – Burn Hazard
Osram Sylvania has recently recalled about 46,300 T8 LED lamp units in the United States due to a burn hazard posed by the overheating and melting of the lamps.
About the Lamp Recall
The Consumer Product Safety Commission (CPSC) reports that the lamps can overheat and melt, causing a burn hazard.
So far, 34 incidents of overheating and melting have been reported to Osram Sylvania. Fortunately there have been no injuries reported.
Consumers who purchased the defective products are urged to discontinue use of the lamps and remove them from the fixture immediately.
Description of the Recalled Lamps
The following information was provided by the CPSC:
- The recalled lamps are SubstiTUBE IS T8 LED lamps.
- They were sold at Osram Sylvania distributors from December 2014 to may 2015.
- They are white cylinders that are 1 inch in diameter and 48 inches long.
- The name OSRAM SubtiTUBE® IS LED T8" is printed on a silver label on the lamp.


text:
How to delete cookies
You can always delete your cookies and remove the information about your behavior patterns (the cookies are saved on your browser).
The following links are guidelines to help you delete your cookies in your browser:
- Internet Explorer
- Mozilla Firefox
- Google Chrome
- Opera
- Safari
- Flash cookies (applied in all browsers)
- iPhone, iPad and other devices from Apple
- Phones running Android
- Phones running Windows 7
To analysis the user's behavior Kamstrup.com uses Google Analytics. The cookies restore information about your behavior (traffic date; IP-adresse) which are collected and send to Google's server in USA.
You can de-select cookies from Google Analytics by clicking button below.


text:
Metal News for May 15, 2011
Last updated on September 19, 2017 at 4:39 PM ET
We post metal news every day, throughout the day, covering thousands of metal bands including underground and unsigned bands. You are currently browsing the news archive, but you can also find news by band.
10 news articles posted on this day.
Sorrows Path Begins Pre-Recording For New Album
Greek act Sorrows Path has checked in with the following announcement about beginning the pre-recording process for a new album:
"Dear friends,
"Greek doomsters Sorrows Path began pre-recordings for their new album on their home studio! This new album that will contain 10 songs, is planned to be recorded at Fragile studios in Greece and be released in 2012. Some song titles are 'The king with a crown of thorns' and 'Brother of life.'
"This album will follow our first one, 'The Rough Path of Nihilism' that was released in October 2010 by German Rock it up records and earned some great feedback from the international press. Doom rules eternally..."
You can also check out a clip of Sorrows Path at the Malta Doom festival performing a medley of Ronnie James Dio songs at this location.
Unexpect To Play Brutal Assault Open Air
Unexpect recently announced an upcoming listening party for the band's new album "Fables Of The Sleepless Empire." The band has now issued the following brief update about also appearing at the Brutal Assault Open Air festival:
"We've recently been confirmed on the line-up of the Brutal Assault Open Air Festival in Czech Republic! The event will take place between the 11th and 13th of August. Here is the festival website."
The new album's track listing is as follows:
1. Unsolved Ideas Of A Distorted Guest
2. Words
3. Orange Vigilantes
4. Mechanical Phoenix
5. The Quantum Symphony
6. Unfed Pendulum
7. In The Mind Of The Last Whale
8. Silence This Parasite
9. A Fading Stance
10. When The Joyful Dead Are Dancing
11. Until Yet A Few More Deaths Do Us Part
Will Of The Ancients Posts New Album Teaser
Will of the Ancients has posted a brief teaser trailer online for the band's new album "To Our Glorious Dead," which can be viewed below. The band also commented on the clip:
"Greetings! We have uploaded a video teaser from the song 'The Stars, Like Dust' which will be on our upcoming album 'To Our Glorious Dead' due out this summer! Check it out! We will be uploading some more very soon! Cheers!"
Djevel Streaming New Song
Black metal act Djevel recently finished the recordings for the band's debut release, which will be titled "Dødssanger." The band has now posted a preview song from the album online.
You can check out the new song, named "Mørkefødt," by heading over to the official Djevel MySpace music profile.
Djevel features in its lineup T. Ciekals (ex-Ljå), E. Hjelvik (Kvelertak), as well as Mannevond (Koldbrann/Urgehal).
Sunday Old School: Anvil
By now, more or less every heavy metal fan knows the story of Anvil, thanks largely to the hit documentary movie, "Anvil! The Story Of Anvil." Whether it was the film or the music that made you a fan though, it's undeniable that Anvil are one of the most influential North American bands in the history of heavy metal. The seeds of the group were sewn back in 1973 when guitarist Steve "Lips" Kudrow and drummer Rob Reiner began jamming together, being influenced by the seventies heavy metal of Cactus and Black Sabbath. By 1978 the duo had formed a complete lineup which also featured guitarist Dave Allison and bassist Ian Dickson and Anvil was born.
The group released their debut album, "Hard 'n' Heavy" in 1981, initially under the moniker, "Lips," though it would later be released under the Anvil name. After the record's release, Motorhead mainman Lemmy invited Kudrow to become the band's new guitarist, filling in for the recently departed "Fast" Eddie Clarke, but the invitation was declined. Although it might not have been the wisest move financially, the next Anvil album would prove to be an underground classic in eighties metal, emerging in the form of "Metal On Metal" in 1982. The album included the superb title track as well as the Anvil live staples, "Mothra" and "666." The album was also a commercial success in the neighboring United States, where it reached number 91 on the Billboard album charts. Despite the success of the record, the band found follow up fame elusive, due in part to their restrictive record deal, which denied them the opportunity to sign with larger companies.
Although Anvil eventually broke free to sign with Metal Blade Records, they were still unable to regain the popularity which "Metal On Metal" seemed to promise. A slew of albums, including live records, were released throughout the eighties, nineties and 2000's but all with practically no success, and in some cases, almost no response, leaving the band to sometimes play to virtually empty venues. It was during the preparation for their thirteenth album that their biggest adventure would begin, as an old fan from the United Kingdom, who had since gone on to become a screenwriter, decided to make a documentary on the group. The documentary saw the band embark on a European tour with poor to mixed results, struggle to finance their new album, "This Is Thirteen" and eventually take to the stage in Japan to an overwhelmingly positive reaction. The film breathed a new life into the band, as audiences worldwide witnessed the struggles that come with the dedication to heavy metal, from mortgage problems to homelessness. Ever since then, the band has been performing regularly, appearing at such prestigious events as the Download Festival in England and filming a cameo for the movie, "The Green Hornet." Last week however, the band finally unleashed their highly anticipated new studio album, "Juggernaut Of Justice," which was released through The End Records on May 10th More...
Mastodon Guitarist To Release Side-Project Comp
Mastodon guitarist/vocalist Brent Hinds has announced that he will be releasing a special two CD set featuring material from both of his folk/rock side-projects West End Motel and Fiend Without A Face. The special package is set for release on June 7, 2011 through Rocket Science Inc. You can view the album's track listing below.
Disc 1- Fiend Without A Face
1. Calypso
2. Black Grass
3. Green Slime
4. Cha-Cha
5. Bank Robbin Bandits
6. Tsunami
7. Hot Rod
8. New York
9. Don't Like
10. Cosmonaut
11. Stupido
12. Get Straight
13. Volcano
Disc 2- West End Motel
1. The Confident Wino/...And We Are Here To Entertain You
2. The Devil Called Me Tommy
3. I Like It A Lot
4. She's On Fire
5. Under My Skin
6. Silly Old Song
7. Highwaters More...
My Ruin Posts New Music Video Online
American hard rock/metal act My Ruin has posted its new music video online. The video was comprised of live footage for the track "Diggin For Ghosts" and can be viewed in the player below.
Vegan Black Metal Chef Launches Official Website
Florida's "Vegan Black Metal Chef" Brian Manowitz has launched an official website for his ongoing series of recipe videos. On his website Manowitz offers the following explanation on why he choose to use vegan recipes for his black metal themed cooking show.
"The fast reason I tell people why I am vegan is that I do not believe in the exploitation of animals. Exploitation in this case means that the animal suffers for our benefit. Most animals raised for food live in what I would consider a darker hell than one even I could ever imagine. The best parts of their lives is their moment of death.
"Chickens live in tiny cages [amongst] mountains of shit, Cattle live in crowded factory farms on cement floors. Pigs live in crowded pens, or if its a female that has just given birth, live in tiny 'gestation crates' where they can not even turn around. Turkeys are given so many hormones that they grow too fast for their bones to support them. Of course not each and every animal is treated like this, but it is such the majority case that its time to bring consciousness to this area and decide if we want any part of it once and for all."
You can read the "Vegan Black Metal Chef's" in depth response to choosing a vegan lifestyle at this location, with the first episode - featuring a vegan version of Pad Thai - in the player below.
The Gate Reveals Debut Album Details
German heavy metal act The Gate has announced the track listing for its forthcoming debut album. The first album from the band, which features former Running Wild guitarist Gerald Warnecke, will contain ten tracks and is set to be release in late July through Rock It Up Records. You can view the album's track listing below.
1. Through The Gate
2. Shout For Metal
3. Face your Fear (The Money Song)
4. Guy Anvil
5. 1000 Miles Away
6. Mountains
7. Hiding Where The Wolf lives
8. Into The Pit
9. Deliver From Sin
10. Earth Cathedral
Cold Releases New Music Video
Jacksonville, Florida alternative metal act Cold has posted its new music video online. The video was shot for the track "Wicked World," which is taken from the band's forthcoming full length album "Superfiction." The album is set for release on June 28, 2011. You can check out the video in the player below.
Navigate forward or backward through each day of news below:


text:
LIMITED STOCK - The world famous Victoria and Albert museum are taking their wealth and knowledge, applying it to a stunning range of bed linen. The Kashmir by V&A is a beautiful elaborate floral design based on a traditional Kashmir artwork to bring you this vibrant pink, blue and yellow colour pallette finished with a stylish blue piped edging. For a stunning splash of colour this bold bed linen collection along with matching accessories will bring a true eastern feel to your home. Kashmir lined pencil pleat curtains - 168cm x 183cm. Complement the look with matching duvet cover, bedspread and cushion. Machine Washable.
Please note that all screens vary in colour reproduction and whilst every effort has been made to show the colour as accurately as possible it is for guidance only.
V&A Kashmir Curtains
Item: 9001307766
In stock
UK mainland delivery from £4.95
People who bought this also bought...
from £31.99


text:
A WOMAN who was injured in a head-on crash on the A64 remains in a stable condition in hospital.
Two vehicles crashed at Rillington, near Malton, in the early hours of Sunday.
The woman suffered what police called "not life threatening, but possibly life changing" injuries, and was freed by firefighters following the crash.
Two men in the other car were taken to Scarborough Hospital as a precaution, but were not injured.


text:
|Strength of Schedule Report
Aim For The Head
Search Aim For The Head
All Blogs (including podcasts)
Active Columns
Article Types
August 30, 2002 12:00 am
This week's question comes from Sam Grossman, who writes: What percentage of "quality starts" results in Ws, Ls and NDs for the starting pitcher? What about Ws and Ls for the team? Has this been consistent across time (effect of bullpens, etc.)?
This week's question comes from Sam Grossman, who writes:
July 18, 2002 12:00 am
This week's question comes from Chuck Valenches, who writes: I am the broadcaster for the Pirates' Triple-A club, the Nashville Sounds. We do a promotion where fans are encouraged to write in and "Ask the Sounds".... One question we received we cannot find an answer for. Q. Has there ever been a game in which both teams scored at least one run in every inning, and when was the last time it happened?
This week's question comes from Chuck Valenches, who writes:
July 12, 2002 12:00 am
More mailbag.
Judging from the feedback in my inbox, people are still having fun looking at the number of pitches in a plate appearance, so let's answer a few more questions from the mailbag.
June 26, 2002 10:00 pm
Many people brought up the point that strikeouts can only kick in at three pitches, and walks at four pitches.
The last Aim for the Head, about how offensive production varies with the number of pitches in the plate appearance, generated a lot of questions. Let's dig into the mailbag:
June 26, 2002 12:00 am
Ted Frank wrote:
This is a BP Premium article. To read it, sign up for Premium today!
June 11, 2002 10:01 am
Looking at which length of a plate appearance favors the hitter, the pitcher, or neither
This week's question comes from Don Coffin, who asks:
June 11, 2002 12:00 am
June 6, 2002 12:00 am
PAP^3 is the name for the new system for measuring pitcher abuse via pitch counts introduced in Baseball Prospectus 2001. Though it shares a similar name and goal with a system previously introduced by Rany Jazayerli, it was developed independently, and replaces the older system.
June 5, 2002 12:00 am
May 29, 2002 12:00 am
Since the chat session, I've received dozens of e-mails asking for additional details. The response from BP readers finally prodded me into finishing some related projects I'd had in progress for a while, which I'll present later in this article.
This is a BP Premium article. To read it, sign up for Premium today!
May 7, 2002 5:19 pm
This week's question comes from Robert Shore, who asks: Like many people, I was mightily impressed by Voros McCracken's work, which strongly suggested that pitchers have essentially no effect on the conversion of balls in play to outs. It occurred to me to wonder about the converse question. Are some batters better than others in converting balls in play to base hits?
This week's question comes from Robert Shore, who asks:
The remainder of this post cannot be viewed at this subscription level. Please click here to subscribe.
May 7, 2002 12:00 am
Starting today, we will be periodically running some of the best content from the new, super-charged Baseball Prospectus archives. Those new to BP may be reading this content for the first time. Long-time readers can rekindle old debates. We begin today with Keith Woolner's look at the conversion of balls in play into outs, from 2002. To do your own mining, go to BP's Search function. To request a specific article from the archives, e-mail email@example.com.
This week's question comes from Robert Shore, who asks:


text:
It was all about leather bodysuits at tonight's Superbowl festivities!
Jennifer Hudson kicked off the night's performances with her rendition of "America the Beautiful," which she sang alongside students from Sandy Hook Elementary School. For the momentous occasion, she wore a L'Wren Scott skirt, $895 Saint Laurent ankle strap pumps, and the same $795 Monika Chiang leather bodysuit Kourtney Kardashian wore for an appearance at Sirius Satellite Radio Studios in NYC:
While both ladies opted for white skirts, JHud stuck to a pencil silhouette, while Kourtney went flirty in a more A-line Miu Miu number.
The leather top has an ultra slim fit throughout torso and wrists, along with a mock turtleneck.
While I wasn't particularly wowed by JHud's outfit while watching her perform on TV, I am impressed by the still shots. The skirt's tailored fit goes well with the top's sophisticated aura. I think Jennifer might have my vote!
What do you think?
*In case you missed Jennifer's performance, check it out here:


text:
A bitter row has broken out at the Church of the Holy Ghost, in Hammarsdale, over allegations of mismanagement of funds and claims of missing millions.
A case of fraud is now being investigated by the police regarding the claims.
Certain church members have accused some pastors and senior members of fraudulently using church funds for their own gain.
A group calling itself Church of the Holy Ghost Concern Members said the church coffers were short R6.5 million, and blamed Hendrick Sibuyi, the church's general committee chairman, for the shortfall.
Sibuyi has, however, denied any wrongdoing.
The group said they were first alerted of the shortfall early this year by some pastors.
Hubert Maphumulo, who spoke on behalf of the group, said they had been informed that Sibuyi had influenced some pastors to invest R1.5 m in a certain project.
"The pastors were told that they would receive R100 000 a month, which would be shared equally among them for four years if they agreed to invest the money.
"That money belonged to the church, but the R100 000 would be given to those pastors, not put into the church account. The money was released without the knowledge of the congregation or deacons," he said.
During a meeting last month, Maphumulo said it emerged that R5m was also missing from the church's R35m account.
"The R1.5m seemed to be just the tip of the iceberg. We were beyond shocked when we found out that more money was missing and we weren't given an explanation of where it had disappeared to," he said.
During the meeting, Maphumulo said a senior church member had informed them that he had been given instructions to transfer huge sums into unknown bank accounts.
"Our concern is that in- formation of these events are being withheld from church members. Pastors say members must not be told the truth because they might backslide and leave the church.
"Our pastors don't seem to care about the fact that church institution policies or non-profit organisation laws require transparent accounta- bility since church money is public funds, but they have the nerve to say people must not be told the truth about church financial discrepancies," Maphumulo said.
Sibuyi however has rejected Maphumulo's allegations, saying Maphumulo and his group had been dismissed from the church for sowing division.
"Early this year these guys started complaining about people and things that they didn't like in the church, but they failed to follow the proper channels. They were told to stop and that is when they started spreading rumours," said Sibuyi.
About a month ago Sibuyi said Maphumulo and his group were charged internally for sowing division in the church and they were dismissed.
Sibuyi conceded that things were not rosy at the church, but he blamed Maphumulo and his group. "They have caused havoc in the church," he said.
Sibuyi also dismissed allegations that there was money missing from the church's account.
He conceded however that R1.5m had been invested, but he said this was done after the church committee had given him the go-ahead.
"On the R5m, that is just nonsense because the church doesn't even have R10m… I don't know where they got that figure from," he said.
Police spokesman Captain Thulani Zwane confirmed that a fraud case had been opened last month and that police were investigating.
Asked if he and the rest of his group had been dismissed from the church, Maphumulo said he was still a member of the church.
"They sent us letters claiming that we have been expelled, but a church is a public entity. They can't dismiss us without a hearing, which never occurred.
"These are just Sibuyi's attempts at trying to prevent us from speaking the truth, but they won't work.
"We will continue to expose them because a church is a house of God and a place of worship, not (sic) for criminal activities," he said.
The church, was in the news in March this year when one its pastors, Cyril Mhlonipheni Ngcobo, was arrested after police allegedly found about R1m in prescription drugs at the church.
He was charged with the contravention of the Medicines Act.
At the time police said various medicines were being dispensed to members of the community and that the packaging was marked for state use.
Ngcobo, 34, who is out on bail was promoted to head pastor shortly after the incident.


text:
'Florida Thinks' is no more
That's the word from John Koenig, editor of Florida Thinks, an online service that attempted to entice readers with editorial pieces on serious Florida issues.
Koenig announced the demise of the experiment Wednesday with an e-mail to subscribers.
"'Florida Thinks' was a success in all areas except revenues,'' Koenig wrote. "But financial reality demands that we cease publication.'' The website has been on "vacation'' since July 21. The service began Feb. 1 and had hoped to attract enough readers willing to subscribe at less than $4.99 a month to become profitable.
"Florida Thinks" thus becomes the first of a handful of new web-only news sites to fold its tent. "We succeeded in proving that people really won't pay for journalistic content on the Internet, no matter how low the price,'' Koenig said Wednesday. "'Florida Thinks' drew thousands of readers each month, but could not convert them into subscribers.''
Lucy Morgan


text: Hi guy/girls. I really want to do a meet in the Plymouth/south west area. I know lots of you are in Exeter so we can meet halfway. Seen so many Clio's around here and we need to get together for a big meet very soon. The last meet was too short notice for me so I want to know your thoughts and ideas please then I will do a date for sure. Thinking more near the summer when its nice May/June. How about the Moors as a location. lots of car parks there, take some great pics and meet each other. Let me know your ideas please ie if any of you will be working etc. Sunday will be the best day for us right? cheers Guys


text:
Georgia's unemployment hits four year low
Thu, 20 Dec 2012 13:46:06 GMT —
The Georgia Department of Labor announced Thursday that Georgia's seasonally adjusted unemployment rate has declined to 8.5 percent for November.
State Labor Commissioner Mark Butler says that "this is the lowest state unemployment rate in nearly four years, since it was 8.5 percent in January 2009." He attributes the dropping rate to job growth and fewer new layoffs.
Labor officials say trade, transportation and warehousing sectors saw the biggest job gains,
"I am encouraged by the continuing growth in the number of manufacturing jobs in Georgia," said Gov. Nathan Deal. "This is a result of focusing on a pro-business environment and working closely with Georgia employers to help them grow their businesses, while actively recruiting new industry to our state."
Authorities say that initial unemployment insurance claims declined to 47,351 from 51,495 in October, making it the lowest claims number in seven years.
Stay connected to MySouthWestGA.com as stories develop and the FOX 31 Newscast at 10 PM. Visit us on Facebook and Twitter to join in on the conversation and connect with FOX 31!