International Business Machines Corporation

Heather A Smith

Michael Battaglia

John W Eckhart

Mark Chen-Quee

A system, method and computer program product for evaluating a user's database (db) design schema and definitions syntax and generating a database score according to applied decision tree logic. The database design syntax is automatically evaluated and decision tree logic is applied to determine a context of the database design object and associated syntax and definitions statements. As a result of the automated evaluation, users may then obtain, via a user interface device, a detailed context information associated with their design to assist them in understanding how their database score was derived. By using this detailed contextual information, users analyze the results and can understand what changes can be made to improve their definitions Database Score. The system and method increases the ability of the user to create better database definitions by learning and improving using the contextual data returned.

Retrieving database score contextual information

Embodiments include method, systems and computer program products for evaluating a database design. Aspects include receiving a first database definition for a first database comprising multiple database object definitions; receiving database design rules; calculating object scores representing a compliance between the database object definitions with the database design rules; calculating a first database score based on the object scores; receiving a second database definition for a proposed modification to the first database, wherein the second database definition includes modified database object definitions; calculating object scores representing a compliance between the modified database object definitions of the second database definition with the one or more database design rules; calculating a second database score based on the object scores; displaying the first and second database score; displaying a cause of a difference between the first and second database scores; and receiving an indication of whether to implement the second database definition.

Evaluating a database design and modifications thereto

A mechanism is provided in a data processing system for optimizing a database definition of an existing database. The mechanism receives usage data for the existing database. The mechanism queries a knowledgebase for information about database objects of the existing database. The mechanism executes optimization logic to generate a set of database commands based on the usage data and information about database objects. The set of database commands, when executed against a database definition of the existing database, optimize one or more database objects of the existing database. The mechanism returns the set of optimization commands.

Optimizing database definitions in an existing database

An embodiment of the invention provides a method for controlling access to content in a social networking website, wherein a connection is established between a first user and a second user on the social networking website. Content on the profile pages of the first user is categorized into a first content category and a second content category. The first content category includes content created before the connection between the first user and the second user was established. The second content category includes content created after the connection between the first user and the second user was established. Content in the first content category is also categorized into a first subcategory and at least one second subcategory. Access by the second user is restricted to the first content category. Specifically, the second user is prevented from viewing content in the first subcategory and permitted to view content in the second subcategory.

Time based access control in social software

Systems and methods for optimizing a definition for a database are provided. A method for optimizing a definition for a database, comprises receiving an input command to create a database object, receiving at least one extension corresponding to an estimated feature of the database, submitting the input command and the at least one extension to a knowledge base to determine an optimized command, and generating the optimized command.

Growing community of inventors

Mahopac, NY, United States of America

Heather A Smith