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...
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...
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...
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 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...
Simple Expressions and SQL Predicates - SQL conditions allow a sub-query to be used in certain expressions. For example, a sub-query can be used in the ‘in’ expression to serve as the list value. This concept is supported in the Data Modeler conditions...
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...
Joining Multiple Data Sources - To embed static data manually into an element (Table, Section or Chart), follow these steps...
List Comparison for Queries Using Hierarchical Meta Data - If you want to get a list of all employees with C++ programming skill, you can add a condition to the employee node to select only people with C++ on their skill list. However, since each employee may have multiple skills linked in the employee record, a simple string comparison does not give the correct result...
Materialized OLAP Overlays - Materializing an OLAP overlay involves the implementation of a physical data store such as a star schema in place of the OLAP overlay’s logical structure. An OLAP overlay is a low overhead OLAP option, but other data warehouse options may be more suitable under certain conditions...
OLAP Overlay Multidimensional Analysis - OLAP overlay is an optional component of the data model that provides flexible ways to dynamically group, aggregate, and display summary information. This is often called “slice-and-dice.” Unlike star schema relational databases and multi-dimensional databases, ER schema databases do not have a physical schema that readily supports OLAP functions...
OLAP Server Setup - This article provides various notes on OLAP server configuration. Microsoft SQL Server 2000, Microsoft SQL Server 2005, Oracle9i, and DB2 OLAP Server
Query Condition Expressions - The query condition expression grammar is based on the SQL conditions. Most of the expressions have a construction identical to their SQL counterparts. Like SQL, all reserved words are case-insensitive. However, all names, including variables and child nodes...
Query Traps - A Query Trap refers to a construct in a data model that can generate undesired query results. This can confuse end users or even give incorrect results...
Querying Non-relational Data Sources - While non-relational queries do not use SQL, they are able to filter and manipulate the data before returning the result set. This also provides a common access metaphor, because all queries are interchangeable...
Querying XML or Web Services Data Sources - If a path in the schema tree is selected without any query conditions, the query will simply parse the XML output and return the selected subtrees as the result. The result tree is interpreted by the report engine based on the binding of the query...
Querying CORBA or EJB Data Sources - Creating a CORBA query is very similar to creating XML queries. Since the output of a CORBA request is mapped to a tree, exactly the same as with an XML request, defining a CORBA query is almost identical to the process for XML queries...
Querying Text Data Sources - A text query defines how to convert a text file into a table. The conversion parameters include the delimiter and the headers. More importantly, these parameters contain descriptions of the columns...
Querying Java Object Data Sources - Once a data source is defined, the data source can be used to create object queries. The query building process is identical to the process for XML queries, as the output of the java objects is mapped to hierarchical meta-data...
Simple Expressions and SQL Predicates - This section lists various supported expressions. Arithmetic Expressions Numeric computations are always done using double values. The following operators are supported...
Stored Procedures vs SQL Query - Stored procedures are compiled and stored in a database. There are a few major differences between a stored procedure and a SQL query: A stored procedure is invoked as a function call instead of a SQL query. Stored procedures can have parameters for both passing values into the procedure and returning values from the call...
Structured and Free-form Queries - Queries are written for specific data access purposes and contain logic beyond the generic data model. Queries typically utilize advanced or proprietary database features. The idea is similar to relational database views, except that queries are normally not generic enough to be created as permanent database objects or views...
Viewing the SQL Query Plan of a Table - To view the SQL statements that a table will attempt to execute (the query plan), right-click the title bar, and select ‘Show Plan’ from the context menu. This opens the ‘Query Plan’ dialog box. The ‘Query Plan’ dialog box displays the queries...
More Resources:
|
+86-4006625013
商务咨询
技术支持
