telephone:Data Modeling Information
This is a table of contents of useful information about data modeling using InetSoft's business intelligence software for dashboards, reporting, and analytics, Style Intelligence:
Accessing Multidimensional Databases - The multidimensional database is another way to provide data for OLAP operations. Taking the place of tables in relational databases, multidimensional databases organize data into cubes that contain measures and dimensions...
Accessing Non-relational Data Sources - Data is stored in many different formats. Java Objects, CORBA, and EJB are present in legacy systems, Web Services and XML are the new standards for sharing information over the internet, and Excel is a popular data analysis and manipulation tool...
Accessing Web Service Data Sources - Web Services have proven increasingly efficient in sharing data among distributed applications in a hybrid language environment. The functionalities are made accessible over the web using SOAP (Simple Object Access Protocol)...
Accessing CORBA Data Sources - With its multiple language binding, CORBA is a platform for building distributed applications in a hybrid language environment. Combined with the platform independence of Java; CORBA facilitates the development of truly portable applications...
Accessing EJB Data Sources - Enterprise JavaBeans™(EJB) introduced a new way of writing server side Java applications. Using application servers supporting the EJB platform, an application can concentrate on creating business logic, and rely on the application servers’ middle tier services...
Accessing Text Data Sources - Text data sources are used to describe data in delimited text files. The text data is accessed using a URL in the same way as XML files. All delimited files are treated as a table. Each line is converted to a table row, and the delimited fields...
Accessing Java Object Data Sources - A Java Object Data Source is useful when your data cannot be accessed via common standards JDBC, SOAP, XML or if you have a pre-existing JAVA API to which you wish to connect. Creating a Java Object data source requires, at minimum, the creation of a Data Loader class...
Accessing POJO Data Sources - Data Loader based on DataLoader2 interface The DataLoader2 interface is used to extract data which has a flat tabular structure as opposed to data with an inherent hierarchy. It is the simplest way to extract tabular data, without requiring any...
Advice on Data Mashups - That's a very good point. William, what Malcolm has just been talking about is very interesting, this source data analysis stuff, I wonder, you know we had a show a couple of weeks ago on data profiling and the importance of data profiling, I wonder if mashups can be used in that whole process. Especially when you have these very large organizations that have so many data sources...
Creating a Hierarchical OLAP Overlay - Creating an OLAP overlay is straightforward. The Hierarchy tab of the logical model provides an interface to create the overlay. Entities and attributes are listed in the left pane in a tree structure...
Data Mashup - Data Mashup, at its basic definition, means combining disparate data sources that were not previously architected to be used together. In a data warehouse environment with rigid ETL process, data mashup yields other benefits, particularly in allowing prototyping of data maniupulations before committing to new, official ETL definitions and transformations...
Data Mashup and Geographic Mapping - I think you have to move beyond GIS. The thing about geographic mapping is that we’re all familiar with it. We all know what it is. There isn’t a semantic challenge to understanding it. But let's say if I was to create the data topography of the production landscape...
Data Mashups and Governance - Especially when you're trying to work with many different data sets, and there’s the security angle here and there is also a data quality or data governance angle to this as well. But if you start talking about meta data, it really is important that you manage these definitions well...
Data Mashups in an Ideal World - What do you think of this ideal world we have been discussing? You have this array of data marts and you can essentially mix and match to create your own dashboard on the fly...
Data Mashups vs. Data Warehouses - With the typical data warehouse scenario, if one thing goes wrong, the whole system comes down to its knees. There’s a huge dependence on the IT side before any other business can get done. Whereas if you flip the situation on its head and focus more on the self-service...
Data Mashups vs. OLAP Cubes - But it seems to me that ideally the beauty of a mashup environment, if it is done properly, is that you can essentially, I don’t want to say circumvent IT, but you can avoid a lot of the painstaking work required for building specific OLAP cubes...
Data Modeler - The Data Modeler included in InetSoft's business intelligence software, Style Intelligence, lays the foundation for InetSoft's patent-pending Data Block technology. The Data Modeler is used to connect to various data sources, define semantic layers, and create queries. These semantic layers (logical models) and queries are atomic data blocks...
Data Tables - Tables offer a number of special properties that allow you to access the data values from script, and to add visual style to rows, columns, and individual cells. The following sections explain how to use these properties...
Database Connection Pooling - InetSoft's query engine uses connection pooling for enhanced database performance. The default size of the pool is five connections. For enterprise level deployment, the number of connections can be increased to a more appropriate size by setting the property jdbc.connection.pool.size in sree.properties...
Defining CORBA Data Sources - When defining a CORBA data source, the Data Modeler needs to import the IDL generated classes to analyze the method parameters. This requires the IDL definition to be properly compiled, and requires that classes generated from the IDL are accessible...
Designing a Subquery - Sub-queries are queries used inside a query condition expression. The result of the sub-query is used when evaluating the expression. This functionality is only supported for hierarchical data sources like XML, SOAP, etc...
ERWin Importer - During data model creation, the designer has to manually build physical and logical views of the database schema. Creating these views can be a time-consuming and tedious task, as schemas can be large and complex. ERWin is a widely used database modeling tool with reverse engineering functionalities, used for database design...
Formula Tables - Formula tables are used to create real-time, spreadsheet-like reports with highly specific or complex layouts. These tables can be used to implement the kind of data grouping and aggregation which is commonly required in accounting and financial applications...
| Next: Logical Data Model Information |
