Transparent access to relational, autonomous and distributed databases using semantic web and service oriented technologies

With the constant grow of enterprises and the need to share information across departments and business areas becomes more critical, companies are turning to integration to provide a method for interconnecting heterogeneous, distributed and autonomous systems. Whether the sales application needs to interface with the inventory application, the procurement application connect to an auction site, it seems that any application can be made better by integrating it with other applications. Integration between applications can face several troublesome due the fact that applications may not have been designed and implemented having integration in mind. Regarding to integration issues, two tier software systems, composed by the database tier and by the “front-end” tier (interface), have shown some limitations. As a solution to overcome the two tier limitations, three tier systems were proposed in the literature. Thus, by adding a middle-tier (referred as middleware) between the database tier and the “front-end” tier (or simply referred application), three main benefits emerge. The first benefit is related with the fact that the division of software systems in three tiers enables increased integration capabilities with other systems. The second benefit is related with the fact that any modifications to the individual tiers may be carried out without necessarily affecting the other tiers and integrated systems and the third benefit, consequence of the others, is related with less maintenance tasks in software system and in all integrated systems. Concerning software development in three tiers, this dissertation focus on two emerging technologies, Semantic Web and Service Oriented Architecture, combined with middleware. These two technologies blended with middleware, which resulted in the development of Swoat framework (Service and Semantic Web Oriented ArchiTecture), lead to the following four synergic advantages: (1) allow the creation of loosely-coupled systems, decoupling the database from “front-end” tiers, therefore reducing maintenance; (2) the database schema is transparent to “front-end” tiers which are aware of the information model (or domain model) that describes what data is accessible; (3) integration with other heterogeneous systems is allowed by providing services provided by the middleware; (4) the service request by the “frontend” tier focus on ‘what’ data and not on ‘where’ and ‘how’ related issues, reducing this way the application development time by developers.

New method for determination of (E)resveratrol in wine based on microextraction using packed sorbent and ultra-performance liquid chromatography

An ultra-fast and improved analytical methodology based on microextraction by packed sorbent (MEPS) combined with ultra-performance LC (UPLC) was developed and validated for determination of (E)-resveratrol in wines. Important factors affecting the performance of MEPS such as the type of sorbent material (C2, C8, C18, SIL, and M1), number of extraction cycles, and sample volume were studied. The optimal conditions of MEPS extraction were obtained using C8 sorbent and small sample volumes (50–250mL) in one extraction cycle (extract–discard) and in a short time period (about 3 min for the entire sample preparation step). (E)-Resveratrol was eluted by 1 250mL of the mixture containing 95% methanol and 5% water, and the separation was carried out on a highstrength silica HSS T3 analytical column (100 mm 2.1 mm, 1.8mm particle size) using a binary mobile phase composed of aqueous 0.1% formic acid (eluent A) and methanol (eluent B) in the gradient elution mode (10 min of total analysis). The method was fully validated in terms of linearity, detection (LOD) and quantification (LOQ) limits, extraction yield, accuracy, and inter/intra-day precision, using a Madeira wine sample (ET) spiked with (E)-resveratrol at concentration levels ranging from 5 to 60mg/mL. Validation experiments revealed very good recovery rate of 9575.8% RSD, good linearity with r2 values 40.999 within the established concentration range, excellent repeatability (0.52%), and reproducibility (1.67%) values (expressed as RSD), thus demonstrating the robustness and accuracy of the MEPSC8/UPLC-photodiode array (PDA) method. The LOD of the method was 0.21mg/mL, whereas the LOQ was 0.68mg/mL. The validated methodology was applied to 30 commercial wines (24 red wines and six white wines) from different grape varieties, vintages, and regions. On the basis of the analytical validation, the MEPSC8/UPLC-PDA methodology shows to be an improved, sensitive, and ultra-fast approach for determination of (E)-resveratrol in wines with high resolving power within 6 min.