database

How to extract and analyze data from a machine on a production line?

During an internship in a company that produced hydraulic devices for construction machines, there was a test station on each production line that would test the characteristic of each device after its assembly. The data extracted by the station was stored in a software called Business Object that is part of the SAP package, but only a small amount of people knew how to use this database. In order to make this database usable, I created templates on the software that were usually needed. Example: A template for how to extract the number of pieces not in conformity due to a reason X per line of production. So the user only needed to enter the production lines involved, the reason X and the time period that he wanted to study and a table and graphics were automatically implemented.

Optimizing SQL Queries

In a typical university course, performing an SQL query was always a fast thing. However, when you are working on a project that grows over time, you at first might not give the performance of a query much thought. As the project grew, I had complex queries and lots of records in the database, distributed over many tables. What I didn't expect, was that from one day to another, the performance of the page went from zero complaints to constant user complaints (the page loads too slowly). As I found out way later, the bottleneck comes suddenly. It does not build up. And at that point I was stressed and had to do an overnight shift, dealing with temporarily shutting down the users and optimizing the backend queries (take a look at the JOINS, and narrow it down as much as you can). For future reference I know that I will give SQL query performance way more attention, and as the query complexity and database size grows, you should in the same step perform a check how the performance scales.

What is the most important difference between H2 and PostgreSQL

During the software implementation, it is always difficult for us to decide which one of the database should we use as the technology stack. Especially for the database. So what is the mainly difference between H2 and PostgreSQL.

how to manage unstructured data?

Require a very agile delivery system that is easily able to processes unstructured data. The system of engagement would need to be extremely dynamic.

Conversion of TechScreen from Drupal 6 to Drupal 7

A new Drupal 7 installation, module installation and database conversion

I can not set a database connection

You are unable to set your database connection.

EPM Registry Initialization Fails

The EPM Registry initialization fails in the BIDomain domain. Oracle Fusion General Ledger and Oracle Fusion Customer Relationship Management (CRM) code running within the FinancialsDomain and CRMDomain domains, respectively, has direct integration with the EPM Registry API and consumes EPM Security Component, which also tightly integrates with the EPM Registry API. When EPM Registry initialization fails, it greatly impacts communication with downstream EPM products in the BI domain.

oracle

A function shall be triggered within the database if a certain record is added to a table.

Complex Queries in CakePHP 2.x

With CakePHP, a MVC-based PHP framework, it is usually very easy to retrieve data from the database table underlying a specific model, as well as in case the tables are connected with each other through their respective model declarations, as these tables are then joined automatically. However, when one wants to join multiple tables within one query and they are not connected through their models (which occurs quite often), then there nevertheless has to be a way to join the desired tables to get the respective data. The goal is to find a way in CakePHP to accomplish this task.

Use of Database for relating user roles to menues

In our application we used the approach to create it flexible by storing the information in database, bascially it consists of 4 tables

User
UserToRole - Assigns roles to users
MenuItems
ItemToRole - Assigns roles to menuitems

MenuItems may link themselves to upper level items for creating the menu structure. It also contains the ordering of the items. If the menu is built top level items are displayed according to user roles. If the toplevel items have subelements the same check is done again. Each menuItem holds the corresponding links to the jsp pages.

Taggings:

Pages

Subscribe to database