Abstract: An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.

Abstract: An automated system for validating and refining a template warehouse star schema for a customized data source.

Abstract: An automated system for validating and refining a template warehouse star schema for a customized data source.

Abstract: An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.

Abstract: Systems and methods of making secure communications in a communications network comprising a user device (2) connectable to the network (12) and comprising encryption/decryption means (8) operative after connection, a recipient device (4) is connectable to the user device via an intermediary device (10) having an intermediary contact number and complimentary encryption/decryption means (8) to the user device encryption/decryption means; in use, when the user device connects to the intermediary device using the intermediary contact number, the intermediary device securely obtains a recipient contact number and enables encrypted connection at least between the user and server (10).

Abstract: A butterfly valve for controlling the flow of fluid within a bore, including a butterfly and at least one ring extending at least one of substantially and completely around a perimeter of the butterfly and adapted to develop an expansion force in the radial direction when the at least one ring is in a contracted state with respect to the radial direction, wherein the at least one ring is secured to the butterfly in the contracted state and radial expansion due to the developed expansion force of the at least one ring is effectively restrained, wherein the butterfly valve is adapted to operate, when placed in a bore, without friction or substantially without friction between the at least one ring and the bore when the butterfly valve is placed in a closed position within the bore.

Abstract: A solenoid actuated valve for controlling flow of fluid through a bore defined by a tube comprises an armature fitted slidably in the bore for displacement therein under solenoid control. The armature comprises a generally cylindrical magnetic body that is a clearance fit in the bore, and a glide pad carried by the magnetic body for guiding movement of the magnetic body relative to the tube and preventing direct sliding contact therebetween.