Abstract: Facilitating identification of star schemas in database environments. In an embodiment, queries directed to relational database tables (organized according to normalized schema) are examined to determine the relationships specified in the queries. A star schema is then generated by including the specified relationships. A data warehouse may be organized according to the generated star schema and the data previously stored in the database tables may be copied to the data warehouse.

Abstract: A round cutting insert with a reverse anti-rotation feature that can be manufactured easily and inexpensively is disclosed. The round cutting insert includes a plurality of dimples formed on a first surface and another plurality of dimples formed on a second, opposing surface. The round insert is reversible and indexable. The round cutting insert is removable received in an insert receiving pocket in a tool body. The insert receiving pocket includes a single projection that is capable of being received in one of the plurality of dimples. The cooperation between the projection and one of the plurality of dimples prevents rotation of the round cutting insert when mounted in the insert receiving pocket. The plurality of dimples and the projection can be any desirable complimentary shape, such as a slot, a V-shape, a wagon wheel, a sports wheel, a pyramid, and the like.

Abstract: A round cutting insert with an anti-rotation feature. The round cutting insert includes a plurality of projections formed on a first surface and another plurality of projections formed on an opposing surface. The round cutting insert is reversible and indexable. The round cutting insert is removably received in an insert receiving pocket in a tool body wherein the insert receiving pocket includes a plurality of dimples for receiving one of the plurality of first projections or the plurality of second projections. This arrangement prevents rotation of the round cutting insert while mounted in the insert receiving pocket.

Abstract: A round cutting insert with a reverse anti-rotation feature that can be manufactured easily and inexpensively is disclosed. The round cutting insert includes a plurality of dimples formed on a first surface and another plurality of dimples formed on a second, opposing surface. The round insert is reversible and indexable. The round cutting insert is removable received in an insert receiving pocket in a tool body. The insert receiving pocket includes a single projection that is capable of being received in one of the plurality of dimples. The cooperation between the projection and one of the plurality of dimples prevents rotation of the round cutting insert when mounted in the insert receiving pocket. The plurality of dimples and the projection can be any desirable complimentary shape, such as a slot, a V-shape, a wagon wheel, a sports wheel, a pyramid, and the like.

Abstract: A round cutting insert with an anti-rotation feature. The round cutting insert includes a plurality of projections formed on a first surface and another plurality of projections formed on an opposing surface. The round cutting insert is reversible and indexable. The round cutting insert is removably received in an insert receiving pocket in a tool body wherein the insert receiving pocket includes a plurality of dimples for receiving one of the plurality of first projections or the plurality of second projections. This arrangement prevents rotation of the round cutting insert while mounted in the insert receiving pocket.

Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.

Abstract: Facilitating identification of star schemas in database environments. In an embodiment, queries are examined to determine the joins required. The two tables of each join are added as a relationship in the star schema.

Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: a) receive user input indicating selected items to be retrieved from the database; b) ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, c) if so: i) create a second view that is a copy of the first view and add a copy of each reach through item to it; and ii) create a query that refers only to the second view and the items exposed by it.