The Experts below are selected from a list of 213 Experts worldwide ranked by ideXlab platform
Henrique Madeira - One of the best experts on this subject based on the ideXlab platform.
-
Adding a Performance-Oriented Perspective to Data Warehouse Design
2007Co-Authors: Pedro Bizarro, Henrique MadeiraAbstract:Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement. However, the increasing demands for interactive response time from the users make query performance one of the central problems of data warehousing today. In this paper we defend that data warehouse design must take into account both the business and the performance perspective from the beginning, and we propose the extension to typical design methodologies to include performance concerns in the early design steps. Specific analysis to predicted data warehouse usage profile and meta-data analysis are proposed as new inputs for improving the transition from logical to Physical Schema. The proposed approach is illustrated and discussed using the TPC-H performance benchmark and it is shown that significant performance improvement can be achieved without jeopardizing the business view required for data warehouse models.
-
DaWaK - Adding a Performance-Oriented Perspective to Data Warehouse Design
Data Warehousing and Knowledge Discovery, 2002Co-Authors: Pedro Bizarro, Henrique MadeiraAbstract:Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement. However, the increasing demands for interactive response time from the users make query performance one of the central problems of data warehousing today. In this paper we defend that data warehouse design must take into account both the business and the performance perspective from the beginning, and we propose the extension to typical design methodologies to include performance concerns in the early design steps. Specific analysis to predicted data warehouse usage profile and meta-data analysis are proposed as new inputs for improving the transition from logical to Physical Schema. The proposed approach is illustrated and discussed using the TPC-H performance benchmark and it is shown that significant performance improvement can be achieved without jeopardizing the business view required for data warehouse models.
Pedro Bizarro - One of the best experts on this subject based on the ideXlab platform.
-
Adding a Performance-Oriented Perspective to Data Warehouse Design
2007Co-Authors: Pedro Bizarro, Henrique MadeiraAbstract:Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement. However, the increasing demands for interactive response time from the users make query performance one of the central problems of data warehousing today. In this paper we defend that data warehouse design must take into account both the business and the performance perspective from the beginning, and we propose the extension to typical design methodologies to include performance concerns in the early design steps. Specific analysis to predicted data warehouse usage profile and meta-data analysis are proposed as new inputs for improving the transition from logical to Physical Schema. The proposed approach is illustrated and discussed using the TPC-H performance benchmark and it is shown that significant performance improvement can be achieved without jeopardizing the business view required for data warehouse models.
-
DaWaK - Adding a Performance-Oriented Perspective to Data Warehouse Design
Data Warehousing and Knowledge Discovery, 2002Co-Authors: Pedro Bizarro, Henrique MadeiraAbstract:Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement. However, the increasing demands for interactive response time from the users make query performance one of the central problems of data warehousing today. In this paper we defend that data warehouse design must take into account both the business and the performance perspective from the beginning, and we propose the extension to typical design methodologies to include performance concerns in the early design steps. Specific analysis to predicted data warehouse usage profile and meta-data analysis are proposed as new inputs for improving the transition from logical to Physical Schema. The proposed approach is illustrated and discussed using the TPC-H performance benchmark and it is shown that significant performance improvement can be achieved without jeopardizing the business view required for data warehouse models.
Mohammed Minout - One of the best experts on this subject based on the ideXlab platform.
-
OTM Workshops (2) - Implementing conceptual spatio-temporal Schemas in object-relational DBMSs
On the Move to Meaningful Internet Systems 2006: OTM 2006 Workshops, 2006Co-Authors: Esteban Zimányi, Mohammed MinoutAbstract:Several spatio-temporal conceptual models have been proposed in the literature Some of these models have associated CASE tools assisting the user from the creation of the conceptual Schema until the generation of a Physical Schema for a target DBMS or GIS However, such CASE tools only consider the translation of information structures (i.e attributes) Since current DBMSs or GISs provide limited support for temporal and spatio-temporal information, when translating conceptual Schemas it is necessary to automatically generate the functions and procedures allowing to manipulate spatio-temporal information in the target platform In this paper we describe how to realize this generation in an object-relational DBMSs.
-
OTM Workshops - Preserving semantics when transforming conceptual spatio-temporal Schemas
On the Move to Meaningful Internet Systems 2005: OTM 2005 Workshops, 2005Co-Authors: Esteban Zimányi, Mohammed MinoutAbstract:Conceptual models provide powerful constructs for representing the semantics of real-world application domains. However, much of this semantics may be lost when translating a conceptual Schema into a logical or a Physical Schema. The reason for this semantic loss is the limited expressive power of logical and Physical models. In this paper we present a methodology that allows to transform conceptual Schemas while preserving their semantics. This is realized with the help of integrity constraints that are automatically generated at the logical and Physical levels. As a result, the semantics of an application domain is kept in the database as opposed to keeping it in the applications accessing the database. We present such a methodology using the MADS conceptual spatio-temporal model.
Jacob Anhøj - One of the best experts on this subject based on the ideXlab platform.
-
Generic design of Web-based clinical databases.
Journal of medical Internet research, 2003Co-Authors: Jacob AnhøjAbstract:BACKGROUND: The complexity and the rapid evolution and expansion of the domain of clinical information make development and maintenance of clinical databases difficult. Whenever new data types are introduced or existing types are modified in a conventional relational database system, the Physical design of the database must be changed accordingly. For this reason, it is desirable that a clinical database be flexible and allow for modifications and for addition of new types of data without having to change the Physical database Schema. The ideal clinical database would therefore implement a highly-detailed logical database Schema in a completely-generic Physical Schema that stores the wide variety of clinical data in a small and constant number of tables. OBJECTIVE: The objective was to review the medical literature regarding generic design of clinical databases. METHODS: A search strategy was devised for PubMed and Google to get the best match of peer-reviewed articles and free Web resources on the subject. RESULTS: Eight peer reviewed articles and a Web tutorial were found. All the resources described the so-called Entity-Attribute-Value (EAV) design as a means of simplifying the Physical layout of data tables in a clinical database. In Entity-Attribute-Value design all data can be stored in a single generic table with conceptually 3 columns: 1 for entity (eg, patient identification), 1 for attribute (eg, name), and 1 for value (eg, "Jens Hansen"). To add more descriptive fields to the entity class, all that is necessary is to add attribute values to be stored in the attribute field. The main advantages of the Entity-Attribute-Value design are flexibility and effective entity-centered data retrieval. The main disadvantages are complicated front-end programming needed to display data in a conventional layout that the user understands and less-efficient attribute-centered queries. The Internet offers unique opportunities for database deployment, eliminating problems of user-interface deployment. Furthermore, Web forms may be generated in a completely-generic fashion during run time from metadata describing the semantic structure of clinical information stored in the database. CONCLUSIONS: The Entity-Attribute-Value model is useful for generic design of clinical databases. Depending on the specific requirements of the application, more or less complex metadata models may be applied. [J Med Internet Res 2003;5(4):e27]
Esteban Zimányi - One of the best experts on this subject based on the ideXlab platform.
-
OTM Workshops (2) - Implementing conceptual spatio-temporal Schemas in object-relational DBMSs
On the Move to Meaningful Internet Systems 2006: OTM 2006 Workshops, 2006Co-Authors: Esteban Zimányi, Mohammed MinoutAbstract:Several spatio-temporal conceptual models have been proposed in the literature Some of these models have associated CASE tools assisting the user from the creation of the conceptual Schema until the generation of a Physical Schema for a target DBMS or GIS However, such CASE tools only consider the translation of information structures (i.e attributes) Since current DBMSs or GISs provide limited support for temporal and spatio-temporal information, when translating conceptual Schemas it is necessary to automatically generate the functions and procedures allowing to manipulate spatio-temporal information in the target platform In this paper we describe how to realize this generation in an object-relational DBMSs.
-
OTM Workshops - Preserving semantics when transforming conceptual spatio-temporal Schemas
On the Move to Meaningful Internet Systems 2005: OTM 2005 Workshops, 2005Co-Authors: Esteban Zimányi, Mohammed MinoutAbstract:Conceptual models provide powerful constructs for representing the semantics of real-world application domains. However, much of this semantics may be lost when translating a conceptual Schema into a logical or a Physical Schema. The reason for this semantic loss is the limited expressive power of logical and Physical models. In this paper we present a methodology that allows to transform conceptual Schemas while preserving their semantics. This is realized with the help of integrity constraints that are automatically generated at the logical and Physical levels. As a result, the semantics of an application domain is kept in the database as opposed to keeping it in the applications accessing the database. We present such a methodology using the MADS conceptual spatio-temporal model.