Abstract: A method and system for providing customized filters to restrict datasets retrieved from a database are described. In one embodiment, the method includes receiving a data access query that combines a structured query language (SQL) statement with output related characteristics of an output data chart. The data access query is provided by a first user. The method further includes building the output data chart for a second user using the data access query.

Abstract: A method and system for providing customized filters to restrict datasets retrieved from a database are described. In one embodiment, the method includes receiving a template data access query from a first user, identifying multiple data elements from database tables that are to be accessed according to the template data access query, creating a set of preliminary filters based on the multiple data elements, presenting to a second user the layout of a data presentation and some or all of the preliminary filters, and creating final filters using filter parameters specified by the second user for the preliminary filters. The final filters restrict the content to be retrieved from a database for the data presentation. The method further includes building for the second user the data presentation with the content that is retrieved from the database using the final filters.

Abstract: The present invention introduces a system and method for organizing, storing, retrieving and searching through binary representations of information in many forms and formats. Data is stored in its original file format, while maintaining metadata about the data items in a relational database. During searches the system utilizes the metadata to invoke data translators of the appropriate type to present data to the search engine itself. In addition, the system utilizes profiles and access control lists to restrict access to data to authorized users.